FAQ: How do I convert a loan account that automatically downloads transactions, to a manual entry/sc

Unknown
Unknown Member
edited May 4 in FAQ'S (Windows)
Updated, UKR, 5/2021
  • It's my understanding that effective with Quicken Windows 2018+
    you can deactivate an online-connected loan account and regain full control over your transaction register.  However, you should still review the Scheduled Reminder (or Memorized Payee List entry) associated with the monthly loan payments to ensure they now transfer Principal to the loan account register and not to a Category.
  • If that doesn't work for you or if you use an older Quicken version please read and follow the instructions in the remainder of this discussion.

Comments

  • Unknown
    Unknown Member
    edited December 2020
    The very first thing is to make a backup of your data file, so that if something goes wrong you can restore to this copy.

    Next create a new "manual" loan account (look for the manual link at the bottom where they ask for financial institutions, see first image below).

    Now put in your loan information as if you were first setting it up (with the past starting date and amount). Please note in Quicken 2013 they have different loan types. In the past it didn’t seem to matter which loan type you selected, but in Quicken 2013 they seem to do different kinds of calculations (see second image below).

    Once you have this manual loan account setup, go to that manual loan account and select Payment Details.

    Delete any transactions Quicken put in (There should be an opening balance, and a balance adjustment).

    Next you'll want to deactivate your downloaded loan account. Right click on the account and select edit/delete account > online services > deactivate. 

    Select Ctrl+H
    For the Field to find select category.
    Select Exact for the second field.
    Select the old loan account that is setup with the automatic transactions download in the next field (It will have square brackets around its name)(You may need to also type this field in manually as you see it in your account bar).
    Select Find
    Select "Select All".
    For Replace select category for the first field.
    For With select your new manual loan account.

    Select Replace All. Note it will warn about not making replacements in splits, but don’t worry about that comment, the replacements did happen.
    Select Done.



      Go to the first transaction in the new manual loan account.
    Change the category to manual loan account name (as found in the Transfers section). Move the amount that is in the Decrease column to the Increase column, and save it.

    Hopefully now you have your new manual loan account. Your old automatic download loan account should have no transactions in it and you can delete it.


This discussion has been closed.