Skip to main content

Record-Keeping Tips for Tax Season

Shauna has been in the accounting industry for over 30 years. Her expertise has brought her repeat freelance clients come year end.

These tips will help you get through tax season without the usual pain.

These tips will help you get through tax season without the usual pain.

The end of the year is busy and oftentimes stressful. After all, we have two holidays back to back that require time, money, and preparation. On top of that, by December 31st, it’s out with the old and in with the new. Oh, I’m not talking about cleaning out your closets or the shed. No, I’m talking about financial records, files, receipts, and getting your ducks in a row to present to Uncle Sam.

Daunting, isn’t it?

Well, it doesn’t have to be. Follow these tips and year-end clean up is a breeze. So is gathering your records in preparation for filing your annual tax return.

These tips are meant to make life easier for those of us who work from home as entrepreneurs or solopreneurs. Lord knows we’re busy enough as it is, so why not organize your records? It’ll save time and tons of stress. Trust me!

Keep current-year files close at hand

Keep current-year files close at hand

Organize Your Physical Files

Many of us still prefer to receive our bills in the mail and pay by check. Dedicate a drawer in your desk or a portable file system to house current year receipts. Make a folder for each creditor and label it with the current year on the tab. It’s also a good idea to have a folder for medical expenses, as you’ll be asked for this information on your tax return.

Also, make a current year folder for your business expenses, if applicable. Drop all your receipts in the folder after recording the expense. If your receipts match up to a bank or credit card statement, make a copy to drop in your business folder. (More on recording business related expenses later in this post).

If you have a filing system for papers such as marriage certificates, insurance policies, warranties, vehicle titles, tax returns, etc., (and you should!) year end is the time to clean it out. Go through each folder and trash anything that has expired or no longer applies to your household.

You’ll want to keep bank statements, paid bills and the like for three years. Store them in the cabinet with the files you’re keeping for long term. The IRS only has three years to audit a return, so anything older than that, you can send to file thirteen, including all backup.

Shred all discardable documents and add them to your compost pile or use them as kindling for the fireplace.

Now that you’ve gotten your physical files organized, it’s time to set up a record keeping system that you will maintain on a regular basis. This is where maintaining your sanity comes into play.

Spreadsheets Are Your Friends

Now, don’t go getting all bonkers on me. Even if I didn’t have an accounting background, I’d still use them. They are the easiest way to maintain records and have the information available to you at a glance. Learning to insert formulas in Excel is not hard. And not having to run a tape (on the calculator) come tax time is a huge time saver.

For those of you unfamiliar with Excel, here’s a basic tutorial that walks you through how to set up a spreadsheet and format formulas:

How to Copy and Paste in Excel

Always remember to clear all data, with the exception of the formulas. That way the calculations will perform automatically as you add new data.

As you see by the photo below, I’ve cleared all data but the formulas are still there waiting to go to work for me!

I have several spreadsheets I maintained for my business and still maintain for my personal tax return. Below is what I recommend to make your job easy come tax time. This type of record keeping also serves you well any time you need to provide financial information to an entity that requests it. At the push of a button you can attach these spreadsheets or convert them to PDFs and email them to the requesting entities

Track your earnings by customer

Track your earnings by customer

Scroll to Continue

Freelance Earnings

Open a new workbook and name it Freelance Earnings or whatever floats your boat. Just make sure it’s something you’ll remember when you need to look for it.

Add your name, business name, name of the workbook, and the year it pertains to. (See photo).

In my Freelance Earnings workbook, I’ve added worksheets that pertain to my business. They are as follows:

  1. Earnings 2015
  2. Expenses 2015
  3. Mileage 2015
  4. Overhead Expenses 2015

Note: I closed my freelance business in 2015, but the information I provide in this article is evergreen.

