Stripe balance report: by date
A Stripe Balance change from activity report, itemized (Reports → Balance → Download), with its default columns.
Processed locally in your browser. File contents are not uploaded. No account needed.
Before and after
Made-up rows from the sample file, run through the same code Rote Workspace runs, when this page was built. Removed rows are struck through; changed cells are highlighted — point at one for its old value.
Original
| Row | created_utc | gross |
|---|---|---|
| 2 | 2026-09-02 09:00:00 | 14.00 |
| 3 (removed) | ||
| 4 | 2026-09-01 10:23:45 | 1012.50 (has spaces at its edges) |
| 5 | 2026-09-01 18:00:00 | -12.50 |
Result
| Row | Date (UTC) | Time (UTC) | gross |
|---|---|---|---|
| 4 | 2026-09-01 | 10:23:45 | 1012.50 (changed) |
| 5 | 2026-09-01 | 18:00:00 | -12.50 |
| 2 | 2026-09-02 | 09:00:00 | 14.00 |
3 rows × 10 columns after the fixes · was 4 × 9 · 1 cell changed
7 more columns are not shown; they pass through unchanged.
· marks a space at the start or end of a value. The dots are not in the data; they show spaces you would otherwise not see.
Why
Stripe pays out in batches, so matching bank deposits means working through the itemized report day by day — easier with the rows in order and the date in a column of its own.
What it does
- Remove empty rowsOn the sample: 1 row removed
- Trim spaces in every columnOn the sample: 1 cell changed
- Sort the rows by "created_utc" (A to Z); blank and unreadable values go lastOn the sample: 3 rows moved
- Split "created_utc" on " " into "Date (UTC)", "Time (UTC)"; the last column keeps the restOn the sample: added Date (UTC), Time (UTC); removed created_utc
Your file needs this column, spelled exactly: created_utc. If one is missing or renamed, the workflow tells you which step it breaks and does not run.
How to use it
Download the workflow
A small .json file with the steps above — no data. Want to try it first? Use the sample file (made-up rows).
Open your export
In the Data Workspace, choose your file. It is processed in your browser, not uploaded.
Import, review, run
Workflow → Import, choose the file — or skip the download: under Workflow → Templates, press Check & open. Each step is checked against your columns; press Run on this file, then Download.