LIMITED TIME 90% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
NKonysky
Level 1

Payroll Import

Hello, 

I am looking for the file specifications for importing payroll for from another payroll provider.  We will be using Paylocity so if you have a vendor specific format, that would be the one I need.  Is this provided somewhere online or will you have to send it to me.  We use Enterprise 2021.

 

Thank you in advance.

 

Nancy

5 Comments 5
Archie_B
QuickBooks Team

Payroll Import

Hi there, NKonysky.

 

I'd like to share some in sights in importing payroll data into QuickBooks Desktop.

If you're trying to import payroll transactions directly from your third-party application to QuickBooks, you should consider entering it manually through journal entry. I suggest consulting an accountant to make sure your books are accurate

I also recommend contacting your third-party app support to help you further in importing payroll data into QuickBooks.

 

You can check this link for the list of supported application in QuickBooks Desktop: Apps for QuickBooks Desktop.

 

Post a your reply below and tag my name if you still have other questions about importing payroll data. I'll be in touch. Have a good one.

Fiat Lux - ASIA
Level 15

Payroll Import

@NKonysky 

Prepare your JE data with the following template

RefNumberTransaction DateAccountDebit Credit MemoNameClassBillableIs AdjustmentCurrencyExchange RateHome Currency AdjustmentAmounts in Home Currency
127/09/2020Checking  130PR 092518John Smith NN    
127/09/2020Wages200 PR 092518John Smith NN    
127/09/2020Payroll Taxes Payable 50PR 092518John Smith NN    
127/09/2020Health Insurance Payable 20PR 092518John Smith NN    

 

then utilize one of these importer tools

https://transactionpro.grsm.io/qbd

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

 

kkellam2
Level 1

Payroll Import

This was not a helpful answer.  I am also trying to upload payroll data from an outside resource into QB.  They are requesting the file format and formatting of the report so that it can be uploaded.  I would also need to know how to upload in to QB.

 

Thank you

Angelyn_T
Moderator

Payroll Import

Hi there, Kellam. I understand your interest in trying to bring your payroll data from an outside source to our QuickBooks Desktop (QBDT) software. I'm here to share with you some insights about this action.

 

I want you to know that QuickBooks allows you to input your payroll data into our system by adding them manually or creating a journal entry. While preparing a file format for upload is unavailable, you can temporarily follow the suggested workaround or look for a supported third-party application.

 

Additionally, you can send a feature request directly to our product developers. This way, they can determine what enhancements and improvements are needed to make our product more effective and convenient for our users. 

 

Here's how:

 

  1. Open your QBDT file.
  2. Go to the Help menu, then click on Send Feedback Online.
  3. Tap on Product Suggestion.
  4. Enter your comments or requests.
  5. Hit on Send Feedback to proceed.

 

When you're ready to utilize our payroll service and start tracking your transactions, check out this article as your quick guide to start: Get started with QuickBooks Desktop Payroll.

 

Please extend your patience about this matter. If you have follow-up questions, let me know by leaving a comment below. I'm always here to help. Have a great day!

Fiat Lux - ASIA
Level 15

Payroll Import

@kkellam2 

Are you using QB Online or QB Desktop?

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us