Sample Drawer Report   

Purpose

A sample Drawer Report and description of the fields are listed below.

 

Note:  The sample report may differ from the actual report.  The options used to configure the report will determine the actual output of the report.

 

Figure 8.156 Sample Drawer Report

Focus Café
            Cash Tray Page 1
 
5/24/200X 1:02:00 PM
========================================
Focus (Drawer 1)
STATUS : CLOSED
TIME OPENED : 05/23/0X 2:23 PM
TIME CLOSED : 05/23/0X 9:05 PM
ASSIGNED    : Adam N.
              Jerrold R.
              Jessica
              Micheal N.
              Operations
              Kristen
              Jeff M.

========================================

I N V E N T O R Y  C O U N T S

----------------------------------------

       Beg   Add   End   Qty   Qty Over/

 Item  Qty   Qty   Qty  Used  Sold Short

----------------------------------------

Red Bull             

       34      0    34     0     0     0

Red Bull SF             

       15     0     14     0     0    -1

========================================

P A Y M E N T S  S U M M A R Y
----------------------------------------
Gross Cash             92         521.92
Paid Outs               0           0.00
CC Tip Fee                          0.00
Tips Paid Out                       0.00
----------------------------------------
Net Cash                          521.92
Visa                    8          86.68
Mastercard             10          87.04
AMEX                    2          31.15
Discover                0           0.00
Diners                  0           0.00
Gift Card               4          16.64
Account                 0           0.00
----------------------------------------
TOTAL PAYMENTS                    743.43
========================================
G R A T U I T I E S
----------------------------------------
Tips Owed To:
   Rafael A.                  5.95
                             -----
 Total Tips Owed By Me:       5.95
========================================
P A Y M E N T S  D E T A I L
----------------------------------------
Cash
 Chk #    Amount       Tip     Total
