AutoRecon
Free Invoice Payment Reconciliation Tool
Stop manually scanning invoice rows against bank deposits. Upload two CSV files, map the columns, and review suggested matches for exact payments, combined payments, ambiguous deposits, partial payments, and unmatched rows.
Upload, map, reconcile, export
CSV parsing and match scoring happen locally in this page. Field mapping is editable before the reconciliation run.
AutoRecon tool
Invoices CSV
Required: invoice number and amount.
No invoice file loaded.
Bank Transactions CSV
Required: transaction date and positive deposit amount.
No bank file loaded.
Invoice fields
Bank fields
Load both CSV files or use the sample data.
What the sample demonstrates
The built-in sample covers the match cases AutoRecon supports today.
| Case | What AutoRecon checks | Expected result group |
|---|---|---|
| Exact payment | Deposit amount equals invoice total and the description includes the invoice number. | Matched |
| Customer text match | Amount matches and the description overlaps with the customer name. | Review |
| Multiple invoices paid together | One payment equals the sum of two to five open invoices. | Matched or Review |
| Ambiguous same amount | Two invoices share the same amount and the bank text gives no invoice clue. | Review |
| Partial payment | Payment is below the invoice total but the invoice/customer text is strong. | Review |
| Unmatched rows | No suggestion reaches the confidence threshold. | Unmatched invoices or Unmatched payments |
Built for small CSV workflows
AutoRecon is for people reconciling roughly 30 to 200 invoices per month without a bank connection or accounting-system writeback.
Small business owners
Match customer deposits to open invoices before marking invoices paid in your bookkeeping process.
Freelancers
Review partial payments, combined client payments, and inconsistent payment references from CSV exports.
Bookkeepers
Handle client CSVs with different column names using editable field mapping and a plain results export.
How it works
The matching engine uses integer cents, text clues, date distance, and bounded combination search.
1. Load two CSV files
Upload invoices and bank transactions. Files over 5 MB or 10,000 rows are rejected with a clear error.
2. Confirm field mapping
AutoRecon guesses common headers, then lets you map invoice number, dates, customer, amount, and reference fields.
3. Review and export
Confirm, undo, or ignore suggested matches. Export a formula-injection-safe CSV when the review is done.
Supported formats and limits
AutoRecon is intentionally narrow so the first version stays transparent and easy to verify.
Invoices CSV
Map invoice number and amount. Customer, invoice date, and due date are optional but improve the match reasons.
Bank CSV
Map transaction date and amount or credit. Description/reference is optional but strongly recommended.
Amounts
Currency symbols, commas, and parenthesized negatives are supported. Only positive incoming payments are matched.
Not included
No PDF/OCR, Plaid, Open Banking, login, cloud storage, accounting writeback, tax advice, or audit opinion.
FAQ
Common questions about this free invoice reconciliation software.
Does AutoRecon upload my invoice or bank CSV files?
No. CSV parsing and matching run in your browser. The tool does not send file names, amounts, customer names, invoice numbers, or CSV contents to a server.
What columns are required?
Invoice CSV files need invoice number and amount. Bank CSV files need transaction date and amount. Customer, due date, invoice date, and payment description improve match quality.
Can it auto match payments to invoices when one payment covers several invoices?
Yes. AutoRecon searches for two to five invoices whose total equals a single positive bank payment, then shows confidence and reasons for review.
How does it handle partial payments?
If a payment is less than an invoice and the payment text strongly matches the invoice number or customer, AutoRecon marks it as partial and shows the remaining balance.
Why are some same-amount matches sent to Review?
When multiple invoices share the same amount and the payment text does not identify the invoice or customer, AutoRecon limits confidence and asks you to review the alternatives.
Can I use a credit column instead of a generic amount column?
Yes. Map the bank amount field to a credit or deposit column. The first version only matches positive incoming amounts.
Does AutoRecon connect to QuickBooks, Xero, Bill.com, or bank feeds?
No. This version only works with CSV uploads and a reconciliation CSV export. It does not write back to accounting systems.
What should I do with the export?
Use it as a review file for your own bookkeeping workflow. Confirm the results before marking invoices paid in another system.
Roadmap
These are possible future areas, not current capabilities.
PDF and OCR intake
Not available in v0.1.
Accounting exports
Dedicated QuickBooks, Xero, and Bill.com export formats are not available in v0.1.
Bank integrations
Plaid, Open Banking, and direct bank feeds are not available in v0.1.
Saved workspaces
There are no accounts or saved cloud sessions in v0.1.