Hi there, @beth100. Thank you for reaching the Community. I've got some information you need so you can import an Excel in QuickBooks Online.
Yes, you can import the list of your contractors using an Excel file in QBO. You’ll want to import them as a vendor list in your account.
From there, you can also edit the list and check the box for Track payments for 1099. This way, the lists will be reflected in the Contractors page.
You can read through this article to learn more about importing customer or vendor contact lists from Outlook, Excel, Gmail, or Google Sheets.
For more details about moving lists and adding contractors, check out these articles:
You can always reply or reach out to us again if you need anything else with managing your transactions in QBO. We're always here to guide and assist whenever you need help. Have a good one!
Thanks @Carneil_C . I guess I was not clear on what I was asking. I am talking about the actual processing of payroll, not adding new contractors. After I have the contractors added and want to run my payroll can I upload a spreadsheet that contains all the contractors and their payments for that pay period? Instead of having to manually enter a pay amount for each contractor? Their payments vary each time and I pay different contractors each time, usually about 100 contractors per pay period, so adding them in one by one manually would be a lot of work but if I can upload a spreadsheet that contains each person and their pay, that would be much faster. Thanks.
Thanks for adding some details about your situation, beth100.
For now, we can only import the bank data, customers, vendors, chart of accounts, products/services, and invoices in QuickBooks Online. When you say you want to run payroll for these contractors, are they added as employees? If so, you need to enter their past pay information manually. This is to make sure that everything is accurate for year-to-date (YTD) totals on your employees’ pay stubs to report the correct W-2 information at the end of the year.
You can read this article for more details: Set up a prior payroll for QuickBooks Online Payroll.
On the other hand, you can visit our QuickBooks App Center to find a third-party application that can import payroll transactions into the program. You can also follow these steps to search for an app if you're inside QuickBooks Online:
In addition, please check out this link to help you with the payroll service: Get started with QuickBooks Online Payroll.
Please feel free to get back us if you have more questions or need help with other task in your account. Take care and stay safe.
Hi there, @s2linda.
I can see here that you've posted the same question twice, and my colleague already answers your question through this link.
Though there isn't a direct way to import the list of your contractor and their payment, you can look for a third-party app. Just follow the steps shared by RenjolynC on how to search for a third-party app.
Please know that the Community has your back should you have any questions. Take good care!