Gift Card Report

Purpose

The Sample Gift Card Report, shown below, is designed to display the Store ID, Net Sales, Gift Card Sales, Gift Card % of Sales, Gift Card Payments and Gift Card Sales minus Gift Card Payments.

Figure 3.4.23 Sample Gift Card Report

Focus Corp

Gift Card Report for 10/1/200x-10/31/200x at 11/28/200x 12:57:58 PM Page 1

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

001 | 41852.39 | 761.00 | 1.82 | 996.39 | -235.39 |

002 | 39572.76 | 130.00 | 0.33 | 601.78 | -471.78 |

003 | 28668.72 | 70.00 | 0.24 | 246.84 | -176.84 |

004 | 71852.37 | 271.00 | 0.38 | 286.06 | -15.06 |

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

Totals | 45486.56 | 308.00 | 0.69 | 532.77 | -224.77 |

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

Figure 3.4.24 Sample Gift Card Report Fields

Field

Description

Store ID

Column 1

Displays the Restaurant ID established in Setup > Restaurants > ID.

Net Sales

Column 2

Displays the Net Sales amount for the restaurant for the selected date range.

Gift Card Sales

Column 3

Displays the Gift Card Sales amount for the restaurant for the selected date range.

Gift Card % of Sales

Column 4

Displays the Gift Card % of Sales amount for the restaurant for the selected date range.

Gift Card Payments

Column 5

Displays the Gift Card amount redeemed for the restaurant for the selected date range.

Gift Card (Sales – Payments)

Column 6

Displays the Gift Card Sales minus Gift Card Payments amount for the restaurant for the selected date range.

Totals

Net Sales	Column 2 Displays the corporate average Net Sales amount.
Gift Card Sales	Column 3 Displays the corporate average Gift Card Sales amount.
Gift Card % of Sales	Column 4 Displays the corporate average Gift Card % of Sales amount.
Gift Card Payments	Column 5 Displays the corporate average Gift Card Payments amount.
Gift Card (Sales – Payments)	Column 6 Displays the corporate average Gift Card Sales minus Gift Card Payments amount.

Report Setup - Column 1 (Store ID)

Field	Setup Information
Heading 1	Store ID
Heading 2
Size	10
Sort	Ascending
Format	Text
Display	Yes
Filtered	No
Expression	“REST-ID”
Constant	n/a

Report Setup - Column 2 (Net Sales)

Field	Setup Information
Heading 1	Net
Heading 2	Sales
Size	10
Sort	<None>
Format	Currency (Avg. Total)
Display	Yes
Filtered	No
Expression	“Net Sales”
Constant	n/a

Report Setup - Column 3 (Gift Card Sales)

Field	Setup Information
Heading 1	Gift Card
Heading 2	Sales
Size	10
Sort	<None>
Format	Currency (Avg. Total)
Display	Yes
Filtered	No
Expression	"Gift Cards "
Constant	n/a

Report Setup - Column 4 (Gift Card % of Sales)

Field	Setup Information
Heading 1	Gift Card
Heading 2	% of Sales
Size	10
Sort	<None>
Format	% (Average Breaks)
Display	Yes
Filtered	No
Expression	“Column3” / “Column2”
Constant	n/a

Report Setup - Column 5 (Gift Card Payments)

Field	Setup Information
Heading 1	Gift Card
Heading 2	Payments
Size	10
Sort	<None>
Format	Currency (Avg. Total)
Display	Yes
Filtered	No
Expression	"PAYMENT$7:Gift Card"
Constant	n/a

Report Setup - Column 6 (Gift Card (Sales – Payments))

Field	Setup Information
Heading 1	Gift Card
Heading 2	(Sales – Payments)
Size	10
Sort	<None>
Format	Currency (Avg. Total)
Display	Yes
Filtered	No
Expression	"Column3” – “Column5”
Constant	n/a

Report Format Options

Field	Option
File Format	Text
Totals by Date	Not Selected
Type	None

Related Topics (none)