Multi-Platform Consignment Sales Statement — Excel, Google Sheets & LibreOffice | Australian Sellers
Are you selling items on behalf of clients across multiple online platforms? This professional consignment sales statement template takes the hard work out of tracking sales, calculating fees and paying your clients accurately every month — and it works on Excel, Google Sheets and LibreOffice with no macros required!
Designed specifically for Australian consignment sellers, this template automatically:
- Calculates platform fees for eBay, Etsy, TikTok Shop and Gumroad
- Removes GST from applicable platform fees (eBay, Etsy and TikTok Shop)
- Calculates your commission and applies your maximum commission cap
- References your business and client details from the SETTINGS sheet automatically
Simply enter:
- Date of sale
- Item name
- Quantity
- Sale price
- Selling platform
- Postage and packaging costs
Everything else is calculated automatically!
📊 Key Features:
- Supports 20+ selling platforms including eBay, Etsy, TikTok Shop, Gumroad, Amazon, Shopify, Facebook Marketplace, Gumtree and more
- Fully customisable commission rate and maximum commission cap
- Colour coded layout — instantly see deductions, actions required and client payouts
- SETTINGS sheet — enter your business details, client details and commission settings once and they appear throughout
- Platform fee rates stored in SETTINGS — update fees in one place if platforms change their rates
- Customisable platform list — rename platforms and set your own fee structures
- Professional READ ME sheet with full instructions
- Data validation messages guide you throughout
- Pre-set payment numbers that increase automatically from your starting number
- Organised by fiscal year — one workbook per year for clean record keeping
👥 Perfect for:
- eBay consignment sellers
- Online resellers managing client items
- Anyone selling across multiple platforms on behalf of others
- Users who prefer Google Sheets or LibreOffice over Microsoft Excel
💻 Compatible with:
- ✅ Microsoft Excel
- ✅ Google Sheets
- ✅ LibreOffice
- ❌ Not compatible with Excel Online
- Designed for Australian sellers (GST calculations based on 10% Australian GST)
🔓 Edit Freely: Your download includes a separate text file containing the workbook password. While the sheets are protected by default to prevent accidental changes to formulas, you are welcome to unprotect and edit any part of the workbook to suit your needs. After all — you paid for it!
🔗 Also Available:
Looking for even more automation? Check out our Excel VBA version which includes automatic payment numbering, carry forward balances and click to replace logo!
Or Version 3, which includes all of the Excel VBA version features plus the ability to update selling platform names and their fee structures!
📜 Terms of Use:
- Personal Use Only: This template is for personal or internal business use only and may not be resold or redistributed
- Non-transferable Licence: This template is for your use only and cannot be transferred to others
- Modifications: You are welcome to modify the template for your own use — however the original terms of use still apply
- Copyright: All designs and elements remain the property of the creator and may not be used separately or without permission
❌ Return Policy:
This is a digital product — due to the nature of instant downloads, refunds or exchanges cannot be offered. Please read the description carefully before purchasing. If you experience any issues with your purchase please don't hesitate to contact us and we will do our best to help!
Updated to Version 2.9.3 - minor spelling and formula updates that didn't affect the function. The formula updates added extra decimals to some numbers to ensure accuracy.