01 / Source▤
Storefront orders
Capture order totals, discounts, shipping charged, tax, cancellations and sales dates. Confirm how order status and refunds are transferred or imported into Odoo.
Control question: is the order population complete?
Odoo Ecommerce Accounting
Sales • Fees • Payouts
Odoo Ecommerce Accounting: Reconcile Sales, Fees & Payouts
Your storefront can show one sales total, a payment processor another number, and the bank a third. This practical guide shows how to trace the difference, keep gross sales separate from fees, and build a cleaner Odoo reconciliation process for an online business.
Built for US online sellers•Practical accounting controls•Connector-aware guidance
Settlement studio / batch 01
One payout. Several moving parts.
Illustrative processor settlementRECONCILE
Customer payments captured$12,400.00
Refunds + fees + adjustments−$1,372.00
Expected deposit$11,028.00
Illustrative amounts only. Actual settlements can contain timing differences, reserves, currency conversions, disputes and platform-specific adjustments.
Source
Storefront
Bridge
Clearing
Proof
Bank
⌁
The goal: reconcile the full transaction trail
Gross sales, deductions and bank deposits should tell one traceable story.
01 / The settlement puzzle
A bank deposit is not the same thing as sales revenue.
Payment platforms often send a net amount after deductions. If that net deposit is recorded as revenue without accounting for the underlying activity, sales, fees, refunds and customer balances can be misstated or harder to audit.
Use a documented flow that matches your store and processor setup. Odoo connector availability, fields and automatic posting behavior can vary by version, apps and configuration.
02 / Deductions−
Processor activity
Identify processing fees, marketplace commissions, refunds, chargebacks, reserve holds and other settlement adjustments using the processor's detailed report.
Control question: can every deduction be explained?
03 / Accounting⌘
Odoo records
Review invoices or sales entries, payment records, credit notes, fee expenses, clearing accounts, and any tax or inventory treatment relevant to the transaction.
Control question: do records represent gross activity?
04 / Evidence✓
Bank settlement
Match the net transfer to the relevant payout ID and bank line. Investigate timing, multiple deposits, currency conversion, reserves and unsettled amounts.
Control question: is the clearing balance supportable?
02 / Reconciliation blueprint
Build a six-step payout workflow your team can repeat.
The sequence below is a control framework, not a claim that every store integration automatically performs each step. Adjust it to your commerce platform, Odoo version, payment provider and accounting policy.
STEP 0101
Set the source of truth
Document where order, payment, refund, fee and payout data originate. Define the key ID for matching: order, transaction, batch, payout or settlement reference.
Output: source map + reconciliation key
STEP 0202
Record gross activity
Confirm how orders, discounts, shipping, tax, cancellations and refunds enter Odoo. Avoid using only the net cash deposit as the sales figure.
Output: complete sales population
STEP 0303
Map fees and deductions
Separate processing fees, marketplace commissions, refunds, chargebacks and reserve movements. Agree account mappings and retain support for material or unusual charges.
Output: explainable deductions
STEP 0404
Use a clearing approach
Where appropriate, route processor collections through a dedicated clearing account so the transfer to the bank clears the payout amount rather than netting all activity into sales.
Output: traceable settlement balance
STEP 0505
Match payout to bank
Match by payout ID and expected amount, then investigate differences such as reserves, timing, split transfers, currency exchange or unmatched transactions.
Output: cleared bank deposit
STEP 0606
Review the remaining balance
Review outstanding clearing items, refunds in transit, unsettled sales, disputed payments and reserve balances. Assign an owner and target date to every material exception.
Output: documented exceptions
03 / Interactive payout lab
Bridge gross activity to the expected deposit.
Enter totals from one payout statement. The tool calculates the expected net settlement and compares it with the bank deposit you received. Use one consistent date range and payout batch.
Control reminder
This is a simple reconciliation aid, not an automated accounting entry or tax calculation. Add any other documented adjustments to your own working paper.
Payout worksheet
Settlement bridge
Reconciliation result
Calculated expected payout
$11,028.00
Actual bank deposit$11,028.00
Unexplained difference$0.00
Difference relative to expected payout0.00%
The sample bank deposit matches the calculated payout. Save the processor statement and bank evidence with the reconciliation.
Formula used: gross collections − refunds − processing fees − platform fees − deducted chargebacks − reserves/other deductions. Add positive adjustments or other settlement lines to your working paper if applicable.
04 / Exception triage
Select the symptom. Follow the evidence.
Use this quick guide to decide where to look first. Avoid posting a plug entry before the processor report, Odoo records and bank line have been compared.
↗
Suggested investigation
Bank payout is lower than expected
Compare the payout statement with your calculation. Check for fees, refunds, disputes, reserve holds, split payouts, currency conversion, or a transaction that fell outside the date range.
Inspect first
Processor payout detail, payout ID, bank line, and the settlement date range.
Avoid
Booking the unexplained difference directly to sales or miscellaneous expense.
05 / Posting logic
Think in transaction layers—not one net deposit.
The exact journal entries depend on your Odoo configuration, integration and accounting policy, but the underlying questions are consistent. Each type of activity should have a clear home and an audit trail.
Transaction layer
What the accounting review should confirm
Orders and sales
Reconcile order count and total values, including discounts, cancellations, shipping charges and applicable tax. Confirm which records create invoices or sales journal entries in your workflow.
Customer payments
Confirm that receipts are recorded and linked to the right invoices or customer balances where relevant. Avoid creating a second payment entry if an integration already imported the transaction.
Processor / platform fees
Record supported deductions in the appropriate expense or clearing treatment under the business's accounting policy. Reconcile fee reports to the statement instead of estimating fees from a percentage.
Refunds and disputes
Link approved refunds to the original sale where possible, review credit-note treatment and trace the cash movement separately. Chargebacks may require tracking while a dispute is unresolved.
Payout and bank
Match the processor's net settlement to the bank line. Clear the relevant payment clearing account and document any residual amount, timing difference, reserve or currency conversion.
Inventory and tax
For businesses holding inventory, reconcile stock movement and cost of goods sold with the configured valuation method. Review sales tax mapping and filing obligations separately; a payout report alone is not a tax return.
This article provides operational accounting guidance, not legal or tax advice. Confirm state and local sales tax requirements with an appropriately qualified US tax professional.
06 / Close checklist
A month-end routine for ecommerce accounting.
Reconcile by settlement batch as the month progresses, then review the full clearing balance and open exceptions before closing the period.
Checklist progress0 of 8
07 / Common questions
Odoo ecommerce reconciliation FAQs
Practical answers to common accounting questions from growing online sellers.
Why is my Shopify or marketplace sales total different from the bank deposit?+
Bank deposits may be net of processor fees, marketplace commissions, refunds, chargebacks, reserves and adjustments. There may also be timing, currency or date-range differences. Compare the order and transaction reports to the settlement report, then match the payout ID to the bank statement.
Should I record only the net Stripe or PayPal payout as revenue in Odoo?+
Recording only the net payout as sales can hide fees, refunds and other activity. A documented workflow should capture gross sales and separately account for deductions and settlement. The exact entries depend on the integration, Odoo configuration and the company's accounting policy.
Can Odoo automatically import Shopify, Stripe, PayPal or marketplace transactions?+
Available connectors and supported data vary by Odoo version, the installed integration, provider changes and configuration. Before relying on automation, test which order, payment, fee, refund and payout fields transfer, how duplicates are prevented, and whether the imported records support the reconciliation controls you need.
What is a payment processor clearing account used for?+
A clearing account can help separate customer payment activity from the later bank transfer. The processor collection, deductions and net payout can be traced through the account, and the remaining balance should be explainable by unsettled transactions, reserves, timing or other supported items. Design the flow around the actual integration and accounting policy.
How often should an ecommerce business reconcile payouts?+
Choose a cadence based on transaction volume, payout frequency, dispute risk and close requirements. High-volume sellers often benefit from reconciling each payout or on a frequent schedule, then reviewing clearing balances, fees, refunds, sales tax and inventory-related balances at month-end.
Can outsourced Odoo accounting support help with ecommerce reconciliation?+
A remote accounting team can help reconcile sales and payout reports, review fee and refund treatment, investigate clearing-account balances, prepare close schedules and document exceptions. Scope should clarify who owns integration changes, operational decisions, tax advice and final review approvals.
Build a stronger close
Related Odoo accounting guides
Payment Reconciliation
Odoo Customer Payments Not Reconciled
Investigate unmatched receipts, open customer balances and reconciliation issues.
Read article →Credit Notes & Refunds
Odoo Credit Notes & Customer Refunds
Review refund processing, credit notes and customer balance controls.
Read article →US Sales Tax
Odoo Sales Tax Configuration & Reconciliation
Review tax mapping and investigate differences between reports and ledger balances.
Read article →Affordable remote Odoo accounting support
Keep ecommerce numbers clear—without automatically adding full-time overhead.
Accountrise supports US online sellers and growing businesses with Odoo accounting review, settlement reconciliation, fee and refund checks, clearing-account cleanup and month-end documentation. Bring in remote professional support for the workload you need, with defined responsibilities and evidence-backed controls.
Odoo accounting support starting at $12/hour
Final pricing depends on scope, transaction volume, complexity, integration setup and engagement requirements.