MySQL 5 - Design help for cross checking cash receipts

Hi ,,

We are trying to do an inventry management system for sales of Recharge coupons and SIM's ..Now confused with the Checking the correctness of Cash details for taking reports for daily and monthly statements..

Can some one help us to do some database design for cross checking the money details.

We feel that there should be atleast two tables for cross checking the money..

Can any one please help..

are you just starting? or do you have something already and just want the reporting done. I only ask because usually you would have a record of all the sales in a sale table and the reporting would just query that to get your summary figures. The only other option is to have a summary table that records sum and count of each type of item and have an end of day report that compiles the information and use that in your reporting.

Thanks lot..We have already done a prototype and trying to enhance its features.Some times getting stuck as our database design is not up to par.
So trying to reinforce it

well there isn't really a point to adding data in the database two times. In fact, good database design will get you to minimize duplication of data as much as possible. The way my work POS software works is at the end of the night, whomever is closing after the store closes, runs an 'end of day' report. When this report is run, the software finalizes all transactions and creates accounting numbers which are really just a summary of each sale item (count and amount) and puts that into a salehistory table. something like "INSERT INTO SaleHistory SELECT ItemType_ID, SUM(Amount), COUNT(*) FROM Sales WHERE Date='{today}' GROUP BY ItemType_ID". That would insert from the sale table into the sale history table the id number for an item, the count of how many of that item sold and the sum of the amount sold.