How to import a QBO file into Quickbooks Desktop – ProperSoft

Steps on how to make a rule: 1. After importing the QBO file you go to the Rule 2. Select Manage Rules drop-down then choose Add New 3. Then write Rule Name 4. In the Description field write common contains mentioned in the memo 5.

Select Rename and then write Payee field then select add 6. Select a category and write the accounting field 7. If you need to modify the Rule then you can easily modify it by doing the Following Steps- 1.

Select Rule which you want to modify 2. Edit Rule: if you want to change a detail in Rule b. Recent Blogs Worker Classification: Employee vs. Using the Wells Fargo default will make no difference in getting the data into QuickBooks Desktop except that you will have a Wells Fargo logo associated with it.

See below if you receive an error that QuickBooks cannot verify the institution details. Generally you can just cast your eyes over the above fields before clicking Download , but do make sure the Account Number is captured and, if not, at least that it’s unique. If you are looking to import Statement data to an account that is already connected to a Bank Feed, you will need to disconnect the Bank Feed first. Once selected, and assuming it’s the first time you’ve imported a.

Hit Continue and that’s it – you should be redirected to the Bank Feeds Center with all your transactions available to view for that Bank Account. All you have to is:. Select Prairie Community Bank from the list and click Next. Enter the login and password that you use to login to your online banking account at PrairieCommunityBank.

If it has a blue ball icon it means the account is online linked to direct download. Then click ‘Ok’. Check there is no blue ball after the change. Click the ‘Continue’ button. Now your data is imported.

QuickBooks Import Using Web Connect – Features of Dancing Numbers for QuickBooks Desktop

 
And the ‘Payee’ column is empty. Use the ProperConvert app to ссылка your transaction files to required by your accounting software file format.

How to import a QBO file into QuickBooks Desktop – Post navigation

This example is for the Quickbooks Desktop Windows version. You can quickly roll back to the previous state if you realize later that something was importing in the wrong way.

Confirm file name. You can change it, just keep the file extension as. Then click the ‘Save’ button. Quickbooks has saved a backup of the company file to the Documents folder. Click ‘OK’. Now we can import a QBO file. Or you could create that file with a utility like a ProperSoft converter. Or with the ProperConvert app, which converts from more formats and converts to more formats. Before importing, make sure that the Bank or Credit Card account is disconnected from Online Services.

Click ‘Lists’ – ‘Charts of Accounts’ for the account you want to import into. If you have the icon, it means that the account is connected to Online Services. You need to disconnect first to import a QBO file. Check there is no yellow icon after the change.

You do not have to disconnect all accounts from Online Services, just the account you need to import your data into. Let’s import a QBO file. In this example, we have already a QBO file at the beginning of this tutorial. Then you select your QBO file. It shows only QBO files, listed here. There are no other files in the Downloads Folder.

Click the ‘Open’ button. Let’s take a look at the INTU. BID in the text editor Notepad. In our case, we have INTU. BID number – So, the QBO files are the text files. You can review them, before importing. Just take a look at them, that they are created correctly. BID value is for your bank and it is allowed. When you use ProperSoft converter you can get that list, numbers for each bank, and you’ll see they are allowed or not.

There is also an Account Type. It is matching what you are going to import. So if you have a Checking account, you’ll see only Checking accounts listed, if you have Credit Card, you’ll see only Credit Card accounts listed. Account ID has to be digits only number. It could be any number, but it is a good idea to use the actual account number, that you have for that account. Let’s say if you need to convert for two accounts and you have five files: three for one account and two for another.

So, for those three files, you have to use one Account ID and for those other two files, you have to use another Account ID, the same for those two.

So, that’s why, when you are starting using different numbers, to avoid confusion, it is easier just to use the account number.

So you have a specific account number for that account, just use it. If you are starting converting or using another account, just use that another account number. Check any transactions, that it is obviously an expense transaction, check that it has a minus, that it is a negative amount. If it is negative, then the QBO file was created correctly. And deposits must be positive. If you see it in the opposite way, even if that file was downloaded from your bank, then it means, that it was created incorrectly.

Even for banks, like Checking Account or Credit Card, if it is an expense, it must be negative. Let’s return to selecting a Bank Account. You can have any name here, even if you are importing, let’s say, for Capital One.

You could have here Wells Fargo. It’s fine because the Bank Label is no an important Label. The Account type is more important, you must match what you importing for.

You are importing for Bank Account, then it has to be Checking or Savings. The Account number is important to check because if you are importing for this or that account, that you used incorrectly, you specified for the QBO file correctly. You may never use the option ‘Create a new Quickbooks account’ because you can not move transactions from one account to another in Quickbooks, as in Quicken.

Unless you really creating a new account, then you would use this option to create a new account and import transactions there. But mostly you created that account before when you set up Quickbooks. And you will see here only accounts matching this Account Type.

So if it is a Checking Bank account, then you would see only Checking accounts. In this example, we will use the ‘Checking Wells Fargo Bank’ account. Select the Bank Account and click the ‘Continue’ button.

Now your Web Connect data has been successfully read into Quickbooks. Click the ‘OK’ button. So, the first part is done. The account we import into got back yellow strike icon. It happens when you import a QBO file. BID value. BID value, same Account Type, Quickbooks will not ask you to select an account and will import directly into this account. If you need to import the QBO file with another Account ID, but into that account for whatever reason, you have to disconnect it first.

And then continue with that QBO file. In the second part, you have to review transactions. Pay attention to the Account ID. You have to match each transaction to Vendor Record. For example, figure out ‘No payee’ what it is? Then go to ‘Account Settings’ and tell which expense account to prefill when you enter bills for this Vendor. Let’s select ‘Office Supplies’. So, we have the ‘Office Supplies’ account prefilled.

You can still change it, but if it is your regular Vendor and it is already classified, categorized, then you would have by yourself extra-clicking, because you already assigned it, as Vendor Record. Then you continue doing it with all of them or some of them, actually checking what you want to add to the register. If you see some transaction, that does not belong, or wrong, or you do not want to import it, mark it and select ‘Ignore’.

So, you have to get all transactions out of here. Let’s add the first one, for example. Click ‘Yes’. It offers you to create a renaming rule, so for next time, when you import this, it will be automatically selected ‘Home Depot’ for ‘No payee’. For something, like ‘Home Depot’ 1, 2, 3, it is a good idea to create the following rules. For something, like ‘No payee’ is not a good idea to create a renaming rule.

So, you can uncheck it, because ‘No payee’ could mean anything you have to find actual payee, so you don’t want it to be automatically for the next QBO import. Then click ‘OK’. So this way you can continue matching transactions. And then it will be done. This is how you import and then match your QBO file.

All rights reserved. Privacy Policy Contact Us.

Import qbo file into quickbooks desktop.How to Import a QBO File into QuickBooks Online?

 
 
Process Steps for Importing QBO File into QuickBooks Online Step At the start, login into QuickBooks Online and then click on Banking. Select the account your must have Step . AdMove from any accounting software to QuickBooks. Convert data error free. Sage data conversions done rapidly, zero downtime, zero errors. To import a QBO file, select ‘File’ – ‘Utilities’ – ‘Import’ – ‘Web Connect Files’, select created QBO file. And select an existing account to import transactions. Check bank label, Account Type, Account number to select the correct Account in Quickbooks.