cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Visit this post for a list of recent banking issues in QuickBooks Online.
carol42
Level 1

Can i manually add a bank account instead of having a live feed to my bank?

 
Solved
Best answer February 12, 2020

Accepted Solutions
GeorgiaC
QuickBooks Team

Can i manually add a bank account instead of having a live feed to my bank?

Hello carol42, 

 

 

You can certainly choose to do this if you do not wish to connect your account directly. 

 

To do this, go to Accounting > Chart of Accounts > New, and select the Account type as 'Cash at Bank and in hand' and the relevant detail type. You can then rename the account here under '* Name' and enter an opening balance (the balance of your bank account when you began recording transactions in QuickBooks Online).

 

You can then either enter the transactions manually or import the transactions from a CSV file, which will allow you to use the Banking page in the same way as if there was a live connection by adding and matching transactions. 

 

You can see how to import the the transactions using a CSV file on the link below: 

 

https://quickbooks.intuit.com/learn-support/en-uk/help-article/import-transactions/add-older-transac...

 

 

Thanks 

 

 

View solution in original post

6 REPLIES 6
GeorgiaC
QuickBooks Team

Can i manually add a bank account instead of having a live feed to my bank?

Hello carol42, 

 

 

You can certainly choose to do this if you do not wish to connect your account directly. 

 

To do this, go to Accounting > Chart of Accounts > New, and select the Account type as 'Cash at Bank and in hand' and the relevant detail type. You can then rename the account here under '* Name' and enter an opening balance (the balance of your bank account when you began recording transactions in QuickBooks Online).

 

You can then either enter the transactions manually or import the transactions from a CSV file, which will allow you to use the Banking page in the same way as if there was a live connection by adding and matching transactions. 

 

You can see how to import the the transactions using a CSV file on the link below: 

 

https://quickbooks.intuit.com/learn-support/en-uk/help-article/import-transactions/add-older-transac...

 

 

Thanks 

 

 

carol42
Level 1

Can i manually add a bank account instead of having a live feed to my bank?

Thank you so much Georgia, that is very helpful.

nickynacks
Level 1

Can i manually add a bank account instead of having a live feed to my bank?

So I take it this cannot be done in Self-Employed?

 

RaymondJayO
Moderator

Can i manually add a bank account instead of having a live feed to my bank?

Yes, you're correct, @nickynacks. The steps shared by my peer above apply to our online version. But I can provide the alternative methods in Quickbooks Self-Employed (QBSE) to help you achieve your goal. 

 

First, you can import bank transactions using a CSV file since there's no live feed to your bank. I'd recommend contacting their support team to confirm if they support this file type. Once verified, you'll have to format it correctly and save it to your computer. Please take note that the transactions will go into the cash account in QBSE. Then, proceed with the importing process below. 

  1. Go to the Settings (⚙) icon at the upper right.
  2. Select Imports.
  3. Click Import transactions
  4. Choose Browse to upload the file from your computer. 
  5. Follow the onscreen instructions to upload the CSV file.
  6. Click Import.

 

For the detailed instructions, check out this article: Import Transactions From Other Sources

 

Second, you can manually add your bank transactions in the program. Just click Add transaction from the Transactions tab. See the screenshot below for your visual reference. 

 

As always, you can categorise and edit your bank transactions from the Transactions tab. You'll have to select PersonalBusiness, or Split as the type, and choose the appropriate categories for them. This way, we can ensure your financial records are correct. To learn more about this process, visit this article: Categorising Transactions

 

You can count on me if there's anything else you need. Keep safe always, @nickynacks.

chs143
Level 2

Can i manually add a bank account instead of having a live feed to my bank?

I have QBSE and I need help adding a bank account. I currently do not have online banking (it would be an extra $15.99 a month and I am just starting out, so it's unnecessary to have that additional expense).

 

Since I have just a handful of transactions, I would prefer to input them via CSV file, but I don't want them showing up as cash transactions. I have looked at all the help articles and it seems as all of the imports will come up as "cash." Is this ok from a bookkeeping standpoint? ALL my transactions would be "cash." If done this way. Even though I rarely use cash. I use my bank card primarily for all my purchases.

 

When I follow your directions to go Settings > Imports > Import Older Transactions

It won't let me upload any files. I can't even browse my files. Is this because I have no bank account added? I'm really frustrated with trying to get this figured out.

 

Thank you so much in advance! I'm hoping this all works out because otherwise I could've just stayed doing my bookkeeping in excel.

SarahannC
Moderator

Can i manually add a bank account instead of having a live feed to my bank?

Hello there, chs143. Thanks for posting here.

 

It looks like a duplicate post, and I have shared a few details about the transactions that are posted as Cash account in QuickBooks Self-Employed. You can check this link to review the complete details: https://quickbooks.intuit.com/learn-support/en-us/banking/i-have-qbse-need-help-adding-a-bank-accoun....

 

Also, the program allows to import older transaction even you don't have any account connected into QuickBooks Self-Employed. We can go ahead and double-check the Downloads folder on your desktop and other location. If the file doesn't appear, you can download the transactions again and re-import them.

 

Let me know if you have other questions. Take care always.

Need to get in touch?

Contact us