Receipt Transcription Outsourcing

Receipt Transcription to Spreadsheet, CSV file or Specific Database

 Processing Receipt

• Collectively, these different HITs (Receipts) fall into just 5 HIT Types

1) RSD
2) RIN
3) RIN / RSD
4) UPC
5) UPC / RSD

Entry person should enter these 5 receipts into 5 different template.

 RSD

Sample Receipt Sample Output (Spreadsheet)

transcriptio transaction_d Transaction Sr. Type (Item, Coupon, receipt_im
n_type receipt_id banner_id total ate time No Void) Qty Item Description Price Per Item Remarks ages Image_2
edf88eb6ae7
441a49fc196
1:26 PM 96d56f622b.
RSD 25443590 7_eleven 1.07 9/24/2014 1 Item 1 BGCUPFOAMSELL 0.99 0.99 jpg
4385592389
aa46409993
7f5df880343
RSD 25443792 7_eleven 6.24 9/24/2014 1 Item 1 AIRHEADS BTSFT2Z 1.29 1.29 4.jpeg

2 Item 1 REESA PB CPKS 2.8Z 1.89 1.89

3 Item 1 SBGCARCPPLSSELL 1.49 1.49

4 Item 1 SIRP MED SELL22Z 1.39 1.39

ef73339f377 ee835f3d0e
f405e9180b 15470e9a02
ac41ba7ec4 d98669fc27e
RSD 25444379 7_eleven 10.12 9/24/2014 1 Item 1 MONSTER ENGYXXL24ZCN 3.49 3.49 6.jpg 2.jpg

2 Item 1 CRV 0.10 0.10

3 Item 1 MONSTER ENGYXXL24ZCN 3.49 3.49

4 Item 1 CRV 0.10 0.10

 RIN Should have to enter all leading
zeros in RIN number if given

Sample Receipt Sample Output (Spreadsheet)

transcripti transaction_da Transaction_ti Type (Item, Image_
on_type total te me Sr. No Coupon, Void) Qty Item Number Price Per Item Remarks receipt_images_1 2
27352b40263f43fd96d77aad8
RIN 67.95 9/28/2014 10:11 1 Item 1 807473 9.99 9.99 3066034.jpeg

2 Item 1 807473 9.99 9.99

3 Item 1 807473 9.99 9.99

4 Item 1 24000 18.99 18.99

5 Item 1 24000 18.99 18.99

4c61a0539e29434d9bdb73507
RIN 32.77 9/27/2014 1 Item 1 954799 9.95 9.95 a51b446.jpeg

2 Item 1 90097 3.29 3.29

 RIN / RSD Should have to enter all leading
zeros in RIN number if given

Sample Receipt Sample Output (Spreadsheet)

transcriptio transaction_dat Transaction Type (Item, Coupon, Per receipt_ima
n_type total e time Sr. No Void) Qty Item Number Item Description Price Item Remarks ges Image_2
4110bccd28 f1d7b880e9
d84797b6d1 96425ca275
1f080cc7079 4879888ca8
RIN / RSD 52.98 12/31/2013 13:05 1 Item 1 9220675 NT-MS318 MEDIA TOWER 19.99 19.99 4.png 62.png

NT-NB13071 SLEEVE 15.6"-

2 Item 1 5357414 BLUE YVES KLEJ 2.99 2.99

AF2-IN-MF-R INCLINE CASE

3 Item 1 6639726 FOR KINDLE FIRE 14.99 14.99

RF-AC1U2NK UNIVERSAL
4 Item 1 7129096 TABLET /EREADER WALL 2.99 2.99

RF-MCB55K KINDLE CAR

5 Item 1 9735929 CHARGER 7.99 7.99
f6cdc2d5827
94a0781f78
JBL CHARGE SHADOW 2b36a59a7f
RIN / RSD 160.38 12/24/2013 1 Item 1 1805904 BLACK/GREY 129.99 129.99 5.png
 UPC
Should have to enter all leading zeros in UPC number if given

Sample Receipt Sample Output (Spreadsheet)

transcriptio Type (Item, receipt_ima
n_type receipt_id banner_id total transaction_date Transaction time Sr. No Coupon, Void) Qty UPC Code Price Per Item Remarks ges
1c2590c1da
8346eea0aa
0778027131 87013619dd
UPC 26112852 walgreens 8.06 9/30/2014 2:58 PM 1 Item 10 2.50 2.50 20.jpeg
0778027130
2 Item 13 2.50 2.50
0107000215
3 Item 12 1.59 1.59
0490226053
4 Item 16 0.89 0.89
45c2e1026e
5f440db959
0490227392 eabc0375f3
UPC 26113175 walgreens 5.82 9/28/2014 1 Item 18 5.49 5.49 d7.jpeg
26554fcf381
24eda975b5
0360003463 0fde5d2e26
UPC 26114231 walgreens 5.29 30-09-2014 1 Item 13 4.99 4.99 8.jpeg
a84e13ec47
474411ac96
3119171632 b0a3eadb9c
UPC 26114511 walgreens 11.49 9/30/2014 1 Item 11 11.49 11.49 50.jpeg
 UPC / RSD