----------------------------------------
| Refund | -28.21 |    0.00 |  -28.21 |
| 120    |   6.84 |    0.00 |    6.84 |
| 121    |   8.69 |    0.00 |    8.69 |
| 122    |  18.86 |    0.00 |   18.86 |
| 123    |   5.43 |    0.00 |    5.43 |
| 125    |  13.67 |    0.00 |   13.67 |
| 126    |  13.35 |    0.00 |   13.35 |
| 127    |   0.00 |    0.00 |    0.00 |
| 128    |   5.16 |    0.00 |    5.16 |
| 130    |   4.34 |    0.00 |    4.34 |
| 131    |   7.06 |    0.00 |    7.06 |
| 134    |   1.62 |    0.00 |    1.62 |
| 135    |   0.00 |    0.00 |    0.00 |
| 136    |   8.20 |    0.00 |    8.20 |
| 138    |  11.93 |    0.00 |   11.93 |
| 139    |   0.00 |    0.00 |    0.00 |
| 141    |  15.83 |    0.00 |   15.83 |
| 142    |   7.59 |    0.00 |    7.59 |
| 143    |   0.00 |    0.00 |    0.00 |
| 145    |   0.00 |    0.00 |    0.00 |
| 147    |   0.00 |    0.00 |    0.00 |
| 150    |   5.42 |    0.00 |    5.42 |
| 151    |   7.92 |    0.00 |    7.92 |
| 153    |   5.43 |    0.00 |    5.43 |
| 154    |   7.60 |    0.00 |    7.60 |
| 155    |   1.09 |    0.00 |    1.09 |
| 156    |   7.33 |    0.00 |    7.33 |
| 157    |   0.00 |    0.00 |    0.00 |
| 159    |   7.06 |    0.00 |    7.06 |
| 160    |   6.83 |    0.00 |    6.83 |
| 162    |  15.62 |    0.00 |   15.62 |
| 163    |   4.66 |    0.00 |    4.66 |
| 164    |   4.34 |    0.00 |    4.34 |
| 165    |  10.00 |    0.00 |   10.00 |
| 167    |   0.00 |    0.00 |    0.00 |
| 168    |   0.00 |    0.00 |    0.00 |
| 169    |   5.74 |    0.00 |    5.74 |
| 170    |   5.43 |    0.00 |    5.43 |
| 171    |   0.00 |    0.00 |    0.00 |
| 172    |   3.80 |    0.00 |    3.80 |
| 173    |   5.97 |    0.00 |    5.97 |
| 174    |   0.00 |    0.00 |    0.00 |
| 175    |   4.34 |    0.00 |    4.34 |
| 176    |   0.00 |    0.00 |    0.00 |
| 177    |   7.60 |    0.00 |    7.60 |
| 179    |   4.66 |    0.00 |    4.66 |
| 181    |   6.51 |    0.00 |    6.51 |
| 182    |   7.06 |    0.00 |    7.06 |
| 183    |   3.58 |    0.00 |    3.58 |
| 184    |   9.33 |    0.00 |    9.33 |
| 185    |  13.90 |    0.00 |   13.90 |
| 186    |   6.50 |    0.00 |    6.50 |
| 187    |   5.48 |    0.00 |    5.48 |
| 188    |  16.27 |    0.00 |   16.27 |
| 189    |   4.66 |    0.00 |    4.66 |
| 190    |  11.27 |    0.00 |   11.27 |
| 191    |  16.06 |    0.00 |   16.06 |
| 192    |   4.66 |    0.00 |    4.66 |
| 193    |   7.06 |    0.00 |    7.06 |
| 194    |  13.34 |    0.00 |   13.34 |
| 195    |   6.24 |    0.00 |    6.24 |
| 196    |   6.83 |    0.00 |    6.83 |
| 197    |  10.07 |    0.00 |   10.07 |
| 198    |  11.22 |    0.00 |   11.22 |
| 199    |   0.00 |    0.00 |    0.00 |
| 205    |   7.86 |    0.00 |    7.86 |
| 208    |   8.14 |    0.00 |    8.14 |
| 209    |   0.90 |    0.00 |    0.90 |
| 210    |   5.64 |    0.00 |    5.64 |
| 211    |  25.05 |    0.00 |   25.05 |
| 212    |   0.00 |    0.00 |    0.00 |
| 213    |   8.15 |    0.00 |    8.15 |
| 214    |   7.06 |    0.00 |    7.06 |
| 215    |   5.16 |    0.00 |    5.16 |
| 216    |   0.00 |    0.00 |    0.00 |
| 219    |   7.28 |    0.00 |    7.28 |
| 220    |   4.34 |    0.00 |    4.34 |
| 222    |   0.00 |    0.00 |    0.00 |
| 224    |   7.64 |    0.00 |    7.64 |
| 225    |   0.17 |    0.00 |    0.17 |
| 226    |  12.27 |    0.00 |   12.27 |
| 227    |   1.63 |    0.00 |    1.63 |
| 228    |   7.60 |    0.00 |    7.60 |
| 229    |  10.85 |    0.00 |   10.85 |
| 230    |   1.52 |    0.00 |    1.52 |
| 231    |   0.00 |    0.00 |    0.00 |
| 232    |   7.37 |    0.00 |    7.37 |
| 233    |   1.00 |    0.00 |    1.00 |
| 233    |   5.30 |    0.00 |    5.30 |
| 234    |   5.43 |    0.00 |    5.43 |
| 236    |   0.32 |    0.00 |    0.32 |
| 237    |   0.00 |    0.00 |    0.00 |
----------------------------------------
  Total    521.92      0.00    521.92
----------------------------------------
Gift Card
 Chk #    Amount       Tip     Total
----------------------------------------
| 180-1  |   5.74 |    0.00 |    5.74 |
| 202-1  |   9.76 |    0.00 |    9.76 |
| 205-1  |   0.68 |    0.00 |    0.68 |
| 205-1  |   0.46 |    0.00 |    0.46 |
----------------------------------------
  Total     16.64      0.00     16.64
----------------------------------------
Visa
 Chk #    Amount       Tip     Total
----------------------------------------
| 133-1  |   4.34 |    0.00 |    4.34 |
| 140-1  |  21.28 |    0.00 |   21.28 |
| 144-1  |   8.69 |    0.00 |    8.69 |
| 146-1  |  17.90 |    0.00 |   17.90 |
| 161-1  |  11.91 |    0.00 |   11.91 |
| 166-1  |   4.66 |    0.00 |    4.66 |
| 200-1  |  11.40 |    0.00 |   11.40 |
| 204-1  |   6.50 |    0.00 |    6.50 |
----------------------------------------
  Total     86.68      0.00     86.68
----------------------------------------
MasterCard
 Chk #    Amount       Tip     Total
