Bookkeeping spreadsheet for authors and writers (please share!)

September 22nd, 2014 → 8:56 am @ // 9 Comments

Hate-bookkeeping-Keep-it

 

I had lunch with a friend, Joules Evans, author of Shaken Not Stirred: A Chemo Cocktail from my writers group and we talked about taxes and the dreaded record keeping.

Joules is a writer (and a very funny one!) and she detests keeping records, but she knows it is important to her success as a business owner (and because I nagged her!)

I tried to make it easy on her and shared this spreadsheet I created with her. Joules doesn’t need accounting software like Quickbooks to track her income and expenses. A simple spreadsheet will do.

Then I had an “aha!” moment and thought I’d share it with you all, too.

AuthorSpreadsheet

Author Bookkeeping Spreadsheet

(click to open the spreadsheet)

Please feel free to share this spreadsheet. All I ask is that you do not delete the box on the first tab giving me credit.

I hope it’s helpful!

Carol Topp, CPA

 


Tags: , , , ,

9 Comments → “Bookkeeping spreadsheet for authors and writers (please share!)”

  1. […] you want to keep it basic, you can either use the digital or printed version of this accounting spreadsheet created by accountant and author Carol […]

    Reply

  2. Katharine Godbey

    2 years ago

    Great spreadsheet! Thanks for sharing this. Where you recommend putting in paypal fees? Misc.?

    Reply

    • Carol

      2 years ago

      I put my Paypal fees and other banking fees (like credit card fees) in a category called Bank Fees. You could put them under Misc if they are insubstantial. My fees started adding up, so I created a separate category for them.
      On the tax return (Schedule C of the Form 1040), I put bank fees under Other Expenses.

      Reply

  3. wendy beasley

    2 years ago

    Thank you Carol, It’ll be very helpful.
    Are your suggestions equally valid for those in Canada?
    Happy holidays – Wendy

    Reply

    • Carol

      2 years ago

      Wendy, I’m happy to offer the spreadsheet. I’m not familiar with Canadian taxes or deductions to be able to answer your question! Sorry.
      I do know that good record keeping is essential in every country! :)
      Carol Topp, CPA

      Reply

  4. Leah E. Good

    2 years ago

    Wow. What a great resource. Quick question. Putting a dollar amount into the “income” category flows into the “total expenses” category. Is that an error or am I missing something? Also, I see you have “office” and “postage” listed separately. Are they considered different categories on the tax form or do you combine them for that?

    Reply

    • Carol

      2 years ago

      Leah,
      Thank you for pointing out that error in the spreadsheet. I fixed it and have uploaded a corrected version.
      Postage (you paying to ship out books) could be included as part of Cost of Goods Sold on your tax return. I separated it from Office Expenses, just to have visibility into how much I was spending on postage.

      Reply
  5. Thanks so much for this info, Carol. So glad I found your site just before tax time!

    Reply
  6. […] separating everything out and keeping good records, starting now. Topp offers a free downloadable business income/expense spreadsheet you can use to keep track of your podcast finances. While Topp’s site is aimed at writers, […]

    Reply

Leave a Reply → Katharine Godbey