Using Maarten Balliauws's PHPExcel SDK http://www.codeplex.com/PHPExcel and various formats created by financial applications and online banking websites this article will show you how to create an Excel spreadsheet with some basic functions and conditional formatting. 

Read more here