Skip to main content

AR Aging Report - Report

The Quickbooks The AR (Accounts Receivable) Aging Report provides a snapshot of unpaid customer invoices, categorizing them based on the duration of outstanding balances. It aids in tracking and managing receivables for effective cash flow management.

Add this job

Data

Sample Data

Open in new tab -

Data headers

HeaderDescription
AccountsName of the related account
Accounts Idquickbooks id of the related account
CurrentInvoice issued but payment is not due yet
1 - 30Total due which is overdue by 1-30 days
31 - 60Total due which is overdue by 31 - 60 days
61 - 90Total due which is overdue by 31 - 60 days
91 and overTotal due which is overdue more than 91 days
TotalTotal due for this account

Filtration options

This job can restrict the data that is visible in spreadsheets. Use the following parameters to restrict the data.

ParameterOptions
report_dateGets the report as of a specific date. If left empty, then it will get data as of today. Format - YYYY-MM-DD.