Reports is where every business report lives. Open Reports in the sidebar (/reports), pick a report, check the figures on screen, then export exactly that to Excel or CSV.
Finding a report
Reports are listed in five groups: Money, Bookings & customers, Marina, Operations and Accounting. Each row says what the report covers and which date it goes by (date of sale, service date, payment date, or a balance as of a date).
- Find a report searches report names and descriptions.
- Category shows one group at a time.
- Open shows the report on screen. CSV and Excel download it straight from the list, using the dates and location in the toolbar. CSV from the list gives the report's main table; open the report to pick another one.
Reports for features you have turned off (for example Slips, POS or Staffing) are hidden. A line at the bottom of the page says how many are hidden, with Show them to list them anyway.
The toolbar
The same row of filters sits above the list and above every report.
| Filter | What it does |
|---|---|
| Dates | Presets: Yesterday, Last 7 days, Last 30 days, This month, Last month, This quarter, Year to date. Custom dates… picks any range. Both dates are included, a single day works, and days follow the location's time zone. |
| As of | Reports that show a balance (Unpaid balances, Trial balance, Bonds held) use one date instead of a range: the balance at the end of that day. |
| Location | Shown when the business has more than one location. All locations combines them. If they use different currencies or time zones, the report says so in a note. |
| Options | Some reports have their own choices, such as Bookings (Dates: service date or booking date; Cancelled: leave out or include), POS sales (booking payments taken at the till) and Price list (current and recent seasons, or every season). |
| Show | Reports with more than one table switch between them here, for example Sales summary (By category, By day, By channel) and Payments & fees (By tender, Money out, By day). |
The line at the right of the toolbar repeats which date the report goes by and the time zone it uses.
Pinned reports
Click the star next to a report to pin it. Up to four pinned reports show at the top of the page as tiles with their headline figure for the selected dates. Sales summary, Sales tax and Unpaid balances are pinned until you choose your own. Pins are kept on this browser.
Exporting
Export at the top right of a report gives:
- Excel workbook: one sheet per table, with numbers stored as numbers (so totals and formulas work) and an About sheet listing the report, the dates and the locations it covers.
- CSV: one table per file, with a single header row and no blank or title lines, ready for a spreadsheet or your accounting software. Accented names open correctly in Excel.
The export has the same figures as the screen. Some exports add columns the screen leaves out to save space, such as a customer's email and phone.
The reports
| Report | What it shows | Dates go by |
|---|---|---|
| Sales summary | Sales by category, day or channel, with discounts, tax and fees. Fuel and pass-through surcharges are listed apart and are not counted as sales. | Date of sale |
| Profit & loss | Sales, cost of goods and expenses for the period. | Date of sale |
| Payments & fees | Money received by card, debit card, cash, cheque, gift card and on account, with refunds, other money out and card fees. | Payment date |
| Unpaid balances | Who owes you, aged under 30, 30 to 59, 60 to 89 and 90+ days. Opens Accounts receivable. | As of a date |
| Deposits & prepayments | Money taken for bookings that have not happened yet, and what is still promised. The two are shown apart, never added together. | Balance at each date |
| Sales tax | Tax collected, adjusted and owed, per tax, named the way you set it up. | Date of sale |
| Tips | Tips by service date and staff, for tip-outs. | Service date |
| Bonds held | Damage bonds you are holding for customers. Shown only if you take bonds. | As of a date |
| Bill-to statements | Monthly statements for payers you bill later, such as schools. Shown only if you use bill-to. | By month |
| Bookings | Every booking with dates, items, customer, paid and balance due. | Service date or booking date |
| Customers | Contact details, bookings and lifetime spend. | All customers |
| Members | Members with tier, monthly charge, next payment and home location. | Current members |
| Storage clients | Everyone renting a slip or storage, with monthly charge and next payment. | Active today |
| Moorage billing | What moorage billed, collected and is still owed for the period. | Reservations active in the range |
| POS sales | Every till sale with items, tender and staff. | Date of sale |
| Price list | Every rental item's rates by season. | Current and recent seasons |
| Fleet | Rental items, units, capacity and status by location. | Current fleet |
| POS items | Products with price, cost and stock. | Current stock |
| Timesheets | Hours worked by staff, with breaks and overtime. | Clock-in day |
| Journal | Every ledger line, debits and credits grouped by transaction. | Posting date |
| Trial balance | The balance of every account at the end date. | As of a date |
| AppFolio journal | The journal in AppFolio's import layout, one entry per day. Shown only where AppFolio is set up. | Posting date |
Some reports need a permission, for example Bookings (bookings access), Customers (customers access) and Timesheets (staff schedule access). The links in Financials open the matching report.
Run the Trial balance as of the last day of the month before you close it, and match your export dates to your accounting periods. Every report a person opens is recorded in the audit log.
A report shows nothing: widen the dates, or check the location in the toolbar. A report says when there is nothing in the range.
Sales do not match Payments & fees: Sales summary goes by date of sale and leaves out fuel and pass-through surcharges; Payments & fees goes by the day the money arrived and includes them. Compare them over the same dates with that in mind.
Numbers differ from Stripe: Stripe pays out on its own schedule and nets its fees. Payments & fees lists card fees separately so the two can be reconciled.
A report is missing from the list: it may be for a feature that is off (use Show them at the bottom of the page), or it may need a permission your role does not have.