How to create a CSV file of historical Mortgage Payments

Question

I am setting up Quicken Classic and i want to back fill historical transactions. Among those are mortgage payments that i want to show as a decrease to a checking account and a payoff to a mortgage account. If you do this type of transaction with current downloaded data from the bank or manually enter the transaction, it shows as a transfer and the categories are [checking] and [mortgage] with no sub categories and the associated account balances are adjusted to reflect the transaction. If i try to  emulate this in a csv file for historical data it does not import as a transfer, it just creates a new category that shows as -checking- and -mortgage- and the transaction is labeled as expense, not transfer.

How do i structure the csv file to import transactions as transfers?

RJPiekos · Answer

Thank you. I have reached out to Chris_QPW to see of his program would be appropriate for this task.

splasher · Answer

I think a .QIF file import would work better.

Do a .QIF export of two of the transactions from the checking account involved since it will have all of the split lines involved to see the pattern that you need to emulate.

Create a small file of 2-3 transactions to test your setup first, then go for a larger file.

NOTE: MAKE A BACKUP FIRST AND MAKE THEM IN BETWEEN SUCCESSFUL BATCHES TO PREVENT HAVING TO START OVER COMPLETELY IS SOMETHING GOES WRONG.