Basic Accounting Report
Below you will find information relating to the filters and column data found in the Basic Accounting Report and is designed to provide a basic understanding of how it works and where the data is drawn from.
FILTERS/TOOLS
Interval
The interval filter will allow you to specify how the sales records will be grouped within the selected period. The options for this filter are daily, weekly and monthly. Each sales record is fed into one of the interval options, and within the specified period, based on the completed date of that order. For the weekly interval option, it will take every day between the start of Sunday at midnight through to the next Saturday.
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.
COLUMN DATA
Period
The period column is based off of the Interval form input where one of three values can be selected: daily, weekly or monthly. Examples of the output of each period are as follows:
Daily: 05/28/24
Weekly: May 26, 2024 - Jun 1, 2024
Monthly: May, 2024
Subtotal
The values found in the subtotal column represent the combined subtotals for all orders within the specified interval. The subtotal values are calculated by taking the unit price of each commerce order item and multiplying that by the quantity of that item in the order. This calculation occurs separately for cash and credit sales, and so we combine those to cover all web-based and POS orders in the given period.
Fees Collected
Each and every order is subject to having fees applied to it. This column tracks the fees collected for all orders in the specified period.
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.