Loading this page.
Loading this page.
Upload your AR subledger (CSV), invoice by invoice, and the GL control account extract (CSV). F20 ties the two and flags what does not tie: unapplied cash and credit balances sitting on the control account, deductions and short payments, and write-offs the subledger was never expected to mirror.
Free AR reconciliation tool: tie receipts to open invoices and surface short payments, part payments and unapplied cash. Upload the file this page names, review the result in the browser, and download CSV or Excel when offered.
Ties customer receipts to open invoices through the shared matching ladder, using whether a row carries an invoice number to tell an invoice-level line from an aggregate receipt — the same distinction a credit controller draws by eye. Its rules cover cash application, unapplied cash, bad-debt write-offs and short or partial payments as their own categories, not as one generic mismatch, before rolling into a reconciliation score.
Upload receipts and the AR ageing. The tool tells invoice-level lines from aggregate receipts, then classifies unapplied cash, write-offs and short or partial payments as their own categories.
Open the page, drop receipts and the AR ageing, and read the result in the browser. Download CSV or Excel when the tool offers those exports.
Yes. There is no charge and no account required. Every tool on F20 FinanceOps runs without signing in. A run made without an account is not recorded.
No. Uploaded files are processed in memory and dropped when the response is sent. Nothing is written to disk. They are never stored.
Have receipts and the AR ageing. The tool tells invoice-level lines from aggregate receipts, so you do not need to pre-split a batch deposit by hand.
Work unapplied cash, short payments and part payments as their own categories. Then run the unapplied-cash analyzer if receipts are still sitting, or age the ledger if overdue is the next question.
AR rec ties cash that came in to invoices that are still open. Classification is rule-based. Unapplied cash is a finding to work, not a posting this page will make.