Often times companies use a company other than Intuit to process payroll and are looking for an easy and reliable way of importing this data into QuickBooks. We have some detailed articles on our blog on how to import checks and journal entries into QuickBooks using Transaction Pro Importer 5.0 (“TPI5”). However, we wanted to provide an article which provides answers to the most commonly asked questions as well as provide some options that might make your imports easier.
Does TPI5 support job costing?
Yes there are various fields on both the check and journal entry imports that allow you to specify a customer name and/or billable status.
On check imports the following fields are available to users on the TPI5 mapping screen: Expenses Customer, Expenses Billable, Items Customer and Items Billable.
On journal entry imports the following fields are available to users on the TPI5 mapping screen: Name and Billable.
Journal Entry Imports – how do the amounts need to be formatted?
You can either have two columns one for debits and one for credits. Alternatively, if you enable the option on the advanced tab, Specify a single column for Debit/Credit instead of separate columns you can provide your amounts all in one column with the debits expressed as a positive number and the credit amounts are expressed as a negative number.
What if the employee name does not exist in QuickBooks pre-import?
For check imports you have the options below:
- If you do not select any options TPI5 will just create a new vendor
- If you want TPI5 to set up any new names in QuickBooks as an employee you can turn on a command line called /EMPLCHECK=1 which will add any new names as employees. You can read how to enable this here.
- If you do not want TPI5 to create any new names you can select an option to not add new names. You can read more here.
For journal entry imports you have the options below:
- If you do not select any options TPI5 will provide you with an error message that the entity does not exist if TPI5 does not find a matching name in QuickBooks.
- If you want TPI5 to create the names for you in QuickBooks you can enable the command line /JE_NAME. You can read more here.
What if the accounts or the employee names do not match my accounts and names in my QuickBooks company file?
On check imports you can import by employee number by enabling the /EMPLXREF command line. You can read more here.
On journal entry imports you can use a cross reference in the Account Name field on the journal entry. You can find this option on the Advanced Tab within TPI5 under the General Ledger Accounts section.
On my check imports what if all gross amount and deductions are in columns instead of in rows?
If your payroll provider lists all amounts for a check on one line turn on the option on the Advanced Tab within TPI5 under checks to enable columns as rows for checks.
What if I use Intuit Payroll can I import the hours work into QuickBooks so I can then process the payroll through QuickBooks?
Yes, just use the import type, Time Tracking. You can read more here.
Where can I find the articles on Importing Checks and Journal Entries?
Click on the links below for links to our articles on importing of:
You can request a free trial demo of our software here. If you have any questions or comments please post them below.