Statement — a CSV for your accountant
Export a period as CSV: which rows are included, what the columns mean, and why you never sum the 'nominal' column.
Statement turns a period into a CSV file: one row per money event — a payment, a refund, a package sale, a cost. This is the file you hand to your accountant (or open yourself in Excel when you want to check something calmly). The screen is a form: you specify what you want on the left, and on the right you see exactly how many rows you’ll get before you download anything.
1. When you need it
- Monthly or quarterly handover to an accountant.
- Working out “why was this month weaker” with the full list of movements in front of you.
- An archive for yourself — the file still opens years later, without Mountify.
The title is Statement, and under it: “Download every money line of a period as a CSV — for your accountant, or to check the books yourself.”
The path: left rail → the board → Money → in the left-hand column, under MONEY FLOW → Statement.
2. Step by step: export a period
- In the Period card, press one of the six tiles or set your own range. Each tile prints the exact dates it resolves to. To the right of the card’s heading you see how many days that is.
- In What goes in, keep the default ticks (the five “money that moved” types) or add the informational ones.
- Optionally, in Narrow it down, limit by payment method, expense category, amount or text.
- Look at the right-hand card, What you will get: the number of rows, what they consist of, and the In / Out / Difference totals.
- Read the warnings underneath, if any.
- Press Download CSV. The button turns into Preparing the file…, then the file is saved to your device and you get “Done — N lines in the file.”
3. The period
| Tile | What it resolves to |
|---|---|
| This month | From the 1st to today — not to the end of the month |
| Last month | A whole calendar month |
| This quarter | From the start of the quarter to today. The tile carries a Q1…Q4 tag |
| Last quarter | A whole quarter |
| This year | From 1 January to today |
| Last year | The whole previous year |
Below the tiles it says or a custom range, with a date picker for when you need exactly 12–19 July.
A few details:
- The days are the board’s calendar days (its timezone), not your device’s clock.
- There is no limit on how long a period may be, but there is a limit on the number of rows — see step 8.
- The whole specification (period, types, filters) lives in the page’s address. If you file the same slice every month, bookmark the address and just change the dates.
- If two tiles resolve to the same range (in the first month of a quarter This month and This quarter coincide), the product says so honestly — which is why quarters carry a number.
4. Which rows are included (and which are only for the record)
The What goes in card has two groups. To the right of its heading it says how many of the 8 types are ticked.
Money that moved — ticked by default:
| Type | Means |
|---|---|
| Payment | Money received against a booking |
| Refund | An amount returned (in cash or to a card) |
| Package sold | A package whose money came in |
| Package refunded | Money returned for a package |
| Expense | A row from Money → Expenses, including automatic repetitions |
For the record only — with the hint “These lines carry 0 — they change no total, they record what happened.”:
| Type | Means |
|---|---|
| Comped service | A visit put on the house |
| Package not paid yet | A package sold whose money hasn’t come in |
| Package given away | A package handed over as a gift |
Two practical notes:
- An accountant usually needs only the five default types — a file that foots.
- For your own analysis (“how much did we give away this month”) tick the informational types, but never sum their
nominalcolumn.
You can’t untick everything: the last tick stays, because a file with no types would be a header row and nothing else.
5. “Narrow it down”
Everything here is optional. Above the fields it says “Nothing ticked means everything — narrow only when you are after something specific.”, and to the right, how many filters are active.
| Filter | How it works |
|---|---|
| Payment method | Six chips: cash, card, online, package, mixed, no method recorded. Several at a time |
| Expense category | The five categories. It applies only to expense rows — income doesn’t vanish when you tick “Rent” |
| Amount from / Amount to | Compares the magnitude, whether it’s income or a cost. Empty = no bound |
| Search | Part of a client’s name, a service or a note (case-insensitive) |
Once filters are set, a Clear filters link appears below them.
6. “What you will get” — the number on screen is the number in the file
The right-hand card is computed along exactly the same path the file is later written with. That’s why its row count is the file’s row count — not an estimate.
| Line in the card | What it is |
|---|---|
| The big number + line / lines | How many rows the file will have (excluding the header and the final technical line) |
| The coloured bar | What the file consists of by row count (not by money) |
| The list under it | How many rows of each ticked type |
| In | The sum of the positive amounts |
| Out | The sum of the negative amounts, shown as a positive number |
| Difference | In minus out |
Under the card sits the Download CSV button and the note “The file opens in Excel, Numbers and Google Sheets.”
The button is inactive while the card is still counting, and when the row count is zero.
7. The columns in the file
The file has a header row and 14 columns:
| Column | Contents |
|---|---|
date | The board’s calendar day, YYYY-MM-DD |
time | HH:mm in the board’s time. Empty for an expense — an expense is a day, not a moment |
type | The machine name of the type: payment, refund, comp, package_purchase, package_purchase_unpaid, package_grant, package_refund, expense |
amount | A signed amount: positive for money in, negative for money out, 0 for the informational types |
nominal | What the row “would have been worth” as money: the comped price, the value of an uncollected package sale. For ordinary rows it equals the amount without its sign |
currency | The row’s currency code, e.g. BGN |
method | The payment method as recorded (cash, card, online, package, empty) |
client | The client’s name, when known |
service | The service (or the package’s name) |
category | The category — expense rows only |
note | The note, if there is one |
booking_id | The booking’s identifier (empty for packages and expenses) |
client_id | The client card’s identifier |
record_id | The identifier of the row itself — useful when reconciling |
Sorting is chronological: by day, then by time. Expenses sit at the start of their day (they carry no time). Two exports of the same window produce the same file, row for row — so they can be compared.
8. The sign of the amount: never sum nominal
The rule is one line:
| Row type | amount | nominal |
|---|---|---|
| Payment, Package sold | + the amount | the same amount |
| Refund, Package refunded, Expense | − the amount | the same amount |
| Comped service, Package not paid yet, Package given away | 0 | the sticker value |
Therefore:
- Sum the
amountcolumn — it gives exactly what the period did to the till, and it agrees with Difference on the screen. - Never sum
nominal. It mixes real money with gifts and uncollected sales; its total means nothing.
If the
amountcolumn doesn’t sum in Excel, the file was opened as text. Open it via “Data → From Text/CSV” with a comma separator and a dot as the decimal mark.
9. The warnings
Facts about the period appear under the right-hand card — not advice:
| Warning | What it means | What to do |
|---|---|---|
| ”This period is over 100,000 lines and the file will be cut. Split it into shorter periods.” | There’s a hard ceiling of 100,000 rows | Split the period (by month, say) |
| “There is not a single line in this period.” | Nothing to download | Widen the period or drop filters — the button is inactive |
| ”The lines are in N currencies — the sums below mix currencies.” | The period holds amounts in different currencies. Nothing is converted | Export per currency using the filter, or accept that Difference is approximate |
| ”N packages are sold but not paid for yet.” | The period holds uncollected package sales | Nothing — it’s information. They carry amount 0 |
| ”N given-away packages are not counted in the sums.” | There are gifts in the period | Nothing — they were never revenue |
After the download you may also see:
- “Done — N lines in the file.” — all good;
- “The file was cut at N lines. Split the period.” — the ceiling was hit and the file covers part of the period;
- “The download was cut short and the file is incomplete, so we did not save it. Try again or pick a shorter period.” — Mountify deliberately refuses to save half a file. Every file ends with a technical line,
#END,<count>,complete; when it’s missing the file is rejected rather than handed to you looking plausible and quietly missing December; - “The download failed.” — a generic error, try again.
10. What the file does not contain
- Bookings with no money. A booking nobody paid anything for has no row here. For what’s unpaid see Who owes me.
- Debts. The statement is about movements, not obligations.
- Voided entries. An entry you undid as a mistake never enters the file.
- VAT or a net/tax split. There is one amount per row.
- Invoices. Neither to your clients nor to you. Your Mountify subscription is a separate bill — see Plans & billing.
- Several boards at once. One statement = one board.
11. Common questions
Is there an Excel file (.xlsx)? No, CSV only. It opens directly in Excel, Numbers and Google Sheets, and can be saved as .xlsx from there.
Will Cyrillic names read correctly? Yes. The file carries an encoding marker that Excel on Windows recognises — names don’t come out as question marks.
What is the file called?
statement_<from>_<to>.csv — for example statement_2026-07-01_2026-07-31.csv.
Can it be emailed automatically every month? No. Downloading is a manual action on this screen.
Why is the same package on two rows? Because the sale and the refund are two events. A package sold in June and refunded in July gives June a Package sold row and July a Package refunded row. That’s precisely why a refund never rewrites an already-closed month.
Who can download it? Anyone with permission to view the board.
What’s next
- Expenses and what’s actually left — where the Expense rows come from.
- Day and month reports — the same money, summarised instead of listed.
- Payments & revenue — the ledger on screen.
- Your venue’s currency — why one file can hold two currencies.