Every report can leave Pop Dispatch as a CSV file. You will be able to download the figures you see on screen and open them in a spreadsheet.

Before you start #
- Run the report first, so you know the dates and time zone it covers.
- The file holds the same rows and totals as the table, for the same dates and time zone.
Steps #
- Open Reports for the fixed reports, or Report builder for custom and saved reports.
- Choose the report and the First day and Last day.
- Select Run report (or Run on a saved report).
- Select Download CSV. The browser saves a file named with the report and the dates, and a message says "The CSV file is saved."
- Open the file in your spreadsheet. The first row holds the column names and the last row holds the totals, labeled Total.
- To print instead, select Print / PDF. The printable page opens in a new tab with your business name, the report, the dates, the time zone and the day you ran it.
How the file reads #
- Money is written as plain numbers in dollars with two decimals, such as 1250.50, so a spreadsheet can add it up.
- Distances are written with one decimal.
- Dates in a custom report are written as year-month-day, with the time when the field holds one.
- Text that a spreadsheet would read as a formula starts with an apostrophe.
Technical details
- Fixed reports:
GET /reports/:name?from=&to=&tz=&format=csv. Custom reports:POST /report-builder/run?format=csvwith the definition, andGET /report-builder/saved/:id/run?format=csvfor a saved one. - The CSV is built from the same table as the screen, so the two always agree. A custom run exports up to its row limit.
- Printing a PDF is written to the audit log as "printed a report".
If something goes wrong #
- "This report is for owners, managers and advisors.": ask one of them to run it.
- "from must not be after to": swap the dates.
- A browser that keeps the PDF tab closed saves the PDF as a file instead.