Unified Sales & Accounting Custom Report

The Unified Sales & Accounting Report is a new consolidated custom report available in the Console. It combines item-level sales details with transaction-level information into a single export, eliminating the need to download and merge multiple reports manually.

This enhancement is designed to support accounting and finance teams who require accurate, detailed data for reconciliation, margin analysis, and audit purposes.

Previously, accounting teams relied on multiple reports such as Sales by Item, COGS Report, and Register level report and manyally combined them which as time consuming. The Unified Sales & Accounting Report steamlines this workflow by providing all required data in one downloadable file.

Navigate to Reports→ Custom Reports → Unified Sales & Accounting Report

This report is built at the line-item level, meaning each row represents a single item sold within a specific transaction.

It combines:

• Item-level sales data

• Transaction-level attributes

• Cost and margin details

Key Data Fields Included:

Transaction Details

• Transaction Date

• Transaction #

• Transaction Type (Sale, Return, Refund, etc.)

• Register

Item Details

• Item ID

• Description

• UPC

• Department

• Category

• Subcategory

Sales & Financial Details

• Quantity Sold (net of sales and returns)

• Sales Amount

• Discount Code (applied at header or item level)

• COGS (Cost of Goods Sold)

• Gross Margin (Sales Amount – COGS)

If a discount is applied at the transaction level, it will appear alongside each relevant item. If the discount applies only to specific items, it will be shown only on those line items.

Available Filters

Before generating the report, users can filter the data using:

• Date Range: Select a custom date range using the standard report date selector.

• Venue: Select the venue to generate the report of the selected venue

• Store: Organization location hierarchy; generate the report of the selected store from selected venue

• Attributes: Select attributes (classifications) such as Department, Category, Sub Category

• Email Address: The report will be sent to the entered email address 

• Once selected the filters, user can click on Export to export the report to the entered email address.

The Unified Sales & Accounting Report provides a single, comprehensive export that combines item-level sales data with transaction-level details. It reduces manual effort, improves data accuracy, and supports faster financial reconciliation.

Articles in this section

• Item Import Field Descriptions
• Overview
• Merchant Onboarding
• Navigation Bar
• Reports
• Items
• Settings
• Dashboard Overview
• Company
• Register

See more