Under the Earnings tab, I’ve named the columns thusly:

  • Column A—Project Name
  • Column B—Date invoiced
  • Column C—Invoice number
  • Columns D thru M—each are assigned to an income source (client)
  • Column N—Subtotal (the total of all numbers in the row)
  • Column O—Total (this is actually redundant)
  • Column P—Date paid
  • Column Q—Less fees (sometimes PayPal assesses fees for non-verified payers)
  • Column R—Amount Paid (the net paid to me)
  • Column S—Balance (unpaid balance)
  • Column T—Monthly total (this requires a separate formula that varies depending upon how many rows of entries I have in a month)

At the bottom of the spreadsheet I have formulas for each column. This lets me know at a glance how much I’ve made from each client. This comes in handy when you’re re-assessing your client base. It’s also helpful at year-end; you know from which clients to expect a 1099 (anything over $600).

Then there’s a formula running across to give me a grand total. It should agree with the totals in columns Q, R, S, and T. This is called a ‘proof’. If the totals don’t cross-check you’ve got an error somewhere.

At this point I’d like to interject. If any of my readers feel overwhelmed with setting up spreadsheets, I’ll be more than happy to do it for you. Then all you’ll have to do is drop in the information as it occurs. Shoot me an email via the Bravewarrior profile page (look under "fan mail.")

Track your business expenses

Track your business expenses


Next, we’ll move to the Expenses worksheet. This is where you’ll track all your business related expenses. I’ve set this one up a little differently. The first three columns are Date, Payee, and Total, respectively. The fourth column is left blank in order to see the total without having to go to the last column. You’ll see why I’ve set it up this way when you see the columns I’ve named. Remember to include all tax deductible operating expenses, otherwise known as cost of doing business (outside of overhead–we’ll address that later).

Here’s What You Should Include in Your Spreadsheet

  • Office supplies—paper, ink, toner, pens, pencils, etc.
  • Software
  • Hardware—CRTs, monitors, laptops, speakers, printers, etc.
  • Training—any seminars you attend or online training for which you pay a fee
  • Repairs & Maintenance (R & M) Equipment—computer repairs, etc.
  • Advertising/Marketing—this does not include mileage but actual costs for getting your name out there. This could be stickers for your vehicle, business cards, printing charges, etc.
  • Licenses/Taxes—your occupational license and fees for the registration of your business name qualify here. I also list my annual domain name and website fees in this column.
  • Insurance—if you have separate insurance for your business only, such as Professional Liability
  • Contest Fees
  • Fees (other)—this would be bank charges, PayPal charges and any other fees you absorb in order to be paid.
  • Postage
  • Entertainment—if you take a client to lunch or dinner, be sure to write the name of the client and what was discussed on the receipt, otherwise you can’t write it off.
  • Travel—again, this does not include mileage; that’s a separate calculation. This would include airfare, hotel stays, car rentals, etc. provided they are business related.

You’ll want to have total running down each column (vertical) that will ‘proof’ to the row (horizontal) totals.

The Mileage tab is pretty straight forward. Basically, it looks like this:

Log your mileage

Log your mileage

When you drive to a networking event, the post office, the office supply store, to meet with a client, or entertain a client locally, your mileage is deductible. The IRS posts a different rate each year. Your tax software or accountant will make the proper calculation once you provide the total mileage. Parking fees and tolls are also deductible, so be sure to keep the receipts and log them. I usually keep a separate column in the mileage spreadsheet to track parking and tolls (see Medical Expenses sheet later in this post for an example).

Note: If you use a vehicle for work purposes only, you can choose to include gas and oil, repairs and maintenance on the vehicle in the operating expenses area. However, you cannot write off mileage if this is the way you go. Also, you should amortize the vehicle (depending on its age) if it is, indeed a company vehicle.

Overhead Expenses

Moving on to Overhead Expenses:

If you work from home and have a dedicated office (I converted my third bedroom into an office), you can deduct a portion of your overhead. The calculations are based on the square footage of your office divided by the total square footage of your home. Your tax software will do the math based on the square footage you provide.

