Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks. Explore QuickBooks Payroll
jodi35
Level 1

My balance is off. I checked my statement. All is matching, but deposits are higher/claim more than I can see. However, the deposits and payments shown add up correctly.

Reconciling and checked all against the bank feed as well. All match! Former CFO did journal entries with no explanations but none match these figures.

2 Comments 2
FishingForAnswers
Level 10

My balance is off. I checked my statement. All is matching, but deposits are higher/claim more than I can see. However, the deposits and payments shown add up correctly.

@jodi35  Unfortunately, there is something you've missed that isn't matching.

 

No matter how you go about reconciling, it comes down to a beginning balance less expenses plus deposits equals the ending balance.

 

So, either the beginning balance is off, the total expenses are off, the total deposits are off, or the ending balance is off. It can't help but be one of those things, no matter what the specific error is.

 

One easy thing to check is the amount of the error. A neat little math trick is, if you find that the total amount off is divisible by 9, you probably have a reversed pair of digits in at least one transaction.

 

For instance, if you started with 100, added 81 by mistake instead of 18 and ended up with 118, you'd have a difference of 63 (181 - 118), which is divisible by 9.

 

This kind of thing is both easy to overlook, and an easy mistake to make.

 

I suggest reviewing the numbers more carefully.

Dandie_A
QuickBooks Team

My balance is off. I checked my statement. All is matching, but deposits are higher/claim more than I can see. However, the deposits and payments shown add up correctly.

Thank you for providing detailed information about the balance discrepancy you're experiencing, Jody.

 

I understand how confusing it can be when your reconciliations and bank statements match, but deposits still appear higher than expected.

 

Based on what you have shared, journal entries created by your former CFO could potentially affect your deposit figures. However, we will need to investigate further to understand their exact impact.

 

First, let's review the Journal Report to check for any manual adjustments to deposit accounts or income.

 

Here's how you can do that:

 

  1. Navigate to Reports from the left-hand menu in QuickBooks Online.
  2. Use the search bar to find the Journal Report and select it.
  3. Adjust the Date Range to cover the time period of the discrepancy (e.g., last quarter or the period of concern).
  4. Look for any journal entries affecting deposit-related accounts, such as Checking or Income. Pay attention to adjustments to Debits, Credits, and their descriptions.
  5. Compare these entries to your bank statement or other records to identify any inconsistencies.

 

While reviewing these journal entries can offer valuable insights, I recommend reaching out to an Accountant before making any changes to your records or adjusting anything.

 

If you don't have an accountant, you can find a certified QuickBooks ProAdvisor here: Find an accountant.

 

Feel free to comment below if you need more assistance or have any questions.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us