Skip to content
Cybooks CompleteE-commercePricingAccountantsLog inStart free
Start free

BlogProduct updates

Bank statements: import Excel, CAMT.053, MT940 and OFX

The bank statement import now reads Excel workbooks and CAMT.053, MT940 and OFX files as well as CSV. The bank formats arrive with their balances, no mapping.

By Christopher DosinFounder / CTO

1 min read

Contents

The bank statement import now reads more than CSV. It also takes an Excel workbook, an ISO 20022 CAMT.053 file, a SWIFT MT940 file and an OFX or QFX file.

The Cybooks dashboard with a company’s financial overview

What changed

  • Excel (.xlsx) goes through the same column mapping as a CSV file.
  • CAMT.053, MT940 and OFX need no mapping. They reach the statement review with the opening and closing balances the file states, in the file’s currency.
  • The file is recognised by what is inside it, not by its name.

Where to find it

Use the same bank statement import you use for CSV files today, and choose the file your bank gives you.

Read more about bank reconciliation in Cybooks.

Article by

Christopher Dosin

Founder / CTO

He wrote Running a Cyprus LTD Company because the same questions kept coming up in onboarding calls, support tickets, and conversations at events.

The answers existed, but they were scattered across tax circulars, government PDFs, and accountant briefings. The book brings them together in one place.

Keep learning

All articles