Front End Reports
Overview
Front end reports means report From the till
Reports
Functions > Reports
Today's Report? Need Api
Today’s Sales – Total sales made today (not Inc Tax)
Last Year’s Sales – The sales on this day last year
Difference from Last Year – The difference between last years sales and this years sales () around the figure means down from last year
Percentage – Difference from last year expressed as a percentage
Comps – The number of comps and the sum of all comps applied
Voids – The number of Voids and the sum of all Voids applied
Discounts – The number of Voids and the sum of all Voids applied
Number On Clock – The number of people who are clocked in
Employees On Clock – A list of all employees who are clocked in with the Job Title they are clocked in with
Hourly Sales – Any hours that have sales will be listed here with the number of sales and the total amount for the hour (Not inc Tax)
Quick Report
Functions > Quick Report
Quick report has the same information as the End of Day report. However, it can be printed before the tills and banks are closed so it is a very comprehensive report
See End of Day Report
Print Till Report
Functions > Tills and Cashouts > Print Till Report
This report is exactly the same as the report that prints when you close the Till but is the
***Unofficial Copy***
Please See Till Report
Cashier Report
Functions > Tills and Cashouts > Cashier Report
Allows you to choose a cashier to run a Till report on. The information is exactly the same as the Closed till report but will run before closing the till and can be filtered to only show sales from particular employees. Also the ***Unofficial Copy***
See closed Till Report
Print Bank Report
Functions > Tills and Cashouts > Print Bank Report
This report is the same as the report that prints when you close the bank which is called the Server Bank Report but it is the ***Unofficial Copy*** and can be printed before the bank is closed
See Server Bank Report
Server Bank Report
This report prints when you close the Bank. If you do not close the bank then the report will print when performing an End of Day. It is for an individual’s Bank. The server name will print on the top of the report
Transaction Totals
Any payment method that was used will show under this section with the totals taken using next to each payment type. For example
Cash Transactions – Sum of all transactions made to cash
Credit Transactions – Sum of all transactions made to Credit
Total Transactions – Sum of all transactions
Tip & Gratuity Totals
Any Tips or gratuity will be listed here split into how they were paid. For example
Cash Tips – Sum of all Tips paid to Cash
Credit Gratuity - Sum of all gratuity paid to Credit
Total Tips – Sum of all Tips and Gratuity
Expected Totals
This section contains the expected totals for any payment method used whilst the Bank was open. For example
Expected Cash – Cash Transactions + Cash and Credit Tips – Total Tips (any tips are expected to be taken by the server in cash so are removed from the Expected Cash)
Expected Credit – Credit Transactions + any Credit Tips or Gratuity
Expected Total – The sum of all of the expected totals
Employee Stats
Discounts – Any Discounts applied by the employee
Comps – Any Comps applied by the employee
Pre Send Removals – Sum of any pre submit removals
Post Send Removals – Sum of any post send removals
Guests – The number of guests. There are settings to determine how guests are defined in back Office > Settings > POS > Guest Count Settings
Average Check – The total sales (Not Inc Tax) divided by the number of Checks/ Tickets
Category Sales
Will list all report categories with the sum of all sales for that category (Not Inc Tax)
Cash Totals
Expected Cash – The expected Cash inc Starting amount
Starting Funds – Back Office > Settings > Tills > Personal bank Settings there is a setting called Starting amount. If you turn this on then when you open a bank you will be asked to enter a starting amount. This amount will show in this field
Cash Deposit – Cash Expected Less the starting funds
Fee Groups -
Total Cash Due – Total cash due from the employee’s personal bank
Till Report
Prints when you close the Till. If you do not close the till then it will print when performing an End Of Day
Starting Amount – The amount entered when opening the Till
Transaction Total – A list of all payment types will show here with the amount (Inc Tax) that was settled to that payment type. For example
Cash Transactions – The sum of all cash transactions
Credit Transactions – The sum of all Credit Transactions
Total Transactions – The sum of all transactions for all payment types
Tip and Gratuity Totals- Tips and gratuity will be listed here by Payment Type and be added together ?? Tips appear to open their own bank even with banks turned off and they want to do deposit cash for the amount of the tip??
Total Tips – The sum of all Tips and Gratuity
Expected Totals- The different payment types will be listed here. For example
Expected Cash – Cash Transactions minus Total Tips + Starting Amount – pay outs + pay ins
Expected Credit – Credit Transactions + Credit tips or gratuity
Expected Total – The sum of all the expected totals
Other Payments
Custom Payment Types will be listed here along with the amount paid to credit and gratuity (Inc Tax)
Employee Stats
Pay Ins – Sum of all Pay Ins
Pay Outs – Sum of all Pay Outs
Guests – There are settings that determine what constitutes a guest. Back Office > Settings > Pos > Guest Count Settings
On Account – The sum of all transactions settled to account
Discounts – Any Discounts added
Comps – Any Comps added
Pre Send Removals – The sum of all pre send removals
Post Send Removals – The sum of all post send removals
Average Check – Net sales divided by the number of Checks
Category Sales
Any category that contains an Item that was sold will be listed here with the sum of all Items sold by category. (Not Inc Tax)
Employee Sale
List of all employees with their sales (Inc Tax)
Tax Code Sales
List of tax codes with sales and tax collected against each. For example
Default Taxrate Sales: $8.97
Default Tax Collected $0.60
Till/Bank Closeouts
Till/Bank Cash Total – ?? don’t know how to get this to populate. Tried declaring the bank before closing??
Cash Totals
Cash Expected – Cash Transactions minus Total Tips + Starting Amount
-Starting Funds – The amount you declared when opening the bank
+Till/Bank Closeout Cash
Cash Deposit – Cash Expected minus Starting Funds + Till/Bank Closeout Cash
Register Totals
Cash Deposit Total = Cash Deposit from above
Pay Outs – The sum of all Paid Outs
Discounts – The sum of all discounts applied
Non Cash Deposit Total – The sum of all payment totals apart from cash and account
On Account – Any transactions settled to an account
Grand Total – Cash Deposit Total + Paid Outs +Discounts + Non Cash Deposit Total + On Account
Sales Totals – Sum of all sold items (Not Inc Tax)
+ Tax Collected – The sum of all tax collected
-Discounts – The sum of all discounts applied
+ Tip Discount - ?????
-On Account – Any Sales settled to account
+Pay Ins – The sum of all Pay Ins declared
-Pay Outs – The sum of all Pay Outs declared
+ Starting Cash – The amount used to open the till
Expected Total – The total expected based on the calculations from the sales total. Sales total + Tax Collected -Discounts + Tip Discount – On Account + Pay Ins – Pa Outs + Starting Cash
End Of Day Report
This report runs when you process an end of day. It is a comprehensive report of the day’s activities. There are other reports that are printed at the same time as the end of day report. These can be turned on or off in the settings. They will be listed separately
Gross Sales – Sum of all sales before discounts / comps and tax not including event deposits
Refunds – Any refunds issued
Discounts/Promos– Any Discounts or promotions issued
Comps – Any Comps that were issued
Pay Ins – The sum of all pay Ins
Pay Outs – The sum of all Paid Outs
Fees Collected –
On Account – Total of all transactions settled to account (inc Tax)
Adjusted Gross – Gross Sales -Refunds -Discounts -Comps +Pay Ins – Pay Outs – On account transactions and tips
Tax Collected – The sum of tax collected for all payment methods
Giftcards Sold – The amount is the sum of the value of all sold Gift Cards
On Account – Total of all transactions settled to account (inc Tax)
Pay Ins – The sum of all pay Ins
Pay Outs – The sum of all pay Outs
Net Sales – Uses Adjusted gross, removes tax and gift cards the adds back in the paid in/paid out and on account transactions
Deposit Summary
Cash Trans – Total amount of cash sales (Inc Tax)
Cash Gratuity – Total amount of gratuity paid in cash
Tips Collected – The total of any tips paid. Tips made to other payment methods will be taken out of cash to pay the server so will be a negative figure here.
Pay Ins – Sum of all Pay Ins using the pay in function
Pay Outs – Sum of all Pay Outs using the pay out function
Fees Collected – ????
Cash Gratuity – ??
Cash Refunds – Refunds made to cash
Cash Event Deposits – Deposits taken against events paid for in cash
Cash Deposit Expected – How much the system calculates you should have in cash to deposit in the safe. Cash Gratuity will be removed from this figure as it assumes you will have paid it to the server???
Credit Trans – Total amount of sales paid using credit (Inc Tax)
Online Credit trans – Transactions paid for through the mobile order site
Credit Tips – Tips paid using credit
Credit Refunds – Refunds made to Credit
Credit Event Deposits – Deposits taken against events paid for with Credit
Credit Deposit Expected = Credit Trans + Online Credit Trans + Credit Tips – Credit Refunds + Credit Event Deposits
Check Trans – Total amount of sales paid for using Checks (Inc Tax)
Check Tips – Tips paid using Checks
Check Refunds – Refunds made to Check
Check Event Deposits – Deposits taken against events paid for with a Check
Check Deposits Expected = Check Trans + Check Tips –Check Refunds + Check Event Deposits
Gift Card Trans - Total amount of sales paid for using Gift Cards (Inc Tax)
Gift Card Tips - Tips paid using Gift Cards
Gift Card Refunds – Refund made to Gift Cards
Gift Card Event Deposits – Deposits taken against events paid for using Gift Cards
Gift Card Deposits Expected = Gift Card Trans + Gift Card Tips -Gift Card Refunds + Gift Card Event Deposits
Other Payment Trans – Total sales paid for using custom payment methods (Inc Tax)
Other Tips
Other Payment Event Deposits – Deposits taken against events paid for using one of the custom payment methods
Other Payment Expected = Other Payment Trans + Other Payment Tips + Other Payment Deposits
Expected Deposits –
Event Deposits – Any money taken as a deposit against an event
Adj Gross – Expected Deposits -Event Deposits
Discounts – Any Discounts that have been applied in the form of promotions
Comps – The sum of all comps that have been appliled
Pay Ins – The sum of all Pay Ins
Pay Outs – The sum of all Pay Outs
On Account – All payments made using Account as a payment method
Fees Collected
Gross Sales – Adj Gross + Discounts + Comps -Pay Ins + Pay Outs + On Account + Fees Collected
Expected Deposit Total – The sum of all expected deposits
Deposit Adjustment – any varience from the till declaration
Actual Deposit Total – Expected Deposit Total + or – Deposit Adjustment
Accounts Invoiced- The sum of anything paid with account as the payment type
Giftcards Sold – All giftcards sold
Giftcards Redeemed – Anything that was paid with giftcard as the payment type
Voided Transactions – All transactions that were voided (Cancelled sales)
Refunds – The sum of all refunds
Table Orders – The sum of all orders made with this order method (Inc Tax)
Bar Orders – The sum of all orders made with this order method (Inc Tax)
Retail – The sum of all orders made with this order method (Inc Tax)
Takeout – The sum of all orders made with this order method (Inc Tax)
Delivery – The sum of all orders made with this order method (Inc Tax)
For Here – The sum of all orders made with this order method (Inc Tax)
To Go – The sum of all orders made with this order method (Inc Tax)
Drive Thru – The sum of all orders made with this order method (Inc Tax)
Account Payments – The sum of all orders made with this order method (Inc Tax)
Deposits – The sum of all orders made with this order method (Inc Tax)
Guests – There are settings that affect this figure. Back Office > Settings > Pos > Guest Count Settings
Transactions – The number of tickets. If you split an order into 2 tickets then both of the tickets will count towards this number
Payments – The Number of payments made
Average Net Trans – Net sales divided by Number of tickets
Average Net Payment Trans – Net Sales divided by number of payments
Pre Submit Removals – Sum of pre submit removals
Post Submit Removals – Sum of Post submit removals
Other Payment Methods
Custom Payment Types will be listed here along with the gratuity. For example
Uber Eats
Uber Eats Gratuity
End Of Day Report
Shows all hours that had sales with the number of sales and the amount taken (Inc Tax)
End Of Day Category Trends
Shows all report categories that have sales with the sum of the sales for each category This will be the sale price of the items (likely not inc Tax)
Job Category Labor Report
The job categories will be listed here with the hours worked, labor cost and category percentage.
On Account Report
This report will list each invoice that was paid to account and any payments paid off the balance of an account
Employee Detail Comp Report
A list of all comps, who comped the item, how much the comp was for and the reason chosen when comping the item
If an override is required then the person mentioned here will be the person who authorized the override
Pay In/Out Detail Report
Lists all pay in and pay outs with the name of the person who performed the pay out, The date and time it happened, the amount it was for and any notes if they were entered
If an override is required then the person mentioned here will be the person who authorized the override
Manager Post Submit Removal Report
If an override is required then the person doing the override is considered a manager. These managers will be listed with the amount of removals and the total sale price for those items
Employee Post Submit Removal Report
This will list all of the employees that requested the post submit removal along with the amount of removals and the total sale price for those items
Pre Submit Removal Report
Each Employee will be listed here along with the amount of removals and the total sale price for those items
Coupon/Discount Report
A list of all Employees that have performed discounts will be shown with the amount of times a discount was applied and the sum of how much those discounts were worth
Pay In/Out Detail Report
A list of all comps, who comped the item, how much the comp was for and the reason chosen when comping the item
If an override is required then the person mentioned here will be the person who authorized the override
Pay In/Out Detail Report
Lists the following for all pay in or pay out events
Date and time
The employee that initiated the pay in or pay out
The amount Pay out will be in parenthesis (14.50) where as paid in will not 14.50
The reason given
This is the last of the End of Day Reports
View Transactions
This report can be accessed from the control panel. It will show all transactions that have been put through any terminal since the last End of Day was performed. You can see transactions prior to the last
The employee permission to view this report is called “View Transactions”
End of Day by using the Search Transactions button
The amounts shown here are the actual amounts taken so will include tax if any has been applied
Status – Currently this can be either Account which means it has been paid using an account. Completed means it has been paid for with one of the usual payment methods. Voided means that the payment has been voided from the control panel and the sale has been canceled
Order ID – The Order ID is what is sent to the kitchen to link the printouts together. It also lilnks the invoices. If you split the order into 2 tickets then the invoice number will be different for each ticket but the order number will be the same you can see that they were part of the same order
Ticket -
Invoice ID – The ID attached to the invoice. Each ticket is a different invoice so if you split the ticket into 2 tickets the order number will be the same but the invoice number will be different
Terminal – The terminal that settled the transaction
Method – The order method used
Customer – Customer name if available
Cashier – Name of the Cashier that settled the transaction
Date and Time – Date and time the transaction was settled
Total – How much the transaction was settled for
Searching for Transactions
In View Transactions Click Search Transactions and you will see the following screen
You can use the various search criteria here to narrow the search for a specific transaction
Transaction Details
You get to this from Functions > View Transactions > Highlight the transaction and click on View Transactions
This report shows all off the details from the transaction report and adds a list of the items that were ordered and how exactly the transaction was paid.
From here you can void the transaction or reprint a receipt if the customer lost theirs
Receipts/Tickets
This is a great report. It shows every ticket that has been sent to an order printer and allows you to reprint it
The employee privilege for this is called Kitchen Tickets
Time – When the ticket was printed
Printer – The name of the printer the ticket was sent to. This is the printers friendly name. The name that is used when setting up the printer in the print server. (little blue icon in the system tray) It is a good idea to call it something that easily identifies it. In this case it is called REC01 as it is the receipt printer for Till 1 but if that is also the coffee dispense you may want to call it coffee instead
Status – Tells you if the print was successful or not
Terminal – Which terminal sent the order
Ticket # - This is refered to on the actual ticket stub as REF#
Seq # - This number prints out on every ticket in the kitchen. It increases by one every time ticket is printed. The idea is that if you get a ticket printer with Seq#4 then the next one is 6 you know you are missing number 5. In which case you go to this report. Find the printer in question (you can filter by printer on the drop down menu) find Seq#5 and reprint it.
You may also want to reprint the ticket if it is lost or damaged
Items on Receipt –A list of all items on the ticket with quantities and Prices
Reprint Selected – Will reprint the selected ticket
Manage Stations – Will present you with a list of the 10 printer stations. You can enable or disable each station from this location. This will stop any orders being printed to that station from any till.
Employee Control Panel
This report will show you open and closed orders by employee since the last End of Day
The employee privilege for this override is called Employee Control Panel
Drop down menu1 – Allows you to filter the results by Job Titles
Drop Down Menu2 – Allows you to filter the results by either Clocked In, Clocked out or All
Clock – Red or Green. Red is Not clocked it Green is clocked in
Name – Employee Name
Open Orders
Time – Time the order was opened
Type – The Order Type. Table, For Here etc
# - Table number or Order ID
Section – Which Section the table is in
Name – The name of the customer for takeout and delivery orders
Closed Orders
Time – Time the order was closed
Type – The Order Type. Table, For Here etc
# - Table Number or Order ID
Section – Which section the table is in
Name – The name of the customer for takeout and delivery orders
Invoice ID – Now the order has been paid it is assigned an invoice ID
If you click on one of the orders another windows will open with the order information
QTY – How many of that item there are
Name – The name of the Menu Item
Price – This is the sale price
Employee – Employee Name
Time Added – The Time the Item was added to the order
Comps
Employee – The name of the employee who initiated the comp
Manager – The name of the employee who authorized the override
Item Name -Menu Item Name
Amount – The amount that was comped
Time – Time the comp happened
Reason – Reason chosen by the employee
Removed Items
Removed items include both pre and post submit removals
Item_id – This related to the Item_id in the menu_items table in the OrderCounter database
Employee – Name of the employee who removed the item
Manager – Name of the employee who authorized the override
Amount – The sale price of the item that was removed
Time – Time the item was removed
Reason – Reason chosen when removing the item.
Receipts / Tickets
Gift Cards
Gift cards allows you to see 2 reports
Balance Inquiry will show you the current balance
History Inquiry Shows you the cards spending history and allows you to print that history
Please reference this guide for any updates or changes: https://tinyurl.com/ocmanualp
Related Articles
Quick Report
Quick Report has the same information as the End of Day report. However, it can be printed before the tills and banks are closed so it is a very comprehensive reportPay In & Pay Out
Pay In/Pay Out Creates a transaction to add/remove funds on a Till/Bank assigned to a User logged in. 1. Login 2. Select Functions from the top right corner 3. Select Pay In & Pay Out from the Functions Menu. 4. Select Pay In Or Pay Out 5. Enter ...Add/Remove Cashier On Till
1. Login 2. Select Functions from the top right corner 3. Select Tills and Cashouts from the Functions Menu. 4. Select Add or Remove Cashier If Removing a cashier, Select the Cashier from the list and select Remove Cashier 5. Select and Add User ...Today's Report
Today's report shows a detailed summary report of today's sales. You can access today's report from the Control Panel. Today’s Sales – Total sales made today. Does not include tax Last Year’s Sales – The sales on this day last year. Difference from ...Viewing Transactions
This report can be accessed from the Control Panel. It will show all transactions that have been put through any terminal since the last End of Day was performed. You can see transactions prior to the last End of Day by using the Search Transactions ...