Update September 13, 2014: An updated version of this article can be found here.
Want a fast and easy way to import your journal entries into QuickBooks Online? This application is on Intuit’s newest platform, the Intuit App Center. There is a free trial available here.
As long as your data is in an Excel or CSV file you can use Transaction Pro Importer for QuickBooks Online to upload these transactions to your QuickBooks Online company file. Your import file can contain columns in any order, have whatever headers you want and can have extra columns. We have provide a suggested template for you to review or start with to save you time. You can download this template here. If you use the template we provide then you won’t need to map any fields since Transaction Pro Importer automatically maps fields with the same name.
Below is a table showing all the fields supported as well as the data format expected in your import file. To see the entire table change the number of rows in the show entries box. We also have this data dictionary available in a Microsoft Excel file here.
|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.||T|
|Memo||Journal Entry - Line Item Memo||T|
|Class||Journal Entry - Class||T|
So if your company needs the ability to import journal entries into QuickBooks Online try the free trial today of Transaction Pro Importer: The fast and easy way to import your data into QuickBooks Online.
If you have any questions or comments please post them below.