Overview
When closing your books, you'll often want to confirm that the Deferred Revenue total shown on the Orders - Journal Entries Explorer matches the Deferred Revenue page and the underlying Order Line Items and Shipping pages. The numbers should tie out across all three to four screens — but each page uses slightly different filters to surface the same figure, and the right filter combination depends on both the order system (Amazon Seller, Shopify, etc.) and the value type you're checking (gross, shipping, discount).
This article walks through how to apply the right filters so you get a clean one-to-one comparison.
⚠️ Before You Start: Currency Settings
The Order Line Items and Shipping pages do not currently support the "Show in Financial Statement Currency" toggle. It only displays values in the original transaction currency.
To compare cleanly across all four pages, you need to turn off "Show in Financial Statement Currency" on both:
The Journal Entries Explorer
The Deferred Revenue page
…and then filter by a single currency at a time (e.g., reconcile USD figures separately from CAD figures).
The Four Pages You're Reconciling
Page | What it shows |
Orders - Journal Entries Explorer | The summary figure that posts to your GL — captures the full picture, including order-system-level adjustments |
Deferred Revenue page | A page-level summary of deferred revenue, broken down by order system and value type |
Order Line Items page | The transaction-level detail behind a specific deferred revenue figure. Drill-in destination when you click into a ordered total (via the "order line item" link) |
Shipping page | Transaction-level detail for shipping figures. Drill-in destination when you click into a ordered total (via the "order shipping" link) |
"Hover over the "Total Ordered" amount to click into either Order Line item or Order Shipping links"
All pages should agree when you use the right filter combination. Where they don't, it's almost always a filter mismatch — see the table below.
Filter Combinations That Make the Numbers Match
The filter you apply on the Deferred Revenue page to match a given Journal Entry figure depends on two things: the order system and the value type being measured. Use the table below as your reference.
USD Reconciliation
Order System | Deferred Revenue Type | Order Line Item Values Filter | Shipping Values Filter |
Amazon Seller | Gross | Gross price | (none) |
Shopify | Gross | Gross price | (none) |
Amazon Seller | Shipping | (none) | Gross price |
Shopify | Shipping | (none) | Gross price + Discount |
Amazon Seller | Discount | Discount | Discount |
Shopify | Discount | Discount | (none) |
Example of comparing Amazon Seller - Gross Deferred Revenue :
Deferred Revenue Page:
Orders - Journal Entries Explorer:
CAD Reconciliation
Order System | Deferred Revenue Type | Order Line Item Values Filter | Shipping Values Filter |
Amazon Seller | Gross | Gross price + Discount | (none) |
Amazon Seller | Shipping | (none) | Gross price |
Example of comparing Amazon Seller - Gross Deferred Revenue :
Deferred Revenue Page:
Orders - Journal Entries Explorer:
Note on filter variation: The exact filter combinations differ between Amazon Seller and Shopify — and in some cases between currencies — because of how each order system applies discounts, shipping, and order-level adjustments at the underlying data level. We're actively reviewing whether these filter rules should be standardized, but for now this is the validated approach to get figures to tie out.
Special Case: Amazon Order-Level Discounts
When checking Amazon Seller discount figures, you'll see something that looks like a discrepancy but isn't:
The Journal Entries Explorer and Deferred Revenue page show the full discount total
The Order Line Items page shows a smaller figure
The gap between the two can be material
Why this happens
Amazon applies discounts at two levels:
Line item level — discounts attached directly to a specific product line. These show up on the Order Line Items page.
Order level — basket-building promotions applied to the order as a whole (e.g., small $1.49 or $2.99 promo credits that aren't tied to a specific SKU). These do not show up on the Order Line Items page.
The Journal Entries Explorer and Deferred Revenue page correctly capture both levels. The Order Line Items page is limited to line-item-level discounts only — which is why it appears to "miss" the order-level discount portion.
How to investigate the gap
If you need to see what's behind the order-level discount difference:
Click into the discount total from the Journal Entries Explorer page and download the export
Click into the discount total from the Order Line Items page and download the export
Compare the two exports — the orders present in the JE export but missing from the Order Line Items export reveal the order-level promotion activity
There's no data missing — it's a display limitation of the Order Line Items page, not a reconciliation problem.
Step-by-Step Reconciliation Walkthrough
Use this flow whenever you're tying out a Deferred Revenue figure:
Pick a specific JE figure to reconcile. Open the Journal Entries Explorer and identify a single Deferred Revenue line you want to check (e.g., Deferred Revenue – Gross, Amazon Seller, USD).
Turn off "Show in Financial Statement Currency" on both the JE Explorer and the Deferred Revenue page so you're comparing in the order's native currency.
Open the Deferred Revenue page and apply the matching filter combination from the table above (order system + the correct Order Line Item Values and Shipping Values filters).
Confirm the page total matches the JE figure. If it doesn't, double-check that you applied the exact filter combination from the table — most mismatches at this stage are filter errors.
Click into the Deferred Revenue figure to drill into the Order Line Items page.
Compare the Order Line Items page total to the JE figure:
For Gross and Shopify Discount: the total should match exactly
For Amazon Discount: expect the Order Line Items page to be lower than the JE figure — the difference is the order-level promotional activity that doesn't surface at the line-item level (see Special Case above)
Repeat Step 5 and 6 for Shipping.
Known Limitations
Order Line Items and Shipping pages do not support "Show in Financial Statement Currency." Reconciliations across all four pages must be done one currency at a time.
Order Line Items page does not surface Amazon order-level discounts. This is a display limitation only — the data is correctly captured in the JE Explorer and the Deferred Revenue page.
Filter combinations differ between order systems (Amazon Seller vs. Shopify) and in some cases between currencies (USD vs. CAD) due to differences in how each system applies discounts and shipping at the underlying data level. We're actively reviewing whether to standardize this.
Questions?
If you're hitting a tie-out you can't explain, or you'd like help reviewing a specific reconciliation, reach out to our Customer Support team.