Aging Report PDF to Excel: Convert AR Aging and AP Aging Reports to Excel and CSV

Upload the aging report PDF to the converter at the top of this page and download the result as XLSX or CSV. Each customer or vendor stays on its own row, and the current, 1 to 30, 31 to 60, 61 to 90 and over 90 day buckets each land in a separate column. Amounts come back as real numbers, so the column totals still add up to the report total.

In QuickBooks Online, open Reports, run the A/R Aging Summary or A/R Aging Detail, then use the export icon and choose Export to Excel. That path only works while you still have access to the file. When the aging report reaches you as a PDF from a client, a former bookkeeper, or a system you were locked out of, upload it here instead and you get the same column layout back.

Most US aging reports use five buckets: Current, 1 to 30 days, 31 to 60 days, 61 to 90 days, and over 90 days, plus a total. Some systems shift the boundaries to 0 to 30 and 91 plus, and construction and healthcare formats often add a 120 plus column. The converter keeps whatever buckets your report uses and does not force them into a fixed template.

Because most aging rows have empty buckets. A customer who only owes money over 90 days has four blank cells before that figure, and a converter that reads by position rather than by structure slides the number left into the 61 to 90 column. That single failure quietly changes what your collections list says. This converter maps each amount to the bucket header above it, so blanks stay blank.

The same way as a receivables report, and the output is the same shape. Upload the AP aging PDF and you get one row per vendor with the amount owed in each aging bucket. Finance teams use the result to sort vendors by what is falling past terms, plan the next check run, and tie the total back to the accounts payable balance on the balance sheet.

Yes. Aging reports printed and scanned by a client or pulled out of an old practice management system still convert, because built-in OCR reads the page before the table structure is rebuilt. Scanned pages are where bucket alignment usually breaks in cheaper tools, so check the total column against the report footer once the file opens.

Once the aging report is in Excel, divide the total of the over 90 day column by the grand total of the receivables column, then format the result as a percentage. In practice, put =SUM(F2:F200)/SUM(G2:G200) in an empty cell where F is the over 90 bucket and G is the total. Anything above roughly ten percent is usually where a collections review starts.

Convert the aging report, then sort by the over 90 day column from largest to smallest and filter out any row with a zero balance. The first fifteen rows are almost always where the recoverable money is. If you have the aging detail rather than the summary, you also get the individual invoice numbers and due dates to quote on the call.

A summary gives one row per customer or vendor with a balance in each bucket. A detail report lists every open invoice under each customer, with its date, number, due date, and amount. Both convert here. Take the summary when you want a portfolio view and the detail when you need to reference specific invoices while chasing payment.

An aging report names your customers and exactly how much each one owes, so it deserves the same care as a bank statement. Files here are encrypted in transit and at rest, processed in an isolated environment, and deleted automatically once the conversion finishes. Nothing is stored long term, resold, or used to train an outside model.