A small system to accept details from bank statement and dissect data according to user defined rules against statement text and put in categories.
Need to be able to:
1. Import CSV file
1A. Manually add transactions (Date, Text, Amount)
2. Set up Categories
3. Set up Rules for quick dissection (repeatable)
4. Apportion transaction values as set in Category Table (Income, Expense, Capital; Percentage to apportion, Applicable Tax Rate etc)
4A. Manual intervention on non categorised transactions, select from Category dropdown
5. Produce output similar to excel look, using Categories and apportionment rules.
6. Export function to CSV/Excel file.
To run on windows using propriety file structure or free database.
Must be easy to install
Using modern UI.
Future: to run on Android and IOS