# Import a bank statement and match payments

Source: https://goldmary.eu/en/manual/bank-statement

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

## What you need

- 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

- [Keeping business and private money apart](https://goldmary.eu/en/blog/separating-business-and-private-money)