DEV Community

Oddshop
Oddshop

Posted on • Originally published at oddshop.work

Bank Transaction Reconciliation Tool

We just released Bank Transaction Reconciliation Tool — reconcile bank csv exports with quickbooks/xero transactions automatically.

What it does

This tool automates financial reconciliation for developers and small businesses. It compares exported bank statement CSVs with exported QuickBooks or Xero transaction data, flagging mismatches and generating a detailed report. Saves hours of manual spreadsheet work.

Features

  • Load and parse bank statement CSV exports
  • Load and parse QuickBooks/Xero transaction CSV exports
  • Fuzzy match transactions by date, amount, and description
  • Generate reconciliation report with matched and unmatched items
  • Export results to a clean, formatted CSV for review

Usage

reconcile --bank bank_statement.csv --ledger quickbooks_export.csv --output report.csv
Enter fullscreen mode Exit fullscreen mode

Requirements

Python 3.8+. Install dependencies:

pip install -r requirements.txt
Enter fullscreen mode Exit fullscreen mode

Get it

Download Bank Transaction Reconciliation Tool for $29 →

Buy once, use anywhere. ZIP includes the full script, README, and usage examples.


Originally published at oddshop.work
Built by OddShop — Python automation tools, one new release every week.

Top comments (0)