These Are the Items You Should Record on a Monthly Basis

  • Mortgage payment—if your taxes and insurance are included in the payment, you’ll have to break the principle out when you file your taxes. Simply deduct your insurance and property tax numbers from the total payment for the year to come up with the correct breakdown.
  • Electric
  • Gas—to cool and heat your home/water
  • Water
  • Home Repairs—this only applies to repairs that affect the entire house, such as re-plumbing the structure, re-wiring, etc.
  • Cell phone—if you use it for business.
  • Phone—if you have a dedicated phone line, include this in the expenses worksheet, rather than here.
  • Internet—this especially applies to writers. Any self-employed professional who relies on the Internet to conduct business should include this cost.
Track your overhead expenses

Track your overhead expenses

Simple Spreadsheets for All Taxpayers

For all taxpayers who itemize deductions, it’s a good idea to maintain spreadsheets for your Medical/Dental expenses, and Charitable Contributions. Track your mileage for both categories as well, as it counts towards your out-of-pocket expenses and is deductible.

Your Medical/Dental spreadsheet is a very simple layout, as you’ll see below:

Track your medical expenses, including mileage

Track your medical expenses, including mileage

Your premiums are deductible, as are prescriptions, doctor visits, hospital stays, lab work, out-patient treatments, etc. If your physician has prescribed a weight loss plan or gym membership to treat a specific disease, including obesity, those are deductible as well. Note the key word here is prescribed. Your doctor mentioning you should lose weight does not qualify you to take this deduction.

For more on what qualifies as allowable medical and dental deductions, read this IRS document

Charitable Contributions

When setting up your Charitable Contributions spreadsheet, the following information should be included:

  • Date of contribution
  • Name and address of charity (make sure it’s recognized by the IRS)
  • Description of donation—check, cash, household goods, clothing, etc.
  • Value
  • Totals—total each row then create a cross-check total of each column across the bottom row. I think you’ve seen enough spreadsheets now to know what it should look like.

Be sure to track your mileage, especially if your donation is that of your time in a volunteering capacity.

It’s wise to maintain these spreadsheets even if you don’t think you have enough deductions to itemize. Your tax software or accountant will determine whether you should itemize or take the standard deduction.

Being prepared is a good practice to follow.

How do you deal with tax season?


You can make your life a whole lot less stressful by maintaining spreadsheets to track your income and expenses as each event occurs, rather than scrambling at the last minute.

Year-end is a breeze. Filing your taxes is a drop in the bucket.

Keep your sanity in check and your business records organized by following the tips I’ve provided in this post.

How do you account for your business activity? Let me know in the comments below. Also, if you found this post helpful, please share it by pressing any of the social media buttons to the left.

Have a successful and stress-free year!



Parody on "Money for Nothing":

This article is accurate and true to the best of the author’s knowledge. Content is for informational or entertainment purposes only and does not substitute for personal counsel or professional advice in business, financial, legal, or technical matters.

© 2016 Shauna L Bowling


Shauna L Bowling (author) from Central Florida on December 31, 2019:

Nell, I'd rather do my own than pay someone to do it. It's pretty easy with tax software. I use H & R Block software. It's easy peasy since I have my spreadsheets updated and ready to go by the end of the year.

Happy New Year, my friend!

Nell Rose from England on December 30, 2019:

Luckily I don't need to do my own taxes, but if I did I would probably go nuts, lol! I am useless at stuff like that purely because I do not have the patience.

Shauna L Bowling (author) from Central Florida on May 17, 2019:

Then neither one of us will grow up because neither one of will grow up. LOL How's that for Sha Logic?

Suzie from Carson City on May 17, 2019:

Of COURSE it makes sense! "Making sense".....great concept! So you're organized AND sensible! You're my idol, Sha....& when I grow up, I want to be just like you!! LOL

