cancel
Showing results for 
Search instead for 
Did you mean: 
craft1120
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
GraceC
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

@craft1120 

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

https://transactionpro.grsm.io/qbo

https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

 

Hope it helps.

Need to get in touch?

Contact us