Excel and CSV file reconciliation
How it works
Upload the files
Bank statement, POS report, payment gateway export or any Excel or CSV with transactions. Upload two or more.
Confirm the columns
The tool suggests the reference, amount and date of each file. Change them if needed and adjust the tolerances.
Review and download
See how many movements match, which ones differ and which are missing from a file. The report comes as Excel and PDF.
Frequently asked questions
Are my files uploaded to a server?
No. Reading and reconciling happen in your browser. Data is only sent if you ask for the report by email, and then it is the summary and exceptions, not the original files.
Which file formats does the reconciliation accept?
CSV with comma, semicolon, tab or pipe separators, and Excel workbooks in XLS or XLSX. Each file can be up to 10 MB and 50,000 rows.
How many files can I reconcile at once?
Up to eight. For example, POS sales, the gateway report and the bank statement in a single run. A movement is matched when it appears in every file with the same amount.
What if several rows in one file correspond to a single deposit?
When matching by reference, rows that share a reference are added up. Three sales of the same batch are compared against the batch deposit. When matching by amount and date, the tool looks for groups of rows that add up to a single movement of the other file.
How do I reconcile files with no common reference?
Match by amount and date. Each movement is paired with the one with the same amount and the closest date within the tolerance you set, and if both files carry a time you can also limit the minutes of difference.
How are card terminal and gateway commissions handled?
Tell the tool whether each file's amount is gross or net and, if there is one, which column holds the commission. It compares on net when any file is a bank deposit and deducts each movement's commission. If you set the expected commission, it also flags charges that do not match it.
What does the cause of each difference mean?
Each difference is classified as commission, rounding below one unit, duplicated row, date or time offset, or unexplained. When nearly all differences are the same percentage, the tool tells you the likely commission.
How much does it cost?
It is free and needs no sign-up. If you want to automate this reconciliation every day with your systems, Quantum can implement it.
Reconciling the same thing every day?
Quantum automates payment reconciliation across your banks, gateways and ERP, and keeps every difference traceable.