Reports

There are some reports that CERMS will generate after registers are closed. Below is a list of reports with their names and descriptions

Register Receipt - A printable receipt generated when a register is closed. This will show all information about the register and should be kept with the register until a manager can observe that everything is correct.

Register Report - An Excel spreadsheet that generates with "-register" at the end. This is a complete totals report for a single register with a single cashier assigned to it.

Final Report - An Excel spreadsheet that generates with "-final" at the end. A final report is generated at the opening of a dayshift register. This report will go from the previous day at 07:00 AM and contains all information from that day broken up into shifts.

Generated Report - An Excel spreadsheet that generates with "-generated" at the end. The report generates when you click "generate now" on the register page. It will start at 07:00 AM and continue until the current time, displaying all information broken up into shifts.

Register, Final, and Generated reports all have the same layout. The only difference is the data that is compiled. The type of report you look at determines if the report will show you an entire day's worth of information or just a single cashier. 

The Excel format breaks reports into two "sheets:" Detail and Summary.

Detail

At the top of this sheet, you will see CERMS, followed by the version you are running. You will see information about the report such as Cashier (if register report), start/end date/time, and register ID (will appear as random letters/numbers). The middle of the sheet is broken down into shifts. These shifts are NOT what is self-declared by the cashier. They are based on time. For example, if I open a register for the 7 AM-3 PM shift but I make a transaction at 3:30 PM, the information for that transaction will show up under the 3 PM-11 PM shift. You will see the following information in the middle of the report.

Dept. Total: Total amount of money from that shift

Tax: Amount of money that was from tax

Net: Total amount without tax

Cash: Total amount of cash taken in

CCard: Total amount of Credit Cards taken in

Gift Cards: Total amount of Gift Cards taken in

Over/(Short): The difference in cash from reported to taken in. If you do not see a number, the register was balanced perfectly. If you see a number in parenthesis "(10.00)" this means you are short that amount ($10 in this case). If the number is alone "10" you are over that amount ($10 in this case)

Next, at the bottom, you will see a list of all products sold during the shift. Depending on your system configuration, you may see a list of ALL products or just the ones sold. You will see the product name (under description), the amount sold, and the amount generated from it. 

NOTE: If a product has been marked a payout, it will be highlighted in red. The amount will also be surrounded by parenthesis "()", showing that it is a negative amount.

Summary

Just like the details page the top of this sheet will display information about the system version, start/end date/time, cashier name, and register ID. 

In the middle of the sheet, you will see a more broken-down layout of the transactions. The following are categories and their meanings

Biz Date: The date of this report

Shift: The shifts are broken up into times (again, not based on cashier declaration but based on the time of transaction)

Membership: Sales from memberships (if a product is checked as a membership)

Locker: Sales from lockers (if the product name has "locker" in it)

Room: Sales from rooms (if a product is a rental)

CounterTx: Sales from taxable products (without tax included)

SalesTx: Amount of tax generated (from taxable products without the product price included)

NoCounterTx: Sales from nontaxable products

PassThru: Not currently used (will show blank)

Payout: Amount that was paid out

Days Gross: Total shift gross

Totals: Totals of all categories

Below this information at the bottom you will see the following broken-down layout:

Biz Date: The date of this report

Shift: The shifts are broken up into times (again, not based on cashier declaration but based on the time of transaction)

Detail CCard: Amount sold from Credit/Debit Cards

Detail GCard: Amount sold from Gift Cards

Detail Cash: Amount sold from Cash

Detail Net: Total amount sold

Actual Cash: Amount of cash declared by the cashier at the closing of their register

Over/(Short): The difference in cash from reported to taken in. If you do not see a number, the register was balanced perfectly. If you see a number in parenthesis "(10.00)" this means you are short that amount ($10 in this case). If the number is alone "10" you are over that amount ($10 in this case)

Charge Total: Total amount charged from credit/debit cards

Totals: Totals of all categories

<-- Over Credit/(Under Debit): The difference in credit cards from reported to taken in. If you do not see a number, the register was balanced perfectly. If you see a number in parenthesis "(10.00)" this means you are short that amount ($10 in this case). If the number is alone "10" you are over that amount ($10 in this case)

If you have more questions regarding a register/final report, please create a support ticket. Attach the report to the support ticket so I can better look at the information and better answer questions.