Your requirements are lacking some important details:
- how will the database be filled with data
- quantity of data present
- quantity of transactions
- how long should historic data be maintained
On the first sight, this looks like a project of, say, half a man-year (or more) to get a basic application.
My advice: find a reputable IT-company to do a system design and make a quotation for building the system.
For a charity in the UK I want to create a file with
total donation from each donor
tax refund -value in currency of 28% of each donation
total of each donors donation and tax refund
total of all donations and also of tax refunds
and to be able to present the results in a tabulated report
Are the formulae I need available in "free to use" text document, spreedsheet and database appliacations?
Which would be best?
ideas and suggestions welcomed!