This spreadsheet is designed for eBay sellers and online resellers who want
to keep their records organized and clearly understand their real profit.
Instead of guessing how much money you made, you can track what you sold, what
you spent, your fees and expenses, and your actual net profit all in one place.
By keeping your activity organized throughout the year, tax season becomes much
easier and far less stressful.
The workbook was intentionally created to be
simple and beginner-friendly, so even users with little or no Excel experience
can use it. It is intended for small to medium-sized online sellers and works
with Microsoft Excel (Windows/Microsoft Office) and Apple Numbers for Mac. It
is not compatible with Google Sheets. This is a digitally delivery spreadsheet
file and will be sent to you through email.
The spreadsheet includes:
1. A
main sales table that calculates gross profit and overall performance
2. A
supplies and expense sheet to organize business expenses and deductions
3. A
full income statement with charts to view your business performance
4. A
monthly sales table showing a month-by-month breakdown
5. An
inventory logbook to track purchases, quantities, and item categories
6. A
mileage log to record vehicle use for business purposes
7. A
fees, shipping, and tax information guide with general seller guidance
8. Optional
advanced reporting tables (not required to use)
I have personally been an eBay seller for over
9 years and use this exact spreadsheet for my own bookkeeping and tax
organization. Recording transactions a little at a time throughout the year
greatly reduces the burden of preparing records at year-end.
With my accounting background and experience
using Excel, I created this spreadsheet to provide sellers with a practical and
affordable record-keeping system. As of January 1, 2026, 83 buyers have
purchased this spreadsheet, and most questions received have only been simple
clarification or customization preferences. You can view feedback in my eBay
storefront.
After purchase, please provide your email
address and I will send you your copy of the spreadsheet to your email. No
physical item will be mailed. The file will be sent promptly so you can begin
using it right away. If you have any questions setting it up, feel free to
message me and I will help you.
The spreadsheet can be reused for any year. I
recommend keeping a blank master copy for future use.
This spreadsheet requires manual entry and
does not automatically import data from eBay.
Disclosure: This spreadsheet is an organizational bookkeeping tool and not tax advice. You are responsible for entering accurate information.