Hovering Above

Archives

         --By Month--       Octobre 2012       Septembre 2012       Avril 2012       Mars 2012       Février 2012       Janvier 2012       Décembre 2011        2011       Octobre 2011       Septembre 2011       Aout 2011       Juillet 2011        2010       Septembre 2010       Aout 2010       Juillet 2010       Juin 2010       Mai 2010       Janvier 2010        2009       Aout 2009       Avril 2009       Mars 2009       Janvier 2009       Décembre 2008        2008       Juin 2008       Mai 2008       Avril 2008       Janvier 2008       Décembre 2007        2007       Octobre 2007       Aout 2007       Juin 2007       Avril 2007       Mars 2007       Février 2007       Janvier 2007       Décembre 2006        2006       Octobre 2006       Septembre 2006       Aout 2006       Juillet 2006       Juin 2006       Mai 2006       Avril 2006       Mars 2006       Janvier 2006       Décembre 2005        2005       Octobre 2005       Septembre 2005       Aout 2005       Juillet 2005       Juin 2005       Mai 2005       Avril 2005       Mars 2005       Février 2005       Janvier 2005       Décembre 2004        2004       Octobre 2004       Septembre 2004       Aout 2004       Juillet 2004       Juin 2004       Mai 2004       Avril 2004       Mars 2004       Février 2004       Janvier 2004       Décembre 2003        2003       Mars 2003       Février 2003       Janvier 2003       Décembre 2002        2002       Octobre 2002       Juin 2002       Mai 2002       Avril 2002       Mars 2002       Janvier 2002       Décembre 2001        2001       Septembre 2001    

        --By Category--      Computing      cs193p      Site      Genealogy      Internet      Netherlands      Science      Sundial      World Affairs    

Search

Advanced Search

Syndicate

RSS 1.0, RSS 2.0
Atom 0.3
Login
Register

Site Credits

Powered by:
ExpressionEngine

Financial App requirements

After trying several financial applications, I realised that I should formulate my requirements more formally. Several applications seemed to fit my needs, but failed after using them for a while. So with this post I will define my requirements. I might edit this post when I get more details.

• Import - this is one of the most important requirements. The applications should be able to import the files, that I get from my banks. Thus it should be able read OFX-files, which I get from Credit Agricole. It should be able to read CSV-files, which I get from the ING Bank. Latter demand seems to be a bit to much. I can convert CSV-files to QIF-format with QIF-Master, so as a third option QIF is really required. Control over number and date format is desirable (although fiddling with the international settings can help);
• Create/Edit - it should be easy to create and edit new transactions. I prefer inline editing;
• Export - the application should be able to export all data, either into OFX, QIF or CSV. As I have multiple accounts in a single set, I like to export as a single file. QIF seems to support only a single account per file. It seems that I must have control over the date and number formats, both for exporting and importing. Several apps introduced errors here;
• Document-based - I am not sure whether I use the correct terminology here. I want to save multiple sets of financial accounts as separate documents. I have to manage four different of such sets. Hiding those all those sets in a single document can be very difficult when creating reports;
• Filter - I would like to easily zoom in on a set of transactions by specifying a string. This can be to search for a certain amount or transaction made by a person. This is a like search, but then easier;
• Splits - support for splits is desirable. I do not have much experience yet with it, but I found it already useful, just for noting down some details;
• Categories - I would like to set a category (or tag) for each transaction, so that I can see what happens per category. I would also like to have subcategories, although there might be a way around it;
• Reporting - this requirement is the most difficult as it has many subsets that I need;
• Time-ranges - I would like to see what happens in certain times ranges, i.e. per month, per year (this, previous) or a range specified by me. I need the monthly reporting for a specific category for my taxes;
• Across accounts - I like to see what happens to all transactions (or in specific categories) summed over all accounts. Many applications do not support this kind of summation;
• MacOSX adherence - an application should adhere to MacOSX-standards as much as possible. Clear ports will only annoy me.

Categories: Computing
PermaLink