Reconciliation templates

A template is a complete reconciliation set-up to start from: its sides, the fields they are mapped onto, the matching passes in order, the checks that prove the result and, for some, reason codes. Starting from one copies it into a new reconciliation you then adapt in the designer: connect your own data sources, map your columns, and change anything else. Your workspace can add its own templates as well (Settings → Library); see Creating a reconciliation.

This list is generated from the product’s template library.

Start from scratch

Two datasets matched on a reference and an amount. Rename the sides, add the fields you need, then add passes, checks and rules.

Sides	2 — Side A · Side B
Fields	Date · Reference · Description · Amount
Matching passes, in order	Reference and amount
Checks	References and amounts present

Bank reconciliation

Bank statement against the cash book. Matches by reference, then by amount and date, then batched deposits and split payments, and proves the result with a bank reconciliation statement.

Sides	2 — Bank statement · Cash book
Fields	Date · Reference (cheque, UTR) · Narration · Amount · Balance
Matching passes, in order	Reference and amount Amount and date One deposit for several receipts Several entries for one book entry Amount within a week
Checks	Statement duplicates · Statement running balance · Bank reconciliation statement · Open items by age

Cash book integrity (single-sided)

One ledger or statement on its own: every balance follows from the previous one, no duplicates, nothing missing, large movements flagged.

Sides	1 — Cash book
Fields	Date · Voucher · Amount · Balance
Matching passes, in order	None: a single-sided check
Checks	Required values · Duplicate vouchers · Running balance · Large movements

Corporate card reconciliation

The card statement against expense claims. Matches by authorisation code, then amount, date and merchant, splits one charge across several claims, and catches claims made twice.

Sides	2 — Card statement · Expense claims
Fields	Transaction date · Authorisation code · Merchant · Cardholder · Amount
Matching passes, in order	Authorisation code Amount, date and merchant One charge split across claims Amount and date only
Checks	Claimed twice · Large charges · Statement and claims totals · Open items by age

Customer receipts against open invoices

Cash application: money received from customers against their open invoices. One receipt can pay several invoices, part payments stay open, and balances are compared per customer.

Sides	2 — Customer receipts · Open invoices
Fields	Date · Invoice number · Customer · Amount · Currency
Matching passes, in order	Invoice number quoted One receipt for several invoices Same customer and amount
Checks	Duplicate invoices · Balance per customer · Receivables by age
Reason codes	Customer paid less

Data checks (single-sided)

One dataset on its own: required values, duplicates and values outside a range. Each failing row is an exception to fix.

Sides	1 — Data
Fields	Reference · Date · Amount
Matching passes, in order	None: a single-sided check
Checks	Required values · Duplicates · Amount range

GSTR-2B against purchase register

Input tax credit: invoices on the GST portal (GSTR-2B) against your purchase register by supplier GSTIN and invoice number, with taxable value and IGST, CGST, SGST and cess compared. Shows credit you can take, credit at risk and invoices you have not recorded.

Sides	2 — GSTR-2B · Purchase register
Fields	Supplier GSTIN · Supplier name · Invoice number · Invoice date · Taxable value · IGST · CGST · SGST · Cess · Input tax credit
Matching passes, in order	GSTIN, invoice number and date GSTIN and invoice number, date differs Probable: GSTIN, tax and date, similar invoice number
Checks	Supplier GSTIN valid · Tax components · Invoice booked twice · Input tax credit · Credit per supplier

Intercompany transactions

One entity's receivable against the other entity's payable. Amounts are opposite in sign, matched within each currency and entity pair; differences show by counterparty.

Sides	2 — Entity books (receivable) · Counterparty books (payable)
Fields	Date · Intercompany reference · Counterparty · Amount · Currency
Matching passes, in order	Reference, opposite amount Same amount within a week Several entries against one
Checks	Balance per counterparty · References present · Open items by age

Online payments (four-way)

Orders, the payment gateway's settlement report, the bank statement and the ledger. Each order is traced to its gateway payment, the gateway's batch payout to the bank credit, and the bank credit to the ledger entry.

