Home Page link  

Multiple G/L Accounts For Sales Tax Payable

 

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

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
Multiple G/L Accounts For Sales Tax Payable Monte Sliger 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 ThreadsPosted
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
QB Premier Canadian 2007 multiple sales orders August 21, 2007, 1:28 pm
payable and receivable May 9, 2007, 3:57 am
Q: Invoicing a Payable December 13, 2007, 10:21 pm
Changing an Account Payable via GJE May 15, 2007, 1:36 pm

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap