How to import excel/csv file on bank register?

It's good to see you here in the Community, @Mai3.

I know a way on how you can import transactions in your bank register inside QuickBooks Online.

To begin, you'll need to choose a start date. Also, you'll need to know the date of the account's oldest existing transaction. This way, you can avoid recording duplicate transactions.

Here's how you can do it:

1. Select the Accounting menu and go to Chart of Accounts.
2. Locate the bank or credit card account you want to upload the transactions into.
3. Click on View register.
4. Locate and enter the date if the oldest transaction. The opening balance is usually the oldest transaction.

After that, follow the steps 2 through 6 in this article: Manually upload transactions into QuickBooks Online. This will make it easier for you to upload transactions manually.

I'm also adding some helpful articles to guide you with accessing, managing, and printing reports in QBO:

• Customize reports in QuickBooks Online
• Run reports in QuickBooks Online

Reply to this thread if you have other concerns with QuickBooks or questions related to importing. I'm always here to assist. Have a nice day!

@Mai3 

Prepare your Bank Statement data with the following template

then utilize an importer tool

https://transactionpro.grsm.io/qbo

Otherwise, utilize a converter app to get the QBO file and import it into your QBO account.

https://www.moneythumb.com/?ref=110