- Last Updated on:   March 28th, 2019
- Posted by: QB
- Category: QuickBooks Payroll
In many previous posts, we have already discussed the QuickBooks Bank Reconciliation and what is it’s necessity?? With the help of this technical and informative article, we are going to let you know about the procedure to set up Bank Reconciliation in the QuickBooks software.
Before we start this discussion, it is really very important to understand the reports in the accounting process. As we are familiar with the fact that before applying anything you should have some knowledge about it. Here, through this article we will endow you the general idea of reports generation after online QuickBooks bank reconciliation that will assist you to understand it in a better manner. However, If you are thinking about to hire a certified bookkeeper or ProAdvisor, you can hassle free connect with our QuickBooks customer support team at 1(800) 880-6389.
How to Reconcile Your Accounts in QuickBooks?
Don’t be anxious with the term Reconciling & why it is necessary? Reconciling is a process that tends you to a comfort zone where you can handle the bank account effortlessly & in an appropriate way with no perplexity. After reconciling the bank / credit card account you can simply compare the beginning balance & all the transactions listed within the QuickBooks company file. Later, you will be able to contrast monthly reports/statements that have been created by a bank or credit card company. At this point in time, you can ensure that it matches & also saves precious time.
Watch this video to understand easily the process for Reconcile Your Accounts with in QuickBooks Desktop US version.
What is the Need of QuickBooks Online Bank Reconciliation?
It is a systematic way of comparing the entered data by you in the QuickBooks with the physical data that clears the account. If in case, you forgot to enter any data entry into QB software this can lead to great data damage in the whole accounting system.
Hence, it is very essential for us to identify the missing entry. This is the main reason why a lot of small business owners utilize the running bank account balance feature in the QB software that investigates every missing data entry.
Reconciliation is enormously recommended to be done on a regular basis. As a result all the discrepancies among the record & bank record can be fixed.
There possibly a query that might pop-up in your mind that is – how can I reconcile into the QuickBooks online? Don’t you worry about it..! You swiftly reconcile the accounts in the QuickBooks Online. After the bank account reconciliation, your account starts giving most of the details associated with the transactions. You attach the oldest bank reports/statement that hasn’t reconciled & you will contrast the monthly bank statement with the registered transactions within QB software and that difference among them supposed to be ZERO! Now reconcile procedure is done.
You should match each of the deposits in the bank report to those important to the bank statement. If you have planned a deposit that the bank had not yet collected along with an activity the month, list this deposit as reconciling detail/information that supposed to be added to the bank’s ending cash balance for the account.
6 Easy Ways to Set-up QuickBooks Bank Reconciliation Online
Below are the 6 ways to set-up the QuickBooks online bank reconciliation:
Step 1: Go to the Reconciliation Menu:
- First, you should select the “Reconcile” tab from the home page. Later, tap on the “Gear” icon which is at the left-side of the company name & then, hit onto the column heading Tools & choose the “Reconciliation” icon.
Step 2: Choose the Bank/Credit Card Account
- In the drop-down list, select the bank/credit card account which you wish to reconcile.
- After choosing the account, click on the “Reconcile Now” tab.
Step 3: Enter the Statement Details
- Verify the copy of bank report/statement of the account you are willing to reconcile with QuickBooks software.
- Make a note of the statement End date & the Ending Balance amount.
- Go back to the QuickBooks Online, hit onto the Reconcile overlay. In the “Calendar” drop-down mention the Statement End Date.
- Go to the Reconcile overlay, type-in the statement with Ending Balance and later, hit onto the “OK” tab when the whole process is done.
Step 4: Begin Match Expenses
- Verify the bank account Transaction history for the statement & see the financial transactions.
- Open the “Reconcile window”, then match each and every financial transaction from the bank report/statement with items in the list, you obviously match the entire transactions & checking the box to the right of each transaction to match.
Statement Ending Balance
- It shows you the amount which you have entered in your bank/credit card statement.
- This is the ending balance from last month’s statement.
- When you commence reconciling each and every item, this amount will change depending upon whether you have chosen a payment or a deposit transaction.
- Payments will rise when you choose the payments to reconcile from the detailed transaction section given below.
- When you choose deposits to reconcile from the detailed transaction below this transaction will amplify.
QuickBooks Online estimate the variation. It demonstrates the result among your statement balance & the cleared balance, the difference is zero is a good result for you.
We share an instance with you for the better insight, while spending money with QuickBooks Online so you confirm overall withdrawals or payments on the bank statement ($2548.25) match the total withdrawals we have cleared in QuickBooks ($2548.25). If it happened, you can move onto the next step.
Sample Bank statements (For Example)
|Beginning Balance on 1/1||$150.56|
|Withdrawal Debits||– 2548.25|
|Ending balance on 1/31||$1760.55|
Step 5: Finish Reconciliation
- If you achieve the ideal difference value at the bottom – zero. Now, hit onto the “Finish now” icon to create the bank reconciliation reports. Thus, the QuickBooks online bank reconciliation process will be completed.
Step 6: Examine the Reconciliation Report:
- Now see thoroughly the Reconciliation Reports, navigate back to the “reconcile” section where you will notice the reconciliation entered by you, and hit onto it to open the detail window for checking purpose.
- Then, hit onto the “Run Report” tab to open detailed information about the reconciliation.
- In the accounting process, the report plays a significant role in decision making. Reporting assists us to examine the data we have entered in reconciliation. It also guides us to keep the transactions record that can be requisite in the future.
- If you would like to print the QuickBooks Online bank reconciliation reports, you can press click on the report window & print the reconciliation report.
Important: You can create a folder which names Bank/credit card account also that can save all bank reconciliation reports in it.
Other Method to Get the Detailed Report
Checkout the steps are given below:-
- Search the reconciliation report, hit onto the “Gear” icon.
- Choose the “Reconcile” tab, from the drop-down menu,
- From the upper right corner of the window, select the “Reconcile History” icon.
- From the account drop-down, choose the “Account” icon.
- Click on the “View report” under the “Action” tab to open the report.
- Finally, to print the report click on the “Print” tab in the upper right corner of the report.
Hopefully, this article would be beneficial for you to properly understand the QuickBooks Online Bank Reconciliation. However, if still some doubts remains in your mind – you can clarify those with the help of QuickBooks payroll phone number +1-800-880-6389.