OdooWiki OCA HUB

PayPal CSV Format Bank Statements Import

account_bank_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 13.0

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

This module lets you bring PayPal CSV reports into Odoo as bank statements, so PayPal transactions appear in your accounting without manual entry.

  • When importing a bank statement, a new field "PayPal mapping" appears on the import screen. You pick a mapping and Odoo reads the PayPal file with it.
  • A menu "PayPal Report Mappings" (under Accounting) lists the mappings. Several ready-made ones are provided: PayPal Statement and PayPal Activity in English, Spanish and German.
  • Each mapping defines the number separators (thousands and decimals), the date and time formats, and which CSV column holds each piece of data (date, time, timezone, name, currency, gross, fee, balance, transaction ID, description, type, emails, invoice ID, subject, note, bank name, bank account).
  • A wizard helps you create a new mapping: upload a PayPal file, Odoo reads its header and proposes the columns; you can adjust them from drop-down lists and save the mapping.
  • During import, only rows matching the journal currency are kept. Dates and times are converted to UTC, with common PayPal timezone codes recognised. Each line becomes a transaction; when a fee exists, a separate fee transaction is created. The statement's opening balance is computed from the first line, and the closing balance from the last line.
  • Accountants can read mappings; only accounting managers can create, change or delete them.

Depends on

account_bank_statement_importmulti_step_wizardweb_widget_dropdown_dynamic

Menus it adds

PayPal Report Mappings
Models and fields (5)
  • account.journal · extends an existing model
  • account.bank.statement.import · extends an existing modelpaypal_mapping_id (PayPal mapping)
  • account.bank.statement.import.paypal.parser · new model
  • account.bank.statement.import.paypal.mapping · new modelname, tz_column ("Timezone" column), fee_column ("Fee" column), date_column ("Date" column), date_format (Date Format), name_column ("Name" column), note_column ("Note" column), time_column ("Time" column), time_format (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.bank.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 13.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: 2 confirmed, 7 with no information of 9 versions.

Sources · Odoo 13.0

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

terminal Installation and usage

OCA documentation · Odoo 13.0

Configuration

Source · Odoo 13.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 13.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.