Formats accepted: CSV or XLSX for either file. For courier files, you can also upload a .zip, .7z, .rar, .tar or .gz containing several reports at once, or add one file per courier separately. PayTrace merges them into a single run either way.
1. Exporting your Shopify orders
In your Shopify admin, go to Orders → Export, choose All orders (or a specific date range), and export as CSV. That's the file to upload.
- Shopify admin → Orders
- Click Export in the top right
- Choose the orders to export: the last 30 days is enough for a normal audit (see the date-window note below)
- Export as CSV for Excel, Numbers, or other spreadsheet programs
- Upload the downloaded file to PayTrace as-is
Use the standard export, not a filtered/custom one. Shopify lets you export only specific columns. If you do that and leave out Total (or Grand Total), PayTrace has nothing reliable to read each order's value from, and has to reconstruct one from your line items instead. That's a real fallback, but it can't see fees or shipping charges added outside the line-item price, so it may undercount. The plain, unfiltered "All orders" export always includes Total, and is the safest choice.
If Shopify splits a large export into multiple files, add all of them. PayTrace merges them into one run automatically.
2. Downloading your courier remittance report
This is the report showing what your courier actually paid you for COD orders, sometimes called a "remittance," "COD payment," or "payout" report. Where to find it depends on the courier:
Delhivery Confirmed path
Delhivery One dashboard → Finances → Remittance. This lists every remittance with its number, processed date, bank UTR and amount, export or download it from there.
Shiprocket Confirmed path
Shiprocket seller panel → Billing → COD Remittance. The tab shows your COD payment summary and lets you pull the detailed report for the period you need.
Ekart, XpressBees & Shadowfax Check your billing section
These couriers' merchant panels sit behind account-specific logins, so the exact menu label varies by account type and plan. Look for a Billing, Finance, or COD Management section in your dashboard. XpressBees in particular runs COD reporting through a separate portal from its main shipping panel. If you can't find it, your account manager or their support chat can point you to it directly; search their help center for "COD remittance" or "COD payment report."
Shipping with more than one courier? Add a remittance file for each. You don't need to combine them yourself, and you don't need to run a separate audit per courier.
3. How much history to upload
Export the last 30 days of Shopify orders, and a courier remittance report covering at least the last 45 days. The extra window gives your courier's normal payment cycle time to complete even for your most recent orders, so an unmatched order can be confirmed as genuinely missing rather than just not-yet-paid.
Got both files? You're ready to run an audit.
Upload your files →