Summary of financial information with several sections containing financial information in different formats.
Parameters
Start Date - start date of sales in range
Start Hour - start hour of sales in range
Start Minute - start minute of sales in range
Start Second - start second of sales in range
Group By - select the column by which the report should be grouped for summaries
Show Sessions on Deferred Basis - by default, session revenue is recognized when the payment is received. Optionally, you can report session revenue on an accrual basis.
Section to Show - many sections appear in this report. Optionally, run the report with only the sections you wish to see.
Charge Card Summary By - select how to group the Charge Card Summary section.
Events Booked By - select the employee name or all customers who initially booked the event.
End Date - end date of sales in range
End Hour - end hour of sales in range
End Minute - end minute of sales in range
End Second - end second of sales in range
Sales Summary Display Option - select how you would like to group the Sales Summary section.
Discount Summary Columns to Show - select which columns to show in the Discount Summary section.
Discount Summary Group By - select how to group the Discount Summary section.
Location - filter the report values by location.
Transaction Source Category - filter where the transaction is created through Online or On-Site.
Transaction Source Type - filter what type of transaction source it is.
Debits and Credits Section
Financial information is displayed in an accounting format of debits and credits. Click the square plus icon to expand for more detail. Click the square minus icon to collapse the detail. Click the hyperlinks to drill through to more detail.
The Grand Total Debits should equal Grand Total Credits, except for sales tax rounding. See Transactions that Do Not Balance section for further information if Grand Total Debits do not equal Grand Total Credits.
Pending Transactions Section
Pending transactions are often a cause of the Grand Total Debits not equaling the Grand Total Credits. Even if the report is in balance, it is advised to resolve pending transactions.
Transactions that Do Not Balance Section
See a listing of the transactions where the debits (payments) do not match the sales (credits). You may see several transactions that are off by a penny or two. This is due to sales tax rounding and should be adjusted for in your journal entry for sales tax. If there are transactions with larger differences, email support@aluvii.com with a screenshot of the header of the report that shows the parameters used to run the report.
Closed Cash Till Summary Section
Summary of the tills used during the report's date/time range. Click the hyperlinks to drill through to more detail.
Charge Card Summary Section
Summary of the charge card payments during the report's date/time range. Click the hyperlinks to drill through to more detail.
Cost of Goods Sold Summary Section
For products with a unit cost sold during the report's date/time range, the cost of goods sold debit and corresponding inventory credit will be shown. Click the square plus icon to expand for more detail.
Additionally, a table of Net Sales, Net Unit Cost, and Gross Profit grouped by Accounting Code Description is provided for further detail. Click the hyperlinks to drill through to more detail.
Sales Summary Section
A table showing a sales summary grouped by the attribute selected in the parameters additionally displays Gross Sales, Discounts, Refunds, Net Sales, Sales Tax, and Grand Total.
Sales Summary by Sales Tax Option
See Sales by Sales Tax Option report.
Labor Cost Analysis Section
See Labor Cost Analysis report.
Discount Summary
Refunds Section
See Refund Report.
Trial Balance
The trial balance section is the debit and credit section of the report formatted in a trial balance format.
Events Booked
Payment Breakdown
Sales broken out by payment type columns. If a transaction is paid for with a single tender type (payment method), the sales on that transaction can be broken out by payment type. If there are more than one tender type used to pay for a transaction, see the Split Payments section next.
Split Payments
A split payment is when a single shopping cart is paid for using more than one tender type (payment method). Transactions with split payments are presented with the products purchased along with the payment methods and amounts, so that a human can allocate payment types to the products as desired. This is not done programmatically, because scenarios and use-cases become complex with a) preferences on allocation methods (pro-rata or first payment type to first products added to the cart or last payment to first products added to the cart, etc.), b) partial refunds paid with a different allocation method than the original sale, c) etc.
Comments
Please sign in to leave a comment.