Magicpin Orders & Charges Reconciliation

Magicpin orders and charges reconciliation helps finance teams verify that every order, payment, commission, discount, packing charge, and settlement is recorded correctly. For restaurants, retail stores, and other businesses that sell through Magicpin, this work is important for accurate revenue recognition, charge verification, and month-end close.

Cointab replaces spreadsheet-heavy review with a reusable reconciliation workflow. Teams upload their records, map the required fields once, run reconciliation, and review matched and unmatched transactions in a structured report.

Why Magicpin reconciliation matters

Magicpin-linked sales often involve more than just order value and payout value. Finance teams also need to check whether platform charges and related adjustments have been applied correctly.

Typical items that need review include:

• Orders captured in the internal POS or order system
• Magicpin order or annexure reports
• Settlement or payout reports
• Commission charges
• Discount adjustments
• Packing charges
• Pending or delayed payments
• Cancelled or missing records

When these records are compared manually in Excel, it becomes easy to miss differences, repeat work each period, or rely on formulas that are difficult to audit later.

How Cointab handles the reconciliation workflow

Cointab uses a Side A and Side B model.

• Side A contains your internal records, such as POS orders, sales exports, or store-level reports.
• Side B contains external Magicpin-side records, such as order, settlement, and charge files.

Once the files are uploaded, teams map the relevant columns such as date, amount, order ID, settlement ID, or another business reference. Supporting files can also be added when a lookup or enrichment step is needed before reconciliation.

Common data used in a Magicpin reconciliation

If required, teams can also create derived columns to calculate cleaned identifiers, expected charges, or net values from existing fields.

What gets matched and verified

A Magicpin reconciliation can be configured to compare several related business values, not just the order amount.

Order and payment verification

Cointab compares the internal order record against the external Magicpin record to identify:

• Fully matched orders
• Orders with short payment or excess payment
• Orders with pending payment
• Orders that appear in one report but not the other
• Cancelled orders that do not have a corresponding external status

Commission charge verification

Finance teams can compare the expected commission against the charge reflected in the Magicpin data. The expected value can be calculated using the business rules configured for that reconciliation.

This helps identify:

• Commission correctly charged
• Commission overcharged
• Commission undercharged
• Commission not charged
• Commission not verified because of missing data

Discount verification

Discounts can be checked against the applicable order-level or promotion-level logic. This is useful when the business wants to confirm whether the discount applied in the report matches the actual business rule.

Packing charge verification

Packing charges can also be compared where the internal and external reports both contain the relevant data. This helps teams spot undercharges, overcharges, or records that need review.

How exceptions are classified

Cointab separates reconciliation results into clear buckets so finance teams can focus on exceptions instead of reviewing every row manually.

• Fully matched: identifiers and amounts align according to the configured rules
• Partially matched: identifiers match, but the amounts differ
• Unmatched: a record appears on one side but not the other
• Skipped: a record was excluded because it was incomplete, invalid, duplicated, or otherwise not usable for the configured run

This structure makes it easier to review differences in order payments, settlement values, and charge calculations without losing visibility into the reason a record was excluded.

Structured matching, then AI-assisted review

Cointab first applies structured reconciliation logic. This can handle matching rules such as one-to-one, one-to-many, many-to-one, and grouped comparisons where the business data requires it.

After the structured rules run, AI can help review difficult open items where the evidence is not obvious. In practice, this is useful for:

• Slightly different descriptions or references
• Missing identifiers
• Partner-specific naming differences
• Complex charge or settlement scenarios
• Open transactions that need reasoning before review

If the evidence is not strong enough, the item remains unmatched rather than being weakly forced into a match.

Manual review and report refresh

When an item cannot be matched automatically, users can manually review it and match it if the totals and business context support that decision. This is helpful for one-off exceptions or incomplete partner data.

If a required Magicpin-side file arrives late, the missed file can be added to the same reconciliation and the report can be refreshed. That makes the workflow practical for real finance operations, where partner data often comes in at different times.

Reusable setup for recurring periods

A major advantage of Cointab is that the reconciliation does not need to be rebuilt every month.

Once the Magicpin workflow is configured, teams can reuse it for future periods by simply:

1. Selecting the reconciliation
2. Choosing the period
3. Uploading the latest files
4. Running reconciliation
5. Reviewing the updated report

This reduces repeat setup work and keeps the process consistent across periods.

Automation for recurring Magicpin reconciliation

For teams that reconcile Magicpin data regularly, Cointab can support automated data input and scheduled runs through email, SFTP, or API integrations.

That means the workflow can be used for more than just manual file uploads. A team can set up the reconciliation once and then let the platform handle recurring data flow, validation, run execution, and report generation.

This is especially useful when finance teams need:

• Daily or weekly reconciliation checks
• Faster month-end close support
• Regular order and charge verification
• Shared access across finance and operations teams
• Audit-ready reporting for internal review

Audit-ready outputs

After the reconciliation run is complete, users can review the dashboard and download Excel reports for matched, partially matched, unmatched, and skipped records.

These outputs help teams track:

• Which orders were settled correctly
• Which records need follow-up
• Which charges were overapplied or underapplied
• Which transactions still require manual review
• What changed from one period to the next

Because the setup is reusable, the same report structure can be used consistently across reporting periods.

A better way to manage Magicpin order and charge reconciliation

For businesses that rely on Magicpin, reconciliation is not just about matching orders. It is about verifying the full financial picture across sales, settlements, commissions, discounts, and packing charges.

Cointab gives finance teams a structured way to compare internal records with external Magicpin data, isolate exceptions, and maintain audit-friendly reconciliation reports without rebuilding the process every month.