Question about split transactions
in [Quicken]
|
From: Jose68 on 22 Dec 2009 22:36 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: Andrew on 23 Dec 2009 08:09 Jose68 wrote: > 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!! > > > For my telephone service, I use UTILITIES:TELEPHONE for the entire bill. For the cable people (like your example above), I use UTILITIES:CABLETV and implicit is that taxes and subservices (like internet fees which are part of the 'cabletv') are included. But it depends on what you do with your data. Do you really need to sub-analyze all the little pieces of a bill? Quicken makes it convenient (although in your case it doesn't have the ability to split a difference across categories as we've discussed), but at the end of the game, does one need to be so anal in that? If so, unfortunately, you need to do it manually. (Personally, I would never have a separate category for "Federal Universal Service Fund" or "State video fees". Why would I need to track it at that level? YMMV) -- ------------------------------------------------------------- Regards - - Andrew
From: Oilcan on 23 Dec 2009 13:08 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.simonplaza(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: Jose68 on 23 Dec 2009 16:32 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: Han on 23 Dec 2009 20:28
Jose68 <jose.simonplaza(a)gmail.com> wrote in news:7e3426eb-3ff2-4b80-a2e2- 62518d760110(a)x5g2000prf.googlegroups.com: > 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! What I have done in a few cases is use the calculator when entering amounts in a split window. I would multiply each part that is taxable (for instance) with 1.07, since Jersey now has a 7% salestax. -- Best regards Han email address is invalid |