Sample Daily Report   

Purpose

A sample Daily Report and description of the fields are shown 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.54 Sample Daily Sales Report 

focus-jpg.jpg

 

Daily Report for 3/18/200X

 

Focus Cafe

created at 3/18/200X 12:02:10 PM

Page 1 of   1

Lunch

Happy Hour

Dinner

Late Night

 %

08:00 - 15:00

15:00 - 18:00

18:00 - 21:00

21:00 - 08:00

Disc

 Disc

NRGT $81,845.45

Units

Sales

  Sales 

Units

Sales

Units

Sales

Units

Sales

Units

Sales

Units

Sales

Average Check

254

30.29

73

22.64

52

27.57

125

36.23

4

19.29

Average Guest

649

11.85

177

9.34

135

10.62

331

13.68

6

12.86

Voids

6

21.80

0

0.00

0

0.00

6

21.80

0

0.00

Liquor

203

1,260.00

16.38

36

216.25

25

147.25

140

886.50

2

10.00

1

-3.75

Beer

85

274.75

3.57

2

7.00

24

78.75

59

189.00

0

0.00

0

0.00

Food

1112

6,157.78

80.05

299

1,429.69

217

1,207.41

579

3,453.53

17

67.15

17

-38.40

Totals

1400

7,692.53

100.00

337

1,652.94

266

1,433.41

778

4,529.03

19

77.15

18

-42.15

To Go

30.03

Subtotal

7,722.56

Inclusive Tax

0.00

Subtotal Discounts

0.00

Net Sales

7,722.56

Sales Tax

510.09

on

6,182.08 exempt     0.00

City Tax

0.00

on

     36.00 exempt     0.00

Total Tax

510.09

Total Sales

8,232.65

Paid Outs

-4.31

Paid Ins

2.76

Gift Cards

20.00

CC Tip Fee

0.00

Refunds

-25.65

Total Accountable

8,225.45

Gross Cash

66

1,299.87

Paid Outs

1

-4.31

-

______________________

Advances

-20.00

-

______________________

CC Tip Fee

0.00

+

______________________

Tips Paid Out

-844.80

-

______________________

Net Cash

430.76

=

______________________

Cash Deposit: $428.57 (Rained all day)

Checks

0

0.00

+

______________________

Cash & Checks

430.76

=

______________________

Cash & Checks Deposit: $428.57

House Account

47

1,348.25

+

______________________

Master Card

44

1,626.19

+

______________________

Visa

104

3,509.02

+

______________________

Amex

29

1,123.79

+

______________________

Discover

4

187.44

+

______________________

Gift Certificat

0

0.00

+

______________________

Diners Club

0

0.00

+

______________________

Gift Card

0

0.00

+

______________________

Total Payments

8,225.45

=

______________________

-8205.45 = Over/Short ($2.19) CC Total $6,446.44

Order Types

Dine In

227

7,133.78

To Go

27

600.90

Discounts ($42.15)

50% Disc

3

30.30

15 % Disc

2

8.10

Break Spill

1

3.75

Paid Outs

Misc. Cash P.O.

1

4.31

Paid Ins

Change Due

1

2.76

Deposits

Rained all day

408.57

 

Figure 8.55 Sample Daily Report Fields

Field

Description

Open Check Amount

The amount of the open checks that were left open from the previous day.

NRGT

Non-Resettable Grand Total. The NRGT equals the NRGT for the previous day plus the Subtotal on the Daily Report minus Item Discounts. The NRGT is not displayed if the report is run for multiple days (date range).

Average Check

Units

The total number of checks.

Sales

The average check amount.

Shift 1-4

Units

The number of checks for the time period.

Sales

The average check amount for the time period.

Average Guest

Units

The total number of guests.

Sales

The average guest amount (PPA).

Shift 1-4

Units

The number of guests for the time period.

Sales

The average guest amount (PPA) for the time period.

Voids

Units

The total number of Voids.

Sales

The Void amount.

Shift 1-4

Units

The number of Voids for the time period.

Sales

The Void amount for the time period.

Report Groups

Report Group Units are only incremented for non-zero priced items.

Units

The number of Report Group Units sold including discounted items.

Sales

The Report Group Sales amount (net of Item Discounts).

Shift 1-4

Units

The number of Report Group Units sold for the time period.

Sales

The Report Group Sales amount for the time period.

Disc. Units

The number of Report Group Units that were discounted.

Disc. Sales

The Report Group’s Discount Sales amount.

Totals

Units

The sum of all Report Group Units sold.

Sales

