How to add a bank account, which is closed already and therefore cannot be linked?

Hello, @karel-mergl-gmai.

When connecting your bank account with QuickBooks, you'd want to make sure that you have an active account. You need not worry, you can download your bank transaction and import it in QuickBooks using a CSV file. 

Here's the sample file format that for your visual reference:

• 3 Columns

• 4 Columns 

Here's an article you can read to learn more about how you can create a CSV file of your bank transactions: Import bank transactions using Excel CSV files.

Once you have created your file, here's how you can import your bank transactions:

1. Go to the Gear icon.
2. Under Transactions, select Imports.
3. Select Import older transactions.
4. Tap Browse.
5. Find and open the CSV file of your bank transactions.
6. Hit Open.
7. Click Continue.

See this article for more insights in uploading your bank transactions: Add older transactions to QuickBooks Self-Employed.

Once the transactions are added, you can start categorizing them to specify business expense categories:

• Categorize transactions in QuickBooks Self-Employed
• Handle duplicate transactions in QuickBooks Self-Employed

Know that the Community is always here to help you manage your self-employed business transactions. Have a great day!

Thank you for standard help reply number 3. Now, back to original question: "...account is closed,t cannot be linked." So, how do you create it in online QuickBooks?

Hi there, @karel-mergl-gmai.

Thanks for actively responding. QuickBooks will automatically create a Cash account to post your recently imported transactions.

The steps shared by my peer above will get you in the right direction. You'll want to rename the Cash account in the Banking page. Here's how: 

1. Go to the Settings menu, then select Bank accounts. 
2. Click the Pencil icon to rename the account. 
3. Enter the name of the bank in the field. 

For future reference, read through this article: Create rules to speed up reviews in QuickBooks Self-Employed. It helps you learn more about how to quickly categorize your newly added transactions in QBSE. 

Feel free to come back should you need more support. We're always delighted to assist you further. 

Hi,

     Thank you for the further explanation, but still there are issues. The Cash account was created, but it shows no transactions. I tried a few CSV imports yesterday. To my active accounts, it all worked. This CSV from the closed checking account, nothing. I just tried it again, but despite the QB system reading up 385 transactions, while telling me it skipped one due to duplicity, it does not put them in the Cash account. 

     So, not sure, how should I proceed now?

Thanks,

Kare Mergl

Hi,

    So, finally QuickBooks import returned an error message. I went back and corrected couple of the cells to fit proper format. Now, all is imported and that is great. Next step though is that the cash account stays as cash and does not show up on the list of bank accounts, which makes sense, but, where can I edit this account? Or better yet, its properties? 

Thank you,

Karel 

Good to hear that you're able to import the bank transactions, karel-mergl-gmai.

You can change how it is displayed through these steps:

1. Click the Gear icon in the upper-right corner and select Bank accounts.
2. Click the pencil icon next to the account name.
3. Click anywhere to save the changes.

You might also find this article helpful if you want to hide or delete an account: Delete a bank account in QuickBooks Self-Employed.

Please let us know if you need anything else.

Hi James,

     Problem is that the Cash account does not show up in the list of accounts. The list only shows the linked accounts, see attached.

    Where else should I look? 

Thank you,

Karel Mergl