I have a category with a slew of subcategories starting under "HOUSEHOLD" (children would be items such as MAINTENANCE, FURNISHINGS, UTILITIES, etc"). I rented an apartment for a few years, so I've tagged those as "CINCINNATI" so they can be listed separately in a transaction report under the HOUSEHOLD expense category.
Now, I am moving and my default blank tab I'd like to have as my new location. Thus, I'd like is to do a massive FIND/REPLACE for the category and children under "HOUSEHOLD" with ONLY those tags that are currently blank. That way I can then tag them with "OLDHOUSE" so the untagged ones created in the future are the new house and the "CINCINNATI" tags remain.
Didn't find your answer? Ask the community — no account required.
J
John Pollard
Possibly. First:
Are the transactions in question in one Quicken account, or multiple accounts?
Are any of the transactions in question in an investment account?
Are any of the transactions in question split transactions.
A
Andrew
Hi John.
Mostly in one main checking account, I probably could deal with the others manually.
Don't think so, but if they have tags, again I could deal with these roque ones manually I would suspect.
This is probably true, but hopefully not to a great degree. I can see myself having splits in transactions to Lowes or Home Depot that I mark partially home related, for example.
I have over 1,000 of these transactions.
My Plan "B" is to leave things alone, and just remember prior to move day that TAGed blanks are 'old house' and after would be 'new house'.
J
John Pollard
With the exception of transactions in investment accounts, the process should be relatively straight forward (assuming I fully understand the issue).
I would use the All Transactions pseudo-register to make it possible to find and change as many transactions as possible in one process.
Use CTRL-f Find All to find all the transactions that contain "HOUSEHOLD" in the Category field.
The height and width of the resulting "Search Results" dialog box can be changed. and columns shrunk/expanded, where desired to get a more accurate picture of the transactions found.
You can sort the results by most, if not all, the Found fields; I suspect sorting on Tag would make the process easiest.
You can then use the Select column to select the transactions to be modified (noting that the top-level Split transactions will have "--Split--" in the Category column - you can, and should, ignore those rows). [Holding down the SHIFT key while clicking the first and last of a group of rows works like selecting multiple files in Windows Explorer.]
The actual split lines will be displayed in blue with the text "SPLIT" followed by the split line number. Those can be selected where appropriate. Naturally, the non-split transactions can also be selected.
When you have Selected all the transactions you want to modify, click the Edit Transactions button in the lower-right.
At the foot of the resulting Find and Replace dialog is a "Replace" dropdown and a "With" dropdown. Choose "Tag" in the Replace dropdown, and choose your desired new Tag value from the With dropdown (if you wanted to replace a non-blank Tag with a blank Tag, you would just key a Space in the With field.
Then click the Replace All button.
J
John Pollard
I should have added: backup first.
A
Andrew
Really? :-)
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required
Report Content
You are reporting this content to the moderators. They will look at it
ASAP.