cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
finance-adaptpro
Level 1

Is there a way to import our payroll journal entry spreadsheet into QBO?

This is a non-profit with many different funding sources paying for each employee's time.
2 Comments 2
ReymondO
Moderator

Is there a way to import our payroll journal entry spreadsheet into QBO?

Hey there, @finance-adaptpro.

 

Right now, the option to import payroll data into QuickBooks Online (QBO) is unavailable. As of the moment, these are the files we can bring into the program: 

 

  • Bank data
  • Customers
  • Suppliers
  • Chart of accounts
  • Products and Services
  • Invoices
  • Bills

 

If these paychecks are created outside QuickBooks, we can still enter them via journal entries. Here's how:

 

  1. Click the + New button in the left navigation menu.
  2. Select Journal entry.
  3. Fill out the fields to create your journal entry.
  4. Pick Save and new or Save and close.

 

Moreover, you can look for a third-party importer tool to import your payroll data as JE. Simply go to the Apps menu and select Find apps. Then, search for an app from there. 

 

We've assembled some frequently asked questions about importing data to QBO. You can review them in this article: Common questions about importing data to QuickBooks Online.

 

Please let me know if you need further clarification about importing your payroll data into QuickBooks. I'll be here to help you out. Take care and stay safe. 

Fiat Lux - ASIA
Level 15

Is there a way to import our payroll journal entry spreadsheet into QBO?

@finance-adaptpro 

Prepare your JE data 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 to proceed

https://transactionpro.grsm.io/qbo

 

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us