Re: [Emerald] Sales Tax Report

PowerNet ( (no email) )
Tue, 05 Oct 1999 16:58:13 -0400

This is something that should be addressed ASAP as many ISP's now have to=
charge sales tax.

I have actually calculated tax by adding each invoice. Not only a pain,=
but very time consuming.

*********** REPLY SEPARATOR ***********

On 10/5/99, at 3:43 PM, ronnie@itexas.net wrote:

>The problem is that the sales tax is stored in invoices.... not payments..
>so you would have to link the payments to the invoices and etc....
>
>It just takes some that knows CR backwards and forwards....
>
>The simplest thing to do is for Emerald to have a tax field in the=
payments
>table, then the report could be generated no sweat.... I do not know if=
the
>payment posting is handled inside of Emerald or a stored proceedure, but=
if
>it is a stored proceedure it would be simple to add it....
>
>
>
>----- Original Message -----
>From: PowerNet <psc5@powersupply.net>
>To: <emerald@iea-software.com>
>Sent: Tuesday, October 05, 1999 3:26 PM
>Subject: Re: [Emerald] Sales Tax Report
>
>
>Does anyone know the SQL database well enough to create a query like this?
>
>I don't know SQL, but there are many reports that tell amounts collected,
>why not add tax to the report.
>
>It will take someone who knows the SQL table.
>
>
>
>*********** REPLY SEPARATOR ***********
>
>On 10/5/99, at 12:58 PM, ronnie@itexas.net wrote:
>
>>No holes to punch and all this works fine...
>>
>>However, There is no easy way to create a report that provides the
>>information to file taxes.....
>>
>>99% of the ISPs should be working on a Cash Account model since they=
have
>>no inventory.. thus tax is not due until it is actually collected.. using
>>the tax_sum.rpt creates a report on what you billed, not what you
>>collected.....
>>
>>I have sent an Email to IEA requesting a report that actually provides=
the
>>information that is necessary to file taxes... However I have yet to get=
an
>>answer.. I am willing to pay for this report as I am sure there are many
>>others that would also.....
>>
>>Ronnie@itexas.net
>>
>>
>>----- Original Message -----
>>From: David Routh <drouth@davlin.net>
>>To: <emerald@iea-software.com>
>>Sent: Tuesday, October 05, 1999 11:56 AM
>>Subject: RE: [Emerald] Sales Tax Report
>>
>>
>>> At 11:35 AM 10/5/1999 -0500, you wrote:
>>> >The $25 rule is for each month.. no matter how the payment is made,
>>monthly
>>> >4 months, or yearly.... so if you access charge is less than $25.00=
per
>>> >month on the average then there is no tax.. just change the tax to=
none
>>in
>>> >admin...
>>> >
>>>
>>> What we did is create a "dialup single" and a "dialup multi" ... the
>>dialup
>>> single is a non-taxed item in admin and the multi is taxed... The=
dialup
>>> single is used for the bulk of our dialup customers which meet the $25
>>> exemption.
>>>
>>> We also created a "$25 exemption" service that is actually a -$1.97=
(our
>>> tax rate is .07875). That service is added to any account that has the
>>> "dialup multi" or other access that is over $25... like ISDN. This way
>ANY
>>> account that has the "multi" or "ISDN" SHOULD have the "$25=
exemption"...
>>> makes it a little easier for our people to remember.
>>>
>>>
>>> >As for the 20% off the other services.. I don't have anyone that is=
due
>>for
>>> >the next 15-20 days so I am still scratching my head...
>>> >
>>>
>>> We basically do a similar thing... We created a "20% Virtual" and "20%
>>Web"
>>> to handle the few virtual and business sites we house. The discount is
>>> reflective of the cost of the service... Whatever the cost of the=
service
>>> we do the math and deduct the tax charged on 20% of that service...
>>again,
>>> ANY Web hosting service SHOULD have the discount...
>>>
>>> Hope that helps (and makes sense)... if someone can poke holes in it=
let
>>me
>>> know.
>>>
>>> Thanks, David
>>>
>>> For more information about this list (including removal) go to:
>>> http://www.iea-software.com/support/maillists/liststart
>>
>>
>>For more information about this list (including removal) go to:
>>http://www.iea-software.com/support/maillists/liststart
>
>For more information about this list (including removal) go to:
>http://www.iea-software.com/support/maillists/liststart
>
>
>For more information about this list (including removal) go to:
>http://www.iea-software.com/support/maillists/liststart

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart