Reconciliation template catalogue
Every reconciliation Sawwi runs out of the box. Each template knows the files it needs, how to match them and what to check. Don't see yours? Start a custom two-file reconciliation and save it as your own template.
Marketplace seller
Settlement vs. sales invoices
Check every invoiced order was paid out by the marketplace, net of the fees you agreed to.
Every settlement · 2 files · connector: Business Central
B2B invoices vs. payment release
Track B2B marketplace invoices through to payment release: short pays, held amounts and reserves.
Weekly · 2 files · connector: Business Central
Returns vs. invoiced items
Match customer returns and failed deliveries to the invoice line. Check you got the item back, issued the right credit, and the right amount was deducted.
Weekly · 3 files
Commission & fees vs. rate card
Recalculate referral, closing, fulfilment and shipping fees from your rate card and flag overcharges.
Every settlement · 3 files
Fulfilment-centre inventory reconciliation
Check stock you sent to marketplace fulfilment (FBA/FBN-style) against what they received, sold, returned, lost or damaged.
Monthly · 3 files
Damage & lost claims vs. reimbursements
Track every claim you raised (SAFE-T style, lost in transit, damaged returns) until it's paid.
Weekly · 2 files
Advertising deductions vs. campaign invoices
Make sure ad spend deducted from your payouts matches the campaign invoices and the budgets you approved.
Monthly · 2 files
Marketplace VAT reconciliation
Check output VAT on your sales and input VAT on marketplace fee invoices before you file your VAT return.
Monthly · 3 files
Own webstore
Orders vs. payment gateway settlements
Match paid webstore orders to gateway settlements. Separate out MDR fees, refunds and chargebacks.
Daily · 2 files · connector: Shopify, Magento 2
COD delivered vs. courier remittance
Make sure every cash-on-delivery order the courier delivered was remitted to you, in full and on time.
Weekly · 3 files · connector: Shopify, Magento 2
BNPL settlements vs. orders
Reconcile Tabby / Tamara-style settlements: orders captured, refunds, merchant fees and payout batches.
Weekly · 2 files · connector: Shopify, Magento 2
Courier freight invoice vs. shipments
Check courier invoices against your shipments and contracted rates: weight disputes, zone errors, duplicate AWBs.
Monthly · 3 files · connector: Magento 2
Refunds issued vs. returns received
Make sure every refund you paid out has a returned item, or an approved reason to have none.
Weekly · 2 files · connector: Magento 2
Store invoices vs. ERP posted invoices
Check every invoiced webstore order reached your ERP once, as a posted invoice with the same total, VAT and customer.
Weekly · 2 files · connector: Magento 2, Business Central
Store refunds vs. ERP credit notes
Check every refund your webstore issued was posted in your ERP once, as a credit note for the same amount and VAT.
Weekly · 2 files · connector: Magento 2, Business Central
Store stock vs. ERP inventory
Compare what your webstore offers for sale per SKU with the inventory your ERP holds: catch overselling and stock hidden from shoppers.
Daily · 2 files · connector: Magento 2, Business Central
Store prices vs. ERP prices
Check each SKU's webstore price against your ERP's price, and catch special prices left running past their end date.
Weekly · 2 files · connector: Magento 2, Business Central
Multi-currency store invoices vs. ERP
For each store view and currency, check the ERP booked every invoice in the right currency and at the base value Magento recorded, within an FX tolerance.
Monthly · 2 files · connector: Magento 2, Business Central
Gift cards and store credit roll-forward
Adobe Commerce: check each gift card and store credit balance rolls forward (opening + issued − redeemed − expired = closing) against order redemptions.
Monthly · 3 files · connector: Magento 2
Payouts & bank
Bank statement vs. expected payouts
Match every payout you expect from marketplaces, gateways, BNPL providers and couriers to actual bank credits, including FX differences.
Weekly · 2 files
Webstore sales by payment method vs. payouts and bank
Total webstore sales per payment provider (card, PayPal, Apple Pay, Tabby, COD), check each paid out what you sold, and that every payout reached the bank.
Monthly · 3 files · connector: Magento 2
Direct B2B sales
Customer payments vs. open invoices
Apply each business customer's payment to the invoices it settles. Flag short payments, overpayments and receipts nobody has applied.
Daily · 2 files · connector: Business Central
Customer ledger vs. customer statement
Compare your ledger for a customer with their statement or balance confirmation, and explain every difference in the closing balance.
Monthly · 2 files
Sales orders vs. deliveries vs. invoices
Three-way order-to-cash check: everything delivered was invoiced, and nothing was invoiced that wasn't delivered.
Weekly · 3 files · connector: Business Central
Invoiced prices vs. customer price list
Check every invoice line against the customer's agreed price, discount and validity dates.
Monthly · 2 files · connector: Business Central
Customer returns vs. credit notes
Make sure every goods return from a business customer has the right credit note, and every credit note has a return or an approved reason.
Monthly · 2 files · connector: Business Central
Post-dated cheques vs. bank clearing
Track every PDC from receipt to clearing: due but not deposited, bounced, or cleared for a different amount.
Weekly · 2 files
Purchasing & suppliers
Purchase orders vs. goods received vs. supplier invoices
Three-way match before you pay a supplier: only pay for what you ordered, at the PO price, and actually received.
Weekly · 3 files · connector: Business Central
Supplier ledger vs. supplier statement
Compare your payables ledger for a supplier with their statement of account, and explain the balance difference before you pay.
Monthly · 2 files
Import shipments vs. customs & freight bills
Tie each import shipment's supplier invoice to its customs declaration and forwarder bills, so duty, import VAT and freight land on the right stock.
Monthly · 3 files
Bring last month's exports and see what's missing.
Setup takes two minutes. Or try the demo store with invented data first, no sign-up.
Create your workspace