Practice Management QuickBooks Small Business

1099s the Easy Way

Written by Doug Sleeter

Prepare, E-Deliver, and E-File All of Your 1099-MISC forms in 30 Minutes or Less

If you’re sick of the hassle and costs of preparing, printing, mailing, and filing 1099 forms consider Track1099. This is a Web application that integrates with accounting software (QuickBooks Online,, Intacct, and others) to automatically import all of your vendor details. Then, within the application, you can prepare, e-deliver, and e-file Form 1099-MISC.

For the latest updates on 1099’s and Track1099 (for tax year 2012) see our updated article: Prepare your Form 1099 Online and Paperless

One very important feature that differentiates this program from the Intuit 1099 E-File Service that is a part of QuickBooks is that this program doesn’t just E-File, it also E-Delivers. That is, in addition to filing the forms with the IRS, this service provides your recipients with a copy of the 1099 form so that you don’t have to mail them yourself.

At The Sleeter Group, we’ve used Track1099 for two years, and it works great! We prepared, e-delivered, AND E-FILED our 1099s in 20 minutes. And for our 10 vendors, we paid just $39.90.

Let’s look at some of the advantages of this service:

  • E-Filing and E-Delivery: Track1099 allows you to go paperless with the whole process of 1099 filings. You use it to prepare, E-file with the IRS, and e-deliver the forms to your vendors.
  • Integrated: Track1099 offers seamless integration with,,, QuickBooks Online, and CSV files. Although the QuickBooks and Peachtree integration is not quite as seamless, it is still less painful than printing on paper. To transfer QuickBooks Desktop and Peachtree vendor lists to Track 1099, you can sign up for a no obligation trial account with, or you can use an export/import process as described below.
  • Secure: Industry-standard 256 bit SSL encryption protects your sensitive data. Track1099 is totally PCI-compliant with credit cards.
  • Customer Support: Support is provided via live chat and e-mail.
  • Combined State/Federal Filings: Track1099 participates in the Combined State/Federal filing program. Each state has its own rules, so you’ll want to check those out and see what requirements they have.
  • Paper mailing of 1099s for delivery to vendors with missing email addresses. Additional fees apply for paper mailing.

Track1099 is available to business owners (for their own business) or for tax professionals who would like to manage multiple client accounts.

Here is how the program works

The first thing is to go to the track 1099 web site and create a login. Then, set up your company account, and start importing from either, Intacct, Realpage, or from a csv import (discussed later) of QuickBooks or Peachtree data.

After you complete the import of the vendors and payment totals, you can review each 1099 on the screen and make corrections as necessary. Note you can manually add vendors and payment totals too.

Track1099 Setup

When your data is ready to send to the recipients, go to the 1099 Summary section and select each vendor to be sent.

Select Vendor

After reviewing the 1099s, you’re ready to e-deliver and e-file. Go to the E-file 1099s section and decide when to send the 1099s to the vendors, and when to e-file them with the IRS. This is where you’ll enter your credit card information and pay for the service.

E-file 1099

That’s all you have to do! From this point you can check the status to see who you’ve sent forms to, who has received the forms, and when the forms are scheduled to be sent to the IRS.

1099 Status

What Your Vendors Receive

Your vendors will receive email notification that their 1099 is ready for viewing, printing, etc., via a secure login to the track 1099 site:

Vendor 1099 notification

The link takes them to a page where they can retrieve their 1099.

Track1099 landing page

Here’s a sample of what they would see once they connect:

Viewing the 1099

Note that your accounting software will be handling all of the issues of the new 2011 IRS rules on excluding payments made with credit cards (etc.), this service will take the final amount that your accounting software calculates.

Working with QuickBooks Desktop

