Steps
- In QuickBooks Online, run the Transaction Report for the statement period and export it to Excel or CSV.
- Download the statement PDF from online banking.
- Drop both files here and choose which takes precedence: usually the statement.
- Work through Missing from QuickBooks, Only in QuickBooks and Amount differs until the difference is zero.
How lines are matched
Same amount within seven days, preferring the closest date and the most similar description; check numbers break ties. Grouped deposits and split payments are matched next. Lines with the same date and description but a different amount are shown side by side as an amount difference rather than as two unrelated lines.
Files are read inside your browser tab. Nothing is uploaded, no account is needed, and nothing is saved: closing the tab clears everything. The processing code is open source.
Questions
Which QuickBooks report should I export?
The Transaction Report (Reports, then Transaction Report), exported to Excel or CSV for the statement's dates plus a week either side. A report that covers several accounts is split by account automatically.
What if QuickBooks shows a charge as positive and the statement as negative?
When one record uses the opposite sign convention the tool detects it, flips the amounts to match, and tells you it did.
Does it handle deposits that were batched?
Yes. A single bank deposit that equals several QuickBooks lines (or the reverse) is matched as a group of up to five lines within the date window.
Are my statements uploaded anywhere?
No. The files are read by code running in your browser tab. There is no server that receives them, no account and no storage; closing the tab clears them. You can check the code, which is open source.
Is it free?
Yes. There is no sign-up and no limit on the number of files.