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. 

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.

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.

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.

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.

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.

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?

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

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:

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.