In the meantime, you can also search for available topics about banking from our resources posted in the Community. There you can find answered posts, related articles that might help resolving your concerns.

I'll be looking forward to hearing again from you and helping you, @NSF19. Take care!

G

GraceC

Hello there, @mimigreen.

Yes, you can manually add a bank account in QuickBooks Online. Let me guide you how.

From the left menu, click Accounting.
Select Chart of Account.
Click New, then fill out an Account Type, Detail Type, and Beginning Balance.
Select Save and close once finished.

Here's an article you can read to learn more about how you can manually add a bank account: Create subaccounts in your chart of accounts in QuickBooks Online.

I've got you this article more insights in case you wanted to match and categorize your bank, please refer to these articles:

Keep me posted in the comment section down below if you have any other questions. I'm always around happy to lend a helping hand.

G

GenuineRex

Can I add a bank account manually and connect it later? My bank is having issues with the QB connection but they do support a connection. I would like to ad manually, post transactions, and match them up later when the connection is working.

R

J

jamespaul

Hello, R.

I'm down to help you add your bank transactions manually.

Certainly! You can manually import your bank transactions using a .CSV file into QuickBooks Online. Here's a step-by-step process:

Download a specific date range for your bank transactions.
Once done, log in to your QuickBooks Online account then go to Banking.
Click the down arrow icon beside Update, then choose File upload.
Hit the Browse button, then look for the .CSV file you downloaded.
Proceed with Next.
Choose the account where you want to upload the transactions to, then click Next.
Map the QuickBooks Online fields with your .CSV file, then continue with Next.
Review the transactions, then hit Next. Click Yes when prompted to successfully import them.

You can read this article for more details about uploading your transactions: Manually upload transactions into QuickBooks Online.

We can address the connection issues of your bank. Can we have the complete name? We can look at the reported cases specific to it, and provide you with updates or workarounds.

After adding the transactions, you can start categorizing or adding them into your books. When you're done, you have the option to start reconciling your bank statement.

I'd recommend reading this article for a reconciliation guide: Reconcile an account in QuickBooks Online.

We're more than happy to answer your questions about the Online Banking feature. You can also ask us additional questions about the areas in QuickBooks Online.

7

78101135276086

I need expenses, income and sales from my previous quickbooks o be imported to my new accou as well as to add another bank account too

M

mv32

Thanks for joining the thread to get help with importing transactions, @78101135276086.

You can use your bank data to import expenses, income, and sales. What you'll have to do is to check the starting and ending date of the transactions from your previous QuickBooks account.

Once done, make sure to get the transactions from your bank and ensure that it correlates with the dates of the entries that you wish to import in QuickBooks.

Here's how:

Sign in to your bank's website.
Follow your bank's instructions to download CSV files.
Check the date range of the download.
Download the entries and save them somewhere you can easily see them, like on the Desktop.

Once you have the transactions, ensure it's in a CSV file type and organized accurately. If the file size is over 350 KB, you may have to cut it short by trimming the date range or getting the transactions in smaller batches. You can check the format (3-columned) that I'm using:

When it's alright, you can import the bank data in QuickBooks. You'll have to be absolute with the column mapping and date arrangement to ensure you upload the file successfully.

Here's how:

Click the Gear icon on the top right and then select Import data.
Choose Bank Data.
Tap the select files link.
Pick the file to upload and hit Open.
Select Continue.
Choose your new account and then hit Continue.
Map the rows, columns, and date format correctly, then Continue.
Include the transactions by checking the boxes.
Once finished, select Continue, then hit Yes.

You'll be able to upload them seamlessly and add, match and categorize them into your new bank account register. For more information, you can reference this article for a detailed guide: Manually upload transactions into QuickBooks Online.

On the other hand, you can add another bank account by going to the Chart of accounts. You can follow these steps for a quicker guide:

Go to the Accounting menu from the left panel.
Select Chart of accounts and then click New.
Choose Bank as the Account Type and then select the Detail Type.
Enter other details.
Click Save and close.

You can also connect your bank account from your Chart of accounts to QuickBooks Online.

Let me know if you need more assistance with importing transactions from your previous QuickBooks account or adding accounts in QuickBooks. I'm always here to help. Keep safe and have a lovely day ahead!

Sign up

Login with SSO

Login to the community

Login with SSO