POS reconciliationBETA

Match card sales from your ERP or POS system against the settlements your bank actually credited. Batches, settlement delays and bank fees are handled automatically. What can't be matched is listed for you to review.

Your files are read inside this page only. Nothing is uploaded.

Load your files

Excel (.xlsx, .xls) or CSV. Columns are detected automatically; correct them if needed.

Sales export from your ERP or POS

One row per card transaction, with at least a date and an amount.

or drop it here

Bank statement

The account where card settlements are credited.

or drop it here

No files to hand? to see how it works.

Set the matching rules

These are saved in this browser for next time.

Settlement delay (days)How many days after the sale the bank may credit it. Weekends and holidays often need 3–4.

Maximum bank fee deducted (%)Banks often credit the sale amount minus a merchant fee. Set to 0 if your bank credits gross amounts.

Rounding toleranceDifferences up to this amount count as an exact match.

Date format in your filesOnly matters for dates like 03/04/2026.

Bank lines to includeOptional. Only bank lines whose description contains one of these words are reconciled. Leave blank to use all credits.

Ignore debits on the statementRecommended. Payments out of the account can't be card settlements.

Auditing POS and card settlements?
Get the full POS and Card Settlements Audit Kit: step-by-step plan, Excel workbook and fillable PDF in English and Arabic.

Get the kit for USD 1

Load your files

Sales export from your ERP or POS

Bank statement

Set the matching rules

Review the results