Fix Missing Contractors or Wrong Amounts in QuickBooks For 1099s

When you create your 1099s in case one of the contractors you set up in QuickBooks is missing or not […]

Voiced by Amazon Polly

When you create your 1099s in case one of the contractors you set up in QuickBooks is missing or not showing correctly. With the help of this blog, find out what to do when you prepare your 1099s in QuickBooks Online or QuickBooks Desktop if you need help adding a contractor or changing an amount.

Solutions for All your Tax Issues

With a combined experience of more than 10 years, our tax professionals can help you with tax preparation, tax filing, disclosure & compliance, transactional tax issues, and audit representation.

Below are the mentioned steps and reports to get everything back to track?

Step 1: Verify that Your Contractor is Active and Configured for 1099 Tracking

When you start to prepare your 1099s, if a 1099 contractor isn’t on the list, it may be because they aren’t active or marked as eligible for 1099. Here are the places to look up that information and the 1099 reports you can create.

QuickBooks Online and QuickBooks Contractor Payments

If you are in the middle of creating 1099s, click the Add from Vendor list button on the Review Your Contractor’s Info window and select the Add from Vendor list button choose the appropriate vendor. Create this 1099 report if you are not producing 1099s to find out which vendors have chosen to monitor 1099s. Afterward, you can change their status:

  • Begin by choosing Reports.
  • Then you have to open the report by searching for Vendor Contact List.
  • After that, you have to select Customize option.
  • Select Change columns under Rows/Columns.
  • Check the box next to Track 1099.
  • Select Deleted and set the All dropdown▼ in the Filters section.
  • Now, you have to choose Run Report.
  • To sort your contractors, click Sort, then click Sort by Track 1099.
  • If a vendor is absent, you have the option of changing their status or moving on to the next step.
    • Choose the name of the person.
    • Then you have to choose to Make Active
  • If the Track 1099 section reads No.
    • The person’s name.
    • Choosing Vendor Details
    • Then selecting Edit
    • Check the box next to Track payments for 1099, then click Save.

Change the 1099 status of the vendor you already know to update:

  • Select Vendors under Get paid & pay in the menu.
  • Choose Edit after choosing the contractor you want to convert.
  • Check the box next to Track payments for 1099, then click Save.

They might not be active if they are not listed in the Vendor list.

  • Choose Settings from the menu above the Action column.
  • Then you have to select the Include inactive checkbox.
  • Next to the missing vendor, Select Make active.

QuickBooks Contractor Payments without QuickBooks Online

For 1099s, all suppliers that have been added to QuickBooks Contractor Payments are automatically eligible. A contractor may not be working if they go missing.

  • Select Contractors by going to Contractors.
  • Choose Inactive from the Active ▼ dropdown menu.
  • Then find and choose the missing contractor.
  • You have to select Mark as active from the Inactive▼ dropdown menu.

QuickBooks Desktop

  • Begin by going to Reports and then you have to choose Vendors and Payables.
  • Then you have to select 1099 Summary.
  • Select all vendors in the 1099 options dropdown menu.
  • Make the missing vendor a 1099 vendor if you find them.
    • Select Vendor Center from the Vendors menu.
    • Click the vendor’s name twice.
    • Choosing the Tax Settings tab.
    • To check the box that says Vendor eligible for 1099, click it.
    • Enter the Vendor’s tax ID in the field.
    • Remove the checkbox if it appears next to Vendor is Inactive.
    • Lastly, You have to select OK.
  • After finishing, repeat steps 1 and 2 again. Select 1099 Vendors from the drop-down menu for the 1099 options.

Step 2: Assure Your Payments to this Contractor Meet the threshold

1099 is only sent to contractors who were paid more than the annual $600 cash threshold. By using these steps and 1099 reports, you can identify which contractors failed to meet the requirement. The use of credit cards is not included. These payments won’t be included in the company’s 1099 values and will instead be reported by the financial institution.

QuickBooks Online and QuickBooks Contractor Payments

  • To get started follow the steps for your product.
    • Contractor Payments with QuickBooks Online: First you have to go to Payroll, and then you have to select Contractors or Get paid and pay, and then you have to choose Vendors.
    • QuickBooks Contractor Payments only: You have to go to 1099 filings.
  • Until you get to the window known as Check that the payments add up, you have to select Prepare 1099s and then choose Continue.
  • At the top of the table, you have to select the arrow that is next to the filter icon, and then you have to change the type of contractors to 1099 Contractors below the threshold.

QuickBooks Desktop

  • Begin by going to Reports, and then you have to choose Vendors and Payables.
  • Then you have to select 1099 Summary.
  • Select Ignore thresholds from the 1099 Options dropdown menu.
  • They have not met the threshold in case you see the Vendor.
  • You have to change the thresholds or need to enter more transactions if this is a 1099 Vendor using 1099 Accounts.
    • Select Preferences by going to the Edit option.
    • Then you have to go to the Preferences window and from the left pane, you have to select Tax:1099.
    • The Company Preferences tab must now be chosen.
    • Selecting the button next to If you want to match the accounts on your form 1099-MISC to the boxes.
    • There will be a page from the QuickBooks 1099 wizard. Select the Show IRS 1099-MISC filing thresholds to link under the Map Accounts step.
    • Double-click the Thresholds column in the appropriate 1099 Box’s column in the 1099-MISC IRS Thresholds box.
    • The statement Your settings do not match the current IRS thresholds will appear in red on the screen. If you want to follow the IRS-mandated threshold and add more transactions in its place, choose Reset to IRS Thresholds.
    • At last, you have to select Save and then Close

