Shes {kinda} Crafty

Dedicated to All Things {kinda} Crafty

Keep on Track | Blogging Income and Expense Spreadsheet

By 71 Comments

I interrupt my regular fun and crafty posts to bring something kind of boring and mundane to you today. So, sorry in advance to those of you who aren’t bloggers, website, or shop owners, but I’ll be back to crafts soon!
You might be asking yourself why I would be helping anyone out with finances or accounting. For those of you who might not know, I am a financial analyst by day and paycheck and a crafter by night and heart. It is true, over 12 years ago now I graduated from the best university IN THE WORLD with a degree in Accounting. I spent a couple years doing the accounting thing and then hopped aboard the analyst train as soon as I could because, just between you and me, debits and credits are really, REALLY boring! 

I spend 8 hours a day in Microsoft Excel creating reports and analyzing the information in those reports –  sounds really exciting, right?  So when a I noticed that some of my fellow blogging friends were in a mad dash come tax time a couple month ago I thought that I would create a simple Excel spreadsheet they could use to track their income and expenses year round. 

This spreadsheet is very easy to use and easy to customize and update for your own personal needs. Just follow these simple steps and you will never have to worry about any of the built in formulas!
1) If you want the header fonts that I used to show up on your spreadsheet you will have to download KG Payphone (free for personal use) but feel free to use any fonts you want.
2) NEVER type in or delete any of the mint green rows or columns – feel free to change their color to match your own scheme if you’d like but do NOT use them or delete them.
3) To add your own Income or Expense columns across the top highlight the mint green column (G in the above example if you want a new income column) right click and select insert. That will insert a column directly to the left of the mint green column and keep the formulas working. Same thing for the Expense categories – just highlight the mint green column to the right of the expense section (column M in the above example), right click and select insert.
4) To add more line items (rows) highlight the bottom mint green line which you will see when you download your own file, it is missing from the above example but it would be row 16, right click and insert a new row. That will insert a new row directly above the green row and keep your formulas working.
That’s it! Feel free to add as many columns of income and expense as you need to make your year end (or quarterly) tax preparation easier. 
You can download your own Blogger Tracking Spreadsheet here for free (it’s free but I really love comments if you do choose to download it, it’s an easy form of payment).
I am not a tax professional so I can’t really answer any of your tax questions but if you have questions on how to use this spreadsheet or tips of that nature please feel free to contact me.
linked up – tatertots and jello

Related posts:

No related posts.

Comments

  7. Thank you for sharing. Another great program that helps you keep track, especially if you sell on Etsy, is Outright.com. It automatically uploads your Etsy and paypal accounts that you link to it. 🙂

    Reply

  14. Thanks so much for this Stacy!
    I’ve been needing something like this for awhile and I am not a “numbers” person at all, so I didn’t know where to start.
    You’re the best!
    Lisa H.

    Reply

  41. I just found you. Thank you for sharing your expertise in this area. I have begun tracking my expenses for upcoming craft shows…now just waiting for the income to begin to roll in!

    Reply

  51. I am having difficulty keeping the formula when I add a new column. I followed the instructions above exactly (highlighted the mint green column, right clicked, hit add column) – the problem is that the formula doesn’t get added to the new column…any help is much appreciated!

    Reply

  54. Thank you for this! I was going to try to create something myself, but thought I would look to see if I could find one that was done for me! You are so awesome. And I am sure my tax accountant will love you too. 🙂

    Reply

  57. I too am an accountant by day and crafter by night 🙂 I completely agree that debits and credits really are boring!! Thanks so much for this awesome spreadsheet! I hope to one day kick off my own craft business, and I must say your blog is a true inspiration 🙂

    Reply

  65. I came across this just before the new year & am amazed by how beautiful it is! It has everything I was looking for in an expense tracker. Not knowing how to use a spreadsheet kind of limited me as to what I could do..lol. Thank you so much! I’ve been using it for a month and it’s so easy and has helped me keep track of everything so much easier than ever!
    Jess Benoit recently posted…Up To 30% Off at True&Co!My Profile

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

CommentLuv badge

{Facebook}

Unable to display Facebook posts.
Show error

Error: (#200) Provide valid app ID
Type: OAuthException
Code: 200
Please refer to our Error Message Reference.

{Instagram}

{Pinterest}

Follow Me on Pinterest