If you are looking for a daily summary report, you are in luck. The recent sales transactions screen should fill most needs. You can change the time frame by using the filter function. The information can be exported to excel, CSV, or PDF by using the export function.

Finally, columns can be customized. Just hover over one of the column headers, select the down arrow, and check the boxes for the columns that you want to see. You can reorganize the column order by dragging and dropping.

Details on the Metrics:

Taxable Sales:

If “Tax Retrieved From” = ‘Calculation’, then Taxable Sales = [ ((Ending Reading from the Register Readings tab – Beginning Reading from the Register Readings tab – Total of ‘Taxable’ sales from the Catering Sales tab) ¸ (1 + State/Province Tax Rate %)) – Non-Taxable Sales from the Totals tab – Charged Tips from the Totals tab ].
If “Tax Retrieved From” = ‘Manual’, then Taxable Sales = [ Ending Reading from the Register Readings tab – Beginning Reading from the Register Readings tab – Sales Tax from the Totals tab – Non-Taxable Sales from the Totals tab – Catering Sales from the Totals tab – Charged Tips from the Totals tab ].
If “Register Readings Exclude Catering” = ‘Yes’, this will not be part of either calculation.
If “Register Readings Exclude Charged Tips” = ‘Yes’, this will not be part of either calculation.
If “Enter Register Readings” = ‘Net’:
And if “Tax Retrieved From” = ‘Calculation’, then Taxable Catering Sales and “(1 + State/Province Tax Rate %)” will not be part of the calculation.
And if “Tax Retrieved From” = ‘Manual’, then “Sales Tax” will not be part of the calculation.

Non-Taxable Sales = [ Total Tax Exempt Amount from the Register Readings tab – Total of Non-Taxable Sales from the Catering Sales tab ].

If “Register Readings Exclude Catering” = ‘Yes’, then “Total of Non-Taxable Sales” will not be part of the calculation.

Catering Sales:

If “Tax Retrieved From” = ‘Calculation’, then Catering Sales = [ ((Total of Taxable sales from the Catering Sales tab) ÷ (1 + State/Province Tax Rate %)) + Total of Tax Exempt Sales from the Catering Sales tab ].
If “Tax Retrieved From” = ‘Manual’, then Catering Sales = [ ((Total of Taxable Sales from the Catering Sales tab) – Value of “Memo: Catering Sales Tax” from the Sales Tax tab) + Total of Tax Exempt Sales from the Catering Sales tab ].

Total Net Sales = [ Taxable Sales + Non-Taxable Sales + Catering Sales ]; from the Totals tab.

Sales Tax:

If “Tax Retrieved From” = ‘Calculation’, then Sales Tax = [ (Taxable Sales from the Totals tab x State/Province Tax Rate %) + (Total of ‘Taxable’ sales from the Catering Sales tab x (State Tax Rate % ÷ (1 + State/Province Tax Rate %)) ].
If “Tax Retrieved From” = ‘Manual’, then Sales Tax = Total value of all entries from the Sales Tax tab.

Charged Tips = Charged Tips from the Register Readings tab.

Overrings = Overrings from the Register Readings tab.

Gross Sales = [ Total Net Sales + Sales Tax – Overrings ]; from the Totals tab.

Non-Register/Gift Sales = Non-Register/Gift Sales from the Register Readings tab.

Catering Accounts = Total of all “Account” Payment Method charges, from the Catering Sales tab.

Complimentary = Total of all entries from the Comps & Discounts tab.

Payment Media 1 = Total of all “Payment Media 1” entries from the Non-Cash Media tab.

Payment Media 2 = Total of all “Payment Media 2” entries from the Non-Cash Media tab.

Payment Media 3 = Total of all “Payment Media 3” entries from the Non-Cash Media tab.

Paid Outs = Total of all entries from the Paid Outs tab.

Book Cash = [ Gross Sales + Non-Register/Gift Sales – Catering Accounts – Complimentary (non-Sales GLs only) – Payment Media 1 – Payment Media 2 – Payment Media 3 – Paid Outs ]

Bank Deposits = Total value of all entries from the Bank Deposits tab.

Over/Short = [ Bank Deposits – Book Cash ]

Click the Disk (Save) icon to save your changes.
If necessary, click the Printer (Export) icon to download and print the entries on this tab.
If necessary, click on any other tab as needed to configure settings on that tab. If not, skip to the next step.
When all entries have been completed for the selected register & date, click on the Totals tab to view the results.
When finished, click the Disk (Save) icon, then click the X (Close) icon to exit the screen.

To print the Sales Entry report for the information entered on all tabs, click Print All Transactions.

Sales Details: Paid Outs

If there are paid outs that need to be entered for this day, they will show on the Paid Outs tab. The General Ledger Name drop-down includes all GL accounts associated with one of the following expense GL Groupings:

Cost of Goods Sold
Operating Expenses
Other Expenses
Payroll

Gift Certificate sales and redemptions are often processed as Paid Outs; they are linked to a P&L Substructure that is linked to the “Liability” GL Grouping.

Gift Certificate Sale = a negative “Paid In” value, which will increase Book Cash.
Gift Certificate Redemption = a positive Paid Out value, which will decrease Book Cash.

Sales Details: Non-Cash Media

If there are credit card or other non-cash sales to be entered for this day, they will show on the Non-Cash Media tab. “Non-Cash Media” are shown grouped by one of the following payment media P&L Substructures, which are linked to non-cash media names in the corporate database.

Payment Media 1, Payment Media 2, Payment Media 3

Sales Details: Bank Deposits

The deposit amounts for the day.

Sales Details: Sales Tax

Sales tax data for the day

Sales Details: Sales

The Sales tab is used for sales transactions for different parts of the day and to categorize the sales by General Ledger account. This tab contains all General Ledger categories that are linked to the "Sales" GL Grouping, except accounts linked to the "Promo", "Beverage Promo", "Food Promo", and "Other Promo" P&L Substructures.

Sales Total = The sum of all “Value” entries on this tab.

Sales Discrepancy = Total Net Sales – “Sales Total” + the sum of all “Value” entries on the Comps & Discounts tab.

Sales Details: Totals

The Totals tab displays a summary of all the sales information for this register and day.