Question about split transactions
in [Quicken]
|
From: Oilcan on 24 Dec 2009 11:53 Actually on my bill the CA Sales tax does only apply to the Cable portion - according to the second of the bill that provides the line of line itemization of the charges. So in my case, I would not split it out. I believe the tax is on the HD Tech Fee (although I think it is off a penny due to rounding). -----Original Message----- From: Jose68 [mailto:jose.simonplaza(a)gmail.com] Posted At: Wednesday, December 23, 2009 1:32 PM Posted To: alt.comp.software.financial.quicken Conversation: Question about split transactions Subject: Re: Question about split transactions Sounds reasonable. And I guess that, since sales tax is not much, it's ok to just add it to the cable category. But I assume it should apply to phone and internet too, right? I agree with John that spreading fees over all categories as I was doing was not the best way to handle it. Thanks! I'll simplify it, and I'll follow your advise. And I guess I'll do the same thing for G&E. I get a charge from "City of San Diego Franchise Fee Differential 1.03% Gas 5.78% Electric", which last month was $5.00, and I guess I'll need to split that between G and E. There are other charges that I was also spreading over both, but they can be identified as gas or electric easily. I guess the "proportionately allocate difference" feature from Money was making me have some bad habits :) Although I also like that for sales tax allocation! ;) On Dec 23, 10:08�am, "Oilcan" <oil...(a)nospam.net> wrote: > Hi Jose, > > Here is how I do my AT&T Universe Bill. �I basically looked at the > detail of the bill to determine where the fees and charges below and > have this as a memorized transaction. �As the bill generally does not > change (usually only the fees change) it works well for me. > > Cable � � � � � � � � �Memo: �Uverse TV U300 � � � � � � � $79.00 > Cable � � � � � � � � �Memo: �Promotional Discount � � � �($10.00) > Internet � � � � � � � Memo: �Yahoo! Broadband Elite � � � $20.00 > Job Expenses � � � � � Tag: Reimbursable Business Exp � � �$20.00 > Internet � � � � � � � Memo: �Bundle Discount � � � � � � ($10.00) > Telephone:Residential � � � � � � � � � � � � � � � � � � �$30.00 > Telephone:Residential �Memo: �Promotional Discount � � � � ($5.00) > Cable � � � � � � � � �Memo: �HD Technology Fee � � � � � �$10.00 > Cable � � � � � � � � �Tag: �CA Local Video Service Fee � � $4.19 > Cable � � � � � � � � �Tag: �CA Local Video Facilities Fee �$0.50 > Telephone � � � � � � �Tag: �Federal Universal Services Fee $2.00 > Telephone � � � � � � �Tag: �911 Emergency System � � � � � $0.09 > Cable � � � � � � � � �Tag: �CA Sales Tax � � � � � � � � � $0.84 > > I do a similar breakdown of other bills (cell, electric, garbage, etc.). > I used to enter tags on purchases, but found I never had enough to > deduct so for the most part I have stopped tagging those transactions. > The bundle discount probably could have been split between the Cable, > Internet and Phone, I just lumped it under Internet as my choice. > > > > -----Original Message----- > From: Jose68 [mailto:jose.simonpl...(a)gmail.com] > > Posted At: Tuesday, December 22, 2009 7:36 PM > Posted To: alt.comp.software.financial.quicken > Conversation: Question about split transactions > Subject: Re: Question about split transactions > > Jim, I agree. It all depends on how you want to track your finances. > > Now I have another example that's bugging me. I have my TV, phone and > internet with AT&T U-verse. The invoice is something like this: > > U-verse TV - �$79 > Broadband - �$35 > Phone - � � � �$25 > HD fee - � � � �$10 > CA local video fees - $7.01 > Federal Universal Service fund - $2 > Sales Tax - $1.68 > > It is a pain to manually distribute the CA local video fees, Fed > service fund and sales tax among my 3 categories: TV, internet and > phone. > > How do you guys categorize this in Quicken? > > In MS Money, it was "easy". I input the total bill, the first 4 items, > and the remaining amount (those $10.69) was magically and > proportionately split among those 4 items. Do you all have a category > for "Federal Universal Service Fund" or equivalent? �Or for State > video fees? �Or even sales tax? > > Thanks!! > > On Dec 19, 5:32�am, "Jim Nugent" <njim2k-etsn...(a)yahoo.com> wrote: > > Jose68 wrote: > > > But please, don't get this into an accounting discussion. It is much > > > simpler. I know that a lot of people adds sales tax to the same > > > category of the item being purchased. If splits are a feature of the > > > program, it just makes sense to give options for users to do things > in > > > a simpler way. > > > A long, long time ago, I used to take a gas station receipt that > included > > gas and a car wash, and split it into two pieces: Auto:Fuel and > > Auto:Maintenece. Now, I have three kids, a house, and too many demands > on my > > time. It goes in as Auto:Fuel. > > > A similar thing happens when I take a grocery store receipt and enter > it as > > "Groceries." It may include dishwasher detergent, paper towels, > tissues and > > what not, but I ignore that and just budget "Groceries" taking the > above > > into account. > > > How this is done depends on what I want to learn from my financial > records. > > That's probably different for different people. > > �-- > > Jim
From: Mr.Jan on 25 Dec 2009 11:34 On Nov 14, 11: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!
From: Mr.Jan on 25 Dec 2009 11:37
On Nov 14, 11: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! There is a SPLIT command when you click on the assignment field. The $67 shows up on the top line. If you assign the first line to GAMES and $25, quicken puts the remaining $42 as unassigned. Then, you do software and finall the SALES TAX for $7 which is the remainder. Then you memorize the transaction w control M and it will save the amounts or as a percentage. |