Skip to main content
March 12, 2024
Question

My past reconciliations must have gotten off with an update because my beginning balance is all messed up. Looks like my deposits aren't coming through...any ideas?

  • March 12, 2024
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

March 12, 2024

Hi Voyage,

 

Welcome to the Community. I am here to help you fix the beginning balance in QuickBooks Online.

 

The opening balance is the starting point for accounts in QuickBooks. If it is incorrect, it can affect all future reconciliations. Therefore, it is important to ensure that your opening balance is correct before checking your beginning balance.

 

Beginning balance issues may arise due to the following reasons:

 

  • Someone entered an incorrect opening balance while creating the account in QuickBooks.
  • Someone added transactions that occurred before the opening balance but didn't edit the original opening balance entry to reflect the change.
  • Someone edited, deleted, moved, or unreconciled an already reconciled transaction. Doing so changes the ending balance of your last reconciliation, which impacts the beginning balance of the next one.
  • Someone manually reconciled a transaction that didn't appear on the next reconciliation.

 

We have compiled some steps that you can follow to fix your beginning balance and get back on track with the reconciliation. Please refer to this link: Fix issues for accounts you've reconciled in the past in QuickBooks Online.

 

When you reconcile, you compare transactions in QuickBooks with the same ones on your bank statements. If QuickBooks doesn't match your bank statement at the end of a reconciliation, you can refer to this article: Fix issues at the end of a reconciliation in QuickBooks Online.

 

Feel free to post or interact about your QuickBooks concerns in this space. If you have any additional questions related to your reconciliation, let us know. We'll be here to lend a hand.

March 12, 2024

I had reconciled everything through last year February but when I jumped back in to reconcile the remaining months and get things ready for taxes here, the starting balance was way off (didn't match any starting balances for any statements from the past five + years) and it hadn't transferred any deposits over from my bank, just expenses. This also happened with our other business with whatever update Quickbooks did this year. Used to be able to change the starting balance as well but can't do that anymore either.

 

March 12, 2024

I understand it can be frustrating to find discrepancies in the starting balance while reconciling your account, Voyage. As such, I want to assist you in resolving this issue to ensure the accuracy of your financial records and a smooth reconciliation process.

 

To begin, may I ask what specific update in QuickBooks you are referring to? This information will help me provide you with the most accurate solution to fix the issue at hand.

 

In QuickBooks Online, the starting or opening balance is a crucial part of the reconciliation process, which has an impact on future reconciliations. If your balance amount doesn't match your bank statement, you can easily change it by going to the Chart of Accounts. However, please note that modifying it will affect your past reconciled transactions and the balance the next time you reconcile. Here's a step-by-step guide on how to change it:

 

  1. Go to Transactions, then select Chart of Accounts.
  2. Locate the bank account you've linked, then click View Register.
  3. Select the Opening balance equity entry, then edit the amount in the Deposit column.
  4. Once done, click Save.

 

Moreover, since you mentioned that your bank transactions only pulled up your expenses, you may need to manually import your missing bank transactions, particularly the deposits in the program. To do this, you'll need to download all your bank transactions in a CSV file from your bank's website, following the CSV formatting required by QuickBooks. After downloading, you can follow these steps to import them:

 

  1. Go to Transactions, then select Bank Transactions.
  2. Select the blue tile for the account you want to upload the transactions into.
  3. Select the Link account dropdown, then select Upload from the file.
  4. Choose Drag and Drop or select files, and select the file you downloaded from your bank, then, select Continue.
  5. In the QuickBooks account dropdown, select the account you want to upload the transactions into, then select Continue.
  6. Follow the onscreen steps to match the columns on the file with the correct fields in QuickBooks, then select Continue.
  7. Select the transactions you like to import. Then select Continue.
  8. Select Yes, then Done.

 

Once the import process is complete, you can match and categorize your downloaded transactions and continue reconciling your accounts.

 

Lastly, here's a reconciliation workflow that you may find helpful for future reference if you want to fix other issues within the process.

 

Also, QBO automatically creates a reconciliation report every time you finish reconciling.

 

I'm still around to help you if you need assistance regarding your starting balance. You can click the reply button below to enter your queries.