Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I am using Desktop 2019 Contractors.
I have been using the 1099 summary report for my subs reports for my insurance audits for 10 years or more....until today! My audit dates cross years (12/19 thru 12/20) and with the change in 2020 to the new 1099 NEC, the 1099 summary report will not let me customize the report dates to a date prior to 2020. I memorize the report for each audit and I tried pulling up an old memorized report to change the dates and it won't let me do it that way either. Does anyone have a work-around for the date issue on the 1099 summary report? I have other ways I can create a report with the info I need, but it is somewhat time consuming and the 1099 summary report would be the easiest if anyone can figure out a way around the 2019 date. TIA!
Nice to have you in the Community space, @Cupcake04.
I’m here to help you get back in running your business. To get around this issue, you’ll want to ensure to update your QuickBooks Desktop (QBDT) software and download the latest tax table. This way, your software is packed with the latest features and fixes.
If the issue persists after making these updates, I recommend running the Verify Rebuild tool. This tool scans your company file for errors and fix them right away. Let me show you how.
To Verify:
To Rebuild:
I've got you this article for more detailed steps: Verify and Rebuild Data in QuickBooks Desktop.
Once everything is all in place, you might want to utilize this link to learn some best practices in confidently managing your reports in QBDT: Understand reports.
Let me also add this article that you can use for reference in filing your 1099 seamlessly: Create and file 1099s with QuickBooks Desktop.
Keep me posted if you have any other concerns about reports or with your QuickBooks. I'll be around to help you. Have a great day!
Thanks for the reply, but I have done all that. Actually, I had to in order to process and print 1099's last week.
When you go to reports/vendor/1099 summary and the report comes up, the dates are pre-populated with last calendar year of 01/01/20 to 12/31/20. When I try to change to custom dates of 12/21/19 to 12/21/20, an error message pops up stating the 1099 forms were modified in 2020 and QB only supports date range starting from Jan 1, 2020, and then the dates default back to 01/01/20 to 12/31/20. This is for both the 1099 Misc & NEC.
In fact, I can no longer run any 1099 reports for any time periods prior to 1/1/20. I guess it's a good thing I printed hard copies of all my prior year reports since they are lost forever in QB! For my audit next week I worked around it by manually creating an excel report for any payment activity 12/21/19-12/31/19 and added those totals to my 1099 summary for 1/1/20-12/21/20. Not ideal, but it works for now and luckily was only 10 days I had to go through. What will suck going forward is not being able to compare prior years in QB, but having to dig out hard copies, and hoping they don't get destroyed or filed or lost.
Go to "Customize Report" and put in custom dates. That solved the problem for me for NEC settings and specific ins audit dates I was needing. Hope that helps.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here