![]() ![]() You can also use Google Sheets, a similar program powered by Google that is completely free to use. If not, it’s available to download for a small fee. You probably already have it installed on your computer.Here are a few reasons you might want to do your small business bookkeeping in an Excel spreadsheet: Excel has a number of useful applications, including bookkeeping. Microsoft Excel has been around for decades but is still used by businesses today because of its accessibility and robustness. Why use Excel for your small business bookkeeping Learn how to do small business bookkeeping in Excel like a professional, and get access to our free Google Sheets and Excel bookkeeping template for small businesses. Chances are you already have access to the computer program. If you’re already a small business owner or just starting your own business, you can save money by using Excel to create a bookkeeping system. Some businesses choose to hire a bookkeeper or utilize accounting software for their bookkeeping. Having a good system for bookkeeping will help keep your business finances organized year-round. Bookkeeping is the process of recording daily business transactions. If you need to report sales tax / vat on your sales then there is a separate report to show you the tax your customers, split between how much has been paid to you (for you to report) and how much Etsy has retained to pay over on your behalf.Īt the moment I have various templates to choose from and your choice depends primarily on where you are based.Anaging your day-to-day finances is one of the most important tasks of any small business. You can see your sales (split between product sales, refunds and shipping income) and all your fees by category so you know exactly what you have earned and been charged without having to extract the right numbers yourself. To make it easier for you I have set-up a few templates where you copy and paste in your Etsy Payment Account and Order file downloads each month and the file will pull out the right numbers for you and populate your 12-month report. HINT: All my Etsy templates allow you to add Income and Expenses from outside Etsy as well using the same manual Income and Expense sheets as described above so you can always have your whole business in 1 file.Įtsy is notorious for having confusing reports that all show different figures, don’t add up and don’t match and makes it really difficult to find the numbers you need for your bookkeeping. Etsy Only TemplatesĪs a fellow Etsy Seller Seller I have created templates just for you which are pre-set up to already have the right categories for your Etsy Sales and Fees to simplify the set-up of your template. The one you need will depend on which platform(s) you sell on and where you are based. You don’t have to manually add each sale! These work by letting you download your transactions and paste into the file so your sales and fees are calculated automatically. Just choose the Tax OR Non-tax version based on the answer you gave above.Īll other Bookkeeping templates are linked to specific sales platforms. ![]() The template then groups your transactions by month and category and drops them neatly into a 12-month report. Just add the date, description and amount and choose a category from a list that you create when you set up the spreadsheet. My most popular templates are the List based reports where you input your Income and Expenses on 2 separate sheets. If you are in the UK or Australia and are not VAT registered then the answer is probably No. Do you need to report tax on your sales to the authorities?Īs a quick guide, if you are based in the US then the answer is probably yes. The templates will work for any business as you decide on the Income and Expense categories you want to see, so whether you sell products or services, or whether you have a physical store or sell online - they will work for you. You can either key them in individually, or copy and paste from another source but you are responsible for making sure that you add the data to the right column and in the right format. At the moment there are 3 of these to choose from.Īll of these are Manual Templates, which means that you add your transactions manually into the file. These templates will work for you - whatever type of business you have as they do not rely on data feeds to get to your monthly figures. My templates are split between categories depending on what sort of business you have and which online sales platforms you use. First of all, what type of business do you have? ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |