Blinkby Theta Advisory

Blink › Guides

Aged receivables and payables in Excel

Blink pulls aged receivables and aged payables from Xero or QuickBooks Online into your workbook, as at the date you choose.

Pulling it

  1. In Blink, open Xero or QuickBooks, then Reports.
  2. Under Aged Receivables or Aged Payables, set the as-at date and click Pull AR or Pull AP.
  3. Each lands on its own tab, called Aged Receivables or Aged Payables.

What you get

  • Xero: one row per outstanding invoice, grouped by contact, with days overdue and Xero’s aging columns. Contacts with nothing outstanding are left out.
  • QuickBooks Online: QuickBooks’ standard aging report as at the date, in its own layout.

The aging buckets are the ledger’s. Blink has no setting to change them.

Xero only provides aging one contact at a time, so a large organisation takes a few minutes. The pull runs in the background. If Xero fails to return some contacts, Blink tells you how many are missing; pull again to pick them up.

What it is used for

  • A collections list sorted by the oldest balances.
  • Agreeing the aging total to the receivables or payables control account at the same date. If they differ, look first for journals posted straight to the control account.
  • The allowance for doubtful accounts, and a search for unrecorded liabilities.
  • Lender and board reporting, with the totals linked into Word or PowerPoint.

For the invoices or bills over a date range, not only what is outstanding, see pulling invoices and bills.

Refreshing

Each aging tab keeps its date. Refresh pulls it again, and Roll forward moves the date on one month. Refresh All leaves the Xero aging tabs until last because they take the longest.

Aging is pulled one company at a time. It is not available for a group.

Get started with Blink

Add Blink to Excel yourself, or send us the workbook and we’ll set it up with you.

More guides