POS Reports Overview
Daily Close
The Cash in Drawer Summary gives an overview of the financial status of your cash drawer for a particular day or range of days. It includes totals for cash, debit, credit and on account payments. Also provides a deposit total and credit/debit total as well as a breakdown of any register adjustments or payments.
The Cash Reconciliation Report gives an overview of the financial status of your cash drawer for a particular day or range of days. It includes totals for cash, debit, credit and on account payments. Also provides a deposit total and credit/debit.
The Cash-Out Sheet is for use when you are balancing your register. The “Cash Deposit” Tab, gives you the option to input the number of each type of currency. On the “Other Payment Types” Tab you are able to input the amount of each of the other payment types you have from that day. This will generate a report that shows what you have in the till compared to the POS amount. It is a blind cash count.
The Gratuities Report is a breakdown of the gratuities earned for each staff member that was logged in. Also shows the date, time, transaction ID and table details.
The Gratuity Payout Report is a breakdown per staff member of the gratuities received.
The Transaction Worksheet is a listing of all of the transactions for a day or range of days organized based on payment type. You are able to search for a specific transaction here and open it in the transaction viewer.
Sales
The Sales by Department Report can be run for all departments or a single department. It includes the department and items within the department, the amount, sales percentage, quantity, HST, and total. The sales percentage is the percentage of sales that that department or item represents of the total sales. If you are interested in seeing the percentage of weekday green fees that make up your green fee sales run the report for that department.
The Detailed Sales by Department Report shows the item, it’s SKU, the accounting number, amount sold, sales percentage, quantity sold and a total sales amount for the department.
A Cost of Sales by Department Report gives cost and profit information on inventory items that have their vendors and received inventory set up. The report gives details on the item, quantity sold, average unit cost, average sale price, total cost, total sales, margin and profit.
The Sales by Accounting Reference Report details the sales for each accounting reference. The report includes the reference number, account description, amount, sales percentage, quantity, HST, and total.
The Sales by Staff Member Report generates a report with the pre-tax amount of sales for each staff member. It includes staff name, member ID, number of items sold and the before tax amount of these sales.
A Detailed Transaction Report gives you all the critical information for individual transactions. It includes the transaction ID, date, time, customer, salesperson, items sold, payment type, the amount paid, subtotal and total. You can choose to show item detail, show items in dynamic combos, show transaction notes, only show transactions with notes & show back dated transactions.
The Item Sales History Report gives you the transaction details for all transactions that include a specified item. Includes date, time, transaction ID, customer name, customer ID, quantity sold and total.
The Hourly Sales Report creates a bar graph display of the sales per hour for a particular day or range of days. You can choose individual items, display the quantities on chart instead of the amount & view a text version of the report.
The Discount Report gives you detailed information on manual discounts that have been used. It includes the transaction ID, date, time, staff name, customer name, type of discount, item, original price and discount amount. It also includes and total discount amount for each staff member.
The Discount by Item Report gives details on items that were manually discounted and sold. Including item name, SKU, quantity, discounted sales total, retail price total, and discount total.
The Multiple Pricing Discount/Happy Hour Report gives you the transaction details for all transactions that included a multiple pricing discount. It includes transaction ID, date, time, staff name, customer name, type of discount, item, original price and discount amount.
The Tab Report is a listing of tabs that have been run. This report includes the customer name, open date, open time, open staff member, close date, close time, close staff member and the amount. If you would like to see the items that were on each tab they can be viewed using the tab history function.
The Tax Exempt Report lists the date, time, transaction ID, customer name and tax exempt ID for the customer. It also lists the total for the items that were marked as tax exempt.
- Export Items Sold
The Items Sold Report is an alphabetical listing of all of the items in the POS and details on the quantity sold, unit cost price, unit retail price, total cost price, total retail price, and total after tax.
Inventory
An Inventory Activity Report provides information on the beginning inventory, quantity sold, quantity received, adjustments and ending inventory for items in the POS that have been created as an “Inventory Item”.
A Detailed Inventory Activity Report gives you information on the beginning inventory, quantity sold, adjustments and ending inventory. As well as the quantity that was received and the cost of the lot and per inventory item.
An Inventory Listing by Department gives you a detailed list of all the items in your POS organized by the department they fall under. This listing provides you with the SKU, accounting reference number, quantity, reorder level, cost, markup, retail price and total cost.
The Inventory Reorder Report will generate a list of items that are at their specified reorder level. You are able to run this report for a particular department or vendor if you choose.
The Theoretical Cost Report is used for food and beverage items where it is difficult to judge the true cost; you can apply a theoretical cost to the item. The theoretical cost report gives you a breakdown of the quantity of each of these items that was sold, the theoretical cost of 1 and the total theoretical cost for the items.
TheItem Detail Report shows the details about modifiers used, raw materials used, discounts, item type, tickets, taxes.
- Checkin Configuration
TheCheckin Configurationreport shows you the fees configured for all of your time ranges and customer types. You have the option to Show All Fees, Show Green Fees, Show League Fees, Show Tournament Fees, Show 18 or 9 Holes only & show online pricing.
Members
The Account Adjustment Report is a report on the use of the Set Account Balance function. It lists the date and time of the adjustment, member’s name and ID, staff name and ID, date the adjustment was applied for, balance applied, current balance and account type (normal, membership, or deposit).
The Account Summary Report gives you a listing of your member’s accounts including the balance at the beginning of the month, purchases made on account, payments and the balance at the end of the month.
TheAccount Payment Detail Report shows you on account payment transactions for the chosen time period. The report displays the transaction ID number, date, time, customer name, Member ID/Username, Customer Type, Salesperson, Payment Type and Total.
An Aged Receivables Report gives you a breakdown of the balance on member’s accounts over set periods of time.
A Loyalty Balance Report generates a list of all of the members in your point of sale and the amount of loyalty points they have accumulated.
With a Loyalty Account Activity you are able to generate a statement for a golfer’s loyalty account activity. This report shows you the golfers points earned, points redeemed, total points and total dollars earned (Dollar Value is based on your loyalty configuration).
With a Loyalty Member Statement you are able to generate a statement for a golfer’s loyalty points. This provides information on the date of the purchase, transaction ID and the amount of points earned.
You can generate a Member List that includes all of your members or just specific member types. The report includes the customer name, member type, email address, address, city, province, postal code and phone number.
The Member Purchases Report will allow you to track the amount of a particular item that your members are purchasing. It will give you a breakdown for each member.
The Member Transactions Report gives you details on each purchase made by a particular member for a given month. Includes transaction ID, date, time, payment amount, payment type, item name, quantity and item total.
- Members with Account Privilege
The Members with Account Privilege Report generates a listing the member name and member IDs of those who have been given account privileges at the club.
The Membership Statement is a statement for the individuals membership account. Gives a summary of the date, transaction description, the amount and balance for the member’s membership account.
The Monthly Statement gives the details of the member’s account. It includes the date, transaction ID, the amount, current balance and loyalty point balance. You can generate statements for all members using the “Print Monthly Statements” or “Upload Monthly Statements” functions found at the bottom of the reports screen.
A Detailed Monthly Statement includes all of the information that the monthly statement does with the addition of the details of each transaction. For example, the item name, quantity purchased and price.
Transfer Account Balance is a detailed report showing any account balances that were transferred to another member’s account. Includes the date of the transaction, the name and member ID of the member the balance was transferred from and to, staff ID, transfer amount and the current balance of both member accounts.
The Retroactive Membership Payments Report gives you a list of your members and payments made against their membership to date.
- Deferred Membership Payments
TheDeferred Membership Payments Report gives you a list of your upcoming deferred membership payments. Choose the start and end dates and the payments coming out during that date range will show on the report. It shows you the Date, Transaction ID from the purchase, Item Name, Payment Amount, Qty & Total remaining.
- Deferred Payment Summary
Beverage Cart Sales
- Beverage Cart Sales
The Beverage Cart Sales Report gives you a total sales amount and quantity sold for the beverage cart on a given day.
- Beverage Cart Sales—By Staff Member
The Beverage Cart Sales by Staff Member gives you the sale information for each time a particular staff member was assigned to a cart. In addition to the quantity sold and sales amount for each day, the report also calculates the overall total for the particular staff member as well as their average sales.
- Beverage Cart Sales – Detailed
The Detailed Beverage Cart Sales Report generates a breakdown of the items sold, quantity sold and sales amount for a particular day and cart.
Gift Certificates
The Gift Certificate Report gives you details on each gift certificate for either all gift certificates or only outstanding gift certificates. Includes date, time, transaction ID, gift certificate ID, customer name, original amount, and current balance.
The Gift Certificate Activity Report lists the date, time, transaction ID, customer name, gift certificate ID and the amount that was redeemed.
The Gift Certificate Adjustment Report lists the date and time of the adjustment, gift certificate ID, staff name and ID, register the adjustment was performed on, and the balance that the gift certificate was set to.
Tickets
The Ticket Report is highly detailed and gives details of the item the ticket is linked to as well as the ticket. It includes the transaction ID, item, customer name, quantity sold and sale amount. For the ticket it includes the ticket name, ticket ID, quantity redeemed and expiry date.
The Tickets Redeemed Report lists the ticket that was redeemed, the item it was redeemed for and the quantity that was redeemed.
The Tickets Redeemed- Detailed Report lists the transaction ID, date, time, and staff ID in addition to the ticket that was redeemed, ticket ID, customer who redeemed the ticket and the quantity that was redeemed.
The Ticket Adjustment Report lists the date and time of the adjustment, ticket ID, staff name and ID, register the adjustment was performed on, and the balance that the ticket was set to.
The Tickets Expired Report shows how many tickets expired during selected time period and shows the value of the expired tickets.
Audit Reports
The Refund/Void Report gives the details of transactions that have been voided or refunded. Includes transaction ID, date, time, staff name, customer name, type, item name and the amount.
The Removed Order Items Report is a Table Service report that shows you any items that were placed on a table and then later removed. It includes the date, time, staff name, customer name, item name, quantity removed, table name and seating area name.
The Void/Reinstate Log Report is a listing of transactions that were either voided or reinstated. It includes the date, time, transaction ID, staff name, staff ID, and action type.
The Email History report gives you the email history for Gift Cards, Receipts, Statements, Tickets, Invoices, etc. It shows you the date, time, type of email, recipient's email address, the ticket/gift certificate number and the transaction number.
- Non-Checked in Prepaid Bookings
The Non-Checked in Prepaid Bookings report shows you which tee times that were prepaid were not checked in.