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. Select the account your must have created earlier. Step 2. Now look for the File upload button at the top right corner of the screen. Refer to below image. Step 3. Now click on Browse and select the QBO file and then click open and next. Step 4. Ensure to review your QBO file by filename, account id and type, and date range, etc.
Step 5. If everything seems fine, click on next to import your QBO file, and after that click on Next. Step 6. Herein you will have to categorize the transactions and match them to vendors. The above process will help you out, in seamlessly completing the import of QBO file, but let us also look into some frequently asked questions to have a little bit more clarity on related issues and queries.
Looking for a professional expert to get the right assistance for your problems? Here, we have a team of professional and experienced team members to fix your technical, functional, data transfer, installation, update, upgrade, or data migrations errors. We are here at Dancing Numbers available to assist you with all your queries. To fix these queries you can get in touch with us via a toll-free number or chat with experts.
Now select the saved QBO file and click on Open. Now switch to single-user mode from the file option and click on export and export the data to excel and at last click on OK. QBO file is nothing but a kind of web file used by QuickBooks software, it comprises the electronic bank statement that is downloaded from the online banking website.
Both the files are used to exchange financial information over that internet by QuickBooks. Bulk import, export, and deletion can be performed with simply one-click. A simplified process ensures that you will be able to focus on the core work.
Click on 'Transaction List' to review transactions. And the 'Payee' column is empty. It shows Vendor Records. Once Vendor Records and Account are set, you can add transactions to the register. The rename rule creation dialog will show up after to use for the next time. 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.
0コメント