Import your bank statements into Odoo Community from CSV, Excel or OFX: columns found by their headers, every transaction checked, duplicates skipped, partners matched, rules for the counterpart account.
No reviews yet0 salesby TAQNIXUpdated Oct 23, 2026
Your bank gives you a file and you type its lines into Odoo Community. Bank Statement Import brings them in from CSV, Excel or OFX.
58 automated tests: CSV, Excel and OFX files, headers and number and date formats, duplicates, partners, rules, statements and balances, access rights.
Illustrated guide in English and Arabic and an Arabic translation of the module.
Odoo 19.0 Community with Invoicing.
The files in the archive you can download after you buy.
No reviews yet. Bought this item? Be the first to review it.
Install and use it in a few lines.
wizard = env['taqnix.bank.import'].create({'journal_id': journal.id, 'file': base64_content, 'filename': 'bank.csv'})
wizard.action_read()
wizard.action_import()Setup, settings and troubleshooting, written by the author.
Every release, newest first.
CSV (comma, semicolon or tab separated), Excel (.xlsx, .xls) and OFX (.ofx, .qfx). Other formats such as MT940, CAMT or QIF are not read.
By their headers (Date, Description, Amount, Debit, Credit, Reference, Name...) in English and Arabic. If yours are different, type their names and read the file again.
Nothing is added twice. OFX transactions are recognised by their bank identifier; CSV and Excel ones by their date, amount and label, including those typed by hand.
Yes. Import rules look for a text or an expression in the label, the partner or the reference and set the partner and the counterpart account, so the transaction is posted to the right account at once.
No. Odoo Community has no bank reconciliation screen. The transactions are posted to the suspense account, or to the account of a rule.
Optionally, with the starting and the ending balance: those of the OFX file, or computed from the last statement of the journal. You can change them before importing.
Yes: Excel dates, day or month first, decimal commas, thousand separators, brackets and trailing minus signs are all understood.
Yes. Arabic headers are recognised, everything is translated and works right to left, and the documentation is in Arabic too.
Calculate end-of-service gratuity in Odoo Community with a policy you configure: tiers by years of service, a cap, the share by reason of leaving, unpaid leave, leave pay, and a printable statement.
Run petty cash funds in Odoo Community: expense vouchers with receipts and an approval limit, payment with the entry, replenishment up to the float, a cash book and printable vouchers.
Track who holds which company item in Odoo Community: handover and return slips with condition, overdue reminders, a Custody tab and a clearance sheet on the employee.
Import journal entries from Excel or CSV into Odoo Community: accounts, partners, analytic, each entry checked for balance, drafts or posted, with a history and an undo.
Run petty cash funds in Odoo Community: expense vouchers with receipts and an approval limit, payment with the entry, replenishment up to the float, a cash book and printable vouchers.
Import journal entries from Excel or CSV into Odoo Community: accounts, partners, analytic, each entry checked for balance, drafts or posted, with a history and an undo.
Print payment, receipt and journal vouchers from Odoo Community: the amount in words in English or Arabic, the invoices settled, the payment details and the signature boxes.
The aged receivable and aged payable reports for Odoo Community: each customer or vendor by age of the open balance, the invoices behind each figure, as of any date.
Bank Statement Import for Odoo 19 Community – CSV, Excel and OFX with Duplicate Check and Rules
$79.00