Shauna L Bowling (author) from Central Florida on May 16, 2019:

Paula, I'm afraid I'm guilty as charged. I'm extremely organized. But in so doing, it allows me time to be lazy. Does that make sense?

I love you, too, even if I do piss you off! :-)

Suzie from Carson City on May 15, 2019:

Sha,,I am convinced, you are the most organized woman I know. And if I didn't love you, it would Pi$$ me off!! LOL

Shauna L Bowling (author) from Central Florida on May 15, 2019:

You're welcome, Aurelio. I record transactions into my spreadsheets as they occur. That way they're always up to date and all I have to do at year-end is print them. Easy peasy!

Aurelio Locsin from Orange County, CA on May 14, 2019:

It's never too early to start organizing for next year's taxes. Thanks for these tips.

Shauna L Bowling (author) from Central Florida on April 09, 2019:

Glad to hear it, Dianna. That was my intent. Filing is so much easier if you organize your files and update them as you go.

Dianna Mendez on April 08, 2019:

This is handy information this time of year. As I review your suggestions I see a few that will make my task easier for next year's filing.

Shauna L Bowling (author) from Central Florida on July 26, 2018:

I hope this helps you, Shyron. Being organized and staying on top of things is key to not stressing over finances.

Thanks for the return visit. I hope things become a little (lot) less complicated for you!

Shyron E Shenko from Texas on July 26, 2018:

Shauna, I came back to re-read this because things are complicated now and I need to refresh my memory of the golden hub.


Suzie from Carson City on July 09, 2018:

Good for you!! Nothing like seeing family and taking much-needed time for yourself. We finally have official "summer" weather. Thought it would never arrive. One more week of 80 - 90 degrees...UGH! and I'll be hoping for Fall! LOL. Old-ornery-can't-be-pleased-Bit_h-that-I-am !!!! LOL

Shauna L Bowling (author) from Central Florida on July 09, 2018:

Nice to see you here, Paula. Actually, I was on vacation the week of the 4th. Went to South Florida to visit with my parents, brother, sister and niece. I was gone for four days and didn't go online at all. Not even over the weekend after I got home! It was a great visit. I really needed to get away.

Love you too, my friend!

Suzie from Carson City on July 07, 2018:

LOL!! Thanks for this, girlfriend!!

Now........HOW do I maintain my sanity for the rest of the year??

LOL......Just happen to be in the neighborhood & stopped by to say, "Hey, how's it going? Hope you're well, happy & feelin loved." Enjoy your week-end, girlfriend! Love ya, P

Shauna L Bowling (author) from Central Florida on June 29, 2018:

I'm glad you found the examples useful, Peg. I tried to be as explicit as possible, yet keep it simple at the same time. I love Excel, too. I work with it all day long. Once you've created the formulas, it makes number crunching a breeze!

Peg Cole from North Dallas, Texas on June 29, 2018:

Your examples of financial spreadsheets are detailed and useful and the filing advice is key to being prepared when tax time comes. I love the ease of Excel and the automatic calculations are a real time saver. Thanks for sharing these tips from your extensive expertise!

Shauna L Bowling (author) from Central Florida on January 26, 2018:

Glad you found this helpful, Louise. Thanks for the visit!

Louise Powles from Norfolk, England on January 26, 2018:

There's some really good advice here, thankyou.

Shauna L Bowling (author) from Central Florida on July 04, 2017:

Shyron, spreadsheets really do simplify life, don't they? I'm glad I was able to share my knowledge with you.

Peace, my friend.

Shyron E Shenko from Texas on July 03, 2017:

Shauna, thank you for all the great tips. I do a lot of stuff with spread sheets, but you have given me fresh new tips and I really appreciate it.

Blessings my dear friend.

Shauna L Bowling (author) from Central Florida on June 08, 2017:

Peg, it sounds like you're as anal about being organized as I am. And that's a good thing!

