Payment Allocation Assistant

Match payments to open invoices and credits, review, and export allocations to Excel

HTTPS encrypted · Files deleted after 24h · No sign-up required

Preview: this tool is being tested and is not listed yet.

Suggests how payments settle open invoices and credit notes, using references, customer, currency, amount and date. You review, change and confirm each one. Nothing posts to your accounting system.

Formats
Open items: CSV or Excel. Payments: CSV, Excel or a PDF remittance advice. Exports Excel.
Limits
Up to 5,000 rows and 20 MB per import. Currencies stay separate unless you give a rate and its date.
Your data
Processed in your browser. Nothing is uploaded. Your draft is saved on this device only.

Open invoices and credit notes

Credit notes can be negative, or marked by type.

ReferenceCustomer ID or nameDateCurrencyOriginal amountOutstanding balanceTypeActions
Nothing here yet.