Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.

Reply to message

View discussion in a popup

Replying to:
GlinetteC
Moderator

Reply to message

I've got other steps to fix your Cash Balance Sheet issues, KM402.

 

You'll have to run reports one at a time to narrow down the transactions causing your balance sheet to go out of balance. Once you find them, you'll need to re-date them to 20 years in the future. And if the issue continues, you can try deleting and re-entering them into the system.

 

Run a Customer Report:

 

  1. Go to the Reports menu, select Custom Reports, then Transaction Detail.
  2. The Modify Report window opens automatically. If it doesn't, choose the Customize Report and go to the Display tab.
  3. On the Display tab:
    1. Set the Report Basis to Accrual.
    2. Set the From and To fields to the day the Balance Sheet goes out of balance.
    3. Set Total by to Customer.
  4. Go to the Filter tab, then:
    1. On the Filters list, select Transaction Type.
    2. From the Transaction Type drop-down, select Multiple Transactions, then mark InvoiceCredit Memo, and Payment.
    3. Select OK.
  • If the total is the amount by which the Balance Sheet went out of balance on this date: Find the customer who has a non-zero (positive or negative) sub-total. This customer has damaged transactions.
  • If the total is non-zero (positive or negative) and not the amount by which the Balance Sheet went out of balance on this date: Add other transactions to the Transaction Type filter such as Journal Entries and Checks.

 

Run a Vendor report:

 

  1. Go to the Reports menu, select Custom Reports, then Transaction Detail.
  2. The Modify Report window opens automatically. If it doesn't, select Customize Report and go to the Display tab.
  3. On the Display tab:
    1. Set the Report Basis to Accrual.
    2. Set the From and To fields to the day the Balance Sheet goes out of balance.
    3. Set Total by to Customer.
  4. Go to the Filter tab, then:
    1. On the Filters list, select Transaction Type.
    2. From the Transaction Type drop-down, select Multiple Transactions, then mark BillBill Credit, and Bill Payment.
    3. Select OK.
  • If the total is the amount by which the Balance Sheet went out of balance on this date: Find the vendor who has a non-zero (positive or negative) sub-total. This vendor has damaged transactions.
  • If the total is non-zero (positive or negative) and not the amount by which the balance sheet went out of balance on this date: Add other transactions to the Transaction Type filter such as Journal Entries.

 

For more details, I recommend following the steps in this article to resolve the balance: Advanced Troubleshooting for Balance Sheet out of balance.

 

In addition, I've added these links that'll help you personalize and memorize your financial reports. This way, you can easily access them in the future:

 

Keep me posted if you need more help managing reports in QuickBooks. I'll be around to help.

Need to get in touch?

Contact us