I'm glad you found my instructions easy to follow. I hope those who are not as familiar with spreadsheets and you and I, do as well.

Peg Cole from North Dallas, Texas on June 08, 2017:

Hi Shauna, What great ideas for staying organized. I've owned a couple of businesses and found that Excel spreadsheets really do help keep track of expenses and income. At my collectibles store, I created a daily recap form and would use that to balance the register at the end of the day and from there, enter the data into my monthly records. Your explanation was really detailed and easy to follow.

Shauna L Bowling (author) from Central Florida on February 18, 2017:

You're welcome, Chris. I've been using their software for years and highly recommend it.

Chris Mills from Traverse City, MI on February 18, 2017:

Shauna, thanks for the information about H R Block. I'll keep that in mind for next year.

Shauna L Bowling (author) from Central Florida on February 18, 2017:

Chris, earning income from multiple states could certainly be tricky. Fortunately, Florida doesn't have a state income tax, but many others do and at various rates. Personally, I use H & R Block tax software. It makes it much easier to go through each module by having spreadsheets to refer to for each type of allowable deduction. I did my taxes on February 4th and had my refund in my bank account on the 13th. No muss, no fuss and no stress!

Chris Mills from Traverse City, MI on February 18, 2017:

Shauna, I could fill this comment box with hahahahahahahahas at the question, "How do you account for your business activity?" I live and work on the road, so nearly all my financial information is online. There are only a few things that come by mail. My accounting method nonexistent. To top it off, I usually have multiple states to file for. CPAs don't usually have a good grasp of tax information for traveling workers, so I've been using TurboTax. I do need to at the very least start some files. Thanks for the excellent information and suggestions.

Shauna L Bowling (author) from Central Florida on January 21, 2017:

Shyron, sorry to hear you and hubby have been swapping the bug back and forth. I hope this is a better year for you.

Thanks for clearing up the second F for me. I figured that out through a forum about Flipboard. Frankly, I'd never heard of it. Guess I'm falling behind the times!

Shyron E Shenko from Texas on January 20, 2017:

Shauna, this is so fantastic, I love spread sheets too and do use them to do taxes and usually have everything ready to roll by this time, but not this year, I have not felt like doing anything this year, I have had the flu a couple of times hubby and I keep sharing it.

I was unable to look at the video, it did not work for me, having problems with my computer.

Blessings and hugs dear friend.

P.S. the second "F" is for flipboard.

Shauna L Bowling (author) from Central Florida on January 17, 2017:

I'm glad you found this helpful, Gina. With all your business ventures, I'm sure you'll put the information to good use.

Gina Welds from Tampa, Florida on January 16, 2017:

Great timely tips! I needed to see this.

Shauna L Bowling (author) from Central Florida on December 23, 2016:

Dianna, that's smart bookkeeping on your part. It's so much easier to log events/expenditures as they happen. It's a real time-saver in the long run. Besides, it only takes a few seconds and there's no scrambling or searching for receipts come tax time.

teaches12345 on December 23, 2016:

Wonderful suggestions for all tax payers. I find keeping a detailed log is best for me as I tend to forget over time what has transpired during the year (even the week!).

Shauna L Bowling (author) from Central Florida on December 20, 2016:

You're welcome Dora. I thought now would be a good time to post rather than closer to tax time. This way, readers who aren't keeping ongoing records can start the new year off on the right foot.

Dora Weithers from The Caribbean on December 19, 2016:

Shauna, thanks for your very practical suggestions on organizing and recording to manage taxes more easily. Good time to start!

Shauna L Bowling (author) from Central Florida on December 15, 2016:

Keeping records as you go makes tax time a breeze, Nell.

Nell Rose on December 14, 2016:

Great advice Shauna! and something we all go eek at when the time comes to do our taxes! lol!

Shauna L Bowling (author) from Central Florida on December 13, 2016:

