Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I am currently performing payroll within Enterprise and would like to switch to a 3rd party software that does this task for me (currently looking at Paycom). I am able to import time sheets into QB enterprise through the .iff file, but can't find how to import payroll information? Ideally would need access to total employee pay amount $ by client and service item so I can run customer profitability reports to show how much payroll was used by client for a specific service. Is this possible? ...and what format would import need to be in? Was thinking importing a journal entry may be an option? Thanks in advance.
I know how important it is to import your payroll information when using a 3rd party payroll software, smartin2. I'm here to share some insights.
At this time, you can only import Customer, Vendor, Items, and Chart of Accounts in QuickBooks Desktop. Importing payroll information is unavailable. As a workaround, you can enter them as journal entries.
Here's how to create a journal entry:
Additionally, I've included these articles that'll help you view useful information about your business and employees. This way, you'll be able to ensure your data is accurate:
Please know that I'm only a few clicks away if you have any follow-up questions, smartin2. Wishing you and your business continued success!
to clarify, can't you import the G/L as an .iif file that creates the journal entry for you (which could include payroll data)?
Great to see you again in the Community, @smartin2. I'd be happy to share some details about importing the .iff file into QuickBooks Desktop (QBDT).
You can import the General Journal as an IFF file that has your payroll data. However, you'll want to create a backup file first. This process is done to avoid data loss or data damage.
Here's how to create a local backup:
Once done, you can start importing the IFF file. If you're using QBDT 2019, select the Multi-user mode when importing. However, if it's the older version, use the Single User mode.
Here's how to import the .iff file:
I'd also recommend consulting an Accounting professional to help you with the process to make sure that your books are accurate.
I've got an article for you to check just in case you'll encounter any issues when importing the .iff file into QuickBooks Desktop: Improved IIF Import in QuickBooks 2019 and later.
I'll be around if you have further questions or concerns about entering prior payroll in QBDT. Take care and have a great day ahead!
I am having the same issue with QBO and Paycom. Why would QB not want to interface a simple excel file. Sounds like I need to find another accounting system.....
You need to use a 3rd party tool to import JE.
https://get.transactionpro.com/qbo
Otherwise, you may purchase a 3rd party conversion service to switch from QBO to another accounting app.
@smartin2 have you found a solution? If so, could you please share. Thank you
Hello @GM33.
I've noticed that this is a duplicate post and my colleague @Jelayca V has already provided an answer to your question about importing Paycom Payroll Data into QuickBooks Desktop. You can find her response by following this link: https://quickbooks.intuit.com/learn-support/en-us/employees-and-payroll/re-importing-paycom-payroll-...
The QuickBooks Community team is available to assist, so feel free to reach out if you have any more questions. Take care and have a great weekend!
QB Online or QB Desktop?
Desktop Enterprise
You can prepare the payroll data in the following JE format
RefNumber | Transaction Date | Account | Debit | Credit | Memo | Name | Class | Billable | Is Adjustment | Currency | Exchange Rate | Home Currency Adjustment | Amounts in Home Currency |
1 | 27/09/2020 | Checking | 130 | PR 092518 | John Smith | N | N | ||||||
1 | 27/09/2020 | Wages | 200 | PR 092518 | John Smith | N | N | ||||||
1 | 27/09/2020 | Payroll Taxes Payable | 50 | PR 092518 | John Smith | N | N | ||||||
1 | 27/09/2020 | Health Insurance Payable | 20 | PR 092518 | John Smith | N | N |
then use a 3rd party tool to import it in bulk.
Thank you @On Beta
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here