Skip to main content
June 14, 2021
Question

I need to import payroll Data in quickBooks. How I can achieve that? Is quickBooks online support this feature? If so then which file format it supports. Thank you

  • June 14, 2021
  • 2 replies
  • 0 views
1) Is QuickBooks Online supports importing Payroll Data from File? 2) If so, which file format it supports? 3) Please provide sample file format that it supports.

2 replies

June 14, 2021

I can show you how to input your payroll data into QuickBooks, userskywatchtechnolo.

 

The option to import payroll and employee info is unavailable. Some payroll services let you import paycheck data directly into QuickBooks. If your service doesn't have this feature, you can manually track these payments as journal entries or look for one of our supported apps. This keeps your payroll and account data all in one place. 

 

You can also complete your payroll setup through the prior payroll process. This is to make sure that everything is accurate for year-to-date (YTD) totals on your employees’ pay stubs going forward to report correct W-2 information at the end of the year. 

 

To help track your payroll accounts and where paycheck amounts are posted, you can refer to these links: 

 

Keep me posted if there are other payroll questions you need help with. I'll be right here to keep an eye on your response. Take care!

Fiat Lux - ASIA
June 14, 2021

@userskywatchtechnolo 

Prepare your historical payroll data as JE with the following template

RefNumberTxnDatePrivateNoteIsAdjustmentCurrencyExchangeRateAccountLineAmountLineDescEntityClassLocation
10101/10/2020Wire TransferFALSE  Savings-50.00Credit Savings   
10101/10/2020Wire TransferFALSE  Checking50.00Debit Checking   
10201/10/2020Wire TransferFALSE  Savings200.00Debit Savings   
10201/10/2020Wire TransferFALSE  Checking-200.00Credit Checking   

 

then utilize an importer tool

https:// transactionpro.grsm.io/qbo