Skip to main content
September 19, 2024
Question

How do i import bank statements to a bank in chart of accounts

  • September 19, 2024
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

September 19, 2024

Thank you for reaching out with your questions, usercontact25. I'm happy to guide you step-by-step to ensure everything goes smoothly.

 

To import bank statements into a bank account in the Chart of Accounts in QuickBooks Online, follow these steps:

 

  1. Prepare Your File: Ensure your bank statement is in a supported format, such as CSV, QFX, or OFX.
  2. Navigate to Banking:
    • Go to the Banking menu from the left navigation panel.
    • Select the Link account dropdown and choose Upload from file.
  3. Upload Your File:
    • Click Browse and select the file you downloaded from your bank.
    • Choose the account you want to upload the transactions into from the list, then click Continue.
  4. Map the Fields:
    • Follow the on-screen instructions to map the fields in your file to the correct fields in QuickBooks.
    • Select the transactions you want to import and click Yes.

 

Once imported, review and categorize the transactions appropriately in the For Review tab and add them to your books.

 

Additionally, ensure to reconcile your accounts to keep them accurate and up-to-date.

 

Great! You’ve successfully imported your bank statements into QuickBooks Online. If you have any further questions or need additional assistance, please don’t hesitate to reach out. We’re here to help you make the most of your QuickBooks experience. Have a wonderful day!