Skip to main content
February 9, 2022
Question

2 Years of CSV Entered, now to reconcile.

  • February 9, 2022
  • 1 reply
  • 0 views

We use Quickbooks online.  The owner uploaded all of the CSV files from 2019 and 2020, now I need to reconcile for January 2022.  Unfortunately, the difference is quite off and I am not entirely sure how to reconcile besides marking off transactions to get it to a $0.00 difference.  Can some please help or point me in the right direction. 

 

1 reply

February 9, 2022

Let me assist reconcile your prior entries imported in QuickBooks, @AAVSBusiness.

 

Your bank statement is needed when reconciling your accounts. This will help you point out the transactions smoother to match it with QuickBooks entries.

 

After importing entries, this will live in the For review tab. You can consider adding those entries if you find no transactions to match or match them with the transactions in QuickBooks.

 

Here's how:

  1. Go to the Transactions/Banking menu.
  2. Select Banking.
  3. Click the tile for the account you want to review.
  4. Go to the For review tab.
  5. Recognize if you need to add or match the transaction.

 

The items you'll add or match with existing transactions in QuickBooks will remain in the Categorized tab. This implies that transactions are now recorded in the bank register.

 

To check this, you can go to the Accounting menu and then select Chart of accounts. Locate the bank account and click View register from the Action column.

 

For a detailed guide, here's how to reconcile transactions that are older than your opening balance in QuickBooks Online.

 

Additionally, you can read through this article for your future reference: How to Unreconcile a Transaction or Undo a Reconciliation. I also recommend consulting an accountant's advice to keep your books accurate.

 

If you have any other concerns about reconciling old transactions, feel free to leave a comment below. Have a great day!