# Statement upload (https://docs.getbeel.com/en/guide/bank-reconciliation/statement-upload)

Upload a bank statement (CSV, PDF, Excel, text, CBI, CAMT.053 or MT940): Getbeel reads the transactions and matches them to invoices.

Upload your bank statement and Getbeel reads its transactions, then matches them to your received invoices. CBI, CAMT.053 and MT940 bank files are read exactly, without AI.

## Before you start [#before-you-start]

- **The statement file**, downloaded from your online banking. Accepted formats:
  - **CBI** (_Rendicontazione movimenti_, the Italian transaction report), **CAMT.053** (XML) and **MT940**: read field by field, without AI.
  - **CSV**, **PDF** and **text**: read with AI.
  - **Spreadsheets** (XLS, XLSX, ODS): not read. Export the sheet as CSV and upload the CSV.
- **A file up to 50 MB.** You can upload several at once.
- **The Owner or Member role.** The **Accountant** cannot upload statements.
- **An active plan.** Reading and matching use AI ([Pricing](/en/api/pricing)).
- **Not needed** if you [connected your bank](/en/guide/collega-la-banca): transactions arrive on their own.

## Steps [#steps]

<Steps>
<Step>

### Open the upload [#open-the-upload]

Open **Reconciliation** and choose **Upload statement**.

</Step>
<Step>

### Choose the files [#choose-the-files]

Drop the files in the box or choose **browse**. You can add more before uploading; each file becomes a statement.

</Step>
<Step>

### Set the currency [#set-the-currency]

In **Statement currency**, choose the account's currency (euro by default). CBI, CAMT.053 and MT940 files already declare their currency.

</Step>
<Step>

### Upload [#upload]

Choose **Upload & process**. The statement moves from **Processing** to **Matching**, then to **Ready to review**. The page refreshes on its own.

</Step>
</Steps>

## What just happened [#what-just-happened]

- **You opened the upload** on the Reconciliation page.
- **Each file is a statement** in the list, with its name, period and number of transactions.
- **The currency** applies to transactions in files that do not state one.
- **Getbeel read the transactions** and looked for the invoice of each payment out. You can now [review the matches](/en/guide/bank-reconciliation/review-workflow).

## How bank files are read [#how-bank-files-are-read]

Getbeel recognises the format from the content, not from the file name.

- **CAMT.053**: ISO 20022 XML `BankToCustomerStatement`, versions 001.02 to 001.13.
- **CBI**: 120-character records, RH (transactions) or EC (statement) flow.
- **MT940**: SWIFT message with the tags `:20:`, `:25:`, `:60F:`, `:61:`, `:86:`, `:62F:`.

The opening balance plus the transactions must equal the file's closing balance. If it does not, a transaction was misread: Getbeel reads the file again with AI.

A file with more than 50,000 transactions is not imported. Split it by period.

## Manage statements [#manage-statements]

From each row's menu you can:

- **View statement** and **Download file**: the original file.
- **Rename**: change the name shown.
- **Redo matching** or, if it is **Failed**, **Retry**: reads the file again from scratch.
- **Delete**: removes the statement with its transactions and matches. It cannot be undone.

## If it fails [#if-it-fails]

| Message                                                                                                                 | Cause                                             | Fix                                                |
| ----------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------- | -------------------------------------------------- |
| "statement.xls" is a spreadsheet: Getbeel does not read Excel or ODS files. Export the sheet as CSV and upload the CSV. | The file is a spreadsheet (even if renamed)       | Export the sheet as CSV and upload the CSV         |
| "statement.zip" is not a supported statement file. Use CSV, PDF or text.                                                | Extension not accepted                            | Export from your bank as CSV, PDF or a bank format |
| "statement.pdf" is larger than 50MB.                                                                                    | The file is larger than 50 MB                     | Download a shorter period                          |
| Could not process "statement.csv". Try again or contact support.                                                        | The upload did not start                          | Try again; if it happens again, contact support    |
| Status **Failed**                                                                                                       | Unreadable file, or more than 50,000 transactions | Split the file, then **Retry** from the row menu   |
| The upload asks for a plan                                                                                              | Reading and matching need an active plan          | Choose a plan in **Settings → Usage & billing**    |
| "Could not restart matching. Try again or contact support."                                                             | Too many restarts today                           | Try again tomorrow                                 |

## Sources [#sources]

The exact readers follow the official specifications, cited in the code (`apps/web/lib/bank-statements/parsers`):

- **CBI**: CBI Consortium, "CBI-RND-001 Rendicontazioni – Standard tecnici" v6.05 (05-03-2013), §2.1–2.8. The official distribution is reserved to CBI members; the text was read from a public copy.
- **CAMT.053**: official schemas camt.053.001.02–.13 (iso20022.org, Message Definitions) and ISO 20022 MDR Part 2 "Bank-to-Customer Cash Management" 2020-2021 (§6.1.5.2, §6.1.9.2).
- **MT940**: SWIFT Standards MT, Category 9. The SWIFT manual is restricted and was not read directly: the field rules come from DK "DFÜ-Abkommen" Anlage 3 v3.7 (05.04.2023) §8, checked against ING's MT940/MT942 description (2016).

## Next steps [#next-steps]

<Cards>
  <Card
    title="Review workflow"
    href="/en/guide/bank-reconciliation/review-workflow"
  >
    Confirm the matches of the statement you just uploaded.
  </Card>
  <Card title="Connect your bank" href="/en/guide/collega-la-banca">
    Stop uploading files: transactions arrive every 6 hours.
  </Card>
  <Card title="Reconciliation via API" href="/en/api/bank-reconciliation">
    Upload statements from code or with `upload_bank_statement`.
  </Card>
</Cards>
