Goldmary
Create a free account Sign in
MenuClose

Import a bank statement and match payments

What you need

When you have followed this manual, your customers' payments sit on their invoices and you did not retype a single amount.

  • A statement of your business account as CAMT.053 (XML), MT940 or CSV. You download it in your bank's online banking.
  • Invoices that are still open.

Steps

  1. Open Invoices, click Payments and choose Import bank statement. Click Choose file and pick the statement you downloaded from your bank.

  2. Each line of the statement is a row with its status and next step. If an open invoice fits an amount you received, the row says Invoice found, with the invoice and the amount still open. If one booked receipt fits a debit exactly (same total, within five days) and fits no other line, that debit is already linked to the receipt. If more than one fits, the row says Receipt found. The other invoices or receipts are in the row's More menu.

  3. If the invoice is right, click Link. If the payment belongs to another invoice, pick it in the row's More menu. The row then says Linked. Do this for every line that belongs to an invoice.

Afterwards

The linked invoices are marked paid, or part paid with the amount still open. A payment on an invoice is only saved when you click Link. A debit that fits exactly one receipt is already on that receipt.

Import a new statement every month or every quarter. That keeps your list of open invoices right.

If you get stuck

My file is not read

Download the statement again from your bank, as CAMT.053 (XML), MT940 or CSV. A PDF of your statement does not work.

I cannot find Import statement any more

Under Money, the Import statement button only shows until your first statement. After that you find it under Invoices, Payments, as Import bank statement.

A payment has no invoice next to it

Then the payment fits no open invoice. Add the payment to the invoice by hand, in the Payment block.

More detail

Markdown · All manuals