OdooWiki OCA HUB

Online Bank Statements: PayPal.com

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

This module provides online bank statements from PayPal.com.

auto_awesome What this module does

AI-generated from the code · Odoo 19.0

Lets you pull your PayPal.com transaction history directly into Odoo as bank statements, so you can reconcile PayPal activity without downloading and uploading CSV files.

This module adds PayPal.com as a selectable source when you set up an online bank statement provider in Odoo Accounting. On the provider form, choosing PayPal reveals a Credentials section where you enter your PayPal Client ID and Secret (plus an API base for advanced users), and these fields become required for that service.

Once configured, Odoo connects to PayPal and retrieves transactions for the period you request, converting each one into statement lines with a reference, amount, date, payment reference and payer name. Transaction fees are imported as separate lines attributed to PayPal, and each line carries a unique import identifier so re-imports do not duplicate entries.

Business rules enforced by the code: - PayPal only allows access to transactions from the last 3 years; older start dates are refused with an explanatory error. - If no transactions exist for the period, the module reads the PayPal account balance and uses it as both opening and closing balance. - Opening and closing balances are calculated from the first and last transaction's available balance, so the statement balances correctly. - Authentication problems (wrong credentials, missing permissions, invalid token) raise clear error messages.

It extends the online.bank.statement.provider model and adds the PayPal option to the available services list. All activity happens through the existing online bank statement provider screen; no new menus are created.

Depends on

account_statement_import_online
Models and fields (1)
  • online.bank.statement.provider · extends an existing model

Text generated by AI (DeepSeek) from reading the Odoo 19.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: 6 confirmed, 3 with no information of 9 versions.

Sources · Odoo 17.0

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

terminal Installation and usage

OCA documentation · Odoo 19.0

Configuration

Source · Odoo 19.0

You will need a Client ID and Secret from PayPal to communicate with the PayPal API. To obtain your PayPal API Client ID and Secret:

  • Open PayPal Developer.
  • Login with your PayPal for Business account (upgrade your personal account to a Business Account, if required).
  • Go to Apps & Credentials and switch to Live.
  • Under REST API apps, click Create App to begin creating a new application.
  • Enter a descriptive name for your app (e.g. Odoo-Statements) and click Create App.
  • Copy the Client ID and Secret to use during provider configuration (instructions below).
  • Under Features, uncheck all optional features except Transaction Search.
  • Click Save Changes.

To configure PayPal as an online bank statement provider, you will need to create a Bank Account & Journal that corresponds to your PayPal for Business account, and then configure the PayPal.com provider with the Client ID and Secret obtained above:

  • Go to Invoicing \> Configuration \> Banks \> Add a Bank Account.
  • In the Account Number field, enter some descriptive text for the account, such as the email address or PayPal Merchant ID of your PayPal for Business account. NOTE: This Account Number is not used in the authentication with PayPal's API, and is only used to distinguish this PayPal Bank Account/Journal from others you may have configured.
  • Fill in the other fields for the Bank Account if desired, and then click Create.
  • Go to Invoicing \> Configuration \> Accounting \> Journals.
  • Open and Edit the Journal corresponding to the PayPal bank account (this Journal was created automatically when you created the Bank Account above.
  • Set Bank Feeds to Online (OCA).
  • Select PayPal.com as the provider in the Online Bank Statements (OCA) section.
  • Save the Journal.
  • To configure provider-specific settings, click on the provider to open it and click Edit.
  • Fill in your desired Configuration and Scheduled Pull settings.
  • Leave the API base field empty, and fill in the Client ID and Secret from your PayPal Developer account.
  • Click Save.

NOTE: For development and testing purposes, you can create Sandbox credentials associated with your PayPal for Business account. When configuring the provider-specific settings, enter the following in the API base field:

Usage

Source · Odoo 19.0

To pull historical bank statements:

  • Go to Invoicing \> Configuration \> Accounting \> Journals.
  • Open the Journal corresponding to the PayPal bank account.
  • Click the Pull Online Bank Statement button.
  • Configure a date interval and click Pull.

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.