Should have to enter all leading zeros in UPC number if given
Sample Receipt Sample Output (Spreadsheet)
transcription Type (Item, Coupon, receipt_imag
_type total transaction_date Transaction time Sr. No Void) Qty UPC Code Item Description Price Per Item Remarks es Image_2
410592789e d5941a8e16
b34db99c8e 1e4844ab68
0e0fbbca8e6 aece8a7e7ce
UPC / RSD 16.85 9/25/2014 13:06:16 1 Item 1 078000052466 ROOT BEER 1.25 1.25 6.jpeg 0.jpeg

2 Item 1 078000052466 ROOT BEER 1.25 1.25

3 Item 1 078000052466 ROOT BEER 1.25 1.25

4 Item 1 023400010486 RENUZIT RELAX SPA AF 1.00 1.00

5 Item 2 400024448916 FASHION TANK GEL 1.00 0.50

6 Item 1 430000289615 BELLE SCRUNCHIE W-1 1.50 1.50

7 Item 1 430000341047 STUDENT PLANNER 1.50 1.50

8 Item 1 183689001022 DGHOME ULT TOWEL 2.75 2.75

SCOTT 9 PK XSOFT
9 Item 1 054000385582 BATH 5.00 5.00
383130e412
be4272ac1d
109fcfed22d
UPC / RSD 14.16 9/29/2014 1 Item 1 027541009293 WATER 24 PK 3.50 3.50 b.jpeg
Receipts Entry Process Tips (Full Extraction Hit)

• The first step in processing any Full Extraction HIT is to determine whether the receipt is valid. (Check the receipt is readable
or its contains full information etc.)
• If the Receipt is a perfect one then entry person can enter this into the spreadsheet or software.
• If the Receipt contains any problem LIKE MENTION BELOW then skip the receipt and give corresponding comments CODE in
the remark column from below list. (Don’t include any other comments from your side). Only input the “CODES”
• DOCTORED (fake, or intentionally edited)
• BLURRY (too blurry to read)
• NOT_ENGLISH (the receipt is in a foreign language)
• NOT_FULL_RECEIPT (missing some line-items, or one or more of the required fields)
• NOT_RECEIPT (it’s not a receipt at all)
• GAS_ONLY (the receipt is only for gasoline/petrol)
• WRONG_BANNER (if the banner id in the csv and image are different)
• MULTI_RECEIPT (more than one banner id in a single receipt id, more than one valid banners in a single image)
RSD HIT Entry Process

 All Full RSD Extraction HITs require transcribing the following values:

1. Per Line Item:

a) Type of line-item (“Item”, “Coupon”, or “Void”) : - Most of the data given in the receipt will be “Item”. If any amount found in Minus figure (-
6.95 or 6.95-) Then enter TYPE as “Coupon” and enter the amount as negative number (eg -6.00). If the any product mentioned as Void then
TYPE will be “Void” (If the Void item is in Minus Figure then Type will be “Void” and enter amount in Minus Figure)
b) Quantity : - Check the quantity given in the receipt for the product. Most of the time it will be “1”.
c) Item Description: - Product name of the line item. (eg: Cheese, PRM Gtrd Med 2/X.xx etc…)
d) Price: - Given price of the product.
e) Per Item:- This will be calculate by the formula (Price /Quantity)
f) Transaction Time: Given in the receipt (most of the case near date)

Serial Number: Serial number should be enter continuously. If one receipt has continuous item then given number as 1,2,3,4,5…..etc
Note: If any item look like not a product (eg: business card, Value Card) you need to include this in the spreadsheet.

Also the entry person need to Confirming / correcting the following prefilled values
1. Transaction Date: - Need to compare the date and correct if any mistake. Date should be in American date format (MM/DD/YYYY)
2. Total :- Need to compare the total and correct if any mistake
RIN HIT Entry Process

 All Full RIN Extraction HITs require transcribing the following values:

1. Per Line Item:

