For any bug or comments please send an email to FAssistant@hotmail.com
Application Version for this ReadMe File is v4.10

This utility is answer to most of your personal and finance information storage and analysis needs. You can store, 
retrieve, track and analyze following things with one single application instead of depending on number of applications
or means to get the same info.

1. Income from different sources, salary income, part-time job income, income from rent etc. 
2. Expenses you do, you can categorize them based on expense mode you use and expense types like travel, dining-out, 
   books, rent etc. 
3. Money you owe to or from someone like your friend or partner/roommate 
4. Expense share with your room-mate/partner or friends for the common expenses which are shared in some ratio 
5. Your bank account information, transactions (deposit, withdrawal, interests earned), start date, maturity date, 
   interest rate 
6. You investments on stocks/securities, sell/purchase of stocks, dividends, earnings (profit/loss), expected earning, 
   complete stock analysis in % as well as actual numbers. You can also know your Smart Earnings by taking time-frame
   in consideration of your investment or reinvestment on stocks 
7. Your loan and policy account information, payments, start date, maturity date, interest rate 
8. Important information storage as secured or unsecured. Like your car details, passport details, utility accounts 
   (electricity, water, phone) details, important numbers or info that you may need time to time and you want to keep
   it handy. 
9. Important Date Reminders like reminders about appointments, meetings. These can be categorized as once, daily, 
   weekly, monthly and yearly. You will see a notification on the main screen about today's appointments and meetings. 
10. Personal Address Book to store address, phone numbers, work related details, dependent details, birth date, 
    marriage anniversary date. And yes you need not to store birth year, just date and month is sufficient. 
11. Store all your online user ids/passwords, ATM pin numbers or any other highly confidential info to retrieve it 
    any time with out any hassle. No one else can view these confidential information. You just need to remember one
    user id/password to see confidential info using this utility. 
12. Reports to analyze your expenses and incomes in number of your own customized ways. Like daily, monthly, yearly, 
    grouped by expense/income types, expense/income modes, between 2 specified dates and much more. You can combine
    various income and expense accounts in a way you want (add/subtract) to get the desired output 
    i.e. (Saving = Income Account 1 + Income Account 2 - Expense Account 1 - Expense Account 2) 
13. Reports to analyze your financial status like total money in all your bank accounts and stocks, how much total 
    cash you have on hand at any point of time, how much in total you have paid in all your loans and policies, how 
    much total profit or loss you made in stocks, total interest earned in all your accounts. 
    You can combine (add/subtract) all your accounts (Bank/Loan/Policy/Stocks) with each other to 
    get the desired output. 
14. Any of the expense/income/information/transactions/payments/address can be searched using search screen provided
    for each type of account. You can customize your search in any way you want. You can also determine monthly or 
    yearly averages for all your expenses/incomes/transactions/payments against each attribute (expense type, income
    type, payment type, transaction type, income mode, expense mode etc.) using search (*Group Average function) screen. 
15. You can first create a report in the desired format and then save it in a text file for taking printout or sending
    to someone as a formatted text file. Most of the report screens, search screens and account details screens have 
    "Save To File" functionality to save data shown on screen in a formatted text file. 
16. There are about 185 countries/currencies that can be supported by this application. You can add/delete currencies 
    to the application from a pre-defined list of currencies also you can add your own symbol/name to it. 
17. Add your own income types, expense types, income modes, expense modes to the application and use them in accounts 
    you create. 
18. Export the complete data dump of the application in a text file for backup or migration purpose. The exported file
    can be imported in a newly installed or exiting application any time. Export and Import both are always password 
    protected (admin user id/password). So no one else can export or import data to/from the application. 
    Application can also automatically make a copy of exiting data file before importing any data file using import 
    functionality. You can control the behavior of import data file functionality as you want. 
19. Data import (v4.00 or higher) has backward compatibility for earlier versions so do not worry if you want to 
    upgrade to a newer version of the application. You can use smart import functionality to make the version specific 
    changes automatically. 
20. You can customize the GUI of the screen through Options screen like main screen layout, foreground and background
    color of inactive records/accounts, include inactive records/accounts in display or not etc. 
21. In all money related accounts like expense account, income account, individual user account, bank account, stock 
    account, loan/policy account you can create template of transactions which occurs periodically (weekly, monthly, 
    yearly). Later you can use these templates from creating or updating a transaction. 
    Also same templates can be used to create multiple similar transactions (Bulk Load) with different dates you 
    chose like once, daily, weekly, monthly or yearly, between 2 specified dates. 

On the main screen of the application you can see 
-------------------------------------------------
1. All your friends and loved ones who have birthday or marriage anniversary this month or today. 
2. All your accounts/loans/policies which are maturing this month and today. 
3. All your important reminders, appointments or meetings which are due this month or today. 
Current month is shown by default with today’s things highlighted. You can always browse back and forth in months. 

