The Line Item List Reports display the Line Items associated with your various Bookings/Accounts. This report exists in 3 formats: Bookings, Events and Invoices.
Line Item List Report (Bookings): Shows a list of Line Items attached to Bookings
Line Item List Report (Events): Shows a list of Line Items attached to Events
Line Item List (Invoices): Shows a list of Line Items attached to Invoices
These three reports work similarly, with the main difference being the associated Booking, Event, or Invoice automatically listed for each item.
Not all items will appear on every version. For example, an item linked to a Booking and Event but not an Invoice will only appear on the Booking and Event reports. Items added exclusively to invoices will only appear on the Invoice report.
Reports can include details such as Line Item Description, Booking Date, Serving Time, Quantity, Unit Price, Line Item Total, and Tax Revenue.
How to Use The Line Item List Report
Click on Reports in the side navigation
Click Line Item List (Booking), Line Item List (Event), or Line Item List (Invoice) report
Select Reporting Filters For example, you can apply filters such as Revenue Category, Booking Status (e.g., "Definite"), and Date Range to tailor the report to your needs.
Add additional Columns
Click Save View (Name Report)
Export As CSV, HTML or PDF
Important Considerations
Exporting to HTML or PDF can include a Revenue Summary of all Line Items in the filtered report. This is broken down by revenue category, taxes, fees, and the overall total.
Exporting the Line Items List Reports to CSV will allow you to filter columns by individual Line items.
Tax Settings: If your organization uses tax-inclusive pricing, the 'Qty X Price' column will show the gross prices. However, if your organization is tax-exclusive, the added taxes will be visible separately.
Notes & Descriptions can often be very lengthy. To improve formatting when exporting to HTML or PDF, the notes and description columns are displayed at the bottom of each entry as a separate row.- Alternative Reports: For additional insights, consider using the Event Sales Productivity Report for revenue by category or the Catering Pace Report for monthly totals by revenue category.