Skip to main content

How to reconcile a WithWine deposit with your orders

Filter the Orders screen by a deposit to see exactly which orders were paid into your bank account. The deposit is the WithWine card payments less WithWine fees.

When customers pay by card through WithWine, WithWine pays the money into your bank account in deposits. Each deposit covers a group of card payments, less WithWine fees. You can filter the Orders screen by a deposit to see exactly which orders make up that deposit.

Before you start

  • Find the deposit amount and date on your bank statement.

  • Refunds come out of a later deposit, not the deposit the original order was paid in. When you filter by the deposit a refund came out of, the refund shows in the list as its own row, with R in front of the order number and a minus amount, for example R#24458943 -$189.20.

  • Only WithWine card payments are paid out in deposits: WithWine - Card Not Present (online and phone payments) and WithWine - Card Present (card reader payments). Cash, invoice, account credit and other payment types aren't part of a deposit.

  • To see which bank account deposits go to, open any order and click the Company Details tab in the order panel.

How to filter orders by a deposit

  1. Go to Orders.

  2. Click Filters.

  3. In Show orders for, choose your company name, for example Saltbush Ridge Estate Pty Ltd. The company name is at the bottom of the Show orders for list.

  4. A second box appears. Choose the deposit, for example Deposit on 06-Nov-2026 $70.82.

  5. Remove any other filters, such as Paid and Ready for Shipping / Pick Up, so every order in the deposit shows.

  6. The list now shows only the orders in that deposit. The filter labels above the list show the company and the deposit.

How to check the deposit adds up

  1. With the deposit filter on, click the + on the Total Order Amount tile. Check every payment type is a WithWine payment type.

  2. Click the arrow on Detailed Summary and choose All.

  3. Scroll to By Transaction Fee. This shows the WithWine Fees (inc Sales Tax) for the orders in the deposit.

  4. Take the fees away from the order total. The result is the deposit.

For example, a deposit of $70.82 shows one order of $73.00. By Transaction Fee shows WithWine Fees (inc Sales Tax) of $2.18. $73.00 − $2.18 = $70.82, which matches the deposit.

Check each order's deposit in the Orders CSV

With the deposit filter on, click the arrow on the Export tile and choose Default > Orders CSV. In the Orders CSV, each order has a Fees column and a DepositAmount column. DepositAmount is the order total less the fees. The DepositAmount values add up to the deposit.

Use the Orders CSV, not the Order Items CSV. The Order Items CSV repeats DepositAmount on every product row, so the total is too high. See "What's the difference between the Orders CSV and the Order Items CSV?".

What happens next

If the deposit matches, you're done. If the deposit doesn't match, see "Why doesn't my deposit match my orders?".

Related articles

Did this answer your question?