Reconciliation of Shopify Pay Payment Gateway Fee
Shopify Pay fee reconciliation helps finance teams verify that gateway fees, taxes, and settlement amounts are deducted and settled as expected. With Cointab, you can compare your internal sales or order data against Shopify Pay payment reports, rate cards, settlement files, and bank statements in one structured workflow.
What Shopify Pay fee reconciliation covers
A Shopify Pay reconciliation workflow is typically used to check whether the amounts charged by the payment gateway match the expected amounts from the applicable rate card and settlement logic. It also helps teams review whether the final settlement received in the bank agrees with the gateway report.
This is useful when finance teams need to understand:
- whether the fee charged matches the expected rate
- whether any fee overcharge or undercharge exists
- whether tax or deduction amounts are applied correctly
- whether settlement totals match the expected net amount
- whether a settlement reference appears in the bank statement
How Cointab handles the reconciliation workflow
Cointab uses a Side A and Side B model so finance teams can structure the reconciliation clearly.
Side A: your internal records
Side A usually contains the records your business expects to be correct, such as:
- Shopify sales or order reports
- internal finance exports
- expected fee calculations
- order-level settlement working files
- supporting lookup or mapping data
Side B: external Shopify Pay records
Side B contains the external records received from the payment gateway or related downstream files, such as:
- Shopify Pay payment report
- Shopify Pay rate card
- settlement report
- bank statement
- related deduction or payout records
Optional supporting data and derived columns
If the reconciliation needs extra context, Cointab can use supporting files such as order metadata, mapping tables, or fee reference sheets.
Finance teams can also create derived columns to calculate values like:
- expected fee amount
- net settlement amount
- tax-inclusive or tax-exclusive totals
- normalized transaction references
- cleaned order or settlement identifiers
Derived columns can be created from existing fields and reused whenever the reconciliation runs again.
Typical checks in a Shopify Pay fee reconciliation
Once the files are uploaded and mapped, the reconciliation engine can highlight several common scenarios.
Fee correctly charged
The actual gateway fee matches the expected amount based on the configured rate or rule.
Fee overcharged
The fee deducted is higher than expected and needs review.
Fee undercharged
The fee deducted is lower than expected and may require investigation before the period is closed.
Tax correctly applied
Where tax is part of the charge structure, the tax amount aligns with the expected calculation.
Tax difference found
The tax amount differs from the expected value and should be checked against the source report or applicable rule.
Settlement amount match
The final settlement amount aligns with the expected net amount after fees and deductions.
Settlement amount mismatch
The settlement received does not match the calculated amount, which may indicate a missing entry, a timing difference, or a deduction variation.
Settlement reference not found in bank
The settlement appears in the gateway report but is not visible in the bank statement yet, which can happen when a payout is delayed or a file is missing.
Review matched, partially matched, unmatched, and skipped records
Cointab separates transactions into clear reconciliation buckets so teams can focus on exceptions instead of reviewing every row manually.
- Fully matched records meet the expected matching logic for identifiers and amounts.
- Partially matched records are related, but the amounts do not fully align.
- Unmatched records appear on one side but not the other.
- Skipped records were excluded because of missing data, invalid values, duplicates, or file issues.
This makes it easier to investigate fee leakage, deductions, missing payouts, and unresolved settlement differences.
Reusable workflow for recurring Shopify Pay reports
After the reconciliation setup is defined once, the same workflow can be reused for future periods.
A typical run looks like this:
- Upload the required reports.
- Map date, amount, and identifier columns.
- Add supporting files if needed.
- Create derived columns where useful.
- Run reconciliation manually or on a schedule.
- Review the report dashboard.
- Investigate exceptions and open items.
- Download the Excel report for internal review or audit.
If a file arrives late, users can upload the missed file under the same reconciliation and refresh the report.
Reporting and exception handling
Cointab provides a report view that helps finance teams review the full reconciliation outcome.
Typical outputs include:
- total summary
- matched summary
- partially matched summary
- unmatched summary
- skipped summary
- transaction-level tables
- filters for deeper review
- downloadable Excel reconciliation report
Open items can also be reviewed manually when business context is needed. If the system or AI cannot confidently match a transaction, it remains open rather than forcing a weak match.
Why finance teams use Cointab for fee reconciliation
Shopify Pay fee reconciliation is rarely just about one fee line. Finance teams often need to track deductions, taxes, settlements, bank credits, and timing differences across multiple reports.
Cointab helps teams:
- reduce repetitive spreadsheet checks
- reuse the same reconciliation setup each period
- keep fee deductions and settlements transparent
- improve exception review for unmatched items
- support month-end close and audit preparation
- maintain a consistent workflow across users
Because the process is structured and reviewable, teams can see what matched, what did not match, and what needs follow-up.
Automation for recurring finance operations
Once the reconciliation is configured, data can be brought in through manual upload or automation. For recurring workflows, Cointab can receive files through email, SFTP, or API, then run reconciliation on a schedule when the required data is available.
This is useful for finance teams that want to keep payment reconciliation, settlement reconciliation, and bank reconciliation part of a repeatable operating process rather than a monthly spreadsheet exercise.
Team-based review and dashboard history
Cointab supports shared workspaces so finance teams can review the same reconciliation history together.
The dashboard keeps past runs available for reference, including the period, run time, files used, and status. That helps controllers, accountants, and reconciliation teams keep a clean audit trail across reporting cycles.
Common data used in Shopify Pay fee reconciliation
A Shopify Pay workflow is often built around these fields:
- transaction date
- order ID or reference ID
- payment amount
- fee amount
- tax amount
- settlement ID
- payout or UTR reference
- bank receipt amount
Where the file format is consistent, the same reconciliation can be reused for future periods without rebuilding the setup.
FAQ
What files are needed for Shopify Pay fee reconciliation?
Most teams use an internal sales or order report on one side and Shopify Pay payment, rate card, settlement, or bank files on the other side. Supporting lookup files can be added when additional context is needed.
Can Cointab reconcile fees and settlement amounts in one workflow?
Yes. The workflow can compare expected fees, actual deductions, and settlement values together, so finance teams can review the full payment chain in one place.
What happens if a transaction does not match?
Cointab flags the item as partially matched or unmatched, depending on the reconciliation logic. Finance teams can review the exception, use filters, and manually match records when the business context supports it.
Can recurring Shopify Pay reconciliations be automated?
Yes. Once a workflow is configured, data can be received through email, SFTP, or API, and reconciliation can be scheduled to run automatically when the required files are available.
Is the reconciliation report downloadable?
Yes. Users can download Excel reconciliation reports that include matched, partially matched, unmatched, and skipped records for internal review and audit support.
