How to force "split transaction" to post multiple entries to one "category" ?

Unknown · June 2020

Hello fellow Quicken fans. I often will make multiple transactions with unique memo/amount to one category in a line item. Sadly Quicken lumps the multiple transactions together and shows only one entry to the category and shows the first memo. Is there an option somewhere to report both entries? Thank you ! Char.

Split Transaction
[AR - Chq & eTransfer] 2020-05-31 Cheques from Till $100.00
[AR - Chq & eTransfer] 2020-05-31 eTransfers from Till $500.00

Reports
[AR - Chq & eTransfer] 2020-05-31 Cheques from Till $600.00

Chris_QPW · June 2020

Sorry but it has been a long standing bug/feature that split transfers to the same account are grouped together. In fact if you look at "AR - Chq & eTransfer" you will set there is only one transaction on that side.

I suspect it has something to do with how the transactions/links to other accounts are recorded in the database and such unlikely to be changed.

NotACPA · June 2020

Actually, if you use different TAGS on the split lines in the originating transaction, the 2 split lines (with the differing tags) will show up as 2 lines in the receiving account.

I do that all the time in my mortgage payment, where I want part of the Escrow amount to reflect as Real Estate tax and part as Homeowners Insurance.

Image: https://us.v-cdn.net/6031128/uploads/editor/96/fmn4qct77uit.png

Image: https://us.v-cdn.net/6031128/uploads/editor/aw/yimv33m06fo5.png

NotACPA · June 2020

I took out this mortgage, as a refi, a couple of years ago. It was the first time in MANY years that an Escrow account was required.

In general, I HATE ESCROW ACCOUNTS, but since it was required, I wanted to track it's 2 components accurately (since the lender's ALMOST ALWAYS get the amount needed wrong). For example, they'll calculate the amount needed for RE Tax about 1-2 months before the local government changes that amount. There's the same problem re: my Homeowner's Insurance.

SO, I fumbled around a bit before I stumbled over this trick. I had noticed elsewhere that separate tags in a split would produce 2 lines in the target ... so I gave it a try.

Chris_QPW · June 2020

Sorry but it has been a long standing bug/feature that split transfers to the same account are grouped together. In fact if you look at "AR - Chq & eTransfer" you will set there is only one transaction on that side.

I suspect it has something to do with how the transactions/links to other accounts are recorded in the database and such unlikely to be changed.

Unknown · June 2020

What is the procedure to report Quicken system "bugs" ? or requests for enhancements ?

Chris_QPW · June 2020

For a feature request you post your question as an Idea and it will get a Vote bottom so that people can vote on the idea.

For a bug:
Help -> Report a problem... (note there isn't any feedback with this)
You might also report a problem to Quicken Support.
Contact Quicken Support

volvogirl · June 2020

You could run them through an intermediate holding account.

Set up an account and call it something like Checks Received or Undeposited Payments. Then enter the payments into it. Then when you make the deposit to your bank account you transfer the total deposit amount to the new account. That way when you download your bank transactions the deposit will match. Or you should use the holding account if you receive payments in one year (like in Dec) but don't make the deposit until the next year (like Jan.).

You don't run to the bank each time you get a check. So you need a holding account so you can show the income when you received it. Then you wait until you get a bunch of checks to go to the bank.

NotACPA · June 2020

Actually, if you use different TAGS on the split lines in the originating transaction, the 2 split lines (with the differing tags) will show up as 2 lines in the receiving account.

I do that all the time in my mortgage payment, where I want part of the Escrow amount to reflect as Real Estate tax and part as Homeowners Insurance.

Unknown · June 2020

Quicken Community ROCKS !!!
I'll work to report this as a "bug" or at least a "request for enhancement"

Chris_QPW · June 2020

@NotACPA Wow that is interesting! I would have never guessed that would work like that.

NotACPA · June 2020

I took out this mortgage, as a refi, a couple of years ago. It was the first time in MANY years that an Escrow account was required.

In general, I HATE ESCROW ACCOUNTS, but since it was required, I wanted to track it's 2 components accurately (since the lender's ALMOST ALWAYS get the amount needed wrong). For example, they'll calculate the amount needed for RE Tax about 1-2 months before the local government changes that amount. There's the same problem re: my Homeowner's Insurance.

SO, I fumbled around a bit before I stumbled over this trick. I had noticed elsewhere that separate tags in a split would produce 2 lines in the target ... so I gave it a try.

Unknown · June 2020

> @NotACPA said:
> Actually, if you use different TAGS on the split lines in the originating transaction, the 2 split lines (with the differing tags) will show up as 2 lines in the receiving account.I do that all the time in my mortgage payment, where I want part of the Escrow amount to reflect as Real Estate tax and part as Homeowners Insurance.(Image)

BIG THANK YOU to all the Quicken Community !!!
THIS IS THE ANSWER THAT WORKS FOR ME !!!
I did not understand how TAGS could help me... but this is it !!!
In my split, if I have multiple lines for one category, I'll add a unique tag.

NotACPA · June 2020

@Charlene If you use the same tag twice, in that originating transaction, it WILL combine into a single line in the receiving account.

It's the differing tags that's the trick.

How to force "split transaction" to post multiple entries to one "category" ?

Best Answers

Answers

Howdy, Stranger!

Categories