cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want an expert to help you set up your QuickBooks Online? Find out how: Click here
staffer2324
Level 1

Balance per Transaction Report doesn't match Trial Balance

Hi, I'm working on a file with an out-of-balance trial balance. After checking the transactions per year, month, week, and days, I finally found the account causing the misbalance. I checked the account balance per transaction report (see first photo) and it doesn't match the amount per trial balance (see last photo). How do I fix this?

3 Comments 3
Maybelle_S
QuickBooks Team

Balance per Transaction Report doesn't match Trial Balance

Hello there, staffer.

 

I understand how frustrating and time-consuming it can be to encounter such discrepancies in financial reports.

 

In QuickBooks Online (QBO), an unbalanced trial balance indicates incorrectly entered transactions. To fix this, let's run the Balance Sheet report on an Accrual basis.

 

Here's how:

 

  1. Go to the Reports menu.
  2. Enter Balance Sheet in the search bar.
  3. Click the Report period drop-down arrow, then choose All Dates.
  4. Check the date on the report when your trial balance went out of balance.
  5. Review all transactions from that day and verify or correct them as needed.

 

Once done, you can reconcile your account. Then, review the reconciliation report to ensure your books are accurate.

 

Please update us if you need additional assistance in fixing the trial balance. We're always here to help. Take care.

staffer2324
Level 1

Balance per Transaction Report doesn't match Trial Balance

Can you help me remove the "ghost" entry to fix this error please? The entry causing the unbalanced TB only appears in the TB and not in the GL.

Amanda-B
QuickBooks Team

Balance per Transaction Report doesn't match Trial Balance

Welcome back, staffer2324.

 

I'd be happy to help you remove the incorrect entry. Here are a few simple steps you can follow:

 

  1. Navigate to Transactions and select Chart of accounts (Take me there).
  2. Locate the account you'd like to edit.
  3. Select Account history.
  4. Select the transaction you'd like to edit.
  5. From here you can make changes to all available fields and select either Delete, Edit, Cancel, or Save.

Here's an article for reference. 

 

I hope this helps! Let me know if you have any other questions.