Financial Report Tool Program (.exe)

rocotilos · 03-19-2010, 01:24 AM

Ok I was looking for a free tool stand alone to process the financial reports, esp for weekly and monthly. Couldnt find any.

I purposely put all my financial reports on my windows box. since it has microsoft excel included. my macbook dont have any.

But even using excel on the pc to process the report is hard.. for me.. maybe because i dont know how to use excel lol...

so i decided to create a simple program (exe - so run in windows only.. at the moment) to process the reports. since i created it already, might as well i give it out free for those interested (later in my website/blog).

now it has (for both weekly and monthly)
- totalling up of total sales of paid apps for each main region in its respective currency
- totalling up of total sales of paid apps for each main region in USD
- ability to export the results as CSV file (so u can format nicely in excel put colors, etc for keeping)

what else do you think is a useful tool/report to have? im thinking to add
- total sales for each paid apps
- ?

THanks.

Tambourin · 03-19-2010, 02:01 AM

in app purchase would be good, grouped hierarchically under the app to which it belongs
AppViz does not really support IAP

rocotilos · 03-19-2010, 02:38 AM

How does an IAP looks like in weekly report and monthly report?
could you paste a line here for each? (from the raw txt format). i dont have any IAP type app.. thanks.

_nivek · 03-19-2010, 07:00 AM

I actually ended up doing something similar. I created a C# program that uses ADO.net to query the excel files. So I can just query my financial reports with a SQL statement

...now I just need a way for them to automatically download daily.

xtcsonik · 03-19-2010, 07:48 AM

Quote:

Originally Posted by _nivek

I actually ended up doing something similar. I created a C# program that uses ADO.net to query the excel files. So I can just query my financial reports with a SQL statement

...now I just need a way for them to automatically download daily.

How about putting this project up on CodePlex. Would love to take a look at it.

rocotilos · 03-19-2010, 11:46 PM

Nivek, thanks for sharing.

SQL queries is far too advanced for me.

Anyways, seems no one is interested so I'll just continue make the tool to do what i think is useful. I'll share the link to download it when its done.