Shopify AR Aging | Build with Bookkeep

On this page

The Shopify AR Aging report shows every Shopify order with an outstanding accounts receivable balance as of a date you choose — money the order still owes you (or, when negative, money you owe back). Each row is one order, with its receivable balance alongside four related balances Bookkeep tracks for the same order: deferred revenue, deferred discounts, Shopify Payments, and refunds payable.

This report is available for Shopify only — it covers orders from your connected Shopify store.

All balances come from Bookkeep's internal double-entry ledger — the same source of truth used to build your journal entries — so the report's totals tie out to the AR, deferred revenue, and related balances Bookkeep posts to your accounting platform. Use it at a period end to see exactly which orders make up your receivables balance on that date. It pairs with the Shopify AR Movement report, which explains how that balance changed over a period.

About the name

Despite "aging" in the name, this report does not bucket balances by age (0–30 / 31–60 days, and so on). It is a point-in-time snapshot: the outstanding balance of every order as of the date you choose.

How the report decides what's included

A row appears for every order with a non-zero accounts receivable balance as of the As of Date. Orders whose AR nets to zero are excluded, even if they carry other balances.
Balances are computed from all ledger activity posted on or before the As of Date (and on or after the Start Date). Payments, refunds, or edits after that date don't affect the report — it shows the world as it stood on that date.
Voided ledger activity is excluded, so corrections Bookkeep has reversed don't distort the balances.

Filters

Filter	What it does
Connection	The Shopify store to report on.
As of Date	Required. Balances are computed as of the end of this date. Set it to a month end or year end to tie out your AR balance.
Start Date	Optional. Orders and ledger activity before this date are ignored. When left blank, Bookkeep starts from your configured opening balance date, or four years before the As of Date.

Totals

Up to six summary tiles appear above the table, each the grand total across every matching order (not just the rows currently visible):

Accounts Receivable — the total outstanding receivable, with the matching order count.
Deferred Revenue — sales collected or receivable for goods not yet recognized as revenue.
Deferred Discounts — the discount portion deferred along with that revenue.
Shopify Payments Balance — amounts held in Shopify Payments for these orders.
Refunds Payable — refunds owed to customers but not yet paid out.
AR (Opening) — the receivable balance carried in from your opening balance date. This tile only appears when an opening balance date is configured for the store.

Columns

Each row is one order. You can sort, reorder, show/hide columns, and export the table to CSV; the money columns show a sum at the bottom of the table.

Column	What it shows
Source ID	The platform's internal ID for the order. Clicking it opens the order's ledger diagnostics, showing the underlying ledger activity behind the balances.
Order	The order's number in your store.
App	The sales app the order came from.
Location	The order's location.
Source status	The order's status in your store (for example `Open`).
Currency	The order's currency.
Financial status	The order's payment status (for example `PAID`, `PARTIALLY_REFUNDED`).
Fulfillment status	The fulfillment status of the order as a whole.
Created at	The date the order was created.
Accounts Receivable	The order's outstanding receivable balance as of the report date.
Deferred Revenue	The order's deferred revenue balance.
Deferred Discounts	The order's deferred discounts balance.
Shopify Payments Balance	The order's Shopify Payments balance.
Refunds Payable	The order's refunds payable balance.

Large reports

The on-screen table loads up to 5,000 orders; a notice appears when the date has more. The totals tiles always cover every matching order, regardless of how many rows are shown.