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

Add a Bank Account Manually

I am trying to manually add a new bank account (RBS Business credit card) to QB Self Employed. The account has no online access so I can’t follow the normal account set which insists on trying to  log onto a bank website. How do I do it?

Solved
Best answer January 16, 2020

Accepted Solutions
Highlighted
QuickBooks Team

Add a Bank Account Manually

Hi Awgphoto,

 

You cannot upgrade from a Self-Employed package, it would be a case of just taking out a new simple start package and then canceling your self employed account. 

View solution in original post

9 REPLIES 9
Highlighted
Moderator

Add a Bank Account Manually

I'll share with you the two options on how you can manually add your bank account, @awgphoto

 

First, you can import bank transactions using a CSV file since your RBS Business credit card has no online access. I'd suggest contacting your bank to verify if they allow you to export transactions to this file type. Once confirmed, the file must be formatted correctly and saved on your computer. Then, start the importing process below. 

  1. Go to the Settings (Gear) 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 finish importing your data.
  6. Click Import.

 

The screenshot below shows you the first four steps. For detailed instructions, check out this article: Import Transactions From Other Sources

ImportTransactionsUsingCSVFile.PNG

 

Once done, the transactions will go into the cash account. With this, you'll need to review and assign them to the correct categories from the Transactions tab. For more information, check out this article: Categorising Bank Transactions

 

The second option is to manually add transactions in the program. This lets you enter all of your income and expenses from your RBS Business credit card account. For detailed steps, go through this article: Manually Add Transactions in QuickBooks Self-Employed

 

You can always visit this website: Banking Overview. This is a resource hub that contains articles to help you effectively manage your bank transactions in the system. 

 

I'll be around to help if you need further assistance. Have a good day, @awgphoto.

Highlighted
Level 2

Add a Bank Account Manually

Thank you for the response. I have been able to export .csv file from CardsOnline Commercial (RBS Business Credit Card) and import as Other Transactions. Unfortunately, these only go into the CASH account.

 

How do I manually add a new account (RBS Business Card) and assign these imported and future transactions to this account? I don't understand why this is not an obvious option. All other accounting packages I have used allow this.

Highlighted
QuickBooks Team

Add a Bank Account Manually

Hi awgphoto

 

If you do not have an account connected and attempt to upload an Excel file it will allocate the information to the cash account, you are unable to manually create an additional account.

Highlighted
Level 2

Add a Bank Account Manually

OK. If I can't change the account after importing the .CSV file, then HOW do I manually create an empty account?

 

I would then want to import transactions from .CSV or manually into this newly created account. I can not make clearer than that. Every time I click Add New Account it only allows me to name a bank and go through the online connection process.

Highlighted
QuickBooks Team

Add a Bank Account Manually


Hi awgphoto

 

You are not able to create an additional account within the self employed account. Then only time an additional account is created is when when you connect a bank account. Importing a CSV, when there is no existing bank connection, will not create an additional account an will allocate the CSV/transactions to the cash account.

Highlighted
Level 2

Add a Bank Account Manually

Why not? That is a vital part of the functionality.

 

I was sold the Self-Employed as I was told it would met my needs. It does not. I assume you can create accounts yourself in the Simple Start package? How do I upgrade?

Highlighted
QuickBooks Team

Add a Bank Account Manually

Hi Awgphoto,

 

You cannot upgrade from a Self-Employed package, it would be a case of just taking out a new simple start package and then canceling your self employed account. 

View solution in original post

Highlighted
Level 3

Add a Bank Account Manually

Hi @RaymondJayO 

 

I saw your solution however having a similar issue.  I cannot connect to my bank same as this user so I have to do it manually.  My bank allows CSV files which I did. However, when trying to load them, I get the error, “Invalid File format”.  You mention that the file should be formatted correctly.  Can you advise how the file should be formatted in order to import the information?  I’m subscribed to QBO Plus.

 

Thanks

Highlighted
QuickBooks Team

Add a Bank Account Manually

I have the steps on how you can map the fields, deycomin.

 

When you import a CSV file, QuickBooks Online uses either a 3-column or 4-column format.

  • 3-column template has columns for the Date, Description and the Amount of the transaction.
  • 4-column template has the Date column, Description, and both a Credit and a Debit column.

I've got some sample screenshots for a visual guide:

 

bankfile1.JPG bankfile2.JPG bankfile3.JPG bankfile4.JPG bankfile5.JPG


To successfully import your bank transactions, please make sure not to include any special characters. I've got an article here for reference: Import bank transactions using Excel CSV files.

 

Please let me know how it goes. I'll be around to help you some more. Thanks.