Skip to content

Import bank statements into Pennylane

Pennylane imports CSV, XLS, OFX and EBICS files, not PDF. Turn a CAMT.053, MT940 or CODA statement into a Pennylane CSV, free, or OFX, and test it first.

No file to hand? Try a sample statement

Pennylane imports bank statements manually from CSV, XLS, OFX and EBICS files (CFONB and CAMT), not from a PDF. Klarbon turns a CAMT.053, MT940, CODA or other supported statement into a CSV with Pennylane's settings, free, or into OFX, once the balances add up. Klarbon has no Pennylane integration and has not tested the import, so run a test import with one short statement first.

On this page 11

Which formats does Pennylane accept?

For manual bank transaction import in the Accounting interface, Pennylane's help centre lists CSV, XLS, OFX and EBICS (CFONB and CAMT) (Pennylane, in French). PDF is not among them. If you use the Management interface, follow the separate article (in French).

Klarbon output Accepted by Pennylane according to its help Notes
CSV (convert a bank statement to CSV) yes free from a statement file; map the columns during import
OFX yes test with one short statement
CFONB 120 CFONB is listed under EBICS Klarbon writes it in beta; test first
CAMT.053 CAMT is listed under EBICS test first; Klarbon writes camt.053.001.02
XLSX (convert a bank statement to Excel) XLS is listed, not XLSX do not assume XLSX works
MT940 not listed avoid for Pennylane

This table reflects Pennylane's documentation on 21 November 2026; it does not prove that a given file will be accepted.

Does a PDF uploaded as a receipt import the transactions?

Pennylane's help centre describes no such route. Transactions reach the Transactions module through the bank connection, a Transactions bancaires import, or by hand. Pennylane also says not to use the Écritures type for a statement, because it creates miscellaneous entries that do not appear in the Transactions module (Pennylane).

How do I prepare the file with Klarbon?

  1. Drop the statement file on this page or on convert a bank statement to CSV: CAMT.053, MT940 or OFX from your online banking, or another supported file such as CODA or CFONB 120.
  2. Check the preview: period, number of transactions and the balance check. A statement that does not add up cannot be downloaded. See the balance check.
  3. Choose the format. If you choose Pennylane as your accounting software, Klarbon suggests OFX first. For CSV, Klarbon writes one signed amount column, negative for debits and without a euro sign, a form Pennylane's help describes as accepted. The separator is a semicolon, the decimal mark a comma and dates are DD/MM/YYYY.
  4. Download the file. The CSV is free; OFX, CAMT.053 and CFONB 120 cost one credit per started 500 transactions.

Reading statement files is in beta. A PDF statement or scan can be dropped on the same tool too: you see every row before paying, a download from it costs one credit per started 10 pages, and what Klarbon reads from a PDF is a draft to compare with the original.

How do I import the file into Pennylane?

According to Pennylane's help centre, in the Accounting interface:

  1. Check that a bank account (account 512) exists; if not, create the bank manually in the company settings.
  2. Open Saisie, then Imports, then Importer un fichier, and choose the Transactions bancaires type.
  3. Choose the format, then map the file's columns to Pennylane's fields: transaction date, label, and amount (or debit and credit).
  4. Select the bank, review the data and finish the import.

You can save the mapping for later statements.

How do I test before importing everything?

Start with one short statement. After the import, compare the number of lines, the dates and the signs of the amounts with the original. A CSV or XLS import does not update the bank balance Pennylane shows; with OFX, CFONB or CAMT, also compare the closing balance if the file carries one (Pennylane, in French). Common causes of errors listed by Pennylane are a wrong date format, signs in the debit or credit columns, amounts that are not numbers (for example with a euro sign) and non-empty cells that were not mapped.

A wrong mapping cannot be fixed in bulk: delete the import, correct the file and import it again.

How do I avoid duplicates?

Do not import a period the bank connection has already synchronised. Pennylane presents manual import mainly as a way to get older history than the synchronisation provides, or accounts at a bank without automatic feeds (Pennylane). If your bank offers a CSV, OFX or CAMT export for the period you need, you can import it directly.

Does Klarbon work with Pennylane?

No. Klarbon has no integration or partnership with Pennylane. It makes a file; you import it. Klarbon creates no archive of the statement or its transactions. A PDF is read for your request only, and the reading may take place outside the EU. See what happens to my files.

Next

Frequently asked questions

How do I import a bank statement into Pennylane?

Import a CSV, XLS, OFX or EBICS file under Saisie, Imports, with the Transactions bancaires import type. Pennylane does not import a PDF. Klarbon turns a CAMT.053, MT940 or CODA statement into a Pennylane CSV, free, or into OFX, after checking the balances.

Which statement formats does Pennylane accept?

According to its help centre, CSV, XLS, OFX and EBICS (CFONB and CAMT) for manual bank transaction import in the Accounting interface.

Does uploading a statement PDF as a receipt import the transactions?

Pennylane's help centre describes no such route. Transactions reach the Transactions module through the bank connection, a Transactions bancaires import, or by hand.

Can I use an XLSX file from Klarbon in Pennylane?

Pennylane's help lists XLS, not XLSX. Do not assume XLSX works; test it with one short statement, or use CSV or OFX.

Does the Pennylane interface change the import?

Yes. Pennylane describes separate procedures for the Accounting and Management interfaces. Follow the article for yours.

Sources

Updated 21 November 2026

Klarbon, https://klarbon.app/pennylane-bank-statement-import