Question: how to import bank transactions in excel into quickbooks?
Answer: Click the File menu, then go to Utilities.
Click Import, then choose Web Connect Files.
Choose the QBO file, then click Open.
When prompted to choose bank account, choose Use an existing QuickBooks account if the account is already set up or Create a new QuickBooks account if it's not yet added.
Click Continue.