The sum of all Report Group Sales amount.

Shift 1-4

Units

The sum of Report Group Units sold for the time period.

Sales

The sum of the Report Group Sales amount for the time period.

Disc. Units

The total number of units discounted for all Report Groups.

Disc. Sales

The sum of all Report Group Discount Sales amount.

Order Type Charges

The dollar amount of the individual Order Type Charges.

Subtotal

Report Group Sales plus Order Type Charges.

Inclusive Tax

The sum of all Inclusive Taxes.

Subtotal Discounts

The sum of all Subtotal Discounts.

Net Sales

Report Group Sales plus Order Type Charges minus Inclusive Tax minus Subtotal Discounts.

Taxes

Tax collected, Taxable Sales and Tax-Exempt Sales are displayed for each Tax.

Sales

The tax collected.

On

The dollar amount that the tax is calculated on.

Exempt

The dollar amount Exempt from the tax.

Total Tax

The sum of all tax collected.

Total Sales

Net Sales plus Total Tax.

Paid Outs

The sum of all Paid Outs.

Paid Ins

The sum of all Paid Ins.

Gift Cards

The sum of all Gift Card purchases.

CC Tip Fee

The sum of all Credit Card Tip Fees.

Refunds

The sum of all Refunds.

Retained Tips

The Tip Amount for all Non Cash Payments. Note: This field is only displayed if the “Retain Tips” Option is enabled in Miscellaneous > General > Timekeeping >Retain Tips.  

Total Accountable

Total Sales minus Paid Outs plus Paid Ins plus Retained Tips plus CC Tip Fee plus Gift Cards.

Gross Cash

The cash collected from all Payments minus cash tips minus change back.

Units

The number of cash payments.

Sales

The amount of cash payments.

Paid Outs

Units

The number of Paid Outs.

Sales

The dollar amount of Paid Outs.

Advances

The sum of all Advances.

CC Tip Fee

The sum of the CC Tip Fees.

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 minus Paid Outs plus the CC Tip Fee minus Tips Paid Out minus Advances plus Retained Tips.

Cash Deposit

The sum of Cash Deposits for the selected date range. Note: This field is filled in only when a Cash Deposit is entered into Focus. If multiple Deposits are entered, then “(See Below)” will be displayed and the amount and description of each Deposit will be listed at the bottom of the report.

Checks

Units

The number of Check Payments.

Sales

The dollar amount of the Check Payments.

Cash & Checks

Sales

Net Cash plus Checks.

Cash & Checks

The actual amount of Cash & Checks can be manually written in here. Note: This field is filled in only when a Cash and Check Deposit is entered into Focus.

Payments (Non Cash)

Individual Payments will be listed in this section.

Units

The number of times the Payment was applied.

Sales

The dollar amount of the individual Payment. 

Total Payments

Cash & Checks plus Payments (Non Cash).

Over/Short

A blank line “____________” is provided for the user to manually enter the Over/Short amount.

Deposit Over/Short

Net Cash minus Cash & Check Deposit. Note: This field is only filled in if a Deposit is entered into Focus.

CC Total

The sum of all Credit Card Payments and Tips.

Order Type Sales

Individual Order Types will be listed in this section.

Name

The Name of the Order Type.

Units

The number of Checks for the Order Type.

Sales

The amount of sales for the Order Type.

Discounts

Individual Discount Totals will be listed in this section.

Name

The Name of the Discount.

Units

The number of times the Discount was used.

Sales

The total dollar amount of the Discount.

Paid Outs

Individual Paid Outs will be listed in this section.

Name

The Name of the Paid Out.

Units

The number of times the Paid Out was used.

Sales

The total dollar amount of the Paid Out.

Paid Ins

Individual Paid Ins will be listed in this section.

Name

The Name of the Paid In.

Units

The number of times the Paid In was used.

Sales

The total dollar amount of the Paid In.

Deposits

The description and amount is displayed for each Deposit if multiple Deposits have been entered for the day.

Description

The Deposit’s Description.

Sales

The amount of the Deposit.

 

Figure 8.55.1 Sample Daily Report Setup Options

Fields Used

Description

Shifts

1

Name

Lunch

Start Time

08:00

End Time

15:00

2

Name

Happy Hour

Start Time

15:00

End Time

18:00

3

Name

Dinner

Start Time

18:00

End Time

21:00

4

Name

Late Night

Start Time

21:00

End Time

08:00

Display Non-Resettable Grand Total

Selected

File Format

Text

 

Related Topics (none)

 

 

 

 

 
Copyright © 2010 Focus POS Systems