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

I need to find an accounts receivable report that shows month end balance by client over specific time frame.

 
5 Comments 5
Rubielyn_J
QuickBooks Team

I need to find an accounts receivable report that shows month end balance by client over specific time frame.

It's a delight to have you here in the Community, @thomas34.

 

Let me provide some information and steps to generate reports in Quickbooks Online. 

 

We can pull up the Accounts Receivable Aging Detail report. This will show you the latest and aging client balances. If you're looking for a client's balance within a specific period, ensure to change the date.

 

Here's how:

  1. From the left panel, choose Reports.
  2. In the Find report by name field, search and select Accounts Receivable Aging Detail report. 
  3. Under the Report period section, select your report date. 
  4. Lastly, click Run report.

    AR report.PNG

 

There you can see the list of customers' outstanding balances.

 

Just in case you want more details, you can customize reports to focus on specific accounts or filter for specific items.

 

Moreover, you can also memorize a report to save it with its current customization settings.

 

Don't hesitate to comment down below if you have further concerns. I'll keep my notifications open for you. Stay safe and healthy.

Rubielyn_J
QuickBooks Team

I need to find an accounts receivable report that shows month end balance by client over specific time frame.

Hi, @thomas34

 

Hope you’re doing great. I wanted to see how everything is going about finding an accounts receivable report concern you had the other day. Was it resolved? Do you need any additional help or clarification? If you do, just let me know. I’d be happy to help you at any time.

 

Looking forward to your reply. Have a pleasant day ahead!

paoluccc
Level 1

I need to find an accounts receivable report that shows month end balance by client over specific time frame.

Is there a way to view accounts receivables from a time period (5/18/21-5/17/22) even if it has already been paid? How would this be accomplished to view from the aging detail report?

paoluccc
Level 1

I need to find an accounts receivable report that shows month end balance by client over specific time frame.

.

ReymondO
Moderator

I need to find an accounts receivable report that shows month end balance by client over specific time frame.

Thanks for joining the thread, @paoluccc.

 

Allow me to jump into this conversation and provide further insights about the Accounts receivable Aging report.

 

This report provides the information you need to know how much money is outstanding, and how much is due to you by your customers. Once they make a payment, this automatically reduces their balance and removes the transaction from the report. 

 

The option to view their balance from a said period once paid is unavailable. This is how QuickBooks reports transactions and the available filter is also inapplicable.

 

I can see how this option would be helpful for you and your business. Therefore, let me take note of this as a suggestion to improve your QuickBooks experience.
 

For now, I'd recommend running reports such as the Transaction List by Customer. Then, filter its report period. This way, you can review the payments made and think of them as if they haven't been paid yet. 

 

Here's how:

 

  1. Go to Reports and search for the Transaction List by Customer report.
  2. Filter its report by selecting Custom from the drop-down list.
  3. Click Run report

 

Moreover, you can customer customize reports to easily review the details that matter the most to you. 

 

If there's anything else you need, you're always welcome here in the Community to post again. We'll be always around ready to help.

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

Need to get in touch?

Contact us