Skip to main content
D
DBAeroSphere
March 26, 2024
Question

Paid Date in A/R Aging Detail

  • March 26, 2024
  • 1 reply
  • 0 views

When running an A/R Aging Detail, Reports > Customers & Receivables > A/R Aging Detail, if you select the "Paid Date" column, all cells show as blank.

I have seen some older posts regarding this issue. I want to bring this up again and ask if anyone has found a workaround for this very expensive sub-optimal program. I'm comfortable exporting the report as a CSV and running it through a Power Query or processing it with Python. At the core, I want an invoice number and the date it was fully paid. 

 

1 reply

MJoy_D
MJoy_D
March 26, 2024

I can assist you in generating a report that displays the date when an invoice was fully paid,

 

The A/R Aging Detail report shows due and overdue invoices and statement charges. If you want to see the invoices and their payment dates, you can try running and customizing the Transaction List by Customer report. 

 

Here are the steps to follow:

 

  1. Go to the Reports menu.
  2. Hover to Customers & Receivables and select Transaction List by Customer. 
  3. Click the Customize Report button.
  4. In the Display column make sure to tick on the checkbox for the Date.
  5. On the window that appears, proceed to the Filters tab, and search for Transaction Type.
  6. In the Transaction Type dropdown, click Multiple Transaction Types choose Invoice and Payment and click on OK. 
  7. Search for Paid Status in the Filters tab and choose Either.
  8. Click on OK to run the report.

 

You can check this article for more information about running various financial reports in QuickBooks Desktop. It explains how to customize customer, vendor, item, company, financial, payroll, and employee reports: Customize company and financial reports.

 

Here's also a guide about saving the current settings that you set for your report, so you do not have to go through the customization process again. It'll guide you with creating, accessing, editing, setting up, and resolving possible issues you'll encounter when memorizing a report: Create, access and modify memorized reports.

 

Let me know if you need more help running your reports. I'm always here to assist. Have a wonderful day!

    D
    DBAeroSphereAuthor
    March 29, 2024

    Hello MJoy_D,

     

    I have generated that report and I have some questions. Here's a sample of what was generated.

    I just want to make sure I am interpreting this information correctly. 
     - Invoices without a payment under are not paid.

     - Invoices with a payment under have been paid, at least partially, and the date of the last payment, assuming open balance is 0, is the date the invoice was fully paid.

    J
    JamesAndrewM
    March 29, 2024

    Thanks for getting back to the thread. I'll share my thoughts regarding your queries.

     

    Based on the information provided in the sample report you generated, I agree with you. The report indicates that the invoice mentioned in it, which has no recorded payment, has not been paid at all. The invoices that show a payment amount under them have received partial payment, but not necessarily the complete amount owed. Additionally, the report suggests that if an invoice's open balance is zero and a payment is recorded against it, then the date of that payment is considered the date when the invoice was fully paid.

     

    I'm adding these articles you can use in the future:

     

     

    If you have any specific questions or need further clarification about QuickBooks, feel free to ask! We're always available and willing to lend a hand to your queries. Have a great day ahead!

      Terms & ConditionsAccessibility statement