Recon-Master

Recon-Master — Smart Reconciliation Tool for ExcelStop matching invoices and payments by hand. Let Excel do the reconciliation — including the cases your accounting system gives up on.Recon-Master is a clean, reusable Excel workbook that automatically matches open items between two data sets: payments vs. invoices, invoices vs. credit notes, or two different system exports (e.g., internal stock ledger vs. general ledger, bank vs. receivables).Built-in auto-clearing routines in major enterprise software (like SAP's F.13) constantly fail on tiny rounding differences or missing reference numbers. Recon-Master was built specifically to solve those frustrating edge cases.🚀 How it works — 3 Simple Steps Paste your data into the two input sheets (DATA_A and DATA_B). Set your rules (adjust cent tolerance, toggles, or combination limits) in the SETTINGS sheet. Click "Run reconciliation" (or press Ctrl+Shift+R). Results appear instantly, perfectly colour-coded by match type, with unmatched items cleanly isolated for your final review.🛠️ What's inside the package Macro Edition (.xlsm): The full-featured engine powered by VBA. It includes 3 sequential matching algorithms ensuring zero double-counting, cent/date tolerance adjustments, and N:1 combination matching. No-Macro Edition (.xlsx): A 100% formula-based version that calculates live and automatically. Perfect if your corporate IT policy heavily restricts macro-enabled files, or if you prefer working on Mac / Excel Online. Step-by-Step PDF User Guide: A quick, visual manual that walks you through data prep, troubleshooting, and optimization tips. Pre-loaded Sample Data: Built right into the sheets so you can hit the button and see the tool in action within 5 seconds of downloading. 🎯 Who is this for?Accountants, financial controllers, AP/AR clerks, auditors, and data analysts who spend hours every month chasing missing payments, hunting down invoice-vs-credit-note pairs, or manually checking bank statements row by row.🔒 Privacy by designNo installation, no external software, no subscription, and no data leaves your machine. The tool operates 100% offline inside Microsoft Excel, keeping your sensitive financial records completely secure.Delivered instantly as a ZIP archive containing: Recon-Master.xlsm, Recon-Master_NoMacro.xlsx, and Recon-Master_User_Guide.pdf.

Found on Devadex — the discovery index for independent software the big search engines bury. More from gumroad.

Report this listing