Tracking payments in Shopify Analytics
Downpay keeps all payments for an order together in one place. This guide explains how split-payment orders appear in Shopify Analytics, and how to use the Payment method by order report to track and reconcile each payment collected.
On this page:
How Downpay orders work in Shopify
The Payment method by order report
Understanding the transaction rows
Using this report for accounting
How Downpay orders work in Shopify
When a customer places an order using Downpay, a single order is created and records every payment against it. The deposit collected at checkout and the balance collected later both appear on that same order.
This is important for accounting: there is no duplicate order, no separate record, and no ambiguity about which payments belong together. Everything is attached to the original order number.
As payments are collected, Shopify updates the order's financial status automatically. An order that has had a deposit collected but still has an outstanding balance will show as Partially paid in Shopify. Once the full balance is collected, it updates to Paid.
The Payment method by order report
Shopify includes a built-in analytics report that gives you a transaction-level view of every payment collected. You can find it in your Shopify admin under:
Analytics > Reports > Payment method by order
This report is particularly useful for Downpay stores because it shows each individual transaction on an order as its own row, rather than just the order total. This means you can see exactly when each payment was collected, how much it was, and how it was processed.
Understanding the transaction rows
Each row in the report represents a single transaction. For a Downpay order, you will typically see multiple rows sharing the same order number.
The columns most relevant to split-payment orders are:
Order name -- The Shopify order number (for example, #1064). Multiple rows with the same order name are all payments on the same order.
Transaction kind -- This tells you what type of transaction the row represents. The most common values you will see on Downpay orders are:
- Sale -- A payment was collected immediately. This is typically the deposit row.
- Capture -- A previously authorized amount was collected. You may see this for balance payments, or for deposit collection methods that authorize first.
- Refund -- A refund was issued against the order.
Transaction number -- Each transaction on an order is numbered sequentially. Transaction 1 is typically the first payment collected (usually the deposit). Later transactions represent subsequent payments.
Gross payments -- The amount collected in that transaction, before any refunds.
Refunded payments -- Any amount refunded from that specific transaction.
Net payments -- Gross minus refunded. This is the amount actually retained from that transaction.
Using this report for accounting
Because each transaction appears as its own row, you can use this report to answer the accounting questions that come up most often with split-payment orders.
When was each payment collected?
Filter or sort by date. The row's date reflects when that transaction occurred, not when the order was created. This gives you accurate cash-basis timing for each payment.
How much has been collected on an order so far?
Filter by order name and sum the Net payments column across all rows for that order.
Has the full balance been collected?
If the order shows only one transaction (the deposit), the balance has not yet been collected. Once the balance is captured, a second transaction row will appear.
How do I reconcile a refund?
Refund rows will show the refunded amount in the Refunded payments column and a negative value in Net payments. They reference the same order name as the original payment rows, so they are easy to match.
For a full breakdown of the underlying Shopify order data available via the API -- including fields like |
|---|
Updated on: 01/06/2026
Thank you!