1. Download the Bank Statements using Online Banking Website in PDF format.
2. Convert the Bank Statements from PDF to excel/ csv format using any software like Adobe
Acrobat XI.
3. Delete those transactions which are already appearing in Quickbooks and identify transactions
which are yet to be uploaded.
4. For those transactions which are yet to be uploaded, prepare a csv file containing the following
3 columns:
1) Date in format MM/DD/YY
2) Description
3) Amount: All debit amounts should be negative and all credit amounts should be
positive.
5. Go to website: qbo.intuit.com
6. Enter User ID and Password to Sign In.
7. Following screen will display:
Select the Company on which you are working.
8. On the right hand side of the screen, Bank Accounts will be displayed:
Select the appropriate Bank Account.
9. On the right hand side, select Update File Upload:
10. Browse to select the csv file which was earlier created. Click Next:
11. Select the Account wherein tansaction needs to be uploaded. Click Next:
12. Following screen will be displayed. Check the selections as per your csv file. Then Click Next.
13. Select the transactions to import. Click Next.
14. Following dialogue box appears. Click Yes.
15. Click Finish
If you have any query regarding this Click Here.