Bank Statement Import: Novapay (XLSX)
by Kitworks Systems| Odoo Apps Dependencies | account, base |
| Community Apps Dependencies | Show |
| Technical Name | kw_bank_statement_novapay_xlsx |
| License | OPL-1 |
| Website | https://kitworks.systems/ |
| Versions | 17.0 18.0 19.0 |
What this module does
Imports NovaPay XLSX statement exports into account.bank.statement.line, including a synthetic transaction for the file’s commission row. Bank website: https://www.novapay.ua/.
XLSX file import
Reads NovaPay XLSX exports via openpyxl in read-only data-only mode. Transactions live between row 12 and the trailer (last two rows). Files shorter than 15 rows raise UserError.
Auto-extracts commission row
Builds a synthetic negative line for NovaPay’s Ukrainian-locale commission row (counterparty Novapay, dedup key COMM-<date>-<amount>) so reconciliation includes the fee.
Field mapping
Date (col 2), amount (col 3, kept as exported), description (col 7), internal reference (col 8), payment ref (col 12). NovaPay exports do not split counterparty IBAN / EDRPOU / MFO — only the description is available as the counterparty name.
Deduplication
Dedup key built as <journal_id>-<internal_ref>. Re-importing the same file silently skips already-stored lines.
Imported transactions list filtered by the NovaPay journal.
Other banks in the Bank Statement Suite
12 more bank statement imports for Ukrainian banks and software vendors.
Need help?
Kitworks Systems supports the Bank Statement Suite. Reach out for installation help, bug reports or custom bank integrations.
info@kitworks.systems