Skip to main content
H
Hull Girl
June 14, 2021
Question

How to re-reconcile years of transactions?

  • June 14, 2021
  • 1 reply
  • 0 views

I had to transfer our QBO to a new QBO account. All the bank transactions transferred but none of the reconciliations did. So now I have years of unreconciled transactions and a starting balance of zero. How cam I re-reconcile years of transactions, and set a new starting balance? Thank you!

 

1 reply

C
Catherine_B
June 14, 2021

I can help you reconcile you transactions, Hull Girl.

 

When starting fresh with QuickBooks, we'll have to enter the bank's balance and reconcile the transactions again to accurately manage your books. You'll need your bank statement to make sure they match your bank and credit card statements. Also, I can help you run reconciliation reports as your basis on what transactions you reconciled within the given period. 

 

Here's how: 

 

  1. Log in to your old QuickBooks Online account.
  2. Click Reports from the let menu.
  3. From the search field, enter and select Reconciliation Reports.
  4. Select the account and report period.
  5. Click on the year and then click View report under the ACTION column.

If you want to simultaneously work with your QBO account, I recommend opening the other account through a regular browser and the other through a private (incognito) or different browser. This way, you won't get kicked out of the system. 

 

Feel free to use these links to help you reconcile and manage your bank accounts.

 

I'm just around the corner to keep an eye on your reply if you have other questions. Take care!

H
Hull GirlAuthor
June 15, 2021

Thanks for your reply (and the tip about using an incognito window!). How do I change the opening balance on the new account to be the closing balance from the old account? On the new account, all the transactions (years worth) came in, but they are all marked C. How can I make all of them R (except the ones that came in after the transfer)?

 

Thanks!

 

R
ReymondO
June 15, 2021

Thanks for getting back to us, @Hull Girl.

 

Let me take it from here and help you in reconciling your account in QuickBooks Online. 

 

You can edit the opening balance of your new accounts by editing its amount through the View register. Here's how:
 

  1. Go to Settings ⚙️ and select Chart of Accounts.
  2. Locate the account, then go to the Action column and select View register.
  3. Find the opening balance entry and click it to open.
  4. Edit the amount. Tip: If you're not able to edit the amount directly on this screen, in some cases you can edit by selecting the Edit ✎ icon.
  5. Select Save. 

 

In addition, transactions that were marked as C in your register are considered as cleared. If you wish to change their status, simply follow these steps:

 

  1. Go to the Accounting tab on the left panel.
  2. Under Your Company, select Chart of Accounts.
  3. Choose the account you’re working on, and click on View Register.
  4. Select the transactions you want to unreconcile.
  5. Keep on clicking the R status until it shows blank or cleared (C).
  6. Click on Save.
  7. Choose Yes in the confirmation window.

 

I also added a link to give more insights about unreconciling transactions. I recommend consulting with your accountant before performing any of the steps. This is to ensure your records are in order.

 

Reach out to me directly if you have additional questions about working in QBO. I'm here to answer them for you. Have a good one.

 

Terms & ConditionsAccessibility statement