Reports
Export your orders, customers and invoices to Excel, and pull the same data into your own tools through the API.
Available to manufacturers on Startup, Pro and Factory Floor plans
Reports in Phasio are the Excel (.xlsx) workbooks you export to work with your data outside the app: for bookkeeping, for a shared view of the work in progress, or to feed another system. You can export your orders, your customer organisations and your order invoices. For charts and headline figures inside Phasio, use Analytics instead.
| Export | Where | What you get |
|---|---|---|
| Orders | Orders > List > Export | Your orders and their item details, for a time period and filters you choose |
| Customers | Customers > Export | Your customer organisations |
| Order invoices | Orders > List > Download Invoices Excel | Invoice data for every confirmed, non-archived order |
Export orders
- Open Orders > List and click Export in the toolbar. The Export orders dialog opens.
- Choose a Time period.
- (Optional) Open More options. Here you can filter by customer, source and payment, search for orders, turn on Include archived, and choose the columns on the Main sheet and Item details tabs.
- Review the estimated row count, then click Download Excel.
The workbook has a Main sheet and an Item details sheet, with the columns you chose for each.
What the order export contains
The price columns are split so they add up to the order's final price:
- Subtotal
- Shipping
- Discount
- Minimum order top-up
- Net total
- Tax
Every price column states whether it includes tax.
Internal orders carry their booking through to the export: the project reference captured at checkout, or the cost centre the order was booked to.
The analytics dashboard counts only orders (not open quotes), leaves out refunded payments and shows gross totals, so its revenue for a period is consistent with the order export for the same period.
Export customers
- Open Customers and click Export in the toolbar. The Export customers dialog opens.
- As with orders, choose the date range, filters, source and columns to include.
- Review the estimated row count, then download the workbook.
Download order invoices
To download your order invoices as one Excel file, open Orders > List and click the ⤓ icon (tooltip Download Invoices Excel) in the top-right corner.
- The file is in .xlsx format only.
- The icon appears only when Invoice generation is on in Settings > Finances > Payments. See Payments.
The download ignores your filters. It includes every confirmed, non-archived order from the start of your order history, and no quotes or drafts.
Other ways to get your data out
- Accounting system. On the Pro plan, you can connect your accounting system so your orders and payments sync to it, and run your bookkeeping reports there. See your accounting system's page under Integrations, for example QuickBooks.
- Manufacturer API. List endpoints for orders, customers, customer organisations and more accept a
filter, so a script or BI tool can pull exactly the rows it needs (see Filtering).GET /api/manufacturer/v1/document/invoicereturns the invoice workbook, andGET /api/manufacturer/v1/analytics/dashboardreturns the analytics dashboard's figures. Both are in the Manufacturer API reference. - Webhooks. To react to new orders or changes as they happen instead of exporting on a schedule, use webhooks.
Last updated on
Analytics
Understand the analytics dashboard: its tabs, what each figure counts, gross revenue, period comparisons, conversion funnels and plan availability.
Storefront
Set up your branded Phasio Storefront, where customers upload models, get instant quotes and place orders, and choose how customers sign in.