free excel template for craft business income and expenses

This sheet lets you compare your conventions to each other. You can duplicate this spreadsheet for each event you attend. There is also a second table that lets you calculate your income versus your convention expenses, such as table fees, travel costs, etc. That data can be applied on the next spreadsheet. There are subtotals for each category, and final totals listing your full sales and your profit from those sales. The individual convention spreadsheet is a list of all the products you have for sale at a particular convention subdivided into categories. (They may need some editing if you add or delete fields.) The charts will function automatically as soon as values are entered in the spreadsheets. Many of the spreadsheets have charts included so that you can get a quick visual representation of what’s going on with your business. The formulas are very simple, so it should be easy to modify them to suit your needs. (In Excel, there are additional spreadsheets for the charts and some tables.) Most of the spreadsheets have some auto calculating fields to do the math for you.

It occurred to me that this might be useful to other people, especially those starting out, so I’m making them available for download. Over the last few years I’ve been putting together a set of spreadsheets to manage our studio finances. It’s important to keep track of your income and expenditures so you can identify issues, evaluate your product sales, and get your taxes straight. I have yet to meet an artist that doesn’t feel the need to do a better job organizing their finances. When artists get together for dinner, they discuss Money. When bankers get together for dinner, they discuss Art.

Free excel template for craft business income and expenses