Want a fast and easy way to import your journal entries from Microsoft Excel or comma delimited files? Look no further than our Transaction Pro Importer on the Intuit App Center where you can take a free trial with no credit card required on the Intuit App Center.
We have provided a picture of a journal entry screen and a table with information on each of the fields to help get you started.
Here is a table with all the fields on a journal entry and some helpful tips.
|QuickBooks Field||QuickBooks Form - Field Description||Notes||Required Field||Type (D for Date, N for Number and T for Text)|
|RefNumber||Journal Entry - Entry #||This field is how TPI knows how to group multiple lines onto the same journal entry. If you would like to let QuickBooks auto assign the next journal entry number select the TPI ipion to Let QuickBooks Auto-Assign Invoice Numbers. TPI still needs a RefNumber for internal grouping even if you enable this option.||Y||T|
|TxnDate||Journal Entry - Date||D|
|Note||Journal Entry - Memo at bottom of screen||T|
|IsAdjustment||Journal Entry -||T|
|Account||Journal Entry - Account||If using account numbers provide the lowest subaccount number only and turn on the option in TPI, Enable Account Numbers on Transactions. If using account numbers includethe entire account and any sub accounts separated by colons (ie. Account:Sub account).||Y||T
|Amount||Journal Entry - Amount||Debits are expressed as postive amounts and credits as negative amounts.||Y||N
|Entity||Journal Entry - Name||Name must already exist in QuickBooks. If you are using sub clients be sure to include both the customer and job separated by a colon (Customer:Job).||T|
|Memo||Journal Entry - Line Item Memo||T|
|Class||Journal Entry - Class||T|
|Location||Journal Entry - Location||The field can also be called business, department, division, property, store or territory.||T|
If you have any difficulties with the mapping feel free to send your file to firstname.lastname@example.org and we will help you get started.