cancel
Showing results for 
Search instead for 
Did you mean: 
hercissp
Level 2

Unable to run 1099 reports for past years.

Every time I select older dates to run a 1099 report, this is the error I get and can go no further "Form 1099-MISC has been modified from January 1, 2020. Quickbooks supports a date range starting from January 1, 2020" I need to run 2019 1099 reports for insurance audits. How can I do this?

8 Comments 8
Rubielyn_J
QuickBooks Team

Unable to run 1099 reports for past years.

Let's find out why the 1099 report for previous years isn't showing, @hercissp.

 

Once you run the 1099 report, it helps identify the amounts paid and to which accounts it is categorized. Take note that reports will default to the Last Calendar Year. Thus, ensure to set up the report to the correct date range. You can see this next to Dates at the top of the report.

 

Here's how: 

  1. Go to the Reports menu, and then choose Vendors & Payables.
  2. Select 1099 Detail.
  3. Use the to identify the vendors and the 1099 Detail to identify the transactions. 
  4. Once you edit your accounts or payments, your previous reports will update and not reflect prior year filings.

You may also consider checking out this article for more details: Create and file 1099s with QuickBooks Desktop.

 

Please fill me in if you need more help. I'll get back to you as soon as I can. Have a nice day.

hercissp
Level 2

Unable to run 1099 reports for past years.

I am not able to run ANY 1099 reports on past years since the update which incorporated the 1099-MISC/1099-NEC. I need to run reports from 2019 and I get the error "Form 1099-MISC has been modified from January 1,2020. Quickbooks supports a date range starting from January 1, 2020."  This error occurs regardless of whether I select Detail or Summary. Before this update, I was able to run 1099 reports on previous years without issue.

MaryLurleenM
Moderator

Unable to run 1099 reports for past years.

QuickBooks updates the form 1099 MISC to 1099-NEC to be in line with rules and standards required by the IRS, hercissp.

 

Since QuickBooks is in the latest release, ensure that the 1099 accounts are map correctly. This way, you can designate the correct report to the boxes. For the complete steps, visit this article: How to modify your chart of accounts for your 1099-MISC and 1099-NEC filing

 

If you wish to use the old 1099-MISC form, I suggest consulting your accountant for advice on how to handle this.

 

You can also find a Pro Advisor by clicking on this link: Find an accountant.

 

 

Let me know if you have any additional questions about 1099s in QuickBooks.

Afsicruz
Level 1

Unable to run 1099 reports for past years.

Hi everybody- I'm having the same problem. I remapped the vendors already and am still unable to pull up the 1099 summary for 2019 which I also need for an insurance audit. Any other ideas?

MichelleBh
Moderator

Unable to run 1099 reports for past years.

Thanks for joining on this thread, @Afsicruz.

 

I'll share with you some workaround so you're able to examine the insurance in QuickBooks Desktop. 

 

You can pull up the 1099 Detailed Report instead of the 1099 Summaryso you don't need to map the accounts. From there, you can audit the insurance of your contractors because this report shows all the transactions. You can follow the steps provided by my colleague Rubielyn_J above. 

 

You can also customize it to show specific information. To know more about customizing, visit this article: Understand reports

 

Once done, take a look at the below articles for a guide to help you about handling 1099:

 

Please leave a comment if you have any other questions. As always, I'll be here should you need further assistance. Keep safe!

Afsicruz
Level 1

Unable to run 1099 reports for past years.

Thank you . I was able to pull the report in the 1099 detailed but not the summary. Which it will work for the audit but does that mean that the summary will never pull up the summary for dates prior to 2020?

MadelynC
Moderator

Unable to run 1099 reports for past years.

Thanks for getting back to the Community, @Afsicruz.


I know the importance of last year’s 1099 report for an insurance audit. As the result of the IRS updates made for the tax year 2020, the prior year 1099’s are no longer able to be generated in QuickBooks Desktop. By this, the Standard 1099 reports are affected by these changes as well.


Since you’re able to pull up the detailed 1099 report, you may consider it as the basis for your audit at this time. You can refer to this link to create and manage reports in QBDT. It contains subtopics that can help you customize and get more insight into your business performance.


Please know that Community is always here anytime. Just drop us a message, and we’ll ensure to take care of them for you. Keep safe always.

chaneymillerinc
Level 2

Unable to run 1099 reports for past years.

Big mistake on QB's part to not make any 1099 information prior to 2020 available through a report.
I don't know about anyone else, but when we are renewing our General Liability we are required to put down up to 3 years of past information in regards to sub-contractors payments..

Now I am not able to run a report for anything past 2020 and will have to pull the paper files for that information.
Bad bad programming design.
And this whole create a new account in your Chart of Accounts thing....What new account are we supposed to create? 
I already have a Sub-Contractor expense account.  Am I supposed to go in, create an entirely new one and then transfer every single payment for every single sub contractor over to the new account and then delete the old one? 
Talk about a bunch of work some some companies that have ALOT of sub contractors.

Or are we creating a 1099-NEC, 1099-MISC & 1099-INT account to track the information.
This portion of the supposed work around instructions is definitely not clear.

Step 3: Create a new account

Add a new account to your Chart of Accounts to track the separate payments.

  1. Go to Lists, then select Chart of Accounts.
  2. Select the Account dropdown, then choose New to create a new account.
  3. Select an account type of Expense, Other Expense or COGS, then select Continue.
  4. Enter the Account Name and details such as Description, Note and Tax-line Mapping.
  5. Select Save & Close.
  6. Repeat this process for each new account to be reported on the 1099-NEC or 1099-MISC.

Step 4: Move the payments to the new account.

You can choose to create a journal entry to move amounts to show in the newly created 1099-NEC or 1099-MISC accounts or you can edit existing payments to the new accounts.

Add a journal entry

  1. Go to Company and select Make General Journal Entries.
  2. Fill out the fields to create your journal entry. Make sure your debits equal your credits when you’re done.
  3. Select Save & Close or Save & New if you have more entries to make.
  4. Repeat this process for each payment you need to move.

Edit existing contractor payments

  1. Select Vendors then Vendor Center.
  2. Choose the vendor and locate the transactions you need to edit.
  3. Double-click to open the transaction to make your edits.
  4. After you have made the changes, select Save & Close.
  5. Repeat this process for each payment you need to change.

Need to get in touch?

Contact us