OdooWiki OCA HUB

PayPal CSV Format Bank Statements Import

account_statement_import_paypal folder_open OCA/bank-statement-import open_in_new
Accounting License: AGPL-3

This module allows you to import the PayPal CSV files in Odoo as bank statements.

auto_awesome What this module does

AI-generated from the code · Odoo 17.0

Import PayPal CSV reports (Statement or Activity) as bank statements in Odoo, using ready-made or custom column mappings.

This module lets accountants import PayPal CSV files directly into Odoo bank statements, instead of typing transactions by hand.

  • In the bank statement import screen, a new field "PayPal mapping" appears, and "PayPal Reports" is added to the list of supported import formats on the journal.
  • A new menu "PayPal Report Mappings" (under the Accounting menu) stores mapping templates that tell Odoo which CSV column holds the date, time, timezone, name, currency, gross amount, fee, balance, transaction ID, description, type, emails, invoice ID, subject, note, bank name and bank account.
  • Ready-made mappings are provided for English, Spanish and German PayPal Statement and Activity exports, including the correct date format and decimal/thousands separators.
  • A multi-step wizard lets you upload a PayPal file, reads its header, and pre-fills the column choices; you can adjust them and save the result as a new mapping.
  • When importing, only rows matching the journal currency are kept. Dates and times are converted to UTC, and common timezone codes such as PST/PDT and CET/CEST are recognised.
  • Each PayPal transaction becomes a statement line; when a fee is present, a separate fee line is created. The opening balance is computed from the first line, and the closing balance from the last line.
  • The module touches account.journal, account.statement.import and adds the mapping, parser and wizard models.

Depends on

account_statement_import_filemulti_step_wizardweb_widget_dropdown_dynamic

Menus it adds

PayPal Report Mappings
Models and fields (5)
  • account.journal · extends an existing model
  • account.statement.import · extends an existing modelpaypal_mapping_id (PayPal mapping)
  • account.statement.import.paypal.parser · new model
  • account.statement.import.paypal.mapping · new modelname, tz_column ("Timezone" column), fee_column ("Fee" column), date_column ("Date" column), date_format, name_column ("Name" column), note_column ("Note" column), time_column ("Time" column), time_format, type_column ("Type" column), gross_column ("Gross" column), balance_column ("Balance" column), subject_column ("Subject" column), currency_column ("Currency" column), bank_name_column ("Bank Name" column), float_decimal_sep (Decimals Separator), invoice_id_column ("Invoice ID" column), description_column ("Description" column), bank_account_column ("Bank Account" column), float_thousands_sep (Thousands Separator), transaction_id_column ("Transaction ID" column), to_email_address_column ("To Email Address" column), from_email_address_column ("From Email Address" column)
  • account.statement.import.paypal.mapping.wizard · new modelheader, filename, data_file (PayPal Report File), tz_column ("Timezone" column), fee_column ("Fee" column), date_column ("Date" column), name_column ("Name" column), note_column ("Note" column), time_column ("Time" column), type_column ("Type" column), gross_column ("Gross" column), balance_column ("Balance" column), subject_column ("Subject" column), currency_column ("Currency" column), bank_name_column ("Bank Name" column), invoice_id_column ("Invoice ID" column), description_column ("Description" column), bank_account_column ("Bank Account" column), transaction_id_column ("Transaction ID" column), to_email_address_column ("To Email Address" column), from_email_address_column ("From Email Address" column)

Text generated by AI (DeepSeek) from reading the Odoo 17.0 code on GitHub; it may contain mistakes, so check the code before deciding. View the code on GitHub

Availability by version

Reviewed: 2026-11-03
Confirmed (verified in repository and branch) Estimated (unverified) No information

Confirmation status: 3 confirmed, 6 with no information of 9 versions.

Sources · Odoo 15.0

Confirmed on 2026-11-03 in branch 15.0 of OCA/bank-statement-import.

terminal Installation and usage

OCA documentation · Odoo 17.0

Configuration

Source · Odoo 17.0

To adjust PayPal report columns mapping:

  • Open Invoicing \> Configuration \> Accounting \> PayPal Report Mappings
  • Modify mapping(s) according to your CSV reports format.

Usage

Source · Odoo 17.0

To import statements from PayPal via Statement report:

  • Go to PayPal
  • Open Statements and select Monthly or Custom
  • Select date range of interest and click Request under CSV column
  • Wait for statement report to be generated
  • Download it and save to a file
  • Go to Odoo and and import saved statement file, selecting corresponding format

To import statements from PayPal via Activity report:

  • Go to PayPal
  • Open Activity download
  • Set Transaction type to Balance affecting
  • Set Format to CSV
  • Select date range of interest and click Create report
  • Wait for activity report to be generated
  • Download it and save to a file
  • Go to Odoo and and import saved statement file, selecting corresponding format

No verified information in OCA: Installation.

info

Data imported from GitHub: this sheet reflects the latest catalog review, not a live lookup. Always check the module documentation and staging before installing in production.