How to Proceed With QuickBooks Import Bank Transactions

QuickBooks Import Bank Transactions

When you are into QuickBooks, the very first thing you look forward to is importing your bank transactions. Of course, it is essential to make sure you have all your transactional details and data available with you whenever you require it.

There are two processes that can be adopted while importing bank transactions into QuickBooks. One is automatic import while the other is manual import.

Process 1: Import bank transactions automatically into QuickBooks

Locating your bank

1. On the Homepage, select Transactions
2. Choose Banking from the left menu bar
3. Click the QuickBooks Online Banking tab
4. Type your bank name and select the bank from the available list

Log into your bank account

1. You will have the login screen in front of you
2. Enter user ID and password

Select bank accounts

1. Put a tick mark on the checkboxes beside the account/accounts you want to connect with QuickBooks
2. From the drop-down for Account Name, select the QB account you want to link to your respective bank accounts
3. If you have not yet setup your QB account, you can select Add Account from that drop-down itself
4. Complete the fields that you get:

Account type – Bank or Credit Card account
Detail type – You can specify more details about the account
Name – Account name that will appear when you open with QuickBooks
Description – Bank name and account type
Check the details you have entered

1. Click Save
2. Click Close button

d.Select the correct data range.

Click Connect and all your transactions will be downloaded to your QuickBooks account

Review the transactions to check the downloaded file

How do I Export from Quickbooks to Excel

Process 2: Import bank transactions manually into QuickBooks

1. From the left menu bar, select Transactions and Banking
2. This will take you to the banking center
3. Select Upload a File
4. Browse to locate the file and choose the file to be uploaded
5. Select the QuickBooks account in the next step. If the account is not there, select Add New from the drop-down menu as in Process 1 (c)
6. In the next step, enter the data into the fields – Account type, Detail type. Name, Description
7. Click Save
8. Click Close
9. Map the fields to avoid discrepancy with the field name in the bank account columns
10. Select the banking transactions by ticking in the respective checkboxes
11. Click Next
12. Your transactions will be downloaded

Though the steps are clearly mentioned above, you might find difficulty in following either one of them or maybe all of them if you doing it on your own. This is where our experts come into the scene.