tag:blogger.com,1999:blog-21508607447120264922011-12-03T10:37:59.714-08:00crystal ball on the table showing you the future!!!vinnyhttp://www.blogger.com/profile/12838594465564163582noreply@blogger.comBlogger11100tag:blogger.com,1999:blog-2150860744712026492.post-8831464441274561752008-09-28T07:44:00.001-07:002011-11-06T20:50:23.531-08:00<div dir="ltr" style="text-align: left;" trbidi="on">its all very simple !!!. First of all, click on "click to edit" on top right hand corner above spreadsheet.<br /><br />1) pick up your latest salary slip .<br /><br />2) fill all the credits(<span style="font-weight: bold;">black and blue colored letters</span> ) and then debits(<span style="font-weight: bold;">red colored letters</span> ) as given in the salary slips into the respective field of the spreadsheet.You are free to change the allowances into the ones relevant to you. for e.g you can change specialist pay to separation allowance..and so on and so forth.<br /><br />3) just remember that the credits in <span style="font-weight: bold;">black letters</span> are taxable and ones in <span style="font-weight: bold;">blue</span> non taxable.<br /><br />4)fill your existing bank balance and Provident fund/DSOP balance into letters in <span style="font-weight: bold;">blue</span><br /><br />5) tax is calculated automatically and it takes into account deductions eligible to you like DSOP/PF/GROUP INSURANCE e.t.c. Also the "<span style="font-weight: bold;">pay to bank</span>" is calculated from the info provided.<br /><br />6) now click on <span style="font-weight: bold;">year planner tab</span> on the bottom of the sheet.<br /><br />7) fill details about monthly recurring expenses here(left hand pane) <br /><br />8) you may add unexpected credits ( like arrears ) and debits (eg. recovery) in respective coloumns.<br /><br />9) now click on various tabs given at the bottom and enjoy the <span style="font-style: italic; font-weight: bold;">analysis and projections</span>.<br /><br />10) budget update is to edit tax slabs if there are any changes in the next budget.</div><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/2150860744712026492-883146444127456175?l=paymatrix.blogspot.com' alt='' /></div>vinnyhttp://www.blogger.com/profile/12838594465564163582noreply@blogger.com1