SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends June 27

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
Mai3
Level 1

How to import excel/csv file on bank register?

I'm having a hard time inputting manually the entries for bank register under charter of accounts. Is there a way to import excel/csv file into bank register?

2 Comments 2
Mich_S
QuickBooks Team

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:

 

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!

Fiat Lux - ASIA
Level 15

How to import excel/csv file on bank register?

@Mai3 

Prepare your Bank Statement data with the following template

TxnDatePrivateNoteCurrencyExchangeRateDepositToAccountEntityLineDescLineAmountAccount
28/07/2020Manual Feed  CheckingJane SmithMonthly Dues25Account1
29/07/2020Manual Feed  CheckingBank of the WestJuly Fees-15Office Expenses
30/07/2020Manual Feed  CheckingStaplesPaper for Copier-50Office Expenses
01/08/2020Manual Feed  CheckingTeddy JonesCharitable Contribution500Account1

 

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

 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us