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.
For a cash basis report, please see QuickBooks’ Sales by Product/Service Detail report.
For a report of specific Ecommerce Product purchases, see Novi's Ecommerce Sales Report.
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:
Total revenue for the revenue category
Total revenue from the previous period
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
Accounting
Num
Memo/Description
Class
Department
Account
Open Balance
Overdue Balance
Open Dues Balance
Overdue Dues Balance
Billing Notes
A/R Paid
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:
Select all the items to be changed.
Click the drop down arrow next to Batch actions
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