Steps for Uploading Bank Transactions in Quickbooks

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.

bank1

 

7. Following screen will display:

bank2Select the Company on which you are working.

 

8. On the right hand side of the screen, Bank Accounts will be displayed:

bank3Select the appropriate Bank Account.

 

9. On the right hand side, select Update  File Upload:

bank4

 

 

10. Browse to select the csv file which was earlier created. Click Next:

bank5

 

 

11. Select the Account wherein tansaction needs to be uploaded. Click Next:

bank6

 

12. Following screen will be displayed. Check the selections as per your csv file. Then Click Next.

bank7

 

 

13. Select the transactions to import. Click Next.

bank8bank9

 

 

14. Following dialogue box appears. Click Yes.

bank10

 

 

15. Click Finish

bank11

 

 

If you have any query regarding this Click Here.

Leave a Reply

Your email address will not be published. Required fields are marked *


*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>