Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
J
JeffLyden
January 28, 2019
Question

Importing into wrong checking account.

  • January 28, 2019
  • 1 reply
  • 0 views

How do I tell QB Desktop to import transactions into a particulat checking account? It's putting them into the wrong account.

    1 reply

    BettyJaneB
    BettyJaneB
    Level 9
    January 28, 2019

    Hi there, @JeffLyden.

     

    It's nice to have you in the Community today. I'd be glad to assist with downloading your bank transactions to the correct account.

     

    If the transactions are coming from your bank, you'll need to reach out to our financial institution to verify why is it showing on the incorrect account. This is because QuickBooks is only dependent on the transactions that were transmitted from your bank. 

     

    However, if the transactions are from a third party application, you'll need to check on the settings to map the accounts correctly. QuickBooks Desktop does not receive data through automatic sync since it's an offline product. Data is instead exported to an Intuit Interchange Format (IIF) file, which you will then download and upload it to your QuickBooks Desktop account.

     

    To learn more about importing files in QuickBooks, please check out this article: Import Intuit Interchange Format (.IIF) files. 

     

    There you have it!

     

    Please let me know if you're referring to something else by replying into this thread. I want to make sure everything is accurate on your end. Have a good one!

    J
    JeffLydenAuthor
    January 30, 2019

    I'm using a 3rd party IIF file. When I import the file with the checking account open I thought it would import into that account. But instead, it created a new checking account (or possibly it was an original account that set up with the new company) and uploaded there. How do I upload to my selected account? Should i remove the other account? Is there a way to choose my intended account by default?

    BettyJaneB
    BettyJaneB
    Level 9
    January 30, 2019

    Hello, @JeffLyden.

     

    I appreciate the details that you've given. Allow me to provide additional insights into this concern.

     

    When importing an .IIF file into QuickBooks Desktop if the account is already existing, transactions will automatically be posted into their designated account. If the account is not recognized by QuickBooks, this will create a new account.

     

    For now, I'd suggest opening your .IIF file on an excel and see if the accounts there are correct. If you're seeing an incorrect account you can edit it so it will be identified by QuickBooks. If you've verified that all accounts are correct, I'd recommend reaching out to your Third Party Service Provider. This is to ensure that your accounts will be mapped accurately upon importing. 

     

    Also, you can merge the newly created account to the new one to consolidate all transactions without needing to enter transactions again one by one and update information as needed.

     

    I've included some helpful articles about importing .IIF file in QuickBooks Desktop for your reference: 

    This amount of information should get you moving today, Jeff.

     

    Please let me know if you need further assistance with this matter. I'll make sure to get back to you as soon as I can. Have a great day!

    Need QuickBooks guidance?
    Log in to access expert advice and community support instantly.
    Terms & ConditionsAccessibility statement