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.
Pene
Level 1

How do I find an AR discrepancy for last year

Hi,

 

My new job has an AR discrepancy from Year End 2022 on the balance sheet.  How do I find what transactions caused the discrepancy or is there a way to get a daily AR report?  At 2022 year end the AR was 325,382.  When the balance sheet was done for 2023, AR was 344,446.50.  I was not at the job at that time and they did not close their books

Thank you!

 

2 Comments 2
MAnneJ
QuickBooks Team

How do I find an AR discrepancy for last year

Let me provide details on running the A/R report, Pene. 

 

We have two reports that we can utilize to find the transaction that caused the discrepancies or get the daily A/R report, either run the A/R Aging Summary Report or the A/R Aging Detail Report. 

 

Here's how: 

 

  1. Go to Report, then search for Accounts Receivable Aging Detail. 
  2. Click Customize.
  3. Filter the necessary information of your preference. 

 

Same goes with A/R Aging Summary Report, you'll just need to enter the report name and customize to your preference. This way, you'll achieve the report you're looking for. 

 

Furthermore, you can check this article to learn how to fix the balance on a cash-based balance sheet: Resolve accounts receivable or accounts payable balances on a cash basis balance sheet in QuickBooks...

 

Additionally, I've added this article if you need to get started memorizing reports and save its customization: Memorize reports in QuickBooks Online.

 

I'll be in the comment section if you need additional assistance running reports in QuickBooks Online. I'm here to assist you. Keep safe. 

Rainflurry
Level 15

How do I find an AR discrepancy for last year

@Pene 

 

"At 2022 year end the AR was 325,382. When the balance sheet was done for 2023, AR was 344,446.50."

 

Your question references A/R balances at "2022 year-end" and "2023".  Can you clarify that?  Are you saying that you have two different A/R balances as of 12-31-22?  What two sources conflict?  

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us