We build. You grow.

Get best community software here

Start a social network, a fan-site, an education project with oxwall - free opensource community software

How to reconcile bank statements in QuickBooks Online | Forum

Topic location: Forum home » Support » General Questions
Sprink Davis
Sprink Davis Dec 15 '23

Account management involves keeping statements in sync with your QuickBooks company file. It makes sure that your bank as well as credit card account statements and the entries in QuickBooks match.


For any organization, having up-to-date accurate accounts is crucial. You should strive to accomplish reconciliation on a frequent basis. There are methods for accelerating or even automating the process with QuickBooks. These days, reconciliation doesn't necessarily have to be done manually. In this segment, we have discussed How to reconcile in QuickBooks Online: Step-by-Step. Thus, keep reading on!

Steps to Reconcile your Accounts in QuickBooks Online

Here's a general guide on how to reconcile your accounts in QuickBooks Online:

Step1: Gather your monthly bank or credit card statements, whether online or paper

·         Make sure the opening balance in QuickBooks matches your bank account balance for the period being reconciled.

·         Check if all transactionsare matched with previously entered ones or categorized and added if they haven't been entered yet.

·         QuickBooks will try to avoid duplicates by matching downloaded transactions with previously entered transactions. You need to approve the match if this happens.

 

Step 2: Begin reconciliation in QuickBooks

Open QuickBooks and select the account you want to reconcile from the Account menu.

·         Make sure the Beginning balance in QuickBooks matches the balance on your account statement.

·         Set the Ending balance and Ending date to match those shown on your statement (some banks or providers might refer to this as the Closing balance).

·         Click on "Start reconciling" to proceed with reconciling each transaction in that account.

Winding Up!

Now this blog has come to an end. If you have any issues related to how to reconcile your accounts in QuickBooks, you can contact us at 1-800-615-2347. Our QuickBooks online error supportteam will be happier to assist you!

READ MORE

Peter Groft
Peter Groft Dec 15 '23

Step 1: Access Reconciliation Section

Login to QuickBooks Online:

Log in to your QuickBooks Online account.

Navigate to the Reconciliation Section:

From the left navigation menu, click on the "Accounting" or "Transactions" tab.

Select "Reconcile":

Under the "Tools" or "Action" menu, select "Reconcile."


Step 2: Choose the Account to Reconcile

Choose the Bank Account:

From the drop-down menu, select the bank account you want to reconcile.

Enter the Statement Date:

Enter the ending date from your bank statement.

Enter the Ending Balance:

Input the ending balance from your bank statement.

Click "Start Reconciling":

Click the "Start Reconciling" button.


Step 3: Match Transactions

Review Transactions:

QuickBooks will display a list of transactions. Match each transaction in QuickBooks to the corresponding transaction on your bank statement.

Mark Transactions as Cleared:

As you match transactions, mark them as cleared by checking the box in the "Clr" column.

Address Discrepancies:

If there are discrepancies, investigate and make corrections as needed.


Step 4: Complete Reconciliation

Verify the Difference:

Ideally, there should be no difference between the "Ending Balance" and the "Difference" shown on the reconciliation screen.

Finish Reconciling:

Once all transactions are matched and the difference is zero, click "Finish Now" or "Finish Later" if you need to come back and finish later.


Step 5: Review Reconciliation Reports

Review Reconciliation Report:

After completing the reconciliation, you can review the reconciliation report. This report summarizes the reconciled transactions.

Save or Print the Report:

Save or print the reconciliation report for your records.


Greetings,
Peter

The Forum post is edited by Peter Groft Dec 15 '23