Reconcile CSV exports

Upload your Paystack transaction export and Shopify report. We match records by a shared ID (usually Shopify Payment Id).

First-run guide

Upload both CSV files

Confirm match columns

Review mismatches

Download export

Download Paystack sample Download Shopify sample

Workspace template

Apply reusable mapping/rules from your workspace.

API connector sync

Pull Paystack + Shopify data directly, then auto-reconcile.

Configure connectors in workspace after login.

Account

File limits: up to 5 MB and 50,000 rows per CSV.

Paystack CSV

Shopify CSV

Column mapping

Smart template suggests columns and shows confidence.

Paystack match columnShopify match columnPaystack status column (optional)Only include Paystack rows with Status = successEnable safe fuzzy ID matching (strict one-to-one partials)Auto-clean messy CSV columns and valuesCollapse likely duplicate rows

Amount mismatch check (optional)

Paystack amount columnShopify amount column

If both amount columns are selected, we flag a row as amount_mismatch when the values differ.

Results

Dataset hash: —

Upload both CSVs and select match columns to compute results.

Export

Full CSV export is generated server-side and requires either a free-size dataset or a successful payment unlock.

Unlock full export

Checkout runs through Paystack and the unlock is attached to your current account.

Account: Not logged in

Tip: test a sample export first to confirm mappings before paying.

SettleStack is not affiliated with Paystack or Shopify.