Detailed Accounting Report
Below you will find information relating to the filters and column data found in the Detailed Accounting Report and will provide a basic understanding of how it works and where the data is drawn from.
You can find this report under Trackside > Reports > Detailed Accounting Report.
FILTERS/TOOLS
Start Date
The start date filter allows you to specify the starting date of the interval and includes every order completed after, and including, the start date.
End Date
The end date filter allows you to specify the ending date of the interval and includes every order completed before, and including, the end date.
Order Type
The order type filter will allow you to select between one of two options, “Online Sales” and “Point of Sale”. The former will return all orders that were completed via online checkout or transfer, while the latter will return all orders completed via a POS (Point of Sale) machine.
Register Group
If you have POS machines that are separated into different groups, this filter will allow you to target a specific group of machines and return the sales records for those machines only.
Register
This filter will allow you to specify which POS machine within a given register group to target and to return all sales records for that particular machine only.
Payment Type
The payment type filter will allow you to filter all sales records for completed orders based on whether they were cash or credit sales.
Include Order Items
This filter is used as a toggle to add or remove the Order Items column to the table below. This column provides additional information by exposing each individual order item per order.
COLUMN DATA
Order#
The Order# column lists the number of each order in the specified period. An order might look like POS-# or WEB-#, where POS or WEB denotes whether it is a Point of Sale or Online Sale and the # is the current number for that type of order that always increments upwards.
Date
The date column features the completed date and time of each order.
Order Items
This column, when toggled to show, displays the individual order items that make up each order. The information will be in the format of “ticket name (ticket type / driver classification) (unit price)”
Type
The type column lists the type of each order. If it was a cash order via a POS machine, the type will reflect as "Point of Sale". If the order was completed via an online checkout or transfer the type would be reflected as "Online Sales".
Subtotal
The value in the subtotal column represents the subtotal for each individual order. The subtotal value is calculated by taking the unit price of each commerce order item and multiplying that by the quantity of that item in the order.
Fees Collected
Each and every order is subject to having fees applied to it. This column tracks the fees collected for each order.
Order Totals
An order total represents the sum of the order subtotal and the fee for that order.
Promotions/Coupons
Promotions/Coupons can be applied against an order as a whole or an individual order item to lower the amount a customer has to pay to purchase one or more tickets. This column tracks the total value of all promotions/coupons applied in the specified period.
Redeemed Gift Cards
Gift Cards can be generated and sold to customers to use at a date and time of their choosing. Whenever a gift card is redeemed against an order, that value is recorded in this column.
Paid Cash
The paid cash column represents the total amount paid in cash (via POS) by customers in the specified period. This amount reflects the order total minus promotions/coupons and gift cards etc.
Paid Credit
The paid credit column represents the total amount paid in credit (via online checkout or transfer) by customers in the specified period. This amount reflects the order total minus promotions/coupons and gift cards etc.
Net Revenue
The net revenue column represents the sum of the total paid in both cash and credit for the specified period.