How to Create a Consolidated Invoice for a Customer
Combine a customer's invoices for a date range into one consolidated invoice, then download, email or export it from the customer's Consolidated screen.Updated Nov 9 2026
Before you start
- Customer List is under Sales > Customers and is open to users with the User role (or All). If your site has Restrict View Of Customers To Customer Associations on, you can only open customers you are associated with unless you have the Can See All Customers function (Manager or AllCustomers by default).
- A consolidated invoice is a document, not a new invoice record. It lists lines from the customer's existing invoices (credit memos, deleted and unbilled invoices are left out).
-
Open the customer's Consolidated screen
- Go to Sales > Customers > Customer List (headed Customers).
- Click the filter search bar (Filter or search…), choose Customer, pick the customer, and click Apply (1). The filter shows as a chip in the search bar, beside the default Active is Active chip.
- Click the customer's Name to open it.
- In the customer's left-hand menu, click CONSOLIDATED (also listed under SALES +). The screen is headed Consolidated Invoice For customer.
-
Choose the invoices
- On the customer's Consolidated screen, set the two Date boxes to the first and last invoice dates you want. Both start at today's date, and the preview below already shows today's invoice lines.
- Optionally narrow it further:
- Sort By Invoice # – list newest invoice numbers first instead of by PO and part.
- Already On Consolidated? – Exclude Lines Already Billed leaves out lines that have been on a consolidated invoice before (Include All Lines is the default).
- Click Submit. The preview shows the matching invoice lines, each with an Include? tick. Your choices stay set when you come back to the screen.
-
Choose the columns
- On the customer's Consolidated screen, tick the columns you want in the Columns To Show table and untick the rest.
- Click Set Columns. The choice is saved for your user and the preview reloads; there is no message.
-
Get the consolidated invoice
- On the customer's Consolidated screen, use the buttons at the top:
- Get PDF – opens the consolidated invoice PDF (Invoice-<from>-<to>.pdf) in a new tab, where you can save or print it.
- Email PDF – opens an email form in a new tab (From, To (comma delimited), CC (comma delimited), Subject, Body). To starts empty: type the customer's address, then click Send.
- Get CSV – downloads the lines as a spreadsheet with its own fixed columns (Invoice #, Customer PO #, Cust Part, Ship Qty, Ship Date, Tracking #, Line Comment).
- Get Packing Slip – opens a consolidated packing slip page in a new tab.
- On the customer's Consolidated screen, use the buttons at the top: