Multiple G/L Accounts For Sales Tax Payable

QuickBooks Discussion board - Discussions about the popular financial software by Intuit 

Yahoo!   Google   Windows Live   del.icio.us   digg   Netscape

Subject Author Date Multiple G/L Accounts For Sales Tax Payable Monte Sliger 08-22-2006  Re: Multiple G/L Accounts For Sales Tax Payable catrick 08-22-2006  Re: Multiple G/L Accounts For Sales Tax Payable Monte Sliger 08-22-2006  Re: Multiple G/L Accounts For Sales Tax Payable Golden California Girls 08-22-2006
Posted by Monte Sliger on August 22, 2006, 12:50 pm Please log in for more thread options I use QuickBooks Premier 2006 - Accountant Edition. I need to break out the sales taxes payable from the invoices I create to various G/L accounts such as a different G/L account for each state. I have the different sales tax items set up in the item list with the correct sales tax percentage for each. In the item list, when I set up a sales tax item, I cannot select a G/L code to use for this sales tax item - it simply assigns the G/L account that QuickBooks automatically set up as the sales tax payable item. Is there any way to change the G/L account code associated with each sales tax item in the item list. When I edit the items in the item list, there is not an option to change the G/L account code. I realize that I can run a sales tax report to get the numbers for each sales tax item so I can make journal entries, but would prefer that it happen automatically whenever I create an invoice. If I cannot change the G/L code associated with the sales tax item, am I limited to journal entries to put the numbers into the correct G/L accounts? Thanks for any help with this. Monte Sliger Posted by catrick on August 22, 2006, 1:34 pm Please log in for more thread options Have you looked into "Classes"? From what I remember, if you assign a "Class" to each state you should be able to get reports you need per Class/State. Cat Monte Sliger wrote: > I use QuickBooks Premier 2006 - Accountant Edition. I need to break out the > sales taxes payable from the invoices I create to various G/L accounts such > as a different G/L account for each state. I have the different sales tax > items set up in the item list with the correct sales tax percentage for > each. In the item list, when I set up a sales tax item, I cannot select a > G/L code to use for this sales tax item - it simply assigns the G/L account > that QuickBooks automatically set up as the sales tax payable item. Is > there any way to change the G/L account code associated with each sales tax > item in the item list. When I edit the items in the item list, there is not > an option to change the G/L account code. > > I realize that I can run a sales tax report to get the numbers for each > sales tax item so I can make journal entries, but would prefer that it > happen automatically whenever I create an invoice. If I cannot change the > G/L code associated with the sales tax item, am I limited to journal entries > to put the numbers into the correct G/L accounts? > > Thanks for any help with this. > > > Monte Sliger Posted by Monte Sliger on August 22, 2006, 2:42 pm Please log in for more thread options Cat, Thanks for your suggestion, but I do not need reports. I have the sales tax report which gives me the numbers I need. I am looking for a way to have the creation of an invoice generate the credit into a different sales tax payable G/L account as opposed to having to make journal entries after the fact. Thanks, Monte Sliger > Have you looked into "Classes"? From what I remember, if you assign a > "Class" to each state you should be able to get reports you need per > Class/State. > > Cat > > Monte Sliger wrote: >> I use QuickBooks Premier 2006 - Accountant Edition. I need to break out >> the >> sales taxes payable from the invoices I create to various G/L accounts >> such >> as a different G/L account for each state. I have the different sales >> tax >> items set up in the item list with the correct sales tax percentage for >> each. In the item list, when I set up a sales tax item, I cannot select >> a >> G/L code to use for this sales tax item - it simply assigns the G/L >> account >> that QuickBooks automatically set up as the sales tax payable item. Is >> there any way to change the G/L account code associated with each sales >> tax >> item in the item list. When I edit the items in the item list, there is >> not >> an option to change the G/L account code. >> >> I realize that I can run a sales tax report to get the numbers for each >> sales tax item so I can make journal entries, but would prefer that it >> happen automatically whenever I create an invoice. If I cannot change >> the >> G/L code associated with the sales tax item, am I limited to journal >> entries >> to put the numbers into the correct G/L accounts? >> >> Thanks for any help with this. >> >> >> Monte Sliger > Posted by Golden California Girls on August 22, 2006, 10:06 pm Please log in for more thread options Monte Sliger wrote: > Cat, > > Thanks for your suggestion, but I do not need reports. I have the sales tax > report which gives me the numbers I need. I am looking for a way to have > the creation of an invoice generate the credit into a different sales tax > payable G/L account as opposed to having to make journal entries after the > fact. Move up the food chain. SlowBooks can't do it. > > Thanks, > Monte Sliger > > >> Have you looked into "Classes"? From what I remember, if you assign a >> "Class" to each state you should be able to get reports you need per >> Class/State. >> >> Cat >> >> Monte Sliger wrote: >>> I use QuickBooks Premier 2006 - Accountant Edition. I need to break out >>> the >>> sales taxes payable from the invoices I create to various G/L accounts >>> such >>> as a different G/L account for each state. I have the different sales >>> tax >>> items set up in the item list with the correct sales tax percentage for >>> each. In the item list, when I set up a sales tax item, I cannot select >>> a >>> G/L code to use for this sales tax item - it simply assigns the G/L >>> account >>> that QuickBooks automatically set up as the sales tax payable item. Is >>> there any way to change the G/L account code associated with each sales >>> tax >>> item in the item list. When I edit the items in the item list, there is >>> not >>> an option to change the G/L account code. >>> >>> I realize that I can run a sales tax report to get the numbers for each >>> sales tax item so I can make journal entries, but would prefer that it >>> happen automatically whenever I create an invoice. If I cannot change >>> the >>> G/L code associated with the sales tax item, am I limited to journal >>> entries >>> to put the numbers into the correct G/L accounts? >>> >>> Thanks for any help with this. >>> >>> >>> Monte Sliger > > Similar Threads Posted Why POs Not On Accounts Payable Detail? June 14, 2006, 2:19 am Report of Accounts Payable by expense? February 5, 2008, 3:15 pm Accounts Payable Register Ending Balance February 7, 2007, 10:51 am Accounts Payable Register Ending Balance February 7, 2007, 10:52 am Cost of Goods Input Accounts Payable Output July 18, 2007, 5:25 pm Editing Billing Charges To Customers Through Accounts Payable March 26, 2008, 10:02 am Reports from multiple bank accounts July 24, 2009, 5:35 pm QB Premier Canadian 2007 multiple sales orders August 21, 2007, 1:28 pm Are gross sales taken from Income Tax Summary report or Sales Tax Liability report when filling in State Sales Tax Forms Gross Sales Field? March 3, 2009, 10:28 am payable and receivable May 9, 2007, 3:57 am