Looking for DETAIL of current Accounts Receivable Aging Report that shows INVOICE billed and date, along with ALL subsequent payments and dates of those payments. The Customer Balance Detail shows all Customers, even those that are paid in full.
Hello there, @DonnaCush.
You'll want to run the Transaction List by Customer report and customized it from there. It will show the dates of your invoice payments in QuickBooks Desktop.
Also, if you'll want to see the related payments of your invoices. You'll have to click the invoice in th right side click the Transaction button to see the related transactions.
To learn more about running reports in QBDT, you may check this article: Understand reports.
If there’s anything else I can help you with, please post a comment below. I’ll be happy to assist you further. Have a good one.
Thank you for your prompt response. I'm not sure what you mean by "Identify the invoice and specific payments." I don't see that anywhere on the Customize button.
I'm looking to see ONLY the outstanding Accounts Receivable balances with all the transactions listed: a listing of all the invoices and payments for each Customer.
I appreciate the details a lot, @DonnaCush.
You can pull up the A/R Aging Detail report. This report will show you the latest and aging customer balances. If you're looking for a customer's balance within a specific period, make sure to change the date.
There you can see the list of customers' outstanding balances.
Just in case you wanted to customize any report that you can generate, you can refer to this article: Customize reports in QuickBooks Desktop.
Please let me know or tag me (@Jovychris_A) if you need further assistance. I'll keep my notifications open. Stay safe and healthy!
Where can I see something like this with Quickbooks Online? We used to get the invoices, payments, balances and aging all together on one report. What's happened to this? Is there no way to combine these without producing 3 different reports?
Good afternoon, @larrylbr.
Thanks for chiming in on this thread. Allow me to share some light on this subject about reports in your QuickBooks Online (QBO) account.
All you need to do is run the A/R Aging Detail Report to produce and see all 3 different transactions/balances. It's a simple process. Here's how:
If you need to customize the list to your liking, just hit the Customize button at the top of the report.
This should do the trick. If you have any other questions, don't hesitate to ask. Have a good one!
We use QB Desktop and none of the standard A/R reports are satisfying our needs and really I need a combination of the Detail and Aging summary. I am looking for the Current, 30, 60 90, >90 at as the column headers in addition to Invoice Date and Invoice#, grouped by Customer and Job Name. Is there a report out there that provides this because I can't seem to find it and don't know if I can create one.
Thanks for the help!
As of now, the option to modify a report that will show the net terms and the Current is unavailable. However, you can export the detail and aging reports to an Excel report. From there, you can combine the two reports in one file. Here's how:
You can set your report preferences to change the file type that QuickBooks exports.
I'm just a post-away if there's anything that I can help. Keep safe!
Thanks for your reply. We know how to export a report but this does not answer the question in much detail and what you are saying looks like a lot of work because we need to provide this monthly to a bank. Can you provide more details how to do what I asked? Very surprised QB does not include such a basic A/R report?? All we need is more detail than the standard A/R report they provide.
Name Current 1-30 31-60
Invoice # Date $60,000
Invoice # Date $75,000
Total $60,000 $75,000
Invoice # Date $100,000
Grand Totals $60,000 $75,000 $100,000
I am looking for the same sort of report today! I need a combination of the detail and summary as well -- we are wanting to show the customer's purchase order number on the report. The PO number does show on the detail aging, but then we lose the column arrangement of 1-30, 31-60, 61-90 just as you described.
Let me help share information about your report in QuickBooks Desktop (QBDT), @Tam41.
As of the moment, there isn't an integrated way to customize a report showing detail and summary data at once. Let's consider creating your report by exporting it as suggested by my colleague above.
While the report you need is not available, it's best to let our developers know about your request by sending feedback. Let me show you how.
I'm adding this article to keep track of your business's financial status to date: Create and Manage Reports in QuickBooks Desktop.
If you have any other concerns with generating reports, please let me know in the comments below. I'll be here to answer all of them. Take care and stay safe!