It's January again, and time to talk about goals, plans, and getting organized for the new year.
If you haven't taken the time to set up a book keeping system for your online business, January is the perfect time to start. Vickie Stewart, who teaches our Bookkeeping Basics class, offers an easy, user friendly book keeping spreadsheet to track your ecommerce sales and organize your inventory and expense information. I've been using the spreadsheet for 2 years and it is very handy and easy to use.
The workbook is set up for eBay and Amazon sales yet could be easily adapted for any sales channel. This bookkeeping solution features separate pages for:
- Inventory (FBA & On-Site)
- Monthly Sales Tabs
- Year-End Sales Totals - Both eBay/Amazon Tabs
- Combined Year-End Sales Tab
- Expenses Tab
- Profit Loss Tab
- Sales Goal Tracker
- Mileage Log
Vickie also has included 45 minutes of tutorial videos, so even an Excel novice can use this tool. The user-friendly tutorials are included when you purchase the product and each step or feature has its own 5 minute video, so if you get lost, you can easily find the instructions you need. It's like having your own Excel tutor right on your computer.
What's also great about this tool is that you only buy it once - this is not a monthly subscription. Once you have purchased the spreadsheet, you will also receive yearly updates as Vickie continues to fine-tune the product. The price is $29.97 , and Vickie is offering a 25% discount to my readers. Just use discount code SWTAX25 to get the discount, good until January 31.