How can I convert an account from "asset" to "cash"

Bertilak

I created an account years ago and mistakenly created it as an asset instead of as cash.

Can I convert this from "asset" to "cash"?

Sherlock

If you just want the Asset account to be included with other Spending accounts, open the Asset account register, press Ctrl + Shift + E, select the Display Options, Spending in the Account intent pull-down menu.

If you want to recreate the Asset account as a Cash account, I suggest you add a Cash account, move the transactions from the Asset account to the Cash account, reset any reminders and memorized transactions referring to the Asset account, delete the Asset account, and rename the Cash account.  You may want to review: FAQ: How Do I Move Transactions Between Quicken Accounts?

Sherlock

Bertilak said:

Sherlock and Squirrel,

Thanks! My first thought, before I posted here, was to export the account as a QIF then import it after deleting the original account and editing the QIF to change the first line from
!Type:Oth A
to 
!Type:Cash

Might that be more reliable? Will it actually work?

It's feasible but less reliable than simply creating the Cash account and moving the transactions.

Bertilak

Sherlock said:

Bertilak said:

Sherlock and Squirrel,

Thanks! My first thought, before I posted here, was to export the account as a QIF then import it after deleting the original account and editing the QIF to change the first line from
!Type:Oth A
to 
!Type:Cash

Might that be more reliable? Will it actually work?

It's feasible but less reliable than simply creating the Cash account and moving the transactions.

Sherlock,

I did that -- created a new cash account and moved the transactions. This worked but with a complication. If a transaction to be moved is part of a split transaction Quicken will not move it.

I dealt with that by doing a restore, removing that part of the split and making it a separate transaction, then redoing the move. Once the move was complete I recreated the split. That part did not really NEED to be done as the two, now separate, transactions kept things properly balanced. but I wanted to keep the split in its original form to more accurately reflect what actually happened.  All is now well.

Rocket J Squirrel

You cannot change the account type from Asset to Cash.

What you can do is create a new Cash account and move all the transactions into it from the Asset account.

Sherlock

If you just want the Asset account to be included with other Spending accounts, open the Asset account register, press Ctrl + Shift + E, select the Display Options, Spending in the Account intent pull-down menu.

If you want to recreate the Asset account as a Cash account, I suggest you add a Cash account, move the transactions from the Asset account to the Cash account, reset any reminders and memorized transactions referring to the Asset account, delete the Asset account, and rename the Cash account.  You may want to review: FAQ: How Do I Move Transactions Between Quicken Accounts?

Bertilak

Sherlock and Squirrel,

Thanks! My first thought, before I posted here, was to export the account as a QIF then import it after deleting the original account and editing the QIF to change the first line from
!Type:Oth A
to 
!Type:Cash

Might that be more reliable? Will it actually work?

I guess I could make a copy of the whole QDF file, give the above a try, then restore the QDF if it doesn't go well. I will try that now!

I'M BACK ---

It didn't work. So I restored the original QDF file. I will need to investigate more.

The original account had about 150 transactions but after re-importing it there were only about 21. A mystery.  I couldn't identify anything unique about the transactions that were (or weren't) skipped on the import. The QIF file seemed normal but that's one of the things I need to look closer at.

Sherlock

Bertilak said:

Sherlock and Squirrel,

Thanks! My first thought, before I posted here, was to export the account as a QIF then import it after deleting the original account and editing the QIF to change the first line from
!Type:Oth A
to 
!Type:Cash

Might that be more reliable? Will it actually work?

It's feasible but less reliable than simply creating the Cash account and moving the transactions.

Rocket J Squirrel

It's not feasible if you have any Attachments or Notes on any transactions. Those cannot be transferred via QIF. Just do it within Quicken as advised.

Bertilak

Sherlock said:

Bertilak said:

Sherlock and Squirrel,

Thanks! My first thought, before I posted here, was to export the account as a QIF then import it after deleting the original account and editing the QIF to change the first line from
!Type:Oth A
to 
!Type:Cash

Might that be more reliable? Will it actually work?

It's feasible but less reliable than simply creating the Cash account and moving the transactions.

Sherlock,

I did that -- created a new cash account and moved the transactions. This worked but with a complication. If a transaction to be moved is part of a split transaction Quicken will not move it.

I dealt with that by doing a restore, removing that part of the split and making it a separate transaction, then redoing the move. Once the move was complete I recreated the split. That part did not really NEED to be done as the two, now separate, transactions kept things properly balanced. but I wanted to keep the split in its original form to more accurately reflect what actually happened.  All is now well.

Bertilak

Sherlock said:

Bertilak said:

Sherlock and Squirrel,

Thanks! My first thought, before I posted here, was to export the account as a QIF then import it after deleting the original account and editing the QIF to change the first line from
!Type:Oth A
to 
!Type:Cash

Might that be more reliable? Will it actually work?

It's feasible but less reliable than simply creating the Cash account and moving the transactions.

Sherlock,

Moving the transactions to a new cash account worked but with a complication. If the transaction  to be moved is part of a split transfer from another account Quicken will not move it.

I fixed this by un-splitting the transaction, doing the move, and then reconstructing the split. All is now well.