SMALL BUSINESS SPREADSHEET
Simplify running your small business with our small business spreadsheet designed for Google Sheets! This spreadsheet was made for those who create handmade products and easily want to keep track of their sales, inventory, customers, purchases and of course their bookkeeping. This spreadsheet is designed to do the calculations for you. Sold a product? Your bookkeeping and your inventory will update for you! Created new products? Simply enter the amount of batches and the product and update your inventory in seconds
This spreadsheet comes with an integrated bookkeeping spreadsheet consisting of multiple tabs with multiple overviews. Not only will you be able to keep track of your earnings of products sold and materials purchased, you will also be able to keep track of 64 other income and expense subcategories that you can easily customise to your liking. Keeping track of your inventory, sales and bookkeeping has never been easier!
WHY YOU NEED THIS SMALL BUSINESS SPREADSHEET:
• Works with any currency, changing the currency will only take seconds
• Use for multiple years
• Includes a full demo video with step by step instructions
• Easy to use & made for beginners
• Access on multiple devices with Google Sheets
• The calculations are done for you
• Easy to read and understand overview tabs
• Keep track of inventory, sales, orders, purchases, bookkeeping and so much more
• Designed to easily be customised to your business
• Start on any day, in any month in any year
• Start organising your business today!
TABS INCLUDED:
1. Start Tab - Set your currency, enter your profit goals and customise your income & expense subcategories
2. Log Tab - Keep track of all other income & expense transactions that are not products sold or materials purchased
3. Custom Date Tab - Create a bookkeeping overview with any date range, such as monthly, quarterly or weekly
4. Year Tab - Select a start date and create a year overview of your income, expenses and profit including a month by month breakdown in just seconds
5. 5 Year Tab - Select a start date and create a 5 year overview of your income, expenses and profit including a year by year breakdown
6. Sales Tax/VAT Tab - Keep track of Sales Tax/VAT. Simply select a start date. The option to keep track of a second Sales Tax/VAT is included
7. Tracker Dashboard - Select a start date and see a full year overview of earnings, orders, sales, top products sold, order & purchase status and so much more
8. Inventory Tracker - Keep track of an unlimited amount of material and product inventory
9. Pricing Calculator - Easily calculate prices to make sure your products are profitable
11. Product Log - Keep track of each product's breakdown including the cost, materials used and profit per product
12. Created Tab - Easily copy and paste info from the product log when new products are created to update your inventory
13. Sales Tracker - Keep track of products sold and materials used for each order, info added here will automatically update your bookkeeping tabs & inventory
14. Order Tracker - Automatically summarises your sales into orders to make keeping track of orders easier and more organised
15. Customers Tab - Keep track of customers including the amount of orders per customers, outstanding amounts and their personal info
16. Purchases Tab - Keep track of materials purchased. Info added here will automatically be updated into the inventory and in all bookkeeping overviews
17. BONUS: Automated Invoice -
DISCLAIMER
This bookkeeping spreadsheet is not set up for a specific country, it is set up in a way that no matter what country you are from you are able to track your revenue and expenses and additionally your VAT (also known as GST or sales tax). It is important to check with an accountant or financial advisor on how you should set up your bookkeeping.
DELIVERY FOR MAIL