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?
- 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.
- 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.
- 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.
- 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:
- Check that a bank account (account 512) exists; if not, create the bank manually in the company settings.
- Open Saisie, then Imports, then Importer un fichier, and choose the Transactions bancaires type.
- Choose the format, then map the file's columns to Pennylane's fields: transaction date, label, and amount (or debit and credit).
- 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
Related
- Open any e-invoice. Check it. Convert it.
- Klarbon help centre
- Convert a CAMT.053, MT940 or OFX bank statement to Excel
- Convert a CAMT.053, MT940 or OFX bank statement to CSV
- Convert a bank statement PDF to CAMT.053
- Convert a bank statement PDF to MT940
- Why do my statement balances not match?
- Import bank statements into DATEV
- Import bank statements into Lexware Office
- Import bank statements into sevdesk
- Import bank statements into Moneybird
- Import bank statements into e-Boekhouden.nl