Skip to main content
November 17, 2023
Question

Is there a way to import payroll history from an excel spreadsheet?

  • November 17, 2023
  • 2 replies
  • 0 views
Is there a way to import Payroll History from an Excel spreadsheet?

2 replies

November 17, 2023

Hi there @hnors-frontiersl,

 

I'm not sure if there is a way to import payroll history from an Excel spreadsheet in quickbooks, but I found this article that might help you: https://quickbooks.intuit.com/learn-support/en-us/employees-and-payroll/how-to-import-payroll-data-from-excel/00/186415.

It explains how to use the IIF file format to import payroll data from Excel. I hope this works for you. Let me know if you have any questions or issues. Good luck!

 

Thanks 

Paul Newman

November 18, 2023

I can see the convenience of importing payroll history through your QuickBooks Online Payroll account, @hnors. The option to import payroll history is currently unavailable in QuickBooks Online. Let me guide you accordingly.

 

We can look for a third-party application that manages importing bill templates in QuickBooks Online. If you need to use one, we suggest a third-party application and navigate for an app in the QuickBooks Online App Center

 

Here's how:

 

  1. On the left pane, choose the Apps tab.
  2. Click the Find Apps.
  3. Enter the keyword or name in the Search bar.
  4. Once done, similar apps will appear on the screen.

 

Moreover, exporting attachments using the Batch Action feature can be a helpful way to keep your attachments in QuickBooks Online. Please refer to this page mentioned for detailed instructions: Export reports, lists, and other data from QuickBooks Online.

 

Please let me know what other specific features or requirements you have in mind for the file management application in QuickBooks Online Payroll, and I'll do my best to assist you in finding a suitable solution.

Fiat Lux - ASIA
November 18, 2023

@hnors-frontiersl 

You can prepare data in Journal Entry 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 use an importer tool to proceed

https://get.transactionpro.com/qbo