Bank Remittance Challan - In Excel & Calc

Bank Remittance Challan - In Excel & Calc (Ubuntu)

Nicely designed fully automated Bank Remittance Challan. This file will reduce your time and effort to prepare Challans. Challan Format includes Figures to words conversion and Denomination columns.

Click the following links to download Challan. 

Microsoft Excel Users Download from here 

Libre/Open Office Calc Users Download from here


Manoharan PN
Ashtami, Vaikom
9496804046
ashtamim@gmail.com

Malayalam Unicode Fonts ( മലയാളം യൂണികോഡ് ഫോണ്ടുകള്‍ )

Malayalam Unicode Fonts 
( മലയാളം യൂണികോഡ് ഫോണ്ടുകള്‍ )

Three New Malayalam Unicode Fonts
(1 True Type & 2 Open Type)
Ashtami New - Open Type
Ponnu  - Open Type
Ashtami Old - True Type
&
Anjali old Lipi, Dyuthi, Suruma, Reghu Malayalam and Meera
Type Samples:

Download Fonts : ഡൌണ്‍ലോഡ് ഫോണ്ട്

DOWNLOAD CDAC UNICODE TYPING TOOL 

Smart Pension Setup

SMART PENSION (SINGLE FILE SETUP – RE-POST)

All New software for Pension Automation.  Fully advanced, hassle fee & user friendly tool to manage all most all pension works.

System Requirements:

• A trouble free, smoother running, well maintained machine with
• Operating System Windows 2K or Higher. WindowsXP recommended
• A Minimum of 256 MB RAM, 512 MB recommended.
• MS SQL Server 7.0 or higher
• 130 Column Printer (Wipro 1040+, Wipro  LQDSI 5235, TVS MSP 345 or similar)

Download SmartPension Setup

SMART PENSION UPDATE UPLOADED ON 09.07.2014
SMARTPENSION FORM16 - PART B UPDATE  AS ON 08.03.2015

1.      Please download the attached ZIP file ‘PensionSetup.zip’ (Required Broadband internet connection).

2.      Download and Copy this file to the target machine (at first Choose a machine with SQL Server Installed, This is required, to create Database and other initial settings). Unzip and Double click (execute) the ‘PensionSetup.exe’. Please follow onscreen informations to complete the installations.

3.      Installation process is fully automatic. Setup will create all initial working environments, including new Database, DSN, and other settings. In Multiple SQL Server environments, setup will choose the default available server for DSN. When starting application from Client, if it is not starting, please check the DSN and name a correct server that you are using.

4.      You must install a copy of Smart Pension in your server machine, because DATABASE CREATION procedures are included along with the setup. During the final stage of installation ‘New Database Creation’ wizard will appear. This wizard will help you to create Pension Database. For test purpose you can also load sample data during this process.  You can also start this wizard from Smart Pension Program Group at any time after installation. Please cancel this wizard during client installations.

5.      After Database Creation wizard finishes it’s job, Setup will also start the Data Migration tool – a tool which help you to migrate your pension data from Microsoft Excel to SQL Server. A Microsoft Excel Template file is provided for this purpose.  You can open this file from the Smart Pension Program Group for later use.  This is a specified format file for the migration purpose and the format should not be altered. 

6.      Copy your pension details from your existing excel file and paste the same into the specified format file correctly.  Please note that certain ‘Comments’ (a red indication will be displayed in the top right portion of the cell) in the column labels of Excel sheet. Please read & understand all comments provided. Columns for Certain Codes are provided, namely PTYPE & PMODE. PTYPE is for pension type i.e. 1 for Service Pension and 2 for Family Pension.  PMODE is for Payment Mode, i.e. 1 for Through Bank, 2 for Money Order Board’s Cost and 3 for Money order Pensioner’s Cost.  Up to Column NP is considered as Basic Pension Details.  You can migrate to SQL server with these details. 

7.      Details such as Designation and Category are optional, but are required for printing Budgetary Control forms.

8.      Address details are optional for printing Money order forms and Pension Certificate, etc.

9.      It is a good idea to enter these details in the template file and migrate to SQL Server.  Because after migration process you have to update these details in PPO Number wise. i.e. Select one PPO and Update details, then select another PPO and so on.

10. Optionally you can do migration partly, i.e. in first part with basic payment details (columns up to NP) and Second part (for address details) with columns, PPONO, Name, Designation, Category, HName, Place, PO, PIN filled. Select the ‘Update Address only’ Check Box for this purpose. How ever before doing this (2^nd Part) you should migrate basic pension payment details. i.e. the first part should be done in advance.

11. The Software is password protected. Due to security reasons the password is not published here. Please ring to 9496804046 or mail at ashtami@sify.com for the default password. Please change your password in the first use for security.  You can also add additional users in the user settings screen.

For more information and support kindly contact me:

P.N. Manoharan, CA, Civil Circle, Pallom, 9496804046, ashtami@sify.com. Please be specific in your queries.

 

Thanking You

P.N. Manoharan

Ashtami, Vaikom.

 

