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?

    M
    MaryGraceSModerator
    Moderator
    March 26, 2019

    In my business client in QuickBooks 2016 Pro, 2 bank accounts are reflected Business Checking and Wells Fargo. Both are the same account number. When I import the qbo file it goes into the Business Checking for review of transactions etc. I want it to go into the Wells Fargo account. How do I provider proper steerage?


    Hi there, @GSCHMIDT.

     

    Thank you for joining the Community. I'd be happy to help share some information about importing the .qbo file to the correct account. 

     

    It's possible that when you set up the account for bank feeds, the bank connected to QuickBooks is Business Checking and not Wells Fargo. To fix this, you can disable and re-enable Bank Feeds to correct the settings. This way, the most current information will be posted to the accurate location during re-setup.

     

    To start, let's make sure to create a backup of your company file to protect against accidental data loss. After that, let me show you how to deactivate bank feeds for an account:

    1. From the Lists menu, select Chart of Accounts.
    2. Right-click the account that needs to be deactivated then select Edit Account.
    3. Go to the Bank Feed Settings tab.
    4. Select Deactivate all online services. You should get a confirmation that you have just disabled one or more online services for the account, but it does not cancel the services with the bank.
    5. Choose OK then click Save & Close.

    After that, make the necessary changes if there's any, then re-setup the account for bank feeds.

     

    Here's how: 

    1. From the Banking menu, select Bank Feeds.
    2. Choose Set Up Bank Feeds for an Account.
    3. In the Enter your Bank’s name field, enter the name of your bank. Note that as you type, QuickBooks displays possible matches.
    4. Click Continue.
    5. Enter your Direct Connect login credentials. 
    6. Select Connect.
    7. Select the bank account you want to connect to QuickBooks.
    8. Select Finish after the process completes.

    That should do it. You have now successfully activated online banking and can download the transactions in the correct account.

     

    I've attached an article for additional reference about this, as well as a series of basic information that covers about bank feeds in QuickBooks Desktop: Edit Bank Feed settings for bank or credit card accounts.

     

    Keep me posted how it goes. I'll be happy to help you further about importing bank feeds to the correct account in QuickBooks. Wishing you and your business success. 

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