Sides	4 — Orders · Gateway settlements · Bank statement · Ledger
Fields	Date · Order number · Settlement ID / UTR · Amount
Matching passes, in order	Order to gateway Gateway payout to bank Gateway batch to bank by total Bank to ledger Bank to ledger by amount and date
Checks	Duplicate orders · Gateway and bank totals · Open items by age

Payment gateway settlements

Orders against the gateway's settlement report, then each settlement batch against the bank credit. Gateway fees make the bank amount smaller, so amounts agree within a percentage.

Sides	3 — Orders · Gateway settlement report · Bank statement
Fields	Date · Order or payment ID · Settlement batch · Amount · Fee
Matching passes, in order	Order to gateway payment Settlement batch to bank credit Batch total by date
Checks	Orders paid twice · Fees above 3% · Open items by age

Payroll against salary payments

The payroll register's net pay per employee against the salary payments from the bank, by employee and amount, with totals compared for the month.

Sides	2 — Payroll register · Salary payments
Fields	Pay date · Employee code · Employee name · Bank account · Net pay
Matching passes, in order	Employee code and net pay Bank account and net pay Name and net pay
Checks	Paid twice · Total net pay agrees · Employees without a bank account

Stock records against physical count

The stock ledger's quantities per item and location against a physical count or warehouse system. Several ledger lines per item roll up before matching; quantities may differ within a tolerance.

Sides	2 — Stock ledger · Physical count
Fields	Item code · Location · Item · Quantity · Value
Matching passes, in order	Item and quantity Item, quantity differs
Checks	Counted items have a code · Negative stock · Total units agree

Sub-ledger against general ledger

Each sub-ledger (receivables, payables, fixed assets, inventory) totalled per control account against the general ledger balance of that account.

Sides	2 — Sub-ledger · General ledger balances
Fields	Control account · Account name · Amount
Matching passes, in order	Account balance agrees Account balance differs
Checks	Accounts present · Totals agree

TDS: Form 26AS against books

Tax deducted by customers as Form 26AS shows it, against the TDS receivable in your books, per deductor (TAN) and quarter. Credit missing from 26AS is at risk.

Sides	2 — Form 26AS · TDS receivable in books
Fields	Date of deduction · Deductor TAN · Deductor · Reference · Section · TDS amount
Matching passes, in order	TAN, amount and date Several deductions, one entry Deductor name and amount
Checks	TAN present · Credit per deductor · Totals agree
Reason codes	Deducted but not in Form 26AS

Three-way match (PO, goods receipt, invoice)

Every purchase order line is received and invoiced: quantity received against quantity ordered, invoice against receipt, within tolerance. A line missing from any of the three stays open.

Sides	3 — Purchase orders · Goods receipts · Invoices
Fields	PO number · Item · Date · Supplier · Quantity · Value
Matching passes, in order	PO to receipts PO to receipt, quantity differs Receipt to invoice
Checks	PO lines present · Duplicate invoices · Open lines by age

Trades: front office and back office

Trades booked in the front office against the back office or custodian: trade by trade on ID with security, quantity, price, settlement date and counterparty compared, then positions per security and account.

Sides	2 — Front office · Back office
Fields	Trade ID · Trade date · Settlement date · Security (ISIN) · Account · Counterparty · Quantity · Price · Consideration
Matching passes, in order	Trade ID Security, account, quantity and trade date Position per security and account
Checks	Trade details present · Duplicate trade IDs · Quantity totals

Vendor statement reconciliation

A supplier's statement against your purchase ledger. Invoices and credit notes by document number, one payment against several invoices, and balances per supplier.

Sides	2 — Vendor statement · Purchase ledger
Fields	Document date · Document number · Supplier · Document type · Amount
Matching passes, in order	Document number and amount Payment against several invoices Several entries against one Amount and date, same supplier
Checks	Document numbers present · Duplicate documents in the ledger · Balance per supplier · Open items by age