Ebay Tiered Commission Consignment Spreadsheet

Price: $7.99

This software will allow you to keep track of all your ebay Trading Assistant transactions easily and accurately. It contains fields that are preprogrammed with functions to calculate:

Initial Ebay Fees
Final Value Fees
Listing Upgrade Fees
Paypal Charges
Your Company's Commission
Client's Proceeds

This spreadsheet gives you the ability to set your commission rates for 4 different TIERED price ranges. It contains a summary page where all your eBay charges and expenses are recorded for an easy to spot check of where your business is at. It allows you to charge your clients a listing fee and specify if you or your client will pay the eBay and Paypal transaction fees. If you have any questions please email me at sales@spreadsheets.net

Commission

You can set up a progressive TIERED commission, based on the item's final sale price. See the examples below that illustrate the concept.

1) Example 1:

35% of the first $500

25% of the remaining amount (over $500)

PLEASE SET THE VALUES IN YELLOW
	Commission %		Price Point
1st Price Break	35.00%	$0.00	$500.00	Enter 1st Price Point *
2nd Price Break	25.00%	$500.01	$501.00	Enter 2nd Price Point *
3rd Price Break	25.00%	$501.01	$1,000.00	Enter 3rd Price Point *
4th Price Break	25.00%	$1,000.01	Infinite

* Be mindful that the spreadsheet will not let you enter a price lower than the price point above it.

The price structure above will yield the following results.

Your Item Sells For...	eBay's Commission...	Your Commission...	You Receive...
$50.00	$2.60	$18.95	$28.45
$100.00	$3.97	$37.90	$58.13
$150.00	$5.35	$56.85	$87.80
$200.00	$6.72	$75.80	$117.48
$250.00	$8.10	$94.75	$147.15
$300.00	$9.47	$113.70	$176.83
$400.00	$12.22	$151.60	$236.18
$500.00	$14.97	$189.50	$295.53
$750.00	$21.85	$244.75	$483.40
$1,000.00	$28.72	$314.50	$656.78
$1,500.00	$36.22	$454.00	$1,009.78

2) Example 2:

10% of the first $100

20% of the next $100 ($100.01 TO $200)
30% of the next $100 ($200.01 to $300)
40% of the remaining amount (over $300.01)

PLEASE SET THE VALUES IN YELLOW
	Commission %		Price Point
1st Price Break	10.00%	$0.00	$100.00	Enter 1st Price Point *
2nd Price Break	20.00%	$100.01	$200.00	Enter 2nd Price Point *
3rd Price Break	30.00%	$200.01	$300.00	Enter 3rd Price Point *
4th Price Break	40.00%	$300.01	Infinite

* Be mindful that the spreadsheet will not let you enter a price lower than the price point above it.

Tracks and Calculates All Your Fees and Expenses:

Data1

data30025

Sums Up Monthly Totals and Produces a Concise Summary Statement

Print out an Invoice Sheet for each of your customers.

invoice

This program also has an Invoice sheet that allows you to enter the Item number from the data entry sheet and it will fill out all the fields automatically so that you will have a concise document to give to your clients.

I am so confident that you will love this program that I will guarantee it. If you do not like it I will refund your money 100%.

Read the feedback that I have received for my Spreadsheets, they speak for themselves.

"EBAY'S FINEST - A+++ THIS SELLER WENT OVER BOARD TO BE HELPFUL +++ THANK YOU ++ Follow-up by globalduk: IF YOU DO CONSIGNMENTS YOU NEED THIS SPREADSHEET BUY NOW!! WORKS PERFECT ++BUY+" By: Globalduk

"Excellent Seller! Great Customer Support! Stands Behind What he Sells 100% A++++" By: Cjackieanne21kz

"Awesome Seller! Great Program!! Everyone Should Get One!!!" By: Breal345

"Great Spreadsheet!" By: 2fishrman

You have nothing to lose. Give this spreadsheet a try and watch your productivity soar. After receive payment I will email the program with an instruction sheet in PDF format. This program is very easy to use and you will be up and running in minutes. This spreadsheet works on Microsoft Excel and OpenOffice. Please specify which one youwill be using upon ordering.