Question about split transactions
in [Quicken]
|
From: superjacent on 16 Nov 2009 00:21 On Nov 16, 11:39 am, "Andrew" <and...(a)jkl.com> wrote: > superjacent wrote: > > On Nov 15, 3:34 pm, Jose68 <jose.simonpl...(a)gmail.com> wrote: > >> Hello, > > >> I'm coming from Money, and there is only one thing that is bugging me > >> in Quicken: how to enter split transactions. Maybe there is a way to > >> do this in Quicken, but I can't find it! > > >> Let me use an example, an expense with two categories: > >> - Games - $25 > >> - Software - $35 > >> - Sales Tax - $7 > >> - TOTAL $67 > > >> In Money, I could type $67 as total, and once in the split window, I > >> could type $25 and $35, and let Money assign the difference ($7) > >> proportionately into all categories by pressing F6. Or I could assign > >> that difference to one single line item, if applicable, pressing F5. > > >> Is there something similar in Quicken? When I'm splitting a > >> transaction in 4 or 5 splits, it is a pain to have to calculate sales > >> tax one by one. > > >> Thanks! > > > You can do that in Quicken. At the register type in $67 and then > > click for splits. The first line in the split will be $67. If you > > then over-type the $67 with $25, the second line in the split will > > show the difference, and so on. > > > Hope this helps. > > How is this proportional allocating the different parts of the $7.00 sales > tax to each line as the balance goes down? I trust you might not have read > the subtle question! > > You're right in that as you delineate how much of the total should be on > each line, that doesn't do what the OP asked which is how to automatically > ALSO allocate the sales tax percentage to each line. > > To RC who also posted - I don't remember Q ever being able to do the > allocation of sales tax proportionally across the board, but it would be > nice - sometimes I allocate different purchases to different categories and > would also like to add the appropriate sales tax to each line without > manually calculating it like you mentioned in your other post. > > -- > ------------------------------------------------------------- > Regards - > > - Andrew You're right, I didn't read the subtle question.
From: Andrew on 16 Nov 2009 08:09 Jose68 wrote: > ... > I guess you can do it manually, but heck, computers are supposed to > make our lives easier!! :) http://quicken.intuit.com/support/feedback/ can be used to supply feedback; it's a good idea -- I should have asked for this years ago! I fact, I just did. -- ------------------------------------------------------------- Regards - - Andrew
From: Jose68 on 16 Nov 2009 10:32 On Nov 16, 5:09 am, "Andrew" <and...(a)jkl.com> wrote: > Jose68 wrote: > > ... > > I guess you can do it manually, but heck, computers are supposed to > > make our lives easier!! :) > > http://quicken.intuit.com/support/feedback/can be used to supply feedback; > it's a good idea -- I should have asked for this years ago! I fact, I just > did. > -- > ------------------------------------------------------------- > Regards - > > - Andrew I'll have to send my feedback too. It is really helpful, and should be really easy to implement.
From: Doug on 17 Nov 2009 21:51 Jose68 wrote: > > in Quicken: how to enter split transactions. Maybe there is a way to > do this in Quicken, but I can't find it! > > Let me use an example, an expense with two categories: > - Games - $25 > - Software - $35 > - Sales Tax - $7 > - TOTAL $67 > > In Money, I could type $67 as total, and once in the split window, I > could type $25 and $35, and let Money assign the difference ($7) > proportionately into all categories by pressing F6. Or I could assign > that difference to one single line item, if applicable, pressing F5. > > Is there something similar in Quicken? When I'm splitting a > transaction in 4 or 5 splits, it is a pain to have to calculate sales > tax one by one. > Yours is one of the many questions we see here that can be reworded as "why won't Quicken, an accounting program, let me violate all the rules of accounting and put any number I want wherever I want?" You did NOT spend $28 on games and $39 on software. You spent what you wrote. If you wish to pretend that money you spent on taxes was spent on software, be my guest. But why would you imagine Quicken would be programmed to facilitate faking the numbers? Doug
From: Jose68 on 18 Nov 2009 01:29
On Nov 17, 6:51 pm, Doug <Doug_Ell...(a)yho.com> wrote: > Jose68 wrote: > > > in Quicken: how to enter split transactions. Maybe there is a way to > > do this in Quicken, but I can't find it! > > > Let me use an example, an expense with two categories: > > - Games - $25 > > - Software - $35 > > - Sales Tax - $7 > > - TOTAL $67 > > > In Money, I could type $67 as total, and once in the split window, I > > could type $25 and $35, and let Money assign the difference ($7) > > proportionately into all categories by pressing F6. Or I could assign > > that difference to one single line item, if applicable, pressing F5. > > > Is there something similar in Quicken? When I'm splitting a > > transaction in 4 or 5 splits, it is a pain to have to calculate sales > > tax one by one. > > Yours is one of the many questions we see here that can be reworded as > "why won't Quicken, an accounting program, let me violate all the rules > of accounting and put any number I want wherever I want?" > > You did NOT spend $28 on games and $39 on software. You spent what you > wrote. If you wish to pretend that money you spent on taxes was spent > on software, be my guest. But why would you imagine Quicken would be > programmed to facilitate faking the numbers? > > Doug Thanks for enlightening me, Doug. Maybe you want to reword my question as you did, but that would be your question, not mine. But maybe because I have worked as an accountant myself, I neither consider Quicken an accounting program, nor I want to track my finances as I would do as an accountant. For example, I do NOT want to track sales tax as a different category. I want to allocate sales tax. And I am sure that a significant percentage of Quicken users are NOT tracking sales tax as a different category, nor they would want to. If I was to do as you seem to suggest, so "I don't fake the numbers" (good grief), I guess that if you purchased JUST the piece of software in the example about, you would create a split transaction to make sure you put $35 as software, and $4 as sales tax. What a pain. And what about expenses that I pay with my debit card and don't keep the receipt? Do I need to back-calculate the pre-sales tax portion and make a split for that? The more I think about this, the more I would like to keep my question as it was. I would like Quicken to make my life simpler, and help me allocate sales tax (or anything else I want to proportionally allocate for that matter) as Money does. And don't worry, if Quicken hears me out, you won't have to use it. It would be an option. You can keep tracking sales tax for all your purchases. But thanks for letting me know that I am violating accounting rules, and living around faked numbers. I never saw it that way. |