US 7,590,574 B2
Mechanized tax worksheet
Ronnie Dale Johnson, Birmingham, Ala. (US); and Joseph M. Hanners, Birmingham, Ala. (US)
Assigned to AT&T Intellectual Property I, L.P., Reno, Nev. (US)
Filed on Dec. 19, 2006, as Appl. No. 11/613,184.
Application 11/613184 is a continuation of application No. 09/588534, filed on Jun. 07, 2000, granted, now 7,155,404.
Prior Publication US 2007/0208636 A1, Sep. 06, 2007
Int. Cl. G07F 19/00 (2006.01)
U.S. Cl. 705—34  [705/31] 9 Claims
OG exemplary drawing
 
1. A method of verifying tax charges on a batch of customer telecommunications bills, comprising:
downloading, from a mainframe computer to a local server, billing data associated with customer accounts, wherein the billing data includes prebill data that is downloaded on a day of verification and demand print data that can be down loaded prior to the corresponding prebill data;
populating a first database with a first portion of the billing data;
performing pre-calculation functions on a second portion of the billing data and further populating the first database with results of the pre-calculation functions;
providing an option to a user for immediately calculating calculated tax results without displaying predetermined categories of information stored in the first database;
independently of the mainframe computer, calculating calculated tax results for each of several charges in the billing data utilizing the billing data populated in the first database and local tax rates and stored tax rate information;
comparing the calculated tax results displayed within the worksheet with the tax charges on the customer telecommunication bills to verify the telecommunication bill taxes; and
resolving errors on the customer telecommunications bills detected from the comparing printing and sending the bills to customers.