Smart TA Bill - TA Bill Preparation Tool - Updated

Smart TA Bill - Updated

An Application for preparing TA Bills for Officers (TR 47) & Staff of Kerala State Electricity Board.  Program is now updated with Full Month activity preparation view and Importing Progress Report directly from Excel file with a Specified format.

How to Use:

1. EMPLOYEE DETAILS

1.   Before you start using TA Bill, Please furnish your ARU Settings and Office lists in the Settings Screen.

2.   Select the Month & Year of TA Bill to be prepared.

3.   Enter the PIN (Must be a Number) of an employee and furnish the following informations correctly:

a.       Name of Employee

b.      Office

c.       Category

d.      Designation

e.      Pay

f.        Scale of Pay

All these informations are required.

2. ACTIVITY DETAILS

4.   Next select the Activity Mode. It may be JOURNEY or HALT. Alternatively you can select from the previously prepared activities.  This will automatically fill the FROM, DESTINATION, KM, and RATE columns automatically.

5.   Enter Starting Date and Time.

6.   Enter Starting Location, Select Conveyance, Enter Purpose, Destination, KM and Rate.

7.   Enter Reaching Date and Time.

8.   Enter DA (limits will be displayed) and Click Add. If you are correcting an existing activity details, then Click Update instead of Add. You can also use Delete option to delete an existing Activity record.

9.   Repeat the steps 4 to 8 for adding more activity details.

Note: Activity Details Now include Full Month activity View: This will help to mark the following Activities quickly:    Attended Office, Leave, Holiday, etc

3. BILLED EMPLOYEES

10. Each billed employees will be added to this list.  The list is filtered for the selected month and year. However you can click the SHOW ALL EMPLOYEES button to list all Billed Employees. To quickly load the Details of an employee, you can Check ( Tick mark) that employee and Click the SELECT FOR BILL ENTRY (You can also enter the PIN and press Enter Key to load the details of an employee). To take outputs check all the employees who are included in the printouts.

4. OUTPUTS

11. Check the Employees list and Click following options for output:

a.      Progress Report                        -           to Print Progress Report

b.      Pint Bill                                      -            to Print TA Bill.

c.      Print Outer                                -            to Print TA Bill outer.

d.      Print Abstract                            -           to print Abstract of TA Bill.



DOWNLOAD SMART TA BILL UPDATED SETUP


Existing Users can Update by clicking the following link
Update Smart TA Bill (28.06.2016)

For more information kindly contact me.

Manoharan P N

Ashtami, Vaikom

9496804046

Crediting Salary & Other claims - Bank Statment

Crediting Salary & Other claims - Bank Statement (SmartStatement) program is updated. Now you can Import Combined Salary Statements from HRIS to prepare Bank Statement of Salary.

Prepare Bank Statement, CSV/XLS File and Mail in single step. 

Updated with Pension Master Trust Statements.

(PLEASE DON'T FORGET TO SET YOUR SALARY DEBITING A/c No and Pension Master Trust A/c No. IN THE SETTINGS!)

Download Updated Bank Statement setup

LATEST UPDATE (28.03.2016)
(ADDED PENSION BANK STATEMENT FROM HRIS)

For further information please contact:

Manoharan P N

Ashtami, Vaikom

9496804046

Smart Pay Fixation Release Version 3.1 Build 46

Smart Pay Fixation Release 
Version 3.1 Build 48

Trouble Shooting:
Corrections in Pay Scale, Stages, Designations and other various rates can be corrected by the user by selecting Settings option.

<For trouble free downloading use Mozilla Firefox browser>

(Personal pay rounding update)

Download Smart PayFixation Update build 48 
 



Download Smart Payfixation fresh Setup (Including all Updates) 

This is a fresh setup, which will replace your existing installation and data.  It is intended for the use of fresh users. Existing users can use the above update ( Version 3.1 Build 46).

!!!!!!!!!!Please post your comments about this program!!!!!!!!!

Thanking you,

Manoharan P N
Ashtami, Vaikom
9496804046

Smart Pay Fixation Update Release Version 3.1 Build 45

Smart Pay Fixation Update Release 
Version 3.1 Build 45
New Changes

• Fixed some Errors & incorporated suggestions from various offices.
• Add Certificate in Pay Fixation Statement.
• Given a provision for pay fixation using stepped up pay in option B
• Given a provision for give an increment after arriving the pay in next stage in higher scale.  

Update Note: Important
This update is a continuation of my first update of this software. So If you are going to update the software for the first time use the first update (Update Version 3.1 Build 36) first and then this update. Those who are already updated the software using  Version 3.1 Build 36, need only the second update. Please note that the Build 36 update will replace your existing data.

Trouble Shooting:
Corrections in Pay Scale, Stages, Designations and other various rates can be corrected by the user by selecting Settings option.


<For trouble free downloading use Mozilla Firefox browser>

Download Update release Version 3.1 Build 45



!!!!!!!!!!Please post your comments about this program!!!!!!!!!

Thanking you,

Manoharan P N
Ashtami, Vaikom
9496804046