File Format   

Purpose

The File Format Option on the Daily Report is used to select the fields to export. The File Format option must be set to “Comma Delimited” in the Report Window and the Output Type must be set to “File”.

 

Figure 8.53 Daily Report File Format Setup Window

 

Figure 8.53.2 Daily Report File Format Window Fields

Field

Description

Fields

Begin Date

The beginning date for the export.

End Date

The ending date for the export.

# of Checks

The Total number of Checks.

# of Checks Shift 1

The number of Checks for Shift 1.

# of Checks Shift 2

The number of Checks for Shift 2.

# of Checks Shift 3

The number of Checks for Shift 3.

# of Checks Shift 4

The number of Checks for Shift 4.

# of Guests

The Total number of Guests.

# of Guests Shift 1

The number of Guests for Shift 1.

# of Guests Shift 2

The number of Guests for Shift 2.

# of Guests Shift 3

The number of Guests for Shift 3.

# of Guests Shift 4

The number of Guests for Shift 4.

Avg Check

The Average Check amount.

Avg Check Shift 1

The Average Check amount for Shift 1.

Avg Check Shift 2

The Average Check amount for Shift 2.

Avg Check Shift 3

The Average Check amount for Shift 3.

Avg Check Shift 4

The Average Check amount for Shift 4.

Avg Guest

The Average Guest amount (PPA).

Avg Guest Shift 1

The Average Guest amount (PPA) for Shift 1.

Avg Guest Shift 2

The Average Guest amount (PPA) for Shift 2.

Avg Guest Shift 3

The Average Guest amount (PPA) for Shift 3.

Avg Guest Shift 4

The Average Guest amount (PPA) for Shift 4.

Void Units

The Total number of Voids.

Void Units Shift 1

The number of Voids for Shift 1.

Void Units Shift 2

The number of Voids for Shift 2.

Void Units Shift 3

The number of Voids for Shift 3.

Void Units Shift 4

The number of Voids for Shift 4.

Void Amount

The Total Void dollar amount.

Void Amount Shift 1

The Void dollar amount for Shift 1.

Void Amount Shift 2

The Void dollar amount for Shift 2.

Void Amount Shift 3

The Void dollar amount for Shift 3.

Void Amount Shift 4

The Void dollar amount for Shift 4.

RG Units Total

The Total number of units sold for all Report Groups.

RG Units Total Shift 1

The Total number of units sold for all Report Groups during Shift 1.

RG Units Total Shift 2

The Total number of units sold for all Report Groups during Shift 2.

RG Units Total Shift 3

The Total number of units sold for all Report Groups during Shift 3.

RG Units Total Shift 4

The Total number of units sold for all Report Groups during Shift 4.

RG Sales Total

The Total sales amount for all Report Groups.

RG Sales Total Shift 1

The Total sales amount for all Report Groups during Shift 1.

RG Sales Total Shift 2

The Total sales amount for all Report Groups during Shift 2.

RG Sales Total Shift 3

The Total sales amount for all Report Groups during Shift 3.

RG Sales Total Shift 4

The Total sales amount for all Report Groups during Shift 4.

RG Units Discount Total

The Total number of times a Discount was applied to all Report Groups.

RG Sales Discount Total

The Total dollar amount of Discounts for all Report Groups.

Subtotal

The Subtotal dollar amount.

Inclusive Tax

The Inclusive Tax amount.

Subtotal Discount

The Subtotal Discount amount.

Net Sales

The Net Sales amount.

Total Tax

The Total Tax amount.

Total Sales

The Total Sales amount.

Paidout Total

The Total Paid Outs amount.

Paidin Total

The Total Paid Ins amount.

Retained Tips

The Total Retained Tips amount.

Gift Cards

The Total Gift Cards amount.

Refunds

The Total Refunds amount.

Tip Fee

The Total Tip Fee amount.

Total Accountable

The Total Accountable amount.

Gross Cash

The Total Gross Cash amount.

Net Cash

The Total Net Cash amount.

Deposit

The Total Deposit Amount.

Payment Total

The Total Payment Total amount.

RG 1 -100 Units

The Total individual Report Group Units.

RG 1 – 100 Sales

The Total individual Report Group Sales.

RG 1 – 100 Units – Shift 1

The Total individual Report Group Units for Shift 1.

RG 1 – 100 Sales – Shift 1

The Total individual Report Group Sales for Shift 1.

RG 1 – 100 Units – Shift 2

The Total individual Report Group Units for Shift 2.

RG 1 – 100 Sales – Shift 2

The Total individual Report Group Sales for Shift 2.

RG 1 – 100 Units – Shift 3

The Total individual Report Group Units for Shift 3.

RG 1 – 100 Sales – Shift 3

The Total individual Report Group Sales for Shift 3.

RG 1 – 100 Units – Shift 4

The Total individual Report Group Units for Shift 4.

RG 1 – 100 Sales – Shift 5

The Total individual Report Group Sales for Shift 4.

RG 1 – 100 Disc Units

The Total individual Report Group Discount Units.

RG 1 – 100 Disc Sales

The Total individual Report Group Discount Sales amount.

OT Charge 1 – 20

The Total individual Order Type Charge amount.

Tax 1 – 16

The Total individual Tax amount.

Taxable Sales 1 – 16

The Total individual Taxable Sales amount.

Tax Exempt Sales 1 - 16

The Total individual Tax Exempt Sales amount.

Paidout 1 – 100

The Total individual Paid Out amounts.

Paidin 1 – 50

The Total individual Paid Ins amounts.

Payment Units 1 – 25

The Total individual Payment Units.

Payment $ 1- 25

The Total individual Payment amounts.

OT Units 1 -20

The Total individual Order Type Units.

OT Sales 1 – 20

The Total individual Order Type Sales amount.

Disc Units 1 - 100

The Total individual Discount Units.

Disc Amount 1 - 100

The Total individual Discount amounts.

 

 

Related Topics (none)

 

 
Copyright © 2010 Focus POS Systems