Accounts receivable wrong on balance sheet summary

Thank you for providing details, @DonnaBuell.

I can help you verify why the A/R amount on the Balance Sheet Detail report is different on the Balance Sheet Standard and Balance Sheet Summary reports.

• Make sure that all the reports have the same accounting method (Cash or Accrual).
• Verify the date period.

If still the reports are showing different A/R account values, we have to run the Data Repair tool. Verify Data self-identifies the most commonly known data issues within a company file while Rebuild Data self-resolves most data integrity issues that the Verify Data finds.

For the detailed instruction, please refer to this article: Resolve data damage on your company file. There are also other recommended steps you can perform.

Let me know the results, DonnaBuell. I'm still here to help you further about reports. Just add a comment or mention my name. Wishing you all the best!

It sounds like some reports are accrual basis while others are cash basis. Are you consistently using one or the other across the different reports?

Thanks for the help!  The problem was that one report was on "cash" and the other on "accrual".  Once I changed all reports to "accrual" then my problem was solved.

Let me give you some information on why the accounting methods you've selected affects greatly your Accounts receivable. Stacie5.

Accounts Receivable (AR) will show the proceeds or payment which the company will receive from its customers who have purchased its goods & services on credit. This is treated as current assets on the balance sheet. You'll want to run a report on both cash and accrual separately to track sales and expenses that are made on a cash basis or credit. 

In addition, with AR the sales are realized when the invoice is generated whether it has been paid or not. The same thing, once you run a report on the accrual method. That's the main reason why the report shows the correct figures in the accrual method.

Also, an accrual-basis report shows income regardless of whether your customers have paid your invoices and expenses regardless of whether you have paid all your bills. Whereas, cash basis report only shows income if you have received cash and expenses if you have paid cash.

You may want to check this article to resolve AR and AP balances on the cash basis Balance Sheet. 

If there's anything else that you want us to help with, let us know so we can check that and assist you.

Hi, I have the same issue.  AR is 4000 and correct while Balance Sheet shows AR value of -36,967.03.  Basis is Cash, AR aligns with open invoicing through 2012 when file created.  Rebuilt data, etc. so have run out of ideas.  Any thoughts on why a 4000 balance in the AR ledger shows up as -37K on the Balance Sheet?  Thank you, Michael