How to Match WooCommerce Orders to the Money That Actually Reached Your Bank

WooCommerce Analytics says the store sold $9,800 in October, yet the business bank account shows noticeably less, spread across a dozen deposits that don’t line up with any single day of orders. Nothing is missing in most cases. Payment processors take their fees before paying out, group many orders into one transfer, and hold back refunds from later payouts, so the two numbers rarely agree on the first look.

This guide walks through a monthly routine for matching store orders to bank deposits, step by step. The routine starts with getting the bank side into rows and columns, since a PDF statement can’t be sorted or filtered. A Bank Statement Converter such as Bank File Tool handles that part, and the rest takes a spreadsheet and about an hour.

Why the Numbers Don’t Match at First

Before matching anything, it helps to know the usual reasons for the gap:

• Fees come out first. Stripe, PayPal and WooPayments deduct their processing fees before the money is sent, so the bank only ever sees the net amount.
• Payouts are batched. One bank deposit can cover orders from one day or from several, depending on the payout schedule.
• Timing crosses the month. Orders placed on October 30 and 31 often arrive in the bank in November.
• Refunds and disputes are netted. A refund issued this week is usually subtracted from the next payout, and a dispute can add a separate fee.
• Money can wait in a balance. PayPal funds sit in the PayPal account until they are transferred, unless automatic transfers are switched on.
• Several gateways share one account. A store that accepts cards through Stripe and wallets through PayPal gets two streams of deposits mixed together.

Each of these leaves a clear trace once the data sits side by side.

Step 1: Pull Three Reports for the Same Month

Pick one month and collect three files.

• Orders. In WooCommerce, go to Analytics, open the Orders report, set the date range and download it as CSV.
• Payouts. Stripe’s payout reconciliation report lists which charges, fees and refunds make up each payout. PayPal offers an activity download from the account’s reports section, and WooPayments lists every payout in its own dashboard.
• Bank statement. Download the PDF statement for the business account, plus the first week of the following month.

That extra week matters. It catches the payouts for orders placed in the last days of the month.

Step 2: Turn the Bank Statement Into Rows

Upload the statement to the Bank Statement Converter at Bank File Tool. It accepts PDF downloads from online banking, scanned paper statements and PNG or JPG photos, up to 25 MB per file. There is no template to set up, because it recognises each bank’s column order and layout on its own.

Every transaction comes out with the same fields: date, description, deposit, withdrawal and balance. The tool then adds up the transactions and compares the result with the opening and closing balances printed on the statement, and a matching result reads “Matches the statement.” Download the file as Excel or CSV and paste it into a new workbook next to the orders and payout reports.

Step 3: Filter Deposits by Gateway

Bank descriptions for processor deposits usually contain the processor’s name, such as STRIPE or PAYPAL. Add a column called Source and fill it with a simple formula or a quick find-and-replace, so every deposit is tagged as Stripe, PayPal, WooPayments or Other.

Sort by Source, then by date. Within a few seconds, a month of mixed deposits turns into short, clean lists, one per gateway. The Other group is worth a look on its own, since it holds bank transfers from wholesale customers and manual orders.

Step 4: Match Each Payout to Its Orders

Take one payout at a time and rebuild it from the orders behind it. The formula is simple: gross sales, minus processing fees, minus refunds and dispute amounts, equals the payout.

Take a worked example in which a Stripe payout covers 38 orders worth $2,450.00. At Stripe’s standard US rate of 2.9% plus 30 cents per charge, fees come to $71.05 plus $11.40, or $82.45. One customer was refunded $64.00 that week. The payout should therefore be $2,450.00 − $82.45 − $64.00 = $2,303.55, and that is the figure to look for on the bank side.

When the payout matches, mark it green and move on. After every payout has been checked once, only the unmarked rows are left to investigate.

Step 5: Chase What’s Left

The remaining differences almost always fall into one of these groups:

• A payout dated in the next month that belongs to this month’s orders.
• A dispute or chargeback taken from a payout, along with its fee.
• PayPal money still sitting in the PayPal balance.
• A currency conversion on an international order.
• A manual order paid by bank transfer, which shows up under Other rather than under a gateway.

Write a short note next to each one. Next month, the same notes will explain most of the gaps before they turn into questions.

Make It a Monthly Routine

The whole process gets faster with repetition. After two or three months, the Source column, the formulas and the sorting are all in place, and matching a month comes down to pasting in new data.

Bank File Tool’s free allowance fits this routine well. Anyone can convert up to 6 pages a day without an account, and a free account raises that to 10 pages a day, which covers a typical monthly business statement. Stores with several accounts or long statements can use a paid plan with 500 or more pages a month and convert a whole year in one sitting. Statements are parsed in real time with end-to-end encryption, and the company says uploaded files are never retained or shared.

Keep the Workbook, Not Just the Answer

Save each month’s workbook in one folder, named by year and month. By December, the folder holds a full record of what every gateway paid, what it charged in fees and how much went back to customers as refunds. That is also exactly what an accountant asks for at tax time.

A useful final check is to total the fees column for the year. Seen in one place, that number makes it much easier to judge whether a cheaper gateway or a different payout schedule is worth a look.