Balance Sheet Balance Detail - Total by Customer

Hello, gtnorton.

I'd like to work with you and find out what's causing the balance discrepancy on the Balance Sheet report and on the Transaction Detail data. 

The accounting method is likely causing the Balance Sheet or the Transaction Detail report to show different balances. 

The Cash or Accrual accounting methods can affect how balances and transactions show up on your report.

In any case, let's toggle between Accrual and Cash basis on the Report basis section on the Balance Sheet (or other reports).

If you'd like to know more about the Accrual and Cash basis, check out this article for more details: Differentiate Cash and Accrual basis. 

Another thing to look out for is the Report period. The report and the transaction detail view may have been set under different report periods. Make sure the Dates are identical for the reports. 

We can also read this article to know the reasons and the solutions to fix the balances on the Balance Sheet report: Fix a Balance Sheet that's out of balance.

After finding out the cause of the balance discrepancies, do you also need help managing your bank records and ensure they agree with your entries in QuickBooks?

We can utilize the Bank Feeds feature to do this. Check out this link if you need help setting it up: Set up bank accounts for Bank Feeds in QuickBooks Desktop. 

I'll be around if you have more questions about managing your customer balances or reports. Just reply here and I'll get back to you as soon as possible. 

Bothe of these are set to "Accrual" but they don't tie when totaled by customer. 

@gtnorton 

It's most likely due to one of two things:

1) Not all entries that post to a specific account ledger require a customer name.  If there are entries that do not have a customer name entered, they will be disregarded when you run a transaction report by customer.

2) The balance sheet date represents the balance of all entries posted to each account ledger since the inception of the business in QB.  If you run a report, make sure the date range is set to match.  For example, if you're running a balance sheet report as of May 31, 2022, make sure that your report is dated from the beginning of the business to May 31, 2022.  This will match the balance sheet date range.

I am having the same issue on a report that I have used for more than 10 years!  I works in QB 2020 or below but something changed with QB 2021.  I have a work in progress GL Account and a construction draw account. Single accounts that all construction WIP & Draws are booked to.  All types of transactions (bills, checks CC, JE ect) are booked here and every transaction, individual or a multi entry transaction (CC with more than one Customer costs) has a customer assigned to each line.  When I filter for all dates and total by customer it does not work any more.  I know this because I have Customers that closed out years ago and now their accounts balances are no longer zero.  I just closed out a construction job yesterday and it is no longer zero.  What did QB Do here??  Thanks

I appreciate for using QuickBooks Desktop as your accounting partner for ten years, Jodie. Let's work together and fix the issue.

Since you've upgraded QuickBooks, please ensure that the correct company file is restored. 

If the same result, let's run the QuickBooks Desktop Toolhub to resolve common issues. 

1. Close QuickBooks.
2. We recommend downloading the latest version (1.6.0.3) of the QuickBooks Tool Hub. Save the file somewhere you can easily find it (like your Downloads folder or Windows desktop). 
3. Note: If you've already installed Tool Hub before, you can find out which version you have.
   1. Select the Home tab. 
   2. Select About/What's New to view the version.
4. Open the file you downloaded (QuickBooksToolHub.exe).
5. Follow the on-screen steps to install and agree to the terms and conditions.
6. Double-click the icon on your Windows desktop to open the tool when the installation finishes hub.

For the complete process, check this article: Fix common problems and errors with the QuickBooks Desktop Tool Hub.

I'm also sharing this article to add details to your report that matter most to you: Customize reports in QuickBooks Desktop.

Never hesitate to add a comment below if you need more help. Take care!