a) Type of line-item (“Item”, “Coupon”, or “Void”) : - Most of the data given in the receipt will be “Item”. If any amount found in Minus figure (-6.95 or
6.95-) Then enter TYPE as “Coupon” and enter the amount as negative number (eg -6.00). If the any product mentioned as Void then TYPE will be “Void” (If
the Void item is in Minus Figure then Type will be “Void” and enter amount in Minus Figure)
b) Quantity : - Check the quantity given in the receipt for the product. Most of the time it will be “1”.
c) Item Number: - Product given in the invoice have a numerical code given. Need to enter this. (eg: 1859333, 229644 etc…)
d) Price: - Given price of the product.
e) Per Item:- This will be calculate by the formula (Price /Quantity)
f) Transaction Time: Given in the receipt (most of the case near date)

Serial Number: Serial number should be enter continuously. If one receipt has continuous item then given number as 1,2,3,4,5…..etc

Also the entry person need to Confirming / correcting the following prefilled values
1. Transaction Date:- Need to compare the date and correct if any mistake. Date should be in American date format (MM/DD/YYYY)
2. Total:- Need to compare the total and correct if any mistake
RIN / RSD HIT Entry Process
 All Full RIN /RSD Extraction HITs require transcribing the following values:

1. Per Line Item:

a) Type of line-item (“Item”, “Coupon”, or “Void”) : - Most of the data given in the receipt will be “Item”. If any amount found in Minus figure (-6.95 or
6.95-) Then enter TYPE as “Coupon” and enter the amount as negative number (eg -6.00). If the any product mentioned as Void then TYPE will be “Void” (If
the Void item is in Minus Figure then Type will be “Void” and enter amount in Minus Figure)
b) Quantity : - Check the quantity given in the receipt for the product. Most of the time it will be “1”.
c) Item Number: - Product given in the invoice have a numerical code given. Need to enter this. (eg: 1859333, 229644 etc…). Need to include all leading
zeros if given
d) Item Description: - Product name of the line item. (eg: Cheese, PRM Gtrd Med 2/X.xx etc…)
e) Price: - Given price of the product.
f) Per Item:- This will be calculate by the formula (Price /Quantity)
g) Transaction Time: Given in the receipt (most of the case near date)

Serial Number: Serial number should be enter continuously. If one receipt has continuous item then given number as 1,2,3,4,5…..etc
Note: If any item look like not a product (eg: business card, Value Card) you need to include this in the spreadsheet.

Also the entry person need to Confirming / correcting the following prefilled values
1. Transaction Date:- Need to compare the date and correct if any mistake. Date should be in American date format (MM/DD/YYYY)
2. Total:- Need to compare the total and correct if any mistake
UPC HIT Entry Process

 All Full UPC Extraction HITs require transcribing the following values:

1. Per Line Item:

a) Type of line-item (“Item”, “Coupon”, or “Void”) : - Most of the data given in the receipt will be “Item”. If any amount found in Minus figure (-
6.95 or 6.95-) Then enter TYPE as “Coupon” and enter the amount as negative number (eg -6.00). If the any product mentioned as Void then
TYPE will be “Void” (If the Void item is in Minus Figure then Type will be “Void” and enter amount in Minus Figure)
b) Quantity : - Check the quantity given in the receipt for the product. Most of the time it will be “1”.
c) UPC: - “Universal Product Code” a 10-12 digit numeric code that identifies the same product across all retailers in the US. Need to include all
leading zeros if given
d) Price: - Given price of the product.
e) Per Item:- This will be calculate by the formula (Price /Quantity)
f) Transaction Time: Given in the receipt (most of the case near date)

Serial Number: Serial number should be enter continuously. If one receipt has continuous item then given number as 1,2,3,4,5…..etc
Note: Do not include any Alphabet and Addition number showing along with UPC code (eg 0000000000000KF and 0000000000000 – 123)

Also the entry person need to Confirming / correcting the following prefilled values
1. Transaction Date: - Need to compare the date and correct if any mistake. Date should be in American date format (MM/DD/YYYY)
2. Total :- Need to compare the total and correct if any mistake
UPC / RSD HIT Entry Process
 All Full UPC / RSD Extraction HITs require transcribing the following values:

1. Per Line Item:

a) Type of line-item (“Item”, “Coupon”, or “Void”) : - Most of the data given in the receipt will be “Item”. If any amount found in Minus figure (-
6.95 or 6.95-) Then enter TYPE as “Coupon” and enter the amount as negative number (eg -6.00). If the any product mentioned as Void then
this will be “Void” (If the Void item is in Minus Figure then Type will be “Void” and enter amount in Minus Figure)
b) Quantity : - Check the quantity given in the receipt for the product. Most of the time it will be “1”.
c) UPC: - “Universal Product Code” a 10-12 digit numeric code that identifies the same product across all retailers in the US. Need to include all
leading zeros if given
d) Item Description: - Product name of the line item. (eg: Cheese, PRM Gtrd Med 2/X.xx etc…)
e) Price: - Given price of the product.
f) Per Item:- This will be calculate by the formula (Price /Quantity)
g) Transaction Time: Given in the receipt (most of the case near date)