Step 3: From the Right Expense Account Ensure that you are Paying Contractors

QuickBooks uses the expense accounts you mapped to report 1099 transactions for creating 1099s. Review the contractor payment transactions and associated accounts if your amounts are incorrect.

QuickBooks Online and QuickBooks Contractor Payments

  • Start by selecting Reports.
  • In the search bar, you have to enter the transaction list. Then you have to choose Transaction List by Vendor.
  • Now you have to select the option of Customize.
  • Make last year the Report period (or Last Calendar Year).
  • Look under Rows/Columns. Mark the Split box after clicking the Change columns link.
  • Then you have to go to the Filter section.
  • Select the 1099 vendors in question from the dropdown menu after checking the Vendor box.
  • Then you have to select Run Reports.
  • Find out which accounts the vendor’s transactions were associated with by looking under the Splits column. Select the transaction if you see the word SPLIT to learn more about the accounts that were affected. Check the bill to see which spending accounts was impacted if this is a bill payment.

QuickBooks Contractor Payments without QuickBooks Online

  • Select Contractors by going to Contractors.
  • Then you have to choose View all contractor payments.
  • To view the Category you have to open each payment. When creating 1099s this account should be mapped.

QuickBooks Desktop

  • Select Vendors and Payables by going to Reports.
  • Then you have to choose 1099 Summary.
  • Select All allowed accounts by going to the 1099 options dropdown menu.
  • Find the Account and convert it to a 1099 Account once you have located the missing vendor.
    • Double-click the Total column value for the vendor.
    • Take note of the Accounts in the Account column of the 1099 Detail report.
  • For these transactions to appear on 1099 reports and forms.
    • Click Edit and then choose Preferences.
    • Choose Tax:1099 from the left pane of the Preferences panel, then click the Company Preferences option.
    • If you want to map your accounts to the boxes on form 1099-NEC or 1099-MISC, click the link next to that statement.
    • You will see a page from the QuickBooks 1099 wizard. Your browser will take you to Map Accounts. All accounts that have been used to pay 1099 vendors are shown in this window. Select one of the 1099 boxes from the Apply payments to this 1099 box drop-down menu.
  • Close the 1099 Detail report after completing it.
  • Now you have to choose the second 1099 options drop-down, and then you have to select Only 1099 accounts.

Conclusion

After reading the above article, your doubts related to fixing missing contractors or wrong amounts in QuickBooks for 1099s will be cleared out. You will get all the important points mentioned in this article. If you still face any issue related to this topic then you can call the help desk team and take benefit of 24*7 service.

Accounting Professionals, CPA, Enterprises, Owners
Accounting Professionals

Looking for a professional expert to get the right assistance for your problems? Here, we have a team of professional and experienced team members to fix your technical, functional, data transfer, installation, update, upgrade, or data migrations errors. We are here at Dancing Numbers available to assist you with all your queries. To fix these queries you can get in touch with us via a toll-free number
+1-800-596-0806 or chat with experts.


What if You Issued 1099 in Error?

When you say that my 1099 is wrong, the IRS usually already has it. Therefore, request a corrected Form 1099 if the Form 1099’s issuer has already sent the original to the IRS. The issuer will fill out Form 1099 in the correct amount and mark the corrected box.

How to Report a 1099 issued Error?

If you already mailed or eFiled your form 1099s with the IRS and need to make a correction, you must complete and mail a Red Copy A and 1096 to the IRS.

Will the IRS Catch a Missing 1099?

Even if you forget to include your income on your tax return, the government is aware of it since the 1099 form you receive is also submitted to the IRS.

Features of Dancing Numbers for QuickBooks Desktop

Imports

Imports

Exports

Exports

Deletes

Deletes

Customization

Customization

Supported Entities/Lists

Dancing Numbers supports all QuickBooks entities that are mentioned below:-

Customer Transactions

Invoice
Receive Payment
Estimate
Credit Memo/Return Receipt
Sales Receipt
Sales Order
Statement Charge

Vendor Transactions

Bill
Bill Payment
Purchase Order
Item Receipt
Vendor Credit

Banking Transactions

Check
Journal Entry
Deposit
Transfer Funds
Bank Statement
Credit Card Statement
Credit Card Charge
Credit Card Credit

Employee Transaction / List

Time Tracking
Employee Payroll
Wage Items

Others

Inventory Adjustment
Inventory Transfer
Vehicle Mileage

Technical Details

Easy Process

Bulk import, export, and deletion can be performed with simply one-click. A simplified process ensures that you will be able to focus on the core work.

Error Free

Worried about losing time with an error prone software? Our error free add-on enables you to focus on your work and boost productivity.

