Home

User Manual - Home Money Manager

1. 26 2 2 Select a Statement and Chooseatie 27 2 3 Using the IMPON Wiza O EE 28 2 4 Step 1 Specify the File E Ve EE 28 2 5 Step 2 Select the Transaction Amoumt eee 29 2 6 Step Select the Second Transaction 32 2 7 Step 4 Select the Transaction Date 33 2 8 Step 5 Select the Transaction 34 2 9 Step 6 Import the Transactions into the Statement 35 2 10 Import Failed MCSSAGS E 36 ERNEIEREN 36 TINE E EE 37 5 How do get my transactions into an import lei 37 6 How do import my transactions from a spreadeheer 38 Category Auto Marching 39 S 39 Previously Matched Transachons sess nna 39 Category Wildcard Patterns lsseesssssssssssssssseeee nennen nennen enne nnne nnns 39 Hestrichons mM 39 Running the Auto Match tool 40 www homemoneymanager com au 2 Home Loan Manager Pro User Manual EE ee le EE 41 41 Statements and lt I Eet en E 41 Ia det 41 PODON 41 gt eebe 43 Account Details Screens 43 Statement Details Gcreeng 46 Transaction Details Screen 47 In
2. Target Loan Term 25 00 a 3 jo Help Once you have used the detailed payout plan report to work out how many years you can afford to cut off you loan 1 lock your Target Loan Term into the screen You will then 2 be shown exactly what you have to do to reach your goal and by clicking on the chart button 3 you can see exactly when you will be debt free and how much you will save www homemoneymanager com au 69 Home Loan Manager Pro Your Payout Plan Ta repay this loan in a total af 25 00 years and save approximatety 101 774 54 In interest charges the month repayments must be increased by 188 21 ta 2 693 91 for the next 21 50 years Loan Terr 20 00 Years 455 079 52 350 Jan 2010 Jan 2015 Jar X120 Jan 3025 Ja SO Janc2135 Date Balances from Statements 5 Target Balances Loan Balances Target Interest Loan Interest V Display Statement Balances W Display Remaining Balances 7 Display Interest Payable www homemoneymanager com au User Manual 30 000 3 3 E m 70 Home Loan Manager Pro User Manual Interest Calculations When you first set up an account in Home Loan Manager Pro you may need to fine tune the interest calculation settings to match those used by your lender This help topic is the best place to start if the interest checker report is displaying errors Calculating Your Interest Interest Checker Report Errors Interest Errors S
3. Date End Date bihrewais Berosis I 6iosine Balai 5 callidi Moral RENE ica rli a 337 906 55 0 20 01 07 2010 31 12 2010 337 906 55 0 00 0 00 010 01 01 2010 30 06 2010 339 822 39 pm I 5 047 22 DU 18 2009 01 07 2009 31 12 2009 341 594 79 13 274 82 15 047 22 339 877 39 18 0101 2009 30 06 2009 343 371 25 13 270 76 15 047 22 41 594 79 O08 01 07 2006 31 12 2008 345 008 81 13 405 66 15 047 22 343 371 25 008 i 01 2D08 30 06 2008 346 707 52 12 825 58 14 524 29 345 006 81 2Do7 O1f07 2007 31 12 2007 348 474 31 12 234 57 14 001 36 346 70 7 52 18 2007 0101 2007 30 06 2007 0 00 350 142 11 11 667 60 348 474 31 16 When entering statements you are not required to enter the Closing Balance as it is automatically calculated by adding the transaction Withdrawal and Deposit amounts to the Opening Balance As we have not yet added any transactions to our new statement 6 the Withdrawal and Deposit amounts are both 0 00 and the closing balance is the same as the opening balance 6 Adding Transactions Now that the statement has been set up we can enter the transactions 1 Switch to the transaction view and 2 check that you are working with the correct statement The 3 transaction view will show you the transactions you have entered for a statement including the default opening and closing balance entries www homemoney
4. tert ate 01 05 2010 ken 31 05 TM 10 2375 2010 Ee ta 27 05 2010 2605 2010 25 05 2010 24 75 2010 2306 2010 2205 2070 21 05 2010 19 05 2010 18 05 2010 17 5 2010 ja 052010 15 05 2010 14 05 2010 335 193 43 336 183 43 236 183 43 338 183 43 33B 183 43 339 183 43 336 183 43 236 103 43 336 183 43 339 183 43 338 183 43 338 183 43 338 183 43 336 183 43 338 183 43 339 183 43 338 183 43 7 725096 7 2506 7 250 7 250 7 200 7 25096 7 250 7 250 7 250 7 2509 7 250 7 250 7 250 7 200 E 14 n 039865 3 6 0 019653 0 019653 0 019643 n 0198535 0 019653 0 019653 0 01963 0 019643 0 00966 3 0 019653 0 019653 0 01963 0 019865316 n 01985359 n 0198536 0 019653 nuls ann Lice 7 173421 57 173421 67 173421 67 173421 67 173421 57 173421 B7 173421 67 173421 67 173421 67 173421 57 173421 67 173421 67 173421 67 173421 67 173421 57 173421 B7 173421 Di eic www homemoneymanager com au K i Daily Loan ec Rate Interest 0 000 0 000 0 000 0 000 0 000 0 000 0 000 0 000 0 000 0 000 0 000 0 000 0 00096 Q 00095 0 000 0 000 0 000 Rate 3 ODDO E 000000 DOUODODOLD T 0 0000009 QUD00000 t DUODODOD 9 DUODODOD 8e DOUD Q O0000056 QUO00000 se GUO00000 DUODODOD 58e ODDO T O ODODOC H DOUODODOC t 0 000000 DUODODOD 4llowable Offset Int 0 000000 0
5. www homemoneymanager com au 63 Home Loan Manager Pro User Manual YEARLY COMPARISON LINE OF CREDIT Mrs A Citizen DEPOSIT TEE 5 30 b x THORAW AL 1 EE 1 548 17 45 516 82 7 Statement Comparison Report The statement comparison report allows the comparison of transaction totals by category detail or parent category summary between two statements Statement Comparison Repo t STATEMENT COMPARISON LINE OF CREDIT Mrs Citizen Emme liDetal Compare 01 01 2001 31 03 2001 To 1 04 2001 20 06 2001 Can Amount ere el 5 18 133 07 22 406 93 5 342 09 4 705 16 A 625 93 17 863 77 27 DZ ID 9 777 26 www homemoneymanager com au 64 Home Loan Manager Pro User Manual STATEMENT COMPARISON LINE OF CREDIT Mrs A Citizen DEPOSIT 18 1335 07 WITHORAMWAL if ane 01 01 2001 31 03 2001 01 04 2001 30 06 2001 01 01 2001 31 03 2001 01 04 2001 30 06 2001 www homemoneymanager com au 65 Home Loan Manager Pro User Manual Plan For The Future Worried about interest rate rises Want to find out how to pay off your mortgage sooner The following reports will give you answers and keep you informed as you circumstances change 8 Increase Repayments Report 9 Detailed Payout Plan Report 10 Interest Rate Rise Report 8 Increase Repayments Report Can you really save thousands if you increase you
6. 0 000 0 000 0 000 0 000 0 000 0 000 0 000 0 000 0 000 0 000 0 000000 TOTT w OG D ODODOL t 000000 ed da KKK C ODODOLD oe 000000 o 0000009 0 000000 00000001 00000 0000000 0 000000 0 000000 00000001 0000000 0000000 0 000000 0 000000 D DUDEN 000000000 67 116424 57 118324 67 118424 amp 7 118424 amp 7 118324 57 118324 b 7 118324 67 118424 amp 7 118424 amp 7 118324 57 118324 57 118324 67 118424 amp 7 118424 amp 7 118324 57 118324 59 Home Loan Manager Pro User Manual Investigating Interest Errors If you find a discrepancy between the interest being charged by your lender and the estimates being calculated by Home Loan Manager Pro you can use the daily interest report to review the day by day interest charges that make up the estimate The report will also show you the interest rate that has been applied on each day From the interest checker report click on the Daily View icon for the interest charge you wish to investigate and 5 the daily interest report will be pre populated with the correct date range e Daily Interest Report DAILY INTEREST REPORT HOME LOAN Mrs A Citizen account Number 06 0233 1238 9403 221 Lender Name Bank of the World Daily Rat otal Loan interest 2 082 38 Total Offset Interest 0 00 Total Interest Payable 2 002 38 ind Date 31 05 2010 Ende 31 9 Refresh Reset
7. Refer to the Interest Calculations help topic for more information This field impacts the date range used in the interest checker report Normally a lender will calculate interest up to the day prior to them charging you For example if you have an interest transaction on your statement with a date of the 25 of May then it is most likely for the period ending the 24 of May www homemoneymanager com au 44 Home Loan Manager Pro User Manual Home Loan Manager Pro automatically estimates the date range used by your lender in their interest calculations by using the date you enter for the interest transaction and the value you enter into this field For example if your interest transaction is dated the 25 of May and this field is set to 1 then the interest checker report will calculate the interest up to the 24 of May If you set this field to 2 then it will calculate interest up to the 23 of May and so on If your lender does not follow a set pattern or they process a transaction late one month then you can edit the individual interest transactions and manually specify the required end date in the field Date Interest Calculated Up Tip Refer to the Interest Calculations help topic for more information on interest period date ranges OFFSET ACCOUNT DETAILS Offset Account If you are currently viewing a loan account then this field will display the for this Loan offset account you have linked to it The drop d
8. 2 508 55 2 152 42 2 275 99 2 156 39 2 230 06 2 017 14 2 235 02 2 236 78 2 166 76 2 240 71 2 170 55 2 244 60 2 246 29 2 175 01 2 250 11 2 179 58 ZB 2506 2 507 89 2 161 07 2 225 46 2 155 86 2 229 53 2 016 61 2 234 49 2 236 24 2 186 23 2 240 18 2 170 02 2 244 07 2 245 786 2 175 39 2 240 57 2 179 05 e ee ee ee un Tip Check that each interest transaction has been allocated an INTEREST category Check that no other transaction has been allocated an INTEREST category The Interest Checker Report will only process transactions that have been allocated a category of type INTEREST If the report is missing an interest transaction then close the report look for the missing transaction in the account and assign it an INTEREST category If the report is displaying transaction that are not interest charges close the report look for the transaction in the account and change their category to something other than INTEREST Example missing INTEREST transaction The following example is from Home Loan account in the sample workbook where we have changed the category on the interest transaction dated 1 April 2007 from the correct value of INTEREST Periodic Interest to an incorrect value of FEE Other NOTE These errors are fairly easy to find as shown below www homemoneymanager com au 78 Home Loan Manager Pro Use
9. W 31 12 2010 Statement Closing Balance 336 243 14 i IMPORTANT If you assign the INTEREST category to transactions that are not interest charges the reports will not produce the correct results 7 3 Automatically Assigning Categories One of the unique features of this software is the Auto Matching tool which will save you having to manually select categories for every transaction It is designed to detect patterns in the categories you are manually selecting and then automatically match categories for you Run Category Auto Matching The Category Auto Matching tool can instantly assign at least another 5 categories for vou start the tool please click on the Run Now button In future vou can run the matching tool at any time by selecting Auto Match fram the Action menu ar the Toolbar www homemoneymanager com au 21 Home Loan Manager Pro User Manual For example when 1 a category is assigned to the first INTEREST CHARGED transaction in the statement the software detects that there are another five interest transactions in the statement that it can automatically match If you choose to run the tool it will 2 update the categories on the other interest transactions Full details on the category auto matching process can be found in the category auto matching help topic TRANSACTIONS HOME LOAN Mrs A Citizen DEE e Gadd Gr Edit G Delete Statement 2010 01 07 2010 31 12 2010 18 transact
10. for non leap years Lenders generally use a fixed 365 days even on leap years You can check the value your lender uses by looking at your loan contract or accompanying documents your lender has provided you with explaining you interest charges Therefore if you have selected Actual and the interest checker report is showing a small error on every interest charge for leap years eg 1996 2000 2004 2008 etc then you may need to change the value back to 365 Example Leap Year Problem The following example is from the Home Loan in sample workbook where we have changed the Days In Year field from the correct value of 365 to an incorrect value of Actual Errors are being displayed in the leap year www homemoneymanager com au 74 Home Loan Manager Pro Interest Checker Reporta INTEREST CHECKER HOME LOAN Mrs A Citizen Account Number 06 0233 1738 4403 7271 Total Estimated Interest Total Interest Paid 1I02 599 39 Notes There are 12 errors in the table below Click on the fields with red borders for more details on each error tart Lote End Date i INTEREST CHARGED INTEREST CHARGED INTEREST CHARGED INTEREST CHARGED INTEREST CHARGED INTEREST CHAR GEL INTEREST CHARGED INTEREST CHARGED INTEREST CHARGED INTEREST CHARGED INTEREST CHARGED INTEREST CHARGED INTEREST CHARGED Error Tolerance 0 005 Interest End Date Danis Interest Start Date 02 2009 01 01 2009 1 12 2008 01 11 2008 1 10 2008 01
11. loans in it however there is no limit to the number of workbooks you can create What Next Open the sample workbook and take the software for a test drive To find a sample account that is similar to your own loan refer to the sample workbook help topic for a description of each of the accounts in the workbook For step by step instructions on setting up your own workbook adding a loan and entering your first statement refer to the entering your loan details help topic www homemoneymanager com au 8 Home Loan Manager Pro User Manual Sample Workbook The easiest way to try the features of Home Loan Manager Pro is to open the sample workbook and have a play with the example accounts You can open the sample workbook at any time by selecting Open Sample Workbook from the File menu Once the workbook is open 1 the example accounts are listed on the left hand side of the screen under the ACCOUNTS title and 2 you can view the different accounts by clicking on the name in the list S SUMMARY 98 Hide Payout Plan INTEREST ONLY LOAN Mr A Citizen ACCOUNTS Sb Add sr Edit Delete HOME LOAN Mrs citizen Keep Accurate Records HOME LOAN REDRAW Mrs Current Balance 170 984 46 Balance Date 30 06 2006 Current Interest Rate 6 990 I D Statements Transactions Interest Rates Remaining Loan Term 18 18 Years INVESTMENT LOAN Miss Ci L
12. 2 740 21 2 740 21 aN 337 906 5 335 308 68 337 551 10 337 556 10 334 815 80 337 324 44 337 329 44 5 334 589 23 337 096 10 337 101 10 5 X34 360 89 5 336 785 25 5 336 790 25 5 334 050 04 5 336 552 90 5 336 557 90 5 333 81 7 69 5 336 738 14 336 243 14 336 743 14 8 th F Ee 4 Bere GE Select Category Seea Category Select Category Select Category Select Category i Select Category Select Category H 19 Home Loan Manager Pro User Manual 7T Assigning Transaction Categories By assigning categories to your transactions the reports can group and total the costs on your loans You can instantly find out the total you are paying in fees how much interest you paid how much you repaid this period and so on 7 1 Manually Selecting Categories To manually select a category for a transaction 1 click on the transaction category you wish to change and 2 choose a category from the list Tip You can modify the existing categories and aad your own by selecting the Maintain Categories option from the Category menu 7 2 Using the INTEREST Category The INTEREST category is a special category that is used by the reports to check your lender s interest calculations All 1 interest transactions in your statements should be 2 assigned the INTEREST Periodic Int
13. Loan Repayment Outstanding Loan Plan Term Loan End Date Term Amount Interest Original Payout Plan 30 00 23 04 2033 28 06 652 37 121 925 94 Target Payout Plan 20 00 26 04 2023 18 06 785 61 72 523 36 Total Impact 133 24 49 402 58 NOTE The information was produced for a loan currently in its second year of repayments that is 28 years remaining with monthly repayments As well as the target loan term you can change any of the following The interest rate The loan balance The option to include the offset balance if applicable The repayment frequency The current date oe os Note You need to set a Loan Term on the Loan Account for the report information to be accurate If the report displays Original Loan Term years 0 0 you will need to close the report Edit the loan account and enter a value for the Loan Term 10 Interest Rate Rise Report If you are worried about the impact of future interest rate changes and interest rate rises in particular then this report will help www homemoneymanager com au 67 Home Loan Manager Pro User Manual The report lets you to enter a new interest rate for a loan allowing you to see how much better or worse off you will be when interest rates change The report shows the old and new estimated repayment amounts and the total outstanding interest payment for the remainder of the loan You will know in advance how much extra a rate rise will cost you allowing you to better prepar
14. NOTE The amounts include the full benefit of your offset account if you have one linked to the loan 5 The difference between the two interest amounts If the amount is positive then you have been overcharged If the amount is negative then you have been undercharged The offset account section of the report click on the Offset Account tab has two additional columns 1 The amount of interest you have saved by using an offset account 2 The amount of interest you would have paid if you didn t have an offset account Editing Transactions If you need to change a transaction you can Edit Transactions directly from the Interest Checker Report by double clicking on the transaction you wish to edit Any changes you make to transactions will instantly be reflected in the report Interest Checker Report ex INTEREST CHECKER HOME LOAN Mrs A Citizen Account Number 06 0233 1238 9403 721 Lender Name Bank of the World Total Interest Paid 86 003 60 Total Estimated Interest 64 375 54 Total Difference 3 708 34 Mates There are 27 errors in the table below Click on the fields with red borders for more details on each error Start Date End Date Transaction Transaction EditTransaction Details m lt os Date Description oe nu Daily Difference view Transaction Details 01 01 2008 INTEREST CHARGER n x O1 i2 2008 IN
15. Topics STATEMENTS HOME LOAN Mrs A Citizen m ap Add Edit Le Delete Y MANAGER manager Ccorm au E YT 14 NL how uwslIAAAL Aa nA Jr ki 13 131 3H Statement 8 Page 1 of 1 1327482 339 822 39 18 SEET j 15 047 22 341 594 79 18 statement begins 01 July 2010 deg 15 047 22 343 37125 31 December 2010 Statement ends 12 625 58 14 524 29 345 008 81 12 234 57 14 001 36 36 707 52 350 142 11 11 667 60 446 474 31 Opening Balance www homemoneymanager com au 22 Home Loan Manager Pro User Manual 8 Adding Interest Rate Changes The last step to entering your statement information is to enter any interest rate changes for the period If there have been no rate changes then you can skip this step To add the interest rate changes 1 switch to the interest rates view for the account and then 2 click on the Add button to open the interest rates details screen File View Action Report Category Help Open H Save Import Transactions bo Auto Match About E Help Topics ACCOUNTS s Add Edit be Delete Summary EN 1 000 to L Statements Using the example statement from above 3 there is one interest rate change to add to the account Date Transaction Description Dehits Credits Balance 337 906 55 Enter 4 the date the interest rate changed along with the new rate If you h
16. account Reporting Most of the reports are designed to be run against the loan account not the offset account That is you should select the loan account before running the required report The Interest Checker Report will automatically include the balance of the offset account when it calculates the Estimated Interest Paid for your loan To see the details of the offset account interest you are saving select the Offset Account tab in the report The Refund Calculator Report will automatically include the balance of the offset account when it calculates the refund amounts for your loan The Daily Interest Report provides a detailed breakdown of the loan account and offset account information including the balances daily interest rates interest on each account the allowable offset amount and the total interest that should have been charged per day www homemoneymanager com au 41 Home Loan Manager Pro User Manual The Planning Reports give you the option of including the offset balance in the calculations so that you can instantly see how much you will save in interest charges over the life of the loan www homemoneymanager com au 42 Home Loan Manager Pro User Manual Screens This page provides an overview of the main screens used to enter your loan information into Home Loan Manager Pro Click on the screen name below or scroll down the page for more details on each 1 Account Details Screen 2 Statement Details Scree
17. account reduces the amount of interest charged on the loan So far the homeowner has made several additional repayments to the loan from bonus overtime earned and a tax refund and has also made one large withdrawal to help with house renovations The homeowner has also set up a payout plan to help them cut 2 years off the loan and is on track to save over 56 000 in interest charges if they manage to increase their repayments by and approximately 65 each month Interest Only Loan Mr A Citizen Example of an investment property loan This loan is a 20 year investment interest only loan with variable interest rates and a monthly account keeping fee The homeowner switched the loan in the first three months to remove the account keeping fee and to take advantage of a better interest rate Investment Loan Miss A Citizen Example of a share trading or margin loan This investment loan is a 20 year line of credit with no repayments and variable interest rates The homeowner negotiated a discount of 0 5096 off the standard interest rate and all interest charges are being capitalised back into the balance Each time a share parcel is purchased it is funded directly from the loan Line of Credit Mrs A Citizen Example of a mortgage being set up as a line of credit with all income and expenses going through the loan This loan is a 30 year line of credit with principal and interest repayments and the ability to frequently de
18. balance and is automatically updated every time you enter your latest loan details keeping you on track every step of the way Importing Transactions To save you manually typing in all your historical details if you have access to your transactions via your Internet banking website or you currently have them in a spreadsheet the import wizard will help you load them in seconds Refer to the importing transactions help topic for more information www homemoneymanager com au 7 Home Loan Manager Pro User Manual Transaction Categories To help you get the most out of the loan information you enter into Home Loan Manager Pro you can allocate categories to your transactions for example a transaction may be a FEE or an INTEREST charge or a DEPOSIT or a WITHDRAWAL etc You can use the default list of categories or you can set up your own Category Auto Matching To save you manually allocating categories to every transaction Home Loan Manager Pro provides you with a Category Auto Matching tool This tool will automatically allocate categories to new transactions by examining categories you allocated in the past and by using any category wildcard patterns you set up Refer to the category auto matching help topic for more information Workbooks Home Loan Manager Pro stores all your loan information in a file on your computer called a workbook with a file extension of bon Normally you would set up one workbook with all your
19. converted to a newer version it will not work with older versions of Home Loan Manager Pro therefore we recommend you keep a backup of the older workbook If you do not see the above message when you open your workbook then a conversion was not required www homemoneymanager com au 86 Home Loan Manager Pro User Manual Customer Support If you would like to provide us with your feedback or you are having problems using Home Loan Manager Pro please visit the support pages on our website to submit your comments and to read all the latest help and support information www homemoneymanager com au 87
20. entered a5 Eun 060 58 1 1 wi wdrawal wien they shouid have been entered as a oss 300 45 deposit or visa versa resulting in ap incorrecthy VERAS Di Ge 2010 1 calculated closing balance 332 383 45 Q1 02 2010 One ar more transactions in the previous statement eas 149 43 01 01 2010 ACT are missing or have been added bace resulting in an 332 655 30 0101 2010 1 incarrectty calculated closing balance 999 651 30 01 01 2010 FAYE Pas 414 52 em Te fix this problem check the opening balance on this 9 922 39 Statement nas been typed in cormecth check that as the transactions the previous statement nave been entered comecthy and Check if there is a statement missing between the two and enter it if necessary kiki tb Editing Transactions If you need to change a transaction you can Edit Transactions directly from the Balance Checker Report by 7 double clicking on the transaction you wish to edit Any changes you make to transactions will instantly be reflected in the report Balance Checker Repor 22 BALANCE CHECKER HOME LOAN Mrs A Citizen Account Number 06 0233 1238 9403 7271 Lender Name Bank of the World Mares There is 1 error in the table below Click on the fields with red borders for more details on each error Start Date _ End Dabo EIL Dk ue 0 005 i Rosch EH Groot Hd Han zx II
21. help topic Sample Workbook When you first start Home Loan Manager Pro the sample workbook is automatically opened so you can take the software for a quick test drive Each account in the workbook is described in the sample workbook help topic making it easy for you to find an example account similar to your own loan Entering Your Loan Details For step by step instructions on setting up your own workbook adding a loan and entering your first statement refer to the entering your loan details help topic Help and FAQ You can find answers to the most commonly asked questions in the frequently asked questions help topic www homemoneymanager com au 5 Home Loan Manager Pro User Manual Software Overview Keep Accurate Records Mortgage Software LOAN amp Home Loan Manager Pro MORTGAGE DETAILS Be Debt Free Sooner Interest Rates D Statements 2 Transactions Home Loan Manager Pro has been specially designed to work with the loan details provided to you by your lender Using the information on your mortgage statements the software will allow you keep an accurate record of all your loans instantly check the accuracy of your interest charges summarize your expenses and help you plan for the future Keep Accurate Records With Home Loan Manager you can keep an accurate record of all your loans in the one convenient location Capture interest rate changes balances statement information a
22. in all internal interest calculations If you don t enter a discount rate then this field will always match the lender rate Note The actual rate figure must match the yearly rate being used by your lender to calculate your interest therefore if you have set a discount rate please make sure this rate is correct PENALTY RATES OPTIONAL Penalty Rate The penalty rate charged by your lender if you borrow over an agreed limit This field is optional and is mainly used for line of credit loans The rate should be the total penalty rate charged For example if your lender normally charges you 7 596 with a 296 penalty on amounts over 100000 then this rate should be set to 9 596 2 7 596 4 296 and the balance field should be set to 100 000 see Balance below www homemoneymanager com au 50 Home Loan Manager Pro User Manual Leave the field blank or 0 000 if penalty rates don t apply Balance The starting balance for the penalty rate This field is optional and is used with the penalty rate If this field is set to a value greater than zero it will be used in the interest calculations to determine when the penalty rate should be applied Leave the field blank or 0 00 if penalty rates don t apply Note The penalty rate is only applied to the proportion of the balance over the amount specified in this field www homemoneymanager com au o1 Home Loan Manager Pro Reports User Manual Home Loan Manager Pro provides yo
23. interest on the loan including any offset account benefits and compares it to the amount charged by your lender Tip If the report is displaying any errors then the Interest Calculations help topic is the best place to start The report displays the following information 1 The summary information showing the total interest charged by your lender the total estimated interest and the difference between the two totals 1 2 Alist of all the interest transaction for the loan 2 3 The option to run the daily interest report for an interest transaction providing a day by day break down of the interest charge 3 4 The Interest Paid tab and the Offset Account tab allowing you to switch between the main view and the offset account view 4 www homemoneymanager com au 55 Home Loan Manager Pro User Manual INTEREST CHECKER HOME LOAN Mrs A Citizen Genmt Nurber 06 0299 1239 9493 221 Lender Name Bank of the World Total Interest Paid 88 003 08 Tote Estimated merest D4 375 54 Total Difference ATUEM ates There are 77 errors in the table below Dick on the fields with red borders for more details on Gach error Error Tolerance 0 00 rereh B O1 01 2008 O12 ooo INTEREST CHARGED INTEREST CHARGED INTEREST CHARGED INTEREST CHARGED INTEREST CHakgED INTEREST CHARGED INTEREST CHARGED INTEREST CHARGED INTEREST CHARGED INTEREST CHARGED INTEREST CHARGED INTEREST CHARGED INTEREST CHAR
24. irc HOME LOAM Mrs sp Add G gt Edit Lo Delete Mame gt HOME LOAN Mrs citizen SUM mary www homemoneymanager com au 18 Home Loan Manager Pro User Manual After starting the import wizard and working through the required steps the transactions are automatically loaded into the statement 6 They are now visible in the transactions view screen 7 the statement description has been updated to include the number of transactions loaded 18 transactions transactions Date 14 07 2010 01 07 2010 01 07 2010 01 07 2010 2 01 08 2010 01 08 2010 0106 2010 2 01 06 2010 01 09 2010 01 09 2010 01 10 2010 1 1 2010 1 10 2010 01 11 2010 01 11 2010 01 11 2010 01 12 2010 01 12 2010 01 12 2010 31 12 2010 Statement Opening Balance REPAYMENT INTEREST CHARGED ACCOUNT KEEPING FEE INTEREST CHARGED ACCOUNT KEEPING FEE INTEREST CHARGED ACCOUNT KEEPING FEE REPAYHENT INTEREST CHARGED ACCOUNT KEEPING FEE REPAYMENT INTEREST CHARGED ACCOUNT KEEPING FEE REPAYMENT INTEREST CHARGED ACCOUNT KEEPING FEE Statement Closing Balance www homemoneymanager com au and 8 the software is waiting for you to select a category for each of your 2 152 42 5 00 2 505 55 5 00 2 506 87 5 00 2 424 36 5 00 2 500 86 5 00 2 420 95 5 00 2 507 87 2 740 21 2 740 21 2 740 21
25. 000000 000000 0000 root Interest Payable 67 173421 57 173321 67 173321 67 173421 amp 7 173421 67 173421 57 173421 57 173421 67 173421 amp 7 173421 67 173421 57 173471 57 173321 67 173421 amp 7 173421 67 173421 57 173421 67 173421 60 Home Loan Manager Pro User Manual Review Your Costs You can get an instant picture of what your loans are costing you statement to statement and year to year by letting the mortgage software automatically group and categorize the transactions on your statements The following reports will help you discover what your loans are costing you 5 Yearly Totals Report 6 Yearly Comparison Report 7 Statement Comparison Report 5 Yearly Totals Report The yearly totals report provides transaction totals grouped by category detail or parent category summary Yearly Totals Report YEARLY TOTALS LINE OF CREDIT Mrs A Citizen Summary 1 Detail T inche al Accounts Year 2000 Le Gei Arrn Pep Yearly Totals Report as SS YEARLY TOTALS LINE OF CREDIT Mrs A Citizen V nce All Accounts Year 2000 e 34 000 00 DEPOSIT Regular Repayment 4 420 00 DEPOSIT Salary 21 000 00 FEE Loan Set up 6 30 INTEREST Periodic Interest 10 648 17 IWITHDRAIMWAL Initial Drawdown WITHDRAWAL Regular Transfer 23 227 64 Get Men Quee www homemoneymanager com au 61 Home Loan Manager Pro YEARLY TOTALS LINE OF CREDIT Mrs A Ci
26. 08 8 Interest Rates 2008 01 01 2008 346 707 To create the statement you need to 3 enter the statement start date end date reporting year and the opening balance Start Date 01 07 2010 End Date 31 12 2010 Reporting Year 2010 Opening Balance 337 906 55 Tip If you type in 337906 55 the software will automatically add the negative sign and change the format to 337 906 55 Using the information from our sample statement above you can find 4 the start date end date and opening balance The reporting year is used by the reports to determine which yearly totals the statement should be included in and you can set it to any value you want As the start and end date for this statement are both in 2010 we have set the reporting year to 2010 www homemoneymanager com au 16 Home Loan Manager Pro User Manual INEY MANAGER 1eymanager com au statement B Page 1 of 1 Closing Balance 33b 243 14 Once you have entered your statement details click on the Ok button to add the statement to the account 5 It will now appear in the statements view NOTE As we are working with the existing HOME LOAN Mrs A Citizen account from the sample workbook there are already 7 statements in the account When you set up your first statement there will only be one in the statement view ansactions Auto Match About Help Topics O STATEMENTS HOME LOAN Mrs A Citizen ome S acd B Edt delete E
27. 09 2008 0108 2008 03607 2008 0106 2006 01050108 0104 2008 103 2008 DLG 01 01 2008 01 12 2007 0141 2007 0140 Lender Name Bank of the World 102 527 31 2002 2008 31 01 2005 31 12 2008 30 11 2008 31 10 2008 2009 2002 31 08 2008 31 07 2008 3 06 2008 3106 2008 0 04 2002 31 03 2008 29 02 2008 31 01 2008 31 12 2007 30 11 2007 31 10 2007 26 31 31 EN 30 31 3l 31 30 31 20 31 31 30 31 Tots Difference 72 08 Interest Paid 2 038 52 2 258 54 2 260 14 2 189 23 2 203 77 2 192 72 2 257 37 2 268 91 2 197 56 2 272 43 2 201 05 2 275 01 1 925 28 2 059 06 2 061 25 1 996 67 2 064 79 User Manual reset Interest 2 038 52 2 298 54 2 293 06 2 193 29 2 257 59 2 196 73 2 251 17 202 71 2 191 65 2 266 22 2 195 04 2 200 69 1 920 002 2 054 03 2 061 25 1 996 67 2 064 79 ju H E b bh b b b bh bb bib b un INTEREST CHARGED Interest Paid Offset Account wernt IL cose ger 5 Entering Interest Rates Tip Check that you have entered all the interest rate changes for the account If you miss an interest rate change or you enter the wrong date or rate then all interest calculations from that point forward will be incorrect Each time your interest rate changes your lender will provide you with a new interest rate along with the date they started using the rate Make sure you have creat
28. 3 Home Loan Manager Pro User Manual View Action Report Category Help ob Mew Workbook mM Auto Match About Help Topics uy Open Ctr O JMMARY Open Sample Workbook Tip The user option Open Last Workbook At Start Up allows you to automatically open you workbook each time you start the software and by default this option is enabled 4 Creating an Account Once you have set up your workbook you can add your first loan Click on the Add button under the ACCOUNTS heading to open the account details screen File View Action Report Category Help 25 Open IM Save D Import Transactions E Auto Match About Help Topics ACCOUNTS S SUMMARY Edit Delete OO Hide Payout Plan To set up an account you need to enter information into the three sections on the screen 1 The ACCOUNT DETAILS section allows you to describe the account 1 2 The INTEREST DETAILS section allows you specify the way the interest is calculated on the account This information is used by the software to check your interest charges 2 3 The OFFSET ACCOUNT DETAILS allows you to link an offset account to a loan account 3 If you need more information on what to enter into each field 4 click on the Help button Once you have finished 5 click on the Ok button to create the account www homemoneymanager com au 14 Home Loan Manager Pro User Manual HevrLoan Account Details ACCOUNT DETAILS Account Type Loa
29. 6 2008 3106 2008 30 04 2008 31 03 2008 29 02 2008 31 01 2008 31 12 2007 30 11 2007 31 10 2007 20 03 2007 31 al EN 31 al 3 31 30 91 20 31 31 Interest Interest End Date Dans Paid 2 038 52 2 258 54 2 260 14 2 189 23 2 203 77 2 192 72 2 257 37 2 268 91 2197 56 2 272 43 2 201 05 2 275 01 1 925 28 ZER D I 2 061 25 1 096 57 2 064 79 2 000 07 Inter gat 0 00 0 00 0 00 DI 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 1 925 29 e LESS 066 2 061 25 1 996 67 2 064 79 2 000 07 A A A A A A A A A A A A M S EIE Daily Difference view 2 138 52 2 25 54 2 250 14 2 189 23 2 203 77 2 257 37 2 197 2 272 4 2 201 05 2 273 91 SERERE Interest Paid Offset Account 6 Calculating the Interest Period Date Range Tip If the Days Calculated Up to field on the account contains the wrong value then every interest transaction in the interest checker report will contain an error Check that the report is displaying the correct date range for each transaction and that the days in the interest period looks correct eg if you are charged interest monthly then you would expect a days value between 28 and 31 When Home Loan Manager Pro finds an interest transaction on your statement it has to calculate the interest period the transaction relates to 1 To calculate the end date it uses the date on your interest transaction and then subtracts
30. AYMENT 337 48 43 100 00 01 01 2010 ACCOUNT KEEPING FEE 3 9 6558 100 00 01 01 2010 1 INTEREST CHARGED Ir 551 30 100 00 01 01 2010 REPAYMENT 414 54 100 00 21 12 2009 Statement Closing Balance 01 12 2009 ACOOLMT KEEPING FEE D1 12 2005 INTEREST CHARGED 166 7 339 017 99 REPAYMENT 2 507 87 307 650 63 ACCOUNT KEEPING FEE 5 0 ES www homemoneymanager com au o3 Home Loan Manager Pro User Manual If you find errors in your balances 5 click on the error for more information 6 A window will open with an explanation of the problem a list of most common reasons for the error and what to do to fix it Balance Checker Report A statement Balance Error Statement Balance Error This statement s balance af 339 822 39 does not match the previous statements closing balance of 338 977 33 Therefore there 15 a difference of 100 00 which could impart the balances and interest calculations of this account Help The mast comman reasons for this type of error are Estimated Balance 1 A statement is missing between this statement and the LAE statement that appears before it and needs tn be EHE 01 04 2010 T zT entered 2 524 91 01 04 2010 The opening balance on this statement has been typed 335 394 85 O1 03 2010 ACCOLN in incarrecthy 332 202 72 01 03 2000 One or more transactions in the previous statement ao a 0173 2010 have thie wrong amount Or they have been
31. B EditTransaction Details s Transaction Detail LT Di D4 010 2 A 100 00 01 04 2010 Date HES A 100 00 01 04 2010 A 100 00 01403 2010 2 Descrigtion ACCOUNT KEEPING FEE kb 100 00 01 03 2010 1 Category FEE Account Keeping el 77 A 100 03 01 03 2010 d 5B A 100 00 01 02 2010 2 15 A 100 00 ap n 105 00 339 972 39 em ege 01 02 2010 EE D A 100 00 Di Di sQiD 2 A 100 00 01 01 2010 1 T D A 100 00 01 01 2010 _ Qca Hep Show options 100 00 n1 01 2010 ER 7 100 00 D 25mm 0 1 4 315850 Mm Groe www homemoneymanager com au o4 Home Loan Manager Pro User Manual If you only wish to change the transaction sort order then you can change it in the Balance Checker Report by 8 clicking on the sort order column and a drop down list will appear Any changes to the sort order will instantly be reflected in the report Sort Order Description withdrawals ENT 10 01 04 2010 01 05 2010 EEs EPAYMENT ACCOUNT KEEFING FEE 01 04 2010 INTEREST CHARGED 2 220 06 01 04 2010 REPAYMENT 01 03 2010 ACCOUNT KEEPING FEE 3 01 03 2010 INTEREST CHARGED 2017 14 01 03 2010 REPAYMENT 01 02 2010 ACCOUNT KEEPING FEE 2 00 01 02 2010 INTEREST CHARGED 2 239 02 01 02 2010 REPAYHENT 2 Interest Checker Report The interest checker report is designed to quickly highlight errors in the interest charges of your loans It recalculates all the
32. GED INTEREST CHARGED 31 12 2008 20 11 2008 31 10 2008 30 09 2008 31 er 31 07 2008 31 06 2008 21 05 2008 3n n4 2003 31 03 2008 29 02 2008 31 01 2008 31 12 2007 30 11 2007 2114 22 A 2 047 09 all fe eU 2 121 06 2 122 52 2 055 67 2 125 82 Gel D EN 2 129 05 1 925 28 2 050 65 2 052 25 1 996 57 Freee FF Ex Diiin INTEREST CHARGED Jada 3in 2007 i d a Los Se 20 03 2007 nr 2 000 07 3108 2007 2 068 29 Liser 2l 5g ED E get Tip This report will only show transactions that have been assigned the category INTEREST Periodic Interest Therefore if you can t see all of your interest transactions close the report switch to the Transaction View and check the category you have assigned to each interest transaction If you find errors in your interest charges 5 click on the error and 6 a window will open with an explanation of how we came up with the error 7 Click on the View Help Topic Now button and use the information provided to check that you have entered your loan details correctly INTEREST CHECKER HOME LOAN Mrs A Citizen Account Number 06 0233 1238 9403 221 Lender Name Bank of the World Total Interest Paid BB UH3 8B8 Interest Error Notes There are 27 errors thd _ _ Start Date Interest Error nur lender has charged you 146 83 more than the esbmated interest amou Dal Tip Using the information listed below refer fo the Interest Calculati
33. Home Money Manager www homemoneymanager com au Home Loan Manager Pro 7 1 The Mortgage Checker and Planning Tool User Manual 2 January 2012 DOWNLOAD SOFTWARE Home Loan Manager Pro is available from www homemoneymanager com au COPYRIGHT 2004 2012 Home Money Manager all rights reserved worldwide No part of this publication may be reproduced transmitted transcribed stored in a retrieval system or translated into any language in any form by any means without written permission from Home Money Manager Home Loan Manager Pro User Manual Contents r M 2 OCON 4 5 1 Watch the Getting Started VideO 5 2 Refer to the Help 5 Software OVELVICW 6 Importing Transachonsg nennen nennen nennen nennen 7 Transaction Categories ansa arn nara nna anna nn 8 Category Auto Matching 8 Workbooke nennen nnne nnn nnn nnne nennen na re sse nei re riens reserare nenas 8 lida oq 8 Sample Workbook 1 0 ccc ceecccseccceecceeeeeaeeeeee cess nennen nennen nn sna nn nna nsns ans aa snis assis assess anna anna nn 9 Home Loan Mrs CItiZ N ccc c
34. INE OF CREDIT Mrs 4 Citizen MORTGAGE Nr amp Mrs Citizen MORTGAGE OFFSET Mr amp Mr Be Debt Free Sooner To start your payout plan enter a target loan tea and 99 00 Click on the Help button far mare ing The example accounts can be a useful reference when you set up your own loan information in the software and the following section provides more information on each one of them Home Loan Mrs A Citizen Example of a typical home loan This loan is a 30 year principal and interest home loan with variable interest rates and a monthly account keeping fee A payout plan has been set up to show what it would take to cut five years off the loan Transactions are downloaded from the Internet once every six months and loaded into the software with the import transaction wizard The automatching tool then instantly allocates all the categories Tip The samples directory contains a csv file with the latest set of transactions for this account As an exercise you may wish to 1 add the next statement for the account and then 2 import the transactions Home Loan Redraw Mrs A Citizen Example of a typical home loan with a redraw facility www homemoneymanager com au 9 Home Loan Manager Pro User Manual This loan is a 30 year principal and interest home loan with variable interest rates and a monthly account keeping fee The loan has a redraw facility so all extra money deposited into the
35. Missing or Incomplete Information and you will be asked to set up an interest rate Example Incorrect Statement Information Home Loan Manager Pro will not be able to calculate estimated interest amounts for an interest transaction if there are holes in the interest period days missing between statements or if the opening and closing balances between statements don t match 10 July INTEREST 10 June to 9 July Interest Period 1 January to 30 June statement 3 July to 31 December Statement For example if you accidentally create a statement with a start date of the 3 of July instead of 1 of July then there would be 2 days missing in the interest period and the interest can be not be calculated for the 10 of July Tip Run the balance checker report for more information on fixing statement errors Example Partial History When you first start using Home Loan Manager Pro you may decide that you only wish to enter the most recent statements for your loans While the software is designed to handle this it won t be able to check the first interest transaction you enter as it won t have all the balance changes www homemoneymanager com au 82 Home Loan Manager Pro User Manual 10 July INTEREST 10 June to 9 July Interest Period A 1 July to 31 December statement For example if you were to start entering your statements from the 1 of July then Home Loan Manager Pro wouldn t be able to estimate the int
36. ST CHARGED INTEREST CHARGED INTEREST CHARGED INTEREST CHARGED INTEREST CHARGED INTEREST CHARGED INTEREST INTEREST CHARGED INTEREST CHARGED INTEREST CHARGED INTEREST CHARGED INTEREST CHARGED INTEREST CHARGED INTEREST CHARGED INTEREST CHARGED NTEREST CHARGED ad 905 20 10 0104 2010 0103 2010 01 09 e010 08147172010 01 11 2008 01 08 2008 Oo 7772009 006 2008 a1 05 2008 01 04 2008 seess Dd le 2000 0401 2008 1 12 2008 1 2006 31 03 2010 Fr ae rd nli 31 01 2010 30 11 2008 31 10 2003 3009 2009 31 08 2009 31 07 2005 30 06 2005 31 05 2009 20 04 2009 31 0 200 2900272009 31 01 2009 31 12 2008 011 008 2 156 39 2 230 06 z 017 14 2 235 02 2 166 76 2 240 71 2 170 55 2 244 DU 2 246 29 2 175 91 2 250 11 2 179 58 2 253 87 2 038 52 2 258 54 PA i 27 G ER 19 297 00 59 or 006 15 1090 51 LKA 29 101 37 Um S 104 94 PG S 2 108 46 1 907 O0 2 112483 2 114 32 Be PR MM e f bh hj Di Le d d A8 Pee gt Interest di 4 LB 2 66 1 78 The Refund Date field 5 allows you specify the end date for calculating the compounded cost each error When you first run the report the date defaults to today s date however you can change it to any date that you require A date earlier than today will result in a smaller refund a date in the future will result in a larger refund The Error Tolerance field 6 allo
37. TEREST CHAR Cate A O1 11 2008 INTEREST CHARGEN A 146 05 Ol in aXB INTEREST CHARGE INTEREST CHARGED ai A 141 46 o Aa INTEREST CHARI Category INTEREST Periodic Interest F A 146 249 INTEREST CHARGED E A 146 30 ii D1 07 2008 INTEREST TIN pret Ken 141 79 0106 2008 INTEREST CHARGE SSC A 146 61 DATE 2 063 790 CS 34 7 0105 2008 INTEREST CHARGER 2 142 00 O1 D4 2008 INTEREST A 146 83 Oi n3 2008 INTEREST CHARGE 0 00 LS 0140 2008 INTEREST CHARGE 01 01 2008 O1 09 2007 INTEREST CHARGED 01 08 2007 31 08 2007 OLE 2007 INTEREST CHARGED DL 2007 31 07 2007 3l 2069 83 2 069 83 interest Paid Offset Account a c E E c m print close amp 3 Refund Calculator Report The refund calculator report is designed to calculate the total cost of the interest errors on your loans If an error happened some time ago you will have been charged additional interest on www homemoneymanager com au 57 Home Loan Manager Pro User Manual the error and the refund amount could be considerably more than just the original error amount The refund calculator does all the complex calculations for you taking into account interest rate changes compounding interest on interest manual adjustments and all offset account benefits from the date of the error to the refund date Tip This r
38. ager com au 49 Home Loan Manager Pro User Manual The interest rate details screen allows you to maintain your interest rate changes and contains the following fields INTEREST RATES Start Date The date this interest rate should be applied from inclusive Lender Rate The yearly interest rate charged by your lender If you do not receive a discount see Discount Rate below then this field should be the yearly interest rate that your lender uses to calculate your interest Normally the interest rate will be displayed on your statement Note If you are calculating you own values from an index then this figure should include the margin applied by your lender Discount Rate This field is optional If you do not receive a discount then leave the field blank or 0 000 If you have negotiated a discount from the standard lender rate then enter it here For example if you belong to an organization that receives a 0 50096 discount then enter 0 500 in this field Note Before entering a discount rate check that the interest rate your lender is providing on your statements hasn t already been adjusted for the discount If your lender is already adjusting the rate then leave this field blank otherwise Home Loan Manager Pro will include your discount twice Actual Rate The actual rate is calculated from the two fields above and is set to the Lender Rate less the Discount Rate Home Loan Manager Pro uses the Actual Rate value
39. are 2 errors in the table below Click on the fields with red borders for p Error Tolerance 0 005 Interest Interest Start Date End Date Start Date End Date T CHARGED INTEREST CHARGED INTEREST CHARGED INTEREST CHARGED INTEREST CHARGED INTEREST CHARGES INTEREST CHARGED INTEREST CHARGED INTEREST CHARGED INTEREST CHARGED INTEREST CHARGED INTEREST CHARGED INTEREST CHARGED INTEREST CHARGED 01 05 2010 01 04 2010 0108 2010 0102 2010 020172010 01 12 2009 01 11 2n08 O1 1o 2009 0109 2008 0 082009 0107 2009 0106 2008 05 2009 01 04 2009 0102 2009 0101 2008 i l2 2u08 21 05 2010 30 04 2010 31 03 2010 28 02 2010 31 01 2010 01 01 2010 30 11 2005 31 10 2008 30 09 2009 317 0372009 31 07 2009 30 06 2005 31 05 2009 20 04 2009 31 03 2000 2800222009 31 01 2009 31 12 2008 31 fe 2 246 78 2 166 76 2 230 71 2 170 55 2 244 601 2 246 29 2 175 01 2 220 11 2 179 58 2253 H7 2 038 52 2 258 54 2 250 14 nir c 2 308 40 2 166 76 2 240 71 2 170 55 2 244 50 2 245 29 2 175 91 2 290 11 el Ws3g 2 923 87 2 098 52 2 298 54 21290 19 dg dp d d gb ab Interest Paid Offset Account Qckse Gnep 9 Other Interest Errors If you have worked through this help topic and you still have an error in the interest checker report then you should 1 Check that you have correctly entered all dates and amounts for the transactions in the interest date ra
40. are manually entering transactions in the same order as they appear on your statement then this field will automatically be maintained for you and you can ignore it If you import your transactions then you may need to change this value For full details refer to the transaction sort order help topic This field is optional and it is only applicable to transactions that have been allocated a category of type INTEREST If this field is left blank recommended then the interest calculator will use the default value on the account and calculate the end date for the interest period by using the transaction date and subtracting the default number of days nominated in Interest Calculated Up to Day s Prior to Interest Transaction Date If you enter a date into this field then the interest calculator will use it as the end date for the interest period when calculating interest instead of the default value set on the account Tip For most interest transactions leave this field blank and let the interest www homemoneymanager com au 48 Home Loan Manager Pro User Manual Manual Adjustment to Amount Manual Adjustment to Estimate Reason for Manual Adjustment s calculator use the default value set on the account You should only set a value in this field if your lender doesn t follow a set pattern with your interest charges and you need to manually tell the interest calculator the end date of an interest transaction Refer to the
41. ave a line of credit loan that charges penalty rates 5 enter the penalty rate and the agreed amount at which the rate starts being charged 6 Click on the Ok button to add the interest rate change to the account www homemoneymanager com au 23 Home Loan Manager Pro User Manual B Nev interest Rate Details Interest Rates Penalty Rates Optional Start Date 01 07 2010 ND vour lender charges you a penalty rate on balances ower an agreed Lender Rate 8 750 limit enter the total penalty rate and the starting balance below Discount 0 000 Penalty Rate 0 000 Actual Rate 8 750 Balance 0 00 Docs Tip The discount field allows you to capture any special discounts you have negotiated with your lender 9 Updated Summary View Once you have finished entering your first statement return to the account summary view You can see that the Latest Information section of the screen has automatically been updated to reflect the statement that has just been added Fle view Action Report Category Help 25 Open Save amp Import Transactions Lo Auto Match About 7 Help Topics ACCOUNTS SUMMARY add Edit Delete SO amp Hide Payout Plan Mame HOME LOAN Mrs A Citizen HOME LOAN Mrs Citizen IS ED Statements amp Transactions amp Interest Rates Keep Accurate Records Current Balance 336 243 14 Statements Balance Date 31 12 2010 Transactions Current Inter
42. ays in Year the account is setto 365 3 The interest Rates used in the calculations be viewed by clicking on the Dey View icon in thee report The interest period for this transaction is 07 05 2008 to 27022008 CH days the account setting for Days Caiculeteg Lp fo set to 7 This transaction rs being treated as an interest change because you have assigned it the category INTEREST Penooic interest www homemoneymanager com au 73 Home Loan Manager Pro User Manual The following list will help you check that you have entered your information correctly and let you distinguish between small fine tunning issues and lender mistakes 1 Setting the Days In Year Account Value Entering Interest Rates Calculating the Interest Period Date Range Using the INTEREST Category Setting the Interest Transaction Date Other Interest Errors 9 I 4 Setting the Days In Year Account Value Tip Check that you have entered the correct value in the Days in Year field on the account most common value is 365 The Days In Year on the account is used to convert the yearly rates provided by your lender into a value that can be used in the daily interest calculations If you get this value wrong it will impact most of interest transactions One common mistake when entering your loan details is to change the default value from 365 to Actual If you set the value to Actual the software will use 366 days for leap years and 365 days
43. ccc cece eee eec cece eeeeece ees eeseeceeeseeseeceeeseesaeeseeeseeeaeeeeeseeeaeees 9 Home Loan Redraw Mrs A Citizen 0 ccc ccccccccceccecceeeceeeeeeceeeseeeeeeceeeseeeeeeeeeeseeeeeeseeseeeaeees 9 Interest Only Loan Mr Citizen ec ccccccccceeeceeeene cece eeseeeseeeseeeeeeeeseeseeesaneeseeesueeaeeenes 10 Investment Loan Miss nnne nnn nnn nnns 10 Line of Credit Mrs EE E 10 Mortgage Offset Mr amp Mrs A Cizen nennen nnn nnns 10 WAE E 11 Entering Your LOAM DelallS EEE 11 1 Example of a Loan Giatement nennen nena nnn nns 11 e ION e 13 S erus Ke Ee ee EE 13 Pe aun aN ACCOUN E 14 eM el Leg A EE 15 ele Dale M ET et Le 17 7 Assigning Transaction Categories nennen nennen nnne nnns 20 7 1 Manually Selecting Categories nnne 20 7 2 Using the INTEREST Category ccccccccecccseececeeeeseeeeseeeeseeceseeeeseeseseeseseueeseeeeseeeesees 20 7 3 Automatically Assigning Categories 21 8 Adding Interest Rate Changes nennen nenne nnn nnn nnn nnns 23 9 Updated Summary View 24 10 NEM DEMNM 24 Importing Transactions nennen nnne nennen nnn nne nnne nsa nnns 26 1 OVOIVIGW 26 2 Step by Step Instructions 26 2 1 Importing Transachons
44. d 1 or by clicking on the column in the File Sample panel 2 www homemoneymanager com au 29 Home Loan Manager Pro User Manual Transaction Amount Select the column in the table below that contains the transaction amounts If you have two columns with amounts in them select the first column If the amounts have a currency symbol type it into the Currency Symbom field eg for 100 type m E you are importing the transactionis inta Loan account the deposits Should be showing 25 numbers in the table below and interest charges and fees should be showing as negative numbers e Reverse the sign of the amount to change the signs if required 35000000 3500000 optional Reverse the sign on the amount e multiply by 1 File Sample LOAN DRAEN 350000 00 REPAYMENT 347665 44 INTEREST CHARGED ene E 349747 26 ACCOUNT KEEPING FEE 34975226 REPAYMENT Goen se 347418 70 INTEREST CHARGED DW 348205 82 ACCOUNT KEEPING FEE 349301 82 REPAYMENT 5 346568 26 INTEREST CHARGED 349044 93 ACCOUNT KEEPING FEE 340D49 93 REPAYMENT SS A 346715 37 INTEREST CHARGED 348724 50 al i i NT Fee 44H x If the amounts in your file contain a currency symbol for example X A Z Rp etc then type it into the currency symbol field Column Number Sample 350000 00 350000 0 IMPORTANT If you are importing transactions into a Loan or Mortgage statement then deposits shoul
45. d be displayed as positive numbers and the interest charges and fees should be displayed as negative numbers in the File Sample panel www homemoneymanager com au 30 Home Loan Manager Pro User Manual LOAN DRE AVVDCHATI MTEREST CHARGED ACCOUNT KEEPING FEE REPAYMENT If they are currently being displayed incorrectly then select the Reverse the sign on the amount field to change them Column Number 3 Sample 350000 00 350000 0 Currency Symbol optional Click on the Next button www homemoneymanager com au 31 Home Loan Manager Pro 2 6 Step 3 Select the Second Transaction Amount If all your transaction amounts are displayed in the one column then you can skip this step If you have two columns with transaction amounts in them then choose the second column If required enter the currency symbol and change the signs on the amounts Import Transactions 3 of 6 Second Transaction Amount Optional If all your transactions amounts are in the one column skip this step if you have two calumris with amounts in them select the second column If the amounts have a currency symbol it into the Currency Symbol field eg for 100 type in If you are importing the transactions inta a Loan account the deposits should be showing as posite numbers in the table below and interest charges and fees should De snowimng as negale numbers Use the Reverse the sign of te amou
46. de all the transactions If there is an error it will show you the calculated balance the difference between the balances and the impact this error is having on the remainder of the statement Tip The balance checker is also a great way to list ALL the transactions in a loan in the one place The report shows 1 Alltransaction in a loan including interest rate changes 1 2 The balance as it appears on your Statement 2 3 Our Estimated balance when there is an error 3 4 Differences between the balance amounts when there is an error 4 emm po 3 Balance Checker Report o E em BALANCE CHECKER HOME LOAN Mrs A Citizen Account Number 06 0233 1730 9403 2771 Lender Mame Bank of the World Notes There is 1 error in the table below Click on the fields with red borders for more details on each error atat Date End Date Error Tolerance 0 005 d CEST i 2 d Sort Tr Date Order Description Withdrawal Deposits A lil 01 04 2040 2 ACOOUNT KEEPING FEE i Di D4 2010 1 INTEREST CHARGED 524 91 328 624 100 00 01 04 2010 REPAYMENT 530 294 5 335 394 35 100 00 fs 01 03 2010 2 ACCOUNT KEEPING FEE X38 807 72 29 900 100 00 01 03 2010 INTEREST CHARGED 448 797 72 228 997 100 00 01 03 2010 REPAYMENT 336 780 58 2136 880 58 100 00 01 02 2010 2 ACCOUNT KEEPING FEE 34379 2045 329 368 100 00 01 02 2010 1 FHTEREST CHARGED X39 2213 45 Kk 100 00 01 02 2010 REP
47. e pul IE What is the minimum repayment amount The minimum repayment amount is the smallest amount you can enter into the report so that it just covers the interest charges If you were to enter a repayment amount smaller than the minimum then the loan would continue to grow indefinitely and you would never pay it off also referred to as negative amortization If you try to enter a number smaller than this amount the report will override your figure with the minimum repayment amount Note You need to set a Loan Term on the Loan Account for the report information to be accurate If the report displays Original Loan Term years 0 0 you will need to close the report Edit the loan account and enter a value for the Loan Term 9 Detailed Payout Plan Report If you are looking to save thousands in interest payments then this report is the place to start Did you know that if you have a variable rate mortgage your lender will regularly adjust your repayment amount so that you stay on track to paying it off over the full term They do not want www homemoneymanager com au 66 Home Loan Manager Pro User Manual you to pay it off sooner so even if you get ahead in you repayments your lender will reduce the amount they want you to repay to stretch it back out to the full term They know that if you have a 30 year loan they can maximise their profit by letting the interest accumulate over 30 years The power of this report is that it lets yo
48. e for it As well as the interest rate you can change any of the following 1 The loan balance 2 The repayment frequency 3 The current date Note You need to set a Loan Term on the Loan Account for the report information to be accurate If the report displays Original Loan Term years 0 0 you will need to close the report Edit the loan account and enter a value for the Loan Term www homemoneymanager com au 68 Home Loan Manager Pro User Manual Be Debt Free Sooner Do you want to cut years off your mortgage and save thousands Lock in your target and we ll help you every step of the way 11 Your Payout Plan 11 Your Payout Plan Your Payout Plan lets you decide how quickly you would like to pay off your mortgage and then shows you exactly what you have to do to achieve it It works with your current balance and is automatically updated every time you enter a new statement or update your loan details keeping you on track every step of the way Note The repayment amount specified in this report does not include any additional fees your lender charges you Therefore if you pay a regular account keeping fee you will need to add it to the repayment amount displayed in the screen Be Debt Free Sooner Your Payout Plan To repay this loan in a total of 25 00 years and save approximately 101 774 54 2 tne monthty repayments must be increased by 188 21 ta 2 693 81 for the next 21 50 years Loan Term 30 00
49. ed one Interest Rate record for each interest rate change on the account and check that you have entered the correct interest otart Date and Rate Example Missing Interest Rates The following example is from the sample workbook where we have deleted the interest rate change on the 1 of February 2004 that was for 7 25 Errors are being displayed from February 2004 onwards www homemoneymanager com au 75 Home Loan Manager Pro User Manual INTEREST CHECKER HOME LOAN Mrs A Citizen AccpuntMNumber 06 0233 1238 9403 771 Lender Mame Bank of the World Total Interest Paid 102 599 39 Total Estimated imerest 28 367 87 Total Difference 74 251 52 Notes There are 33 errors in the table below Click on the fields with red borders for more details on each error FJ Refresh Reset Help Interest Checker Report Start Date End Date Error Tolerance 0 005 1 11 2008 01 10 2008 01 9 2008 01 08 2008 01 07 2008 01 01 2008 01 12 2007 01 11 2007 O1 10 2007 Transaction Descr ples INTEREST CHARGED INTEREST CHARGED INTEREST CHARGED INTEREST CHARGED INTEREST CHARGED INTEREST CHARGED INTEREST CHARGE INTEREST CHARGED INTEREST CHARGED INTEREST CHARGED INTEREST CHARGED Interest Start Date 01 02 2000 0101 2009 mii2 2008 01 11 2008 1 10 2008 bi oe en08 pes 01 12 2007 i 11 2007 02007 01 09 2007 28 02 2005 31 01 2009 31 12 2008 30 11 2008 31 10 2008 30 03 2008 31 03 2008 31 07 2008 30 0
50. ed the problems you can re start the Click on the Help button for more instructions File Sample Ariat Arnount 2 Cal 5 350000 00 3 50000 00 2393 96 34725565 44 2000 57 349747 26 5 00 349752 26 347412 20 349296 82 349301 82 346565 26 404493 3 904S_ 533 3457 15 37 348724 50 44A f Fr 1 z 3 d 5 B T 8 10 11 12 T3 d Gro 3 What type of files can import The import wizard allows you to import delimitered text files where the information in your file is separated by a delimiter Your import file can contain one of more delimiters including commas tabs semicolons spaces etc The most common file formats are Comma Separated Values CSV files where the information is separated by commas and plain text files where the information is separated by Tab characters www homemoneymanager com au 36 Home Loan Manager Pro User Manual 4 What is a CSV file A CSV file is simply a text file where the information is separated by commas The format dates back to the early days of business computing is very simple and widespread and is supported by almost all spreadsheets and financial software packages In addition most Internet banking sites provide the option of downloading information in CSV format You can find an example of a CSV file in the samples directory of the software If you open this file in a text editor you will
51. eflects the interest you are charged may appear on each statement with a description similar to Interest Payable The first time you enter a new transaction description into Home Loan Manager Pro you will need to manually assign it to an appropriate category for example INTEREST Periodic Interest From then on the auto matching tool will recognise that the category INTEREST Periodic Interest should be assigned to all Interest Payable transactions and it will automatically match them for you Category Wildcard Patterns Often a word in a transaction description can make it a good candidate to be placed in a category For example one month your interest transaction may be Interest Payable to 30 August with the following month being Interest Payable to 28 September It would be convenient if any transaction description containing the words Interest Payable could automatically be assigned the category INTEREST Periodic Interest This type of matching can be easily achieved through the Category Wildcard Patterns For example from above you could set up the wildcard contains Interest Payable for the category INTEREST Periodic Interest When you run the auto matching tool any transaction containing Interest Payable would automatically have the category INTEREST Periodic Interest assigned to it From the Category menu choose Category Maintenance to set up and maintain Category Wildcard Patterns Restric
52. eport will only show interest transactions that were displayed in the Interest Checker report with an error amount greater than the Error Tolerance value shown on this report Therefore if this report is not showing any errors switch to the Interest Checker report and double check if there are any errors being reported on your interest transactions The report shows 1 Asummary of the errors the extra compounded interest you ve been charged and the total refund you are due 1 NOTE If the amount is negative then this is the total amount you have to pay back to your lender 2 Alist of all the interest transactions that contain errors see the Interest Checker report for an explanation of these columns 2 3 The additional compounded interest you have been charged on each error 3 4 The total refund you are due on each error If the amount is positive then you have been overcharged if the amount is negative then you need to repay the amount to your lender 4 Refund Calculator BEL x REFUND CALCULATOR HOME LOAN Mrs A Citizen Li CO D IER Lib EH rE Estimated interest Interest Inbarest Start Date End Date Days ni msn nius2un 01 04 2010 01 403 200 01 02 2070 01 12 2009 01112009 01 10 2009 Diseno 01 08 2009 01 07 2009 01 06 2009 01 75 2009 01 404 009 01 02 2005 01 02 2009 DILL 25m INTEREST CHARGED INTEREST CHARGED INTERE
53. er Interest Error 81 10 Missing or Incorrect Information esssessssesseeeeeenennen nennen nnn 81 11 Interest Rounding Error 83 12 What Next 84 EE 5 RR 85 TAINS AC HON engel 85 WY OF KO OOK ONIN IOP E 86 GUSTO MCT OUDDOD d 87 www homemoneymanager com au 3 Home Loan Manager Pro User Manual Welcome With Home Loan Manager Pro you can track plan and manage all aspects of your loans check the accuracy of your interest charges and discover how to pay off your mortgage sooner It does all the hard work for you so you will only need a few minutes a year to keep your mortgage and loans under control Mortgage Software Home Loan Manager Pro www homemoneymanager com au 4 Home Loan Manager Pro User Manual Where to Start 1 Watch the Getting Started Video This six part video tutorial will show you everything you need to know about the software and you can watch it now by selecting Watch the Getting Started Video from the Help menu File View Action Report Category 87 Open d Save Import Tran Contents amp Topics Watch the Getting Started Video r 2 Refer to the Help Topics Once you ve watched the getting started video the following help topics will get you started with Home Loan Manager Pro Software Overview For more information on how this software works and how it will help you manage your loans refer to the software overview
54. erest category www homemoneymanager com au 20 Home Loan Manager Pro User Manual TRANSACTIONS HOME LOAN Mrs A Citizen S Gadd P Edit Delete Statement 2010 01 07 2010 31 12 2010 18 transactions Date Description Withdrawals Deposits Balance Category 01 07 2010 Statement Opening Balance 337 906 55 01 07 2010 REPAYMENT 2 507 87 335 398 68 Select Category P 01 07 2010 2 ACCOUNT KEEPING FEE 5 00 337 556 10 FEE Loan Set up 01 08 2010 REPAYMENT 2740 21 334 815 89 FEE Cther 01 06 2010 1 INTEREST CHARGED 2 508 55 337 324 44 FEE Tax and Duties 2 01 08 2010 2 ACCOUNT KEEPING FEE 5 00 337 329 44 VE 1i 01 09 2010 REPAYMENT 274021 334 589 23 fee ECL 01 05 2010 1 INTEREST CHARGED WITHDRAWAL Other 2 506 87 337 096 10 01 10 2010 REPAYMENT 1 2740 21 334 360 89 Sekt Category 01 10 2010 1 INTEREST CHARGED KK nl d n E ma be 2 524 30 336 705 25 Select Category 01 10 2010 2 ACCOUNT KEEPING FEE 5 00 336 790 25 5elect Category 01 11 2010 REPAYMENT 2 740 21 334 050 04 SelectCategry 01 11 2010 1 INTEREST CHARGED 2 502 86 336 552 90 Select Category 01 11 2010 2 ACCOUNT KEEPING FEE 5 00 336 557 90 Select Category 3 01 12 2010 REPAYMENT 2 740 21 333 817 69 SelectCategory f 01 12 2010 1 INTEREST CHARGED 2 420 45 336 238 14 Select Category M 01 12 2010 2 ACCOUNT KEEPING FEE 5 00 336 243 14 Select Category
55. erest for the 10 of July as it wouldn t have a complete list of all the balance changes Interest transactions after the 10 of July would be calculated correctly and if at a later date you were to enter the older statements it would go back and calculate an estimate for the 10 of July 11 Interest Rounding Errors Tip If there is a very small difference between the estimate and the interest paid then it could be due to different rounding techniques There are many different ways to round the numbers in financial calculations including rounding up rounding down no rounding rounding to the nearest currency unit rounding daily rounding monthly etc In order to maintain the most accurate calculation possible Home Loan Manager Pro 1 Does not round any figures during internal calculations 2 Rounds the final estimated figures to the number of decimal places you have selected under the user Options If your loan provider uses a different rounding technique then the interest checker and refund calculator reports will display a slight difference on most of your interest transactions If you decide the errors on the report are due to rounding and you want to remove them from the report you can set the Manual Estimate Adjustment amount on each interest transactions to the reported difference This will ensure they do not appear as errors the next time you run the interest checker and refund calculator report Tip You can edit t
56. est Rate HOME LOAN REDRAW Mrs A dx EE 6750 Interest Rate Changes INTEREST ONLY LOAN Mr A C Remaining Loan Term 26 00 Years INVESTMENT LOAN Mise 10 What Next Continue adding your statements from oldest to newest entering the transactions and interest rate changes for each You can start running the reports after you have added your first statement www homemoneymanager com au 24 Home Loan Manager Pro User Manual For instructions on loading your transactions from your Internet banking site refer to the importing transactions help topic When you first run the audit reports if things don t look quite right refer to interest errors help topic to find out how to fine tune your account settings www homemoneymanager com au 25 Home Loan Manager Pro User Manual Importing Transactions To save you manually typing in all your transactions Home Loan Manager Pro provides you with an import wizard so that you can automatically load your transactions into your statements For more information on importing transactions please select from the following topics 1 Overview Step by Step Instructions What type of files can import What is a CSV file How do get my transactions into an import file How do import my transactions from a spreadsheet pE T 1 Overview mport Transactions Select a Statement amp Choose a File Start Import Wizard The first part to the i
57. et this field to the start of the transaction date range you wish to process Tip When you first start using Home Loan Manager Pro you don t have to start with the oldest statement first For example if you have a loan that is ten years old and you want to get started with the statements for the last year you can create your first statement starting a year ago and add older statements at a later date Tip You should keep the date ranges of your statements in a continuous time line That is the start date of one statement should be the end date of the previous statement plus one day When you create a new statement Home Loan Manager Pro automatically calculates a default start date for you using the end date of the previous statement The end date of the statement This field would normally be set to the end date as it appears on your statement If you do not receive statements then set this field to the end date of the transaction date range you wish to process The reporting year is used in the Summary reports to group information into yearly totals Normally you would set it to the same year as the start and end date If the statement start date and end date are in different years then you can select either year as the value for this field There are no constraints on the reporting year except that it must be a number The balance of the account as at start date This field would normally be set to the opening balance on your state
58. etting the Days In Year Account Value Entering Interest Rates Calculating the Interest Period Date Range Using the INTEREST Category Setting the Interest Transaction Date Other Interest Errors 10 Missing or Incorrect Information 11 Interest Rounding Errors 12 What Next eu EO MUI 1 Calculating Your Interest In order to check the accuracy of the interest charges on your loans Home Loan Manager Pro has to calculate its own estimate for every one of your interest transactions To do this the interest checker report has to Identify all the interest charges on your statements Calculate the date range each charge applied to Find all the changes to the balances in the date range Find all interest rate changes in the date range Calculate the interest amount pra Do DS The following is a quick example of how the interest checker report processes an interest transaction along with tips on the information it uses 10 July INTEREST 10 June to 9 July Interest Period 1 January to 30 June 1 July to 31 December statement Statement 1 The software finds an interest charge on the 10 of July Tip Home Loan Manager Pro requires that you assign the category INTEREST Periodic Interest to all you interest charge transactions 2 It calculates the interest period to be the 10 of June to the 9 of July Tip Home Loan Manager Pro automatically calculates this date range in one of two www homemoneymanager com a
59. fset interest rates and the interest the offset account is saving you using the percent allowable set on the account 3 4 The daily amount of interest your lender should be charging you It is calculated as the difference between the daily interest on the loan and the allowable deduction from the offset account if any 4 A punt Mumber 06 0233 1238 9403 271 Total Loan Interest 56 245 40 Lender Name Bank of the world Total fet Interest 0 00 Daily Rate Dieisor 365 days Total Interest Payable 86 245 40 End Date sfresh st E Help balance ES gati Daily o9 ae Dau Alona 1 4 Late Rate ge teg seul Rate 3 ay 0 019653 B erg 57 118424 16 29 TT nin 20 06 2010 27 06 2010 20 06 2010 22 06 2010 24 05 2010 z3 06 2010 z2 06 2010 21 06 2010 20 06 2010 13 05 2010 13 06 2010 17 06 2010 16 06 2010 15 06 2010 14 05 2010 337 906 55 337 006 55 337 006 55 337 906 55 337 506 55 337 906 55 337 906 55 z37 9065 55 337 906 55 337 506 55 337 506 55 337 906 55 337 000 55 337 906 55 337 906 55 0 013653 0 019553 0 014643 0 019653 n 019865 3 6 0 013653 0 019553 ek E 0 019653 0 019653 0 013653 0 013553 0 019852 n digen ss n 019865 3 6 n 01985 3 6 1 57 118324 b7 11H324 67 118424 57 118424 57 11B324 57 11H324 67 118424 67 118424 57 118424 67 110474 67 1105424 07 118424 67 118424 57 118424 b7 118424 57 118324 www homemoneymanager com au
60. ger com au 3 Home Loan Manager Pro User Manual Once you have downloaded your transactions and stored the file on your computer it is ready to load directly into the software using the import wizard 6 How do 1 import my transactions from a spreadsheet Most spreadsheet packages provide you with the option of saving your work as a Comma Separated Values CSV file Therefore all you have to do is save your spreadsheet as a CSV file and then you can load it directly into the software using the import wizard T A 1 Rm _ 7 e M2007 REPAYMENT 733355 lfc Save As 350000 00 82 1 82 File name Transactions ke Ob Uh d CO MN www homemoneymanager com au 38 Home Loan Manager Pro User Manual Category Auto Matching To save you manually allocating categories to every transaction Home Loan Manager Pro provides you with a Category auto matching tool Note The Auto Match option will remain disabled until the account contains at least one statement Overview The category auto matching tool tries to match categories to transactions automatically and once tuned to your needs it will do most of the matching for you The tool uses two main techniques which are covered in more detail below 1 Previously Matched Transactions 2 Category Wildcard Patterns Previously Matched Transactions Some transactions come up statement after statement For example the transaction that r
61. interest details section on the account screen for more information on how to use this field This field is only applicable to transactions that have been allocated a category of type INTEREST The Interest Checker Report and the Refund Calculator Report use the Manual Adjustment to Amount and Manual Adjustment to Estimate values to adjust the report values before displaying them These two fields are normally used as a way of removing small rounding errors from being displayed on the reports without having to edit the transaction amount which would have a flow on effect to the balance Refer to the rounding errors help topic for more details This field is only applicable to transactions that have been allocated a category of type INTEREST Please see explanation for Manual Adjustment to Amount above This field is only applicable to transactions that have been allocated a category of type INTEREST Enter the reason you are setting values for Manual Adjustment to Amount and or Manual Adjustment to Estimate Interest Rate Details Screens Editinterest Rate Details Interest Rates Penalty Rates Optional StartDate MERA If your lender charges you a penalty Lender Rate Discount Actual Rate rate on balances over an agreed KO limit enter the total penalty rate and the starting balance below 0 000 Penalty Rate 0 000 7 75055 Balance 0 00 Gok cancel G www homemoneyman
62. ions Dae Description Withdrawals Deposts Balance category 01 07 2010 Statement l Balance 337 906 55 01 07 2010 REPAYMENT 2 507 87 335 398 68 01 07 2011 INTEREST CHARGED 2 152 42 137 551 11 IN 01 07 2010 2 ACCOUNT KEEFIMG FEE 5 00 337 556 10 1 d 01 08 2010 REPAYMENT 2 740 21 334 815 89 Select TUUS d 01 08 2010 1 INTEREST CHARGED 2 906 55 D ITEREST Periodic Interest 01 08 2010 2 ACCOUNT KEEPING FEE 5 00 01 09 2010 REPAYMENT 2 740 21 ACTI PN 01 08 2010 1 INTEREST CHARGED 2 506 97 INTEREST Periodic Interest M 0109 2010 2 ACCOUNT KEEPING FEE 5 00 01 10 2010 REPAYMENT 2 740 21 dene 01 10 2010 1 INTEREST CHARGED 2 424 36 i 205 96 INTEREST Periodic Interest 01 10 2010 2 ACCOUNT KEEPING FEE 5 00 SERGE 01 11 2010 REPAYMENT 2 740 21 3 050 04 ees 01 11 2010 1 INTEREST CHARGED 2 502 86 932 08 INTEREST Periodic Interes 01 11 2010 2 ACCOUNT KEEPING FEE 5 00 57 90 SS 01 12 2010 REPAYMENT 2 740 21 333 817 69 01 12 2010 1 INTEREST CHARGED 2 420 495 336 238 14 INTEREST Periodic Interest 01 12 2010 2 ACCOUNT KEEPING FEE 5 00 336 243 14 Select Category M 31 12 2010 Statement Closing Balance RT After you have added the transactions to the statement you can return to the statement view screen and review the Withdrawal and Deposit amounts and check that the closing balance matches the balance on the printed statement msactions e Auto Match about Help
63. l If you have correctly specified a column for each of the required fields step 5 will show you the Ready to Import message 1 Start the import by clicking on the Finish button 2 and if everything is valid the transactions will be loaded into the statement Import Transactions 6 of 6 Ready to Import File Sample T Date Descripien 1 2 3 d B 7 OH www homemoneymanager com au eris Bak REPAYMENT ACCOUNT KEEPING FEE REPAYMENT ACCOUNT KEEPING FEE REPAYMENT INTEREST CHE REPAYMENT INTEREST CHARGED bf Pre FEE Cnl 5 KL 00 34 7566 44 349747 26 343975220 347418 34029065 82 349301 82 3458568 25 340044 93 343 33 3457 16 37 48724 60 44H rep 35 Home Loan Manager Pro User Manual 2 10 Import Failed Message If any of the values you have selected are incompatible with the import file then you will see the Import Failed message 1 To find out why the import failed review the errors in the File Sample panel by clicking on the fields with the red borders 2 Once you have reviewed the errors and gone back and addressed the problems you can re start the import Import Transactions 6 of 6 Wu ae Import Failed X nut why fe mport failed review the errors in the table below by eliekimg on the fields with nere ders total number of errors found 322 Once you have reviewer the errors and gone back and address
64. lance 336 245 14 Date Transaction Description Debits Credits Balance 1107 2010 OPENING BALANCE OOI Interest Rate Changed og 75 99 A072010 REPAYMENT 2507 97 N1 12 2010 CLOSING BALANCE The rest of this help topic will show you how to add this sample statement to the software www homemoneymanager com au 12 Home Loan Manager Pro User Manual 2 Overview Create and save Your Workbook Enter Loan f Details Add a Statement i Enter Statement Details E Add Transactions Add Interest Rates Impart Transactions Enter Interest T Rate Details or Type in Manually Assign Categories 5 Auto Match Categories or Select Manually The first step to entering your loan details is to 1 set up your own workbook to hold your information You can then 2 add your first loan which will hold each of your 3 statements 4 Add transactions to each statement by importing them from your Internet banking site or by typing them in manually and then 5 assign categories to your transactions using the Auto Matching tool or by selecting them manually The final step is to 6 set up the interest rate changes for the account 3 Setting up a workbook Before you can start entering your loan details into the software you need to set up your own workbook to store them in From the file menu select the New Workbook option www homemoneymanager com au 1
65. lated up to value from the correct value of one to the incorrect value of zero Errors are being displayed on every transaction www homemoneymanager com au 11 Home Loan Manager Pro User Manual Interest Checker Report INTEREST CHECKER HOME LOAN Mrs A Citizen Accpuntiumber 06 0233 1238 9 4403 72721 Lender Name Bank of the world Total Interest Paid 102 599 39 Total Estimated Merest 102 658 27 Tote Difference Notes There are 47 errors in the table below Click on the fields with red borders for more sieft Date End Date Error 1 0 008 F Raf Transaction Transaction E RR Dat anim ned End Date Orig 2010 01 08 2010 01 07 2010 01 06 2010 O65 2010 01 04 2010 0014032010 01 4002 2010 0101 2010 01 11 2009 01 10 2009 0149 2009 01 09 2069 01 07 2008 00062000 1 05 2008 INTEREST CHARGED INTEREST CHARGED INTEREST CHARGED INTEREST CHARG INTEREST CHARGED INTEREST CHARGED INTEREST CHARGED INTEREST CHARGED INTEREST CHARGED INTEREST CHARGED INTEREST CHARGED Interest Paid Offset Account 7 Using the INTEREST Category Ogy06 2020 2 07 2010 02 06 2010 0205 2010 02 04 2010 0203 2010 02 02 2010 0240132010 02 12 2009 Oz 7 11 2009 02 10 2009 0208 2009 D1 09 2010 01 08 2010 01 07 2010 01 06 2010 D1 05 2010 0104 2010 03 2010 01 02 2010 01 01 2010 01 12 2009 D1 11 2009 01 10 2009 01 09 2009 01 03 2009 0107 2009 01 05 2003 2 506 87
66. lumn Humber Sample 1 01 2007 01 Jan 2007 Date Format OMY e Date Separator 1 Home Bak iach W Forwardelash 10 Space Other File Sample 350000 00 347565 44 349747 26 34975226 347412 7 34920682 348301 82 346368 265 340044 3 340D5 33 34671637 348724 50 JAT A An 1 d 4 5 B 7 G First inest rei camel Hp Select the Date Format 1 and Date Separator 2 to match the dates in the column for example given a date of 20 03 2008 select a date format of DMY and a date separator of Column Number 1 Sample 1 01 2007 01 Jan 2007 Date Format Date Separator ve Nope BackSlash Wi ForwardSlash 19 Space Other Click on the Next button www homemoneymanager com au 33 Home Loan Manager Pro User Manual 2 8 Step 5 Select the Transaction Description Select the column that contains the transaction descriptions Import Transactions 5of 6 Transaction Description Select the column in the table below that contains the transaction descriptions Column Number 2 Sample LOANDRAWDOWN Amount2 On EE 2333 56 pals Ha 12 00 1 a d d D 7 B H 10 11 ak T Cum ee Click on the Next button www homemoneymanager com au 34 Home Loan Manager Pro 2 9 Step 6 Import the Transactions into the Statement User Manua
67. manager com au 17 Home Loan Manager Pro User Manual File View Action Report Category Help D Open bd save i Import Transactions Lo Auto Match About Help Topics ACCOUNTS TRANSACTIONS HOME LOAN Mrs A Citizen B amp ai pd ik Delete L Statement 2010 01 07 2010 31 12 2010 Date n Description Wither awal Deposits Balnce D1 07 2010 Statement Opening Balance 337 906 55 31 12 2010 Statement Closing Balance 3 337 906 55 Add Edit x Delete HOME LOAN Mrs 4 Citizen orent HOME LOAN REDRAW Mrs INTEREST ONLY LOAN Mr C INVESTMENT LOAN Miss Ci LINE OF CREDIT Mrs A Citizen MORTGAGE Mr amp Mrs Citizen MORTGAGE DEFSET Mr S Iv There are two ways you can add your transactions to the statement you can type them in or you can import them from a file If you wish to manually type in your transactions 4 click on the Add button and use the information from your printed statements In this example we are going to import the transactions from a file therefore we ll 5 click on the Import Transactions button Full instructions on how to use the import wizard including step by step instructions on how to load the statement for this example can be found in the importing transactions help topic File View Action Report Category Help e Open H Save 13 Import Transactions Auto Match About Help Topics ACCOUNTS bodega
68. ment If you do not receive statements then this value must match the balance of the account as at the date you have nominated in the start date field Note In Home Loan Manager Pro an account balance should be set to a www homemoneymanager com au 46 Home Loan Manager Pro User Manual negative number when you owe money Therefore all your loan and mortgage accounts will normally have negative balances You can enter a negative or positive number and Home Loan Manager Pro will automatically set it to negative if required Transaction Details Screen Transaction Details Date 01 06 2010 Description INTEREST CHARGED Category INTEREST Periodic Interest Withdrawal Deposit 229 00 w Oe Advanced Options Optional Sort Order Date Interest Calculated Lp to Manual Adjustment to Amount 0 00 Manual Adjustment to Estimate Reason for Manual Adjustment s _ Badd Mos amp Help Hide Options Tip If you are adding your transactions by typing them in instead of importing them you can use the Add More button to process the current transaction you are working with and automatically display the screen again ready for the next transaction The transaction details screen allows you to add and edit your transactions and contains the following fields TRANSACTION DETAILS Date The date the transaction amount impacted the account balance This field would normally be set to the transaction date as it appears o
69. mport process allows you to the select the statement you want to update and to choose the import file that contains your transactions 1 The import wizard will then take you through the steps needed to specify the layout of your import file and to map the columns in your file to the information required to create the transactions eg the amount date description etc 2 The final step is to physically import the file where your transactions are automatically loaded into the nominated statement 3 2 Step by Step Instructions This section contains step by step instructions on importing a CSV file into a statement 2 1 Importing Transactions To start the import process click on the Import Transactions button on the toolbar or from the Action menu choose Import Transactions www homemoneymanager com au 26 Home Loan Manager Pro User Manual File View Action Report Category Help 25 Open W Save Import Transactions L Auto Match about Help Topics V J ACCOUNTS cp Add G gt Edit t Delete HOME LOAN Mrs Citizen SUM Mary en Las 01 07 2010 Statement Opening Balance 31 12 2010 Statement Closing Balance 2 2 Select a Statement and Choose a File The Import Transactions screen requires that you 1 Check the Statement to Update is set to the statement you wish to load your transactio
70. n 3 Transaction Details Screen 4 nterest Rate Details Screen Account Details Screens E EditLoan Account Details ACCOUNT DETAILS Account Type Loan Mortgage Account Mame zen Account Number 06 0233 1239 9403 221 Lender Mame Bank of the Warid Original Loan Date 01 01 2007 Original Loan Term 30 00 Years Original Loan Amount 350 000 00 INTEREST DETAILS Days in Year T Interest Calculated Up to Day s Prior to Interest Transaction Date OFFSET ACCOUNT DETAILS Offset Account for this Loan ey ce OO Cancel amp The account details screen allows you to maintain your accounts and contains the following fields ACCOUNT DETAILS Account Type For new accounts if you are adding a loan mortgage line of credit or any other form of debt set the account type to Loan Mortgage If you are setting up an account that will offset the interest charges on a loan set the account type to Offset Account Note Once you have created added an account you cannot change the www homemoneymanager com au 43 Home Loan Manager Pro User Manual Account Name Account Number Lender Name Original Loan Date or Date Created Original Loan Term Original Loan Amount account type Identifies the account and is used in the title of all the screens and reports The account number allocated to you by your lender The name of the lender or bank providing the account For a l
71. n Mortgage ACCOUNT a c ROC M IEEE LES Account Number 06 0233 1238 8403 221 Lender Mame Bank af the World Original Loan Date 01 01 2007 Original Loan Term 20 00 Years Original Loan Amount 350 000 00 INTEREST DETAILS Days in Year Days Interest Calculated Up to Davis Prior to Interest Transaction Date OFFSET ACCOUNT DETAILS Offset Account for this Loan Allowable Offset Deduction 100 000 Loan for this Offset Account OAD Oren Q9 Tip Days in Year is normally set 365 sometimes 366 and Interest Calculated Up to is normally set to 1 sometimes 0 Refer to the Interest Calculations help topic for more information on what each field does 5 Adding a Statement For each statement you receive from your lender you need to set up a statement in the software To add the statement 1 switch to the statements view for the account and then 2 click on the Add button to open the statement details screen www homemoneymanager com au 15 Home Loan Manager Pro User Manual Fie View Action Report Category Help Open Save Import Transactions be Auto Match About Topics 3 ACCOUNTS s Add G gt Edit be Delete HOME LOAN Mrs 4 Citizen 4010 01 01 2010 30 06 2010 339 822 Summan 2009 01 07 2009 31 12 2009 341 594 2009 01 01 2009 30 06 2009 343 37 1 amp Transactio 2008 01 07 2008 31 12 2008 345 U
72. n your statement Description A meaningful description for the transaction www homemoneymanager com au 47 Home Loan Manager Pro User Manual Category Amount Balance To save you having to type in all your transaction descriptions Home Loan Manager Pro will auto fill the field as you type based on previous transaction descriptions you have entered for the account The category the transaction is to be grouped under in the Summary reports Note Set the category to INTEREST if the transaction is an interest charge that is to be audited Refer to the entering your loan details help topic for more information on assigning categories Note You can change the category descriptions by selecting Maintain Categories from the main Category menu you will need to close the transaction details screen first The amount of the transaction This field would normally be set to the transaction amount as it appears on your statement The balance amount for this transaction Note If the balance does not match the amount on your statement check you have entered all of the transactions before this one in the same order as they appear on your statement and check the statement opening balance you have entered into the software is correct ADVANCED OPTIONS Optional Sort Order Date Interest Calculated Up to This field is used by Home Loan Manager Pro to help sort two or more transactions that have the same transaction date If you
73. nd all types of transactions including extra repayments fees taxes and interest charges The software will let you enter as much or as little historical information as you want When you first start using Home Loan Manager we recommend that you start with your newest statement first and then add your older statements at a later date This is particularly useful if you want to start by importing your transactions and your Internet banking site only contains the latest information Check For Errors Not sure if your lender s interest calculations are correct Want to find out if you are receiving the full benefit of your offset account and any extra repayments you ve made The following reports have been designed to check your mortgage and loans for bank errors www homemoneymanager com au 6 Home Loan Manager Pro User Manual The Balance Checker will confirm that all your transactions and balances have been correctly processed by the bank The Interest Checker and Offset Account Checker will quickly highlights any errors in the interest charges of your loans If your lender has incorrectly calculated your interest The Refund Calculator and Error Compounder will display the refunds you are due by calculating the total compounding cost of each error The Daily Interest Report will show a breakdown of the interest you are being charged on each loan Review Your Costs You can get an instant picture of what your loans are co
74. ng your loan details help topic Entering Your Loan Details This help topic will take you through the steps of setting up your own workbook adding a loan and entering your first statement All the examples are based on the account HOME LOAN Mrs A Citizen from the sample workbook therefore if you open the sample workbook you can work through the exercises This help topics contains the following sections 1 Example of a Loan Statement Overview 3 Setting up a workbook 4 Creating an Account 5 Adding a Statement 6 Adding Transactions 7 Assigning Transaction Categories 8 Adding Interest Rate Changes 9 Updated Summary View 10 What Next 1 Example of a Loan Statement Most of the information you need to enter into the software is available on the statements sent to you by your lender While statements vary slightly from lender to lender they generally contain the following information 1 The STATEMENT details start date end date opening balance etc 1 2 The INTEREST RATE changes if any in the period 2 3 The TRANSACTIONS that took place in the statement period 3 www homemoneymanager com au 11 Home Loan Manager Pro User Manual HOME MONEY MANAGER www hamemanewymanager cam au Mrs Citizen Statement 8 Page 1 af 1 12 Sample St statement begins 01 July 2010 Sample City NSW 2212 statement ends 31 December 2010 pening Balance 33r 906 55 HOME LOAN 06 0233 1238 5403 2721 _ Closing Ba
75. nge with the error For example if the interest transaction has a period of 1 January 2007 to 31 January 2007 then check all the transaction in this period match the information on your statements 2 Check that the opening balances on your statements are correct in particular those that contain the interest transaction with the error 10 Missing or Incorrect Information If any of the information required to calculate the interest estimates is missing the estimated interest column will be left empty and an error will be displayed under the in Interest Paid column Clicking on the error in the report will display a window explaining what information is missing or incorrect www homemoneymanager com au 81 Home Loan Manager Pro User Manual Missing ar Incorrect Information Missing er Incorrect Information The estimated interest cannot be caiculated on this interest transaction because of the TOlowing 1 The interest rate for the oan account is missing between 01 02 2008 and 29 02 2008 fix this problem clase the report swiech ta the Interest Rates view and add the interest rate ta the loam account Tip For more information meer fo tne fr eresr Caleuations hei fooc Example Missing Interest Rate The interest checker report needs at least one interest rate to be set up on the account before it can estimate the interest If you run the report before you set up the interest rate every entry will be flagged as a
76. notice that commas separate the transaction information 1 01 2007 LOA N DRAWDOWN 350000 00 350000 00 1 02 2007 REPAYMENT 2333 56 347666 44 1 02 2007 INTEREST CHARGED 2080 82 349747 26 1 02 2007 ACCOUNT KEEPING FEE 5 00 349752 26 1 03 2007 REPAYMENT 2333 55 347418 70 1 03 2007 INTEREST CHARGED 1878 12 349296 82 1 03 2007 ACCOUNT KEEPING FEE 5 00 349301 82 4 a 4 n n n If you want to import a CSV file into the software you need to select the Comma as the Column Delimiter This will allow the wizard to put each value into a separate column ready for importing Column Delimiters Text Delimiter Perry 7 p Semicolon Space Other 1 01 2007 LOAN DRAW DCA 320000 00 1 02 2007 REPAYMENT 2333 96 1 02 2007 INTEREST CHARGED 2080 82 1 02 2007 ACCUOLINT KEEPING FEE 3 00 5 How do I get my transactions into an import file Most banks allow you to view your transactions online via their Internet banking site and provide you with the option to download your transactions to a CSV file When viewing your transactions online look for the download or export option and select the CSV format other names for the CSV file format include CSV text file Comma Separated Values CSV Spreadsheet file Plain Text file If you can t see any of these options please contact your lender for more information on how to download your transactions into a CSV file www homemoneymana
77. ns into NOTE If you want to add your transactions to a new statement you will need to create it before starting the import process 1 2 Enter the filename including the full directory path of the import file that contains your transactions or Click on the Browse button to locate the file 2 3 If you are updating an existing statement and it already contains transactions decide if you wish to delete them or append to them 3 4 Click on the Start Import Wizard button to start working with your file 4 Options Only Import Transactions In Statement Date Range sat import wizard H www homemoneymanager com au 27 Home Loan Manager Pro User Manual 2 3 Using the Import Wizard As you work through the import wizard steps you will notice that each step has the following Screen components 1 Instructions for the current step 1 2 Input fields allowing you to enter the requested information 2 3 A File Sample panel that displays the contents of your import file 3 4 Navigation buttons allowing you to move between the different steps 4 Import Transactions 1 of 6 Specify File Layout Please specify the layout of your import fie Use the start and end row fields to exclude unwanted header and footer information and then adjust the Column Dielimiters and Text Delimiter fields until your infarmatian appears in columns in the table below Click on the Help Sutton fo
78. nt to change the signs 4 if required Column Number Currency Symbol File Sample se Coll 1 3 4 5 D 7 H H 10 11 12 14 Tip If you have two columns with amounts for example debits and credits it doesn t matter in which order you assign them to Amount and Amount 2 The important thing to check is that the numbers in each column have the correct sign adjusting them with the Reverse the sign on 1 01 2007 1022007 1 02 2007 1 03 2007 13 2007 1 03 2007 1 04 2007 1 04 2007 1 04 2007 1 05 2007 1 05 2007 Sri Care Sea imme Si Sample optional Reverse the sign on the amount e multiply by 1 LOAN DP AVDOWWN REPAYMENT INTEREST CHARGED ALCOUNT KEEPING FEE REPAYMENT INTEREST CHARGED ACCOUNT KEEPING FEE REP AWENT INTEREST CHARGED ACCOUNT KEEPING FEE REPAYMENT INTEREST CHARGED l i Fee the amount field if required Click on the Next button www homemoneymanager com au User Manual Home Loan Manager Pro User Manual 2 7 Step 4 Select the Transaction Date Select the column that contains the transaction dates Import Transactions 4 of 6 Transaction Date Select the column in the table below that contains the transaction dates and then select the Date Format and Cate Separator to match the dates in the column or example given date af 20 03 2008 select a date format of and date separator of rr Co
79. oan or mortgage this is the contract date usually the date you borrowed the money For other account types this is the date the account was set up with the lender Tip This date lets the software know how old your account is and therefore it must always be set to the original contract date of the loan If you decide you only want to enter the latest statements for the loan for example if you have a loan that is ten years old and you only want to enter statements for the last year this date should still be set to the original date from ten years ago and not the date you start entering statements For a loan or mortgage this is the loan term in years Eg 30 If the account has no loan term then leave this field empty Eg line of credit account offset account For a loan or mortgage this is the amount you have agreed to borrow For a line of credit this amount is the total credit limit For an offset account this amount would be zero Tip In Home Loan Manager Pro an account balance should be set to a negative number when you owe money Therefore all your loan and mortgage accounts will normally have negative balances INTEREST DETAILS Days In Year Interest Calculated Up to Day s Prior to Interest Transaction Date Number of days in the year that Home Loan Manager Pro will use in the interest calculations The most common setting is 365 however please check your loan contract for details on interest calculations Tip
80. ong date on an interest transaction then it will result in two errors on the interest checker report For example if you accidentally enter the 2 of January instead of the 1 of January it will cause create an error in both the January and February interest calculations as the interest period shifts by one day www homemoneymanager com au 79 Home Loan Manager Pro User Manual 1 January 1 February INTEREST INTEREST 1 Dec to 31 Dec Interest Period 1 Jan to 31 Jan Interest Period 1 January to 30 June statement 2 January 1 February INTEREST INTEREST 1 Dec to 1 Jan 2 Jan to 31 Jan Interest Period Interest Period wg 1 January to 30 June Statement By entering the wrong interest date the January interest estimate will contain an extra day and the February estimate will be missing a day Example Incorrect Interest Transaction date The following example is from Home Loan account in the sample workbook where we have changed the date on the interest transaction from the correct value of 1 January 2007 to an incorrect vale of 2 January 2007 NOTE These errors are fairly easy to find as shown below www homemoneymanager com au 80 Home Loan Manager Pro User Manual Interest Checker Report INTEREST CHECKER HOME LOAN Mrs A Citizen Account Number 06 0233 1238 9403 771 Lender Mame Bank of the World Total Interest Paid 102 599 39 Total Estimated Interest 102 598 92 TotalDifference 0 47 Motes There
81. ons en Dep tapic fo check pou have entered your loan details correctly 141 24 Interest Transaction Details 14605 0 04 2008 your lender charged you 2 275 97 in Interest The Days fn Year on the account is set to 285 The eresi Reales used in the calculations can be viewed by clicking the view icon In the report The miterest penod fnr this transaction is CAUSE 2008 to 22 0 Y 2038 37 days This date range nas been calculated using the transacbon date and the account setting for Days Up to set to 7 i This transaction 15 being treated 25 an interest charge because you have assigned it the category AT EREST Period Interest FRRRRRRRRRMAO 146 29 146 39 5 E 5 Ga Hiat INTEREST CHARGED INTEREST CHARGE INTEREST CHARE INTEREST CHARGE INTEREST CHAR INTEREST CHARGED INTEREST CHARGED INTEREST CHAR Interest Paid Offset Account it odo di amp rrnt cke Gep Information Displayed in the Report www homemoneymanager com au 56 Home Loan Manager Pro User Manual The main section of the report the Interest Paid tab shows the following information 1 All of your interest transactions 2 The date range for each interest transaction and the number of days in the interest period 3 The amount of interest charged by your lender 4 The amount of interest that you should have been charged calculated by Home Loan Manager Pro
82. own box will display all valid offset accounts in the workbook that can be assigned to this loan Note If you select an offset account that is already linked to another loan it will break the link from the old loan and link it to the current loan account you are viewing Allowable Offset This determines how much of the offset account can be used as a deduction Deduction against the primary loan default is 10096 Loan for this If you are currently viewing an offset account then this field will display the Offset Account primary loan account it is linked to The drop down box will display all valid loan accounts in the workbook that this offset account can be linked to Note If you select a loan account that is already linked to another offset account it will break the link from the old offset account and link it to the current offset account you are viewing www homemoneymanager com au 45 Home Loan Manager Pro User Manual Statement Details Screens I EditStateme Start Date End Date Reporting Year Opening Balance nt Details 30 06 2010 2010 338 822 39 ok Cancel Help The statement details screen allows you to maintain your statements and contains the following fields Start Date End Date Reporting Year Opening Balance The start date of the statement This field would normally be set to the start date as it appears on your statement If you do not receive statements then s
83. posit and withdraw money The current borrowing limit is 200 000 and the bank charges a penalty rate on amounts over this limit A discount of 0 10 off the standard rate was included as part of a credit card package The homeowner deposits all salary and rental income directly into the loan Day to day living expenses are being paid for with a credit card which is paid off once a month via a direct transfer from the loan Additional deposits and withdrawals are made as more money becomes available or is required Mortgage Offset Mr amp Mrs A Citizen Example of a mortgage linked to an offset account This mortgage is a 30 year principal and interest home loan with variable interest rates The homeowners were awarded a discount of 0 2596 off the standard rate for being members of a professional association In addition the account is linked to a 10096 deductible offset account so that any additional funds can be placed in the account to reduce the monthly interest A payout plan has been set up to keep them on track to cutting 15 years off their mortgage and helping them save more than 450 000 in interest charges www homemoneymanager com au 10 Home Loan Manager Pro User Manual What Next For information on how this software will help you manage your loans refer to the software overview help topic For step by step instructions on setting up your own workbook adding a loan and entering your first statement refer to the enteri
84. provided you with an offset account for your loan then the following steps will show you how to set it up Link the Accounts You need to set up two separate accounts one for your loan and one for your offset account We recommend that you use the word Offset in the title of the offset account For example if your loan account is named Home Mortgage then we recommend you call the offset account Home Mortgage Offset The loan account is set up in the normal way Add a new account and select the account type Loan Mortgage To create an offset account Add a new account to the workbook and select the account type Interest Offset To link the offset account to the loan account you need to 1 Enter the allowable offset amount this is the amount of the balance that can be used in the interest calculations and is normally set to 100 2 Select the loan you want to link it to by choosing an account from the list Loan for this Offset Account Statements and Transactions All statements and transactions for the offset account are entered separately from the loan account You need to create new statements for the offset account and add all the required transactions or import them Interest Rates The interest rates for the offset account and the loan account are maintained separately If your offset account has the same interest rates as your loan use the Copy Rates options from the Interest Rates view for the offset
85. r Manual Interest Checker Report BE 3 INTEREST CHECKER HOME LOAN Mrs A Citizen Account Number 06 0233 1738 4403 2271 Lender Mame Bank of the World Total Interest Paid 100 369 33 Total Estimated terest 102 570 51 Total Diference 23 201 18 Notes There are 3 errors in the table below Click on the fields with red borders for more detalk on each error End Date Error Tolerance 0 005 FJ Refresh eset Help Start Date Transaction Transaction Interest Interest Estimated Daily Dae Deser iptioni Start Dabe Dan ritergat Difference View Dru INTEREST CHARGED murum 2 225 09 2 211 31 INTEREST CHARGED 1 03 2011 2 156 39 4 372 25 INTEREST CHARGED 2 017 14 2 017 14 RMIEREST CHARGED 31 in 3T 2 235 02 101 201 2 236 78 01 12 7200 2 156 75 01 11 7200 2 240 71 D1 10 200 20 2 170 55 01 068 200 2 294400 O1 08 200 2 246 29 01 07 2008 5 2055 2 175 01 01 06 2009 INTEREST CHARGED 2 250 11 0105 2009 INTEREST CHARGED 2 179 58 O1 O4 2008 INTEREST CHARGED 2 253 87 Oi 2009 INTEREST CHARGED 2 038 52 O10e 2009 INTEREST CHARGED 2 258 54 01 01 2009 INTEREST CHARGED 2 260 14 UNIZ INTEREST CHARGED J1 L1 2006 El E BU AED Interest Paid Offset Account by E DN EN EN a DH E EJ Ey 9 E EJ E Sch 8 Setting the Interest Transaction Date Tip Check that you have entered the interest transaction date correctly If you enter the wr
86. r Pro internally sorts transactions in date order and any transactions on the same date are further sorted by their Sort Order if it is set and then alphabetically on their description As the alphabetical sorting of transactions on the same date won t always match the particular sort order your Loan provider uses you can manually set the Sort Order on a transaction Therefore if at any time you notice a balance difference you should compare the order of the transactions to your statement If they are different then update the Sort Order on the required transactions until they match You can edit the sort order directly through the Transactions view screen when editing an individual transaction or through the Balance Checker Report www homemoneymanager com au 85 Home Loan Manager Pro User Manual Workbook Conversion If you choose to upgrade to a newer version of Home Loan Manager Pro the workbooks containing your saved information may need to be converted If a conversion is required when you open an existing workbook you will see the following message The workbook being loaded is from an older version of Home Loan Manager Pro and has automatically been converted to the current version Please use a new filename when saving or exporting this workbook if you wish to keep a backup of the older workbook The conversion takes place automatically and there is nothing you need to do However please note that once a file has been
87. r mare instructians CMProgram F fwianagerPro samples hrs A Ce Transaction Ce Del irnited ri File 322 1 End Import atRow 322 RM Tab Semicolon Space Other Text Delimiter 1 01 2007 LOAN DR AWDCANMN 35DODO 00 35000000 1 02 2007 REPAYMENT 2333 56 347665 A 1 02 2007 INTEREST CHARGED 23060 82 349747 26 1 02 2007 ACCOUNT KEEPING FEE 5 00 349752 28 1 03 2007 REPAYMENT 2333 56 3474 18 70 1403 2007 INTEREST CHARGED 187H 12 349296 E2 1 03 2007 ACCOUNT KEEPING FEE 5 00 345301 82 1 04 2007 REPAYMENT 2333 56 346968 28 1 04 2007 INTEREST CHARGED 2076 67 349044 03 1 04 2007 ACCOUNT KEEPING FEE 5 00 349049 93 1 05 2007 REPAYMENT 2333 56 3467 15 37 1 05 2007 INTEREST CHARGED 200H 23 348724 80 qEBIAAMAm BACOURT PRR EFE MATA An 2 4 Step 1 Specify the File Layout The first step of the Wizard requires that you to specify the layout of the file you wish to import If your file contains unwanted header or footer information then you can exclude them by changing the start and end row fields File Type Delimited Rows in File 322 Start Import at Row End Import at Row EES Calumn Delimiterz Camma Tab Semicolon Space other Text Delimiter SN www homemoneymanager com au 28 Home Loan Manager Pro User Manual Adj
88. r repayments by the smallest of amounts This report will show you Enter a New Repayment Amount and instantly see how much you can save in interest and how much sooner you will repay your mortgage When you first open the report or press the Reset button the report will use the latest loan information and set the New Repayment Amount to the required amount to pay off the loan over the remaining term The following are some of the powerful ways to use this report 1 To find out how much you can save by increasing your repayments enter the new repayment amount 2 To find out how much you can save by making a one off payment eg 10 000 simply edit the balance and enter the new reduced balance For example if the balance is currently 100 000 enter a new value of 90 000 The report will then show you how much you will save if you stick to your current repayment amount with the new balance If you have an offset account you can find out exactly how much it is going to save you over the life of your loan When you open the report by default the offset balance is not included in the calculations Simple click the Allowable 96 radio button and the Estimated Outstanding Interest will now show you your new total interest bill As well as the new repayment amount you can change any of the following The interest rate The loan balance The option to include the offset balance if applicable The repayment frequency The current dat
89. ransactions from within the interest checker report by double clicking on them www homemoneymanager com au 83 Home Loan Manager Pro User Manual 12 What Next If you have worked through this help topic and things still don t look right then please contact us and we will help you get back on track www homemoneymanager com au 84 Home Loan Manager Pro User Manual Transaction Sort Order When you enter transactions into Home Loan Manager Pro they must remain in the same order as they appear on the statement otherwise the balances and the estimated balances won t match Home Loan Manager Pro provides a field on every transaction called the Sort Order to help with the ordering of transactions although most of the time you will not need to worry about this field The Sort Order is only ever used when two or more transactions have the same date If you manually enter the transactions in the order they appear in the statement then Home Loan Manager Pro will automatically take care of the Sort Order for you If you import transactions electronically and the transactions in the raw import file are in date order ascending or descending then the Sort Order will be set automatically as the transactions are imported If all the transactions in the import file are not in date order then the Sort Order will not be set and you may have to manually set the Sort Order on transactions that have the same transaction date Home Loan Manage
90. rror Tip These errors will be displayed under the Difference column in the report aal 96 L 911 00 879 59 A le 882 43 852 00 30 43 012 51 551 04 31 47 EI T3732 I YT TW OE IM E EE RU TR Missing or Incorrect Information The report cannot calculate an estimate as you have not entered all the information required Tip These errors will be displayed under the Interest Paid column in the report www homemoneymanager com au 72 Home Loan Manager Pro User Manual Daily Difference View Interest Estimated Rounding Errors The estimated interest has been calculated and there is a very small difference between it and the amount you have been charged by your lender Tip These errors will be displayed under the Difference column in the report Estimated 3 Interest Errors The first time you run the interest checker report you may find errors in most of your interest transactions Clicking on an interest error in the report will open a window displaying the key information used to calculate the estimate Interest Error interest Error Tour lender bas Changed vou 146 89 nan the estimated interest amount Tip Using the information listed below refer to the Interest Calculations hein foot ia check you have entereg your loan dejal correctly interest Transaction Details On 03 04 2008 your lender charged you 2 275 97 in interest The D
91. sting you statement to statement and year to year by letting the mortgage software automatically group and categorize the transactions on your statements The following reports will help you discover what your loans are costing you The Yearly Totals Report will show you the total costs of your loans for ANY year The Yearly Comparison Report will compare totals between two different years The Statement Comparison Report will compare totals between to different statements Plan For The Future Worried about interest rate rises Want to find out how to pay off your mortgage sooner The following reports will give you answers and keep you informed as you circumstances change The Increased Repayments Report will allow you to work out how much you can save over the life of your loan by increasing your mortgage repayments The Interest Rate Rise Report will let you prepare for interest rate rises by showing you the impact on your repayments and total cost to your loan The Detailed Payout Plan will let you work out how many years you can afford to cut off your loan and how much you will save in interest charges Be Debt Free Sooner Do you want to cut years off your mortgage and save thousands Lock in your target and we ll help you every step of the way Your Payout Plan lets you decide how quickly you would like to pay off your mortgage and then shows you exactly what you have to do to achieve it It works with your current
92. terest Rate Details Gcreens 49 alum 52 Geek FOr EOT 53 1 Balance Checker Report 53 2 Interest Checker Report ccccsecccseeceeeeeeeeeeeseeeeseeeeeeeeeeeeeeseeeesaeesseeeseeessaeesseeeeseeeeaaess 55 Refund Calculator Report 57 4 Daily Interest Report cccccceccsecceeeceeeeeeeeeeseeeseeceeeseeeseeeeeesseeseeeeueseeseeeeueneeeseeeueneeenaes 59 Review Your Goss 61 Yeay Totals ROPOT EE 61 6 Yearly Comparison Report sre nnns 6 7 Statement Comparison Report sns nnns 64 TAC FUU eo 66 8 Increase Repayments Hepnort nennen 66 9 Detailed Payout Plan 66 10 Interest Rate Rise Hepnort A 67 SEP ed FICS SOON RT T 69 Pepen EE ees 69 bh D OUI I c 69 liiteres CFIC GE 71 eene aii ET 71 2 Interest Checker Report Error 72 3 Interest se do CC 73 4 Setting the Days In Year Account Value nennen nnns 74 5 Entering Interest Hates nennen nennen nnn nenne nnne nenne rns 75 6 Calculating the Interest Period Date 76 7 Using the INTEREST Category sessssesssssssseeen eene nennen nnne nnne nnns 78 8 Setting the Interest Transaction Date 79 9 Oth
93. the default number of days you have set up in the nterest Calculated Up to field on the account 2 To calculate the start date it uses the end date of the previous interest period or the loan start date if it is the first interest transaction on the account www homemoneymanager com au 76 Home Loan Manager Pro User Manual 1 January 1 February INTEREST INTEREST 1 Dec to 31 Dec Interest Period 1 Jan to 31 Jan Interest Period 1 January to 30 June Statement By default the Days Calculated Up To value is set to one so when Home Loan Manager Pro finds an interest transaction it will use the day before the transaction as the end date For example for an interest transaction on the 1 of February it will subtract 1 day from the transaction date and use the end date of 31 January If you lender charges interest on the same day as they calculate the interest period then you will need to change the account setting to zero If your lender doesn t follow a set pattern or they process a transaction late one month then you can edit the individual interest transactions and manually specify the required end date in the field Date Interest Calculated Up To When you set the value on a transaction Home Loan Manager Pro will ignore the default value on the account Example wrong Days Calculated Up To value on the account The following example is from the Home Loan in the sample workbook where we have changed the days calcu
94. tions The auto matching tool has been designed to assign categories to transactions only if they have not already been matched This will prevent it trying to change any categories that you have manually assigned or previously auto matched www homemoneymanager com au 39 Home Loan Manager Pro User Manual Running the Auto Match tool 1 From the Action menu choose Auto Match 2 Select the statement you wish to auto match 3 By default the auto matching tool will use the Category Wildcard Patterns If you do not wish to use the category wildcard patterns deselect the Match to Category Wildcard Patterns check box 4 By default the auto matching tool will use the transactions you have matched in the current statement If you do not wish to use the current statement then deselect the Match to Current Statement check box 5 By default the auto matching tool will use all previously loaded statements You can select the number of statements to match to by selecting from the drop down list www homemoneymanager com au 40 Home Loan Manager Pro User Manual Offset Accounts An offset account is an account designed to reduce the amount of interest you are charged on your loan or mortgage by reducing your loan balance before the interest is calculated For example if you have a loan with a value of 100 000 and an offset account with a value of 5 000 then your interest payable would be calculated on 95 000 If your lender has
95. tizen WITHDRAVAL 45 516 82 DEPOSIT 98 573 07 INTEREST 10 047 25 YEARLY TOTALS LINE OF CREDIT Mrs A Citizen WITHDRAWAL Regular Transfer 33 405 74 WITHORAWAL Other 12 111 08 ET Salary 21 000 00 pcs Periode Interest 10 047 25 DEPOSIT Regular Repasrnent 2 040 00 www homemoneymanager com au User Manual 62 Home Loan Manager Pro User Manual 6 Yearly Comparison Report The yearly comparison report allows the comparison of transaction totals by category detail or parent category summary between two years Yearly Comparison Report YEARLY COMPARISON LINE OF CREDIT Mrs A Citizen Summary Detail include All Accounts Compare 2000 201 DEPOSIT Add DEPOSIT Regular Repayment 4 420 00 2 040 00 DEPOSIT Salary 21 000 00 21 000 00 FEE Loan Set up 6 30 0 00 INTEREST Periodic Interest 10 640 17 1D D47 25 WITHDRAWAL Initial Dravedowm 283 876 75 0 00 WITHOR SiL Other 0 00 12 111 08 WITHORAIMAL Regular Transfer 23 227 64 33 405 74 H a Gier ferm cise 12 111 08 WITHIRAWAL Regular Transfer 33 405 74 DEPOSIT Regular Repayment 4 420 2 040 00 FEE Loan Set up E 0 00 DEPOSIT Salary 21 000 21 000 00 INTEREST Periodi Interest 10 640 17 10 047 25 DEPOSIT Arkitional Papay ment WITHOR AIMAL Initial Crawler Pret guer
96. u 71 Home Loan Manager Pro User Manual ways 1 using the transaction date and then subtracting the default value in the Days Calculated Up To field on the account or 2 using the Days Interest Calculated Up To date on the transaction if you have manually set it It looks for all balance changes in this interest period Tip Home Loan Manager Pro uses a combination of the statement opening balances and the transaction amounts to calculate daily balances 4 l tlooks for the interest rate changes in the interest period Tip Home Loan Manager Pro uses the interest rates you have entered for the account and converts them into values that can be used in the interest calculations using the value in the Days In Year field on the account 5 It estimates the interest based on the above information Tip Home Loan Manager Pro uses the standard internationally accepted formula for calculating interest on the outstanding daily balance in arrears 2 Interest Checker Report Errors If the interest checker can t calculate the interest or it calculates the interest and it doesn t match the amount charged by your lender it will display an error The errors displayed in the interest checker report will be one of three types Interest Errors The estimated interest has been calculated however it doesn t match the amount your lender has charged you This could be due to incorrect settings in the software or it could be due to a lender e
97. u set the terms of your repayment and then keeps you on track to achieving your goal It does not matter if the bank changes the repayment amount you make a one off deposit or withdrawal interest rates change etc this report will continue to adjust your repayment amount to suite your payment terms not the banks Each time you run the report it will show you how long you have left to reach your goal and the new repayment amount required to achieve it For example if you set the target loan term to 20 years and you are in the second year of repayments it will show you the required repayment to finish paying the loan off in 18 years All you do is enter a Target Loan Term and the report does the rest The report also shows you the total interest you will save by comparing the total remaining interest on the original loan term for example 30 years with your new target for example 20 years Note The repayment amount specified in this report does not include any additional fees your lender charges you Therefore if you pay a regular account keeping fee you will need to add it to the repayment amount displayed in the report Example Results The following example report highlights that you can save 49 402 on a 100 000 loan just by paying it off in 20 years instead of 30 years The report shows this can be achieved by increasing the monthly repayments by approximately 133 24 for the next 18 06 years Remaining Estimated Estimated Loan
98. u with a set of powerful reports to work with your loan and mortgage information Click on the report names below to find out more about each report 1 Balance Checker Report Interest Checker Report Refund Calculator Report Daily Interest Report Yearly Totals Report ae ee ee DOT 0 Interest Rate Rise Report 1 Your Payout Plan Tip You can copy and paste the results from the of the reports to other software packages either use keyboard shortcuts or use the right mouse button to activate the pop up menu and use the menu options to select all and copy www homemoneymanager com au Yearly Comparison Report Statement Comparison Report Increase Repayments Report Detailed Payout Plan Report 52 Home Loan Manager Pro User Manual Check For Errors Not sure if your lender s interest calculations are correct Want to find out if you are receiving the full benefit of your offset account and any extra repayments you ve made The following reports have been designed to check your mortgage and loans for bank errors Balance Checker Report Interest Checker Report Refund Calculator Report pw cm Daily Interest Report 1 Balance Checker Report The balance checker report is designed to quickly highlight errors in the balances of a loan It checks that the statement opening balance the sum of the transactions and the closing balance are correct from statement to statement It also checks that the statement date ranges inclu
99. ust the Column Delimiters and Text Delimiter fields until your information appears in columns in the File Sample table The most common file formats are Comma Separated Values CSV files where the information is separated by commas and Text files where the information is separated by Tab characters For CSV csv files select the comma delimiter for Text txt files select the Tab delimiter Column Delimiters comma Tab sSemicolen Space Other Text Delimiter File Sample Col 1 1 01 2007 LOAN DF DOAN 350000 00 350000 00 1 02 2007 REPAYMENT 2333 56 347666 44 1 02 2007 INTEREST CHARGED 2080 82 349747 26 SL 02 2007 ACCOUNT KEEPING FEE 5 00 349752 26 As the information in our sample file is in CSV format selecting the comma delimiter places the information neatly into columns Column Delimiters Text Delimiter Semicolon Space Other 1 01 2007 LOAN DRAW DCA 35000000 1 02 2007 REPAYMENT 2333 96 1 02 2007 INTEREST CHARGED 2080 82 1 02 2007 ACCOUNT KEEPING FEE 3 00 Click on the Next button 2 5 Step 2 Select the Transaction Amount Once your import file is being displayed as columns in the File Sample panel select the column that contains the transaction amounts If you have two columns with transaction amounts for example debits and credits select the first column You can do this by typing in the column number into the field provide
100. ws you to control the minimum refund amount to be displayed in the report Interest transactions with an error less than the tolerance amount you specify will not be displayed For example if you don t want to report on refunds less than 1 then set the error tolerance to 1 0 and click on the Refresh button www homemoneymanager com au 58 Home Loan Manager Pro User Manual 30 7 56 Total Refund 5 975 90 4 Daily Interest Report The daily interest report provides a day by day breakdown of the interest payable on a loan and includes any offset account benefits you are entitled to The report provides you with all the details you need to perform thorough audits of your loans and it allows you to investigate discrepancies reported in the Interest Checker report Tip By default the report show every day in the account from the start date of the first statement to the end date of the last statement To view the report for a single interest transaction click on the Daily View icon from within the interest checker report The report shows 1 The summary information showing the total interest on your loan the total interest saved by your offset account if applicable and the total interest you should have paid 1 2 The daily breakdown of loan information including the loan balance interest rates and interest payable 2 3 The daily breakdown of offset account information if applicable including the offset balance of

User Manual - Home Money Manager

Contents

Download Pdf Manuals

Related Search

Related Contents