Mar, I'm sure your accountant loves you for being organized. It makes his job so much easier!

Maria Jordan from Jeffersonville PA on December 12, 2016:

Helpful, practical and timely tips, dear Sha.

I enjoy being organized and I know our accountant enjoys it as well. I have Mom to thank for my good habits.

Have a peaceful night - great seeing you publishing again. Love, mar

Shauna L Bowling (author) from Central Florida on December 12, 2016:

Ruby, I didn't even notice that we no longer have a Twitter button. I wonder why? And what is the second F? That's a new one on me!

I'm glad you find this article informative with easy-to-follow instructions. It's so much easier to log transactions as they happen rather than wait until tax time. No wonder people get stressed out!

Shauna L Bowling (author) from Central Florida on December 12, 2016:

Thank you, Larry. And thanks for the visit!

Shauna L Bowling (author) from Central Florida on December 12, 2016:

Merry Christmas to you too, Martie!What is Pastel? Is that an accounting software?

Even at work we use Excel in addition to several other construction software programs.

The fiscal year, as far as taxes go is January 1st thru December 31st. However, I know of many companies that run their year from July 1st thru June 30th. Not sure why that is. It would be easier to keep with the calendar year, in my opinion.

Ruby Jean Richert from Southern Illinois on December 11, 2016:

I usually share an article on Twitter that I deem useful and important to friends or anyone, but twitter is no longer listed. I miss it. This article is really good and presented with easy instructions. Tax time can be stressful if one hasn't kept records. Excellent!

Larry Rankin from Oklahoma on December 11, 2016:

Great tips!

Martie Coetser from South Africa on December 11, 2016:

Best tips! Although I use Pastel for formal bookkeeping, I do a lot - more than a lot - on/in/with Excel. I absolutely love this program!

Our financial year is from March 1st to February 28th. I am surprise to know that yours are from Jan 1st to Dec 31st.

Merry Christmas to you and yours, dear Sha!

Shauna L Bowling (author) from Central Florida on December 11, 2016:

I agree with you Bill. It's especially important to take those deductions if you don't pay quarterly income tax, as recommended. The more you can deduct, the less you'll have to pay.

Off to the grocery store to get the ingredients I need for Christmas cookies. I'd better get baking... it'll be here before I know it!

Shauna L Bowling (author) from Central Florida on December 11, 2016:

Genna, I keep all my receipts by vendor and year and toss them after three years. However, I keep all home repair receipts indefinitely. You never know when you need to call on a repair service you're pleased with. Going to the Home Repairs folder is much easier than trying to remember what year the repair was done, then locating the information.

It sounds like you're very organized. Kudos to you!

Bill Holland from Olympia, WA on December 11, 2016:

All great tips, Sha! Thanks for the refresher course. You know, I still hear from quite a few writers who do not take deductions for writing....not sure why that is, but in my opinion, if the deductions are there then they are worth taking. Anyway, have a great Sunday!

Genna East from Massachusetts, USA on December 11, 2016:

Hi Shauna. As an entrepreneur, I know exactly what you mean. Receipts are the bane of my existence. I dislike paperwork and love technology as it saves us from having to file hard-copies. I usually keep my receipts (the IRS wants to see these during an audit) -- barring an e-copy acknowledgement of the order/purchase -- in a box, by year. Those records I can toss after several years. Payroll records we keep forever. Hugs for the Excel/spreadsheets reports tips -- that is very good advice. We use these as well as QuickBooks SW to track everything. Organization/documentation is the key to everything. Excellent hub.

Shauna L Bowling (author) from Central Florida on December 11, 2016:

Flourish, I'm all about organization when it comes to taxes. It makes life so much easier and less stressful.

I am doing well. Thank you for asking.

FlourishAnyway from USA on December 10, 2016:

Great useful tips and I like that you are writing here again. Would be really useful in the situation of being audited to have all your stuff organized so well. Hope you are well.

Related Articles