Bank Statement & Receipt Reconciliation Automation
Budget: €8 – €30 EUR
We have:
One XLS file with all bank transactions.
One XLS file with all receipts/invoices (coming from two already working flows).
Goal
Create an automated process (n8n workflow or small script) that:
Reads both XLS files.
Normalizes date and amount formats in both datasets.
Performs an exact match on (date, amount) between bank transactions and receipts.
Produces one output XLSX with 6 columns, all rows sorted by date:
Bank side: Bank Date | Bank Description | Bank Amount
Receipt side: Receipt Date | Receipt Description | Receipt Amount
For rows where there is an exact match (date + amount), put bank and receipt on the same row, and mark the row as OK in green (e.g., green row background or an extra “Status = OK” column).
Where there is no match, leave the opposite side empty (so I can reconcile manually later).
Deliverables:
Working n8n workflow or standalone script (Python preferred) + instructions on how to run it on my machine.
Example input files + one sample output file showing matched and unmatched rows.
One XLS file with all bank transactions.
One XLS file with all receipts/invoices (coming from two already working flows).
Goal
Create an automated process (n8n workflow or small script) that:
Reads both XLS files.
Normalizes date and amount formats in both datasets.
Performs an exact match on (date, amount) between bank transactions and receipts.
Produces one output XLSX with 6 columns, all rows sorted by date:
Bank side: Bank Date | Bank Description | Bank Amount
Receipt side: Receipt Date | Receipt Description | Receipt Amount
For rows where there is an exact match (date + amount), put bank and receipt on the same row, and mark the row as OK in green (e.g., green row background or an extra “Status = OK” column).
Where there is no match, leave the opposite side empty (so I can reconcile manually later).
Deliverables:
Working n8n workflow or standalone script (Python preferred) + instructions on how to run it on my machine.
Example input files + one sample output file showing matched and unmatched rows.