Workspace and Stripe show different parts of the same sale. Workspace records the order and fulfilment information, while Stripe records the payment, its processing fees and the payouts sent to your bank.
Choose the same reporting period
- In Workspace, open Sales & Activity.
- Select the date range you want to reconcile and apply any relevant filters.
- Export the sales information as a CSV.
- In Stripe, open the reporting or transaction area for the same dates and export the relevant payment, fee, refund and payout information.
Stripe occasionally changes the names and locations of its reports. If the wording in your Stripe account differs, look for the report or export that shows balance activity and individual transactions.
Match the sales
Compare the gross customer payments recorded in Stripe with the corresponding Workspace sales. Allow for differences caused by the reporting dates, refunds, failed payments, currency conversion or transactions that settle after the end of the selected period.
You can usually locate an individual transaction using the customer’s email address, sale value, date or Stripe payment reference.
Separate the deductions
When reviewing a transaction, distinguish between:
- Stripe payment-processing fees.
- Refunds or chargebacks.
- Queensberry product and fulfilment costs where Queensberry supplied the order.
- Your own production, packaging and delivery costs for self-fulfilled products.
Workspace does not charge commission on self-fulfilled products. Stripe processing fees may still apply, and your own fulfilment costs need to be recorded separately.
Understand payouts
A Stripe payout may combine several transactions and may also reflect fees, refunds or adjustments. The date money reaches your bank will not necessarily be the date the customer placed the order.
Use Stripe’s payout details to match each bank deposit back to the underlying balance activity.
Keep suitable records
Retain the Workspace export, Stripe reports, Queensberry transactions and your own fulfilment records for the period. Ask your accountant or tax adviser how these amounts should be entered in your accounting system.
