Bringing in an existing bank account

I understand you want to upload transactions from your bank, @Danielle. Don't worry. I can show you the best way to pull up your banking transactions from the existing beginning balance to your QuickBooks Online account.

Through manual upload, we can import older transactions. We usually download this file from your bank. Before you can upload it, we must ensure the data is in the correct format.

Furthermore, you can import a maximum of 350 KB file size. You can download it in smaller sets if you want to import more than that.

Follow the steps below:

1. Go to Banking, then select Bank Transactions.

2. Select the blue tile for the account you want to upload.

3. Pick the Link account dropdown and then Upload from the file.

4. Choose Drag and Drop or select Files and select the file you downloaded from your bank. Then select Continue.

5. In the QuickBooks account dropdown, select the account you want to upload. Then choose Continue.

6. Follow the onscreen steps to match the columns on the file with the correct fields in QuickBooks. Then select Continue.

7. Select the transactions you would like to import. Then select Continue.

Select Yes.

8. When you accept your transactions, select Done.

After uploading them, you can review the uploaded files and categorize them. Refer to this page for your guide: Categorize online bank transactions.

Once done, reconcile them to help your book balance and track accurately. You may visit this article: Reconcile an account in QuickBooks Online.

By following these steps, you can start an existing bank account in QuickBooks with an accurate beginning balance for the current year and manually enter transactions as needed. If you encounter any issues or need further assistance, we are here to back you up, @Danielle. Take care.

I have done all that my bank does not go beyond three months so I only have from oct-dec.  However the bank account has a starting balance since it was opened before 2023.  I can manually add the transactions from jan to sept that is not a problem I do not know hot to start a new quickbooks company with a starting balance. (meaning how do I manually put the starting balance in)?

I have figured it out Thank you

Hello there, @Danielle. Allow me to guide you on manually inputting the beginning balance in QuickBooks Online (QBO). 

Having an organized and accurate chart of accounts is crucial for maintaining accurate financial records. When it comes to accounts that affect your Balance Sheet, it's necessary to ensure that you enter an opening balance. 

Here's how you can manually set a starting balance for a new QuickBooks company: 

1. Ensure you know the amount you must enter for your opening balance.
2. Go to Settings and select Chart of accounts.
3. Select New, then set up your account.
4.  Pick the date you want to start tracking your finances in the open balances section. 
5. Then, enter the account balance for that date and hit Save.

Once you have done this, you can start tracking new transactions in QuickBooks that come after the opening balance date. In case you have already been tracking transactions and skipped opening an opening balance, you can still enter an opening balance later on. 

Furthermore, we have here some handful articles that might be helpful to you in the future: 

• Categorize online bank transactions in QuickBooks Online.
• Set up bank rules to categorize online banking transactions in QuickBooks Online.
• Reconcile an account in QuickBooks Online.

Please feel free to reach out to me if you have any further queries regarding managing opening balances in QBO. I'm always here to help you out. Have a great day.