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.
In the Split transaction screen, I enter each taxable item's actual price, then press * (for multiply), enter 1.0825 on the numeric keypad, and press Enter. (Our combined State and local sales taxes are 8.25%.) So, for a $39.95 item - like the Quicken 2010 Deluxe that I bought last month, my keystrokes were: 39.95 * 1.0825 - and Quicken calculated the $43.25 (after rounding) and entered it, then went to the next Split line.
It might be easier for someone like me, with over 50 years experience on
10-key adding machines, and it can get tedious on those few transactions when I need to split the tax between more than 3 or 4 lines. But I rarely find it a problem.
I think there is an automatic allocation feature, but I don't recall ever having used it.
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.
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?
I don't know where you studied accounting, but you apparently misunderstood what you were taught.
An expense - or an asset purchase - includes all the costs necessary to get the item into your possession and ready to use. Depending on the type of product acquired, those costs might include freight, shipping and handling, installation, commissions paid by the buyer...any of many kinds of expenditures. AND taxes levied on the buyer for the transaction, such as sales taxes paid to the seller (for transmission to the state) or use taxes paid directly to the state for items purchased sales tax-free (for resale or from another state in some cases) but on which the use tax must be paid.
A much longer lesson is available, Doug, but this should suffice for today.
University of Connecticut, many years ago. I understand aggregation of separate costs to form a larger cost, such as in Cost of Goods Sold.
But the way I was taught, sales tax does not add to an asset's valuation. If I bought a $10,000 truck and paid $1,000 State Sales Tax, I would debit $11,000 from my bank account, create a $10,000 asset, and book a $1,000 expense for Sales Tax. Is that not correct?
I believe that for OP to wish to distinguish his computer game expenses from his software expenses, but not his tax expenses, is whimsical. He has every right to be whimsical in his bookkeeping if he wishes, but there's little reason for Quicken to have been programmed that way, is there?
I'm actually having a hard time thinking of a situation in which one would capitalize a point-of-sale Sales Tax payment. Maybe there is one.
I understand the impulse to fold the sales taxes paid to the State into the "cost" of the purchase. Now that Sales Tax is generally not federal deductible, there's little benefit for an individual to track the expense. One could just as easily IGNORE the taxes, too, and (using Quicken's feckless terminology) simply not categorize that portion of the split instead of apportioning them.
Many of my purchases involve a mix of taxable and non-taxable items. So when for example I'm splitting a Costco bill, I might have some portion categorized as groceries, some as clothing, and some as medicine. In my state, groceries aren't subject to sales tax, so if Quicken apportioned the sales taxes to all the split categories, that would be incorrect also.
But I still come back to the notion that Quicken can't be expected to read my mind. It has to be programmed with some conventions in mind, and the conventions Intuit used are vaguely based upon bookkeeping principles. My recollection is that this thread began with a new Quicken user asking why Q didn't let him do something that Microsoft Money did let him do. The only reasonable answer is that Intuit didn't write the software that way because they didn't think anyone would/should want to falsely categorize an expense.
Sometimes it's hard to recall that Quicken was designed as a checkbook program. It took a very pragmatic approach, ignoring accounting theory in many ways.
I practiced public accounting in California for 18 years (1962-1980) and had plenty of experience with the sales tax, both professionally and personally. Then I lived and practiced in Oklahoma for 10 years; the sales tax rules were mostly the same. Now I've been in Texas for nearly 20 years, but retired, so my experience here is only personal, not professional - but the general sales tax rules are still similar. "Groceries" are not taxable, but meals and some prepared foods are. As you said, a Quicken programmer would have to deal with "dozens of categories" in trying to program automatic allocation of sales taxes - and then we users would have to classify each multi-item purchase receipt to match those! Can you imagine how much WE would gripe about that inconvenience?
Tax laws are written by legislators - and very few of those are accountants. That's why so many corporations have to keep more than one set of books. One set is kept according to accounting principles developed over centuries by accountants who were trying to report accurately the results of business activities. The other set is kept according to laws, which are concerned with producing tax revenues and - more and more in recent decades - with motivating taxpayers to act in certain ways that lawmakers want us to behave. These tax provisions very often do not conform with accounting principles! They don't have to make sense; they are the LAW! :^{
Even if tax laws allow you to deduct the sales tax you pay on your new car or computer or shirt or candy bar, the tax on that transaction is still a part of the cost - to you - of buying that property.
Accounting theory has evolved over the centuries, but I suspect that, even at the "University of Connecticut, many years ago", that is what was being taught in accounting theory classes. That's what I was taught at the University of Oklahoma in the 1950's (BBA in Accounting, 1956). And I'm pretty sure that is what today's students are learning.
OK - Dad always said "when 2 people tell you you're drunk, go to bed", so I'll agree I was wrong about the undesirability of allocating sales tax expenses to the accounts of the goods being purchased.
I still don't understand why anyone using Quicken would find this useful. If one is going to go to the trouble of finely categorizing their purchases, why not categorize the tax expenses, too? Do they blend their FICA and income tax back into their salary? But I don't need to understand why someone would wish to do so, and needlessly described doing so as "wrong". To the OP: sorry.
TomYoung wrote: > there's actually lots of > situations where you'd capitalize sales taxes.
So, in my truck situation, I'd amortize the sales tax over the life of the truck? I guess I can see that, although I don't like it. The truck loses value over time, for sure, but the one-time expense of the sales tax is incurred all at once and is a function of the purchase action, not the life cycle of the good purchased. Knowing what to capitalize and what to expense was always more art than science if I remember correctly. But one factor was, I thought, whether or not the item/service being acquired had some enduring value. I can re-sell the truck, but I cannot transfer any worth to another person once I've paid the state its sales tax. The "value" of the disbursement instantly dissipates.
I seem to recall living in jurisdictions where "children's" clothing was untaxed and "adult" clothing was taxed. Silly, and fraud-provoking.
OK - Dad always said "when 2 people tell you you're drunk, go to bed", so I'll agree I was wrong about the undesirability of allocating sales tax expenses to the accounts of the goods being purchased.
I still don't understand why anyone using Quicken would find this useful. If one is going to go to the trouble of finely categorizing their purchases, why not categorize the tax expenses, too? Do they blend their FICA and income tax back into their salary? But I don't need to understand why someone would wish to do so, and needlessly described doing so as "wrong". To the OP: sorry.
TomYoung wrote: > there's actually lots of > situations where you'd capitalize sales taxes.
So, in my truck situation, I'd amortize the sales tax over the life of the truck? I guess I can see that, although I don't like it. The truck loses value over time, for sure, but the one-time expense of the sales tax is incurred all at once and is a function of the purchase action, not the life cycle of the good purchased. Knowing what to capitalize and what to expense was always more art than science if I remember correctly. But one factor was, I thought, whether or not the item/service being acquired had some enduring value. I can re-sell the truck, but I cannot transfer any worth to another person once I've paid the state its sales tax. The "value" of the disbursement instantly dissipates.
I seem to recall living in jurisdictions where "children's" clothing was untaxed and "adult" clothing was taxed. Silly, and fraud-provoking.
Well, of course it is "part of the cost". Aren't some costs expensed? Aren't some costs booked in one account, while others to other accounts?
Remember where this started: someone new to Quicken who wanted to categorize his expenses. I'm not disputing that sales tax is a cost. I am a little slow on the uptake here with the notion that sales taxes paid are an asset .
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here.
All logos and trade names are the property of their respective owners.