English
Payments and Invoice Matching
Use Financial > Payments to import a customer or supplier ledger export. DirectPort records payments, links them to invoices, and updates balances automatically. After importing, a summary shows what changed and any differences to check.
This page records payments that have already taken place. For bank details printed on invoices, see Bank Accounts and Invoice Payment Details.
Before you start
- Select the company whose payments you are importing in the company switcher.
- Prepare one CSV, XLS, or XLSX file, up to 10 MB. Excel files must contain only one populated worksheet. Each import supports up to 20,000 rows and 80 columns.
- Prefer a complete customer or supplier history export with column headings, account references, names, dates, debit and credit amounts, journals, document numbers, and matching codes. Include opening balances and miscellaneous bookings when available.
- Check Administration > Tenant settings > Financial > Book year starts in. DirectPort uses this month to date imported opening balances.
- Invoices must be Approved or Posted, belong to the selected company, and use the payment's currency to receive allocations. Deleted invoices and credit notes do not receive payment allocations.
Import the export
- Open Financial > Payments.
- Drop the file into the upload area, or click to browse.
- Select Import.
- Keep the page open while DirectPort reads and reconciles the export.
The import applies automatically; there is no separate confirmation of suggested matches. A successful import opens its summary.
DirectPort identifies parties from their invoices, earlier imports, and names. An AI review checks unresolved accounts and invoice references. Accounts that cannot be linked to a known party are skipped.
Within linked accounts, the ledger's matching codes connect payments and invoices. One payment can cover several invoices, and partial payments leave the remaining amount open. A group settled through a credit note or write-off can also mark an invoice paid when the bank payment alone does not cover it.
Read the summary
The summary shows invoices paid, invoices still open, payments recorded, and parties linked. Check the listed disagreements, such as a different invoice amount or an invoice marked paid in DirectPort but still open in the ledger. It also shows skipped accounts, import notes, and corrections made by the AI review.
Select an invoice link to inspect the document. Use Done to return to Payments. You can reopen the summary from Imports > Summary.
Uploading the same imported file again opens its existing summary. In overlapping exports, previously recorded bank lines are not recorded twice. A later export can add links to invoices that were matched in the accounting ledger since the earlier import.
Find payments and source files
The Payments tab shows dates, counterparties, amounts, banks, linked invoices, unallocated amounts, and source files and rows. Select an invoice number to open it.
An invoice with linked payments shows their amounts, dates, and bank or journal. Select View to find a payment in Payments, then Show all payments to return to the full list.
The Imports tab keeps the source files, upload dates, and status. Use Download for the original file and Summary for the reconciliation results. Imported means the changes were applied; Not applied means they were not applied or were undone.
Allocate an unallocated payment
A payment linked to a known party can remain unallocated, for example a prepayment. Open that party's invoice to see available unallocated payments in the same currency and direction. Select Allocate to apply the available amount up to the invoice's remaining payment balance.
Use Remove beside an existing allocation to unlink it. Payments identified as settling the carried-forward opening balance are excluded from this list.
Verify party balances
Open Party balances, search by party name, and select a party to inspect its documents, unallocated payments, opening balances, and adjustments. Each currency has its own row.
Receivable is the customer balance, Payable is the supplier balance, and Saldo is receivable minus payable. Positive saldo is due to you; negative saldo is due to the party. Net zero means open amounts offset each other.
When the export provides opening balances, DirectPort starts from them and adds documents, payments, and adjustments for the period. Earlier documents included in the opening balance are excluded from that period's calculation. Linked payments count toward the party balance even when they have not been allocated to an invoice.
Matches compares DirectPort's balance with the ledger's closing balance on the export's closing date. A difference is shown as Δ. Use the ledger filter to find parties whose balances differ. Select Refresh to reload the latest amounts.
Undo an import
Select Undo import in the summary or Imports tab, then confirm. Undo removes the payments and allocations recorded by that import, reverts its invoice paid changes and updates to earlier payments, and removes its new ledger balances. If the import replaced earlier opening balances or adjustments, those earlier values are restored.
If a later import used the earlier import's payments or replaced its ledger balances, undo that later import first. For example, undo February's overlapping export before undoing January's. You can upload a file again after undoing its import.
Delete individual payments
Use a payment's ⋮ > Delete menu, or select rows and choose Delete selected. Deletion removes invoice allocations. Mark linked invoices unpaid is on by default; clear it only if those invoices should remain marked paid.
Deleting individual payments leaves the original import marked Imported. Use Undo import when you need to reverse the whole import, including its ledger balances.
Troubleshooting
| Problem | What to check |
|---|---|
| I am asked to select a company | Choose an individual company in the company switcher. |
| The file is rejected | Check its format, size, row and column limits, and that it has one populated worksheet. |
| No payments are found | Check that the export includes bank movements or invoice lines with readable headings. |
| An account was skipped | Check whether its party exists in DirectPort and whether its name and invoice references identify it clearly. |
| An invoice remains open | Inspect the summary, invoice amount, currency, status, references, and matching code in the ledger. |
| Party balances differ from the ledger | Check missing documents, credit notes, adjustments, and the book year start month. |
| Undo asks me to undo another import first | Undo the later dependent import, then retry. |
For help with a discrepancy, contact support and include the source export and import summary.
