Zovo AR Aging Report

Make an accounts receivable aging report from your open invoices and see who owes you money, without building a spreadsheet. Zovo AR Aging Report is an AR aging report template that fills itself in. Type or paste your open invoices, or attach a CSV or Excel export from QuickBooks, Xero, FreshBooks or Wave, and it ages each open balance as of the date you choose.

Each balance goes into Current, 1-30, 31-60, 61-90 or over 90 days past due, counted from the due date (from the due date column, or from terms such as Net 30, Net 15, Net 30 EOM or Due on receipt). Totals per customer and the grand total are computed in cents and add up to the cent, with the percent of the total in each bucket. Partial payments and credit memos reduce balances; invoices paid in full are skipped and counted. Title lines, section headings and Total rows in accounting exports are left out and listed, and when the export has its own grand total, the result says whether the open items match it. Give credit sales for a period to get DSO (days sales outstanding).

Downloads are a printable aging PDF (summary by customer plus detail), an Excel workbook (aging summary, open invoices, reminder emails, rows left out), a CSV, and one-page customer statements as a PDF with the open items, an aging strip and the balance due. Polite past-due reminder email drafts are written from the invoice facts only, ready for you to review and send.

Good for small business owners, bookkeepers and office managers who chase unpaid invoices each week or close the month.

It ages by days past the due date with fixed 30, 60 and 90 day edges and handles one currency per report. It does not connect to QuickBooks or Xero, send emails or collect payments. Generated files are deleted after 1 hour. Up to 5,000 open items per run.