Follow These Record-Keeping Tips to Maintain Your Sanity at Tax Time
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!
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!
Recommended Spreadsheets to Track Business Activity
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
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:
- Earnings 2015
- Expenses 2015
- Mileage 2015
- 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.")
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.
- 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.
- 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:
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.
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.
- Gas – to cool and heat your home/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.
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:
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
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.
- 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?
Is filing your taxes stressful?
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.
Questions & Answers
© 2016 Shauna L Bowling