|
Can't get QB G/L # on imports |
Post Reply 
|
| Author | |
rocketsteve 
Newbie 
Joined: 15 April 2012 Location: novato ca Status: Offline Points: 1 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: Can't get QB G/L # on importsPosted: 15 April 2012 at 3:10pm |
|
hello - clearly this must be user error. I load sales, credit card, items to QB Online. I can't get some data to match up. For example
Sales-receipt template. Bank account number will not match up with my #. I put in "1005" and the import sets up a new G/L item. I cut and paste from the chart of accounts, "1005 Checking", it creates an entirely new category. Same for Expense Account in Bills. I can upload new items, or bills. But then I have to go into each transaction and fix it to record in the proper category. Very time consuming. Thank you.
|
|
|
rocket Steve
|
|
 |
|
|
QBKaren
Admin Group 
Joined: 26 March 2011 Location: NH Status: Offline Points: 1279 |
Post Options
Thanks(0)
Quote Reply
Posted: 15 April 2012 at 4:12pm |
|
Your import file should contain either account numbers or account name and not both. If you are using account names make sure you include the account and sub account separated by a colon (eg Account:Subaccount). |
|
|
Visit our blog for more tips and how to examples
|
|
|
|
|
VeritasCPA
Newbie
Joined: 28 February 2012 Status: Offline Points: 2 |
Post Options
Thanks(0)
Quote Reply
Posted: 16 April 2012 at 3:38pm |
|
I don't have the option "enable account number on transactions" - I am using 5.0. Maybe I am not looking in the right place?
|
|
|
|
|
QBKaren
Admin Group
Joined: 26 March 2011 Location: NH Status: Offline Points: 1279 |
Post Options
Thanks(0)
Quote Reply
Posted: 16 April 2012 at 4:07pm |
|
Yes this post if for QuickBooks Online. Please refer to this article for TPI 5: http://blog.baystateconsulting.com/index.php/2010/10/21/how-to-format-customers-items-classes-and-accounts-in-your-import-file-for-use-with-transaction-pro-importer-for-quickbooks/
|
|
|
Visit our blog for more tips and how to examples
|
|
|
|
|
Post Reply
|
|
Tweet
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
Topic Options