WooCommerce Bank Reconciliation - Match Orders, Payouts and Bank Deposits
Review WooCommerce orders, processor payout exports, and bank deposits in one local reconciliation workflow.
Try with sample files | View sample report
Problem statement
WooCommerce stores often record gross order totals while the actual cash arrives through Stripe, PayPal, manual bank transfer, or another processor payout. The bank only shows the final cash movement, so the safe workflow is usually orders to payout support to bank deposit.
Numeric example
| Line item | Amount |
|---|
| WooCommerce gross orders | $2,410.00 |
| Refunds | -$180.00 |
| Processor payout deductions | -$84.80 |
| Bank deposit under review | $2,145.20 |
Why the numbers do not match
- A payout can be lower than gross orders because refunds, explicit processor fee rows, reserves, or adjustments reduce the net movement.
- Multiple orders are often combined into one processor payout or bank deposit.
- Orders placed today may not appear in the bank for several days because the processor payout lands later.
- Mixed payment methods can require separate support files before the bank row is explained safely.
- Order totals alone do not prove the payout composition or the final bank movement.
What files to export
- WooCommerce orders export with order number, date, total, payment method, status, refund fields, and customer reference.
- Payment gateway payout report with payout IDs, payout status, deductions, grouped batches, and net payout rows.
- Bank statement CSV/XLSX with deposit date, amount, and raw bank description for the expected processor transfer.
Manual workflow
- Export WooCommerce orders for the reconciliation period.
- Export the matching processor payout report for the same period and payment method.
- Export the bank statement that covers the expected deposit dates.
- Separate orders by payment method before you start matching them to payouts or bank rows.
- Calculate expected payout support from gross orders, refunds, payout status, and any explicit payout deductions shown in the processor export.
- Match the expected payout to the bank entry by amount, date, and payout reference where available.
- Keep unclear gateway splits, grouped payouts, and weak-reference rows in review instead of forcing a final answer.
Common mistakes
- Comparing WooCommerce gross order totals directly to one bank deposit.
- Skipping the processor payout export and trying to explain the bank row from orders alone.
- Using exact fee wording when the export only proves a broader amount difference or payout adjustment.
- Forcing grouped payout support into a final one-to-one bank match.
How Reconcile Locally helps
- Separates matched rows, amount differences, unknown bank payments, and grouped-payment review cases in one local workflow.
- Keeps order, payout, and bank support visible together instead of spreading the review across several spreadsheets.
- Exports a report you can hand off before changing accounting entries.
What still needs manual review
- Grouped payouts still need a reviewer decision when one bank row can plausibly match several order bundles.
- WooCommerce stores with several gateways may need one more export before the bank row can be explained safely.
- Keep amount-difference or payout-adjustment wording unless the processor export explicitly proves the exact cause of the shortfall.
Content review and sources
Written and reviewed by the Reconcile Locally product team. Last reviewed June 7, 2026.
Guidance is checked against current product behavior and first-party documentation where available. Reconciliation results still require human review.
Frequently asked questions
Why do my WooCommerce orders not match bank deposits?
Because the bank usually receives the processor payout, not the gross WooCommerce order total. Refunds, payout deductions, grouped deposits, timing gaps, and mixed gateways all change what reaches the bank.
Which export usually explains the shortfall best?
Usually the processor payout export. WooCommerce orders explain gross sales, but payout IDs, payout status, grouped batches, and deductions usually explain why the bank amount is lower or delayed.
Can I reconcile WooCommerce orders without connecting my bank?
Yes. Reconcile Locally works with exported CSV/XLSX files only. Download your WooCommerce orders and bank statement, then reconcile locally in your browser.