1 of 6
Consultant Name Jane Jones
Change the blue amount to the
Consultant Number XX1234 proper rate for your state.
State Tax
>>>>>>>>
Director Name Mary Smith > 0.088
Enter your name, number, and director's name. Do not forget to change your tax amount in cell G3. Sheet is protected so that
formulas are not altered. You ONLY need to enter information into the white cells. The gray cells will auto-calculate. To add
more rows: unprotect the sheet (pw: MK), click on a row number at the left to highlight the row, right click, and select "copy."
Right click again and select "insert copied cells." Don't forget to protect your sheet when you are finished.
Retail Price Retail Wholesale Consultant Consultant
Item Description (EACH) Quantity Amount Amount Tax Cost Loss
Lip Gloss $13.00 16 $208.00 $104.00 $18.30 $122.30 $10.40
Lip Liner $10.00 23 $230.00 $115.00 $20.24 $135.24 $11.50
Eye Shadow $6.50 24 $156.00 $78.00 $13.73 $91.73 $7.80
Loose Powder $14.00 8 $112.00 $56.00 $9.86 $65.86 $5.60
Foundation Medium $14.00 10 $140.00 $70.00 $12.32 $82.32 $7.00
Microderm Step 1 $30.00 16 $480.00 $240.00 $42.24 $282.24 $24.00
Microderm Step 2 $25.00 16 $400.00 $200.00 $35.20 $235.20 $20.00
$0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00
2 of 6
Consultant Name Jane Jones
Change the blue amount to the
Consultant Number XX1234 proper rate for your state.
State Tax
>>>>>>>>
Director Name Mary Smith > 0.088
Enter your name, number, and director's name. Do not forget to change your tax amount in cell G3. Sheet is protected so that
formulas are not altered. You ONLY need to enter information into the white cells. The gray cells will auto-calculate. To add
more rows: unprotect the sheet (pw: MK), click on a row number at the left to highlight the row, right click, and select "copy."
Right click again and select "insert copied cells." Don't forget to protect your sheet when you are finished.
Retail Price Retail Wholesale Consultant Consultant
Item Description (EACH) Quantity Amount Amount Tax Cost Loss
$0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00
------------------> TOTALS 113 $1,726.00 $863.00 $151.89 $1,014.89 $86.30
3 of 6
Consultant Name Jane Jones
Change the blue amount to the
Consultant Number XX1234 proper rate for your state.
State Tax
>>>>>>>>
Director Name Mary Smith > 0.088
Enter your name, number, and director's name. Do not forget to change your tax amount in cell G3. Sheet is protected so that
formulas are not altered. You ONLY need to enter information into the white cells. The gray cells will auto-calculate. To add
more rows: unprotect the sheet (pw: MK), click on a row number at the left to highlight the row, right click, and select "copy."
Right click again and select "insert copied cells." Don't forget to protect your sheet when you are finished.
Retail Price Retail Wholesale Consultant Consultant
Item Description (EACH) Quantity Amount Amount Tax Cost Loss
Total Number of Items Returned 113
Wholesale Total $863.00
Consultant Loss Total $86.30
90% of Wholesale $776.70
Taxes refunded $151.89
MY REFUND CHECK FROM MK: $928.59
(Refund total based on 90% Wholesale Amount plus Tax)
Reminder: Make sure you insure your items when shipping them and include a copy of this spreadsheet in each box.
4 of 6
5 of 6
6 of 6