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

How can ik book the bank manual in quickbooks ?

 
3 Comments 3
Jelayca V
QuickBooks Team

How can ik book the bank manual in quickbooks ?

Hi, Marc. It's great having you here in the QuickBooks Community.             

 

QuickBooks Online (QBO) has a feature that lets you connect to your bank using your online banking login details. This feature automatically imports your bank transactions into QBO, simplifying their management and reconciliation.

 

Before you can set up this connection, you must first create your bank account in QBO. To do this, here's how:

 

  1. Click the Gear icon, then Chart of accounts.
  2. Select New to open the Account dialog.
  3. In the Account Type dropdown, select Cash and cash equivalents.
  4. Give the account a name and an optional description.
  5. Indicate whether this is a sub-account of another account.
  6. Enter the opening Balance of the account as of the date you specify.
  7. Finally, click Save and Close.

 

Once done, you can proceed connecting it to your bank. You will need your bank login credentials to do this, as you will have to log in to your bank's website to establish the connection. You can connect your account either from the Bank transactions page or from your Chart of accounts.

 

From the Bank transactions page:

 

  1. Hover over to the Transactions menu, then Bank transactions.
  2. On the Bank transactions page, click on Connect account. If you have already set up an account, select Link account instead.
  3. Look up and choose your bank from the list provided.
  4. Enter your login credentials and authorize QuickBooks to access your account.
  5. Choose which accounts you want to link to QuickBooks from your bank or credit card provider's list. If you need to create a new account, select +Add new
  6. Finally, select Connect to connect the process.

 

Through the Chart of Accounts:

 

  1. Go to the Chart of accounts page and locate the account to connect.
  2. Select Connect bank from the Account history dropdown list.
  3. Follow the prompts to complete the process for connecting your bank account.

 

QuickBooks will automatically download transactions up to a certain date. You can select a specific date range if you need fewer transactions. If your bank can’t connect to QuickBooks, you can still upload your transactions manually.

 

For more details and information, you can refer to this article: How to connect bank accounts and manage imported transactions in QuickBooks Online

 

Additionally, you can visit this article to learn how to add, match, and manage transactions in QBO: Add and match downloaded banking transactions.

 

Don't hesitate to reach out to us if you have further questions about the bank accounts and transactions in QBO. I'll be here to get back to you. Keep safe. 

marcdijkhuizen-p
Level 1

How can ik book the bank manual in quickbooks ?

Thanks, it is impossible to connect my bank to Quickbooks.

I hope I can download all the transactions from the beginning and than upload them in Quickbooks.

Can I delete bank transactions when I upload them in Quickbooks ?

RCV
QuickBooks Team
QuickBooks Team

How can ik book the bank manual in quickbooks ?

Thanks for coming back, marcdijkhuizen-p. Let me help you with downloading your bank transactions in QuickBooks Online (QBO). 

 

You can use the Request support for your bank option if your bank is not listed as a participating financial institution for QBO integration. Then, ask us to add your bank and the support request will depend on the agreement between Intuit and your bank.

Here's how:

 

  1. Click Banking in the left menu.
  2. Choose Banking.
  3. Click Add Account in the upper-right corner.
  4. Enter your bank or a URL. If you get the message, Hmm, we can’t find [name of the bank you entered] in our list of supported banks be presented with helpful tips to try finding your bank again.
  5. If you’re still unable to find your bank, click Request support for your bank.
  6. Enter your bank's web address (URL) in the field provided.
  7. Click Request.

 

For more details about identifying the correct bank, you can check out this article: Find your bank or credit card account when you connect to online banking. In the meantime, you'll want to manually upload bank transactions through a CSV file format or other file formats that QBO supports. You can go to your bank's website and follow the instructions on how to download them. From there, you can download all the transactions from the beginning and upload them to the program. I recommend the following articles which cover this process and contain the required steps:

 

 

On the other hand, you can delete the transactions uploaded from your bank account. We'll need to exclude the uploaded transaction first before you can delete it in the system. To exclude, here's how:

 

  1. Go to the Banking menu, then choose the Banking tab.
  2. Scroll down to select the For Review tab.
  3. Select the checkboxes of the transactions to exclude.
  4. Click the Batch actions drop-down button, then choose Exclude Selected. (Please refer to the screenshot below)

 

Once done, it will transfer to the Excluded tab for your reference. From there, you can select the transaction by putting a check mark beside it, then select Delete on the Batch actions button. (Please refer to the screenshot below). For detailed steps and further information about excluding a transaction in QuickBooks, you can check out this article: How to Exclude Expenses from Downloaded Bank Transactions.

 

That'll keep you going. Should you have further banking concerns or downloading your bank entries, let me know by leaving a comment below. I'm just around if you need help.