"Tax included" and Your BooksThis is a discussion on "Tax included" and Your Books within the Business Talk forums, part of the Business Discussion category; I just got Quickbooks and I am intergrating my orders into the program. Anyway my questions is on items that ...
(#1)
| | Junior Member
Posts: 7 Join Date: Jul 2007 Location: cypress, Real First Name: Nikki Camera: nikon d200 iTrader Rating: 0 LIKES Received: 0 LIKES Given: 0 | "Tax included" and Your Books -
10-23-2007, 03:53 PM
I just got Quickbooks and I am intergrating my orders into the program. Anyway my questions is on items that are "tax included" how do ya'll backout the tax of the set price (Say $25) and get your books to come out even... I hope I explained this right...
I am typing in say $25 and it adds tax but the $25 includes the tax and I dont how to get the program to recongnize this.
Is there a way to set this up?
Any help would great!
-Nikki | | | | | Sponsored Links | Premium Members do not see Google advertisements. SIGN UP today and help support our community.
|
(#2)
| | You Can't Be Serious!!
Posts: 13,273 Join Date: Mar 2005 Location: DFW, Texas Real First Name: Brad (duh) Camera: Canon Can Others Edit My Photos: Yes iTrader Rating: 12 LIKES Received: 125 LIKES Given: 30 |
10-23-2007, 04:10 PM
25 / 1.0825 for an 8.25% sales tax
--------------------------- Brad Barton, Grand Prairie, TX (DFW) Twitter -- Blog -- Headshots -- Portraits Honest critiques always welcomed. An artist is not paid for his labor, but for his vision. -- James Whistler, Painter, 1834-1903 | | | |
(#3)
| | Junior Member
Posts: 7 Join Date: Jul 2007 Location: cypress, Real First Name: Nikki Camera: nikon d200 iTrader Rating: 0 LIKES Received: 0 LIKES Given: 0 |
10-23-2007, 04:44 PM
i've got the sales tax formula down... what i was wondering is how you (if i can) set up items that include tax, so quickbooks will back out the tax later | | | |
(#4)
| | Uber Poster
Posts: 2,777 Join Date: Sep 2005 Location: Pine Bush, NY, New York Real First Name: Pete Camera: Canon Can Others Edit My Photos: No iTrader Rating: 3 LIKES Received: 0 LIKES Given: 2 |
10-23-2007, 04:53 PM
As far as I know QB won't "back out" the tax. You have to do that manually. I send all my quotes as $$$ + tax. Why lose the 8+% IMO? | | | |
(#5)
| | Junior Member
Posts: 7 Join Date: Jul 2007 Location: cypress, Real First Name: Nikki Camera: nikon d200 iTrader Rating: 0 LIKES Received: 0 LIKES Given: 0 |
10-23-2007, 05:02 PM
OK thanks, thats what i needed to know.... i guess for my event prices (Proms, etc.) i'll just do it manually for my bookkeeping | | | |
(#6)
| | Forum Master
Posts: 1,401 Join Date: May 2006 Location: Friendswood, Texas Real First Name: Kasey Camera: Nikon Can Others Edit My Photos: No iTrader Rating: 4 LIKES Received: 20 LIKES Given: 2 |
10-23-2007, 05:31 PM
it won't back out hte tax. you have to do the math before you enter the amounts.
welcome to another reason i dislike quickbooks, blah. it seems with a program like this, it should really be able to do the math for you. | | | |
(#7)
| | Member
Posts: 76 Join Date: Jul 2006 Location: Spring/Klein, north west of Houston, Real First Name: Barbara Camera: Canon 30D Can Others Edit My Photos: No iTrader Rating: 0 LIKES Received: 0 LIKES Given: 0 |
10-23-2007, 11:07 PM
In your item list, create a new item. Name it "X without tax" (X=product) and then set it's detail to not add tax. | | | |
(#8)
| | You Can't Be Serious!!
Posts: 13,273 Join Date: Mar 2005 Location: DFW, Texas Real First Name: Brad (duh) Camera: Canon Can Others Edit My Photos: Yes iTrader Rating: 12 LIKES Received: 125 LIKES Given: 30 |
10-23-2007, 11:27 PM
Except that won't withhold tax on your books.
--------------------------- Brad Barton, Grand Prairie, TX (DFW) Twitter -- Blog -- Headshots -- Portraits Honest critiques always welcomed. An artist is not paid for his labor, but for his vision. -- James Whistler, Painter, 1834-1903 | | | |
(#9)
| | Permanently Banned
Posts: 15,341 Join Date: Apr 2005 Location: Fort Worth, Tx, Real First Name: Tom Camera: canon Can Others Edit My Photos: Yes iTrader Rating: 24 LIKES Received: 1 LIKES Given: 0 |
10-24-2007, 12:22 AM
Brad's right. As far as I know, Quickbooks can't back out the tax. It shouldn't be hard to develop a table with all your possible package pricing and have it show what the backed out pricing would be.
$25 = 23.09
etc. | | | |
(#10)
| | Junior Member
Posts: 7 Join Date: Jul 2007 Location: cypress, Real First Name: Nikki Camera: nikon d200 iTrader Rating: 0 LIKES Received: 0 LIKES Given: 0 |
10-24-2007, 12:58 AM
thanks everyone! | | | |
(#11)
| | Supa Dupa Poster
Posts: 4,404 Join Date: Mar 2005 Location: Denton, Texas Real First Name: Don Camera: Nikon D200 Can Others Edit My Photos: No iTrader Rating: 5 LIKES Received: 0 LIKES Given: 0 |
10-24-2007, 12:32 PM
None of the other programs that I have seen back the tax out. Maybe some of the high dollar ones will do it??? It only takes a few seconds to do it. I don't do it on individual items. I just put in prom packages and a dollar amount. Even then it is sometimes a penny off. I just add a $.01 handling charge.
---------------------------
Don Barnes
The Photographers, www.thephotographers.cc
The Ark was built by amateurs, The Titanic by professionals.
88mm gray filter plus whatever camera needed to activate it.
| | | | | Thread Tools | | | | Display Modes | Linear Mode |
Posting Rules
| You may not post new threads You may not post replies You may not post attachments You may not edit your posts HTML code is Off | | | | Google Sponsors | Premium Members do not see Google advertisements. SIGN UP today and help support our community.
| |
Copyright ©2004 - 2011, Abel Longoria - www.Pixtus.com
Powered by vBulletin® Version 3.8.7 Copyright ©2000 - 2012, vBulletin Solutions, Inc. |