Odoo Payment Settlements: Explain Gross Sales, Fees and Deposits
Short answer: reconcile provider payments by connecting individual transactions to the provider’s settlement and then to the bank deposit. Gross customer payments, fees, refunds and timing differences can make those amounts differ legitimately. Identify the cause of each difference before clearing it through an accounting adjustment.
Applies to
Odoo 19 payment providers and Accounting reconciliation. Provider reports, settlement behaviour and accounting treatment depend on the selected service and business configuration. The corresponding Odoo 20 references were reviewed in October 2026; use the documentation for your installed release when configuring screens and fields.
Which records belong in the chain?
Start with the customer document and payment transaction reference. Then identify the provider settlement or payout containing that transaction and the corresponding bank movement. Each record answers a different question about the movement of money.
Odoo’s payment provider documentation distinguishes enabling an online provider from adding bank accounts for reconciliation. A functioning checkout connection does not automatically establish a complete settlement accounting process. Review both arrangements with the finance owner.
I would agree the reference fields used to join the evidence. Customer names and rounded amounts are weak identifiers when several transactions look similar. Preserve the provider transaction and payout references through the approved reporting or integration process.
Why can the payout differ from sales?
A settlement may combine several payments and deduct charges or adjustments. Refunds and different processing dates can also affect the amount. The exact composition comes from the provider’s evidence, not from a universal formula that applies to every service.
Keep timing differences distinct from missing money. A transaction accepted today may appear in a later payout under the provider arrangement. Record the period and expected settlement status so that the team can identify genuinely overdue items without repeatedly investigating normal timing.
Review currencies separately where applicable. The customer transaction, provider settlement and bank account may not all use the same currency. Finance should approve the exchange and fee treatment rather than treating every numerical difference as a platform charge.
What should the reconciliation explain?
Build a bridge from the included transactions to the settlement amount and then the bank deposit. Each deduction or adjustment should have a reference and accepted classification. The bridge should balance from evidence, not from an unexplained residual posted to a convenient account.
Identify transactions missing from one side. A payment visible at the provider but absent in Odoo can require integration investigation. A transaction in Odoo without confirmed external completion may need a different review. Do not force both cases through the same correction.
Use Odoo’s reconciliation tools according to the configured accounting process. Automation can help with repeatable matches, but the reviewer remains responsible for uncertain differences. A matching suggestion is not proof that two similar amounts represent the same event.
Worked example: one payout contains sales and refunds
Imagine an online retailer receiving a single bank deposit for several customer payments. The provider statement also includes a refund and service charges. Comparing the deposit directly with the day’s gross sales produces a difference that appears unexplained.
Finance identifies the payout reference and its included transactions. It traces the refund to the original customer case and confirms the charges from the provider evidence. A payment processed near the cutoff belongs to a later settlement and remains separately tracked.
The resulting accounting treatment follows the approved configuration. The team can explain the bank amount without labelling the entire difference as a fee. It also retains the later settlement item rather than accidentally writing it off during reconciliation.
How should unresolved items be managed?
Keep an exception list with transaction or payout reference, amount, currency, cause under review and owner. Distinguish items awaiting normal settlement from those needing provider or integration support. The next action should be specific enough that another reviewer can continue it.
Avoid duplicate corrections. If the technical team restores a missing transaction while finance creates a manual workaround, the combined result can overstate payment. Coordinate the recovery decision and record which action is authoritative.
Review refunds and disputes through their own evidence. A customer refund instruction, provider acceptance and final settlement adjustment can occur at different times. The reconciliation should explain the actual status rather than treating a support ticket marked resolved as financial completion.
When does a detailed settlement process fit?
It fits businesses receiving grouped payouts or handling meaningful online payment volume. It becomes particularly valuable with refunds, several currencies or multiple providers. The process can be simple when the evidence is consistent and the transaction volume is small.
It does not require inventing a custom integration immediately. A controlled provider export and a clear review may be sufficient initially. Automate only after the reference mapping and exception treatment are understood well enough to be reproduced reliably.
Review provider capability and current terms when the service changes. Odoo documents different features across providers, including refund and capture support. Do not assume a workflow accepted for one provider transfers unchanged to another.
Common mistakes
Common mistakes include matching gross sales directly to net deposits, posting every difference as a fee and using customer names as the only reference. Another is allowing technical recovery and manual accounting corrections to proceed independently.
Close a settlement when the transaction bridge, provider evidence and bank record agree under the approved accounting treatment. Keep unresolved items visible with owners. That gives finance a defensible explanation of the money received and helps support teams investigate customer questions without guessing from a bank balance.
Related
Read Odoo POS Refunds: Reconcile the Return, Payment and Stock for the connected workflow.
Official references
How this article was checked: official Odoo 19 documentation and the corresponding Odoo 20 pages were reviewed in October 2026. The examples are illustrative, not client results or tests on a live database.
For help designing this workflow, see my Odoo consulting services.
? Frequently asked questions
Does a successful online payment equal a bank deposit?
No. A provider can settle several transactions together, deduct fees or apply other adjustments. Match the provider evidence with the bank and accounting records.
Should every payout difference be posted as a fee?
No. Investigate refunds, timing, reserves and unmatched transactions before applying the finance approved treatment for the actual cause.