← Help

Reports and analytics

The reports available, who can see them, the date ranges, how the figures are worked out (revenue by orders or by payments received), and exporting to CSV or PDF.

Who can see reports

Reports include revenue and customer spend, so only workspace owners and admins can open the page; members see a notice that Reports are for owners and admins. Reports also need a Pro or Farm plan; on Free the page shows the upgrade notice instead of the charts.

What reports are available

  • Summary: revenue, expenses and net for the range.
  • Owed to you: today's unpaid invoices after payments and credit notes, the overdue part, the same money split by days since the invoice date (0 to 30, 31 to 60, 61 to 90, over 90), and the money received this month, tax included. It does not follow the range. The dashboard's Owed to you tile shows the same figures.
  • Revenue vs expenses: month by month. The month in progress is drawn dotted and labelled so far, so the start of a month does not look like a fall.
  • Job economics: for the orders placed each month in a column that counts as revenue, their sales before shipping and tax, their cost, the margin (sales less cost, also as a percentage) and the hours printed. An order's cost is the cost saved on its lines (material, power, machine wear and labour, as the order form worked it out). An order whose lines carry no cost counts the material the stock ledger says it used instead, at today's spool and item prices. The card says how many orders had no cost either way, and how much filament came from spools with no price. Hours printed are what FoxTrack Bridge recorded in the month when it recorded any, else the print hours on the order lines. The dashboard's Margin this month and Printers busy tiles show this month's figures; Printers busy is the hours printed over the hours your printers in use have had since the month began.
  • Most popular products: ranked by quantity ordered. Order lines without a product are one row, Custom work. Order value is the lines' total on the order date, whichever revenue rule is on.
  • Biggest client: customers ranked by total spend, including a customer whose only entry in the range is a credit note.
  • Filament consumption: grams used per month, from stock movements.
  • Expenses by category: what you spent in each category over the range, with the number of entries and a total that matches Summary Expenses. A category whose credits (vendor refunds) outweigh its costs shows as a credit.
  • Downtime by printer and Downtime by month: from maintenance log entries.

Each card explains when there is no data for the range yet.

Filament used per month

The Filament consumption card on the Reports page shows the grams of filament used in each month of the range, worked out from the filament stock movements that saved orders and stock changes record. Refills, opening balances and stock moved between places are not counted as use. Pick Last month in the range control to see what last month's work used, or This year for the trend. What is left on each spool now is on the Filament page.

Date ranges

The range control at the top offers This month, Last month, Last 6 months (the default), This year and Last year, plus Custom…, which shows two month pickers, From and To. If From is later than To, the report reads the two months in order. Every card follows the same range. Reports only read what has been entered: complete orders, logged expenses, stock movements from saved orders and filament usage, and maintenance downtime.

How the figures are worked out

What counts as revenue is a setting, Revenue counts under Settings → Reports, and the line under the Reports title says which rule is on, for example Revenue: orders, by order date, with a Change under Settings link. The PDF prints the same line and the CSV has a Revenue counts row.

  • Orders (the default): revenue is the total of orders created in the range, excluding orders in board columns marked Exclude from revenue, plus Outstanding and Paid invoices issued in the range that have no order behind them (for example an invoice made straight from a quote). Those invoices count before tax, the same way orders do. An invoice made from an order is not counted a second time.
  • Payments received: each payment recorded on an invoice counts on the day it was received, before tax (its share of the invoice's total before tax), so a deposit counts in its month and the balance in its own. A refund comes off on the day it was paid back, and never touches an earlier month. An order with no invoice still counts by order date. An order that has an invoice counts once, through the payments on that invoice. Draft invoices count nothing. Credit notes count nothing on this rule: the refund, or the smaller payment, already says it. This rule used to be called Paid invoices and counted a whole invoice on the day it became paid.

On the Orders rule, an issued credit note takes its amount before tax back off revenue, and off that customer's spend, in the month of the credit note's own date; a void credit note takes nothing off. The Orders count and Average order use orders only. Expenses are entries in the range, with credits subtracted. Net is revenue minus expenses. Product popularity counts ordered quantities; client spend follows the revenue rule per customer; filament consumption sums grams from stock movements; downtime sums hours from log entries. Everything is calculated on the server from stored records, so the numbers match what the dashboard shows for the same period. Reports count days and months in your shop's time zone from Settings → General → Localization, so everyone who opens them sees the same totals. If no time zone is set, they use the time zone of the computer you are on, and the Summary card says so.

Exporting

Export CSV downloads the report figures for the selected range as a spreadsheet. Export PDF renders the same view, including your logo and the range, as a document to share with a partner or accountant. Both carry every card on the screen, Expenses by category included, name the time zone, and use the number and date formats from Settings → General. While a card has failed to load, export waits: reload the page, then export.

Still stuck?

Email info@foxtrack.studio or ask on the FoxTrack Discord. Inside the app, the question mark in the top bar sends a bug report or feedback.