Bank statements
For each of the bank accounts, one can download different types of bank statements, each with their specific content and usage.
| Type | Format | Advantage | Main usage | Periodical | Source | Archiving | Folder |
|---|---|---|---|---|---|---|---|
| Excel statements | Excel | Easy overview
All you need for income and expense |
Legacy
Follow-up of transactions (easy) Reporting |
Ad hoc
Daily Quarterly |
Download | By year | ledger |
| CAMT.053 statements | XML | Can be imported in bookkeeping program
Drag and drop to Excel for further reporting |
Query and reporting
Review income and expenses Auditing |
Ad hoc
Daily Quarterly |
Download | By year | XML-raw |
| PDF statements | Platform neutral; read-only | Non-repudation
Long-term archiving |
Quarterly | Rekeninguittreksels | By quarter |
You can download PDF extracts via:
Overzicht → Self Service → Downloads → Rekeninguittreksels
Archiving
[edit]Archive the above files by bank account. To be kept in G-Suite.
Retention period: you need to keep bank statements, and invoices for 10 years.
Excel files are handy for reporting.