Skip to Content

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.

ExportWhereWhat you get
OrdersOrders > List > ExportYour orders and their item details, for a time period and filters you choose
CustomersCustomers > ExportYour customer organisations
Order invoicesOrders > List > Download Invoices ExcelInvoice data for every confirmed, non-archived order

Export orders

  1. Open Orders > List and click Export in the toolbar. The Export orders dialog opens.
  2. Choose a Time period.
  3. (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.
  4. 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

  1. Open Customers and click Export in the toolbar. The Export customers dialog opens.
  2. As with orders, choose the date range, filters, source and columns to include.
  3. 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/invoice returns the invoice workbook, and GET /api/manufacturer/v1/analytics/dashboard returns 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

On this page