Convert an Accounts Receivable Aging PDF to Excel and CSV
An accounts receivable aging report shows who owes your company money and how long each invoice has gone unpaid. A collections lead prints it to decide whom to call first. When it reaches you as a PDF, the balances cannot be sorted, filtered or added.
Statements to Sheets turns that report into a CSV. Every column in the document becomes its own column in the file. You can then open it in Excel or Google Sheets and work through the customers in whatever order helps you collect.
Upload your Accounts receivable aging file to see the first rows before you pay. The first 50 transactions are free.
Why an accounts receivable aging report is hard to convert from a PDF
Customer names are long and they wrap. A client with a legal name and a division can fill two lines, and a basic converter turns the second line into a row with no balances. The sheet then has gaps that break a filter on customer.
Each customer owns a block of rows. The customer is named once at the top of the block, and the invoices sit below it. Copy the page into a spreadsheet and the invoices lose the customer they belong to, which is the one fact you need to place a call.
Subtotals follow every customer and a grand total closes the report. The headings come back at the top of each page as well. A tool that reads line by line takes those lines for invoices, and a sum over the sheet counts the same receivable twice.
The report is wide. Several bands of overdue time sit side by side, and a balance belongs to a band only because of where it sits on the page. Lose that position and an old debt looks like a fresh one.
About accounts receivable aging reports
- An accounts receivable aging report is a standard output of accounting software. It is run as of a chosen day, and it sorts what customers owe by how late the payment is.
- Collections staff use it to rank their calls. Controllers use it to judge how much of the money owed will really arrive, and lenders ask for it when a company borrows against what it is owed.
- Each accounting package prints its own version. Some give one line per customer, and others list every open invoice. A company with many customers can produce a report that runs to many pages.
How we convert it
- The reader finds the table headers and the column positions on the page.
- Each row is cut by position, so a wrapped customer name stays in its own cell.
- Every column in the document becomes its own column in the CSV.
- The preview shows the first rows free, and you can adjust the column positions if a column is misread, before you convert.
- The free preview shows the first rows, so you can check the result before you convert.
Every conversion also checks each page against the page image, and lines that continue a wrapped description are not counted as extra transactions.
The result is a CSV with Date, Description and Amount columns (plus Balance when the statement has one) that opens in Excel and imports into Google Sheets and QuickBooks. You pay per transaction, not per page. See plans and pricing.
What people do with the file
Collections calls. Sort the sheet from the oldest balance to the newest, and hand each caller a list of customers to contact. A sheet is easy to split and to track.
Credit decisions. Filter to one customer before you approve a new order, and see every open invoice they hold in one view.
Cash forecasting. Add up what customers owe and weigh it against your own bills for the coming weeks. A pivot table does the grouping in a few clicks.
Month-end review. Put this month's report beside last month's in one workbook to see which customers slid further behind.
Lender requests. A bank that lends against receivables may ask for the full list. Send a clean sheet rather than a long PDF.
Write-off review. Pull the balances that have sat longest into their own tab and bring them to the person who decides what to write off.
Good to know
- Look at the free preview before you convert, and adjust the column positions there if a column is misread.
Questions
Are all the columns of the aging report kept?
Yes. Each column in the document becomes its own column in the CSV.
What if a customer name wraps onto a second line?
The reader cuts each row by its position on the page, so a wrapped name stays in its own cell. Look at the preview, and adjust the column positions if something is off.
Will customer subtotals show up as invoices?
Totals are kept apart from the invoice rows. The free preview shows the first rows, so you can see how your report comes out before you convert.
How is it priced?
The preview is free, and you pay per transaction, not per page.
Related Guides

Written by
Jeff GoughFounder of Statements to Sheets and Cascade Foundry LLC. Built this tool after converting 300+ pages of printed bank statements into CSV for a friend's QuickBooks catch-up. Read the full story →