Accounting: Accounting Workflows: Importing Bank Statements
This document covers importing your Bank Statements in Odoo 14 within the Accounting app. Importing your bank statements allows you to keep track of financial movements that take place on your accounts and allows the reconciliation of them with the transactions recorded within your accounting. For higher efficiency, we recommend using the Bank Synchronization feature; however, if your bank is not a supported institution or you don't want to use synchronization, Odoo still gives you a couple of options.
To get started, navigate to the Accounting app.
Importing Bank Statements
The first option is simply importing the statements supplied to you by your bank. Odoo supports several file formats to import your statements:
SEPA recommended Cash Management format (CAMT .053)
Comma-separated Values (.CSV)
Open Financial Exchange (.OFX)
Belgium: Coded Statement of Account (.CODA)
The following modal will open, allowing you to select your file. Click UPLOAD when ready.
If you click + Formatting Options, a table of formatting options appears. Once configured to your preference, click IMPORT.
Creating Bank Statements
This window allows us to Add a line to manually enter each entry from the original bank statement.
Tip: To ease the reconciliation process, selec an entry in the Partner field, if you have it. It is also recommended to write payment references in the Label field.
Reference: Enter a reference name for your Statement.
Journal: The assigned Journal for this Bank.
Date: Assign a date to the Bank Statement
Company: If in a single company environment, this will be set by default.
Starting Balance: Beginning balance of journal before transactions are input.
Ending Balance: Balance after transactions are calculated. The ending balance and the Computed Balance should be the same.
Now you can click validate to finalize the process.
Once the entries have been validated, the NEW status will be replaced by one that reads VALIDATED, and you can now click the Journal Entries smart button to see the entries made on the bank statement.