Software/Hardware requirements:
-------------------------------
Following are the minimum system requirements for running this utility:
1. JRE/JDK 1.4 must be there in your system's path. Running following command on command prompt must return 
   java version 1.4 or above

     > java -version

   If you don't have JDK1.4 installed on your machine, first down load it from the link provided in side menu. 
   Change system classpath and path accordingly so that typing java -version on command prompt will return JDK1.4 
   or above.

2. It uses Microsoft Access data file for storing user data. For that it just requires Microsoft Access drivers, 
   which are there on your machine if you have Windows plate form. It can be used with Oracle Database also but 
   it has not been fully tested with Oracle database and hence not recommended.

	Note: If you are not using the default provided Microsoft Database during installation. Application will create 
	some required tables in the defined database. So make sure you don't loose any existing data.

How to Install:
---------------
1. First download the FAssistant.zip file from the link provided on side menu 
2. Store it on some place on your hard drive. 
3. Unzip the FAssistant.zip file to a blank directory (using WinZip or similar software). 
4. Open a Command Prompt Window (DOS/CMD window by typing cmd in Run) 
5. Go to the directory where you unzipped the file (like >cd C:\Fassistant) 
6. Run the setup.bat file on command prompt window (like >setup) 
7. This will open a installation window (if you have JRE/JDK 1.4 or above in your system's path). 
8. Follow the commands on the screen. This will install the application in a directory you mentioned during 
   the installation. 
9. It will also create a bat file (Run.bat) if the corresponding checkbox is checked during installation. 
10. To run the application use this script file. (on windows double click it will run the application) 

Note : For first time installation it is recommended to use the default values(provided by the application) 
	   for all the required fields.

Recommendations:
----------------
It is recommended to use this application on Windows XP/2000/97/ME.

Following are the common points/behavior used within the application on various actions or screens:
---------------------------------------------------------------------------------------------------
1. Any label shown in Dark Red color is mandatory.
2. Any label shown in Blue color is a link which describes field type (mandatory, optional, read only etc.) along 
   with some rules or properties or description for that particular field. Clicking on the label will open a pop-up
   box with details and a close (X) button. This pop-up box will be closed automatically after a pre-defined time 
   or click 'X' button to close explicitly. 
3. Any label shown in black color is optional and can be left blank.
4. "Save To File" button is shown in few screens. Click this will save the data of table in a text file. Data will be 
   saved in same order as it is shown in the table on the screen. Data will be formatted as the column type. The width
   of the each column is calculated dynamically to fit all values in that column.
5. "Status" field in most of the screens has following options "Active", "In Active". Making a account/record in-active
   will disable it from being shown in LOVs (Drop Downs) and tables. It can be made Active again when ever needed.
6. By default double clicking on any record in a table will open that record in update mode.
7. All in-active rows shown in a table are shown with different foreground and background color so that they can easily
   identified. In-active rows are not considered in calculation of totals in respective screens (unless otherwise option
   is selected). The color of in-active row can be changed by going Tools -> Options... -> Application tab.
8. User can use arrow keys to navigate within a table. Down arrow and Up arrow will be treated as single mouse click on
   a row in table. While Enter key will be treated as double click on a row in table. Tab will bring focus to the next 
   eligible component on the screen just after table and shift + Tab will take focus to previous eligible component 
   just before the table.
9. If there is any editable cell present in a table. The color of that cell will be dark orange. 
10. In table green foreground color symbolizes profit, red color symbolizes loss and purple color symbolizes 
    interest/dividends.
11. Any important row or column in a table or any important field on the screen will be shown with fuchsia color as 
    background. Same color is also used to show the current fields, rows or columns (like current stock price, 
    reminders due today). 
12. Bringing mouse on any image button will show description of the button.
13. "Show Active Records Only" option shown just above table in most of the screens is selected or un-selected based on
    the properties set in the Options screen (Application tab).
14. To view or update any secure/confidential info user needs to login as admin user first. Once you are logged in as 
    admin user it remain logged-in till you close the application, click on "Log Out" button or choose "Admin Log out" 
    menu option of Main screen.
15. To Export or Import data from application you always need to provide admin user id and password, even though you 
    are already logged-in as a admin user. This is for security purpose so that no one else can do export or import 
    of your personal data even if you forgot to logout after login as admin user. 
16. On Main screen following 3 reminders are shown in 3 different tables. By default all reminders due in current month
    are shown in respective table. Anything that is due for today will be highlighted with fuchsia color and will be 
    shown at top of the table. You can always browse back and forth in months. You can resize, reset, show or hide each
    reminder table on main screen by right clicking on the reminder title. Reminder title for current month is shown 
    with blue color while any other month will shown with black color. You can always jump to current month from any 
    month by clicking "Go to Current Month" option of right click menu.
17. All alert, error or confirmation messages shown in the application are model in the nature. Which means you will be
    not able to do anything else in the application until you take some action on the shown message (like click OK or 
    Cancel button).
18. There are also few model child windows which are opened when you click on details button on some of the screens. 
    When such model child windows are opened you will be not able to do anything else on any other screen until you 
    close the model child window. So some time if you see you are not able to do anything on any opened screen, either
    there is a alert message is shown on some screen or a model child window is opened some where in the application. 
19. Shortcuts commands are defined for frequently used screens like "Ctrl+X" for closing the application, "Ctrl+P" for 
    password manager screen. All shortcut commands are defined on the menu toolbar (next to the screen name) and all 
    these commands can be executed only if main screen is the currently activated window.
20. In most of transaction details screens "Create/Update Template", "Open Template For Single Use" and "Open Template 
    For Bulk Load" image buttons are shown. These buttons can be used to create or update transaction template, use any
    existing template to add or update a transaction or create multiple transactions for defined frequency (once, daily,
    weekly, monthly or yearly) between 2 specified dates. Templates are specific to the account type and can used for 
    all accounts of that account type.
21. GUI for almost each table shown on any screen can be customized to suit your requirements and taste. Right click 
    inside the table boundary, you will see a pop-up menu with following options
        a. Reset Table Layout: This is to reset the current table layout to the last saved table layout. If no table layout 
                               is saved the default table layout will be shown.
        b. Default Table Layout: This will reset the current layout to the system default table layout. 
        c. Save Current Table Layout: This will save the current shown table layout in database to be used for next time onwards.
        d. Show/Hide Columns: This can be used to show or hide columns in the table. 
    You can change the width of each column shown in the table or reorder the sequence of the columns and save it so that
    next time onwards this new layout will be used instead of default table layout.
      
You need to Create and Manage following reference data to be used in various accounts:
--------------------------------------------------------------------------------------
1. User: Maintains list of your friends, colleagues or partners with whom you do money transactions.
2. Expense Mode: Maintains list of modes you use for your expenses like Cash, Check, Credit Card, eBillPay, 
   Demand Draft. Same list is used for all income modes also like Direct Deposit, Check, Cash etc.
3. Expense Type: Maintains list of major categories you do expenses on like Phone charges, Rent, Cloths, Grocery etc.
4. Expense Sub Type: Maintains list of sub categories you do expenses on like Mobile, Land Line, Store Names etc.
5. Income Type: Maintains list of categories your income comes from like Salary, Part Time Work, Rent, Interest etc.

FAssistant provides storage, tracking and analysis of following types of basic accounts:
----------------------------------------------------------------------------------------
1. Monthly Expense Account: You can create N number of expense accounts. This account is maintained on monthly basis.
   You can keep track of your expenses by creating one or more such accounts. To create this type of account navigate 
   to Accounts -> Manage Account -> Monthly Expense. Here provide values for all mandatory fields and then click on 
   "Add" button to create the account. Once account is created you can add expenses to it by going to Accounts -> 
   Open Account. Select "Monthly Expense" as Account Type and account name that you want to open and click "Open" 
   button. This will open Monthly Expense screen for current month with today's date populated. You can create or 
   use a template to add one or multiple similar transactions to the monthly expense account.

2. Yearly Income Account: You can create N number of income accounts. This account is maintained on yearly basis.
   You can keep track of your incomes by creating one or more such accounts. To create this type of account navigate 
   to Accounts -> Manage Account -> Yearly Income. Here provide values for all mandatory fields and then click on 
   "Add" button to create the account. Once account is created you can add income transactions to it by going to 
   Accounts -> Open Account. Select "Yearly Income" as Account Type and account name that you want to open and click
   "Open" button. This will open Yearly Income screen for current year with today's date populated. You can create or
   use a template to add one or multiple similar transactions to the yearly income account.

3. User Account: This is used to a create account where you give or borrow some money form any person. You can 
   keep track of all money transactions you are doing with a person. This is till date kind of account. Which shows 
   balance with the individual till date. You can create one such account for each user created in manage user screen. 
   You need to select a user during creation of this type of account and once created you can not change the user 
   attached to the account. To create Individual User Account navigate to Accounts -> Manage Account -> User 
   Account. Here provide values for all mandatory fields and then click on "Add" button to create the account. Here 
   Cutoff Date is the date where all the transactions before or on the Cutoff Date will be combined and final outcome 
   will be shown as one row in the table of account details screen. Now to access the account navigate to Accounts -> 
   Open Account and then select Account Type as "User Account" select appropriate account from the drop down and 
   click "Open" button. This will open the Individual User Account screen with today's date populated. It shows the 
   final balance you owe to or from the account user. You can create or use a template to add one or multiple similar 
   transactions to the individual user account.

4. Group Account: This account is used where a group of persons are involved in expenses on sharing basis. Like a group
   of 4 person went on a vacation together or you do share expenses with your room partner. So this account can be used 
   to keep track of such expenses which are made by the group of people and is shared by some or all of the people of 
   the group. This is mostly one time use account and is not bound to month or year. To create Group Account navigate 
   to Accounts -> Manage Account -> Group Account menu option. Here provide values for all mandatory fields and then 
   click "Add" button to create the account. Select all users form the list who are part of group and are involved in 
   expense share. Now to access the account navigate to Accounts -> Open Account and then select Account Type as "Group
   Account" select appropriate account from the list and click "Open" button. Here you can share an expense equally in 
   all users or in different proportions, but sum of expense should be equal to sum of share always. This account lets 
   you know how much each person in the group needs to pay or receive from the other members of the group.

Following miscellaneous accounts can also be used to keep track of your financial status at any point of time:
--------------------------------------------------------------------------------------------------------------
1. Bank Account: This type of account can be used to store or keep track of various bank accounts, fixed deposits, 
   credit card accounts and their transactions. You can keep track of how much interest you are earning on your bank 
   accounts or fixed deposits or when they are maturing, what is the interest rates etc. These accounts can be used in
   miscellaneous account summary reports to know how much total money you have in different accounts in Bank. To create
   a new Bank Account first you need to create a category by navigating to Accounts -> Bank Account -> Manage Account. 
   Add one or more required categories here (like Credit Card, Saving Account, Checking Account, Fixed Deposit, 
   Personal Account, Wife Accounts, Kid's Accounts etc.). Now to add a bank account to a category navigate to 
   Accounts -> Bank Account -> Open Account, select appropriate bank account category and click "Open" button. 
   This will open the bank account details screen where you can add/update/delete a bank account. To add transactions
   to a bank account double click on it in the table to open it in update mode. Click on details button next to 
   "Current Amount" field, this will open bank account transaction details screen. Here you can add/update/delete 
   bank account transactions to the bank account. Each transaction you can categorize as Deposit, Withdrawal or 
   Interest. You can create or use a template to add one or multiple similar transactions to the bank account.

2. Stock Account: This type of account can be used to keep track of different Shares/Stocks you buy or sell. You can 
   track how many stocks currently you have, how many you purchased, how many you sold, what is net gain/lose etc. 
   These accounts can be used in miscellaneous account summary reports to know the total value of all stocks you 
   currently have, how much you earned in stocks, how much fees you have paid or how much dividends you earned. To 
   create a new stock account first you need to create a category by navigating to Accounts -> Stock Account -> Manage 
   Account. Add one or more required categories here (like IPO Stocks, IT Stocks, Manufacturing Stocks etc.). Now to 
   add a stock account to a category navigate to Accounts -> Stock Account -> Open Account, select appropriate stock 
   account category and click "Open" button. This will open the stock account details screen where you can add/update/
   delete a stock account. To add transactions to a stock account double click on it in the table to open it in update
   mode. Click on details button next to "Earnings" field, this will open stock account transaction details screen. 
   Here you can add/update/delete stock account transactions to the stock account. Each transaction you can categorize 
   as Purchase, Sell or Dividend. You can create or use a template to add one or multiple similar transactions to the 
   stock account. 
     
   Click on "Portfolio..." button on stock account details screen to analyze your stock investments for the selected 
   stock category. This will open the portfolio screen which gives you complete 360 degree stock analysis based on 
   current stock rates stored in the application, it will give you details like % Earnings, Expected % Earnings, 
   Smart % Earnings, Max/Avg/Min Purchase Price, Max/Avg/Min sell price, total dividends earned, total fees paid, 
   expected fees if you sell all your stocks. Most of the fields on this screen are shown as link (in blue color), 
   click on any link fields to know the description of the field and formula used. There is a "Portfolio..." button 
   on stock category account screen also which will do the same analysis for all the selected categories. You can get 
   the current quotes of all the stocks you have by clicking on "Get Current Quotes..." button and "Price Watch..." 
   button. Get Current Quotes functionality will just bring the current quotes of the stocks while Price Watch 
   functionality will bring current quotes with other useful info like net or % change in stock price today, max/min 
   stock price today, 52 week max/min stock price, previous close price, total quantity traded today. These 2 
   functionalities requires plug-ins and these buttons will be enabled only if you have installed the plug-ins for 
   these.
   
   Note: Portfolio and Price Watch screens under Stock Account will not work with Oracle Database.
   
3. Loan/Policy Account: This type of account can be used to keep track of different policies or loans for that you need
   to pay premium or installments on weekly/monthly/yearly basis. Like car loan, Life insurance policy etc. These 
   accounts can be used in miscellaneous account summary reports to know the total amount you paid in installments, 
   total principle amount, maturity amount and interest amount for all loan/policy accounts. To create a new 
   loan/policy account first you need to create a category by navigating to Accounts -> Loan/Policy Account -> Manage 
   Account. Add one or more required categories here (like Loans, Insurance Policies, Medical Policies etc.). Now to 
   add a loan/policy account to a category navigate to Accounts -> Loan/Policy Account -> Open Account, select 
   appropriate account category and click "Open" button. This will open the loan/policy account details screen where 
   you can add/update/delete a loan or policy account. To add transactions to a loan/policy account double click on it
   in the table to open it in update mode. Click on details button next to "Total Amount Paid" field, this will open 
   loan/policy account transaction details screen. Here you can add/update/delete payment transactions to the account. 
   Each transaction you can categorize as Installment or Other. You can enter negative values in "Payment Amount" field. 
   You can create or use a template to add one or multiple similar transactions to the loan/policy account. 
   
Following are other types of accounts supported by the FAssistant utility
-------------------------------------------------------------------------
1. Information Account: This type of account can be used to keep all your important information (up to max 4000 chars) 
   in one secured place. You can store any confidential or non-confidential information in this type of account, which 
   you need time to time and you want to keep it handy. To create a new information account first you need to create a 
   category by navigating to Accounts -> Information Account -> Manage Account. Add one or more required categories 
   here (like Passport Details, Tax Details, Personal info etc.). Select or un-select "Secure" option based on if you 
   want to create all information accounts in this category as confidential or non-confidential. Making a category 
   confidential will require you to log in as admin user to see or update the information. Now to add an information 
   account to a category navigate to Accounts -> Information Account -> Open Account, select appropriate account 
   category and click "Open" button. This will open the information account details screen where you can add/update/
   delete a information account. To view the information double click on a record in the table that will open the 
   record in update mode and information will be shown in "Information" field. If the account category defined as 
   secure then "Log In" button will be enabled and you will need to log in as admin user to view or update the 
   information details. In that case "Secured : Please login" will be displayed until you login as a admin user.
   
2. Reminder Account: This type of account can be used to keep track of all your reminders/appointments/meetings at one 
   place and all reminders for the current month are shown on main screen of the application. If anything is scheduled 
   for today that will be shown at top in the table with fuchsia color. To create a new reminder account first you need
   to create a category by navigating to Accounts -> Reminder Account -> Manage Account. Add one or more required 
   categories here (like Doctor Appointments, Work To Do, Car Insurance Premium Payment Reminder etc). Now to add a 
   reminder account to a category navigate to Accounts -> Reminder Account -> Open Account, select appropriate account 
   category and click "Open" button. This will open the reminder account details screen where you can add/update/delete 
   a information account. During creation of a reminder (account) you need to select the frequency of reminder (once, 
   daily, weekly, monthly or yearly) and the start and end date for the reminder to be shown on main screen. Whatever 
   frequency you define here the eligible dates during defined reminder period are determined by the application and 
   are shown under "Message Reminder" section on main screen. 
   
3. Password Manager: This type of account can be used to keep all your user ids/passwords, ATM Pins at one secured 
   place. For all your online accounts user ids/passwords that you want to keep handy, this account is a good choice. 
   To create a new password account first you need to create a category by navigating to Tools -> Password Manager. 
   Click on category accounts button next to "Category Name" drop down. This will open password manager category 
   screen. Add one or more required categories here (like Online Shopping Account, ATM Pin Account, Online Bank 
   Account etc.). Select or un-select "Secure" option based on if you want to create all password accounts in this 
   category as confidential or non-confidential. Making a category confidential will require you to log in as admin 
   user to see or update the password. Close the category screen after making required changes. Now to add a password 
   account to a category, select appropriate category from "Category Name" drop down shown on password manager screen. 
   If any passwords account already exist for the selected category, those accounts will be shown in the table. You can
   add/update/delete a password account here. If the category defined as secure then "Log In" button will be enabled 
   and you will need to log in as admin user to view or update the information details. To see the password for an 
   account double click on the account, this will open the account in update mode, bring your mouse over "View Password"
   field the password will be visible, it is be hidden once your mouse goes out of the "View Password" field. If the 
   category is secured and you are not logged in bringing your mouse to "View Password" field will show text 
   "Secured : Please login", you need to login as admin user to see the password.
   			
4. Personal Address Book: This type of account can be used to keep all your personal address book related details, 
   contact details of your family, friends or loved ones. Here you can store birth date, anniversary date, office/home 
   phone numbers, fax numbers, address details or any dependents details of a person. To create a new person address 
   account first you need to create a category by navigating to Tools -> Personal Address Book -> Manage. Add one or
   more required categories here (like Family Friends, Office Friends etc). Now to add a person account to a category 
   navigate to Tools -> Personal Address Book -> Open, select appropriate account category and click "Open" button. 
   This will open the person account master screen where you can add/update/delete information related to a person. 
   Double click on a record in the table to open it in update mode, click on dependent details button next to "Person 
   Name" field to store the information about the dependents of the selected person. Persons or dependents with birth 
   date and or anniversary date lying in current month will be shown in "Important Date Reminder" section of the main 
   screen. While defining birth date or anniversary date only month is mandatory date and year can be left blank.
    
Following reports can be used to track and analyze various types of accounts supported by the application:
----------------------------------------------------------------------------------------------------------
1. Account Summary Report: This report can be used to combine one or more following accounts. Here records are added at
   account level.
     a. Monthly Expense Account
     b. Yearly Income Account
     c. User Account
   Accounts can be combined to get the desired report by adding them to the report or subtracting them from the report.
   i.e. Total Savings = Income Account 1 + Income Account 2 - Expense Account 1 - Expense Account 2
        Total Income = Income Account 1 + Income Account 2
        Total Expense = Expense Account 1 + Expense Account 2
   To create such report first you need to define the report by navigating to Reports -> Account Summary Report -> 
   Manage Report, this will open manage account summary report screen. Here select the report cycle (Monthly, Daily, 
   Till Date), define time frame for which you want to run the report (you can leave them blank if you don't want to 
   define the time frame), provide rest of the mandatory fields and then you need to move one or more accounts from 
   the "Account From" table to the "Account To" table. Define "Action Type" (as Add or Subtract) for all the accounts 
   included in "Account To" table and save the report. This will define the criteria for report execution. To execute 
   the report navigate to Reports -> Account Summary Report -> Open Report, select the appropriate report name from 
   the drop down and click "Open" button. This will open account summary report screen. The results of the report 
   execution are shown here in a table based on the accounts and their relationship defined in manage account summary 
   report. You can change the predefined time frame here also and refresh the report. You can also see the accounts 
   attached to this report. This report is very useful to summarize various accounts you created in the application.
   
2. Miscellaneous Account Summary Report: This report can be used to combine one or more following account categories. 
   Here records are added at category level. All accounts under the added category are considered while executing 
   report.
     a. Bank Account
     b. Stock Account
     c. Loan/Policy Account
   Category accounts can be combined to get the desired report by adding them to the report or subtracting them from 
   the report.
   i.e. Total Cash = Bank Account 1 (All checking accounts) + Bank Account 2 (All savings accounts)+ Stock Account 1
        Total Money in Stocks = Stock Account 1 + Stock Account 2
        Total Amount Paid in Loan/Policies = Loan Account 1 + Policy Account 2
   To create such report first you need to define the report by navigating to Reports -> Miscellaneous Account Summary 
   Report -> Manage Report, this will open manage miscellaneous account summary report screen. Here select the option 
   "Include Blank Date" if you want to include transactions with bank date in calculation, define time frame for which 
   you want to run the report (you can leave them blank if you don't want to define the time frame), provide rest of 
   the mandatory fields and then you need to move one or more category accounts from the "Account From" table to the
   "Account To" table. Define "Action Type" (as Add or Subtract) for all the category accounts included in "Account To"
   table. For each account added in "Account To" table you also need to define the way transaction data is included in 
   the report execution. This varies based on the type of the category account you are adding. Here is the list of 
   options you can use for each category account type.
     a. Bank Account: Current Amount, Maturity Amount, Interest Amount
     b. Stock Account: Earnings, Current Value, Dividends, Fees
     c. Loan/Policy Account: Current Amount, Maturity Amount, Interest Amount, Total Amount Paid
   You can select 3 such values for each category account. Then you can also define if you want to include in-active 
   records in calculation by selection "Yes" or "No" option under "Include InActive" column of of the "Account To" 
   table. After defining report execution criteria save the report. To execute the report navigate to Reports -> 
   Miscellaneous Account Summary Report -> Open Report, select the appropriate report name from the drop down and 
   click "Open" button. This will open account miscellaneous summary report screen. The results of the report execution
   are shown here in a table based on the accounts, their relationship and the criteria defined in manage miscellaneous 
   account summary report. You can change the predefined time frame here also and refresh the report. You can also see 
   the category accounts attached to this report along with the relationship and criteria you selected. This report is 
   very useful to analyze your current financial status using miscellaneous accounts you created in the application.

Following are the search screens in the application to search for a specific record or transaction
--------------------------------------------------------------------------------------------------
1. Account Details Report: This can be used to see the expenses of a specific account for a specific period. It can 
   be also used as search screen to search and update specific transaction/expense/income. It has following sub menu 
   items:
     a. Monthly Expense: Navigate to Reports -> Account Details Report -> Monthly Expense, this will open the report/
        search screen for monthly expense accounts. Select the desired account from the drop down, provide the date 
        range for which you want to see the expense records. Now click "Run Report" button. You can use filters and 
        group by options to further refine your search or to see the expenses in different categories (Expense Mode, 
        Expense Type, Expense Sub Type etc.). Double click on a record to open it for update purpose. 
     b. Yearly Income: Navigate to Reports -> Account Details Report -> Yearly Income, this will open the report/search
        screen for yearly income accounts. Select the desired account from the drop down, provide the date range for 
        which you want to see the income records. Now click "Run Report" button. You can use filters and group by 
        options to further refine your search or to see the income in different categories (Income Mode, Income Type 
        etc.). Double click on a record to open it for update purpose.			    
     c. User Account: Navigate to Reports -> Account Details Report -> User Account, this will open the 
        report/search screen for individual user accounts. Select the desired account from the drop down, provide the 
        date range for which you want to see the transactions. Now click "Run Report" button. You can use filters and 
        group by options to further refine your search or to see the transactions in different categories (Amount, 
        Transaction Type, Expense Mode etc.). Double click on a record to open it for update purpose. In all these you 
        can use "Group Average" option to know the average (monthly or yearly) for different values of the selected 
        category (column). Double click on a record in table (when group average or group by option is not in use) 
        will open the selected record for update.
    
2. Transaction Search: Search for following 3 accounts is almost similar in functionality. 
     a. Bank Account: To open search screen navigate to Accounts -> Bank Account -> Transaction Search...
     b. Stock Account: To open search screen navigate to Accounts -> Bank Account -> Transaction Search...
     c. Loan/Policy Account: To open search screen navigate to Accounts -> Bank Account -> Transaction Search...     
   You need not to select category name or account name to perform the search. By default all categories are selected. 
   Option "Include Blank Date" can be used to include or not include transactions with blank date in search results. 
   Selecting option "Show Active Records Only" will not include transactions for accounts which are in In-Active state 
   or transactions for all the accounts where category is in In-Active state. Rest of the search functionality is 
   similar to the Account Details Report including the group average and group by functionality. Double click on a 
   record in table (when group average or group by option is not in use) will open the selected record for update.

3. Personal Address Book Search: This search screen can be used to search records from Personal Address Book accounts 
   based on given search criteria. To open the search screen navigate to Tools -> Personal Address Book -> Search...
   The search functionality is similar to the Account Details Report excluding the group average and group by 
   functionality as there is no money involved in these types of accounts. Double click on a record in the table 
   to open it for update.

4. Information/Reminder Search: Search for following accounts is almost similar in functionality.
     a. Information Account: To open search screen navigate to Accounts -> Information Account -> Search...
     b. Reminder Account: To open search screen navigate to Accounts -> Reminder Account -> Search...
   Here by default search is performed for all categories and accounts. Selecting option "Show Active Records Only" 
   will not include records for accounts which are in In-Active state and records for all the accounts where category 
   is in In-Active state. You can refine your search by providing search criteria in top panel of the search screen. 
   Double click on a record in table will open the selected record for update.
   
5. Password Manager Search: To open search screen navigate to Tools -> Password Manager. This will open password 
   manager screen, click on "Search" button to open the password manager search screen. Here by default search is 
   performed for all categories and accounts. Selecting option "Show Active Records Only" will not include records 
   for accounts which are in In-Active state and records for all the accounts where category is in In-Active state. 
   You can refine your search by providing search criteria in top panel of the search screen. After selecting a record
   in table you can click on "Select" button or double click on it to open it for update in password manager screen, 
   on doing so will close the search screen.

Following are the other functionalities provided by the application:
--------------------------------------------------------------------
1. Export: This is used to export the schema or data from the database to the flat file (.sql). Which can be used as a 
   backup file or to import it back into the newer version of application. To use export utility go to File -> Export...
   menu option. Select the appropriate tab, select relevant options and click "Export" button. It will ask for admin 
   user id and password (for security purpose). Provide it and it will create a ".sql" file at selected location. It is
   not advisable to use system tables while doing import for upgrading to the new version as in new version there might
   be some additional system data changes which were not there in current version of application. In most cases Export
   Data tab should be used to export user data with option "Add Truncate Table Statements?" selected.

2. Import: This is used to import user data into the database from a flat file (.sql), which was exported by the 
   application. To use import utility go to File -> Import... menu option. "Database" field shows the current database 
   type, provide location and name for file which you want to import, select relevant options and click "Import" button. 
   It will ask for admin user id and password, provide it and it will start executing sql statements from the imported 
   file in to current database. To see the rules and format of .sql file just click on "Import File" label. You can 
   also see logs for each sql statement executed in logs text area. From FAssistant version 4.00 onwards if you are 
   trying to import an old version file, application will give you option of using "Smart Import" functionality, using 
   this option any required database changes (because of version change) will be handled by the application 
   automatically. This does not guarantee to perform all required changes in the database, it depends the version of 
   the file you are trying to import.

3. Change Password: It is used to change the password for application or admin user ids. To open change password screen 
   go to Tools -> Change Password menu option. Select the user id from the drop down you want to change, provide 
   existing password, and new password to change the password. 
   There are 2 types of users
	 a. Application User: This user id/password is used when login to the application if (relevant option is activated 
	    during installation or in options screen.
	 b. Admin User: This user id/password is used to make you admin user for the application. This is required for 
	    import and export functions and during deletion of most of the category accounts. This is also required for 
	    seeing secured information under Information and Password Manager Accounts.

4. Options: This screen is used to set up the properties for the application. To open options screen go to Tools -> 
   Options menu option. After doing necessary changes in this click on "Save" button to save changes. You can do 
   following things in options screen.
     a. General Tab: Here you can set the default directory, which will be pre-selected when ever you do export, import 
        or save a file using "Save To File" functionality. Use option "Use native look and feel for windows?" to change
        the look and feel of the screens. Rest options are used to see the error details if there is some error 
        occurred during processing your request/action.
     b. Database Tab: Here you can change the database type, database file name, user id and password for database 
        connection and database driver. It is recommended not to change things in this tab and leave it to the default 
        values set during installation.
     c. Security Tab: Here you can select option "Prompt for authentication on startup?" so that when you start the 
        application you need to provide application user id and password, so no one else can open the application. Use
        option "Prompt for authentication for critical record delete?", so that application will need admin access if 
        you want to delete the categories of most of the account types. In this screen you can also define the minimum 
        password length you want to keep for both application and admin passwords you choose using Change Password 
        functionality.
     d. Application Tab: Here you can change the foreground and background color of in-active records shown in table in
        all the screens. You can choose option "Show only active records in Table?" to show or not show in-active 
        records in table by default when screens are opened. Use option "Show Reminder Messages on Main Screen?" to 
        show or not show three reminders tables on main screen. Use option "Save Main Screen Layout on Exit?" to save 
        the layout of main screen when you exits from the application. So that when you login next time the layout of
        main screen will be same as it was before login out last time.         
     Note: some of the options (starting with *) in all these tabs may require application restart to get it activated.

5. Template: This screen can be used to update or delete templates of all account types. To go to this 
   screen navigate to Manage -> Template, this will open template details screen. All the templates added 
   from various account types are shown here. Here you can change template name, template description or status of a 
   template. You can also delete a template from this screen. To update template specific data you need to go to the 
   respective transaction details screen. Template can be created for following types of transactions, accounts, categories.
     a. Monthly Expense
     b. Expense Type
     c. Expense Sub Type
     d. Expense Mode
     e. Yearly Income
     f. Income Type
     g. Income Mode
     h. Individual User Transaction
     i. Bank Account Transaction
     j. Stock Account Transaction
     k. Portfolio Category
     l. Price Watch Category
     m. Loan/Policy Account Transaction

6. Currency: This screen can be used to add/update/delete currencies in the application from a pre-defined list of 
   countries and currencies. To use this functionality navigate to Manage -> Currency, this will open currency details 
   screen. To update an existing currency double click on the currency in the table, this will show the selected 
   currency in update mode. To save the changes you need to login as admin user if you are not already an admin user. 
   You can change the country name or symbol of the currency. If "Default Currency" option is selected, it means that 
   this is a default currency available to the application and can not be deleted from the application. Currently there
   are only 3 default currencies. You can always add/update/delete the custom currencies to/from the application. 
   To add a new currency to the application click on "Add Currency" button, this will "Add Currency To Application" 
   screen. There are about total 80 countries/currencies defined in this application, but these are not available to 
   the application you manually go and add them to the application. Only default currencies are available to the 
   application always. Select the country/currency you want to add to the application and click on "Add to Application"
   button. This will make this new currency available to the application and this will be shown in currency drop down 
   shown in various screens.

