Apply every customer payment to the right invoices
Load the money your customers paid and your list of open invoices. AI Customer Payment Match applies each receipt to the invoices it pays, says why in plain English, finds part-payments, short-payments and overpayments, sends anything doubtful to you to check, and ages what is still owed. Your files never leave this device.
Your files can't leave this page. Here's how you can check.
- Your browser blocks it. This page carries a security rule (
connect-src 'none') that stops it from sending data to any server, ours included. The browser enforces it, not us. - Test it yourself. Once this page has loaded, turn off Wi-Fi or unplug the network. AI Customer Payment Match keeps working, because everything happens on your computer.
- No outside code. Every script on this page, including the AI, comes from appiqfinance.com. There are no trackers and no analytics on this page.
- The AI runs here too. The AI model is downloaded to your browser and works on your computer. It only reads the receipt descriptions and customer names in your files.
- It never connects to your bank. You download the files yourself and load them here. Nothing is posted back to your accounting system either: you post the results yourself.
1Load your two files
Your receipts (a bank statement, or a receipts or cash book export) and your open customer invoices (an AR open items or aged debtors export).
Paste the key from your purchase email. It's checked on this device; nothing is sent. No key yet? Buy AI Customer Payment Match Pro.
Receipts
Bank statement or receipts export: CSV, Excel (.xlsx), OFX/QFX, CAMT.053 (XML) or MT940. Only money in is used.
Open invoices
AR open items: invoice number, customer, invoice date, amount open, and the due date if you have it. CSV or Excel (.xlsx).
2Check what we read
We worked out the columns, dates and amounts. Check the first lines look right, then apply.
Matching settingsoptional
A receipt that is short of an invoice by no more than the larger of the two tolerances (and never more than a tenth of the invoice) is flagged as a short-payment for you to check: usually a settlement discount or a bank charge. A bigger gap is a part-payment.
3Your receipts applied
Chase what is still open
The open invoices list, aged by due date, shows exactly who to call first. Download it as Excel and work through it oldest first.
About AI Customer Payment MatchReconcile the same bank statement
AI Bank Match pairs every line of your bank statement with your ledger, explains each match and gives every leftover line a likely reason. On your device.
Try AI Bank Match