Showing results for 
Search instead for 
Did you mean: 
Level 1

excel import for QB online

My payroll service sent me an excel to import into my QB online and I am getting the following error message: Something's not quite right.  This is not the correct format.  Try Excel or CSV format.

What is the correct/best format for importing payroll transactions.  My payroll processor uses ProPay payroll software to process my payroll. 

Thank you for any assistance you provide.

2 Comments 2
QuickBooks Team

excel import for QB online

Hello there, @craft1120.


At this time, importing payroll isn't supported in QuickBooks Online (QBO). 


In the meantime, you can enter your payroll manually by recording a prior payroll.


Here's how:

  1. From the left menu, click Taxes.
  2. Select Payroll Tax.
  3. Click Enter prior tax history.
  4. Under Prior Tax Payments, select Add Payment.
  5. Enter the tax information and amount of your payment.
  6. Hit OK.

Here's an article you can read to learn more about recording a prior payroll: Set up a prior payroll.


I've attached this helpful article in case you need some ideas about managing your payroll transactions: Payroll and workers.


Please let me know if you have other questions. I'll be always here to help you!

Fiat Lux - ASIA
Level 15

excel import for QB online


Utilize the 3rd party tool to import historical payroll data as JE in bulk


Hope it helps.

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us