Multi-Platform Consignment Sales Statement — Auto GST Calculations | Australian Sellers

⚠️ Please Note: This version has been deprecated and will no longer receive ongoing updates due to the release of Version 3. We have left this listing available at a lower price point should you still wish to purchase it. For the latest version with customisable platform names and fees, please see Version 3 here: https://payhip.com/b/vJH9a

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.

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
• Carries forward the opening balance from the previous month
• Increments your invoice number automatically each month

Simply enter:

• Date of sale
• Item name
• Quantity sold
• Selling platform
• Sale price
• 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 once and they appear throughout
• Dynamic platform selector — choose only the platforms you use
• Click to replace logo with your own business logo
• Professional READ ME sheet with full instructions
• Data validation messages guide you through every input
• Protected sheets prevent accidental changes to formulas

👥 Perfect for:

• eBay consignment sellers
• Online resellers managing client items
• Anyone selling across multiple platforms on behalf of others

💻 Requirements:

• Microsoft Excel with macros enabled
• Not compatible with Excel Online or Google Sheets
• 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 a version compatible with Google Sheets and LibreOffice? Check out our Universal no-macro version! Click here: https://payhip.com/b/FpUiS

For the latest Excel VBA version with customisable platform names and fees, see Version 3 here: https://payhip.com/b/vJH9a

📋 Version History:

06/04/2026 — Updated to Version 2.9.2

• Removed flickering when updating platform lists
• Spreadsheet now remains on SETTINGS sheet after updating platform list

02/06/2026 — Updated to Version 2.9.3

• Minor spelling errors fixed
• See our new Version 3 here: https://payhip.com/b/vJH9a (Now with customisable selling platform names and 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!