Serial Number: Serial number should be enter continuously. If one receipt has continuous item then given number as 1,2,3,4,5…..etc
Note: Do not include any Alphabet and Addition number showing along with UPC code (eg 0000000000000KF and 0000000000000 – 123)

Also the entry person need to Confirming / correcting the following prefilled values
1. Transaction Date: - Need to compare the date and correct if any mistake. Date should be in American date format (MM/DD/YYYY)
2. Total :- Need to compare the total and correct if any mistake
Instruction Overview

• In the spreadsheet image column you can see more than one image (Image 1, Image 2 etc) for one row. Some receipt will be large and show multiple photos
of portions of the same receipt pieced together. This will consider as one receipt and need to open all images for completing one receipt. (Check the sample
files)
• Minus figure and Non products should be enter under “Coupon” type in the spreadsheet. Minus figure should be enter as Negative number. (Check the
sample files).
• Minus figures can entered in the receipt like (-6.95 or 6.95-). Both format consider as minus deduction amount.
• In a once receipt you can see “Void” product and Normal Item. For these images you need to enter Void products under “Void” type and normal products
under “Item” type. (eg: check the image in the Void product folder in the sample. Here, you would enter the "KSSTEAKSTRIP" item normally, then enter
another line of Type "Void" which also has RSD "KSSTEAKSTRIP" and the same price. (check the sample folder). If the Void item is in Minus Figure then Type
will be “Void” and enter amount in Minus Figure
• Always use CAPITAL LETTERS while entering the Item description.
• Dates must be entered in the American date format (MM/DD/YYYY), not the Indian format (DD/MM/YYYY). This should be verified while checking the
prefilled values.
• Strictly verity the receipt before entering. If the receipt is not perfect for entering then only given the listed comments in the remark column. Do not key any
other comments. If you have any other comments for particular image then use a fresh spreadsheet and give the image name and comments in that
spreadsheet.
Quality Checking Process

• While entering the description field there is chance for typing error when keying the alphabet (O, I, L etc….). Ounce should be abbreviate as OZ. Alphabet “O”
and Numeric “Zero” look like same. Alphabet “I” and Numeric “Once” look like same. So understanding the product description is important. Try to
understand overall product type of particular manufacture and preparing the database according to the product name this will helpful.
• This is important to verify the Prefilled values (date and total amount already given in the excel). Also verity the date format. (MM/DD/YYYY),
• After completing a full receipt, entry person can verify the total amount. Add the all column value. Then need to deduct the minus figures if any given in the
receipt. Then add the tax amount. After that entry person can compare the total of invoice and excel. If there is any mismatching there should be a mistake.
(Plus Figure – Minus Figure = Subtotal) (Subtotal + Tax = Total). This will reduce the error.
• For few images total item number given in the bottom side of the invoice.
 Banner id New Instructions
 Bath_n_body works  Iga  Chick-fil-A

 Fry's Food Stores and Fry's Marketplace  Pet Valu  KFC

 Food Basics , Real Canadian Superstore , Super C  LCBO  Petro-Canada

 Dollarama & Meijer  COMMISSARY

 Boots  Trader Joe’s

 Victoria’s Secret  Bed Bath & Beyond

 Costco  BC Liquor Stores

 Dillards  Five Below

 Walmart  Giant Tiger

 Giant_Eagle  Zaxby’s
 Bath_n_body works
Shipping Receipt Shopping Receipt
 Combo Items

Type Qty Item Description Price

Item 1 3PC TENDER COMBO 7.49

Item 3 *MILD TENDER 0.00

Item 1 *BISCUIT 0.00

Item 1 *REG MASH POTATOES & GRAVY 0.00

Item 1 *COKE 22 0.00

Item 1 *BARBECUE SAUCE 0.00

Fry's Food Stores and Fry's Marketplace
 Food Basics , Real Canadian Superstore (Type-1) , Super C
Type Qty Item Description Price

WRAPPED
Item 3 BROCCOLI CROWN 5.00 (1.66 X 3)

In this image, the number of items is '6’ . Meaning there are 6 items in that CREMINI
group with a group net price of 10.00. Item 2 MUSHROOM 3.34 (1.66x 2)

The (3) in front of the item “ WRAPPED BROCCOLI CROWN ”

indicates a quantity of 3 for that item.
WHITE
Item 1 MUSHROOM 1.66 (1.66 X 1)
The same applies for the item “ CREMINI MUSHROOM & WHITE
MUSHROOM ” 2 and 1.
Net Price of Group 10.00
The '3/$5.00' indicates that a quantity of 3 has a price of $5.00.

If you divide 5/3, you will get 1.66 as price for single item.
 Food Basics

Type Qty Item Description Price

Item 2 ALLEN JUICE 1.98

Item 1 RUFFLES ALL DRESS.CHIP 3.50

Item 2 FRBOWN FRUIT CUP 5.00

Item 1 SPRITE CAN 5.99

Item quantities can be indicated in parentheses in front of the item description but also on the
line below the item description.

Example: ‘FRBOWN FRUIT CUP’ has a quantity of 2

 Super C
Type Qty Item Description Price

Item 1 LIPTON SOUPE ENV 2.00

Item 1 RECET.SOUP.ENV.OIGNON 2.00

Item 1 BUBLY EAU PET.C.CERISE 5.99

Item 2 SAC MONTREAL SUPER C 0.20

Item 2 BLEUET BIO 4.00

Item 1 FRAMBOISE 170G 3.00

Item quantities can be indicated in parentheses in front of the item description but also on the line
below the item description

Example: ‘BLEUET BIO’ has a quantity of 2

 Dollarama & Meijer

 Add 0’s to the item number at the beginning to fill out required digit amount

 Applies to both Meijer and Dollarama

 Boots (Type-1)
Item Type Item Qty RSD Net Price

Item 1 EVIAN WATER 750ML 1.00

Item 1 BTS BLT/PRWN/CHK 3.35

Item 1 KINDER BUENO WHITE 0.75

Item 1 NKDLN JCE WATRM&RSP 2.60

Coupon 1 SAVING -3.31

Item 1 BTS SFRIED CHK WRP 3.15

Item 1 KINDER BUENO WHITE 0.75

Coupon 1 SAVING -1.51

If you see "MEAL DEAL" or "***SAVE***" item groupings on Boots receipts:

1. Enter the price located next to the RSD for each item as net price
2. Enter the "SAVING" as a coupon
3. Enter the price printed after "SAVING" as the net price for the "SAVING" coupon, do not enter the price that is printed after
"NOW“

Remember - This methodology applies ONLY for MEAL DEAL and ***SAVE*** on Boots receipts.
 Boots (Type-2)

BOOTS PTS

Some of the boots receipts may have points (PTS) instead of price, as seen in below image. Reject such receipts as
“NOT_RECEIPT”
 Victoria’s Secret

Most of these receipts total amount is zero. UPC code given in the receipt with product amount. Also the same amount is give as
discount. Due to this the total and subtotal showing zero. This should be entered as a normal receipt.
costco
 Costco
Type RIN Item Description Price

Coupon 000022785 /2161251 -3.00

Item 51214 VINEGAR 3.49

Item 32711 CHINET PLATE 17.89

Item 32711 CHINET PLATE 17.89

Void 32711 CHINET PLATE -17.89

Item 921279 FRZ GAL ZIPR 14.99

Need to enter this type of RIN number as above mentioned.

 Costco
Type Qty RIN Item Description Price

Item 1 585578 KS BATH 17.99

Void 1 585578 KS BATH -17.99

Item 1 388206 VILEDA EASY 38.99

Coupon 1 1432462 TPD/388206 -9.00

Item 6 180100 REALEMON 2PK 25.74

Item 1 129572 EGGS 2.5 DZ 6.29

Item quantities are indicated on the line ABOVE the item

 Costco
Type Qty RIN Item Description Price

Item 1 585578 KS BATH 17.99

Void 1 585578 KS BATH 17.99

Item 1 388206 VILEDA EASY 38.99

Coupon 1 1432462 TPD/388206 9.00

Item 6 180100 REALEMON 2PK 25.74

Item 1 129572 EGGS 2.5 DZ 6.29

• When an item on the receipt has a negative price, it is considered a Coupon

• When an item on the receipt has a negative price but also has the word ‘VOID’
above it, then it should be entered as a Void
• Item quantities are indicated on the line ABOVE the item
 Costco
Type Qty RIN Item Description Price

Item 1 1130713 JUS ASSORTIS 8.99

Item 3 427367 FROM CREME 29.97

Item 1 1212860 KS CHEWY BAR 8.99

Item 1 427367 FROM CREME 9.99

Void 1 427367 FROM CREME 9.99

‘ANNUL’ = Void for French-Canadian receipts

 Costco

Total

• The Total that should be entered is the one that is

listed before the payment method/details and will
Payment
say the word ‘Total’ next to the value method
 Costco

Total

• ‘Executive Rebate’ and ‘CC Reward’ are considered

payment methods and should not be transcribed
 Costco
● This is considered a return slip or
not a shopping receipt due to
returned items and a negative Total

● Returned items are indicated by a

negative price

● Coupon line (1347399,

TPD/1083189) shows up as a
positive price

● Promotions/coupons applied to an
item will show up as a positive price
when the item is returned
 All type receipts

When the total of a receipt is negative, if the items are returned then reject it as NOT_RECEIPT
 DILLARDS

You will need to remove the dashes ("-"). And the UPCs for Dillards must be exactly 12 or 13 digits long.
 Walmart
Type Qty UPC Item Description Price

Item 1 006310037556 DELI EXP BCN 2.97

Item 1 006310037556 DELI EXP BCN 2.97

Item 1 006827400014 NPL WATER 2.97

Item 1 007874264076 NS DEPOSIT 2.40

Item 1 006827400014 NPL WATER 2.97

Item 1 007874264076 NS DEPOSIT 2.40

Item 1 005717406216 TEA 6.97

Coupon 1 DISCOUNT GIVEN -0.59

‘DISCOUNT GIVEN’ should be entered as a coupon with negative price.

 Walmart

In this example, do not transcribe ‘ASSOCIATE DISCOUNT’, because it comes AFTER the final subtotal
 Walmart
Type Qty Item Number Item Description Price

Item 1 PHARMACY 3.73

Item 1 PHARMACY 3.73

No need to enter D38 as item number or description

 Walmart
Type Qty UPC Item Description Price

Item 1 RX# 6348105 0.00

Item 1 RX# 6355672 1.19

Item 1 RX# 6299787 10.00

Item 1 RX# 6354072 2.32

Item 1 005084417594 QP APAP CAP 1.98

Item 1 007874209254 ORG CREAMER 1.84

‘RX#’ indicates a prescription/medication, it has no item number

 Walmart
Type Qty Item Number Item Description Price

Item 1 000000001234 PLASTIC BAG 0.05

Coupon 1 STACKERS/LM 2 for $5 -3.08

000000000035

Coupon 1 000000000167 BSB 2 FOR $20 -2.00

Need to enter the item number as seen in the image

 Walmart
Type Qty Item Number Item Description Price

Item 1 006291303234 SB BATH TRIG 3.78

Item 1 002420005030 PUREX UC 6.77

Item 1 062891564393 GARBAGE BAGS 12.97

Coupon 1 ASSOCIATE DISCOUNT - 9.80

Item 1 068113198193 FBC DONATION 1.00

Coupon 1 123 SCRUBBING 2 FOR $6 - 1.56

Coupon 1 71 SNACK CAKES 2 FOR $6 - 0.94

Coupon 1 224 COKE-PEPSI 2 FOR $9 - 1.88

‘ASSOCIATE DISCOUNT’ appears more than once before the final subtotal, but it only has to be entered one time
 Walmart
Type Qty Item Number Item Description Price

Item 1 088304928323 AFF WASH 5CT 9.98

Item 1 002840007098 TOST QUESO 3.98

Item 1 002840007095 LAYS RNCHDIP 3.98

Item 1 002840000078 DIP 2.98

Coupon 1 VENDOR COUPON - 3.00

VENDOR COUPON’ need to be process, because it is listed BEFORE the final subtotal
 Walmart
Type Qty Item Number Item Description Price

Item 1 085303600600 OYSTER MUSH 19.93

Coupon 1 053600600000 COUPON 36006 -12.99

Item 1 053600600000 COUPON 36006 19.93

Item 1 053600600000 COUPON 36006 12.94

Item 1 056670300000 COUPON 66703 12.94

Void 1 003064178029 CALADIUM -3.00

If a voided product has positive price, then it needs to be entered as item

giant_eagle
IGA
 PET VALU

Type Qty RIN Item Description Price

Item 3 9994760 GOLD DUST L/T MOLLY 1EA 13.47

Coupon 1 GOLD DUST L/T MOLLY 0.68

ZM REPTI ROCK WATER DISH

Item 1 66570 1XS 6.49

• Item quantities are listed below the item description

 LCBO

Type Qty Item Number Item Description Price

DOMAINE D’OR SUPERIOR

Item 1 00193821 WHITE 14.95

Item 14 00088815 TATRA BEER 30.10

Item quantities are in parentheses on the line BELOW the item number
 COMMISSARY

• ‘Surcharge’ listed after the subtotal should not be transcribed

 Trader Joe’s

• ‘OZ’ = ounce = weight → Quantity for that item is 1

• ‘FLOZ’ = fluid ounce = weight → Quantity for that item is 1
• ‘EA’ = each = quantity → Quantity for that item is the number before ‘EA’

→ Quantity = 1

→ Quantity = 1

→ Quantity = 5
 Trader Joe’s
Type Qty Item Description Price

Item 1 ORG FREE RANGE CHICKEN BROTH 3.98

Item 1 TOMATO BASIL MARINARA 1.79

Item 1 HOL PUMPKIN WAFFLES 1.99

Item 1 HOL MAC & CHEESE BUTTERNUT SQU 2.99

Item 1 SALMON SMKD 3 OZ 4.49

Item 1 TARTAR SAUCE 2.29

Item 1 CUCUMBERS HOTHOUSE EACH 1.29

Quantities greater than 1 indicated by ‘EA’ after the value
Item 2 TOMATOES ROMA EACH 0.58

Watch out for weights (ex: FLOZ = fluid ounce)

12
 Trader Joe’s

Type Qty Item Description Price

Item 1 CHOMPS GRASS FED BEEF JALAPENO 3.38

Item 1 HOL PUMPKIN BUTTER 2.29

Item 1 PLANTAIN CHIPS 1.79

Quantities greater than 1 indicated by ‘EA’ after the value Item 5 BANANAS EACH 0.95

Watch out for weights (ex: OZ = ounce)

 Bed Bath & Beyond
• Time can be found next to date (see time outlined in red)

• Format of Transaction Date & Time = MM/DD/YY-HHMM

• Time should be entered in 24-hr format since there is no AM/PM

designation Example: 11:12
 BC Liquor Stores
• Two timestamps are printed on the receipt but
you can enter either one

• Time format is shown as AM/PM and also as 24-hr

• If the time you choose to enter is the AM/PM

format, then you need to include ‘AM’ or ‘PM’ in
the time Example: 1:04 PM
 Five Below

• Time format is shown as AM/PM

• Time should be entered with ‘AM’ or ‘PM’ included

 Five Below
• Prices that are in parentheses indicate a
negative price

• Some receipts contain both returned items and

purchased items

• If the Total is in parentheses (negative) then we

consider this a return slip or not a shopping receipt
 Giant Tiger

• If the Total is negative then we consider

this a return slip or not a shopping
receipt
 Giant Tiger
Type Qty Item Number Item Description Price

Item 1 0205893 283G FE CAESAR 9 3.99

Item 2 0157430 425G CHEF BOYARDEE 9 1.98

Item 1 0157448 425G CHEF BF RAVIO 9 0.99

Item 2 0965348 FRSH CHK THIGH 9 4.94

Watch out for item quantities that are greater than 1, they will be shown below the item number in
smaller font
 Zaxby’s

Quantities in parentheses are part of the The number right before the item description
item description for these items are part of the item description
Zaxby’s

Type Qty Item Description Price

Item 1 PLATE MEAL 0.00
Item 1 5 FING PLATE 8.99
Item 1 FRIES 0.00
Item 1 SLAW 0.00
Item 1 22 OZ DRINK 0.00
Item 1 COKE 0.00
Item 5 EXTRA SAUCE 1.25
Item 5 ZAX SAUCE 0.00
Zaxby’s
Type Qty Item Description Price

Item 1 TLC SAND ML 3.99

Item 1 SANDWICH ONLY 0.00

Item 1 (5) WING MEAL 8.19

Item 1 (5) WING W/MEAL 0.00

Item 1 *WIMPY* 0.00

Item 1 FRIES 0.00

Coupon 1 NO DRINK 1.00

 Chick-fil-A

Type Qty Item Description Price

Item 1 FRST LMNDE SM 3.79

Item 1 MLKSHK STRW SM 3.79

Item 1 + CHOC 0.30

Coupon 1 EMPLOYEE 50% 10.20

Symbols in front of the description are part of the item description

KFC
Type Qty Item Description Price

Item 1 16PC MEAL 37.99

Item 2 LRG MAC & CHS 0.00

Item 2 LRG MASH/ GVY 0.00

Item 8 BISCUIT 0.00

Item 2 UPCHARGE 1.98

Item 1 SUB LG SIDE 0.00

 KFC
Type Qty Item Description Price
Item 1 2P CHKN COM 8.49
Item 1 *WITH LEG 0.00
Item 1 *WITH RIB 0.00
Item 1 *W BG IND FRY 0.00
Item 1 *REG POP 0.00
Item 1 FLATBREAD SAND 2.79

Symbols in front of the description are part of the item description

 KFC

Type Qty Item Description Price

Item 1 12 PC CHICKEN 26.69

Item 1 CHICKEN BOWL LG 5.99

Quantities in parentheses are part of the item description

 KFC

Item quantities are listed under the ‘QTY’ section on the receipt
 Additional Instructions
 Enter the description exactly as in the receipts including special characters (£, $, -, / etc.).

 Even if the total of a receipt is 0, you must enter it, if it has items or products.

 If the receipt's banner name doesn't match the "banner_id" in the csv, you must reject the receipt with rejection reason "
WRONG_BANNER".

NOTE: If there are more than one image for a “receipt_id” you must check all the images before transcribing, to find the
correct one according to the "banner_id", "transcaction_date" & "total".

 If the "transcaction_date" & "total" are missing or different in the csv file you must enter it from the image.

WHSMITH RECEIPTS

 You must enter the receipts of banner WHSMITH even if the banner name is not visible in the image.

 If a single receipt ID with images of multiple banners, you can reject it with a rejection reason “MULTIPLE_RECEIPTS”.
 Screenshots of Receipts
• Receipts on a computer or phone are not considered valid paper receipts
 Taxes
• ‘HST’, ‘PST, or ‘GST’ are taxes found on Canadian receipts and should not be transcribed
• They are usually found near the subtotal or total on the receipt
 GAS_ONLY

You can identify these receipts because they note the number of "Gallons" (the US unit of measure for gas), or
"Price/Gallon", or "Fuel Total", or "Unleaded", or "Pump #", etc.
 WRONG_BANNER

The above receipt has no banner name related to excel banner ID , then you can reject it as wrong_banner
 NOT A WRONG_BANNER

The above receipt the banner id is not present in the top of image,but it is present in the bottom of image. So need to process it.
 Leading Zero Instruction

Correct: 049040159

Wrong: 49040159

This leading-zeros must be included in the transcription

 Leading Characters

No need to process the character at the end of description.

 Numbers In description

Need to process with the numbers as the description

 Rental Receipts

Rental receipts should be rejected as NOT_RECEIPT

 COLUMN DETAILS
TRANSCRIPTION_TYPE
initial state: prefilled
entry person should: (do nothing)
allowed values: only these strings: "RSD", "RIN", "UPC", "RIN_RSD", "UPC_RSD"

RECEIPT_ID
initial state: prefilled
entry person should: (do nothing)
allowed values: INTEGER

BANNER_ID
initial state: prefilled

TOTAL
initial state: prefilled
entry person should: edit if necessary

TRANSACTION_DATE
initial state: prefilled
entry person should: edit if necessary
must be in "(M)M/DD/YYYY" format
 COLUMN DETAILS
SR.NO
initial state: "1"
entry person should: do nothing for the 1st line-item; increment for subsequent line-items

ITEM_TYPE
initial state: blank
entry person should: enter
allowed values: if rejection_reason is populated: (blank); else: only these strings: "item", "coupon", or "void" - case-
insensitive

QUANTITY
initial state: blank
entry person should: enter
allowed values: if rejection_reason is populated: (blank); else: INTEGER

UPC CODE - ONLY IN UPC and UPC_RSD

initial state: blank
entry person should: enter
allowed values: if rejection_reason is populated: (blank); else: string consisting only of numbers, should be 10-16
digits
 COLUMN DETAILS
RIN CODE - ONLY IN RIN and RIN_RSD CSVs
initial state: blank
entry person should: enter
allowed values: if rejection_reason is populated: (blank); else: string consisting only of numbers, "\", "/", and "-"
chars, should be 5-12 digits

RSD - ONLY IN RSD, RIN_RSD, and UPC_RSD CSVs

initial state: blank
entry person should: enter
allowed values: if rejection_reason is populated: (blank); else: string

PRICE
initial state: blank
entry person should: enter
allowed values: if rejection_reason is populated: (blank); else: NUMBER (max 2 decimal digits)

PER_ITEM
initial state: blank
entry person should: enter
allowed values: if rejection_reason is populated: (blank); else: NUMBER (max 2 decimal digits); should equal
(price/qty)
 COLUMN DETAILS
REJECTION REASONS
initial state: blank
entry person should: enter only if rejecting the receipt for one of the following reasons allowed values: only (blank), or any of:

 “BLURRY” - The receipt is too blurry (or dark, or unreadable for any reason) to transcribe all of necessary data.

 “NOT_FULL_RECEIPT” - An important portion of the receipt is missing, so you are unable to transcribe all the data.
(This can happen if important text is cut off from the top or bottom of the receipt image, or if there
are multiple receipt images and they don’t overlap.)

 “NOT_ENGLISH” - The receipt is printed in any language besides English

 “DOCTORED” - The shopper has clearly edited the text of the receipt (with a pen or pencil)

 “GAS_ONLY” - The shopper only purchased gasoline (petrol). If the shopper purchased gasoline plus other items, the
receipt should be transcribed normally.

 “MULTI_RECEIPT” - More than one banner id in a single receipt id or more than one valid banners in a single image

WORKER ID
initial state: blank
entry person should enter their name.
 For more assistance

Skype id - live:.cid.af424ccea5458f84

Allianze Projects