GetbeelDocs
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

  • 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).
  • Not needed if you connected your bank: transactions arrive on their own.

Steps

Open the upload

Open Reconciliation and choose Upload statement.

Choose the files

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

Set the currency

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

Upload

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

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.

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

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

MessageCauseFix
"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 acceptedExport from your bank as CSV, PDF or a bank format
"statement.pdf" is larger than 50MB.The file is larger than 50 MBDownload a shorter period
Could not process "statement.csv". Try again or contact support.The upload did not startTry again; if it happens again, contact support
Status FailedUnreadable file, or more than 50,000 transactionsSplit the file, then Retry from the row menu
The upload asks for a planReading and matching need an active planChoose a plan in Settings → Usage & billing
"Could not restart matching. Try again or contact support."Too many restarts todayTry again tomorrow

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

On this page