Auto Reconciliation Tool

# Auto Reconciliation Tool

A CLI tool that compares ERP system invoice amount with bank transaction amounts and generates report. Auto Reconciliation Tool is a lightweight, powerful Java CLI tool designed for finance teams, freelancers, accountants, and business owners who want to match bank transactions with ERP invoices—accurately and automatically.

🔧 What It Does

• Reads two CSV files:
  📁 One from your ERP system (like QuickBooks, Zoho Books, Tally, etc.)
  📁 Another from your bank statement (HDFC, ICICI, Axis, SBI, etc.)
• Automatically matches transactions based on:
  • Invoice Numbers / Reference IDs
  • Payment Amounts
  • Custom Field Mapping (--map argument)
• Generates a detailed reconciliation report (reconciliation_report.csv) with statuses:
  • ✅ Paid
  • 🔁 Underpaid
  • 💸 Overpaid
  • ❌ Not Paid

## Usage

bash

java -jar recon-tool.jar --erp <erp.csv> --bank <bank.csv> --map "ERPField1:BankField1,ERPField2:BankField2..."

Example: java -jar recon-tool.jar --erp erp.csv --bank bank.csv --map "InvoiceNo:Narration,InvoiceAmount:Deposit"

Arguments

| Argument | Description |

| ------------ | --------------------------------------

| --erp | Input ERP statement csv file

| --bank | Input bank statement csv file

| --map | Input header names from both CSV files which need to be compared

🎯 Who It’s For

• Startups and SMBs
• Freelancers tracking client payments
• Chartered Accountants / Bookkeepers
• Internal finance departments of growing businesses
• Anyone reconciling ERP and bank data manually

💡 Features

• No installation needed — just run the JAR
• Works on Linux, Windows, Mac
• Fully offline – no data leaves your machine
• Customize which fields to compare with simple --map option
• Fast and handles thousands of records in seconds

📦 What’s Included

• ✅ Executable JAR file (recon-tool.jar)
• ✅ Sample ERP and Bank CSV files
• ✅ README with instructions
• ✅ Free email support for 7 days

🚀 Instant Delivery

You'll get a ZIP file with everything you need, right after purchase.