Setting attributes for the QBO files - ProperSoft

Setting attributes for the QBO files

This video talks about QBO format Output options.

So, if you are using the converter, that converts to QBO format, which is Bank2QBO, CSV2QBO, PDF2QBO, QIF2QBO, and others, then you would have this QBO tab here, that you have to use to set right QBO parameters. They are like complement transaction data, QBO files have transaction data plus additional things, that are related to the whole file.

Setting attributes QBO files Step 1: main window

In this case, it would be the Account ID. And if you have more than one account, you would see more than one choice, more than one group here. This is the Account ID for the QBO file, which is digits only number and Account Type, which could be Checking, Savings, Credit card, and others. So, when you convert transactions for one account, you have several files to convert, make sure to use the same Account ID for those files. When you're ready to convert for another account, make sure to switch the Account ID, when you start converting for different accounts. The same goes for the Account Type.

Setting attributes QBO files Step 2: Account ID

Another setting for the QBO file is Currency. For QuickBooks US Edition QBO files must have US Dollars currency, for Quickbooks Canadian edition - must be US dollars or Canadian dollars. There are also options to set: Bank ID or Branch ID, you can leave them empty with using QuickBooks and you can set them if your accounting software requires this to be set. The next option is the Bank INTU.BID has to be from the allowed bank. You can see the list of banks, clicking the 'Lookup' button.

Setting attributes QBO files Step 3: Currency

And you can start typing your bank name, for example, "Capital One" and you would see this bank is listed several times: there's one option for the Credit card, another option for the Checking account.

Setting attributes QBO files Step 4: Lookup Capital One

So, make sure, for example, "Wells Fargo Bank" (03000) allows all Credit account types and this is more than bank label, it does mean anything, so you could have "Wells Fargo Bank" label for the QBO file, but then you would select any account in QuickBooks, like Checking account, you would select any account to import your transactions into. Many users want to set the bank name to match, what they have in QuickBooks, but it's not necessary. The more important thing is to have the code to be allowed. Don't use code, that said 'not allowed' and don't use codes, that not allowed for your Account type. So, for Checking, you cannot use code, that lists only a Credit card.

Setting attributes QBO files Step 5: Lookup Wells Fargo

Another setting for the QBO file: you can set the Balance and you can use these settings, like 'Deterministic References', 'Regenerate References', 'Allow non-numeric checks', 'Allow empty name' and 'Separate splits'. These are advanced settings. See another step-by-step tutorial about these settings. Suggest: not changing them, unless you specifically know, that you want to use them a specific way.

Setting attributes QBO files Step 6: Balance

Related articles