locked
NatWest Download RRS feed

  • Question

  • I have Money Version 14 running on Windows 10.

    I download my banking transactions from NatWest into Money and I find that my MasterCard transactions are posted to my Current Account in Money, not MasterCard Account. I just cannot find where to correct this.

    If I download to a spreadsheet the transactions are correctly identified as MasterCard transactions which suggests that the error is within Money.

    Can anyone help please? Thank you.

    Sunday, January 1, 2017 12:46 PM

All replies

  • Keep an extra backup in case you want to undo something.

    If OFX Web statements are wrongly placed in the Natwest account, blank the
    Financial Institution (FI) for the *Natwest* account in account
    settings.  Do that in the Account Settings/Details, which you can
    reach by right-clicking the account name on the Account List.  Don't
    just change the FI.  Blank it using the Delete or Backspace keys.

    On the Account List, if there are transactions to read for the
    wrong account, right-click TransactionsToRead, and then click
    Delete Statement.

    Import the OFX file.  Money should ask which account to use.  Tell
    Money the statement should go onto the right account.

    Put the FI for the *wrong* account back.


    If that does not fix it, see method 2 of
    http://support.microsoft.com/kb/910214 where you temporarily
    change the currency of the wrong account.


    Friday, January 6, 2017 6:18 PM
    Moderator
  • I have had similar problems with NatWest recently and now I am also getting a communications error message from Money when I try to download the OFX file.  Tried the first solution which did not overcome the communcations error message to enable me to nominate the account the statement should go to.  Cannot go to method 2 because the MS website returns a message to say the page does not exist.
    Tuesday, January 24, 2017 2:44 PM
  • I have had similar problems with NatWest recently and now I am also getting a communications error message from Money when I try to download the OFX file.  Tried the first solution which did not overcome the communcations error message to enable me to nominate the account the statement should go to.  Cannot go to method 2 because the MS website returns a message to say the page does not exist.

    Don't download the OFX file with Money. Instead download with IE.

    Fortunately I saved the contents of that knowledge base article:

    ===========text from old wrong account KB:========================

    SUMMARY
    When downloading your online statements from your financial institution, your accounts may have incorrectly been assigned to your existing Money accounts. This article describes how to break the association with the current Money account and then re-associate the online statement downloads to the appropriate Microsoft Money account.


    MORE INFORMATION
    When downloading your online statement information into Microsoft Money, your financial institution may have different statement offerings. Review the following methods and choose the one that best fits your situation.

    To re-associate a Web statement to the appropriate Money account, use the following methods in the order that they appear in.
    Method 1
    To break the current association of a Web statement to your Microsoft Money 2005 or later account, follow these steps: 1.Start Money.
    2.Click the Banking tab.
    3.Under Account List, locate the account that is incorrectly linked to the Web statement. If you have a downloaded statement to read for that account, Right-click on transactions to read and then click Delete Statement.
    4.Click the Banking tab, and then click Manage online services, in the left pane.
    5.Click Specify where accounts are held, click the account in the list that is associated with the Web statement, and then click Move Account.
    6.In the Move Account dialog box, click Not held at a financial institution, click OK, and then click Done.
    Once you have moved the account to Not held at a financial institution, you will then need to download the Web statement from the financial institution's Web site.
    To re-associate a Web statement to the appropriate Money 2005 or later account, follow these steps: 1.Download the latest Web statement again from the financial institution's Web site.
    2.You will receive an Import a file dialog box that requests that you re-associate the file. Click the correct account in the drop down list, and then click Next.
    3.In the Import Summary dialog box, click OK.
    4.Verify whether the Web statement information has been transferred to the correct account
    If Method 1 does not resolve your issue and you do not receive the following error message, go to Method 2:
    A communication error occurred. Please try your call again. If you continue to have problems call your financial institution's Online Services Customer Support.


     For more information, click the following article number to view the article in the Microsoft Knowledge Base:
    829143 How to troubleshoot problems downloading statements from your financial institution's Web site into Money
    Important Sometimes these steps may not resolve the issue. When you try to import the Web statement, you may receive an error message that is similar to the following:
    A communication error occurred. Please try your call again. If you continue to have problems call your financial institution's Online Services Customer Support.
    If you receive this error message, reassign your accounts to the correct financial institution. To do this, follow these steps: 1.Start Money.
    2.Click the Banking tab, and then click Manage online services.
    3.Click Specify where accounts are held, click the account in the list that is associated with the Web statement, and then click Move Account.
    4.In the Move Account dialog box, click Held at, type the name of the financial institution in the list, and then click OK.
    5.Repeat for each account you need to reassign.
    6.Click Done two times after all the accounts have been assigned.
    Note Under certain circumstances, you may have already accepted all the transactions from the latest Web statement. If this is the case, use one of the following methods:Download another Web statement from your bank that contains the latest information, and then continue with the steps that are listed in Method 2.
    Delete at least one of the last accepted transactions that are incorrectly associated with the account. Then, continue with the steps that are listed in Method 2.

    Method 2
    If the steps that are listed in Method 1 does not resolve the issue, you can change your account currency settings to force Money to enable you to re-associate your account. To do this, follow these steps: 1.Start Money.
    2.On the Account list , right-click the account that the statement is incorrectly being imported into, and then click Account Details.
    3.Change the Currency from US Dollars or your current currency selection to anything else.
    4.Click Done.
    5.On the Tools menu, point to Internet Updates, and then click Update Now. This will perform an update of your online quotes and exchange rates.
    6.When the update is completed, close Money.
    7.Start Money.
    8.Try to import your online statement. You will receive a warning message that states that the currencies do not mach. Click OK.
    9.Import your statement again. You are prompted to select the account that you want to import the information into.
    10.When the import is completed, follow steps 2 through 4 to change your currency back to US Dollars or your previous currency selection.

    Method 3
    To re-associate an OFX statement to the correct Microsoft Money account, delete the downloaded statements, turn off online services for the account, and then turn them on again. To do this, follow these steps:
    Step 1: Delete online statements from your account list
    To delete online statements from your account list, follow these steps: 1.Open Money.
    2.Click on the Banking tab.
    3.Locate the account that has an incorrect statement associated with it.
    4.Right-click Transactions to read next to the account name.
    5.Click Delete Statement . All downloaded transactions that you have not yet verified are deleted.
    After you have deleted the statement, it is time to turn off your online services.
    Step 2: Turn off online services for the account
    To turn off online services for the account, follow these steps: 1.To avoid unnecessary service charges, contact your bank, broker, or other service provider and ask to cancel the services. To find the contact information for your bank or broker: a.On the Money navigation bar, click the Banking tab.
    b.Under View banks and brokerages, on the left, click the name of the bank or broker that you want to contact.
    c. Under View contact information, click the name of the bank or broker.

    2.On the Money navigation bar, click the Banking tab, click Account tools and then click Manage Online Services.
    3.Click on the financial institution that you want to turn off online services for.
    4.Click Stop using online services. Follow the online steps to complete the process of turning off online services.

    Note If online services are turned on for more than one account at one financial institution, you may have to follow the steps in the "Step 2: Turn Off Online Services for the Account" section for each of those accounts to turn off all of the online services for that financial institution.
    After you have completely turned off online services for your financial institution, you can then re-setup services. During the setup process, ensure you carefully match the downloaded accounts with the imported accounts fro your financial institution.
    Step 3: Turn on online services for the account
    To turn on online services for the account, follow these steps: 1.Open Money
    2.On the Money navigation bar, click the Banking tab, click Account tools and then click Manage Online Services.
    3.Locate the financial institution you want to setup for online services.
    4.Under To do click Set up online services.
    5.Follow the instructions in the wizard to setup your online services. When asked if these are new or existing accounts, ensure you choose existing and match the accounts up accordingly to the accounts you already have setup in Money.


    Properties

    Article ID: 910214 - Last Review: 12/09/2015 03:38:54 - Revision: 3.0

    Tuesday, January 24, 2017 2:51 PM
    Moderator
  • Unfortunately none of the above methods have resolved the issue.  NatWest deny it is them even though on another account associated with HSBC Money will still read their OFX files.  Perhaps I will have to put up with the loss of this feature and as Money gets older I am certain more and more functionality will be compromised until someone steps in with a new piece of money management software that is a real replacement for MS Money (RIP).
    Monday, January 30, 2017 9:54 PM
  • How are you downloading the OFX data? Are you saving the files to your hard drive, then opening them?

    What exactly is the download error?


    Bob - MSN Mobile

    Monday, January 30, 2017 10:25 PM