Costs Breakdown Accounting Spreadsheet with Charity Donation Log for your UK Handmade Business, Accounting System, Bookkeeping Template

This is a digital file

$28.85
Get Shipping Estimate
$28.85
In stock
Digital download

Features
Digital
Made in Earby, United Kingdom

Item details

A bookkeeping system with cost breakdown and charity donation log for your UK based handmade business, including an accounting spreadsheet Excel file instant download with a detailed instruction booklet.

I have run my own handmade business for several years, and from this experience I have developed, tested and tweaked a bookkeeping system that works perfectly for people selling their handmade creations through their Etsy shop.

This system allows you to log each transaction you make for your business (with a nifty time saving trick for inputting you Etsy order data, detailed in the instruction booklet). It will reward you by giving monthly and yearly totals for your revenue, costs and profit so you know exactly where your business stands financially, with charts to give you at-a-glance insights that you can really visualise.



The Importance of a Good Bookkeeping System

Being able to see your business finances at a glance and knowing exactly where you stand at any point can be really valuable when planning for your future, or even making decisions right here, right now. When you can see trends throughout the year, you can make predictions for next year. When you can compare your yearly expenses against your yearly profit you can see if you’re actually charging enough to cover them. When you’re trying to justify buying that lovely new camera (or sewing machine, or printer, or circular saw, or other shiny new thing of magic and wonder that will make working life so unbelievably great) you can see/predict just how long it has taken/will take to earn enough to pay for it. You start feeling in control of your business and less dependent on the whims of the fluctuating handmade market.



The Right Accounting System for You

This bookkeeping spreadsheet is designed for those based in the UK with an Etsy shop, but also allows for PayPal sales and purchases, and cash, cheque and bank transactions. If you’re a Sole Trader in the UK, working on a Cash Basis accounting method and not VAT registered, this can help you find the values needed to complete your Self Assessment Tax Return.

This is the Charity Donations Bookkeeping Spreadsheet with Costs Breakdown

I have developed a selection of templates to suit various business needs, allowing for those who use a bank or PayPal account for both business and personal transactions, those who would like to break down their costs into greater detail to see precisely how much they spend on what, and those who would like to record charity donations made from sales. See the last picture for a chart which will help you to find the best system for you.

Other sheets can be found in my shop:

Bookkeeping Spreadsheet
https://www.etsy.com/uk/listing/523267291/bookkeeping-spreadsheet-for-your-uk?ref=shop_home_active_5

Bookkeeping Spreadsheet with Costs Breakdown
https://www.etsy.com/uk/listing/523279863/costs-breakdown-bookkeeping-spreadsheet?ref=shop_home_active_4

Charity Donations Bookkeeping Spreadsheet
https://www.etsy.com/uk/listing/523281155/bookkeeping-system-with-charity-donation?ref=shop_home_active_3



About Your Bookkeeping System

You will receive an Excel file which you can make copies of to use year after year, making this the only bookkeeping system you will ever need for your business. You will also receive a detailed information booklet which will talk you through each step: from saving your file template and making copies to enter data into, right through to copying over data from Etsy and PayPal CSV files so that all your monthly sales can be entered in a few simple steps.

If you purchase using an Etsy account registered to a Google email address I can also offer you access to a Google Sheets version of this spreadsheet, which you can save onto your own Google Drive and use online. This is great if you don’t have Excel, simply if you like your work to be automatically saved stored in a cloud, reducing the chance of losing your data due to computer mishap, or if you want to be able to input transaction details while you’re on the go, using the Google Sheets mobile app.


It opens with a main Monthly Summary sheet where you will be able see your monthly totals and have an overview of your business finances, this is where the magic happens. Then there are several data input sheets where you will enter all the necessary information about your business transactions.

This bookkeeping system allows you to break down your costs into your own desired categories, so you can see exactly where you’re spending in particular areas, for example, to check if your advertising and marketing costs are having the desired impact on your revenue.

There is also a sheet to include any charity donations you make from your sales, and you will see monthly and yearly totals of amount you are donating.

Your data requires manual input, and I have included detailed instructions in the accompanying booklet of how to do this in an efficient but accurate way. You will of course enter all your Etsy Direct Checkout transaction details, but can also include sales made through PayPal, cash sales, cheques and bank transfers, and may be able to include sales from other payment providers if they follow a similar format as those already listed.



The term "Etsy" is a trademark of Etsy, Inc. Happy Dance Solutions and any of its products are not affiliated with or endorsed by Etsy, Inc.


FAQs

While I am unable to assist with general help with Excel and Google Sheets, other than issues directly related to your spreadsheet, both come with detailed help sections and there is a wealth of information to be found online.

Digital downloads are non refundable, so please read through the information in the listings very carefully and contact me with any questions you have before purchase.

These spreadsheets are .xlsx files and will work in Microsoft Excel, versions 2007 or later, or Excel Starter 2010. If you make your purchase using an Etsy account registered to a Google gmail address then I can allow you access to a Google Sheets version of the spreadsheet, to save onto your Google Drive, so that you can work online. You can add a note at the checkout if you'd like me to do this.

While I am unable to assist with general help with Excel and Google Sheets, other than issues directly related to your spreadsheet, both come with detailed help sections and there is a wealth of information to be found online.

Digital downloads are non refundable, so please read through the information in the listings very carefully and contact me with any questions you have before purchase.

These spreadsheets are .xlsx files and will work in Microsoft Excel, versions 2007 or later, or Excel Starter 2010. If you make your purchase using an Etsy account registered to a Google gmail address then I can allow you access to a Google Sheets version of the spreadsheet, to save onto your Google Drive, so that you can work online. You can add a note at the checkout if you'd like me to do this.



Reviews
No reviews yet

More from this seller

Digital downloads
File delivery
Your files will be available to download once payment is confirmed. Here's how.

Payments
Secure options
Etsy Studio keeps your payment information secure. Etsy Studio shops never receive your credit card information.