Skip to main content

Item Sales Report

See detailed sales data from QuickBooks tied to Member record data in Novi.

Jaime Morgan, CAE avatar
Written by Jaime Morgan, CAE
Updated this week

While QuickBooks Online should always be considered the system of record for accounting, Novi provides non-QuickBooks users with access to an Item Sales report. This report includes sales data from QuickBooks combined with membership details from Novi AMS.

The items shown in this report are all of the items available in QuickBooks Online. Sales are on an accrual basis, so they are counted when billed, not collected.

In this Article:


Viewing the Item Sales Report

Main Report

Access the Item Sales report on the backend of Novi in the left navigation under Reporting and then click Item Sales.

Within the report, there are 3 tabs: Summary, Details, and Item Mapping.

Specific Member Record

To view the Item Sales for a specific member, navigate to the Accounting tab on the member's record and then click on the Sales sub-tab.


About the Item Sales Stage Summary Cards

The top of the summary view includes an item sales stage with cards that summarize item sales by overall item sales total and also breaks out summaries by revenue category. The stage cards are dynamic and will reflect the filters applied to the summary report list view (see the section on the Summary Tab below.)

Note: There may be instances when additional revenue is not visible to Novi. QuickBooks Online should be the ultimate source of accounting data.

Each staging card contains:

  1. Total revenue for the revenue category

  2. Total revenue from the previous period

  3. The percent change from the previous period


The Summary Tab

Below the staging cards is a list view of the items sold in the selected period. It includes the Item (Product/Service), quantity sold, total amount, and revenue category for each item.

The Action column on the far right has a View All link. This opens to a filtered view of the details tab for that particular item.

To sort the Summary tab by a particular column, click the column header:

Filters on the Item Sales Detail Report:

By default, the summary tab displays the last 365 days. Click the Filter button to change what is included in the list view and what's shown on the staging cards.

  • Revenue Category

  • Items (Products & Services)

  • Report Period

  • Transaction Date From

  • Transaction Date To


The Details Tab

The Details tab shows the past 365 days of data, listing items alphabetically with their date, member, quantity, price, total amount, revenue category, and member type.

The Details tab includes the following types of transactions:

  • Invoices

  • Sales Receipts

  • Credit Memos

  • Refunds

Filters on the Detail Tab

Click the Filter button to change the information included in the detail view.

  • Revenue Category

  • Items (Products & Services)

  • Member Type(s)

  • Member(s)

  • Report Period

  • Transaction Date From

  • Transaction Date To

  • Final Payment Date From

  • Final Payment Date To

Filters When Viewing the Report on a Specific Member Record

When viewing this report on a specific member record, the Member Type(s) and Member(s) filters will not be included, and there will be an additional filter for:

  • Relationship Type

    • All Related

    • Member & Children

    • Member Only (default)

Display Columns in the Details tab:

The default columns that display in the report are:

  • Item (Product/Service)

  • Date

  • Member

  • Quantity

  • Price

  • Total Amount

  • Revenue Category

  • Member Type (Effective)

Tip: Add Additional Columns with the List View Gear

Additional columns can be added to the report by selecting them using the gear icon on the far right:

In addition to the columns regularly available in list views, these display columns are also available under the gear icon:

  • Details

    • Description

    • Date

    • Payment Dates

    • Final Payment Date

    • Member

    • Revenue Category

    • Related Event

    • Related Products


Item Mapping

The mapping on this tab determines how Novi categorizes the sales of each item in the report. This mapping will not affect your financials in QuickBooks.

How Items are Categorized

By default, Novi categorizes item sales based on the following rules:

  • Dues: If an item is attached to a dues rule.

  • Events: If an item is attached to an event ticket and not a dues rule

  • Ecommerce: If an item is connected to a product and not a dues rule or event ticket.

  • Other: If an item is not mapped within Novi.

Filters on the Item Mapping Tab

By default, the Item Mapping tab includes all items in any revenue category. Filters on the item mapping tab include:

  • Account(s)

  • Revenue Category

  • Default Overwritten

Changing an Item's Revenue Category

The revenue category can be changed using the drop downs in the Revenue Category Mapping column.

To change the revenue category or reset the category of multiple items:

  1. Select all the items to be changed.

  2. Click the drop down arrow next to Batch actions

  3. Select the change to be made: Assign Revenue Category or Reset to Default.

Assign Revenue Category will open a modal that shows the number of records (items) that will be affected, and a dropdown to select the New Revenue Category.

Reset to Default changes the selected items back to the original category set in Novi. A single item can also be reverted by clicking the link Revert to Default in the action column next to the item.


Related Articles

Did this answer your question?