cancel
Showing results for 
Search instead for 
Did you mean: 
Bkilz
Level 1

How to run a Customer Balance Detail Report in Accrual rather than Cash

I run my BS in accrual, but when I run the Customer Balance Detail report, it seems it's in Cash, (Total doesn't match BS).  Although the Customer Balance Summary is correct.  Any suggestions?

Solved
Best answer January 29, 2020

Best Answers
Jen_D
Moderator

How to run a Customer Balance Detail Report in Accrual rather than Cash

Hi there, @Bkilz,

 

I can share some insights about the accounting method used in QuickBooks reports.

 

Detail reports in QBDT always default to accrual basis when you create them from the Reports menu. If it doesn't match with the summary report, try to review if they are using the same method.

 

Summary reports can be on a cash or accrual basis. You can easily toggle the report's default basis in the Preferences. Here's how:

 

  1. Go to the Edit menu and select Preferences.
  2. Click on the Reports & Graphs menu then proceed to Company Preferences.
  3. In the Summary Reports Basis box, make sure to select Accrual to match with the Detail report.
  4. Hit OK when done.

See this article to learn more about this: Differentiate Cash and Accrual basis.

 

If it doesn't match run the Verify/Rebuild Utility. This built-in tool automatically fixes minor company file data issues which may affect the reports. Here's how:

 

  1. Go to the File menu then pick Utilities from the list.
  2. Select the Verify Data. tool then wait until the diagnosis is done.
  3. If there are issues, proceed to rebuilding the company file.
  4. Tap File menu then hover over Utilities.
  5. Pick Rebuild Data then click OK.
  6. Follow the onscreen steps to save a backup.

 

Let me know the result as I want to make sure this is resolved. It's my pleasure to assist you any time. Have wonderful week!

View solution in original post

2 Comments 2
Jen_D
Moderator

How to run a Customer Balance Detail Report in Accrual rather than Cash

Hi there, @Bkilz,

 

I can share some insights about the accounting method used in QuickBooks reports.

 

Detail reports in QBDT always default to accrual basis when you create them from the Reports menu. If it doesn't match with the summary report, try to review if they are using the same method.

 

Summary reports can be on a cash or accrual basis. You can easily toggle the report's default basis in the Preferences. Here's how:

 

  1. Go to the Edit menu and select Preferences.
  2. Click on the Reports & Graphs menu then proceed to Company Preferences.
  3. In the Summary Reports Basis box, make sure to select Accrual to match with the Detail report.
  4. Hit OK when done.

See this article to learn more about this: Differentiate Cash and Accrual basis.

 

If it doesn't match run the Verify/Rebuild Utility. This built-in tool automatically fixes minor company file data issues which may affect the reports. Here's how:

 

  1. Go to the File menu then pick Utilities from the list.
  2. Select the Verify Data. tool then wait until the diagnosis is done.
  3. If there are issues, proceed to rebuilding the company file.
  4. Tap File menu then hover over Utilities.
  5. Pick Rebuild Data then click OK.
  6. Follow the onscreen steps to save a backup.

 

Let me know the result as I want to make sure this is resolved. It's my pleasure to assist you any time. Have wonderful week!

View solution in original post

Bkilz
Level 1

How to run a Customer Balance Detail Report in Accrual rather than Cash

Perfect...thanks.

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us