cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
Magdalena-Allan
Level 1

I can see my bank in reconciliation drop down, it does not appear in bank transaction tab, I cannot upload the CSV file my manager ask me to upload to reconcile bank

I can see my bank in reconciliation drop down, however, it does not appear in bank transaction tab. I cannot upload the CSV file my manager ask me to upload to reconcile bank. I do not have access to online banking hence loading from CSV file

1 Comment 1
Jessavell_A
QuickBooks Team

I can see my bank in reconciliation drop down, it does not appear in bank transaction tab, I cannot upload the CSV file my manager ask me to upload to reconcile bank

Once your bank is not connected to QuickBooks, it's normal that you can't see it on the Bank transactions page, Magdalena.

 

The accounts in the Bank transactions page are meant for downloading and reviewing transactions, which is what bank feeds do. If an account was never connected, or the connection was disabled/expired, it won't appear there, even if it exists in your books.

 

However, you can still manually upload your transactions even if your bank is not connected. This process allows you to select your existing bank account from the Chart of Accounts to upload a CSV file.

 

Here are the steps to manually upload your transactions:

 

  1. If your account isn't connected yet to online banking, select Upload transactions. If you already have a bank connected, select the Link account ▼ dropdown, then select Upload from file.
  2. Upload your CSV file.
  3. In the Select account ▼ dropdown, select the account you want to upload the transactions into.
  4. Match the columns in the file with the corresponding fields in QuickBooks, then select Continue.
  5. Select the transactions you wish to import, then click Continue.
  6. Choose Yes, then select Done.

 

After uploading your transactions, categorise them based on how you classified similar transactions in the past. Then, you can proceed with reconciling your bank account.

 

If you have any further questions, please feel free to revisit this thread.