Financial Summary

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.

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

See Discount Summary report.

Trial Balance

The trial balance section is the debit and credit section of the report formatted in a trial balance format.

Events Booked

See Booking Summary report.

 

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.