Bank2QBO (Windows): Convert CSV/Excel/PDF/OFX/QFX/QBO/QIF/MT940/STA to QBO/IIF/CSV
See a step-by-step tutorial at https://www.propersoft.net/howto/bank...
This tutorial shows how to convert a transaction file to QBO format. We will use Bank2QBO utility. IMPORTANT: Bank2QBO is discontinued and replaced with a new Transactions app (https://www.propersoft.net/products/t..., that converts from more formats and converts to more formats.
00:00 - Download Bank2QBO
00:26 - Start Bank2QBO and select a file with transactions
00:49 - Review transactions before converting
01:07 - Sample PDF file (example)
01:41 - Set the Bank INTU.BID
02:46 - Set the Account ID
03:43 - Set the Account Type
03:54 - Set the Currency
04:30 - Set End Balance, Bank ID, Branch ID
04:45 - Convert to QBO file
04:55 - Switch to Quickbooks and disconnect from online services before importing
05:20 - Import a QBO file
05:34 - Select the account to import into
06:09 - Review the transactions
06:18 - 'Downloaded As' column
06:24 - 'Show Bank Memo' option
06:33 - 'Payee' and 'Account' column
06:50 - Add transactions to the register
Please subscribe: https://www.youtube.com/subscription_...
Step by step instructions for Windows:
Use ProperSoft Bank2QBO to convert CSV/Excel/PDF/QBO/QFX/QIF/OFX/MT940/STA files to QBO/IIF/CSV (Web Connect) format and import into Quickbooks (Window/Mac/Online). Download it and make sure you are using the latest version of the Bank2QBO.
Start Bank2QBO and select the transaction file (it could be QBO file, OFX file, QFX file, QIF file, PDF file, MT940 file, or STA).
Review transactions before converting, check that dates are correct, have the correct year, deposits, and withdrawals are assigned correctly.
Set INTU.BID number to match your bank or use a default value. The INTU.BID value defines the bank label shown during a QBO import in Quickbooks. It has to be from the allowed bank. You can try to locate your bank, make sure a bank you choose supports the account type you are converting for. Keep the default value if your bank is not listed (3000-Wells Fargo or any allowed bank).
Set the Account ID (number) and the Account Type. Account ID must be all digits for Quickbooks. For multiple accounts, use a different Account ID for each account.
Currency should be USD even for non-USD accounts for Quickbooks US edition. For the Canadian edition, you can use USD and CAD. And for the UK edition, GBP currency must be set. If you have non-USD, you have to use another converter, for example, Bank2IIF converter, that does not have currency and you can import for a non-USD account. Bank2IIF converts to IIF format instead of the QBO format.
You can also set End balance, Bank ID, Branch ID if your accounting software requires it.
Click the 'Convert' button to create a QBO file.
Confirm the file name and location.
Import created QBO file into Quickbooks:
Now the QBO file is created, let's switch to Quickbooks and import created QBO file. Before importing a QBO file make sure that the account you need to import into doesn’t have the yellow strike icon. Click 'Lists' - 'Charts of Accounts'.
Because if you have the icon, it means the account is online linked to direct download. You need to disconnect first to import a QBO file.
To disconnect, right-click - 'Edit Account'.
Then click on 'Bank Feed Settings' and 'Deactivate All Online Services' first if needed. Check there is no yellow icon after the change. After disconnecting the account from online services, you can import a QBO file.
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. Then click the 'Continue' button.
Now your data is imported.
Click on 'Transaction List' to review transactions. Assign Vendor Records and expense/income accounts before adding transactions to the register.
'Downloaded as' column shows Payee names from the QBO file.
Click 'Show Bank Memo' to see the description to the 'Bank Memo' column.
Once Vendor Records and Account are set, you can add transactions to the register.