POS ↔ Bank Reconciliation

Drop the POS response.json and bank .xlsx statements here, or Choose files

Advanced settings

Exact window (min) Search window (min) Amount tolerance Date-only slack (days) Include bank rows with no branch (single-branch exports only)

Card terminals without a branch

A terminal is the card machine ID printed on the bank statement. QNB statements do not say which branch a terminal sits in, so each one must be mapped once. Confident suggestions are applied automatically; for the rest, pick a branch and the reconciliation re-runs on its own. The percentage is how many of the terminal's non-round amounts were found in that branch's POS receipts on the same day.

Source	Terminal	Rows	Total EGP	Dates	Suggested branch	Branch

Only branches with open items

Branch	Name	POS card	Bank rows	Matched	Review	POS only	POS only EGP	Bank only	Bank only EGP	Status

Exact Confirmed Review POS only Bank only Voided

Status	Date	POS time	Receipt	Type	Card	Cash	Δ min	Bank	Bank time	Amount	Net	Auth · card	Score

Load a POS export and at least one bank statement, then run the reconciliation.