Shopify Fulfilled Line Items | Build with Bookkeep

Shopify Fulfilled Line Items Report

The Shopify Fulfilled Line Items report shows the revenue Bookkeep recognized from fulfillments in a date window you choose, one row per line item. Each row carries the gross sales amount, discount, and cost of goods sold recorded when the item was fulfilled, along with the product, order, and fulfillment details behind it. Returns and adjustments that Bookkeep recorded in the same window appear as their own rows, so the report reflects the full revenue activity for the period.

This report is available for Shopify only — it covers orders from your connected Shopify store, and orders from other sales channels do not appear in it.

If you use fulfillment-based revenue recognition, this report is the line-item detail behind the revenue recognized in the period: sales move out of deferred revenue and into income when items ship, and each row here is one of those movements. It pairs with the Shopify Unfulfilled Line Items report, which shows what had not yet shipped as of a date.

All amounts come from Bookkeep's internal double-entry ledger — the same source of truth used to build your journal entries — so the report ties out to what Bookkeep posted to your accounting platform.

How the report decides what's included

A row appears when Bookkeep recorded revenue activity for the line item within the Start Date – End Date window: a fulfillment, a return, or an adjustment. The dates refer to when Bookkeep recognized the activity, not when the order was originally sold — an order sold in March and fulfilled in April appears in an April report.
Product, shipping, and adjustment line items are included.
Each row is tagged with an Action Type — ORDER for fulfillment revenue (including fulfillment cancellations), RETURN for returns and refunds, and ADJUSTMENT for order adjustments — so you can separate sales from give-backs.
Deleted orders are excluded. When an order is deleted, Bookkeep reverses its ledger activity; items whose activity nets to zero are dropped from the report.

Filters

Filter	What it does
Connection	The Shopify store to report on.
Start Date / End Date	Required. The window of fulfillment activity to include. Set it to a month to see that month's recognized revenue.
Fulfillment Locations	Optional. Limits the report to fulfillments from the selected locations.
App Name	Optional. Limits the report to orders from the selected sales apps (for example, Online Store or Point of Sale).
COGS only	Optional. Yes restricts the report to line types that carry cost of goods sold (products and adjustments), excluding shipping lines.
Zero unit cost	Optional. Yes shows only line items with no cost recorded — useful for finding products missing cost data.

Choose your filters and click Apply to load the report. You can also choose which columns are visible, search within the results, and export the full report to CSV.

Totals

The totals strip above the table shows two sets of figures:

Shipped — totals across every row in the report: gross sales, returns, discounts, discounted total, shipping total, unit cost (COGS), and quantity.
Delivered — the same figures counting only line items whose fulfillment has a recorded delivery. Comparing the two shows how much of the period's shipped revenue has actually reached customers.

Columns

Line item details

Column	What it shows
Order ID	The platform's internal ID for the order.
Sale ID	The platform's internal ID for the sale the line item came from.
Order	The order's number in your store.
App Name	The sales app the order came from.
Product	The product (and variant) name, or a description of the shipping charge.
Variant SKU	The variant's SKU from your store catalog.
Product Type	The product's type/category from your store catalog.
Line Type	`PRODUCT` for merchandise, `SHIPPING` for a shipping charge, or `ADJUSTMENT`.
Action Type	`ORDER` for fulfillment revenue, `RETURN` for a return/refund, `ADJUSTMENT` for an order adjustment.

Dates

Column	What it shows
Line Item Sold Date	The date the item was originally sold.
Sold Month	The sold date's month (`YYYY-MM`).
Calculated Fulfilment Date	The date Bookkeep recognized the activity — the date the report's Start/End window matches against.
Fulfilment Month	The fulfilment date's month (`YYYY-MM`).
Delivered Month	The month the fulfillment was delivered, when a delivery is recorded.

Comparing Sold Month and Fulfilment Month shows revenue that was deferred in one month and recognized in a later one.

Amounts

Column	What it shows
Gross Sales	The revenue recognized for this line before discounts. Negative on `RETURN` rows.
Discount	The discount recognized for this line.
Discounted Total	Gross sales minus the discount — the net revenue for this line.
Unit Cost	The cost of goods sold recorded for this line (cost × quantity).
Quantity	The quantity fulfilled on this line (negative for reversals).

Fulfillment details

Column	What it shows
Delivery Method	How the fulfillment was delivered (for example, shipping or local pickup).
Fulfillment Delivered At	When the fulfillment was delivered, shown in your store's timezone. Empty when no delivery has been recorded.
Fulfillment Display Status	The fulfillment's current status in your store.
Fulfilment Location	The location the fulfillment shipped from.