To transfer QuickBooks Desktop data you can either work through (you can sign up for a free trial account), or you can use the CSV export/import process as described here:

  1. Run a 1099 Summary Report in QuickBooks and verify all of your vendor information, tax IDs, and payments for the year.
  2. Export this report to a CSV file (1099Pmts.csv).
  3. Create a customized/filtered Vendor Contact List report.
  4. To import this predefined QuickBooks report:
    1. In QuickBooks, display the Memorize Report List.
    2. From the Memorized Report dropdown, select Import Template.
    3. Browse to select 1099_Vendor_List.QBR
    4. After the report template imports, you can run it by double-clicking on the memorized report called 1099 Vendor List.
  5. If you don’t want to use our predefined report template, you can create your own report by following these steps:
    1. Create a Vendor Contact List.
    2. Filter the report to display only those vendors who are eligible for 1099s.
    3. Customize the columns to display:
      1. Contact, Tax ID, Bill from 1, Bill From City, Bill from State, Bill from Zip, Email
  6. Export the customized/filtered Vendor Contact List to CSV (VendorInfo.csv).
  7. Download and open the Track1099 Excel Import template and copy/paste data into the appropriate columns from the two reports (1099Pmts.csv and VendorInfo.csv) above.
  8. Save the populated Excel template as Track1099ImportFile.CSV.
  9. Go into Track1099 and go to the Import tab and follow the steps to Import from CSV.
  10. Once you’ve finished importing your vendors and payment amounts, you should review each of the 1099s before sending them. Make sure you verify that the “Second Name” field in Track1099 includes the “dba <companyname>” text, or the 1099 may be rejected by the IRS.

Save pagePDF pageEmail pagePrint page

About the author

Doug Sleeter

DougSleeter (@dougsleeter) is the founder and former CEO of The Sleeter Group, an international network of accounting software consultants, and the former producer of SleeterCon, an annual conference and tradeshow for accounting professionals.

In 2015, he sold The Sleeter Group to Diversified Communications ( and the company has since become The Accountex Network.

He is a passionate leader of innovation and change in the small business accounting technology world. As a CPA firm veteran and former Apple Computer Evangelist, he melded his two great passions (accounting and technology) to guide developers in the innovation of new products and to educate and lead accounting professionals who serve small businesses.

Always in search of the next big thing, he is currently focusing on digital currencies and blockchain technology. He believes these technologies will change virtually everything in global commerce.

The CPA Practice Advisor recognized Doug as one of the "Top 25 Thought Leaders" in the accounting profession and he has been named to Accounting Today's "Top 100 Most Influential People in Accounting" each year 2008 through 2015. In 2013, he was recognized by Small Business Trends with the Small Business Influence Champion award.

In the early 1990s, Doug was a pioneer in developing the first QuickBooks seminars in the country and has since built the largest group of accounting software consultants in the small business accounting profession. Doug serves on several advisory boards for technology companies and has consulted with numerous industry leaders including Intuit, Sage, Apple, and Adobe Systems. 

Doug is the author of numerous books and courseware materials including The QuickBooks Consultant’s Reference Guide, and QuickBooks Complete, a college textbook.
Doug attended both the University of California Santa Cruz and Santa Clara University and holds a Bachelor of Arts degree in Computer Information Systems. Doug and his family live in Pleasanton, CA. Doug's hobbies include woodworking, golf, and lifelong learning.


  • Charlie, when looking at the sign up page, it asks for a (optional) referral code. Is that something that pertains to how I was referred to the sight? Do you have a referral code that you would like me to use that would show you as the reference?

  • As a newbie learning to do bookkeeping for our business, I appreciated learning about Track1099. I used them this year and saved a lot–last year I used Intuit. This was simple.



  • Good information. Some of these web based solutions are so easy to use and also its very cost effective.

    Last year I ended up using for 1099-K, 1099-INT and 1099-Misc. It worked great and best part is same payer/payee data can be used for multiple filings. If you have a payer A and Payee B, you can reuse the data to file 1099-Misc, 1099-INT, 1099-MISC and file different forms.

  • Thank you for publishing information regarding 1099’s. This is usually a bookkeeper nightmare. I am a bit confused as to how to file the Massachusetts E-file portion. The TRACK 1099 gives you a dowload file suitable for submission, although I have not been able to figure out how to submit this download information. Your advise would be extremely helpful. Thank you in advance for any insight in this matter.

    Kind regards,


  • have been attempting for 2 days now to get my 1099 ‘s keep getting :

    “Thanks for using Track1099. We apologize, but our servers are very busy; please try again later today. You will be able to pick up your form.”

    I am happy I have tested your system prior to moving my company to you.

    This is not a good way to do biz. ll be posting this review on the web.

    Sam S

  • Sam,

    We’ve checked with Track1099 and they say the problem has been resolved. Perhaps it was a temporary system problem, similar to what happens on virtually all SaaS products. If you try again, it should work now.

Leave a Comment