On-time Support

We provide round the clock technical assistance with an assurance of resolving any issues within minimum turnaround time.

Pricing

img

Importer, Exporter & Deleter

*See our Pricing for up to 3 Company Files

$199/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Unlimited Export
  • Unlimited Import
  • Unlimited Delete

img

Accountant Basic

*See our Pricing for up to 10 Company Files.

$499/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Importer,Exporter,Deleter
  • Unlimited Users
  • Unlimited Records
  • Upto 10 companies

img

Accountant Pro

*See our Pricing for up to 20 Company Files.

$899/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Importer, Exporter, Deleter
  • Unlimited Users
  • Unlimited Records
  • Up to 20 companies

img

Accountant Premium

*See our Pricing for up to 50 Company Files.

$1999/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Importer, Exporter, Deleter
  • Unlimited Users
  • Unlimited Records
  • Up to 50 companies

Dancing Numbers: Case Study

Frequently Asked Questions

 
How and What all can I Export in Dancing Numbers?

You need to click "Start" to Export data From QuickBooks Desktop using Dancing Numbers, and In the export process, you need to select the type you want to export, like lists, transactions, etc. After that, apply the filters, select the fields, and then do the export.

You can export a Chart of Accounts, Customers, Items, and all the available transactions from QuickBooks Desktop.


How can I Import in Dancing Numbers?

To use the service, you have to open both the software QuickBooks and Dancing Numbers on your system. To import the data, you have to update the Dancing Numbers file and then map the fields and import it.


How can I Delete in Dancing Numbers?

In the Delete process, select the file, lists, or transactions you want to delete, then apply the filters on the file and then click on the Delete option.


How can I import Credit Card charges into QuickBooks Desktop?

First of all, Click the Import (Start) available on the Home Screen. For selecting the file, click on "select your file," Alternatively, you can also click "Browse file" to browse and choose the desired file. You can also click on the "View sample file" to go to the Dancing Numbers sample file. Then, set up the mapping of the file column related to QuickBooks fields. To review your file data on the preview screen, just click on "next," which shows your file data.


Which file types are supported by Dancing Numbers?

XLS, XLXS, etc., are supported file formats by Dancing Numbers.


What is the pricing range of the Dancing Numbers subscription Plan?

Dancing Numbers offers four varieties of plans. The most popular one is the basic plan and the Accountant basic, the Accountant pro, and Accountant Premium.


How can I contact the customer service of Dancing Numbers if any issue arises after purchasing?

We provide you support through different channels (Email/Chat/Phone) for your issues, doubts, and queries. We are always available to resolve your issues related to Sales, Technical Queries/Issues, and ON boarding questions in real-time. You can even get the benefits of anytime availability of Premium support for all your issues.


How can I Import Price Level List into QuickBooks Desktop through Dancing Numbers?

First, click the import button on the Home Screen. Then click "Select your file" from your system. Next, set up the mapping of the file column related to the QuickBooks field. Dancing Numbers template file does this automatically; you just need to download the Dancing Number Template file.

To review your file data on the preview screen, just click on "next," which shows your file data.


What are some of the features of Dancing Numbers to be used for QuickBooks Desktop?

Dancing Numbers is SaaS-based software that is easy to integrate with any QuickBooks account. With the help of this software, you can import, export, as well as erase lists and transactions from the Company files. Also, you can simplify and automate the process using Dancing Numbers which will help in saving time and increasing efficiency and productivity. Just fill in the data in the relevant fields and apply the appropriate features and it’s done.

Furthermore, using Dancing Numbers saves a lot of your time and money which you can otherwise invest in the growth and expansion of your business. It is free from any human errors, works automatically, and has a brilliant user-friendly interface and a lot more.


Why should do you change the Employee status instead of deleting them on QuickBooks?

If you are unable to see the option to terminate an employee on your list of active employees on the company payroll, this mostly implies that they have some history. Thus, if you change the employee status instead of deleting it on QuickBooks, the profile and pay records remain in your accounting database without any data loss in your tax payments.


Is it possible to use the Direct Connect option to sync bank transactions and other such details between Bank of America and QuickBooks?

Yes, absolutely. You can use the Direct Connect Option by enrolling for the Direct Connect service which will allow you access to the small business online banking option at bankofamerica.com. This feature allows you to share bills, payments, information, and much more.


Why should do you change the Employee status instead of deleting them on QuickBooks?

If you are unable to see the option to terminate an employee on your list of active employees on the company payroll, this mostly implies that they have some history. Thus, if you change the employee status instead of deleting it on QuickBooks, the profile and pay records remain in your accounting database without any data loss in your tax payments.


What are the various kinds of accounts you could access in QuickBooks?

QuickBooks allows you to access almost all types of accounts, including but not limited to savings account, checking account, credit card accounts, and money market accounts.

Get Support

Bulk import, export, and deletion can be performed with simply one-click. A simplified process ensures that you will be able to focus on the core work.

Worried about losing time with an error prone software? Our error free add-on enables you to focus on your work and boost productivity.

Close X
Call Now+1-800-596-0806
Top