Studios in Australia reconcile Stripe payouts using the Payment Transactions by Gateway - Local report because Stripe calculates their payouts using the studio's local time instead of UTC. This article explains how to match your Stripe Reconciliation Report and bank deposits to your Mariana Tek data.
Stripe Reconciliation Report
Since mid-July 2026, Stripe groups transactions into daily payouts based on midnight in your studio's local time. Before this change, all studios used midnight UTC. For example, when Melbourne is 10 hours ahead of UTC, a sale at 3:00 PM UTC on September 17 happens at 1:00 AM on September 18 in Melbourne. Stripe now includes that sale in the September 18 payout, not the September 17 payout.
This means:
Use the Local report: Reconcile with Payment Transactions by Gateway - Local, not Payment Transactions by Gateway - UTC.
The SRR still shows UTC: All dates and times in the Stripe Reconciliation Report are still in UTC, so you'll need to adjust them by one day.
Weekly deposit window: Each Stripe Reconciliation Report covers deposits that land in your bank from Tuesday to the following Monday, local time.
How to Match SRR Payout Dates to your Bank Deposits
Payout dates in column B of the Stripe Reconciliation Report are in UTC. To find the date the deposit landed in your bank account, add one day. Examples:
SRR column B (UTC) | Bank deposit date (local) |
Monday, 8/31 | Tuesday, 9/1 |
Tuesday, 9/1 | Wednesday, 9/2 |
Wednesday, 9/2 | Thursday, 9/3 |
Thursday, 9/3 | Friday, 9/4 |
Sunday, 9/6 | Monday, 9/7 |
How to Reconcile a Stripe Reconciliation Report
Open your Stripe Reconciliation Report and sort column G from oldest to newest.
Find your start date: take the earliest date in column G and add one day.
Find your end date: take the latest date in column G and keep it as is.
Stripe can process refunds faster than regular transactions, so a refund may appear in an earlier payout than same-day sales. If the last date in the filtered column is different than all the other dates in the payout, skip it and use the next latest date instead.
In Mariana Tek Admin, go to Reports > Finance > Payment Transactions by Gateway - Local.
Set the date picker to your start and end dates.
Compare the Total Net Amount to the payouts in the Stripe Reconciliation Report.
Example: Column G runs from 9/17/2026 14:01 to 9/24/2026 12:40 (UTC).
Start date: 9/17 at 2:01 PM UTC is 12:01 AM on 9/18 in Melbourne, so your start date is 9/18/2026.
End date: 9/24 at 12:40 PM UTC is 10:40 PM on 9/24 in Melbourne, so your end date is 9/24/2026.
Result: Filter Payment Transactions by Gateway - Local for 9/18/2026 to 9/24/2026.
The earliest transaction always falls just after your local midnight. In UTC, that's the afternoon of the previous day, which is why you add a day to the start date. The latest transaction falls just before your local midnight, so the UTC date and the local date are the same.
If your Numbers don't Match
Using the UTC report: Payment Transactions by Gateway - UTC splits days at midnight UTC, which no longer matches your payouts.
Switch to Payment Transactions by Gateway - Local and run the report again.
Using column B dates as deposit dates: SRR payout dates are in UTC, so they show one day earlier than your bank statement.
Add one day to each column B date before comparing them to your bank deposits.
Chargebacks or refunds: Stripe deducts lost chargebacks and processes refunds on its own timeline, and Mariana Tek reports don't reflect this.
Check the Stripe Reconciliation Report for chargeback and refund adjustments.
Reconciling a period before mid-July 2026: Payouts before the change were calculated using midnight UTC.
Use Payment Transactions by Gateway - UTC for those dates.