How to Upload a Qba File Into Quickbooks
Import a QBO file into Quickbooks Desktop for Windows
QBO files are Web Connect files similar to direct online download (save a QBO file from your online banking and then import into Quickbooks)
This tutorial shows all the steps for QBO import into Quickbooks Desktop for Windows.
This example is for the Quickbooks Desktop Windows version. Earlier importing any file (IIF file, QBO file, QBJ file) into Quickbooks, make sure to backup your Quickbooks company data file. You tin can apace curl back to the previous state if you realize later that something was importing in the wrong way.
To fill-in your Quickbooks data, click 'File' - 'Back up Company' - 'Create Local Fill-in'.
Then select 'Local fill-in' and click 'Next'.
Select 'Salve it now' and click the 'Next' push.
Ostend file proper noun. You can change it, just continue the file extension every bit .QBB. Then click the 'Save' push button.
Done! Quickbooks has saved a backup of the company file to the Documents folder. Click 'OK'. Now we can import a QBO file.
Yous could have a QBO file downloaded from your Online Banking, and then you just import it. Or you could create that file with a utility like a ProperSoft converter. For example, you take a CSV file, and you employ CSV2QBO or Bank2QBO to convert it to QBO file. Or you accept a PDF file, downloaded from your Depository financial institution or Credit Card and you utilize PDF2QBO or Bank2QBO to create a QBO file from the PDF file. Or with the Transactions app, which converts from more formats and converts to more formats.
Earlier importing, brand sure that the Depository financial institution or Credit Card account is disconnected from Online Services. Click 'Lists' - 'Charts of Accounts' for the account you want to import into.
Make certain, that the account you demand to import into doesn't have the xanthous strike icon. If you take the icon, information technology means that the account is connected to Online Services. You lot need to disconnect outset to import a QBO file.
To disconnect, correct-click - 'Edit Account'.
Then click on 'Bank Feed Settings' and select 'Conciliate All Online Services'.
Click 'Relieve & Shut' and 'OK'. Check at that place is no xanthous icon subsequently the change. Later disconnecting the account from Online Services, you can import a QBO file. You do non take to disconnect all accounts from Online Services, only the account you demand to import your data into.
Let's import a QBO file. In this example, we take already a QBO file at the beginning of this tutorial. Click 'File' - 'Utilities' - 'Import' - 'Web Connect Files'. QBO files are Web Connect Files.
Then y'all select your QBO file. It shows simply QBO files, listed here. There are no other files in the Downloads Folder. Click the 'Open' button.
This greeting grade shows y'all a Bank label, which is converted from INTU.BID value in your QBO file.
Let's take a expect at the INTU.BID in the text editor Notepad. Open Downloads folder, select a QBO file - right-click - 'Open up with' - 'Notepad'.
In our case, we have INTU.BID number - 3000. So, the QBO files are the text files. You lot can review them, before importing. Merely have a wait at them, that they are created correctly. INTU.BID value is for your banking company and information technology is allowed. 3000 is 'Wells Fargo'. When y'all use ProperSoft converter you can go that listing, numbers for each banking concern, and y'all'll see they are allowed or non.
There is also a Bank ID. Information technology should be digits only.
There is likewise an Account Type. Information technology is matching what yous are going to import. So if you have a Checking account, you'll come across only Checking accounts listed, if you have Credit Card, you'll see only Credit Bill of fare accounts listed.
Account ID has to be digits only number. It could be whatever number, only information technology is a good thought to use the bodily business relationship number, that you accept for that account. Because if you are importing for multiple accounts, then you must use dissimilar Account ID's for different QBO files. Permit'southward say if you lot need to convert for two accounts and you accept five files: three for one account and two for some other. So, for those 3 files, you lot have to use one Account ID and for those other two files, yous accept to use another Account ID, the aforementioned for those two. So, that'due south why, when you are starting using different numbers, to avoid defoliation, it is easier just to use the account number. And so y'all have a specific account number for that account, just use information technology. If you are starting converting or using another account, just use that another account number.
Bank check any transactions, that it is obviously an expense transaction, cheque that it has a minus, that it is a negative amount. So if information technology something expense, like Office Supply, Dwelling Depot, Shell Purchase, information technology must be negative. If information technology 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, and then it means, that it was created incorrectly. Even for banks, similar Checking Account or Credit Carte, if it is an expense, information technology must be negative.
Let'southward return to selecting a Bank Account. In our case, nosotros have 'Financial Establishment' - Wells Fargo Bank (3000). Yous can have any name here, fifty-fifty if you are importing, allow's say, for Capital One. Y'all could have hither Wells Fargo. It's fine considering the Bank Label is no an important Label. The Account type is more important, you must match what you importing for. You lot are importing for Bank Account, then information technology has to be Checking or Savings. The Business relationship number is of import to check because if you lot are importing for this or that account, that y'all used incorrectly, you specified for the QBO file correctly. You may never employ the option 'Create a new Quickbooks business relationship' because you can not move transactions from one business relationship to another in Quickbooks, every bit in Quicken. Unless you lot really creating a new business relationship, then you would employ this option to create a new business relationship and import transactions there. But more often than not you created that business relationship before when you lot ready Quickbooks. So 99%, that you will select 'Apply an existing Quickbooks account' option. And you will run into hither only accounts matching this Account Type. Then if information technology is a Checking Bank account, then you would encounter simply Checking accounts. In this example, we will use the 'Checking Wells Fargo Bank' account. Select the Banking company Account and click the 'Continue' button.
You can ignore this message, it doesn't mean anything.
Now your Spider web Connect data has been successfully read into Quickbooks. Click the 'OK' push. So, the showtime part is washed.
The account we import into got dorsum yellowish strike icon. It happens when you import a QBO file. It means that linking is done to that Business relationship ID, Account Type, INTU.BID value. And then what happens if you import the second QBO file with the aforementioned Account ID, same INTU.BID value, same Business relationship Type, Quickbooks will not ask y'all to select an business relationship and volition import directly into this account. If you demand to import the QBO file with some other Account ID, but into that account for whatsoever reason, you have to disconnect it beginning. You have to edit the account, click on 'Bank Feed Settings' and select 'Deactivate All Online Services', click 'Salve & Close', 'OK'. And then continue with that QBO file.
In the second part, yous have to review transactions. Click 'Banking' - 'Banking concern Feeds' - 'Banking concern Feeds Center'.
'Wells Fargo Banking company' Label - ignore it if you are importing for another Bank proper noun. Pay attending to the Account ID. 'Checking at Wells Fargo Banking company' (or 'Majuscule Ane', or 'Credit Card', or 'Visa') is the name of your actual account in Quickbooks.
We have four transactions. Click on 'Transaction List' to review transactions.
Yous see, that 'Payee' is empty, just it is non empty on the actual QBO file.
And 'Downloaded as' column is a Payee from the QBO file.
You have to match each transaction to Vendor Record. For case, figure out 'No payee' (what it is?) - select 'Abode Depot'. Then yous have to select an expense/income account.
Information technology is a practiced idea before converting to go 'Vendor' - 'Vendor Center'.
And for each Vendor assign the default expense business relationship.
Correct-click - 'Edit Vendor'.
And so go to 'Account Settings' and tell which expense account to prefill when you enter bills for this Vendor. Allow's select 'Office Supplies'. Click 'OK'.
So, we have the 'Office Supplies' business relationship prefilled. Y'all can even so modify it, but if it is your regular Vendor and information technology is already classified, categorized, and then you would have by yourself actress-clicking, because yous already assigned it, as Vendor Record.
Then you lot continue doing information technology with all of them or some of them, really checking what y'all want to add to the register. Simply check once y'all select 'Add/Approve'.
If you see some transaction, that does not belong, or wrong, or you lot do non desire to import information technology, marker it and select 'Ignore'.
And then, you have to get all transactions out of hither. Allow's add the showtime one, for example. Click 'Yep'.
It offers yous to create a renaming rule, so for side by side time, when you import this, it volition be automatically selected 'Home Depot' for 'No payee'. For something, like 'Home Depot' 1, 2, 3, information technology is a skilful thought to create the post-obit rules. For something, like 'No payee' is not a good idea to create a renaming dominion. And then, you tin uncheck it, because 'No payee' could mean annihilation yous have to find actual payee, so you don't want it to exist automatically for the adjacent QBO import. And then click 'OK'.
Now, this transaction is gone and information technology is in the annals for that account.
Click 'Lists' - 'Chart of Accounts' - 'Checking at Wells Fargo Bank' and you'll encounter that transaction hither. So this way you lot can continue matching transactions. And so it volition be done. This is how you import and then match your QBO file.
Related manufactures
- Catechumen a CSV file to IIF and import into QuickBooks (2017)
- Convert a CSV file to QBO format and import into QuickBooks
- How to import a CSV file into Quickbooks Online
Source: https://www.propersoft.net/howto/import-qbo-quickbooks-win
0 Response to "How to Upload a Qba File Into Quickbooks"
Post a Comment