User:Frahmad/Sandbox

Business Process
The "Daily Finance Report" provides a summary of the financial transactions in Clublead based on the entry time of the transactions in Clublead. The report can be used for:


 * Get a summary of the daily transactions on each finance account
 * Get a summary of VAT booked for transactions with different rates
 * See totals booked for sales, exenses, assets and liabilities.

The report can be used for booking finance transactions in an external finance system without the use of the ClubLead finance export feature.

The report is timesafe which means that historic reports can not change by events happened after the report has been extracted from Clublead.

Report layout
The layout of the report are shown below:

Sales                      Bookdate       Debit       Credit        Total       VAT     VAT Type 10100 Joining Fees       2007-11-27      500.00     -5000.00     -4500.00   -225.00       OUT_5% 10200 Subscriptions      2007-11-27     1250.00    -25000.00    -23750.00  -2375.00      OUT_10% 10100 Retail sale        2007-11-27      250.00     -1500.00     -1250.00   -312.50      OUT_25% Sales total:                            2000.00    -31500.00    -29500.00  -2912.50

To prevent that transactions are forgotten in Clublead - e.g. not reported - the report can not be generated for todays date, but only for yesterday or earlier, since this will allow for taking out reports that does not contain all transactions for the date specified.

If the daily transactions contain transactions with different book dates on the same account, the summary will contain a record for each of the book dates.