Jan 31st is just around the corner. That means you only have a few days left to prepare and send your 1099’s. Last week we discussed 1099’s – what is a 1099, who gets a 1099, and when 1099’s are send/received. This week I want to walk you through how to prepare 1099’s using QuickBooks. Don’t forget your 1099’s must be mailed to your vendors no later than January 31, 2011.
The quickest and easiest way to prepare your 1099’s is by using QuickBooks’ 1099 and 1096 Wizard. The QuickBooks 1099 and 1096 Wizard provides you with 4 steps to easily verify your information, review your data, and double check that your numbers are correct before printing your 1099’s.
To access the QuickBooks 1099 and 1096 Wizard, click on the Vendors menu and choose the Print/E-file 1099s… option. The wizard will open and will suggest you take the following steps:
- Review Your 1099 Vendors – The Vendor 1099 Review report is helpful so you can verify that the vendors who should be receiving a 1099 are marked “yes” and to double check that the vendors marked “yes” have a Tax ID number and a complete mailing address.
- Map Your Accounts to Boxes on 1099 – This window allows you to select the account (general ledger account aka chart of accounts) you want to be reported on the 1099’s. You can assign multiple accounts to each 1099 box category, but you can not assign the same account to multiple 1099 categories. You will also want to verify the threshold (minimum) amount you must report to the IRS matches the current IRS rules.
- Review Your 1099 Data – The 1099 Summary Report opens, providing you with the opportunity to see each vendor that is eligible for a 1099 and the amount paid to that vendor. Please note the report is sorted by Box Number (which box the amount will be reported in on the 1099). You can double click any vendor to see the details behind the total amount showing on the report. If you notice a check or bill was originally posted to the wrong account (i.e. it’s not showing up on the 1099 or it’s being reporting in the wrong box), you are able to go back and change the account on the the check or bill. I recommend printing a copy of the report. It is a good tool to double-check all 1099 vendors are included.
Additional Steps to Ensure 1099 Reporting Accuracy –
- First, open Quickbooks’ 1099 Details report. To access the 1099 Details report, go to the Reports menu and select Vendors & Payables. Then click on the 1099 Detail option to open the report. Make sure the report dates are correct, choose the “All Vendors” option, and the “Only 1099 Accounts” option. Refresh your report. Look into any vendors that show up on your QuickBooks 1099 Details report that do not show up on your QuickBooks 1099 Summary report. If you find vendors who are supposed to receive a 1099 – open their vendor record and click the Form 1099 button on the Additional Information tab and verify you have their Tax ID Number and mailing address.
- Secondly, in the QuickBooks 1099 Details Report change the 1099 Options to: “Only 1099 Vendors” and “All Allowed Accounts.” This new version of the 1099 Details Report allows you to verify the amount you are reporting on the 1099. If you find any vendor payments that were accidentally posted to the wrong account, you can double click the listing to open the transaction to change the account. After making the change, refresh your report to make sure the amounts match.
Once the vendors and amounts have been verified for accuracy, you are ready to print your 1099’s.
- E-file and Print on Plain Paper OR Print on Preprinted Forms –
- QuickBooks 2011 is the first version that gives you the option to file your 1099’s electronically through QuickBooks. Click the Use Intuit 1099 E-File Service button to proceed to file your 1099’s electronically. Note: if you file your 1099’s electronically, you do not need to file a 1096. Another nice feature is that you are able to print your vendor’s copies on plain paper, so you do not have to worry about buying and printing on the preprinted forms.
- To print your 1099’s and 1096 on preprinted forms, click the Print 1099’s button. This will walk you through printing your 1099’s and 1096 on preprinted forms. Preprinted forms can be purchased at most major office supply stores (i.e. Office Max) or ordered for free from the IRS. Printed Form 1099’s and Form 1096 will be filed with the IRS by mail.
Keep in mind most 1099’s need to be mailed to your vendors by January 31st and then filed with the IRS by February 28th, 2011.
Instructions for Form 1099-MISC (2010).
Who Can Help You File 1099’s
If you get stuck or have questions, contact the IRS, your lawyer, or your CPA.
Michelle is the owner of Trailhead Accounting Solutions CPA, LLC, an Erie, CO based CPA firm focused on providing small and mid-sized businesses with day-to-day accounting, bookkeeping, and business solutions. Michelle is a CFO turned consultant who loves working with small businesses and entrepreneurs. When she’s not crunching numbers, she can be found hiking, remote camping, gardening, quilting, and hanging out with her family.