Shopify AR Movement | Build with Bookkeep

Shopify AR Movement Report

The Shopify AR Movement report is an accounts receivable roll-forward for a period you choose: the AR balance at the start of the period, plus every increase, minus every decrease, arriving at the balance at the end of the period. The movement is broken down by the month the order was created, so you can see how much of the period's AR activity came from new orders versus orders created in earlier months.

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

All figures come from Bookkeep's internal double-entry ledger — the same source of truth used to build your journal entries. An increase is any ledger activity that raised accounts receivable (typically a sale not yet paid); a decrease is any activity that lowered it (typically a payment or refund settling the receivable). The report's ending balance ties exactly to the Shopify AR Aging report as of the same date, so the two can be used together: AR Movement explains how the balance changed during a period, and AR Aging shows which orders make it up at a point in time.

You'll find the report in Bookkeep by clicking Reports in the left navigation menu, then choosing AR Movement Report under the Shopify section.

Filters

Filter	What it does
Connection	The Shopify store to report on.
Start Date / End Date	Required. The period to roll forward. The beginning balance is as of the day before the Start Date; the ending balance is as of the End Date.
Source status / Financial status / Fulfillment status	Optional. Limit the report to orders currently in the selected statuses. These appear after the report first loads.
Exclude settled orders (net $0 in period)	On by default. Hides orders whose AR movement nets to zero within the period — for example, an order created and paid the same day. The beginning and ending balances are unaffected, and the roll-forward still ties.

Balances and the Summary Matrix

Five summary tiles appear at the top: Ending AR Balance (as of the End Date), Beginning AR Balance (as of the day before the Start Date), AR Increases, AR Decreases, and Net Change with the number of orders involved.

Below them, the summary matrix breaks the movement down with columns Order Created, Orders, AR Increases, AR Decreases, and Net Change. Its rows read like a reconciliation:

Beginning AR balance — the starting point.
Opening balance — appears when part of your balance was carried in from your configured opening balance date rather than from individual orders.
One row per creation month, split into two groups: orders created in prior months (with their own subtotal) and orders created within the period (with their own subtotal). This split shows how much of the period's activity is new business versus older orders finally settling.
Unknown creation month — appears when activity belongs to orders that have since been deleted; it's kept so the roll-forward still ties.
Total movement and the Ending AR balance.

A Download CSV button on the matrix exports it exactly as shown.

Drilling Down to Orders

Every month row is clickable:

Click the month to see all AR activity for orders created in that month.
Click the AR Increases or AR Decreases amount to see only that side of the activity.
Click the prior months subtotal to see all activity from orders created before the period.

The drill-down loads a table below the matrix, one row per order, and the address bar updates so you can bookmark or share the drilled-in view. Use Clear drill-down to return to the summary.

Column	What it shows
Source ID	The platform's internal ID for the order. Clicking it opens the order's ledger diagnostics.
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.
Currency	The order's currency.
Financial status	The order's payment status.
Fulfillment status	The fulfillment status of the order as a whole.
Created at	The date the order was created — this is what places it in a summary-matrix month.
AR Increase	The total AR increases for this order within the period.
AR Decrease	The total AR decreases for this order within the period.
Net	Increase minus decrease — this order's net effect on your receivables in the period.

The money columns show sums at the bottom of the table, and the table has its own CSV export.

How the Report Decides What's Included

All active (non-voided) ledger activity on accounts receivable posted within the period counts toward the movement; the beginning and ending balances count everything posted through their respective dates.
Orders are bucketed by their creation month in your store's timezone.
Activity from deleted orders still counts toward the balances (so the roll-forward ties) but is grouped under "Unknown creation month" and has no drill-down.
With Exclude settled orders on, orders whose increases and decreases cancel out exactly within the period are hidden from the matrix and drill-down. Because each hidden order removes equal amounts from both sides, totals still reconcile.

Large drill-downs load up to 5,000 orders into the table; a notice appears when the bucket holds more. The summary matrix is always complete regardless.