Billing Report – Invoice Details

Overview

Use the Invoice Details report to view totals and details about balances, work items, line items, and deposits for invoices created during a selected date range.

This report shows all service activity performed for customers within a selected date range, as well as the total dollar amount due for services rendered, excluding the price of installed items.

The report displays information in four tabs:

• Invoices — Shows invoices sent during a set date range and their details, such as total sales, invoice date, and service location.
• Work Items — Provides a high-level overview of the number of completed Stops, Dosages, Installed Items, and Work Orders on each invoice.
• Line Items — Gives greater detail for each invoice, down to individual line items.
• Deposits — Displays information solely about deposit invoices.

Each tab includes two sections:

• Summary — Located at the top of the report, the summary section shows totals for the key performance indicators (KPIs) for the tab. These values are color-coded: green for positive or paid amounts, amber/orange for outstanding or at-risk amounts, and gray for neutral totals.
• Detail — Displayed in table format in the lower half of the report, the detail section lists the individual transactions that make up the KPIs in the Summary section.
  

Report totals

The Invoices, Work Items, and Line Items tabs display the same summary totals:

• Total Invoice Count — The total number of invoices sent during the date range.
• Total Paid — The money paid to you from those invoices. This includes whole and partial payments.
• Total Outstanding — The total amount still owed on the invoices.
• Total Sales — The combined total of Outstanding and Paid. This is the total amount you can expect to collect from the invoices.

The Deposits tab focuses on invoices generated to collect deposit payments on future services, so it displays summary totals relevant only to deposit invoices:

• Deposit Count
• Deposit Paid
• Deposit Outstanding
• Deposit Total

When to use this report

The Invoice Details report provides a high-level summary of your billing while giving you the option to drill down into the details. Common uses include:

• Billing and Revenue Review
  • Checking which invoices have been paid, are outstanding, or are overdue
  • Reviewing total revenue for a specific time period (weekly, monthly, end of quarter)
  • Reconciling income against what was actually invoiced
• Customer Inquiries
  • Looking up a specific customer's billing history if they dispute a charge
  • Verifying what work items were included on a particular invoice
• Bookkeeping and Accounting
  • Exporting data to share with an accountant or bookkeeper
  • Comparing invoiced amounts to actual payments received
• Deposit Tracking
  • Reviewing deposit invoices alongside regular invoices for a complete picture of customer billing activity
• Franchise/Multi-location Owners
  • Reviewing billing across locations

Tips and tricks

• Date filters — For the most reliable date filtering, use the Last, Current, or Between date filter types. The On, Before, and After options may not work as expected.
• Drill down — Click a column value to view more information. For example, clicking 22 in the Invoice column opens invoice 22 in a new tab.

Filter options and report details by tab

The following table lists the filter options and report columns for each tab. Use these options to narrow and sort your report results.