Skip to main content
carol42
Feb 12, 2020 12:20 PM UTC
Solved

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

Original commenter did not share additional details
GeorgiaCAnswer
Feb 12, 2020 1:24 PM UTC

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-transactions-quickbooks-self-employed/L0jWhUMA1_GB_en_GB?uid=l7fsgshk

 

 

Thanks 

 

 

View in thread

6 replies

GeorgiaCAnswer
Feb 12, 2020 1:24 PM UTC

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-transactions-quickbooks-self-employed/L0jWhUMA1_GB_en_GB?uid=l7fsgshk

 

 

Thanks 

 

 

carol42Author
Feb 12, 2020 1:30 PM UTC

Thank you so much Georgia, that is very helpful.

nickynacks
Jul 25, 2020 10:01 AM UTC

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

 

RaymondJayO
Jul 25, 2020 11:44 AM UTC

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 Personal, Business, 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
Nov 28, 2020 7:52 PM UTC

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.

Terms & ConditionsAccessibility statement