Tracking Your Author Expenses

It’s nearly here. That day we all dread … April 17, 2018. Tax day. [insert dramatic villain sound effect here.]

If you’ve managed to keep on top of things throughout the year, you’re in a great position! But for the rest of us … it’s not too late to start getting your crap together for next year.

taxesIt has taken me some time, but I have finally found my rhythm when it comes to logging my outbound expenses throughout the year to make my life significantly easier when it comes to preparing taxes, itemizations, and deductions.

To organize my ridiculously disorganized self, I created this handy dandy spreadsheet. And because I’m a firm believer in helping others, I’m sharing it here with all of you.

For those of you diving in, there are a few things to note:

  • This spreadsheet only tracks your spend / outbound expenses. Keep your income well tracked as well.
  • All numbers currently reflected are faux examples used to demonstrate how the spreadsheet rolls up to the Master Tab. But you can download the file and input YOUR information in there to help organize your expenses.
  • Do not manipulate numbers on the Master Tab. When you edit the numbers on tabs 1-12, they will automatically be reflected on the Master Tab in section sub-totals and the overarching deduction total.
  • Mileage tracked will reflect the 54.5-cent deduction publicized for your 2018 taxes.

If you like what you see on the Google Drive, select File > Download and then save it to your desktop or File > Save A Copy to your Google Drive.

Hopefully someone out there finds this helpful! Feel free to contact me if you have any questions about the spreadsheet.
Find this helpful? Check out the Authors Helping Authors series on the blog featuring articles like SEO, preparing for GDPR and even Book+Main

3 thoughts on “Tracking Your Author Expenses

  1. This might actually help me file earlier (and with more organization) next year. Thank you so much for sharing with us! ❤

  2. Pingback: Book Pricing Strategy: Royalty & Volume Calculators

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s