CSV troubleshooting
Why Your Sales CSV Does Not Match Your Payout: A Reconciliation Guide
Do not force gross sales, net sales, total collected, and bank payouts to match: they describe different stages of the money flow. First copy each source's documented metric definitions into a reconciliation map. Then align currency, sign convention, date basis, transaction ID, and row grain; calculate each subtotal separately; bridge the differences with discounts, returns, tax, shipping, processing fees, reserves, disputes, and timing items; and compare the final payout total with the bank deposit. Keep unmatched rows visible instead of hiding them in an adjustment.
Short answer
Do not force gross sales, net sales, total collected, and bank payouts to match: they describe different stages of the money flow. First copy each source's documented metric definitions into a reconciliation map. Then align currency, sign convention, date basis, transaction ID, and row grain; calculate each subtotal separately; bridge the differences with discounts, returns, tax, shipping, processing fees, reserves, disputes, and timing items; and compare the final payout total with the bank deposit. Keep unmatched rows visible instead of hiding them in an adjustment.
Upload
Bring the CSV you already use.
Understand
Start with the brief and evidence.
Act
Ask, edit, filter, and export.
A practical starting point
Do not force gross sales, net sales, total collected, and bank payouts to match: they describe different stages of the money flow. First copy each source's documented metric definitions into a reconciliation map. Then align currency, sign convention, date basis, transaction ID, and row grain; calculate each subtotal separately; bridge the differences with discounts, returns, tax, shipping, processing fees, reserves, disputes, and timing items; and compare the final payout total with the bank deposit. Keep unmatched rows visible instead of hiding them in an adjustment.
Concrete examples
Example 1: Tax is included in the customer payment but excluded from net sales
A shop records RM10,000 of gross product sales, RM500 of discounts, RM300 of returns, and RM552 of tax. Its documented net-sales metric is RM9,200, while the customer-facing collected amount includes tax. Comparing RM9,200 directly with the payment total creates a RM552 “mismatch” that is actually a definition difference.
Example 2: A partial refund posts after the original sale period
An order is captured on 31 July, but RM80 is refunded on 2 August. A July order report and an August payment or payout report will not align if both are grouped by their own event dates. The reconciliation retains the order date, capture date, refund date, and payout ID, then explains the cross-period item rather than moving it without documentation.
Example 3: Processing fees explain part of the bank difference
A payout export lists RM5,000 of included payments, RM200 of refunds, and RM95 of processing fees. Under the provider's documented sign convention, the payout is RM4,705 before any other adjustments. A sales dashboard that compares RM5,000 directly with the bank deposit overstates the unexplained difference by RM295.
Example 4: A one-to-many join duplicates an order total
An order-level export contains one RM120 order. A line-item export contains three rows for the same order. Joining the RM120 order total onto every line and then summing produces RM360. The analyst either aggregates line items to order grain first or keeps the order total in a separate order-level table.
Example 5: A reserve release appears without a current-period sale
A payment provider releases RM400 that was held from an earlier period. The bank payout is therefore higher than current-period captured payments less fees. The payout bridge labels the reserve release with its source transaction or balance reference instead of treating it as new sales revenue.
Examples are illustrative and are not customer results.
Common questions
What is the safest way to work with this CSV problem?
Do not force gross sales, net sales, total collected, and bank payouts to match: they describe different stages of the money flow. First copy each source's documented metric definitions into a reconciliation map. Then align currency, sign convention, date basis, transaction ID, and row grain; calculate each subtotal separately; bridge the differences with discounts, returns, tax, shipping, processing fees, reserves, disputes, and timing items; and compare the final payout total with the bank deposit. Keep unmatched rows visible instead of hiding them in an adjustment.
Keep exploring
See what your own CSV is saying.
Try the browser workspace with a real file and keep the public guide open when you need help.
Start free