Introduction #
If you have consignment or other commission-based partners from whom you source products, the Commissions tab of the Reseller Toolkit makes it easy to track linked sales, how much is owed to partners, and your payments to them. It’s a good idea to set up your partners in the table on the left as soon as you start using the worksheet for the first time, then add to if you acquire new partners.
Please note that this is an optional tab, and if you never plan to sell items on commission, you can safely ignore it. Perhaps you want to move this tab to the end of the list then or hide it.
Columns #
Partner Name: The name of the person or organization linked to commissions. This is the same as the Supplier list in the My Business tab, but you should only enter rows here for partners who are linked to commissions. Use one row per partner.
Rate (%): This is the rate that you pay to commission partners out of net profit. If a partner has a commission rate of 25% and the net profit on an item (as calculated on the Sales tab) is $20, then the worksheet will calculate that the partner is owed $5.
Last Payment: This column calculates when the partner was last paid based on the payment history records in the table on the right side of the page. It looks for the most recent date for that partner.
Total Paid: This amount is calculated automatically by looking at payments to that partner on the right side of the page.
Average Sale: This column looks at all sales linked to the partner and calculates the average selling price of their items.
Date (in the Payment History table): This is the date that you sent a payment to the commission partner, recorded in the format 12/31/2025.
Amount: How much you paid the commission partner on the associated date.
Notes #
- Although you may have multiple payments linked to an individual partner on the right side of the page, in the table on the left each partner should only be listed once.
- In the Owed column, a green background indicates nothing is owed to the partner, while a red background shows an amount outstanding.