Revolut Payment Gateway Fee Reconciliation

Revolut payment gateway fee reconciliation helps finance teams verify that transaction fees, taxes, settlement values, and bank credits match what should have been recorded. Instead of checking reports manually in Excel, Cointab gives teams a structured workflow to upload files, map fields, match transactions, review exceptions, and download audit-ready reports.

For finance teams handling payment reconciliation, the main challenge is not just finding a difference. It is understanding whether the difference came from fees, tax, settlements, refunds, timing gaps, or missing files. Cointab is built to make that review transparent and reusable.

What gets reconciled in a Revolut fee workflow

A Revolut payment gateway fee reconciliation usually compares your internal records with external payment and settlement records. The goal is to confirm that every transaction is accounted for correctly across fee, tax, and settlement views.

Typical records may include:

• Internal sales or payment records on Side A
• Revolut payment gateway reports on Side B
• Rate card or fee reference data
• Tax or GST-related reference data where applicable
• Settlement or payout reports
• Bank statements for settlement confirmation

Cointab uses the Side A and Side B model so your records stay separate from external records, making the reconciliation easier to review and audit.

Common checks in payment gateway fee reconciliation

Finance teams usually need to verify more than one number. A strong fee reconciliation should show where the issue sits and what needs follow-up.

Fee verification

Cointab can compare charged fees against expected fees derived from the configured rate card or business rules. This helps teams identify:

• Fees correctly charged
• Fees overcharged
• Fees undercharged

Tax verification

If tax is part of the reconciliation, Cointab can help teams compare recorded tax against the expected tax calculation logic. This makes it easier to spot:

• Tax correctly charged
• Tax overcharged
• Tax undercharged

Settlement verification

Settlement checks help confirm whether the expected payout amount matches the actual settlement reported by the gateway.

Common settlement checks include:

• Settlement UTR validation
• Settlement amount matching
• Settlement amount mismatch review

Bank settlement matching

Some teams also reconcile the settlement report against the bank statement to confirm that the payout actually reached the bank account.

That helps identify:

• Settled in bank account
• Not settled in bank account

How Cointab handles the workflow

Cointab follows a structured reconciliation process designed for finance teams that want control, traceability, and repeatability.

1. Upload the required files for Side A and Side B.
2. Map fields such as date, amount, and transaction or reference identifiers.
3. Optionally upload supporting data such as rate cards, lookup files, or enrichment files.
4. Create derived columns when the raw data needs cleaning or calculation.
5. Run the reconciliation manually or on a schedule.
6. Review the matched, partially matched, unmatched, and skipped transactions.
7. Download the Excel reconciliation report for internal review or audit support.

Because the setup is reusable, the same Revolut fee reconciliation can be run again for the next period without rebuilding the workflow.

Why supporting data matters

Fee reconciliation often depends on reference data that is not meant to be reconciled directly. Cointab supports supporting data to help prepare the main records before matching begins.

Examples include:

• Fee rate files
• Product or order master data
• GST or tax mapping files
• Settlement reference files
• Customer or merchant mapping files
• Order metadata or lookup files

Supporting data can help finance teams enrich missing fields, combine reports, or calculate net amounts before reconciliation.

Using derived columns for fee calculations

Many payment gateway fee workflows need calculated fields before matching can happen. Cointab lets users create derived columns using AI-generated Excel-style formulas.

That is useful when you want to:

• Calculate net settlement amounts
• Normalize transaction references
• Clean order IDs or UTRs
• Convert refund amounts into the right sign
• Compute fee or tax values from business rules

Derived columns are recalculated every time reconciliation runs, so the logic stays consistent across periods.

What the reconciliation report shows

After the run is complete, Cointab presents a report dashboard that helps finance teams focus on exceptions rather than rechecking every row.

The report includes:

• Total summary
• Fully matched transactions
• Partially matched transactions
• Unmatched transactions
• Skipped transactions
• Filters for deeper review
• Detailed transaction tables
• Downloadable Excel output

Fully matched

These are records where the reconciliation rules confirm that the amounts and identifiers align.

Partially matched

These are records where the system finds a related transaction, but the amounts do not fully match. This is useful for detecting undercharges, overcharges, rounding differences, deductions, or settlement gaps.

Unmatched

These are records present on one side but not found on the other side. For payment gateway fee work, unmatched items can indicate missing settlements, missing transaction records, or reporting gaps.

Skipped

Skipped records are visible in the report so teams can understand which rows were not included and why, such as incomplete data, invalid fields, or excluded rows.

AI assistance for difficult open items

After structured matching is complete, Cointab can use AI to help analyze open transactions where rules alone are not enough.

This can be useful for:

• Slightly different transaction descriptions
• Missing or partial identifiers
• Complex grouping scenarios
• Unclear fee differences
• Possible missing file situations

AI support is conservative and reviewable. If the evidence is weak, the transaction remains unmatched instead of being forced into a poor match.

Manual match for finance review

Some payment gateway exceptions need human judgment. Cointab provides a manual match option so finance teams can match transactions when the totals and business context make sense.

Manual match is useful when:

• The gateway report is incomplete
• A reference value is missing
• The exception requires business context
• The system cannot confidently match the records

Manual matches remain auditable and can be undone if needed.

Reuse and automation for recurring periods

Revolut fee reconciliation is often a recurring finance task. Cointab is built so teams can configure the workflow once and reuse it for future periods.

That supports:

• Monthly reconciliation
• Quarterly reconciliation
• Year-end review
• Lifetime or all-time reconciliation
• Custom settlement periods

Teams can also automate recurring data flow through email, SFTP, or API, and schedule reconciliation runs when required files are available. This reduces repeated manual uploads and helps keep reporting up to date.

Team-based review and audit readiness

Finance reconciliation is usually a shared process. Cointab supports team workspaces so multiple users can work in one account with roles, permissions, and shared history.

That helps teams keep track of:

• Who ran the reconciliation
• Which files were used
• What changed between runs
• Which exceptions remain open
• What has already been manually reviewed

The result is a cleaner audit trail and less dependency on scattered spreadsheets.

When this use case is most valuable

This reconciliation workflow is especially useful for finance teams that need to verify:

• Payment gateway fees
• Settlement deductions
• Taxes or charges linked to transactions
• Bank credits against settlement reports
• Unmatched or partially matched payment items

It is also useful when the team wants to move beyond one-off Excel checks and build a repeatable reconciliation process that can be reviewed, reused, and automated.

FAQs

What files are usually needed for Revolut payment gateway fee reconciliation?

Most workflows use internal transaction data on Side A and Revolut payment gateway or settlement reports on Side B. Teams may also add rate cards, tax reference files, or bank statements depending on what needs to be verified.

Can Cointab reconcile fees, taxes, and settlements in one workflow?

Yes. Cointab can be configured to compare fee values, tax values, settlement amounts, and bank credits within the same reconciliation setup, provided the required files and field mappings are available.

What happens if a file is missing?

If a file is missed, it can be uploaded under the same reconciliation and the report can be refreshed. This is useful when partner reports arrive late or in a separate file.

Can finance teams review exceptions manually?

Yes. Cointab separates matched, partially matched, unmatched, and skipped records, and it also supports manual match for exceptions that need business review.