Home Writing Business: Build the Spreadsheets Needed for Taxes

Since I started my writing business seven years ago, I've tracked data that my husband and I need to file our year-end and quarterly taxes. Before you start your writing business, you should apply for a business license with your state authority. A business license is essential for paying
 your sales taxes and for receiving discounts on your business related expenses. In addition, if you move around the state making sales, you may owe sales taxes to the city or county in which you made the sale, and / or to your city of residence.

I use a spreadsheet created in MS Excel to manage most of the data. The reason for this is spreadsheets have the ability to add functions to the columns that will add up the data and I don't have to do it. They are also convenient to enter data. You type the data for a column and hit tab to go to the next column. These spreadsheets are stored in a folder created just for that year. Every year, I copy the previous year's folder and contents and delete out the old data.

I save all my receipts in a folder in my file cabinet titled taxes. I pay for as many of my expenses with a credit card because I then have a direct trace from the bill to an expense item entry in my table. I also put any payment notices made to PayPal in the same folder.

Tracking Your Mileage

Your mileage to and from business related events is deductible on Schedule C of your taxes. Only count trips where you drove. Only count the portion of your trip that was required to get you to your business-related event. Examples of writing events include: classes, critique sessions, brainstorming sessions, conferences, readings or presentations.

The information I track is what we used to put in a form at the Boeing Company and Port of Seattle and includes:

Purpose of Event

Date

Number of Miles

Whether the Number of Miles was for a One or Two Way Trip

At the bottom of the spreadsheet, in the number of miles column, I put in a summation function, in MS Excel Edit> Insert> Function> Sum

Related information
 
Comments 1 - 10 of 11 Next >>
Comments
Type in Your Comments Below

Nice explanation :D

Posted on 08/06/2008 at 6:08:41 PM

Good info!

Posted on 02/26/2008 at 9:02:42 PM

may i know what are the 8 c's of business writing?

Posted on 11/28/2007 at 7:11:00 PM

I have to keep a spreadsheet for my business, just for tax purposes. I used to like doing speadsheets until I had to do them for my own business, now I feel I have to spend all this time recording stuff when I could be listing inventory. You have some great tips here. Thanks

Posted on 09/20/2007 at 9:09:00 PM

Good info. I use an access database we created to plug stuff in and to pull stuff straight from my paypal reports, but excel works just as well. I wonder though - in Texas, where I live, services like writing are not sale taxable. Are they were you live?

Posted on 09/20/2007 at 4:09:00 AM

great info!

Posted on 09/19/2007 at 12:09:00 PM

Excellent suggestions. Thanks for sharing.

Posted on 09/06/2007 at 8:09:00 AM

My husband does a lot of traveling with his job thanks for the information.

Posted on 09/06/2007 at 7:09:00 AM

Very useful info.

Posted on 09/05/2007 at 5:09:00 PM

Great information.

Posted on 09/02/2007 at 9:09:00 AM

Comments 1 - 10 of 11 Next >>