----------------------------------------
| 132-1  |   3.87 |    0.00 |    3.87 |
| 137-1  |  10.09 |    0.00 |   10.09 |
| 148-1  |  10.30 |    0.00 |   10.30 |
| 152-1  |   6.51 |    0.00 |    6.51 |
| 158-1  |   8.46 |    0.00 |    8.46 |
| 178-1  |   7.60 |    0.00 |    7.60 |
| 217-1  |   5.43 |    0.00 |    5.43 |
| 218-1  |  14.17 |    0.00 |   14.17 |
| 223-1  |   5.43 |    0.00 |    5.43 |
| 235-1  |  15.18 |    0.00 |   15.18 |
----------------------------------------
  Total     87.04      0.00     87.04
----------------------------------------
AMEX
 Chk #    Amount       Tip     Total
----------------------------------------
| 124-1  |  24.09 |    0.00 |   24.09 |
| 221-1  |   7.06 |    0.00 |    7.06 |
----------------------------------------
  Total     31.15      0.00     31.15
----------------------------------------
CC Total   204.87 |    0.00 |  204.87 |
----------------------------------------
 Payment       Amount    Tip   Total
----------------------------------------
 Visa           86.68   0.00   86.68
 MasterCard     87.04   0.00   87.04
 AMEX           31.15   0.00   31.15
 Discover        0.00   0.00    0.00
 Diners          0.00   0.00    0.00
 Gift Card      16.64   0.00   16.64
 Account         0.00   0.00    0.00
========================================
C A S H  D E T A I L
Declared Cash                     672.25
Net Cash                         -521.92
Starting Bank                    -150.00
                                   -----
Cash [Over]/Short                   0.33
 
Declared Check Total                0.00
Check Total                         0.00
                                   -----
Checks [Over]/Short                 0.00
 
Declared Gift Card Total           17.00
Gift Card Total                   -16.64
                                   -----
Gift Card [Over]/Short              0.36
========================================
R E F U N D S
 Name              Time   Amount
----------------------------------------
 Cash             18:45   -28.21
========================================
P A I D O U T S
----------------------------------------
========================================
P A I D I N S
----------------------------------------
========================================
G I F T  C A R D S
 Accounts Activated              Amount
----------------------------------------
 6010XXXXXXXX3774                10.00
 6010XXXXXXXX3428                 5.00
 6010XXXXXXXX4269                 5.00
----------------------------------------
 3 cards activated               20.00
 
========================================
D R O P S
 

 

 

 

Figure 8.11.1 Heading Fields

Field

Description

Date/Time

The Date and Time the report was generated.

Cash Tray Info

Cash Drawer

The Station Name and Drawer Number associated with the Cash Tray.

STATUS

CLOSED

The Cash Tray is Closed.

OPEN

The Cash Tray is Open.

TIME OPENED

The date and time the Cash Tray was Opened.

TIME CLOSED

The date and time the Cash Tray was Closed.

ASSIGNED

The Employees Assigned to the Cash Tray.

 

The Inventory Counts Section compares the quantity of an Inventory Item used with the quantity sold to determine the variance (Over/Short). Note: Only Items on checks closed to the Cash Tray are included in the Inventory Counts Section.

 

Figure 8.12 Inventory Counts Section Fields

Field

Description

Item

The Inventory Item Name.

Beg Qty

The number of Units in stock before the shift.

Add Qty

The number of Units added to stock during the shift.

End Qty

The number of Units in stock at the end of the shift.

Qty Used

The number of Units used during the shift (End Qty minus Beg Qty plus Add Qty).

Qty Sold

The number of Units ordered during the shift.

Over/Short

Qty Used minus Qty Sold.

 

Figure 8.14 Payment Summary Section Fields

Field

Description

Gross Cash

Units

The number of cash payments received.

Amount

The Total amount of cash collected from all payments minus cash tips minus change back.

Paid Outs

Units

The number of Paid Outs.

Amount

The Paid Outs Total.

Drops

The total dollar amount of all Drops.

CC Tip Fee

The Total Tip Fee collected for all Payments.

Tips Paid Out

The Tip Amount for all Non Cash Payments. Note: This field is only displayed if the Miscellaneous > General > Timekeeping >Retain Tips > Pay Out Tips option is selected.

Net Cash

Gross cash plus Paid Outs plus Advances plus Drops plus CC Tip Fee plus Tips Paid Out plus Retained Tip Pool.

Non Cash Payments

Name

The Payment Name.

Units

The number of times the Payment was applied.

Amount

The Total amount of the Payment.

TOTAL PAYMENTS

Net Cash plus Non Cash Payments.

 

Figure 8.15 Gratuities Sections Fields

Field

Description

Tips Owed to

Name

The Employee that is owed tips.

Amount

The Amount the tips owed. Note: The Amount is Net of the CC Tip Fee.

