EXCEL FOR AUTHOR EXPENSE & INCOME


EXCEL FOR AUTHOR EXPENSE & INCOME

Natalie Bright

 

During the month of April, we are blogging about “Tips and Tools” for writers. This is such an important topic, we’ll be blogging about it again in November under “Writing Resources”. We’d love to hear your thoughts and suggestions too. Please leave your comments below.

GET ORGANIZED NOW

You may be a newbie writer drowning in the muddle of author platforms, social media, chapter hooks, and wide or not wide. It can be overwhelming. Regardless of where you are in your writing career, there’s no better time than 2020 to get your finances organized. From online spreadsheet templates to high dollar accounting software, there are many options available. As a newbie writer, I began with several books on KDP and tracked my business with a simple Excel Spreadsheet.

First, I recommend that you:

  1. Open a separate author checking account.
  2. Only use your author debit card or a designated credit card for expenses related to your writing business.

Don’t be tempted to charge anything on your author card that cannot be expensed. When you set up payments for book sales from KDP, Ingram, etc., and Square (if you plan to have booths at book fairs and take credit cards), have all of the royalties and payments come directly to your author checking account. All of your income will be posted right there on your bank statement, which you can easily make copies for your CPA or transfer to an income spreadsheet.

EXPENSES

Second, set up a spreadsheet for expenses, a check register, where you will record checks you have written, cash disbursements and credit card charges all relating to your author business.  Across the top list the Categories, for example:

     
Date Ck # Off Sup  Workshop

Seminar Fees

 Travel Exp Research Reference Professional Fees/Dues Mrktng

 

Those sticky notes, writing pens, spirals, and copy paper are office supplies. Don’t forget about the printer ink cartridges. That trip you took to the beach to get a feel for the setting of your next series can be counted as author expense under research and travel. You can set up sub-categories by working titles or series title. That little ad you placed in your local newspaper announcing your newest release is marketing expense, and maybe you bought the newspaper editor’s lunch. Log that under public relations. There are many different ways to set up your expense categories. Check with your CPA to make sure you have the right categories for your particular situation.

In the meantime, stay safe and happy writing!

 

Hello April


POSTCARDS FROM THE MUSE

Hello April

Nandy Ekle

This month, the month of April is dedicated to tips and tools. So I will try to blog about things that I think of as a good tip, or something I use as a tool.

The only tips I have, besides SYBICAW (Sit Your Backside In Chair And Write) are tips I’ve picked up from other writers. And since my very favorite writer is Stephen King, I’ll use a lot of his tips. As for tools, I’m a pantser, so I’ll do my best.

As far as a tip for today’s blog, Writers write. So there you go. If you write, you’re a writer. If you just want to write but haven’t written anything, you need to re-analyze whether or not you are a writer.

Today’s tool. One of my favorite things is music. Sometimes lyrics grab me and scream that there is definitely a story buried here. Sometimes a piece that’s completely instrumental (Electric Light Orchestra’s instrumental Fire On High) tells a story just from the sounds I hear. I get a lot of story ideas from my playlist. And in those moments of needing extra inspiration, I will close my eyes and play the piece over and over.

 

Writing Quote – E. L. Doctorow


 

“Writing is an exploration. You start from nothing and learn as you go.”

                                                        – E. L. Doctorow

More Writing Quotes


More Writing Quotes

by Adam Huddleston

 

“Writing is easy.  All you have to do is cross out the wrong words.”

– Mark Twain

 

“The scariest moment is always just before you start.”

– Stephen King

 

“There is no real ending. It’s just the place where you stop the story.”

– Frank Herbert

 

“Not that the story need be long, but it will take a long while to make it short.”

– Henry David Thoreau

 

“No one can write decently who is distrustful of the reader’s intelligence or whose attitude is patronizing.”

– E.B.White