Weekly and Monthly Reports

CSV layout

The file is one CSV with a header row naming four columns, in any order. Row numbers count the header as row 1. All dates are UTC.

Columns

CSV columns and their accepted formats
ColumnAccepted formatRequired
dateYYYY-MM-DD, a real calendar day, read as UTCYes: a missing date rejects the row
descriptionAny textNo
categoryAny text; totals are grouped by it (blank becomes Uncategorised)No
amountA plain number such as 120.00 or -45.5, no currency sign or thousands separatorYes: a missing or non-number amount rejects the row

A valid file

date,description,category,amount
2026-11-02,Supplies,Expenses,120.00

Rows that would be rejected

Examples of rejected rows
Row in fileReason shown
,Sale,Sales,90.00Missing date
2026-11-31,Sale,Sales,90.00Date is not a real day written YYYY-MM-DD
2026-11-04,Sale,Sales,Missing amount
2026-11-04,Sale,Sales,"12,5O"Amount is not a number

Download the fictional sample CSV