Total Tips Owed by Me

The Total Amount of tips owed.

 

Figure 8.16 Payment Detail Section Fields

Field

Description

Payment Name

The Name of the Payment for all Non Cash Payments. Note: Cash Payments (i.e., $5, $10, $20, etc.) are grouped together and displayed as the Payment Name ‘Cash’. Cash Payments are only displayed on the report if the Drawer Report Option ‘Include Cash Payment’ is enabled.

Chk #

The Check and Seat number associated with the Payment. Note: A Paid In will display “Paid In” and a Refund will display “Refund” in this field. A “V” in this field denotes the Payment has been Voided.

Amount

The amount of the Payment.

Tip

The tip amount for the Payment.

Total

The Amount plus Tip.

CC Total

Amount

The Total credit card Payment Amount.

Tip

The Total credit card Top Amount.

Total

The Total credit card Amount plus Total CC Tip Amount.

 

The Cash Detail Section is displayed if a Starting Bank or Declared Cash has been entered.

 

Figure 8.16.1 Cash Detail Section Fields

Field

Description

Declared Cash

The actual amount of money counted at the close of the Cash Tray.

Net Cash

Gross cash plus Paid Outs plus Advances plus Drops plus CC Tip Fee plus Tips Paid Out plus Retained Tip Pool.

Starting Bank

The Cash Tray’s Starting Bank.

Over/Short

Declared Cash minus Net Cash minus Starting Bank. Note: If the drawer is short, the word “Short” is enclosed in [ ]’s (i.e., Over/[Short]      -1.76)

Declared Check Total

The actual amount of checks counted at the close of the Cash Tray.

Check Total

The amount of checks received.

Checks Over/Short

Declared Check Total minus Check Total.

Declared Gift Card Total

The actual amount of Gift Cards counted at the close of the Cash Tray.

Gift Card Total

The amount of Gift Cards received.

Gift Card Over/Short

Declared Gift Card Total minus Gift Card Total.

 

Figure 8.14 Refunds Section Fields

Field

Description

Name

The Payment Type associated with the Refund.

Time

The Time the Refund occurred.

Amount

The Amount of the Refund.

 

Figure 8.14 Missing Tips Section Fields

Field

Description

Missing Tip

Employee

The Nickname of the Employee associated with the Payment that is missing a tip.

Check #

The Check # that contains the Payment with the missing tip.

Amount

The Amount of the Payment of the check with the missing tip.

 

Figure 8.14 Paid Outs Section Fields

Field

Description

Paid Out

Name

The Name of the Paid Out.

Invoice

The Invoice Number associated with the Paid Out.

Amount

The Amount of the Paid Out.

 

Figure 8.14 Paid Ins Section Fields

Field

Description

Paid Ins

Name

The Name of the Paid In. Note: A “V” in front of the Paid In Name indicates the Paid In was Voided.

Amount

The Amount of the Paid In.

 

Figure 8.14 Gift Cards Section Fields

Field

Description

Accounts Activated

Amount

The Amount of the Activation.

Total

Activated

The number of Gift Cards Activated.

Amount

The Total Amount of Activation.

Accounts Incremented

Amount

The Amount of the Increment.

Total

Activated

The number of Gift Cards Incremented.

Amount

The Total Amount of Increment.

 

Figure 8.14 Drops Section Fields

Field

Description

Dropped To

Name

The Drop recipient.

Amount

The Amount of the Drop received.

Total

The Total Dropped To Amount.

Dropped By

 

Name

The employee that initiated the Drop.

Amount

The Amount of the Drop relinquished.

Total

The Total Dropped By Amount.

 

Note: Only Drawer Opens longer than the number of seconds defined in Drawer Report Setup > Drawer Opens > Threshold (Seconds) will appear on the report.

Figure 8.26 Drawer Opens Section

Field

Description

Open Time

The time the drawer was opened.

Name

The Name of the cash drawer that was opened.

Activity

Gift/Cd

The drawer was open as a result of a Gift Card Purchase.

Paid In

The drawer was open as a result of a Paid In.

Refund

The drawer was open as a result of a Refund.

Paid Out

The drawer was open as a result of a Paid Out.

Drop

The drawer was open as a result of a Drop.

No Sale

The drawer was open as a result of a No Sale (Open (Drawer) Command).

Ck #

The Check # associated with the Payment received.

Time(Secs)

The number of seconds the drawer was open.

 

Related Topics (none)

 

 
Copyright © 2010 Focus POS Systems