Home

Read User Manual - INDUSFLOW SYSTEMS

1. Save Delete LoanID BIR1160 1160 Birchmount Road View Existing Deductions fe LoanAmount 725 000 00 Misc Charge Code BROKERAGE a Brokerage Fee G L Account 4300 Management Fee Income Amount 1 000 00 Charge borrower 1 000 00 Borrower 100 0000 Pay investor 500 00 Investor 50 0000 Distribute Last Billed Frequency Next Billing x Next Billed 03 09 2007 Active E Unapplied Amount 0 00 InvestorlD Name LoanAmount Balance MiscCharge Enno Bill Baroodwala _ 50 000 00 50 000 00 17 24 BINSEB Sebastian Bingor 100 000 00 100 000 00 34 48 _ GOLBAR Barry Goldberg 175 000 00 175 000 00 60 34 _ HIGBAR Barry Hiqgert 50 000 00 50 000 00 17 24 _ JINJOH John Jingle 75 000 00 75 000 00 25 86 __ KNOBEN Ben Knowles 25 000 00 25 000 00 8 62 __ MCKBOB Bob McKenzie 25 000 00 25 000 00 8 62 NIMELY Ely Nimber 50 000 00 50 000 00 17 24 Close 2 The fields shown on the screen are described below Loan ID a Misc Charge Code e SYNDi Loan Manager User Manual Displays the Loan ID for which the Miscellaneous Charge is being entered View Miscellaneous Charge Codes for this loan Click to display existing Miscellaneous Charge Codes to the loan An alphanumeric code of up to 16 digits set up to identify the miscellaneous charge Finder is used to display a list of all codes in the Miscellaneous Charge Codes table New is used to clear the screen while setting up a new mi
2. Database role membership for Acme db_accessadmin M db_backupoperator db_datareader Server RAFI DB20 SGLEXPRESS Connection C db_datawriter DOM_NTADMIN rafi db_ddladmin db_denydatareader db_denydatawriter db_owner db_securityadmin View connection properties 22 Click OK to save the login configuration for the newly created link 23 You are ready to enter database information in the Manage Companies screen See section 3 10 SYNDi Loan Manager User Manual Page 60 Chapter 3 Running the Application 3 15 Common Problems with SQL Server Databases 1 There could be a few issues with the workstation install e g with a You may have forgotten to disable UAC on the workstation b The Windows firewall may be running on the server but the necessary ports may have not been opened for sql server 2 Here is acommon problem for people who are not familiar with Sql server setup The sql server installation program does not automatically open the appropriate ports during installation nor does it warn you that you need to open any ports If you are using any software firewalls on the sql server you should not forget to open the appropriate ports SYNDi Loan Manager User Manual Page 61 Chapter 4 Setting up the Application Chapter 4 Setting up the Application 4 1 G L Accounts 3 SYNDi Loan Manager
3. Loan ID AVE1 077 adwsessionmgr dll BlankSYNDi mdb CheckLayout dot File Type IndusRegister exe InvestorDischargeNotice dot LastCompany sys Drive ac E License 2375 2121 sys SE MasterDischargeNotice dot A A Microsoft Office Integration pdf Program Files mecalocx NSFLetter dot C Documents PayoutStatement dot J Reports SYNDi User Manual pdf Templates SYNDi exe E Users syndiaccounting dll SYNDiSample mdb SYNDiSystem mdb Choose the appropriate File Type e g doc pdf jpg etc or leave it to display all file types Select the proper drive and navigate to proper folder where the file is located The list of files is displayed on the left panel Double click on the name of the desired file to copy it into the Catalog Folder The original file is left in the source folder from where it can be deleted manually if necessary 39 Deleting a Document To delete a document from the catalog click on it in the Documents List to select it and then click Delete button The file is moved into a sub folder called Backup From time to time you may want to clean the backup sub folder by deleting unnecessary files manually 40 Renaming a Document To rename a document from the catalog click on it in the Documents List to select it and then click Rename button SYNDi Loan Manager User Manual Page 160 Chapter 5 Working with Loans Opt Fields Tab 41 The tab is displayed
4. Borrower Name Samuel Sampson Interest Rate 9 5000 Per Diem Interest 188 70 Last Billing 03 09 2007 NextBilling 04 09 2007 Maturity Date 06 09 2009 Borrower Investors Principal 725 000 00 Principal 725 000 00 Interest 1 132 17 Interest 1 132 17 Penalty 17218 75 Penalty 17 218 75 3 Months Fee 67 90 Misc Charges 25000 N R Tax 10 98 Prev Balance 0 00 Sales Tax 3 38 Total Payout 743 600 92 Misc Charges 250 00 Previous Balance 0 00 Error Codes Total Payout 743 600 92 Payout Discharge Discharge 5 Statement Notices Report Edit Cancel Close 2 The fields shown on the screen are described below Loan ID Discharge Date Send Payment to Investors Interest Rate SYNDi Loan Manager User Manual An alphanumeric code of up to 16 digits set up to identify the loan Enter the date on which the loan is being discharged When the Discharge Date is entered the program runs billing Chapter 10 and saves the billing data in temporary area Check it if the borrower is supposed to send all monies payable to investors directly to them When the box is checked a list of investors with corresponding amounts is printed on the payout statement No other processing is affected Displays the rate at which the loan was advanced Page 172 Chapter 5 Working with Loans Borrower Name Per Diem Interest Last Billing Next Billing Maturity Date Borrower Principal Borrower Interest
5. lt S N M60Bichmount Roada Bank ID ee g Date 1070172011 i Stat Date 10 01 2011 End Date 1073172011 From Investor ID GAMDAV o DavidGambol To Investor ID PIPPET Aal PeterPper Investment Type i a Registered in Borrower s name Amount 20000 00 Investor s Bank Fee 5 0000 Transit Number 0120 21087 Status Unposted Account No 0208167235 __ InvestoiD Description BAHOTT Otto Bahn RefNo StartDate _ BalanceLoan _ AmountLoane a 19200 David Gambol 7 1 9 2010 David Gambol 31 7 15 2011 Add Delete 2 The fields shown on the screen are described below Reference No A numeric code assigned by the system from the Next Payment Number in Company Profile table Whenever a new transfer is generated the Next Payment Number in Company Profile table is incremented by 1 g Finder is used to display a list of transfers in the Transactions table New is used to clear the screen while setting up a new record Loan ID Enter the Loan ID maximum 16 alphanumeric characters user defined When a valid Loan ID has been entered the investor table on the screen displays all investors participating in the loan g Finder is used to display a list of all records in the Loans table SYNDi Loan Manager User Manual Page 191 Chapter 7 Investor Transfers Bank ID Date From Investor ID a To Investor ID a E Amount SYNDi Loan Manager User Manual Enter
6. b Expand Databases folder and double click on Acme c Click File gt Open gt File and point to CreateSYNDiMDF sq in the Application Folder where SYNDi is installed This file contains the script to create necessary tables d Once the script is loaded click Execute to create tables 5 Next you have to create a User Group called SYNDiGroup It is preferable to create it as a Domain User Group However you may decide to create it as a Local user Group Both methods are B Creating Domain User Group 6 Get your system administrator to create a domain user group called SYNDiGroup and add all users who will be accessing SYNDi database to that group 7 Skip the steps given below and proceed directly to the steps under Section E C Creating Local User Group 8 Login as Administrator on the computer on which SQL Server is installed The following screens assume that you are using Windows SYNDi Loan Manager User Manual Page 56 Chapter 3 Running the Application 7 The actual display may vary with the operating system Go to Control Panel gt Administrative Tools gt Computer Management gt Local Users and Groups to display the following screen Computer Management m File Action View Help e9 20 os 8 amp Computer Management Local Name Description 4 System Tools Administrators Administrators have compl Task Scheduler Backup Operators Backup Operators can ove
7. AgentID png or AgentID gif in database location Templates folder where AgentID is the Party ID used to set up the Agent in Other Parties table For instance if the Agent ID is SMITH the name of the signature file should be SMITH png SMITH jpg or SMITH gif The recommended size of the image is 100 pixels wide and 50 pixels high If the image height is not 50 pixels SYNDi resizes it to 50 pixels and adjusts the width accordingly Step 7 Add your Company Logo If you wish to display your logo or letterhead on some documents provide it as an image SYNDi can embed the logo on a document The company logo file should be saved as CompanyLogo jpg CompanyLogo png or CompanyLogo gif in database location Templates folder The recommended size of the image is 250 pixels wide and 50 pixels high If the image height is not 50 pixels SYNDi resizes it to 50 pixels and adjusts the width accordingly SYNDi Loan Manager User Manual Page 314 Chapter 17 Loan Documents Step 8 Set up the Loan Set up the new loan with zero principal to start The principal will be built as loan advances are applied Link the loan to a property with valid Property Type You must also enter the Rank and the Lawyer ID for the loan Step 9 Generate Loan Documents You are now ready to generate Loan Documents for new loans that have not been funded yet The documents are saved in database location Documents Loans LoanID folder as xls or pdf files depen
8. Borrower Penalty Borrower Misc Charges Borrower Prev Balance Borrower Total Payout Investors Principal Investors Interest Investors Penalty Investors Fee SYNDi Loan Manager User Manual Displays the name of the borrower Displays the daily interest amount Displays the date on which last billing was run Displays the date on which next billing is scheduled to run Displays the maturity date of the loan Displays the principal to be paid to the borrower Displays the interest calculated from the Last Billing Date to the Discharge Date If the loan profile indicates a number of months interest to be calculated for early discharge the program calculates interest from the discharge date up to the maturity date up to a maximum of penalty months on the loan profile If the difference between the maturity date and the discharge date is less than the number of penalty months penalty is calculated for that period Displays the total amount of unbilled miscellaneous charges including the amounts to be billed at the time of loan discharge Displays the total of previous unpaid balances Display the total amount payable by the borrower Displays the total principal to be paid to the investors Displays the interest calculated from the Last Billing Date to the Discharge Date to be paid to the investors Displays the total interest penalty to be distributed to investors Displays the tot
9. Chapter 6 Investor Receipts 6 1 6 2 6 3 6 4 6 5 6 6 Introduction Receipts Entry Tab Terms Tab Activity Tab Optional Fields Tab Menu Tab Chapter 7 Investor Transfers 7 1 Fid TS 1 4 7 5 Introduction Transfers Entry Tab Terms Tab Optional Fields Tab Menu Tab Chapter 8 Borrower Payments 8 1 8 2 8 3 Introduction Payments Entry Tab Menu Tab Chapter 9 Loan Adjustments 9 1 9 2 9 3 9 4 9 5 Introduction Loan Adjustments Entry Tab Increasing Loan Amount Reducing Loan Amount and Entering Interest Adjustment Menu Tab Chapter 10 Billing 10 1 10 2 10 3 10 4 10 5 10 6 10 7 Introduction Running Billing Editing Billing Data Borrower Tab Investors Tab Misc Charge Tab Printing Borrower Bills Chapter 11 Miscellaneous Transactions 11 1 11 2 11 3 Introduction Menu Tab Transaction Entry Tab Chapter 12 Borrower Receipts 12 1 Introduction 12 2 Menu Tab 12 3 Working with Batches 12 4 Receipts Entry Tab 12 5 Principal and Interest Tab 12 6 Miscellaneous Charges Tab 12 7 Unapplied Cash Tab 12 8 Deductions Tab 12 9 Reversing Borrower Receipts 12 10 Entering Borrower Receipts in Block Chapter 13 Investor Payments 13 1 Introduction 13 2 Menu Tab 13 3 Payments Entry Tab 13 4 Entering Investor Payments in Block 13 5 Bank Account Verification Chapter 14 Generating Checks 14 1 Introduction 14 2 Menu Tab 14 3 C
10. Menu Receipts Entry Principal and Interest Misc Charaes Unapplied Cash f Deductions Deductions 1 HOLDBACK i Holdback S O zaoo 2 AaDMN jlAdmnFee 250 00 3 jest i SaestTa S e CC rN SO C8 0 00 DJO 0 00 Total Amount 7 562 50 2 Itis ideal for entering down payments holdbacks administration charges etc paid by the borrower or deducted from loan advance BEFORE the loan is funded It can also be used to process such transactions if you are controlling Borrower Receipts through Batches otherwise you may enter them through Miscellaneous Transactions as service charge billed and received See Chapter 11 3 If you are using this screen to enter deduction you should not apply any portion of the receipt amount to previous billings or unapplied cash SYNDi Loan Manager User Manual Page 257 Chapter 12 Borrower Receipts 12 9 Reversing Borrower Receipts 1 Ifa receipt from a borrower has been entered and posted it can be reversed in case the check is returned by the bank due to insufficient funds It is suggested that the Investor Payment should be entered only after borrower receipts have been cleared by the bank although The program allows the user to return the check even after Investor Payments have been processed 2 Ifthe receipt to be reversed has not been posted yet it should just be deleted instead of being reversed 3 To reverse a receipt choose Receipt Entry tab and enter the Re
11. 12 31 2011 4 362 80 4 962 80 Amount to be appllied 11 612 30 5 Ifthe Amount is being partially paid or not being paid click on the amount in InterestRec column to highlight it Type the new value and hit the lt Tab gt key The amount in Interest Received column cannot exceed the amount in Interest Due column Similarly if the SYNDi Loan Manager User Manual Page 253 Chapter 12 Borrower Receipts Principal Due column contains a certain amount you can apply it partially by changing the figure in PrincipalRec column SYNDi Loan Manager User Manual Page 254 Chapter 12 Borrower Receipts 12 6 Miscellaneous Charges Tab 1 The tab is displayed as follows SYNDiLM Borrower Receipts Sample Financial Co OX Menu Receipts Entry Principal and Interest E Mise Charges Unapplied Cash Deductions Miscellaneous Charges Code Description AmountDue __ AmountReceived gt NSF 21265 _ NSF Charges 150 00 150 00 Misc Charges 150 00 2 This table displays miscellaneous charges associated with the selected billing record in Principal and Interest Table The columns in each row are described below Code Displays the Miscellaneous Charge Code Description Displays the description associated with the miscellaneous charge code or the description entered for the service charge Amount Due Displays outstanding amount Amount Received Displays the amount to be paid i
12. Blended Payments 5 The formula for calculating the payment is as follows P p tD r ET where P Principal Balance Pm Payment Amount n Amortization period in months i Annual interest rate as percentage OE r 72X100 6 To calculate the principal portion of the installment subtract the interest calculated earlier from the payment amount P 7 Consider a loan of 100 000 with interest rate of 9 amortized over 30 years The payment is calculated as follows P 100 000 n 30X12 360 i 9 eae r yg 90075 I 100 000X 0 0075 750 1 1 0 0075 1 1 0 0075 P 100 000x 0 0075 804 62 8 Out of the payment of 804 62 the principal payment will be 804 62 750 00 54 62 The principal balance P after the first payment will be 100 000 54 62 99 945 38 and the interest will be calculated on this value 9 To calculate interest for part of the month calculate daily rate by multiplying the annual interest rate i by the number of days d and dividing by 365 number of days in the year For example if the rate is 9 per annum the daily rate will be 9 365 or 0 02465753 10 Interest 74 for certain number of days d is calculated by multiply ing the principal balance P by the monthly rate divided by 100 SYNDi Loan Manager User Manual Page 9 Chapter 1 Introduction Lp iXd 365X100 Thus if the principal balance is 100 000 and the interest rate is 9 per an
13. Just enter appropriate values for each field To enter a new transfer click New to clear the screen and enter Loan ID The system displays an investor table displaying all investors participating in the loan and their contributions You may hit lt Tab gt key to move from one field to the next Alternatively you may click inside a field and modify it To modify an existing record enter the Reference Number or use Finder to select a record Enter various fields and click Save to save changes You cannot modify a record that has already been posted with the exception of Fee Bank ID and Account Number If an investor has already contributed to a loan and additional investments are entered through Investor Transfers the new investments are created under separate Investment Numbers Once you have initiated the billing process you cannot enter a transfer until billing has been posted SYNDi Loan Manager User Manual Page 197 Chapter 7 Investor Transfers 7 To delete a record click Delete You cannot delete a record that has already been posted SYNDi Loan Manager User Manual Page 198 Chapter 7 Investor Transfers 7 5 Menu Tab The tab is displayed as follows SYNDi LMS Investor Transfers Sample Financial Company ransters Entry Terms Opt Fields E Print Unposted Transfers E Print Posted Transfers E Post Transfers Add Close The functions shown on the sc
14. Port Sender s Name Yes C No V Need Authentication User ID Password Confirm Password Will you use SYNDi to send e mails Use Microsoft Outlook Use SMTP Outgoing Mail Server SYNDi Loan Manager User Manual administrator The default is No Click Yes if you want to send e mails from SYNDi and fill the rest of the details If you are using Microsoft Outlook for your e mails choose it and all e mails will go from your Outlook account If you do not wish to use Microsoft Outlook you should fill this section Get SMTP Mail Server and Port from your system administrator and fill the rest of the details Page 77 Chapter 4 Setting up the Application Integration Tab 7 The tab is displayed as follows when the user clicks tab header SYNDiLM Company Profile Sample Financial Company _ O Company Options E Mail Integration Descriptions Integration Server Name ACCPAC SERVER C Simply A n If you leave the Server Name blank SYNDi will use imply Accounting ODBC connection to connect to the database You Accpac ERP should have already set up an ODBC connection Standalone DB Name SAMINC If you are using ODBC connection this field should contain the DSN Name otherwise the name of SOL Server database User ID Password Posting Level C Summary Detail Write payment checks inAccpac 8 This screen is used to define the interface with the accounti
15. Scroll or Close while adding a new record or just after deleting a record the system displays the following message Check Save E A Do you want to add this record If you have deleted a record inadvertently or have forgotten to click the Add button click Yes to save the record before proceeding 9 Ifyou hit New Scroll or Close while changing an existing record the system displays the following message Confirm Update A Changes to the current record have not been saved Do you want to save changes If you have forgotten to save changes click Yes to save the record before proceeding 10 Before adding or saving a record the system checks each field for errors If an error is encountered it displays and error message and returns to the edit mode 11 All dates are displayed by the system in the format set in Windows Thus if the format has been set as m dd yyyy the system will display August 3 2003 as 8 03 2003 On data entry screens however the format for date fields will be mm dd yyyy reserving two digits for month and two digits for day so that you will enter the date as 08 03 2003 SYNDi Loan Manager User Manual Page 37 Chapter 3 Running the Application 12 Amount fields should be type in dollars and cents e g 2365 29 for positive values or 2365 29 for negative values However these numbers are displayed as 2 365 29 or 2 365 29 Make sure that you do not type dollar sign comma or parenth
16. The program will automatically scan the account numbers shown on Accounts 1 and Accounts 2 tabs and will force you to change the account numbers to valid values 16 Click Close to close the screen 17 After SYNDi has been successfully integrated with an accounting package download the chart of accounts and banks from the package See Section 15 3 Simply Accounting Interface 18 Before you set up an interface with Simply Accounting you must set up an ODBC connection to the Simply Accounting database as follows SYNDi Loan Manager User Manual Page 79 Chapter 4 Setting up the Application Step 1 Open the desired database in Simply Accounting Go to Help gt About Simply Accounting by Sage Click on Support Info The following screen is displayed Sage Simply Accounting Support Info x This product is licensed to r Database Engine Shared company Yes Company INDUSFLOW SYSTEMS INC Database engine connections 3 Serial 12AE5U28314816 Key Code 12AE5U2 FLMA 6L1N E3HU 9MLZ Users Account ID 4003526730 Payroll ID PKOOVNSWJG Graced Inbound connections 0 Computer name INSTALL B256C80 Port 13540 Payroll Taxes Effective Jul 1 2012 Ci A omen SimplyAccounting exe 19 00 0000 0004 ntdll dil 5 01 2600 6055 2010 12 09 11 kernel32 dll 5 01 2600 5781 2009 03 21 10 WININET dll 8 00 6001 19328 2012 08 28 11 msvert dll 7 00 2600 5512 2008 04 14 05 SHLWAPI dll 6 00 2900 5912 2009 12 0
17. The screen contains four tabs described below SYNDiLM Template Setup Sample Financial Company E Settings Options Accounts 1 Accounts 2 Settings This screen contains various settings to be applied to the Loan Options This screen contains banking information for the company various miscellaneous charge codes and taxes if any Accounts 1 Various General Ledger accounts that are debited and credited during transaction flow are describer on thes screen Accounts 2 Additional General Ledger accounts that are debited and credited during transaction flow are describer on thes screen You may access various tabs by clicking on the tab header The fields on each tab are described below SYNDi Loan Manager User Manual Page 134 Chapter 5 Working with Loans Settings Tab 4 The tab is displayed as follows SYNDiLM Template Setup Sample Financial Settings Options Accounts 1 Accounts 2 Accounts 3 Template ID LOANS aqo Description All Loans Loans are given in Cash C Kind Billing Frequency Monthly v Interest Payment Frequency Monthly Default Calculation Method 12 Month Year v Fee from investors of interest 5 00 Wam when interest rate exceeds 25 00 x Default Billing Day fo Default Payment Type C Blended Interest only Are loans linked to Properties J Use as Default Template IV Save Delete Print 5 The fields shown on the screen
18. are not applicable It is used primarily by lawyers lenders syndicators and other companies providing financial services In a typical scenario the company sets up the syndicate advances the loan amount to the borrower receives the payment on monthly basis and distributes it to the investors The broker may deduct a percentage from the distributed interest amount as the management fee The system automates the loan management cycle and maintains relevant records until the loan is paid off SYNDi Loan Manager User Manual Page 1 Chapter 1 Introduction SYNDi Loan Manager is a general purpose application that handles all loans payable in installments interest only or blended payments amortized over a period with a balloon payment General Features e Interest only loans or Blended Payments e Capability to process interest free loans e Can be integrated with QuickBooks Sage Accpac ERP or Sage Simply Accounting e Loans can be linked to real estate properties e Pop up reminders can be set up to alert the user to take proper actions e Processing of term loans with interest payable either at the beginning or the end of the term e Maintenance of a Document Catalog for each loan for quick access e Setting up different interest rates for borrower and lenders e Interest rates can be fixed or variable based on prime e Calculation of Bonus Interest as penalty in case of early discharge e Amortization Tables b
19. completed when you either post it or cancel it If you enter Loan SYNDi Loan Manager User Manual Page 174 Chapter 5 Working with Loans Discharge just to print payout statements and discharge notices do not post it if you are not ready Instead click Cancel 4 The Post button gets highlighted only if you have printed either Payout Statement or Discharge Notices and if there is no error You may correct the error by clicking Edit and reprinting the statements 5 Entering a discharge initiates the billing process Loan Discharge and Billing are mutually exclusive and you can run either one or the other You cannot enter a discharge if billing is in progress and vice versa If you wish to run billing while the discharge is in progress then either cancel the discharge or post it before you run billing Similarly if you wish to a discharge while billing is in progress then either cancel billing or post it before you enter the discharge 6 If you need to change the wording in Payout Statement or Discharge Notices run Microsoft Word 2003 and edit the files in Templates sub folder as described in Section 3 11 Be careful not to touch Mail Merge fields and save the files back as dot files WARNING If you edit your templates they may not work with future releases of the program SYNDi Loan Manager User Manual Page 175 Chapter 5 Working with Loans 5 8 Renew a Loan Reserved for future use SYNDi Loan Manager U
20. percentage is 100 9 The Miscellaneous Charge Code defined here is used only as a template and the values can be modified when the code is applied to a loan SYNDi Loan Manager User Manual Page 96 Chapter 4 Setting up the Application 4 7 Loan Status Codes 1 Click Loan Status Codes on Setup screen to display the following screen SYNDi LMS Loan Status Codes Setup Sample Financial Co BEE Status Code Description Stop Billing lel al ae Foreclosure iv Delete Close 2 The fields shown on the screen are described below Status Code g H Description Stop Billing Add SYNDi Loan Manager User Manual A numeric code of up to two digits set up to identify the status of a loan Finder is used to display a list of all codes in the Loan Status Codes table Scroll is used display previous or next record by hitting up or down arrow New is used to clear the screen while setting up a new status code Description of loan status code maximum 60 alphanumeric characters If Stop Billing is checked the loan is not included in the billing run Click to add a new record Page 97 Chapter 4 Setting up the Application Save Click to save an existing record It is highlighted only when the user changes a field Delete Click to delete an existing record rn Close Click to close the screen 3 To set up a new record click New to clear the screen
21. 10 15 2009 1 00 26PM NSFLetter_8505_20091010115657 doc 10 10 2009 10 57 00 AM PayoutStatement_20091010114612 doc 10 10 2009 10 46 22 AM Current Document DischargeNotice_BARJIM_2794_20091010114639 New Doc Delete Rename Close 36 The fields shown on the screen are described below Document List The list may contain Microsoft Word documents pdf files pictures of the property saved as jpg gif or bmp files survey results and all other related documents Some documents prepared by SYNDi are automatically saved in the Documents Catalog New Doc j New Doc is used to add a new document to the Documents Catalog Delete Delete is used to delete a document from the Documents Catalog Rename Renam e is used to change the name of a document in the Documents Catalog ii 37 Organization of Documents Catalog All files to be displayed in Documents Catalog are placed in the catalog folder which is database location Loans LoanID For SYNDi Loan Manager User Manual Page 159 Chapter 5 Working with Loans instance if the database is located in C Program Files SYNDi Database the catalog folder for Loan ID AVE1077 will be C Program Files S YNDi Database Loans A VE1077 In order to open a document double click on it in the Document List 38 Adding a New Document To add a new document to the catalog click New Doc button to display the following screen Add Document to Catalog f4
22. 2012ADMIN_ Bonower Receipt 11 Borrower Receipts resulting from Loan Adjustments and Investor Transfers are not grouped in individual batches Such transactions are assigned Batch 0 SYNDi Loan Manager User Manual Page 248 Chapter 12 Borrower Receipts 12 4 Receipts Entry Tab 1 The Receipts Entry tab is displayed as follows Ref No NEW AOI Bank ID cce e Loan ID Brne g 1160 Birchmount Road Receipt Date 1172572013 4 Actie Stop Biling Receipt Type jcasH ass Cah Receipt Amount 25 000 00 I write off Document No O o Description Borrower Receipt Due Principal 7455 i Interest 2475696 2475696 0 00 Misc Charges 000 Ooo Doo status On Account Receipts 5000 00 5 000 00 oo Unposted Deductions 0 00 J 0 00 0 00 Total Amount Due 23 931 51 J 23 931 51 J 0 00 Overpayment 1 068 49 V On account To be appllied 0 00 Add Delete Reverse Apply Print 2 The fields shown on the screen are described below Ref No A numeric Reference Number assigned by the system from the Next Payment Number in Company Profile table Whenever a new receipt is generated the Next Payment Number in Company Profile table is incremented by 1 To access an existing receipt enter the Reference Number and hit lt Tab gt g Finder is used to display a list of receipts in the Transaction table New is used to clear the screen while setting up a new record Bank ID Enter
23. 5 Click Investment Type tab to display the following screen Investor Receipt i Investment Type SYNDiLM Loan Adjustment Detail Sample Financial investment Type Opt Fields C test Registered Investments Plan Type RRSP a a Registered Retirement Savings Plan Plan Number 234 ABC 29876 TrusteelD m g jTDTust SYNDi Loan Manager User Manual Page 213 Chapter 9 Loan Adjustments 8 10 For a new Loan Adjustment the values on this screen ciome from the default value on Investor record You may change them if necessary Click Opt Fields tab to enter the optional fields if any The following screen is displayed SYNDi Mortgage Manager Loan Adjustment Detail Sample Financi Investor Receipt Opt Fields gt Category Click Investor Receipt Tab again and click Save and Close to return to the Loan Adjustments screen Go back to Step 2 above to add another investor SYNDi Loan Adjustments Sample Financial Company BEE Menu Loan Adjustments Entry Investors Investor ID CHOJIM e InvestorlD InvestorName Principal BAHOTT Otto Bahn 10 000 00 gt CHOJIM Jim Chong 15 000 00 When all investors have been added note that the list of list of investors and their contributions appears properly as shown below Click Loan Adjustments Entry tab and make sure that the Total Investor Principal is equal to the Adjustmen
24. 843 75 5 313 08 Yes 4 9021 d E z OF Total Payment 14 676 03 Close 3 The fields shown on the screen are described below Payment Date SYNDi Loan Manager User Manual Enter the date on which the payments to investors have been distributed All billed transactions are displayed in a grid in the sequence of billing date and loan ID The investor payments must be processed only if borrower receipts have been processed and posted and the bank has advised that the borrower check has been cleared If you need to process a payment double click in the Process column on the desired row a Yes entry will appear in the cell If you double click it again the Yes entry will disappear and Page 271 Chapter 13 Investor Payment the transaction will not be processed Description Displays the default description defined in Company Profile Change it if necessary Bank ID Enter the Bank ID of the bank from which funds will be withdrawn This field is optional unless SYNDi is integrated with an accounting package Loan ID You may specify a Loan iD if you wish to process payments only for a certain loan Select All Flags all loans for processing Select if Borrower Flags only those loans for which Borrower has paid Receipts have been processed De select All Removes processing flag from all loans Process Processes all flagged records Close Click to close the screen 4 If you need to process
25. Add Save Delete PEERS Close Enter the date on which the prime rate becomes effective Enter the Prime Rate up to 3 decimal places New is used to clear the screen while setting up a new prime rate Click to add a new record Click to save an existing record It is highlighted only when the user changes a field Click to delete an existing record Click to close the screen 2 To set up a new record click New to clear the screen Enter the date or use the calendar control to set a date If the record is already present in the table the data is displayed and the fields could be modified SYNDi Loan Manager User Manual Page 99 Chapter 4 Setting up the Application 3 If you do not click the New button while entering a new record the data from the previous record remains on the screen You may change any fields if necessary and then click Add to add the record 4 To modify an existing record click the appropriate record in the table of existing rates and change the rate 5 To delete a record click Delete SYNDi Loan Manager User Manual Page 100 Chapter 4 Setting up the Application 4 9 Borrowers The Borrowers screen is displayed when the user clicks Borrowers on Setup screen Hit lt Tab gt through various fields and change them if necessary The screen contains two tabs described below SYNDi LMS Borrowers Setup Sample Financial Company Applicant 1 Applican
26. Audit Specifications E Server Objects 49 Replication 49 Management S E SQL Server Agent 18 E Login New Select a page 7 7 Script AH General SS Sep baz Server Roles lt r User Mapping Login name SYNDiGroup s bl ES Windows authentication 7 Status SAL Server authentication e ord at next login Mapped to certificate Mapped to asymmetric key CD Map to Credential Mapped Credentials Credential Connection Server RAFI D820 Connection DOM_NTADMIN sultan F View connection properties Progress Default database master Default language lt default gt OK J Cancel a 19 Enter SYNDiGroup in Login Name field or choose Search 20 Click the User Mapping in the left Panel of the screen and select Acme from the list of databases in right panel by putting a checkmark in the empty checkbox This will enable SYNDiGroup SYNDi Loan Manager User Manual Page 59 Chapter 3 Running the Application full access to Acme 21 Check db_owner and Public in Database role membership section of the screen F Login New Select apage Script Hel LA General S soit Hep gt Server Roles _ User Mapping Users mapped to this login LF Securables Map Database Default Schema gt Status GBahama GBPA AR INDUS master MIC_CORP MIC_FMS model
27. Code du feuillet Numero didertiication dubsnefciirs Type deb ndficiaire voir au verso Box Case Amount Montant Box Case Amount Montant Box Case Amount Montant Recipient s name last name first and address Nom pr nom et adresse du b n ficiaire Payer s name and address Nom et adresse du payeur Bahn Otto Sample Financial Company 7481 Woodbine Ave 7481 Woodbine Avenue Suite 203 Markham ON L3R 2W1 Markham ON L3R 2W1 Currency and identification codes a 28 For information see the back Codes de devise et d identification Pour obtenir des renseignements Forsign currency Transit Succursale eciplent account ilos le vanes Devises trang res Num ro de compte du b n ficiaire Privacy Act Personal information Bank number CRA PPU 150 and CRA PPU 006 Lol sur la protection das renseignements personnels Fichiers de renseignements personnels ARC PPU 150 et ARC PPU 005 5 12 B Canada Revenue Agence du revenu m TA 8 50x14 00in lt SYNDi Loan Manager User Manual Page 303 Chapter 16 Loan Transfer Message Tab If you want to send Email to the investors with T5 slips as attachments you may want to write a email subject and an email message This subject and the message will be same for all your investors and will be stored in the database In future if you are using this email service again you will g
28. Delete Report Edit Process Cancel Post 2 The fields shown on the screen are described below User ID Name Password SYNDi Loan Manager User Manual A code set up to identify a user maximum 16 alphanumeric characters user defined Finder is used to display a list of all banks in the Users table Scroll is used display previous or next bank record by hitting up or down arrow New is used to clear the screen while setting up a new user User name maximum 60 alphanumeric characters Password for the user maximum 16 alpha Page 87 Chapter 4 Setting up the Application numeric characters Displayed as a row of asterisks Passwords are case sensitive Confirm Password Password for the user maximum 16 alpha numeric characters Displayed as a row of asterisks Passwords are case sensitive Enter the same value as in the field Password If the entries in the two password fields are not identical an error message is displayed Copy Profile of If you want to grant the same access rights as those for an existing user just enter the User ID and hit Tab The profile of the specified user is copied into the profile of the current user and you may change some or all rights before saving the record User Rights The table displaying the security level for each function is displayed You may change the security levels if necessary Add Click to add a new record Save Click to save an existing rec
29. Existing Fields area Save to save changes 6 To delete a record click Delete SYNDi Loan Manager User Manual Page 93 Chapter 4 Setting up the Application 4 6 Miscellaneous Charge Codes If SYNDi is interfaced with QuickBooks it is necessary that QuickBooks be open with the right company when you enter this screen 1 Click Misc Charge Codes on Setup screen to display the following screen SYNDi LMS Misc Charge Code Setup Sample Financial Co Misc Charge Code APPL fe E ol Description Application Processing Fee G L Account 4400 QllFee Income Misc Charge Type Flat Amount Sy Default Amount O 50000 Borrower Percentage 100 0000 Charge Borrower Investor Percentage 00000 Loan Discharge E Delete Close 2 The fields shown on the screen are described below Misc Charge Code An alphanumeric code of up to 16 digits set up to identify a miscellaneous charge g Finder is used to display a list of all codes in the Miscellaneous Charge Codes table al Scroll is used display previous or next record T by hitting up or down arrow New is used to clear the screen while setting up a new Miscellaneous Charge Code Description Description of Miscellaneous Charge Code maximum 60 alphanumeric characters G L Account General Ledger Account to which the SYNDi Loan Manager User Manual Page 94 Chapter 4 Setting up the Application Misc Charge Type Default Am
30. However if you decide to use SQL Server you must have it already installed on the system Please note that the SQL Server installation is available mainly for high volume installation Enter the folder in which you want to locate the database You may also point to the desired folder by clicking the Browse button Databae Location has two functions 1 It has all subfolders in which documents and templates reside and 2 If you are using Microsoft Access the mdb file is located in this folder If you are using SQL Server database the mdf and ldf files do not have to be necessarily located in this folder If you are using Microsoft Access leave the Server Name blank otherwise enter the name of the SQL Server on which the database is located Enter the name of the database file to be created If you are using Microsoft Access SYNDi creates the mdb file whereas for SQL Server you must create the database manually as shown in Section 3 14 Please do not enter the extension of the database name For instance in case of Acme just enter Acme instead of Acme mdb Leave the User ID blank if you are attaching to the database through trusted connection otherwise enter the User ID that will authorize you to connect to the database If User ID is blank please leave the Password field blank otherwise enter appropriate value SYNDiService is an add on product that runs as a Windows Service on some node in the Page 47 Chapte
31. Post each users receipts separately Details of this Batch processing is covered in Chapter 12 titled Borrower Receipts It is suitable for the environment in which you have several cashiers entering Borrower Receipts Choose whether variable interest rates will be based on prime rate If you pay commission to brokers agents or salespersons and if you have purchased SYNDiBroker module click this checkbox in which case you will have to set up brokers and enter commission while entering investor receipts Enter the BankID for your company bank where most transactions will occur It will be used as a default bank when you enter a transactionn screen but you will be able to change it if necessary Enter the account number of your bank account A sequential number assigned by the system to Page 75 Chapter 4 Setting up the Application Ref payment transactions You should not have to modify this number SYNDi Loan Manager User Manual Page 76 Chapter 4 Setting up the Application E Mail Tab 6 The E Mail tab is displayed as follows when the user clicks tab header SYNDiLM Company Profile Sample Financial Com 15 x Company Options E Mail Intearation Descriptions Will you use SYNDi to send e mails Use Microsoft Outlook Use SMTP Outgoing Mail Server 25 Sample Financial Company Sending E mail Address finto sfc comn t i sSOSOS S SC S SMTP Mail Server
32. REVENUS DE PLACEMENTS Actual amouni cf eigble dividends 25 Taxable amount cf aligtle dividends 26 Divdend friar for eligible Interest from Canadian souross 18 Capital gains dividends 20024 88 Int r ts da source canadienne Dividendes sur gains en capital Montant rel des dividendes d temnings Mertant impasatle des diidendes Cr dit dimp t pour diidendes ditermin s a Adius amount of diadend Taxable amcuni of dividends T Diidend tax credi fer dividende x z z ciherthaneigiledeiends Mi siter tran eigb deidonde 12 cmerthan sigte dhidende Report Code 22 Recipient ientiication number 23 Recipient type N l o 123456789 1 a ine e a ere auescuedentiocmechomn s Code du feuilst Nunodienicatindut neie Type de bende Other information s e the back Autres renseignements voir au verso Box Case Amount Montant Box Case Amount Montant Box Case Amount Montant Recipient s name last name first and address Nom pr nom et adresse du b n ficiaire Payer s name and acess Nom et adresse du payeur Bahn Otto Sample Financial Company 7481 Woodbine Ave 7481 Woodbine Avenue Suite 203 Markham ON L3R 2W1 Markham ON L3R 2W1 Currency and identification codes Codes de devise st didentifcation D gt a 28 For information see the back Foreign ourency jimall Wnowans Recipient accou
33. SYNDi Loan Manager User Manual Page 233 Chapter 10 Billing SYNDiLM Print Borrower Bill Sample Financial Company Hog Statement Email Message Subject Borrower Statement gt Message Your statement is attached Create Process Close 5 All bills are sent as a pdf attachment to the email message with the subject line and the message body entered on this screen You may change it if necessary 6 Once satisfied the subject line and the message body select Print Email tab The following screen is displayed SYNDiLM Print Borrower Bill Sample Financial Coy Statement Print Email Message J Print missing email Addresses Print C Email C All None p Selected Avenue Street Plaza info indusflow com 2365 Banglore Ave info indusflow com 1160 Birchmount Road email email com 2251 Circle Square 5516 Corvette Crescent email email com Damascus Plaza Liberty Village Condos email email com gt TST2075 Samuel Sampson email email com Create Process SYNDi Loan Manager User Manual Page 234 Chapter 10 Billing 7 Double click in the Selected column to choose the borrowers to be processed 8 Double clicking the LoanID or Description for a borrowerto preview a bill 9 Click Process to print or email the bills SYNDi Loan Manager User Manual Page 235 Chapter 11 Miscellaneous Transactions Chapter 11 Mi
34. Similarly when an Investor Transfer is performed the account number of the new investor has to be verified Finally in case of Loan Adjustment to advance additional funds to the borrower the bank accounts of investors contributing to the additional advance must be verified 6 Ifthe bank account of an investor has been entered by ADMIN it need not be verified 7 If the bank account is entered or modified by a user authorized to verify bank account information it must be verified by someone else 8 The fields shown on the screen are described below User ID Displays the user currently logged in List of Bank Displays Loan ID Investor ID Bank ID and Accounts Bank Account Numbers Process Processes all verified records and changes to bank accounts Print Displays a report containing list of bank accounts Master List Print a report showing Bank ID and Account Numbers in Investors Table Close Click to close the screen PEEL 9 Ifa bank account was entered by the user currently logged in the entry under Verified column shows Locked which means that it can be verified only by another user which is authorized to perform Bank Account Verification 10 Ifthe bank account number is correct double click in the Verified column The entry in the column now shows Yes which means SYNDi Loan Manager User Manual Page 274 Chapter 13 Investor Payment that the account number has now been verified 11 Ifthe acc
35. Test to make sure that the connection is successful Click OK 19 If you have set up SYNDi Loan Manager to interface with Sage Simply Accounting it attempts to open Simply Accounting database and displays the following message if it fails SYNDi Loan Manager User Manual Page 81 Chapter 4 Setting up the Application A Simply Accounting Database could not be opened Possible Causes of Error 1 Simply Accounting Database has been moved 2 The Connection string in Client Profile is incorrect 3 The password in Client Profile is incorrect 4 Someone has already opened Simply Accounting in Single user Mode Please close SYNDi and investigate 20 If the above message appears the program will not be able to validate various General Ledger accounts defined in Company Profile The problem could arise due to various reasons displayed in the message It is imperative that Simply Accounting must not be running in single user mode while the program is running ACCPAC ERP Interface 21 You must have General Ledger Accounts Receivable and Accounts Payable modules of Sage Accpac ERP Please make sure that you have defined a Payment Code CHECK with Payment Type Check in Accounts Payable 22 If you have set up SYNDi Loan Manager to interface with Sage ACCPAC ERP it attempts to open ACCPAC database and displays the following message if it fails A ACCPAC Database could not be opened Possible Causes
36. a billing record as described above and then create a receipt record debiting Bank and crediting Borrower Receivable If the Action is Billed and Received enter the Bank ID of the bank in which funds will be deposited This field is optional unless SYNDi is integrated with an accounting package Click to add a new record Click to save an existing record It is high lighted only when the user changes a field Click to delete an existing record Page 240 Chapter 11 Miscellaneous Transactions Close Click to close the screen 3 To enter a new transaction click New to clear the screen and hit lt Tab gt 4 To modify an existing record enter the Transaction Number or use Finder to select a record If the transaction has already been posted the following message is displayed This transaction has already been posted You canot change or delete it 5 You cannot modify a transaction once it has been posted 6 To delete a transaction click Delete You cannot delete a receipt that has already been posted 7 Click Add to add the record SYNDi Loan Manager User Manual Page 241 Chapter 12 Borrower Receipts Chapter 12 Borrower Receipts 12 1 Introduction Whether you receive the loan installment on monthly basis or you have collected postdated checks you have to enter receipts after the billing has been run so that you may distribute them to inventors You may use Borrower Receipts
37. add a new record Click to save the record displayed on the screen It is highlighted only when the user changes a field Click to delete the record displayed on the screen Click to print the record displayed on the screen Click to close the screen 6 To set up anew Template click New to clear the screen 7 You may hit lt Tab gt key to move from one field to the next Alternatively you may click inside a field and modify it 8 To modify an existing record enter the Template ID or use Finder to select a Template 9 To delete a Template click Delete SYNDi Loan Manager User Manual Page 138 Chapter 5 Working with Loans Options Tab 10 The tab is displayed as follows SYNDiLM Template Setup Sample Financial Settings Co onsi Accounts 1 Accounts 2 Miscellaneous Charges NSF Charge Code NSF tt a INSF Charges Prepaid Interest Code MTT A T Down Payment Code I ae Late Payment Chg Code QI On Account Receipts jonacer f On Account Receipts Tax Authorities Interest on Unpaid Balance Description Rate Calculate interest on unpaid balance J 1 HST 13 00 G LAccount a 2f 00 as 3 0 00 Investor 0 Save Delete Print 11 The fields shown on the screen are described below NSF Charge Code If you charge a service charge on returned borrower checks you may set up a Miscellaneous Charge Code and enter it here Ever
38. al 2 2 The functions on this screen enable the user to set up various master records as described in Chapter 4 3 The items included on the Setup Menu are as follows G L Accounts Enter the General Ledger account numbers and descriptions It is important that account numbers correspond to the actual chart of accounts so that you will be able to apply the journal entry properly in your General Ledger Banks Banks are used to send direct deposits for investors You must define at least one bank that will be used internally while setting up Company Profile Company Profile This function is used to enter the name and address of your company various options and parameters that you will use tax structure and account numbers SYNDi Loan Manager User Manual Page 29 Chapter 3 Running the Application Users Optional Fields Misc Charge Codes Loan Status Codes Brokers Commission Prime Rates SYNDiService Borrowers Investors SYNDi Loan Manager User Manual Define new users and change their passwords This function is available only when you are logged in as ADMIN You may define unlimited number of optional fields for borrowers investors and loans such as loan type property type realty taxes etc to customize the application Miscellaneous Charge Codes are used to enter sundry transactions such as NSF charge lawyer s fees realty taxes insurance management fee etc There is a st
39. are described below Template ID A code set up to identify the Template maximum 16 alphanumeric characters user defined g Finder is used to display a list of all Templates in the database al Scroll is used display previous or next record T by hitting up or down arrow New is used to clear the screen while setting up a new Template Description Description of the Template maximum 60 alphanumeric characters Loan are givenin Select Cash if loan is provided in cash in which withdrawals is made from a bank to advance loan to the borrower and the joural entry is credited to the bank account SYNDi Loan Manager User Manual Page 135 Chapter 5 Working with Loans Billing Frequency Interest Payment Frequency Default Calculation Method SYNDi Loan Manager User Manual Select Kind if you provide loans in kind e g sell land or buildings or finance equipment In this case when you fund the loan the entry will be credited toproper asset account Billing Frequency establishes how frequently you will running the billing process which is equivalent to generateing an invoice in accounts receivable The following options are available 1 Term On Maturity 2 Daily 3 Weekly 4 Biweekly 5 Semi Monthly 6 Monthly 7 Bi Monthly 8 Quarterly 9 Semi Annual 10 Annual In most cases the Billing Frequency is Monthly It determines how frequently will the borrower ma
40. arrow New is used to clear the screen while setting up a new bank Transit Number Transit Number consists of two parts 4 digit Institution Number that identifies the bank and 5 digit Branch Number that identifies the Branch In SYNDi the two parts are separated SYNDi Loan Manager User Manual Page 67 Chapter 4 Setting up the Application Bank Name Branch Name Address City State Prov PostalCode Country Tel Fax Contact Account Remarks Add Save SYNDi Loan Manager User Manual by ahyphen so that the format of Transit Number is 1234 56789 where 1234 is the Institution Number and 56789 is the Branch Number If the Institution Number is less than 4 digits put zeroes on the left side For instance 012 should be entered as 0012 Bank name maximum 60 alphanumeric characters Maximum 60 alphanumeric characters each Three address lines Maximum 60 alpha numeric characters each Name of the city maximum 30 alphanumeric characters State or province maximum 20 alphanumeric characters Zip code or postal code maximum 10 alphanumeric characters Name of the country maximum 20 alphanumeric characters Telephone number maximum 20 alphanumeric characters Fax number maximum 20 alphanumeric characters Contact name maximum 60 alphanumeric characters User defined maximum 60 alphanumeric characters A user defined memo field Click to add a new record Click to sav
41. been posted the following message is displayed This payment has already been posted You will not be able to delete this record OK 13 You cannot modify a payment once it has been posted 14 To delete a payment click Delete You cannot delete a payment that has already been posted SYNDi Loan Manager User Manual Page 270 Chapter 13 Investor Payment 13 4 Processing Investor Payments in Block 1 Itis suggested that this option be used only while entering investor payments in large numbers It does not allow partial payments and does not give the user much control The procedure described in Section 13 3 for entering individual payments provides better control and allows partial payments 2 Clicking Enter Payments in Block on Menu tab displays the following screen SYNDiLM Investor Payments Sample Financial Gas H d Payment Date 0373172011 E Description Payment to Investor Bank ID FceANK a z ees paid in full Loan ID Q E AU 1 684 29 Yes 3 31 2011 a T of 1 697 28 Yes 4 30 2011 147 0 a 2 234 39 5 31 2011 156 0 0 3 198 21 6 30 2011 157 0 00 5 250 39 3 31 2011 144 708 33 668 31 Yes 4730 2011 147 708 33 668 31 5 31 2011 156 708 33 668 31 6 30 2011 157 708 33 668 31 5 31 2011 156 2 368 49 2 320 70 6 30 2011 157 2 789 58 2 733 65 2 28 2011 143 5 843 75 5 313 08 Yes Total of Loans 5 Process 3 31 2011 144 5
42. file is moved into a sub folder called Backup From time to time you may want to clean the backup sub folder by deleting unnecessary files manually 26 Renaming a Document To rename a document from the catalog click on it in the Documents List to select it and then click Rename button SYNDi Loan Manager User Manual Page 122 Chapter 4 Setting up the Application Group Tab 27 If you intend to make the investor part of a group enter the Investor ID of the owner of the group in Group ID field otherwise leave it blank The table displays all members in the group in alphabetical sequence by name The tab is displayed as follows SYNDiLM Investors Setup Sample Financial Company Name and Address Personal Data Payment Documents Group Opt Fields GroupID GAMDAY a David Gambol Name TT Investor Owner gt David Gambol GAMDAY Julie Gambol GAMJUL SYNDi Loan Manager User Manual Page 123 Chapter 4 Setting up the Application Opt Fields Tab 28 The optional fields defined for investors are listed Just enter appropriate values for each field If the valid values of an optional field have been defined as a List just click on the value column to expose the drop down button and choose it to select a value The tab is displayed as follows SYNDiLM Investors Setup Sample Financial Company Name and Address Personal Data Payment Documents Group Opt
43. from it to another loan as needed The Borrower ID must be same for both loans 1 If you are setting up a new loan to which the money will be coming in progressively from another loan or credit line you may set it with zero balance SYNDi Loan Manager User Manual Page 308 Chapter 16 Loan Transfer 16 2 Entering Loan Transfers Transfer Entry Tab 1 Click Loan Transfer on Loan and Properties Menu Section 4 3 to display the following screen SYNDiLM Loan Transfer Sample Financial Menu Transfer Entry Transfer Number NEW QL From Loan ID javE1077 f venue Street Plaza gt Borrower ID BLOM imBlouki S Available Balance 168 654 42 To Loan ID coRvETTE QJ PimBlouki S Date 0371572011 4 DateRange 03 01 2011 to 03 31 2011 Document No 21 345 Paid to FO Description Loan Transfer st s i SOSOS S S SC S Amount Transferred 50 000 00 Interest 1 230 14 Calculate Status Delete 2 The fields shown on the screen are described below Transfer Number A number assigned by SYNDi to store and a access the transfer New is used to clear the screen while setting up a new transfer Finder is used to display all transfers in the database From Loan ID Enter the Loan ID of the loan from which you are transferring money You cannot transfer more than the balance in the loan BorrowerID Displays the Borrower ID for the loan Av
44. in the list of unposted batches If you want to continue working with one of those batches you may select it by clicking on it in the batch list and click Close without adding a new batch SYNDi Loan Manager User Manual Page 246 Chapter 12 Borrower Receipts 10 Only a user who has right to post batches can do so When all batches have been posted they disappear and the screen shows 0 for batch number After creating the batch click Close You will be taken to Receipts Entry screen as described in Section 12 4 To print a list of all unposted transactions at the end of the day click Menu tab and then click Print Unposted Receipts The following screen is displayed Unposted Borrower Receipts Process BatchNo Entries BatchDate UserID Description o o DI Yes a 1 B 8 2012ADMIN Borrower Receipt i A list of unposted batches is displayed The above screen shows that there is only one batch open Batch Number 1 and it has one entry Double click in Process column to change No to Yes Then click Print to print the batch Similar screen is displayed when you want to post batches You may select the batches to be posted by double clicking under the Process column and the click the Post button as follows SYNDi Loan Manager User Manual Page 247 Chapter 12 Borrower Receipts Post Borrower Receipts Process BatchNo Entries BatchDate UserID Description o o DI Yes 2 8718
45. most of the transactions in the grid choose Select All and then unflag the records to be excluded On the other hand if you need to process only some of the transactions in the grid choose De select All and then flag the records to be processed 5 Ifthe Payment Date is prior to the billing date of any of the transactions in the grid they cannot be processed Even if you double click in the Process column the entry is not changed to Yes You can view such transactions by scrolling the grid to the left to expose the Date Error column 6 When all desired transactions have been selected click Process to generate investor payments Print unposted payments to review them and then post them SYNDi Loan Manager User Manual Page 272 Chapter 13 Investor Payment 13 5 Bank Account Verification SYNDi Loan Manager can be integrated with SYNDi EFT System to deposit monthly payments to investors accounts through Electronic Funds Transfer Several security features have been incorporated into SYNDi to ensure that payments are not deposited in unauthorized accounts Clicking Bank Account Verification on Menu tab displays the following screen SYNDi LMS Bank Account Verification Sample Financial C BEE UserID JACKIE _ Verified InvestorlD LoanID InvNum EnteredBy BankiD AccountNo Name E E ARMTED 0 BOB 0400 02010 21076512 Ted Arr b Locked BARBIL 0 JACKIE 0260 01082 21 76124 Bill Baro BARBIL BIR11
46. of Error 1 ACCPAC Database has been moved 2 The Connection string in Client Profile is incorrect Please close SYNDi and investigate 23 Ifthe above message appears the program will not be able to validate various General Ledger accounts defined in Company Profile The problem could arise due to various reasons It is possible that you have not set up proper ODBC connection to point to the database or the ODBC connection has failed SYNDi Loan Manager User Manual Page 82 Chapter 4 Setting up the Application QuickBooks Interface 24 SYNDi can be interfaced with QuickBooks Pro 2010 or later It is necessary that QuickBooks be open with the right company when you enter the Company Profile screen otherwise the following message is displayed A Could not start QuickBooks 25 Ifthe above message appears the program will not be able to validate various General Ledger accounts defined in Company Profile SYNDi Loan Manager User Manual Page 83 Chapter 4 Setting up the Application Accessing QuickBooks for the first time 26 When you run SYNDi for the first time after interfacing with QuickBooks you have to indicate to QuickBooks that SYNDi is allowed to access the data in QuickBooks The following screen is displayed within QuickBooks QuickBooks Application with No Certificate An application without a certificate is requesting access to the following QuickBooks company file Sa
47. provides a journal entry to be applied to your General Ledger However at this point you may not be interested in setting up G L accounts since your priority may be to set up loans and get started The program automatically sets up account number 9999 as a dummy account and applies all transactions to this account If you are not interested in setting up G L accounts at this point you may let the program use this account and change it later In this case just skip this section and move on You need to set up G L Accounts in SYNDi Loan Manager only if you are using it as a standalone package If it is integrated with an accounting package like QuickBooks Sage Accpac or Simply Accounting as established in Company Profile Setup it will copy the chart of accounts from that package In that case you can skip this section altogether Click G L Accounts on Setup screen to display the following screen SYNDi LMS Accounts Setup Sample Financial Company BEE Account No 1020 azo Description Bank 1 in Trust Account Type Asset x Retained Earning Normal Balance Debit v Delete e SYNDi Loan Manager User Manual Page 62 Chapter 4 Setting up the Application 4 G L Accounts are required to generate journal entries as transactions are posted General Ledger Treatment You will need to set up a set of G L accounts to maintain the flow of transactions Following is the G L treatment of various t
48. the screen to browse through the table If the field on which you have clicked Finder is not blank the entry is shown in the Find field on search screen and the table displays records starting with the value in the field To start search from the middle of the table enter the value in the Find field and the display in the table gets modified For instance if you type 2 in the Find field the table will show all account numbers starting with 2 Accounts Payable GST Payable Payable to Investors 2400 Interest for Distribution 2500 Non Resident Tax 4400 Fee Income 5000 Rounding Errors When the desired record has been found click in the record selector area and then click Select to exit SYNDi Loan Manager User Manual Page 39 Chapter 3 Running the Application 3 9 Printing Reports 1 Reports and Inquiries Menu is displayed when the user clicks the Reports and Inquiries icon on Main Menu The reports generated by SYNDi Loan Manager fall into three categories Master Listings These listings show static information about loans borrowers and investors Transaction Listings These reports list various types of transactions generated during loan processing cycle Letters A number of letters generated by brokers can be printed through the program Custom Reports You can create reports in Microsoft Excel while importing data from SYNDi on the fly These reports typically contai
49. the Application example C S YNDi Documents Investors Bahott the catalog folder for investor Bahott In order to open a document double click on it in the Document List 24 Adding a New Document To add a new document to the catalog click New Doc button to display the following screen Choose the appropriate File Type e g doc pdf jpg etc or leave it to display all file types Select the proper drive and navigate to proper folder where the file is located The list of files is displayed on the left panel Double click on the name of the desired file to copy it into the Catalog Folder The original file is left in the source folder from where it can be deleted manually if necessary Add Document to Catalog Investor ID DINBEN ActivationLibrary bas AkwesasneConversion bas AnnualPercentCalculation xls File Type v BilingHistbylnvestorM enu bas BlankSYNDi mdb Check4ndCreateDB bas CheckINI bas CheckLayout dot CheckRedgistry bas J Accounting CEDC CI CDAutoRun 9 Customer Logos clsBilledB orrowers cls C Development clsBilledInvestors cls Documents clsBilledLoans cls clsBilling cls J E Mail Campaign clsBillingB orrower cls Icons clsBillingD ata cls C Images clsBorowerLoans cls CI Letters clsBorowerReceipts cls C Load 25 Deleting a Document To delete a document from the catalog click on it in the Documents List to select it and then click Delete button The
50. the Bank id of the bank in which funds will be deposited If you are using batches this field contains the Bank ID that you defined when creating the batch otherwise enter it here SYNDi Loan Manager User Manual Page 249 Chapter 12 Borrower Receipts Loan ID Borrower ID Date Document No Receipt Amount Write off On account SYNDi Loan Manager User Manual This is an optional field unless SYNDi is integrated with an accounting package Enter the Loan ID maximum 16 alphanumeric characters user defined or select it using the Finder button next to Loan ID in which case you will see a list of loans with outstanding balances Outstanding transactions are loaded when you enter Loan ID and hit lt Tab gt You will be able to see the transaction details by clicking on Principal and Interest tab which is activated only when the transactions are loaded Displays the Borrower ID and the name Enter the date of receipt Source Document Number e g check number maximum 30 alphanumeric characters user defined Enter the amount of check You may leave it as zero if you are just applying unapplied receipts to outstanding receivables If the Receipt Amount exceeds the Total Amount Due the difference is shown as Overpayment and is applied automatically to the principal If Write off is checked the amount is debited to Bad Debt Expense instead of Bank as specified in Company Profile The transaction
51. this time please click Activate otherwise click Continue and the usage will continue until the expiry Activate If you have chosen to activate the software the activation screen is displayed to enter the Installation Code and the Activation Key see Section 2 2 otherwise the login screen is displayed 2 You may review the users manuals by clicking Start gt Programs gt SYNDi Loan Manager and choosing User Manual or Microsoft Office Integration These manuals are in the pdf format and you may have to download Adobe Acrobat Reader if you do not have it installed on your system SYNDi Loan Manager User Manual Page 21 Chapter 3 Running the Application 3 2 Login Screen Click Start gt Programs gt SYNDi Loan Manager gt SYNDi or click the shortcut you have created to run the program The following login screen is displayed SYNDi LMS Login Om SYNDi Premium Release 5 7E LOAN MANAGEMENT SYSTEM Company Sample Financial Company E m User ID ADMIN Password Date 0271572010 E Login Cancel Sample Financial Company is a sample database that comes with SYNDi You may use it to test drive through the software until you are ready to set up your own company The default user ID is ADMIN for administrator If you do not set up additional users the program will display ADMIN as the user The password field will remain disabled until you set up additional users or change the password for us
52. will be 24 000 You will have to advance 76 000 to the borrower If an investor contributes 50 000 to the loan he will actually pay 38 000 and collect full 50 000 Page 179 Chapter 6 Investor Receipts Transit Number Account Cross Ref No SYNDi Loan Manager User Manual at the end of the term When you enter 50 000 for Gross Amount the system will automatically calculate 38 000 as the Net Amount If monthly payments will be made through direct deposit enter the Transit Number for investor s bank The Transit Number consists of a 4 digit Inistution Number of the bank followed by a hyphen followed by a 5 digit Branch Number If the Institution Number is less than 4 digits add zeroes on the left For instance if the Institution Number is 016 and the Branch Number is 20715 the Transit Number will be 0016 20715 Enter the Bank Account Number for the investor 7 to 12 numeric characters While entering a new receipt the system retrieves the Account Number from the investor record The value can be changed if necessary Cross Reference Number is a 19 character field that is used if you process investor payments through direct deposits via SYNDi EFT This field goes to the bank when you EFT the information When a new receipt is entered the system builds the Cross Reference Number by joining the first 9 characters of Loan ID and the first 9 characters of the investor ID and putting a hyphen in t
53. will be 792 83 99 354 76 100 147 59 so that the balance is zero SYNDi Loan Manager User Manual Page 13 Chapter 2 Installation Chapter 2 Installation 2 1 Install the Application 1 The minimum operating system environment to install and run SYNDi Loan Manager successfully is Windows 2000 with Service Pack 3 If your system does not meet or surpass the minimum requirement you may encounter problems Hardware requirements are not very rigorous On the workstation side any Intel dual core processor or higher would be fine 2 GB of RAM and 10 MB of disk space SYNDi doesn t require a separate server There are no active server side processes other than the SQL Server database and so the server just acts as a file repository for the SYNDi program files and some other config files Most of our clients have a dedicate VM for SYNDi so that if our tech support staff needs to get in with admin access to support the application then they have a comfort level that it is segregated from their other apps We have not actually certified SYNDi for use on Citrix but it should not be a problem We do have some customers who run it on Citrix without any issue once the system is tuned properly Every workstation should have Microsoft Word and Excel installed on it If you will be sending e mails through SYNDi you should preferably install Microsoft Outlook on it In order to install SYNDi Loan Manager you must have
54. with Yes flag in Self Admin column of the grid All transactions to be processed are indicated by Yes entry in the Process column If you need to process a receipt double click in the Process column on the desired row a Yes entry will appear in the cell If you double SYNDi Loan Manager User Manual Page 262 Chapter 12 Borrower Receipts click it again the Yes entry will disappear and the transaction will not be processed Description The default description defined in Company Profile is displayed Change it if necessary Bank ID Enter the Bank ID of the bank in which funds will be deposited This field is optional unless SYNDi is integrated with an accounting package Select Self Admin Flags all self administered loans for processing Select All Flags all loans for processing De select All Removes processing flag from all loans Process Processes all flagged records Close Click to close the screen 4 If you need to process most of the transactions in the grid choose Select All and then unflag the records to be excluded On the other hand if you need to process only some of the transactions in the grid choose De select All and then flag the records to be processed 5 If the Receipt Date is prior to the billing date of any of the transactions in the grid they cannot be processed Even if you double click in the Process column the entry is not changed to Yes You can view such transactions by scrolling th
55. 60 2373 BOB 0260 01082 22687610 Bill Baro BARBIL GOM556 2710 BOB_ 0260 01082 2287610 E Bill Baro BARBIL MAP2287 2211 BOB 0260 01082 2287610 Bill Baro Process Print Master List Close Security Measures 1 All passwords must be protected 2 Only one person and a backup should have access to ADMIN account 3 No user other than ADMIN should be authorized to set up users User Right 8 4 At least two users must be allowed to verify bank accounts User Right 30 5 If a loan contains one or more unverified bank account numbers it will be excluded from billing When a new investor is set up the Bank Account is flagged as unverified It is important that the account be verified before any loan receipt is entered otherwise all receipts will have to be verified In the screenshot displayed above ARMTED is a new investor and SYNDi Loan Manager User Manual Page 273 Chapter 13 Investor Payment no loans have been set up yet All records displayed with Investment Number 0 come from Investor Record while the ones with non zero investment numbers come from Loan Receipts The second record appears because the account number for BARBIL was changed As a result the associated Loan Receipts are also flagged to be verified 5 When a new Investor Receipt is entered the Bank ID and Account Number are flagged to be verified if different from banking information in the investor record
56. 65 Thus if the principal is 100 000 and the interest rate is 9 per annum we have P 100 000 and i 9 the interest for 21 days is 12X21 la X 736 30 508 35 9 In order to calculate blended payment P4 for certain number of days d multiply the payment amount Pn by 12 and divide the result by 365 to get one day s payment which when multiplied by the number of days will give the required result Thus 12Xd P P lt d m 365 Thus if the monthly blended payment is 792 83 as calculated in step 6 above the payment for 21 days is P 792 83X Pi 547 38 365 10 The principal portion of the payment can be obtained by subtracting from it the interest portion i e 547 38 508 35 39 03 11 The interest in the example quoted in this section will be calculated according to the following amortization schedule Month Principal Payment Interest Principal Balance 1 100 000 00 792 83 736 30 56 53 99 943 47 2 99 943 47 792 83 735 88 56 95 99 886 52 3 99 886 52 792 83 735 46 57 37 99 829 16 4 99 829 16 792 83 735 04 57 79 99 771 37 5 99 771 37 792 83 734 62 58 21 99 713 16 6 99 713 16 792 83 734 19 58 64 99 654 51 7 99 654 51 792 83 733 76 59 07 99 595 44 8 99 595 44 792 83 733 32 59 51 99 535 93 9 99 535 93 792 83 732 88 59 95 99 475 99 10 99 475 99 792 83 732 44 60 39 99 415 60 11 99 415 60 792 83 732 00 60 83 99 354 76 12 99 354 76 792 83 731 55 61 28 99 293 48 If the term of the loan is one year the last payment
57. 8 05 ADVAPI32 dll 5 01 2600 5755 2009 02 09 08 25 ancora tt roni arcan ran naninniar On the right side take note of the Computer name e g INSTALL B256CB0 and Port number e g 13540 Step 2 Run ODBC Datasource Administrator from Control Panel gt Administative Tools On the ODBC form go to System DSN and click Add Select MySQL ODBC Driver for the Data Source and click Finish Now you need to fill the following fields Data Source Name The name of database file e g Universal Description The name of your company e g UNIVERSAL CONSTRUCTION Server The Computer name e g INSTALL B256CB0 as you found earlier User Your user name sysadmin or other with 3rd party access rights Password the user s password or blank if no password Database simply SYNDi Loan Manager User Manual Page 80 Chapter 4 Setting up the Application Gi Connector ODBC 3 51 19 Configure Data Source KIEA Connector ODBC ae Wl aema Connector ODBC Configuration This dialog is used to edit a Data Source Name OSN Click on the Connect Options tab Port the port number e g 13540 as you found earlier onnector ODBC 3 51 19 Add Data Source Name FJE4 Connector ODBC PSA Connector ODBC Configuration This dialog is used to add a Data Source Name DSN iss Po pC a a a erty pC pe rs geses gt gt Note that Simply must be opened to connect through ODBC Click
58. 9 _ MCDROB 2365 0 0 0 0 0 0 0 00 0 00 _ MCKBOB 236 0 0 aa itm 0 00 0 59 _ NIMELY 236 0 0 395 89 237 0 00 1 19 _ SAUDAN 2772 0 0 395 8 2A 0 00 1 19 _ TABJAM 236 0 a irs 11 88 0 00 059 __ TINBOB 2370 0 0 395 8 237 0 00 11 WATJAM 2372 0 af ma ate 55 64 iq 8 If you need to change any of the amounts click on it to highlight it and retype the new amount otherwise leave the amounts unchanged 9 Click Misc Charges tab to display miscellaneous charges for each investor SYNDi Loan Manager User Manual Page 269 Chapter 13 Investor Payment SYNDi LMS Investor Payments Sample Financial Company Description gt BARBIL MGMNT Management Fee 17 26 _ BINSEB MGMNT Management Fee 34 48 E GOLBAR MGMNT Management Fee 60 34 HIGBAR MGMNT Management Fee 17 24 JINJOH MGMNT Management Fee 25 86 BS KNOBEN MGMNT Management Fee 8 62 m MCKBOB MGMNT Management Fee 8 62 NIMELY MGMNT Management Fee 17 24 SAUDAN MGMNT Management Fee 17 24 l TABJAM MGMNT Management Fee 8 62 _ TINBOB MGMNT Management Fee 17 24 a WATJAM MGMNT Management Fee 17 24 10 If you need to change any of the amounts click on it to highlight it and retype the new amount otherwise leave the amounts unchanged 11 Click Add to add and distribute the payment 12 To modify an existing record enter the Reference Number or use Finder to select a record If the payment has already
59. 92 Chapter 7 Investor Transfers Cross Ref No Fee Transit Number Account g Account SYNDi Loan Manager User Manual Cross Reference Number Please see the discussion in Section 6 2 While entering a new receipt the system retrieves the percentage of management fee from the To Investor record The value can be changed if necessary If monthly payments will be made through direct deposit enter the Transit Number for investor s bank The Transit Number consists of a 4 digit Inistution Number of the bank followed by a hyphen followed by a 5 digit Branch Number If the Institution Number is less than 4 digits add zeroes on the left For instance if the Institution Number is 016 and the Branch Number is 20715 the Transit Number will be 0016 20715 While entering a new transfer the system retrieves the information from the investor record The value can be changed if necessary If you process investor payments through direct deposits via SYNDi EFT this field is used when you EFT the information to the bank If you wish to pay the investor by a cherub leave the Bank information blank Enter the Bank Account Number for the investor 7 to 12 numeric characters While entering a new receipt the system retrieves the Account Number from the investor record The value can be changed if necessary Finder is used to display a list of all records in the Banks table Enter the Bank Account Num
60. Administrator rights If in doubt please check with your IT administrator or log in as Administrator If you have downloaded SYNDi Loan Manager from the Internet unzip SYNDi zip in a temporary folder to extract Setup exe Setup ini InstMsiA exe InstMsiW exe and SYNDi msi If you are installing the software from SYNDi distribution CD it contains these five files SYNDi Loan Manager User Manual Page 14 Chapter 2 Installation 9 Run Setup exe to install the system The following screen is displayed The installer will guide you through the steps required to install SYNDi Loan Management System on your computer Click Next to continue WARNING This computer program is protected by copyright law and international treaties Unauthorized duplication or distribution of this program or any portion of it may resultin severe civil or criminal penalties and will be prosecuted to the maximum extent possible under the law Cancel reviou 10 If any other applications are running stop them and then click Next The system displays the following License Agreement screen Please take a momentto read the license agreement now If you accept the terms below click I Agree then Next Otherwise click Cancel INDUS SYSTEMS a SYNDi Loan Management System The installer will install SYNDi Loan Management System in the following folder To install in this folder click Next To install to a different
61. All documents in the Catalog are displayed in Documents tab and can be opened by double clicking a document Group Related Investors can be grouped together to facilitate marketing For instance an investor his her spouse and children can form a single group Every group has one owner and one or more members Opt Fields Enter the optional fields defined for investors You may access various tabs by clicking on the tab header if you are on a particular investor record The fields on each tab are described below SYNDi Loan Manager User Manual Page 110 Chapter 4 Setting up the Application Name and Address Tab 4 The tab is displayed as follows SYNDiLM Investors Setup Sample Financial Company Name and Address Personal Data Payment Documents Group Opt Fields Investor ID BAHOTT cr Name Otto Bahn Corporate FirstName A LastName Bahn Individual Address 7481 Woodbine Ave OSOS s s Copy fSute203 0 A City State Markham JON PostalCode L3R 2W1 Country oOo Tel 905 940 0751 Fax 905 940 0341 EMal finfo indussyscom gt SCS S lt lt 7 Contact Otto Bahn S Soc Ins No o save Delete Print 5 The fields shown on the screen are described below Investor ID g HI First Name Last Name SYNDi Loan Manager User Manual A code set up to identify an investor maximum 16 alphanumeric characters user define
62. Enter the status code 2 to 99 If the record is already present in the table the data is displayed and the fields could be modified 4 You may hit lt Tab gt key to move from one field to the next Alternatively you may click inside a field and modify it 5 If you do not click the New button while entering a new record the data from the previous record remains on the screen You may change any fields if necessary and then click Add to add the record 6 To modify an existing record enter the Status Code or use Finder to select a record Enter the fields and click Save to save changes 7 Status Codes 0 Paid Out and 1 Active are reserved by the program When a new loan is set up the status code is automatically set to 1 and when it is paid out the status becomes 0 8 To delete a record click Delete You cannot delete a record if the status code has been assigned to a loan SYNDi Loan Manager User Manual Page 98 Chapter 4 Setting up the Application 4 8 Prime Rates 1 Click Prime Rates on Setup screen to display the following screen The fields shown on the screen are described below SYNDi LMS Prime Rates Setup Sample Financial Company 01 02 2010 Date 01 02 2010 By Prime Rate 2 100 02 16 2008 08 02 2007 09 20 2006 05 15 2006 10 05 2004 08 01 2004 Delete January v 2010 v Close Prime Rate
63. Fields Name Vale Date of Brirth 2 2 1958 gt Marital Status Divorced Delete SYNDi Loan Manager User Manual Page 124 Chapter 4 Setting up the Application 4 11 Reminders 1 Click Reminders on Setup screen to display the following screen SYNDi LMS Reminders Setup Sample Financial Company Reminder ID o nei Reminder Type General Loan C Borrower Investor Other Loan ID BIR1160 Effective Date 06 09 2009 at Remind Me v A 1160 Birchmount Road 9 oo Am C PM Created by ADMIN Reminder Date 02 16 2010 HE a 9 v joo AM CPM Personal v Note Samuel Sampson will pay 200 000 on this billing Enter 200 000 in Principal Payment Leave the payment frequency zero so that this amount is billed only on this billing Hold Billing Save Delete Close 2 The fields shown on the screen are described below Reminder ID Sequential number assigned to the note by the e H Reminder Type Loan ID Borrower ID Investor ID Party ID SYNDi Loan Manager User Manual program Finder is used to display a list of all Reminders in the database Scroll is used display previous or next record by hitting up or down arrow New is used to clear the screen while setting up a new note Select the entity to which the note will be applied The valid entities are loans borrowers investors other parties and gene
64. Fields include total amount loaned total principal paid total interest paid and total fee deducted These fields are for information only and cannot be modified SYNDi Loan Manager User Manual Page 120 Chapter 4 Setting up the Application Documents Tab 21 This tab displays investor documents saved in Documents Catalog SYNDiLM Investors Setup Sample Financial Company Name and Address Personal Data Payment Documents Group Opt Fields DocumentName Type Modify gt 15_52012001 pdf 2 13 2013 4 07 44 PM T5_ 2012003 pdf 2 14 2013 12 47 13 PM Current Document T5_ 2012001 New Doc Delete Rename 22 The fields shown on the screen are described below Document List The list may contain Microsoft Word documents pdf files pictures of the property saved as jpg gif or bmp files survey results and all other related documents Some documents prepared by SYNDi are automatically saved in the Documents Catalog New Doc j New Doc is used to add a new document to the Documents Catalog Delete Delete is used to delete a document from the Documents Catalog if Rename Rename is used to change the name of a document in the Documents Catalog 23 Organization of Documents Catalog All files to be displayed in Documents Catalog are placed in the catalog folder which is SYNDi Documents Investors InvestorID For SYNDi Loan Manager User Manual Page 121 Chapier 4 Setting up
65. Finder is used to display a list of all records in a table Scroll is used display previous or next record by hitting up or down arrow New is used to clear the screen while setting up a new record Fly is used to open another screen and add or modify a record on the fly Calendar appears next to some date fields and can be clicked to select the date instead of being entered 1 Snn through the keyboard Add Click Add button to add a new record Save Click Save button to save an existing record Delete Click Delete button to delete an existing record The system prompts the user to confirm if the record should be deleted Close Click Close button to close the screen If you are adding a new record the Delete button is normally disabled When you click Add button the system checks the validity of data If every field has been filled properly the record is added but still stays on the screen in case you want to change a field or SYNDi Loan Manager User Manual Page 36 Chapter 3 Running the Application delete the entire record The Add button is replaced by the Save button and the Delete button becomes enabled 6 Ifyou access an existing record the Save button remains disabled until you change any field The Delete button is enabled in case you want to delete the record 7 If you delete a record the Add button becomes enabled and the record remains on the screen in case you want to add it back 8 Ifyou hit New
66. LMS Borrower Payments Sample Financial Company lof Menu Payments Entry Payments Entry Enter borrower payments Menu Print various listings and post payments You may access various tabs by clicking on the tab header SYNDi Loan Manager User Manual Page 201 Chapter 8 Borrower Payments 8 2 Payments Entry Tab 1 The Payments Entry tab is displayed as follows Menu Payments Entry Loan ID Bank ID Borrower ID Date Paid to Principal Net Payment SYNDiLM Borrower Payments Sample Financial 1o x jery Ale D Liberty Vilage Condos ea g JQUEPLA Queens Place gt 0170172012 Queen s Pace oo Document No 217655 500 000 00 Down Payment M oo Prepaid Interest oo 500 000 00 Reference No NEW Cross Ref No JLIBERTY QUEPLA Borrower s Bank for 20 10812 20761 21714 Status Unposted Transit Number Account No Miscellaneous Charges Description Cd fe E Add Delete 2 The fields shown on the screen are described below Loan ID Reference Number Date SYNDi Loan Manager User Manual Enter the Loan ID maximum 16 alphanumeric characters user defined Finder is used to display a list of all records in the Loans table Fly is used to set up a loan on the fly Enter Bank ID of the bank from which funds will be disbursed to the borrower If the loan is provided in kind the Bank ID field is disabled A numeric refer
67. Loan Manager User Manual Page 73 Chapter 4 Setting up the Application Exclude first day from interest calculation Maintain Multiple Investors Do you have web interface SYNDi Loan Manager User Manual be increased if necessary If you do not exclude first day from interest calculation the system calculates interest for the day on which the loan is started That is the date on which funds are received from investors and advanced to the borrower Suppose the Start Date of the loan is January 1 2007 the Billing Day is set to be 1 and term of the loan is 12 months the program will calculate the Maturity Date as December 31 2007 and will run the first billing on January 1 2007 calculating interest adjustment for one day However if you exclude first day from interest calculation the Maturity Date will be calculated as January 1 2008 and the first billing will run on February 1 2007 calculating interest for one month Once you set up this parameter it is suggested that you should not change it unless the policy of your company changes When you set up a new company the box is checked as a default and the first day is excluded from interest calculation If you maintain a pool of investors and the funding for a loan comes from one or more of those investors check Maintain Multiple Investors checkbox In this case you will have to enter investor receipts before you can a fund a new loan and will have to
68. Microsoft Word For details please consult SYNDi manual entitled Microsoft Office Integration Chapter 1 5 When a report is selected the following screen is displayed SYNDi Loan Manager User Manual Page 42 Chapter 3 Running the Application Enter Report Range Investor Statement Destination V Screen Printer D E Mail Fax Investor ID Between and ZZZZZZZZZZZZZZZ a Date Between 0170172008 and 03 25 2008 H Level Detailed C Summary V include receipts Continue Cancel 6 Under Destination check Screen and or Printer The E Mail Fax option is available on certain reports only You must choose at least one destination If you select Screen the report is displayed on the screen whereas if you select Printer it is sent to the printer If you select both the report is displayed on the screen first and it is sent to the printer after you close the screen display 7 Under Range 1 enter the From and To range of Investor ID or Loan ID depending on the report The From field is normally blank while the To field shows a row of Z s If you want to print a report displaying all loans or investors do not change these fields otherwise enter the proper range Note that the value in the To field cannot be less than the value in the From field 8 Under Range 2 enter the From and To range of transaction dates The From field normally displays January 1 of the current year while the To field sh
69. Misc Charge tab from the Borrower tab the page displays borrower charges On the other hand if you come to the tab from the Investors tab the page displays charges to be paid to the investor SYNDi Loan Manager User Manual Page 232 Chapter 10 Billing 10 7 Printing Borrower Bills 1 The Print Borrower Bill screen allows you to print and or email a bill to your borrowers This function is run immediately after billing for the current month Bills can be emailed only if you have indicated in the Company Profile that you send emails through SYNDi SYNDiLM Print Borrower Bill Grand Bahama Development Company mf Statement Email Message Loan f A o Z Month 6 Year 2014 The following text will be displayed above the bottom copy of the bill IMPORTANT To ensure proper credit this copy must be returned with your remittance Create ro Close 2 The bill is normally produced in two parts You can enter a note in the text field to be displayed immediately above the bottom part which the borrower is supposed to return with payment By default the wording is as shown in the figure However you may delete it if you do not want any message to be printed above the bottom part of the bill 3 Click Create to generate bills in the specified range 4 When the function is completed the following screen is displayed provided your configuration has been set up for emailing through SYNDi
70. Not Available cannot be corrected through the edit In this case exit billing update prime rate run billing again and click Process to overwrite the billing data 10 Click Cancel to delete billing data in the temporary area This function is typically used when you have already collected billing data and want to make some last minute changes Please note that SYNDi Loan Manager User Manual Page 224 Chapter 10 Billing any modifications made to the data during edit function will be lost and you will have to click Process button again to collected fresh data You cannot delete billing data once it has been posted 11 Ifthe billing data collected in temporary area is free of all errors the Post button becomes undimmed Click to apply the billing data and delete if from temporary area The following message is displayed WARNING After you have performed the posting you will not be able to print the report If you want to print the report do not proceed with posting You may post the current billing after the report has been printed Are you sure you want to post the billing data now 12 The posting function copies billing data in temporary area into permanent area deletes temporary area and generates General Ledger entries Once the data is posted you cannot edit it or generate pre billing report SYNDi Loan Manager User Manual Page 225 Chapter 10 Billing 10 3 Editing Billing Data 1 Cli
71. OAN MANAGEMENT SYSTEM Company Sample Financial Company al User ID Acme Financial Services Sample Financial Company Password Date Login Cancel 9 Double click on Acme Financial Services to choose it Then click Login The following message is displayed Create Database SYNDi Loan Management System database c Database SYNDi mdb has not been found This happens only when you have just set up a new company and are entering it for the first time If you have already created a database and have been running the system you should not see this screen If your are in doubt please click No to terminate SYNDi Loan Management System and investigate otherwise click Yes to create the new database The system will now create a new database Do you want to create a new database 10 Click Yes to create the new database Themfollowing screen is displayed SYNDi Loan Manager User Manual Page 49 Chapter 3 Running the Application Create Database Let SYNDi create your database CompanyName Acme Financial Services Database Type Microsoft Access DatabaseName Acme gt Database Location C Program Files SYNDi Database gt gt 11 Click Proceed At this point the system creates the mdb or mdf file depending on whether you are using Microsoft Access or SQL Server 12 If no error is encountered during the creation of the database the following message is dis
72. Prepare T5 Slips SYNDi Loan Manager User Manual cancel the latest billing provided no borrower receipt has been entered yet If SYNDi Loan Manager is interfaced with an accounting system run this function to 1 Copy Chart of Accounts and Banks from the accounting package and 2 Transfer accounting entries to the accounting package Each entry transferred to accounting is flagged as Transferred so that you cannot transfer it again Transfer all entries at the end of each period month This routine produces checks See Chapter 14 for details This process is meant for Canadians individuals and corporations This generates T5 slips for investors earned interest It must be filed along with tax returns to Canada Revenue Agency CRA Page 35 Chapter 3 Running the Application 3 7 Screen Management 1 All icons and buttons in the application are activated by single mouse click Hit lt Tab gt key to move from one field to the next field in a data entry screen You may also position the cursor inside a field and click the mouse to place the cursor in that field If the background color of a field is same as the screen color or if the entry inside the field is dimmed it is read only and you cannot change the content On the other hand if the background is white and the entry is not dimmed it can be changed The following table shows various buttons found on data entry and inquiry screens
73. ReceiptNo_yyyyMMddhh mmdd doc where ReceiptNo is the receipt number generated at the time of entering investor contribution to the loan and yyyyMMddhhmmidd is the date and time year month day hour minutes second at which the report was generated SYNDi creates a folder database location Documents Loans LoanID for each loan and saves the document in that folder Page 51 Chapter 3 Running the Application Reports This folder is used to save various reports generated by the program and by users SYNDi Loan Manager User Manual Page 52 Chapter 3 Running the Application 3 12 Setting up Workstations The Trial version does not include workstation setup files After you gave purchased the system you will receive a setup file from INDUS to install Visual Basic and database runtime system Alternatively you may run setup exe from the file you have already downloaded but before you run the system point the shortcut to the Application Folder you have installed the system in as follows assuming that your are running the system on Windows 2000 platform 1 Click Start gt Programs gt SYNDi Loan Manager 2 Position the cursor on SYNDi and right click 3 Select Properties 4 Change the target to point to the correct location of SYNDi exe e g L S YNDi S YNDi exe You may also create a Shortcut on the Desktop to run SYNDi exe from the Application Folder SYNDi Loan Manager User Manual Page 53 Chapt
74. SYNDi LOAN MANAGER Release 6 1 User Manual indusflow INDUSFLOW SYSTEMS INC www indusflow com INDUS SYSTEMS SOFTWARE LICENSE AND END USER AGREEMENT THIS END USER LICENSE AGREEMENT APPLIES TO ALL SOFTWARE DEVELOPED BY INDUS SYSTEMS INCLUDING THE FOLLOWING PRODUCTS SYNDi Loan Manager SYNDi Fund Manager SYNDi Investment Ledger SYNDi Electronic Funds Transfer INDUS Backorder System IMPORTANT READ CAREFULLY BEFORE YOU PROCEED FURTHER This End User License Agreement hereafter referred to as Agreement is a legal agreement between You You and Your includes a person and or an individual entity and INDUS SYSTEMS INDUS concerning the specified software products s hereinafter referred to as Software The Software includes all component parts the associated media any printed materials any updates and any online or electronic documentation as applicable By accessing installing copying or otherwise using the Software You agree to be bound by the terms of the Agreement If You do not agree to these terms INDUS is unwilling to license the Software to You In such event You may not access use or copy the Software and You should promptly contact INDUS for instructions on returning the Software WRITTEN ASSENT IS NOT A PREREQUISITE TO THE VALIDITY OR ENFORCEABILITY OF THIS AGREEMENT General License By installing an authorized copy of the Software You are granted a non transf
75. Section 5 3 Chapter 16 Section 5 4 Section 5 4 Section 5 4 Section 5 4 Page 33 Chapter 3 Running the Application 3 6 Periodic Processing Menu 1 Periodic Processing Menu is displayed when the user clicks the Periodic Processing icon on the Main Menu SYNDiLM Periodic Processing Sample Fin E O iB Delete Old G L Entries Cancel Latest Billing Sage Accpac ERP Interface l Purge Old Data Generate Checks 7 The functions displayed on this screen are run on regular basis e g if SYNDi Loan Manager is interfaced with an accounting package the G L entries should be transferred on monthly basis Certain functions e g cancelling latest billing could be run whenever necessary 8 The items included on Periodic Processing Menu are as follows Delete Old G L If SYNDi Loan Manager is running as a Entries standalone program this function deletes all G L entries up to the specified cutoff date If SYNDi Loan Manager is interfaced with an accounting package this function deletes all entries that have been transferred to accounting Cancel Latest If the Pre billing Report after running a Billing billing cycle shows unexpected results e g a loan that was due for discharge has actually been renewed but you forgot to renew it before running billing In such cases you can SYNDi Loan Manager User Manual Page 34 Chapter 3 Running the Application Accounting Interface Generate Checks
76. User Manual Page 177 Chapter 6 Investor Receipts 6 2 Receipts Entry Tab 1 The Receipts Entry tab is displayed as follows Menu Fleceinis Eni Investment No Bank ID Loan ID Date Investor ID Description Lawyer ID Gross Amount Cross Ref No m SYNDiLM Investor Receipts Sample Financial Coun Mi E C a g jave1077 e Avenue SteetPlaza ono i BAHOTT e DtoBban tt i i S Investor Contribution kan e Khan Associates Barristors J 100 000 00 Net Amount J 100 000 00 JAVE1077 BAHOTT Investor s Bank Transit Number Account No foo1 6 20715 Principal Advanced J 110 000 00 002061 076 Status Posted 2 The fields shown on the screen are described below Investment No Bank ID e Loan ID SYNDi Loan Manager User Manual A numeric code assigned by the system from the Next Receipt Number in Company Profile table Whenever a new receipt is generated the Next Receipt Number in Company Profile table is incremented by 1 Finder is used to display a list of receipts in the Loan Investors table New is used to clear the screen while setting up a new record Enter Bank ID for thebank in which funds will be deposited This field is optional except wghen SYND1 is integrated with an accounting package Finder is used to display a list of banks in the Banks table Enter the Loan ID maximum 16 alphanumeric Page 178 Chapte
77. View Favorites Tools Help H Favorites akk Filing Information Returns Electronically T4 T5 and ot A Do Gi whe Pager Safety Tos he Canada Revenue Agence du revenu Agency du Canaca Canada Revenue Agency A www cra gc ca Francais Home Contact Us Help Search Online services and other e services Filing Information Returns Electronically T4 T5 Forms and publications and other types of returns Online services A to Z index Sitemap Ss File a return Individuals E e File by Internet file transfer XML Business e File by Web Forms mr A E e File by T4 Desktop application Other groups p e File by electronic Media DVD CD Search CRA e File by T1204 Desktop application Need to retrieve your Web access code Internet filing for information returns is available January 7 2013 22 Clicking the link File by Internet file transfer XML on CRA web page you will jump to another web page Internet file transfer XML On this page you will click the button with the caption Enter Internet file transfer XMI secure Web site Internet file transfer XML Windows Internet Explorer DER atc gc cafesrvc srvce rf xmi menu eng htm j tive Sard le File Edit view Favorites Tools Help oly Favorites ade Internet file transfer XML he Canada Revenue Agence du revenu Agency du Canada Canada Revenue Agency A www cra gc ca Francais Ho
78. You can set up trustees as Other Parties with Party Type T for Trusteee See Section 4 12 An investor may be paid in the following cycles Monthly Quarterly Semi Annual Annual On Maturity In case of Monthly payments an investor can Page 118 Chapter 4 Setting up the Application Fee Rate Fee Taxable Non Resident Tax SYNDi Loan Manager User Manual be paid on any date after running billing In case of Quarterly payments an investor can be paid on any date after March 31 June 30 September 30 and December 31 for all billings run before or during the first second third and fourth quarters of the calendar year For Semi Annual payments an investor can be paid on any date after June 30 and December 31 for all billings run before or during first and second half of the calendar year For Annual payments an investor can be paid on any date after December 31 for all billings run before or during a calendar year If the Payment Frequnecy is On Maturity the investor is paid all instalments when the loan is discharged Payment Cycle may vary from investment to investment When an investor receipt is created it uses the Default Payment Cycle from the Investors Table but can be changed if necessary Percentage of management fee The value is taken from the default percentage set in company profile but can be changed on this screen to vary from investor to investor Fee is calculated
79. a new Type Code by clicking the Fly button next to Type field You may use Type to indicate the zoning e g RES for Residential COM for Commercial etc User defined field maximum 16 alphanumeric characters You may display the predefined Category Codes by clicking the Finder button or define a new Category Code by clicking the Fly button next to Category field User defined field maximum 16 alphanumeric characters You may display the predefined Class Codes by clicking the Finder button or Page 163 Chapter 5 Working with Loans define a new Class Code by clicking the Fly button next to Class field Add Click to add a new record Save Click to save an existing record It is highlighted only when the user changes a field Delete Click to delete an existing record Close Click to close the screen HEE 3 Calculation of Loan To Value LTV Ratio Loan To Value Ratio is defined as the amount owed on the property divided by the Appraised Value or the Selling Price whichever is less The value is frequently multiplied by 100 to express it as a percentage SYNDi Loan Manager calculates LTV Ratio only if Appraised Value or Selling Price have been provided If both values have been entered it uses the smaller value as Base Value Next it scans the database to calculate the outstanding principal on all loans linked to the property The Other Loans amount is added to the total of outstanding principals to get the Ba
80. ab is displayed as follows SYNDiLM Loans Sample Financial Compa Details Terms Notes Property Contacts Documents Opt Fields Co Borrowers SAMSAM a 3 Samuel Sampson T E D e Guarantors 1 smun l Mohn Smith Af gejl J gaji Jo gal Lawyer ID KHAN a Khan Associates Barristors Reference File Number 20158 Save Delete Profile Amortization Investors Inquiry Close Co Borrowers You can specify up to four Co Borrowers set up in Borrowers Table Guarantors You can specify to four Guarantors set up in Other Parties Table Lawyer ID Enter the Lawyer ID for the loan maximum 16 alphanumeric characters predefined Lawyers are defined in Other Parties Table See 4 12 Reference Any user specified information about the loan maximum 60 alphanumeric characters 34 Any quantitative or descriptive information about co borrowers and guarantors can be placed on the Notes tab SYNDi Loan Manager User Manual Page 158 Chapter 5 Working with Loans Documents Tab 35 This tab displays loan documents saved in Documents Catalog SYNDi LMS Loan Maintenance Sample Financial Company Details Terms Notes Property Contacts Opt Fields DocumentName Type _ ModityDate gt DischarqeNotice_BARJIM_2794_20091010114639 doc _ 10 10 2009 10 46 44 AM DischarqeNotice_Borrower_20091010114636 E doc 10 10 2009 10 46 40 AM NSFLetter_8494_20091015140022 doc
81. acters Telephone number maximum 20 alphanumeric characters Fax number maximum 20 alphanumeric characters E mail address of the borrower maximum 200 alphanumeric characters Contact name maximum 60 alphanumeric characters For Canadian users this field represents 9 digit Social Insurance Number for individual investors or the Business Number for corporations or Trust Account Number for trusts It is used for the preparation of T5 Slips It should conform to CRA layout Page 112 Chapter 4 Setting up the Application For non Canadian users this field is treated as user specified field and could be used as necessary User ID This field is displayed only if you have indica ted in Company Profile that you are using eS YNDi to provide web access to the investors to display their records When a new investor is set up the User ID is same as InvestorID However you may change it if required The program checks to ensure that each User ID is assigned to one and only one investor Password This field is displayed only if you have indicated in Company Profile that you are using eS YNDi to provide web access to the investors to display their records When a new investor is set up the password is set as password all lower case characters and no quotes When investors log into their eS YNDi account for the first time they must change the password for future access Add Click to add a new record Click to sa
82. age administrator enter your Administrator License Number here otherwise leave it blank Account Number If you are a Canadian company enter your CRA Business Account Number in this field It is a 15 digit field of the format 123456789RZ1234 This field will be used if you generate T5 slips to investors Other users may leave this field blank or use it for other purposes Transmitter If you are a Canadian company enter your Number Transmitter Number that has been provided to you by CRA to submit TS slips electronicall It is an 8 character field with the first two characters alpha and the remaining six characters numeric Other users may leave this field blank or use it for other purposes DB Location Location of the database SYNDi mdb This entry is taken from SYNDi ini created in the Application Folder during the system installation and should be modified only if you want to move the database to another location If the new location already contains SYNDi mdb it cannot be moved Save Click to save an existing record It is highlighted only when the user changes a field Close Click to close the screen SYNDi Loan Manager User Manual Page 72 Chapter 4 Setting up the Application Options Tab 5 The Options tab is displayed as follows when the user clicks tab header SYNDiLM Company Profile Sample Financial Cor t E Mail Inteqration Descriptions Company Display pop up Reminder N
83. ailable Balance Displays the balance in the loan To Loan ID Enter the Loan ID of the loan to which you are SYNDi Loan Manager User Manual Page 309 Chapter 16 Loan Transfer transferring money Date Enter the date of transfer Document No Enter the document cheque or voucher number Paid To Normally the borrower or lawyer name Description The default description is Loan Transfer Change it if necessary Amount Enter the amount transferred Transferred Interest The program calculates interest on the amount transferred based on the interest rate defined for From Loan and applies it to To Loan You may change the amount if necessary Calculate Click to calculate the interest Status Displays whether the Transfer has been posted or not Add Click to add a new record Save Click to save an existing record It is highlighted only when the user changes a field Delete Click to delete an existing record Close Click to close the screen in EE SYNDi Loan Manager User Manual Page 310 Chapter 16 Loan Transfer Menu Tab 3 The Menu Tab is displayed as follows SYNDiLM Loan Transfer Sample Financial Company m E4 4 This Tab is used to print unposted or posted transfers or to post unposted transfers SYNDi Loan Manager User Manual Page 311 Chapter 17 Loan Documents Chapter 17 Loan Documents 17 1 Introduction SYNDi can be used to generate loan originating doc
84. al fee to be deducted from the Page 173 Chapter 5 Working with Loans interest and penalty calculated for investors Investors N R Tax Displays the total non resident tax to be deducted from the interest and penalty calculated for investors Investors Sales Displays the total sales tax to be deducted on Tax the fee charged from investors Investors Displays the total amount of unpaid Misc Charges miscellaneous including the amounts to be paid at the time of loan discharge Investors Prev Displays the total of previous undistributed Balance balances Investors Total Display the total amount payable to the Payout investors Payout Click to print the Payout Statement Statement Discharge Click to print master discharge notice as well Notices as discharge notices for individual investors Discharge Click to print the Discharge Report similar to Report Billing Report produced during a billing run i Click to edit the billing data collected in the Edit temporary area See Section 10 3 for details Click to apply the billing data and delete the temporary area The Post function pays off the loan Post Click to delete the billing data collected in the temporary area You can use this button if you have not posted the data yet Please note that any edits done to the billing data are lost Cancel Click to close the screen Close RRA L 3 Loan Discharge cycle starts when you enter the discharge date and is
85. al payments must be made properly If a payment is to be delayed due to Except as follows any reason prior notificstion should be provided at least 5 working days prior to scheduled payment date Save Delete 10 The fields shown on the screen are described below Mortgage New or Existing Type Regular or Collateral Administered Indicate whether or not the mortgage is administered by you or your agent Variable interest Explain if the interest rate is variable e g prime plus Terms and Enter details Conditions of Repayment Mortgage not Describe the conditions under which the renewable except mortgage can be renewed as follows SYNDi Loan Manager User Manual Page 323 Chapter 17 Loan Documents Tab 5 Prior Encumbrances 11 The tab is displayed as follows Prior Encumbrances JCORSS1 6 Prior Encumbrances Yes C No Priority A 4 2 3 C Other Details ee EE Face Amount 150 000 00 Amount Owing 45 000 00 In Default C Yes No Name of Mortgagee YD Trust 2211 Lancaster Road Toronto ON M23 1G8 Any Other Party LO O O Priority B C1 C2 C3 C Other None Details P Face Amount ooo Amount Owing In Default C Yes No Name of Mortgagee Any Other Party Save Delete 12 The fields shown on the screen are described below Prior Click Yes if any monies are owed to other Encumbrances parties otherwise click No Priority A Indicate the rank 1 2 3 or other De
86. alphanumeric characters user defined g Finder is used to display a list of all investors for the specified loan in the temporary billing data table ry Scroll is used display previous or next loan by T hitting up or down arrow New is used to clear the screen Principal Principal amount to be distributed to the investor Change it if necessary Interest Interest amount to be distributed to the investor Change it if necessary Miscellaneous Miscellaneous charges to be distributed to the Charge investor If you have to change any of the SYNDi Loan Manager User Manual Page 229 Chapter 10 Billing amounts switch to Misc Charge Tab and edit them Discharge Penalty If the loan is being discharge earlier than the normal maturity date The program calculates Discharge Penalty which is equal to the interest for the number of months specified in the Loans record Fee Fee Amount to be deducted from the interest N R Tax Non Resident Tax to be deducted from the interest Sales Tax Up to three fields set up in company profile displaying sales tax calculated on fee Save Click to save changes made to any of the amounts It is highlighted only when the user changes a field Close Click to close the screen 3 If you have changed an amount on the investor s side you must click Save before you click Borrower tab 4 When you switch to the borrower tab the error code disappears if the difference between the a
87. alty 893 75 gt 0 Pay Borrower gt 0 Receive from Borrower lt 0 Receive from Borrower Investor Total Principal 25 000 02 Interest 632 78 gt 0 Receive from Investor gt 0 Pay Investor lt 0 Pay Investor Close Notice that the interest and penalty fields are filled automatically The program has calculated the interest on the loan adjustment amount from the last billing date to the loan adjustment date It has also calculated penalty based on the number of months defined in the Loans table Change these values if necessary The principal amount as well as total interest interest plus penalty has to be distributed among the investors The principal and the total interest are distributed automatically to the investor in proportion to their contribution However the calculation may result in slight differences due to rounding errors especially if the number of investors is large Even larger differences may result if you process multiple loan adjustments during the same billing cycle In the above figure notice that the Investor Total Principal is 2 cents more than the loan adjustment amount Similarly the Total Investor Interest is one cent less than the total interest shown for the borrower These discrepancies are corrected on the Investors Tab Click Investors Tab to display the following screen SYNDi Loan Manager User Manual Page 216 Chapter 9 Loan Adjustments SYNDi Loan Adjustments S
88. ample Financial Company Menu Loan Adjustments Entry Initialize Distribute InvestorlD StartDate InvestorName BARBIL 06 10 2004 Bill Baroodwala 50 000 00 1 724 14 43 64 BINSEB 06 10 2004 Sebastian Bingor 100 000 00 3 448 28 87 28 GOLBAR 06 10 2004Barry Goldberg _ 175 000 00 6 034 48 152 74 HIGBAR 06 10 2004 Barry Hiqgert __ 50 000 00 1 724 14 43 64 JINJOH 06 10 2004 John Jingle 75 000 00 2 586 21 65 46 KNOBEN 06 10 2004 Ben Knowles 25 000 00 862 07 21 82 MCKBOB 06 10 2004 Bob McKenzie 25 000 00 862 07 21 82 NIMELY 06 10 2004 Ely Nimber 50 000 00 1 724 14 43 64 SAUDAN 06 10 2005 Daniel Saucers 50 000 00 1 72414 43 64 TABJAM 06 10 2004 James Tabemacle 25 000 00 862 07 21 82 TINBOB 06 10 2004 Bobby Tinker 50 000 00 1 724 14 43 64 WAT JAM 067 0 2004 James Watchman 50 000 00 1 724 14 43 64 Borrower Principal 25 000 00 Interest 632 79 Investors Principal 25 000 02 Interest 632 78 Add let Close 5 Adjust any of the principal amounts by clicking on the principal to highlight it and retyping the amount always with a minus sign Similarly adjust any of the interest amounts by clicking on the interest to highlight it and retyping the amount without minus sign You may also modify calculated fee withheld tax and sales tax by scrolling the grid to the left to display the field and retyping new amounts 6 You ma
89. anager form will be displayed Click on the down arrow on the icon to open a pop up menu and choose upper right center or lower right of the screen Opens the Setup menu and displays all items under it Opens the Transactions menu and displays all items under it Opens the Periodic Processing menu and displays all items under it Opens the Reports and Inquiries menu and displays all items under it Page 25 Chapter 3 Running the Application Classic Menu SYNDiLM Main Menu Sample Financial Company E O Setup Transaction Periodic Processing Reports and Inquiries Help Setup Loans and Properties Investor Receipts Misc Transactions Borrower Receipts Investor Payments Investor Transfers Periodic Processing Reports and Inquiries Pei he a ee ee ag Classic Menu displays each category of functions in a list form This is the original screen format of SYNDi Loan Manager and has been retained to maintain familiarity of existing users with the menu system If you are comfortable with this screen you can stay on it otherwise you can switch to Tree menu by clicking on the Tree Menu icon on the top right side of the screen If you decide to switch you will be on Tree menu next time when you log in The four menu items on top of the screen are same as discussed under the Tree menu The rest of this manual assumes that you are using Classic menu throughout your processing 2 The items included o
90. ange them if necessary SYNDi Loan Manager User Manual Page 86 Chapter 4 Setting up the Application 4 4 Users Setting up Users 1 You must be logged in either as ADMIN or as a user who is authorized to access this function Click Users on Setup screen to display the following screen SYNDi LMS Users Setup Sample Financial Company User ID mo ag hg Name John Smith Password Confirm Password r User Rights Copy profile of ia gt RightN Function Setup Company Proile Level Description Display Change Setup Borrowers Display Change Add De Setup Investors Display Change Add De Setup Deduction Codes Display Change Add Del Setup Other Parties Display Change Add Del Setup G L Accounts Display Change Add Del Setup Banks Display Change Add Del Setup Users Display Change Add Del Maintain Reminders Display Change Add Del Setup Loan Status Codes Display Change Add De Setup Optional Fields Display Create Delete Setup Loans Display Change Add De ete Close Loans Process Enter Deductions Display Change Add Del ete Loan Discharge Display Edit Generate Cancel Post 16 Loan Adjustments Display Change Add De ete Post ee ee ee ne ee es ete Post 17 Investor Receipts Display Change Add De
91. ank Deposits Print Posted Receipts Post Receipts Save Close 2 The functions shown on the screen are described below Print Unposted Receipts Generates a report showing unposted receipts from investors for selected loans You may choose to print Commitments Only in which case The program prints only the investor receipts for loans on which In Process flag has been set See Sample Report in Appendix A Print Bank Deposits Bank Deposits Report displays posted receipts and lists all checks to be deposited in the bank It must be printed after posting See Sample Report in Appendix A Print Posted Receipts Generates a report showing posted receipts from investors for selected loans and date range See Sample Report in Appendix A Post Receipts SYNDi Loan Manager User Manual Page 188 Chapter 6 Investor Receipts This function marks all unposted receipts excluding Commitments as posted Posted receipts cannot be modified or deleted The system displays the following message to confirm if transactions should be posted Confirm Posting A Do you really want to post If you have already printed unposted receipts click Yes to post transactions SYNDi Loan Manager User Manual Page 189 Chapter 7 Investor Transfers Chapter 7 Investor Transfers 7 1 Introduction This function is used only if you have indicated in the Company Profile that you maintain multiple investors During th
92. any BillingDate 10 31 2006 EH Loans From sd gd To 2222222222222222 a include matured loans Loan ID gt DAMPLA DOR1872 D0U2451_ 04 09 2006 05 03 2006 1 Month 04 09 20 Sinyae wr Period Matured _ Maturity Dat 0 06 04 10 2007 06 05 09 2006 1 Month 10 09 2007 IMAP2287 TEST2 _ 04 09 20 ene 1 Month 4 pano 04 09 2006 05 09 2006 1 Month 05 08 2007 WARPLAZ 09 30 2005 10 31 2005 1 Month oe 30 2008 04 09 2006 05 09 2006 1 Month 06 14 2008 Cancel 3 The fields shown on the screen are described below Billing Date Include Matured Loans Process Edit Report Post PEEL SYNDi Loan Manager User Manual Displays the earliest date on which loans selected for billing will be billed Can be changed if necessary Loans maturing in the current billing run should not normally be included in billing Instead they should be processed through Loan Discharge function which generates relevant documentation and runs special billing to recover the principal Click to collect the billing data in temporary area Click to modify the billing data collected in temporary area Click to generate the Pre Billing Report displaying billing data in temporary area Click to apply the billing data delete the temporary area and make the loans ready for Page 222 Chapter 10 Billing next month s billing Cancel Click to dele
93. as a percentage of interest paid to the investor Check if sales tax has to be calculated on the management fee Normally the fee collected from non resident investors is exempt from sales tax Enter the percentage of non resident tax to be deducted from foreign investors Tax is calculated as a percentage of interest paid to foreign investors after deducting management fee and sales tax Page 119 Chapter 4 Setting up the Application 17 18 19 20 The screen displays a table listing contributions from the investor to various loans The table contains one line for each loan showing Loan ID Loan Amount Start Date of contribution Fee percentage may vary from loan to loan principal paid to date interest paid to date fee deducted to date and whether or not the transaction has been posted These fields are for information only and cannot be modified If you have entered a Bank ID and Account Number for Electronic Funds Transfers it must be verified before it is used in a loan see Bank Account Verification Section 13 5 At any point if you change the Bank ID or the Account Number it must be verified again and so should all investments for that inverstor In order to view or modify the detail of a receipt click on the desired row in the table and hit lt Enter gt to display the Investor Receipt screen The numbers at the bottom of the screen show total contribution to date from the investor for all loans
94. as follows SYNDi LMS Loan Maintenance Sample Financial Company BEE Details Terms Notes Property Contacts Documents Opt Fields _ Existing or New Existing Previous Loan Date Save Delete Profile Amortization Investors Inquiry Close 42 The optional fields defined for loans are listed Just enter appropriate values for each field SYNDi Loan Manager User Manual Page 161 Chapter 5 Working with Loans 5 4 Manage Properties 1 The following screen is available only if you have specified in one or more templates that Loans are linked to Properties Section 5 2 Options Tab 2 It can be accessed by clicking Fly button next to Property ID on Property tab in Loan Maintenance screen or by choosing Properties on Loans and Properties menu Section 3 5 P Save Delete 2 The m SYNDILM Properties Setup Sample Financial Com roperty Details Property ID BAN 2365 Sal Outstanding Balance 450 000 00 Appraised Value 1 500 000 00 Loan To Value 30 Selling Price 0 00 Other Loans 200 000 00 Legal Description Banglore Avenue Vancouver BC 1A 1H2 Property Address i Banglore Avenue Yancouver BC 1A 1H2 City Prov State Vancouver BC via 1H2 Canada Type fi a Residential Category i g Single Unit iti S S Class 2 Qj NothYok fields shown on the screen are described below Property ID A code set up to identify the property g
95. ase refer to Section 12 3 otherwise ignore it SYNDi Loan Manager User Manual Page 243 Chapter 12 Borrower Receipts 12 2 Menu Tab 1 The tab is displayed as follows SYNDiLM Borrower Receipts Sample Financial Co COX Menu Receipts Entr Principal and Interest Misc Charges Unapplied Cash Deductions Ej Enter Receipts in Block Print Unposted Receipts Print Posted Receipts Post Receipts 2 The functions shown on the screen are described below Enter Receipts in Block This option displays all billed loans for which the borrower receipts have not been processed The user is provided the opportunity to flag all or some loans for which the receipt has to be processed The program processes these receipts in full and makes them available to be printed and posted See Section 12 10 Print Unposted Receipts Generates a report showing unposted receipts from borrowers for selected loans See Sample Report in Appendix A Print Bank Deposits Bank Deposits Report displays posted receipts and lists all checks to be deposited in the bank It must be printed after posting See Sample Report in Appendix A Print Posted Receipts SYNDi Loan Manager User Manual Page 244 Chapter 12 Borrower Receipts Generates a report showing posted receipts from borrowers for selected loans and date range See Sample Report in Appendix A Post Receipts This function marks all unposted receipts as p
96. ased on loan and Investor profiles e Payment frequency can be weekly bi weekly semi monthly monthly bi monthly quarterly semi annual or annual e Interest can be simple or compounded on daily weekly bi weekly semi monthly monthly bi monthly quarterly semi annual or annual basis e Calculation of Sales Tax and GST on management fee e Withholding of Non Resident Tax from interest payments to foreign investors e Calculation of NSF charges for returned borrower checks e Printing checks for investors e Ability to define unlimited number of optional fields in borrower investor and loan records to customize the program for individual requirements e Renegotiation of terms during the life of a loan e Provision for investors to withdraw and be replaced by new investors during the term of a loan e Generation of detailed or consolidated entries for General Ledger SYNDi Loan Manager User Manual Page 2 Chapter 1 Introduction e User friendly inquiry and data entry screens e Minimal training requirements e Intuitive data entry procedures e Built in reports and inquiries e Access to data by standard report writing tools such as Crystal Reports to generate customized reports Loan Processing Cycle Step 1 Approve and set up loan Step 2 Set up miscellaneous charges Step 3 Set up the investor group Step 4 Receive investor contributions enter receipts Step 5 Pay the borrower Step 6 Bill th
97. at do not exist in Accpac they are displayed as shown below This situation may arise if you have been using SYNDi as a standalone system and integrate it with an accounting package later SYNDi Loan Manager User Manual Page 287 Chapter 16 Loan Transfer 5 If this situation is encountered the non existent accounts should be defined in Accpac and this step be rerun until no more missing accounts are found SYNDi Loan Manager User Manual Page 288 Chapter 16 Loan Transfer SYNDiLM Sage Accpac Interface Sample E a 1 Download from Accpac This function downloads Chart of Accounts and Banks from Accpac The following G L Accounts were not found in Accpac Templates Misc Charges GlAccount Temp GlAccount MiseCholD gt 1040 gt 2600 PROPT BROKERAGE DISCHARGE LENDER MGMNT APPL NSF b Transfer to Accpac 6 SYNDi creates batches in Receipt batches in A R Payment batches in A P and Journal entries batches in G L modules of Accpac 7 Click Process to start transfer If one or more G L accounts are not found in the Chart of Accounts in the accounting system or if any of the entries are out of balance an error message is displayed and the transfer is cancelled otherwise The program displays the number of entries transferred and sets the Transferred flag so that there is no danger of them being transferred again SYNDi Loan Manager Us
98. at has stopped billing e g foreclosures loans in dispute etc Loans for which one or more investors receipts contain banking information The Bank ID and account numbers will be used for direct deposits of investor payments if you are using SYNDi EFT to transfer information to your bank It is important that one or more users be assigned the user right to verify bank account See Bank Account Verification Section 13 5 SYNDi LMS Billing Exceptions Sample Financial Company Pending Loan Discharge LoanID Description MaturityDate Principal Status gt DAMPLA Damascus Plaza 04 10 2007 800 000 00 Foreclosure MAP2287 2287 Maple Ave 05 08 2007 875 000 00 Active Billing Stopped Description 800 000 00 Foreclosure gt DAMPLA Damascus Plaza Pending Bank Verification S LoaniD Description 2251 Circle Square 12 31 2007 100 000 00 Active 265 Fancer Cr 06 08 2007 500 000 00 Active When you have reviewed the information click OK to close the screen If some action is required before running billing e g Loan Discharge or Bank Account Verification cancel the rest of billing run and take appropriate actions before rerunning billing SYNDi Loan Manager User Manual Page 221 Chapter 10 Billing 2 The following screen is displayed when the Billing Exceptions screen is closed SYNDi Billing Sample Financial Comp
99. atus A Adjustment Amount Principal 25 000 00 Borrower Total Principal 25 000 00 Interest 0 00 Investors Total Principal 0 00 Interest 0 00 Add Delete Close 2 Click Investors Tab to display the following screen SYNDi LMS Loan Adjustments Sample Financial Company BEE Investor ID e InvestorlD LIRefNo InvestorName Principal 3 You will now enter Investor IDs and the corresponding contributions Enter Investor ID or choose it from the Finder Hit lt Tab gt key to display the following screen SYNDi Loan Manager User Manual Page 212 Chapter 9 Loan Adjustments Investor ID Amount Interest Rate Fee Payment Type Amortize Over Payment Amount Description Lawyer ID Payment Cycle Term End Date SYNDiLM Loan Adjustment Detail Sample Financial Com Investor Receipt Investment Type Opt Fields Banor 70 000 00 G Fixed C Variable 12 0000 0 0000 Billing Frequency Monthly v C Blended C Interest only Compounding None 0 Calculation Method 12 Month Year v 0 00 Recalculate KHAN Khan Associates Barristors Monthy Investor s Bank 0870172013 70172013 Hl Transit Number oor 6 20715 Account No 001286027610 4 In the above screen the Fee Rate Lawyer ID Bank ID and Account Number come from the Investors table while the Interest Rate Payment Type Term and Compounding come from the Loans table Change the value if necessary
100. atus code associated with each loan When you set up a loan the status code should be 1 for Active When the loan is paid out its status code automatically becomes 0 for Paid Out You may define additional status codes e g 2 for Loans in Default 3 for Power of Sale etc If you pay commission to brokers or salespersons to bring investor accounts you may acquire SYNDiBroker module to calculate commission and make payments to Brokers If you processes loans with interest rates based on prime set up the rate whenever it changes The system maintains a table of historical records of Prime Rates SYNDiService is an add on product that runs as a Windows Service on some node in the network It monitors the database and performs certain predefined functions such as notifying users and sending e mails to borrowers about their accounts reminders about unpaid bills etc Set up name and address of borrowers Set up corporate and personal details fee rate non resident tax percentage and bank details of investors Page 30 Chapter 3 Running the Application Investment Types Reminders Other Parties Set up a user defined field to be used in Investors record and investor receipts Reminders are used to enter miscellaneous pieces of information A note could be flagged to hold billing for a loan starting the specified date so that it pops up to remind the user if certain loan parameters have to be changed before billi
101. aza Record Number 9977 Billing Date o2 717 2012 Cancel Date 0271772012 Hii Click a record to cancel Record Type BillinaDate Principal Interest 9975 4 30 2012 759 14 3 31 2012 759 95 i 874 90 2 29 2012 742 00 872 16 271772012 0 00 500 00 173172012 678 94 795 36 1273172011 679 74 j 795 36 1173072011 680 54 J 795 36 1073172011 681 33 795 36 9 30 2011 682 12 795 36 8 31 2011 682 91 795 36 7731 2011 683 68 i 795 36 6730 2011 684 46 795 36 5 31 2011 685 22 795 36 4 30 2011 685 98 i 795 36 2791 NN11 coc 7a 0 5 w w w gt w w Process 3 The fields shown on the screen are described below Loan ID Enter the Loan ID maximum 16 alphanumeric characters user defined Hit lt Tab gt to display all billing records in the descending order of billing dates g Finder is used to display a list of all loan records in the Billing Data table Record Number Displays the Record Number of the selected record Cancel Date Displays the effective date on which the latest billing will be cancelled The date must be between the billing date and the current date When a record is selected the cancel date is same as the billing date but you may change it if you want the cancellation to be effective SYNDi Loan Manager User Manual Page 285 Chapter 16 Loan Transfer another fiscal period Billing Date Displays the date f
102. be modified or deleted The system displays the following message to confirm if transactions should be posted Confirm Posting E Do you really want to post SYNDi Loan Manager User Manual Page 237 Chapter 11 Miscellaneous Transactions If you have already printed unposted transactions click Yes to post them SYNDi Loan Manager User Manual Page 238 Chapter 11 Miscellaneous Transactions 11 3 Transaction Entry Tab 1 The Transaction Entry tab is displayed as follows ms SYNDiLM Miscellaneous Transactions Sam le Fin MEE Menu Transaction Entry Transaction No Loan ID Date Document No Misc Charge Code Description GL ccount Amount Action Bank ID Save Delete jave1077 Avenue SteetPlaza 0570172012 g DateRange 473072012 to 5 31 2012 ize Received Management Fee ooo 43000 Management Fee Income 250 00 Balance 250 00 C Billed Billed and Received ice g Status Unposted 2 The fields shown on the screen are described below Transaction Number e Loan ID SYNDi Loan Manager User Manual A numeric code assigned by the system from the Next Payment Number in Company Profile table Whenever a new transaction is generated the Next Payment Number in Company Profile table is incremented by 1 To access an existing transaction enter Transaction Number and hit lt Tab gt Finder is used to display a list of transa
103. ber for the To Investor While entering a new transfer the system Page 193 Chapter 7 Investor Transfers Add Save Delete iig Close SYNDi Loan Manager User Manual retrieves the Account Number from the investor record The value can be changed if necessary Click to add a new record Click to save an existing record It is high lighted only when the user changes a field Click to delete an existing record Click to close the screen Page 194 Chapter 7 Investor Transfers 7 3 Terms Tab 1 The Terms tab is displayed as follows SYNDi LMS Investor Transfers Sample Financial Company BEE Menu Transfers Entry i 5 Opt Fields Term 60 months o days Interest Rate Fixed C Variable 93 5000 Payment Frequency Monthy gt Compounding None gt Calculation Method 12 Month Year Payment Type C Blended Interest only Amortize Over mi years Payment Amount O 000 Recalculate Add Close 2 The fields shown on the screen are described below Term The Term is same as specified in the Loans record Interest Rate Under normal circumstances the rate of interest will be same as specified for the investor from which the transfer is being made However you may change it if necessary Indicate whether the interest rate will be fixed or variable In case of fixed rate enter the percent interest rate In case of variable rate the interest w
104. by clicking Browse These transactions must be in a text file that use the Simply Accounting import format Remember you can only import transactions you would normally enter in the Miscellaneous Transactions window Enter the name of the import file C Program Files SYNDi SYNDIGLEntries t Click Navt ta rantina 14 If you are satisfied with the import delete or rename the input file SYNDiGLEntries txt SYNDi Loan Manager User Manual Page 291 Chapter 16 Loan Transfer SYNDi Loan Manager User Manual Page 292 Chapter 16 Loan Transfer QuickBooks Interface 15 If SYNDi Loan Manager is interfaced with QuickBooks there is no need to import the entries since SYNDi writes them directly into QuickBooks Just make sure that the company to which you want to transfer the journal entries is open in QuickBooks SYNDi Loan Manager User Manual Page 293 Chapter 16 Loan Transfer 15 4 Purge Old Data 1 Once a loan is paid out it still stays on the database along with all related records Eventually the database is cluttered with records that are not required anymore This will increase the storage requirements as well as deteriorate the performance of the program If this issue becomes your concern you may purge old records from time to time once a year or more frequently depending on the transaction volume 2 Click Purge Old Data on Periodic Processing Menu to display the following s
105. cance of each value The system stores the description but does not use it anywhere Use this validation type if the value has to be between a certain minimum and maximum You may enter any value as long as you do not leave the field blank Displays a table containing all fields already defined If you want to make changes to a field just click on it to copy it into the data entry area on the top of the screen Page 92 Chapter 4 Setting up the Application Optional Fields appear on records and listings in the order in which they appear in the Existing Fields area You may change this order by clicking Up or Down arrows Se Add Click to add a new record Save Click to save an existing record It is highlighted only when the user changes a field Delete Click to delete an existing record ine Close Click to close the screen 3 To set up a new Optional Field click New to clear the screen Enter the name of the field If the record is already present in the table the data is displayed and the fields could be modified Since field names are textual you may end up setting up multiple fields with slight differences in the spellings If you have made a spelling error delete the field and set it up again before assigning it to a table 4 You may hit lt Tab gt key to move from one field to the next Alternatively you may click inside a field and modify it 5 To modify an existing record select field from the
106. ceipt Number or use Finder to select a record If you use Finder to locate the receipt make sure to include posted receipts on the Finder screen The following screen is displayed SYNDiLM Borrower Receipts Sample Financial Co OK Menu E Hecsints Ente Principal and Interest Misc Charges Unapplied Cash Ref No 8632 AO Loan ID AVE1077 Q Avenue Street Plaza Borrower ID BLOJIM Jim Blouski Receipt Date Document No NSF Charge 0 00 Receipt Amount 795 36 M write off Amount to be appllied 0 00 Principal Interest Misc Charges On Account Receipts Total Amount Due Overpayment Status Posted PEN Delete Reverse 4 Click Reverse to display the following screen showing Check Return Date and NSF Charge if already set up in Client Profile SYNDi Loan Manager User Manual Page 258 Chapter 12 Borrower Receipts J Check Return Check Return Date 0770972004 H NSF Charge 150 00 OK Cancel Enter the Check Return Date if different from the date displayed on the screen The program displays the prompt to confirm if you are sure that you want to reverse this receipt Click Yes to proceed further If the Investor Payment has already been processed the following reminder is displayed Return Check You have already paid the investors Do you still want to reverse this receipt Click Yes to reverse the receipt The following prompt is displayed Return Check A D
107. cessary 2 Ifyou are using Microsoft Access a blank database will be created automatically by SYNDi However if you are using SQL Server database you will have to create it before getting into SYNDi Please see Section 3 14 On Login Menu click the Manage button next to Company Name Company EAEE aL 3 The following screen is displayed SYNDiLM Manage Companies Company Name Acme Financial Services Di Database Type C Microsoft Access Microsoft SQL Server Database Location c DatabasesAcme Browse SOL ServerName fINSTALL B256CBO Database Name jacme i _iti Ss s S SOSCSCS User ID Password Does this company have S YNDi Service Yes C No Company List gt Acme Financial Services ___ e Database Acme _ m Sample Financial Company SYNDiS ample Save Delete 4 The fields shown on the screen are described below Company Name Enter the name of the company to be set up maximum 60 characters New is used to clear the screen while setting up a new company Database Type SYNDi Loan Manager allows two database SYNDi Loan Manager User Manual Page 46 Chapter 3 Running the Application Database Location Server Name Database Name User ID Password Does the Company have SYNDi Loan Manager User Manual types i e Microsoft Access and Microsoft SQL Server If you decide to use the former you do not need to have Microsoft Access on your system
108. cessary and then click Add to add the record 9 To modify an existing record enter the Borrower ID or use Finder to select a record Enter various fields and click Save to save changes To delete a record click Delete You cannot delete a borrower record that has already been assigned to a loan SYNDi Loan Manager User Manual Page 104 Chapter 4 Setting up the Application Applicant Tab 2 10 The tab is displayed as follows SYNDi LMS Borrowers Setup Sample Financial Company Applicant 1 Payment Opt Fields First Name Jane LastName Blouski Company Name Address 1160 Birchmount Road City State PostCode Scarborough Ontario M1P 2B8 Country Canada Tel 416 751 0751 Fax 416 751 9289 St Delete Close 11 The fields shown on the screen are described below First Name Enter the first name of the co applicant if the Borrower Type is Personal maximum 29 alphanumeric characters Last Name Enter the last name of the co applicant if the Borrower Type is Personal maximum 29 alphanumeric characters Company Name Enter the company name if any maximum 60 alphanumeric characters Address Three address lines maximum 60 alpha numeric characters each City Name of the city maximum 30 alphanumeric characters State Prov State or province maximum 20 alphanumeric characters PostalCode Zip code or postal code maximum 10 SYNDi Loan Manager User Manual Pag
109. ck Edit on Billing screen to display the following screen containing two tabs described below SYNDi Edit Billing Data Sample Financial Company Borrower Investors Misc Charaes Borrower Displays principal and interest calculation for the borrower Investors Displays principal interest fee sales tax and non resident tax for investors Misc Charges Displays miscellaneous charges to be billed by borrowers and to be paid by investors in the billing run 2 You may access the tabs by clicking on the tab header SYNDi Loan Manager User Manual Page 226 Chapter 10 Billing 10 4 Borrower Tab The Borrower tab is displayed as follows SYNDi Edit Billing Data Sample Financial Company Borrower Investors Misc Charges Loan ID Borrower Amount Loaned Amount Owed Interest Rate Period Principal Interest Miscellaneous Charges Discharge Penalty Balance 11 3750 This Billing Date 2 09 21 Borrower bw fe Ee Damascus Plaza Queen s Prace 0 00 Start Date 04711 2005 Last Billing Date 01709 2007 Next Billing Date fat Investors f 0 00 1 868 66 7 583 33 7 583 36 934 32 s00 000 00 ooo 0 00 Error Codes ea Close 2 The fields shown on the screen are described below Loan ID g E Principal Interest SYNDi Loan Manager User Manual Enter the Loan ID maximum 16 alphanumeric characters user defi
110. creen Loans C Borrowers Investors SelectAll De selectAll Maturity Date Cutoff ee LoaniD Description StanDate MaturityDate l Principal Process JAVE1O7 107 Avenue Street Plaza 09 28 2004 09 27 2008 100 000 00 Yes _ BAN2365 2365 Banglore Ave 06 14 2005 06 13 2007 1 050 000 00 Yes _ BIR1160 1160 Birchmount Road 6 10 2004 06 09 2007 725 000 00 _ _ CIR2251 2251 Circle Square 01 01 2007 12 31 2007 100 000 00 Yes DAMPLA Damascus Plaza 04 11 2005 04 10 2007 800 000 00 DOR1872 1872 Dorian Blvd 10 10 2004 10 09 2007 1 400 000 00 Yes DoU2451 2451 Doubay Road 05 31 2005 05 30 2007 2 000 000 00Yes FAN265 265 Fancer Cr 06 10 2004 06 08 2007 500 000 00 Yes gt GOM556 556 Gomart Court 02 28 2005 02 27 2009 1 000 000 00 MAP2287 2287 Maple Ave 05 09 2004 05 08 2007 875 000 00 Yes MIDKEN Midland Kennedy Plaza 09 01 2006 08 31 2007 1 250 000 00 VYes IPARK2781 2781 Park Road 08 31 2004 08 30 2008 350 000 00 Yes WARPLAZ Warsak Plaza 06 15 2004 06 14 2008 1 000 000 00 Ves Total Records 13 Total Selected a Process Close 3 The fields shown on the screen are described below Loans Borrowers Investors Maturity Date Cut off Select All Deselect All SYNDi Loan Manager User Manual Select whether you want to purge loans that have been paid out or borrowers or investors that are not linked to any loan Displays the date one year
111. creen is displayed 5 Change the Name and Address if necessary 6 The table shows all posted payments for which no checks were generated Choose the records that are being included in the check by double clicking under the Action column to change No to Yes SYNDi Loan Manager User Manual Page 280 Chapter 14 Generating Checks 7 The Description field in the table shows the default description set in Company Profile You may change the description for individual records by clicking inside the table and retyping the new description 8 Click Add to write the check record Notice that the Record Number on top of the screen changes from NEW You may access the check record later for deletion or modification by using the Record Number 9 After all checks have been entered click on Menu tab print unposted checks and delete or change any records if necessary Then mount check forms on the printer and make sure that the Next Check Number in the Bank record is identical to the first check on the printer Print checks and then print the Check Register as necessary 10 All checks printed in a check run with the exception of manual checks are saved in a Microsoft Word file Check Run Bank xxxx yyyyy Starting Check nnnn doc xxxx yyyyy is the Bank ID and nnnn is the starting check number in SYNDi Documents folder and can be reprinted any time The next page shows a typical check produced by The program SYNDi Loan Mana
112. ctions in the Miscellaneous Transactions table New is used to clear the screen while setting up a new record Enter the Loan ID maximum 16 alphanumeric characters user defined or select it using the Finder button next to Loan ID The Loan ID is optional and can be left blank if the transaction is meant to be applied to any Page 239 Chapter 11 Miscellaneous Transactions Date Document No Misc Charge Code Description G L Account Amount Action Bank ID Add Save __DBetete_ Delete SYNDi Loan Manager User Manual loan belonging to the specified borrower Enter the date of transaction Enter a reference number e g voucher number Enter the Miscellaneous Charge Code defining the G L account to which the transaction will be debited The Code should be defined as described in Section 4 6 with 100 as Borrower Percentage 0 as Investor Percentage and zero as the amount Description of the transaction maximum 60 alphanumeric characters user defined The system displays the G L account number associated with the specified Miscellaneous Charge Code Enter the transaction amount Billed This action can be selected only if you want to create a billing record debiting Borrower Receivable and crediting the G L account defined by the specified Miscellaneous Charge Code normally an income account Billed and Received This action is selected when you want the system to generate
113. d It is recommended that the first six characters of Investor ID be unique Finder is used to display a list of all records in the Investors table Scroll is used display previous or next record by hitting up or down arrow New is used to clear the screen while setting up a new record Enter the first name of the investor if the investor is an individual Personal maximum 29 alphanumeric characters Enter the last name of the investor if the investor is an individual Personal maximum 29 alphanumeric characters Page 111 Chapter 4 Setting up the Application Name Address Individual Corporate Buttons co City State Prov PostalCode Country Tel Fax E Mail Contact Soc Ins No SYNDi Loan Manager User Manual Enter the company name of the investor if the investor is a business Corporate maximum 60 alphanumeric characters If the investor is an individual then his first amp last names becomes the Name Three address lines maximum 60 alpha numeric characters each These options buttons are used to select if the investor is an individual or it is a corporation Click to copy the address telephone number Fax Number and E Mail address from another investor Name of the city maximum 30 alphanumeric characters State or province maximum 20 alphanumeric characters Zip code or postal code maximum 10 alphanumeric characters Country Name maximum 20 alphanumeric char
114. d the balance is zeroed Expected Repayment Date When a loan is set up the Expected Repayment Date is set to be the same as the Maturity Date Occasionally it may have to be modified if the borrower has decided to extend the loan or pay it off earlier The Expected Repayment Date is used to generate Loans Due for Repayment Report for cash flow and marketing purposes You may print this report show investors whose contributions are going to mature within certain number of days and approach them to invest in forthcoming loans The next billing date is calculated on the basis of start date payment frequency and Billing Day As billing is run it updates last and next billing dates automatically The last billing date is blank if no billing has been run yet for a loan that has been just set up otherwise it displays the date on which billing was run the last time The administration of a Loan is normally a three step process a Run Billing b Enter Borrower Receipts and c Enter Investor Payments If you are responsible just for closing the loan and do not get involved in receiving payments from the borrower and distributing them to investors you may check Page 153 Chapter 5 Working with Loans the loan as Self Administered in which case the program flags it to be processed automatically in step b Calculate interest If you have indicated in Company Profile on unpaid balance Setup Section 4 3 that you calcula
115. d to implied warranties or conditions of merchantable quality or fitness for a particular purpose and those arising by statute or otherwise in law or from a course of dealing or usage of trade e All expenses incurred are chargeable to the Customer including travel delivery and courier fees long distance tolls time and travel expense for customer site visits media charges administrative fees telephone and modem communications charges etc e Each party acknowledges that it has read and understands these Terms and Conditions and agrees to be bound by them and further agrees that it is the complete and exclusive statement of Terms and Conditions between the parties which supersedes all prior proposals understandings and all other agreements oral and written between the parties e INDUS agrees to keep all Customer data and information strictly confidential In the event the Customer fails or neglects to make any payment for the Licensed Program when due INDUS may within 60 days after written notice at its option and in addition to any other right which it has under this Agreement or at law delay delivery of any materials or the performance of any services under this or any other agreement with the Customer until such payment is made Software License and User Agreement 2 Limitation of Liability Under no circumstances shall INDUS be liable to You or to any other person or entity for any indirect special incidental or consequent
116. date of the loan principal term interest type interest rate and the mode in which interest has to be compounded Displays various controls to establish payment terms for the loan Enter any remarks and up to three detailed notes including reference check collateral and relevant information If you have indicated in Company Profile Section 4 3 that loans are linked to real estate properties this Tab displays the details of the property to which the loan is linked SYNDi allows the user to define up to four co borrowers and four guarantors for each loan Any descriptive and quantitative information SYNDi LMS Loan Maintenance Sample Financial Company BEE Details Terms Notes Property Contacts Documents Opt Fields Documents Opt Fields about the contacts can be entered on the Notes tab You can save all documentation related to a loan in Documents Catalog All documents in the Catalog are displayed in Documents tab and can be opened by double clicking a document Enter the optional fields defined for loans You may access various tabs by clicking on the tab header The fields on each tab are described below SYNDi Loan Manager User Manual Page 144 Chapter 5 Working with Loans Details Tab 4 The tab is displayed as follows SYNDiLM Loans Sample Financial Company _ 5 x Details Terms Notes Property Contacts Documents Opt Fields Loan ID aveo Ao Temp
117. dditional principal advanced to the borrower or lump sum principal payments received from the borrower Chapter 9 Click to discharge the loan on or before maturity date Section 5 8 Page 147 Chapter 5 Working with Loans LoanDocs This function may be used to prepare and e mail various loan originating documents to investors at the time of setting up a loan It is available if you have specified in Company Profile that you maintain Multiple Investors See Chapter 17 i Click to add a new record Save Click to save an existing record It is highlighted only when the user changes a field Add __Save_ Delete Click to delete an existing record Profile Click to print the loan profile Amortization Click to print the Amortization Table for the loan Inquiry Displays a list of borrower receipts Close Click to close the screen 6 To set up a new loan click New to clear the screen Enter Loan ID If the record is already present in the table the data is displayed and various fields could be modified 7 You may hit lt Tab gt key to move from one field to the next Alternatively you may click inside a field and modify it 8 If you do not click the New button while entering a new record the data from the previous record remains on the screen You may change any fields if necessary and then click Add to add the record 9 To modify an existing record enter the Loan ID or use Finder to select a r
118. delete a record that has already been posted SYNDi Loan Manager User Manual Page 205 Chapter 8 Borrower Payments 8 3 Menu Tab ie The tab is displayed as follows SYNDi LMS Borrower Payments Sample Financial Company BEE Payments Entry ie Print Posted Payments Eh Print Uposted Payments n Post Payments Close The functions shown on the screen are described below Print Unposted Payments Generates a report showing unposted payments to borrowers for selected loans and date range See Sample Report in Appendix A Print Posted Payments Generates a report showing posted payments to borrowers for selected loans and date range See Sample Report in Appendix A Post Payments This function marks all unposted payments as posted Posted payments cannot be modified or deleted The system displays the following message to confirm if transactions should be posted SYNDi Loan Manager User Manual Page 206 Chapter 8 Borrower Payments Confirm Posting A Do you really want to post If you have already printed unposted payments click Yes to post transactions SYNDi Loan Manager User Manual Page 207 Chapter 9 Loan Adjustments Chapter 9 Loan Adjustments 9 1 Introduction Loan Adjustments screen is accessed by clicking the Adjustments button on the Loan Maintenance screen Loan Adjustments are entered under the following conditions a T
119. ding None 0 0000 Calculation Method 12 Month Year Monthly gt orvor7e01s iif 2 The fields shown on the screen are described below Term Interest Rate Payment Type SYNDi Loan Manager User Manual The loan term is same as in the Loan record Under normal circumstances the rate of interest will be same as that specified for the loan However in cases where you are discounting the loan and paying lower interest to the investor you may reduce it Indicate whether the interest rate will be fixed or variable In case of fixed rate enter the percent interest rate In case of variable rate the interest will be calculated as the specified number above or below the prime rate on or immediately before the start date of the loan or the last billing date As the prime rate is modified over the life of the loan the interest will change when monthly installment is calculated Choose Blended or Interest Only The default payment type is taken from the Loan record but Page 182 Chapter 6 Investor Receipts Payment Frequency Compounding Calculation Method Amortize Over Payment Amount Fee Payment Cycle SYNDi Loan Manager User Manual could be changed if necessary Payment Frequency is same as in the Loan record Compounding Frequency is same as in the Loan record Calculation Method is same as in the Loan record In case of Blended paymen
120. ding on the version of Microsoft Excel Click on Loan Documents in Loan and Properties Maintenance Menu Section 5 3 and follow the procedures described in the following pages SYNDi Loan Manager User Manual Page 315 Chapter 17 Loan Documents 17 3 Entering Data 1 Click LoanDocs button on the Loans screen 2 The Loan Documents screen contains 12 tabs such that each tab contains groups of fields to define the details of Loan Documents SYNDi Loan Manager User Manual Page 316 Chapter 17 Loan Documents Tab 1 Loan Documents Menu 3 The tab is displayed as follows SYNDiLM Loan Documents Sample Financial Ce x LoanID COR5516 5516 Corvette Crescent Gl Statement of Mortgage Investor Documents 5 5 2011 Yes 6 30 2011 Yes Sh Apply Loan Advance 1 31 2012 Yes Save Delete 37157201 97217201 Yes 4 The fields shown on the screen are described below Loan ID g Statement of Mortgage Investor Documents Apply Loan Advance Add Save SYNDi Loan Manager User Manual Enter the Loan ID for which you are generating Loan Documents Finder is used to display a list of all records in the Loans table Click it to generate Statement of Mortgage Click it to generate Investor Disclosure Investor Acknowledgement and Administration Agreement for each investor in the loan Click to apply the first and subsequent loan advances C
121. distribute interest to investors after each borrower receipt However if the funding comes exclusively from you as the investor or from a MIC Mortgage Investment Corporation leave it unchecked in which case SYNDi ignores all references to investors and streamlines the workflow Check if you are using eS YNDi to enable borrowers and investor to perform inquiries of their records over Internet in which case the Page 74 Chapter 4 Setting up the Application Use Last Name first for Borrowers Enforce Security Variable Interest Rates based on Do you use Brokers BankID Account Payments Next SYNDi Loan Manager User Manual program allows you to set up user IDs and passwords during borrower and investor set up in order to log into the website For new borrowers and investors the UserID is same as the borrower or investor ID and the password is password If a borrower is an individual and you set up first name as Ted and last name as Smith the full name will be displayed as Smith Ted if the checkbox is checked otherwise it will be displayed as Ted Smith Check if you want to track users entering and posting Borrower Receipts If this option is enabled then SYNDi starts the processing of transactions in batches Each user will have a Batch Number associated with all their transactions for that particular day With this implementation it is easier for the supervisor or admin to
122. e Normal Balance Add Save Delete rn Close A code set up to identify a General Ledger account maximum 45 alphanumeric characters user defined Finder is used to display a list of all accounts in the G L Accounts table Scroll is used display previous or next account number by hitting up or down arrow New is used to clear the screen while setting up a new account number Account description maximum 60 alphanumeric characters Account Type can be Asset Liability Equity Revenue or Expense An equity type account could be flagged as Retained Earning Normal Balance can be debit or credit Assets and Expenses are normally of Debit type while Liabilities Equity and Revenues are normally of Credit type Click to add a new record Click to save an existing record It is highlighted only when the user changes a field Click to delete an existing record Click to close the screen 4 To set up anew G L Account click New to clear the screen Enter the account number If the account number is already present in the table the data is displayed and the Description could be modified SYNDi Loan Manager User Manual Page 65 Chapter 4 Setting up the Application 5 If you do not click the New button while entering a new record the data from the previous record remains on the screen You may change any fields if necessary and then click Add to add the record 6 To modify an existing record ent
123. e loan Amortization Period for blended payments Compounding frequency defined in Loans table Page 319 Chapter 17 Loan Documents Rate Rank Payments Payment Amount Agent License No First Payment Date Last Payment Date Maturity Date SYNDi Loan Manager User Manual Annual rate of interest Defined in Loans table Specifies whether it is interest only loan or interest plus principal Calculated amount of payment License Number of mortgage agent specified in the Remarks field of the Agent record Calculated from the start date and payment frequency of the loan Normally same as the maturity date Calculated from Start Date and the Term Page 320 Chapter 17 Loan Documents Tab 3 Property Security 7 The tab is displayed as follows SYNDiLM Loan Documents Sample Financial Cons M d Property 7 Security C0R5516 Type of property 1 Residential Number of Units 1 Details Oe Appraisal Done Yes C No Date of Appraisal 0372972011 H Appraiser ID B0xw00D a Boxwood Property Appraisers Ltd Property Value 1 200 000 f appraisal has been done please enter Appraised Value otherwie enter Projected Value Zoning Appropriate Yes C No Details Zoning Residential Annual Taxes 7 500 00 Arrears 0 00 Save Delete 8 The fields shown on the screen are described below Type of Property Property Type specified in the Property record of th
124. e 105 Chapier 4 Setting up the Application alphanumeric characters Country Country Name maximum 20 alphanumeric characters Tel Telephone number maximum 20 alphanumeric characters Fax Fax number maximum 20 alphanumeric characters SYNDi Loan Manager User Manual Page 106 Chapter 4 Setting up the Application Payment Tab 12 The tab is displayed as follows SYNDiLM Borrowers Setup Sample Financial Ce SYNDILM Borrowers Setup Sample Financial Company Applicant 1 Applicant 2 T7 Payment Mode Cheque Preauthorized Payments Borrower s Bank Transit Number oor 2 27601 Account No 0028701 59 Save Delete Close 13 The fields shown on the screen are described below Payment Mode Select whether the borrower receipts will come through a check or preauthorized payment directly from the borrower s bank account If you are using SYNDiEFT for Electronic Funds Transfer you an set up borrower for preauthorized payments PAP to receive monthly payments Transit Number If monthly receipts will come through preauthorized payments enter the Transit Number for borrower s bank The Transit Number consists of a 4 digit Inistution Number of the bank followed by a hyphen followed by a 5 digit Branch Number If the Institution Number is less than 4 digits add zeroes on the left For instance if the Institution Number is 012 and the Branch Number is 27601 the Tran
125. e Loan Adjustments Entry tab is displayed as follows SYNDi LMS Loan Adjustments Sample Financial Company BEE Menu Loan Adjustments Entry Investors Adjustment Number NEW Eo Loan ID BIR1160 e 1160 Birchmount Road Date 03 16 2007 pa Date Range 03 10 2007 to 04 09 2007 Document No 21753 Paid to Khan Associates Barristers Rate 9 5000 Balance Penalty 3 months Status Adjustment Amount Principal 0 00 Interest 0 00 Penalty 0 00 Borrower Total Principal 0 00 Interest 0 00 Investors Total Principal 0 00 Interest 0 00 Close 2 The fields shown on the screen are described below g Loan ID a Date Document No SYNDi Loan Manager User Manual View Adjustments Click to display the unprocessed adjustments for the specified loan Enter the Loan ID maximum 16 alphanumeric characters user defined Finder is used to display a list of all records in the Loans table New is used to clear the screen and enter a new Loan Adjustment Enter the date of adjustment The date must be later then the last billing date and prior to the next billing date The billing dates are displayed on the screen for reference Displays the Document Number of the original Borrower Payment Page 209 Chapter 9 Loan Adjustments Paid To Balance Adjustment Amount Principal Adjustment Amount Interest Adjustment Amount Penalty Investor Total Add Save Delete Close iig SYNDi Loan Manager U
126. e Type You may generate checks for investors borrowers financial institutions holding RRSP accounts for individual investors and to tax agencies to remit property taxes collected from borrowers OK Click to proceed further Cancel Click to close the screen and return to Periodic Processing screen 4 Clicking OK in the above screen displays the following menu containing the tabs described below SYNDi Loan Manager User Manual Page 277 Chapter 14 Generating Checks SYNDi LMS Generate Checks Sample Financial Company 2 x Menu Checks Enty Menu Print various listings print and post checks Checks Entry Enter payments individually 5 You may access various tabs by clicking on the tab header SYNDi Loan Manager User Manual Page 278 Chapter 14 Generating Checks 14 2 Menu Tab 3 The tab is displayed as follows SYNDi LMS Generate Checks Sample Financial Company 2 x Print Unposted Checks Print Check Register Print Post Checks The functions shown on the screen are described below Print Unposted Checks Generates a report displaying all unposted checks Print Check Register Prints Check Register for a specified bank in a given range of check numbers and check dates Print Post Checks Assigns check numbers posts checks and prints them SYNDi Loan Manager User Manual Page 279 Chapter 14 Generating Checks 14 3 Checks Entry Tab 1 Enter the Ch
127. e an existing record It is highlighted only when the user changes a field Page 68 Chapter 4 Setting up the Application Delete Click to delete an existing record Close Click to close the screen 4 To set up anew bank click New to clear the screen Enter Bank ID If the record is already present in the table the data is displayed and The fields could be modified 5 You may hit lt Tab gt key to move from one field to the next Alternatively you may click inside a field and modify it 6 If you do not click the New button while entering a new record the data from the previous record remains on the screen You may change any fields if necessary and then click Add to add the record 7 To modify an existing record enter the Bank ID or use Finder to select a record Enter the fields and click Save to save changes 8 To delete a record click Delete You cannot delete a bank record that has already been assigned to an investor or is present in the Transactions table 9 While entering a new bank record if you have already entered other bank records with the same Bank Number the system displays the name of the bank with the same Bank Number but the lowest Branch Number It is assumed that all banks with the same value of the first three characters will have the same name with different branch addresses 10 If you change the name of a bank while adding a new bank record or modifying an existing record the followin
128. e and you will have to print checks before posting the batch If you do not wish to print checks in Accpac leave the checkbox unchecked and SYNDi will generate a check number when tranferring entries to Accpac 13 Once the fields have been entered click Check button to allow the program to open the Accounting database The system displays proper message to confirm whether or not it was able to open the accounting package successfully If the attempt was unsuccessful leave it at Standalone for the time being and investigate the problem after saving the changes The details are given later in this section 14 When SYNDi Loan Manager is set up initially as a standalone system it defines a G L account number 9999 in Accounts Table and plugs it all the account number fields in Company Profile Later on you may have changed these account numbers However when you interface the program with an accounting system it stops using the Accounts Table and uses the Chart of Accounts in the accounting system If any of the accounts defined in the program do not exist in the accounting system it will start generating accounting entries for non existent accounts It is therefore suggested that you go through each account in the Company Profile as well as in Miscellaneous Charge Codes and Miscellaneous Charges to make sure that they have been defined properly in the accounting package 15 When the interface is changed from Standalone to an accounting package
129. e borrower on monthly basis Step 7 Receive monthly installment from the borrower Step 8 Pay monthly installment less deductions to investors SYNDi Loan Manager User Manual Page 3 Chapter 1 Introduction 1 2 Interest Calculation 1 The first payment is calculated from the Start Date of the loan exclusive or inclusive depending on whether or not you are excluding start date from calculation to the next billing date inclusive and may not cover the entire month For instance if the loan is set up as of March 20 and the payment date is the 9 of each month in case of monthly payment frequency the next billing date will be April 9 and the interest for the first installment is calculated from March 20 inclusive to April 9 inclusive i e 21 days You can specify in the company profile if the date on which the Loan is funded should be excluded from interest calculation Subsequent payments are calculated on the basis of full month from one day after the last billing date inclusive to next billing date inclusive Thus the second billing will be run from April 10 to May 9 2 Ifthe maturity date falls before the next billing date the last payment will be calculated for part of the month from one day after the last billing date to the maturity date Thus if the term of the loan described above is one year the maturity date will be February 19 Once the billing has been run for February 9 the normal billing date the system s
130. e grid to the left to expose the Date Error column 6 When all desired transactions have been selected click Process to generate borrower receipts Print unposted receipts to review them and then post them SYNDi Loan Manager User Manual Page 263 Chapter 13 Investor Payment Chapter 13 Investor Payments 13 1 Introduction 1 This function is used only if you have indicated in the Company Profile that you maintain multiple investors 2 Once you have entered the monthly receipts from borrowers and posted them you should run Investor Payments to distribute the interest and any principal to investors 3 Click Investor Payments on Main Menu to display the following screen containing the tabs described below SYNDi LMS Investor Payments Sample Financial Company Menu Payments Entry Investors Misc Charaes Menu Enter Investor Payments in Block Print various listings and post payments Payments Entry Enter investor payments and write offs individually Investors Displays the list of investors during individual payment entry Misc Charges Displays the list of miscellaneous charges during individual payment entry 4 You may access various tabs by clicking on the tab header SYNDi Loan Manager User Manual Page 264 Chapter 13 Investor Payment 13 2 Menu Tab 1 The tab is displayed as follows SYNDi LMS Investor Payments Sample Financial Company BEE Menu Paym
131. e life of a loan an investor may withdraw either part or whole balance of his contribution In this case it is necessary that another investor who may or may not be part of the syndicate joins the group The amount contributed by the new investor must be equal to the amount withdrawn This transaction is covered under Investor Transfers When all transfers have been entered they should be posted in order to be considered part of billing The Investor Transfers screen is displayed when the user clicks Investor Transfers on Main Menu Hit lt Tab gt through various fields and change them if necessary Click Investor Transfers on Main Menu to display the following screen containing four tabs described below SYNDi LMS Investor Transfers Sample Financial Company Menu Transfers Entry Terms Opt Fields Transfer Entry Enter investor transfers Terms Establishes interest rate and related parameters Opt Fields Allows the user to enter optional fields related to investor receipts Menu Print a listing of unposted transfers and post transfers You may access various tabs by clicking on the tab header SYNDi Loan Manager User Manual Page 190 Chapter 7 Investor Transfers 7 2 Transfers Entry Tab 1 The Transfers Entry tab is displayed as follows SYNDiLM Investor Transfers Sample Financial Con ISa Ed Menu Transfers Entry Terms Opt Fields Reference No New QL Receipt mz Loan ID jeinti60
132. e loan Enter the document number and save the record The loan is now ready to be billed 2 Applying subsequent advances Every time a loan advance date approaches go to Tab 1 and click Apply Loan Advance It generates a Loan Adjustment and posts it Each advance increases the principal of the loan by the total amount advanced SYNDi Loan Manager User Manual Page 336
133. e loan 1 Residential 2 Commercial 3 Industrial 4 Land 5 9 Other Number of Units Number of residential units apartments suites etc specified in the Property record of the loan If the property is residential the number of units should be at least 1 Details There are two lines of description available for properties other than residential commercial or industrial Appraisal Done Answer Yes or No Date of Appraisal If appraisal has been done enter the date here Appraiser ID If appraisal has been done identify the appraiser defined in Other Parties Property Value If appraisal has been done enter the appraised SYNDi Loan Manager User Manual Page 321 Chapter 17 Loan Documents value otherwise enster the projected value Zoning Enter Yes or No Appropriate Details Describe zoning details whether or not zoning has been done Annual Taxes Enter annual tax amount Arrears Enter the amount if taxes are in arrears SYNDi Loan Manager User Manual Page 322 Chapter 17 Loan Documents Tab 4 Mortgage Particulars 9 The tab is displayed as follows Mortgage Particulars JCORSS1 6 Mortgage New Type Regular Administered Yes C Existing C Collateral C No Variable Interest Explain Terms and Conditions of This loan is open for full repayment on any payment date on or after Repayment October 5 2011 on payment of 2 months interest as bonis Mortgage not Renewable J
134. e number of months for which interest will be calculated as penalty in case of discharging the loan before the maturity date Depending on how frequently the borrower pays you may select one of the following options Term Daily Weekly Bi weekly Semi monthly Monthly Bi monthly Quarterly Semi Annual Annual SOMNIDNARWNE Depending on the number of times in a year the interest is compounded you may select one of the following options None Daily Weekly Bi weekly Semi monthly Monthly NMNBWN FR Page 151 Chapter 5 Working with Loans Calculation Method Amortize Over Payment Amount Recalculate SYNDi Loan Manager User Manual 7 Bi monthly 8 Quarterly 9 Semi Annual 10 Annual There are four options available 1 360 Day Year in which each year consists of 360 days and is divided into 12 equal months with 30 days in each month 2 365 Day Year in which each year consists of 365 days with no interest calculated on February 29 of a leap year 3 Exact Year in which each normal year consists of 365 days while a leap year consists of 366 days 4 12 Month Year in which each year consists of 365 days and is divided into 12 equal months with 30 416667 days in each month 5 Sum of Digits Rule of 78 According to the Rule of 78 interest is calculated for the life of the loan and then allocated to each month by proportion using reverse sum of
135. e to enter certain information and give your XML filename The details are described later in this chapter 13 After the T5 data has been uploaded or printed select the investors whom you are e maling the slips and click Email Errors during T5 processing There may be times when you have missing or incorrect information in the database For instance you may have left the province code blank in the investor record SYNDi looks for critical information that is mandatory for the T5 slip generation If errors are encountered it generates list of errors on the screen which you can print No further processing is done if errors are found You should correct all errors before rerunning T5 Slips Following is the list of errors Company related Errors 101 102 103 104 Your Business Account Number in Company Profile must have 15 characters Your Business Account Number in Company Profile is invalid Company Address Linel cannot be blank Company City cannot be blank SYNDi Loan Manager User Manual Page 300 Chapter 16 Loan Transfer 105 Company Province is invalid It must have two character abbreviation for your province in capital letters 106 Company Postal Code is invalid it should have the form NON 9N9 107 Company Contact Name cannot be blank 108 Company Email address cannot be blank 109 Company Phone Number cannot be blank These errors can be corrected by modifying Company Profile Investor related E
136. e used as necessary A user defined memo field 14 Itis mandatory to enter either Business Identification Number or the Social Insurance Number to process income tax information SYNDi Loan Manager User Manual Page 116 Chapter 4 Setting up the Application Payment Tab 15 The tab is displayed as follows Payment Mode C Cheque Direct Deposit pia Fee Rate 0 00 Taxable renee Horie joo 6 20715 Non Resident Tax 0 00 Account Number 001286027610 Default Investment Type a g Mue i s S r Registered Investments PlanType RRSP J Registered Retirement Saving Plan _ PlanNumber ABC123456 TrusteelD m g MDTut i 3O Default Payment Cycle Monthly S toanlD Borowerame TransDate Maturity Reference _ Loaned gt Jim Blouski 1 1 2010 1 1 20151 Dataflow Systems 4715 201 1 1 5 2015 14 Dataflow Sustems 23022011 1 5 2118 Save Delete Loan List 16 The fields shown on the screen are described below Payment Mode Select whether the payment will be made through a check or deposited directly in the investor s bank account If you are using SYNDiEFT for Electronic Funds Transfer you an set up an investor for direct deposit DD to transfer monthly payments to investor s bank account Transit Number If monthly payments will be made through direct deposit enter the Transit Number for investor s bank The Tra
137. eck Date if different from the date displayed on the screen 2 Ifa check has already been written manually and you are entering it here just to record it click Manual Check and enter the Check Number If Manual Check is not clicked it still show the check number as 0 and will be assigned at the time of posting the check 3 You may use this routine to write checks for borrowers investors trust companies holding RSP accounts for investors and also to tax agencies to remit property tax collected from borrowers The Payee Type should be selected accordingly SYNDi LMS Generate Checks Sample Financial Company BEE Menu Checks Entry RecodNo NEW JL Bank ID 0260 01082 Payee Type lInvestor CS Next Check 2187 PayeeID BARBIL a Manual Check T Name Bin Baroodwala Check Number o0 Address 1160 BirchmountRoad t C Check date 12 20 2007 Bi Po Check Amount 0 00 Scarborough Ontario M1P2B8 Status Unposted _ ubRefNo TransDate LoanlD PaidT oName Amount Descriptig 8407 8824 12 18 2007 BIR1160 Bill Baroodwala 486 30 Payment 4 8427 892512 18 2007 GOM556 Bill Baroodwala 388 38 Payment 4 8428 8944112718 2007 MAP2287 Bill Baroodwala 353 38 Payment i 4 Enter Payee ID which will be Borrower ID Investor ID Bank ID for RSP accounts or government tax agency to which property tax is being remitted depending on the Payee Type Alternatively select it using Finder The following s
138. ecord Enter various fields and click Save to save changes 10 The Start Date of a loan cannot be changed after the loan has been funded and the In Process flag has been removed 11 To delete a record click Delete You cannot delete a loan record that has already been billed or the loan amount has been advanced to the borrower SYNDi Loan Manager User Manual Page 148 Chapter 5 Working with Loans 12 Once you have initiated the billing process you cannot modify a loan until billing has been posted 13 To print Loan Profile showing investor contributions see Sample Report in Appendix A click Print while on Investors tab SYNDi Loan Manager User Manual Page 149 Chapter 5 Working with Loans Terms Tab 14 The tab is displayed as follows Rank Billing Day Penalty Months Billing Frequency Compounding Calculation Method Amortize Over Payment Amount Maturity Date Expected Repayment Next Billing Date Last Billing Date I Selt Administered 2 a Second Mortgage 31 Payment Type Blended C Interest Only 2 for Early Discharge Monthy Semi Annual x c Additional Principal Deduction 12 Month Year gt Amount 2000 00 25 veas StatDate 0670172012 Hi O 8740 Recalculate Stop Date 0673072012 pH 0170172015 8 fo1701 2015 E 0573172012 4 4 30 2012 Save Delete Profile Amortization Investors Inquiry I Calculate interest on
139. ed in Company Profile Section 4 3 The tab is displayed as follows 15 x m SYNDiLM Loans Sample Financial Compa Property ID BAN2365 a Appraised Value 1 500 000 00 Selling Price oo Dther Loans J 200 000 00 Loan T o Value l 20 Type E Residential ttstst S Category Single Unit COC S Class a NothYok Save Delete Profile Amortization Investors Inquiry Close 22 The fields shown on the screen are described below Property ID A code set up to identify the property maximum 16 alphanumeric characters user defined g Finder is used to display a list of all records in the Properties table Fly is used to set up a new Property or maintain existing properties See Section 5 4 23 The remaining fields on the screen are described in detail in under Manage Properties Section 5 4 24 You cannot change Property ID using Finder or Fly button if a loan has already been funded 25 You may click Investors button to display contributions from individual investors in a tabular form You may scroll through the table by clicking inside the scroll area on the right side of the table if SYNDi Loan Manager User Manual Page 156 Chapter 5 Working with Loans 26 27 28 29 30 31 32 all investors cannot be accommodated on one screen You may select an investor by clicking in the record selector area on the left side of the table When an
140. ed or deleted The system displays the following message to confirm if transactions should be posted SYNDi Loan Manager User Manual Page 218 Chapter 9 Loan Adjustments Confirm Posting Do you really want to post If you have already printed unposted adjustments click Yes to post transactions 3 All Loan Adjustments entered to increase the Loan Amount become applicable when the next billing is run However if the Loan Amount is reduced or an interest adjustment has been entered The program runs a special billing to apply those amounts immediately effective the Loan Adjustment Date After such a Loan Adjustment has been posted you should run Borrower Receipts and post it Then run Investor Payments and post it to close the transaction SYNDi Loan Manager User Manual Page 219 Chapter 10 Billing Chapter 10 Billing 10 1 Introduction Billing is the process in which the monthly installment containing interest and principal if any is calculated and billed to the borrower Each loan is assigned a payment day showing the day of the month on which the loan will be billed When a loan is set up the Next Billing Date is set based on the Start Date of the loan The installment for first billing is calculated from the Start Date inclusive to the Next Billing Date inclusive Thus if the payment day is same as the day in the Start Date billing calculates interest for one day At the end of the billing p
141. een Page 131 Chapter 4 Setting up the Application 3 To set up a new party click New to clear the screen Enter Party ID If the record is already present in the table the data is displayed and various fields could be modified 4 You may hit lt Tab gt key to move from one field to the next Alternatively you may click inside a field and modify it 5 If you do not click the New button while entering a new record the data from the previous record remains on the screen You may change any fields if necessary and then click Add to add the record 6 To modify an existing record enter the Party ID or use Finder to select a record Enter various fields and click Save to save changes 7 To delete a record click Delete You cannot delete a lawyer record that has already been assigned to a loan SYNDi Loan Manager User Manual Page 132 Chapter 5 Working with Loans Chapter 5 Working With Loans 5 1 Introduction 1 Loan Maintenance screen is displayed when the user clicks Loan and Properties on Main Menu as described in section 3 5 SYNDi Loan Manager User Manual Page 133 Chapter 5 Working with Loans 5 2 Setting up a Template 1 The processing of a Loan depends on the settings specified in the Loan Template that defines the Loan It is necessary to set up at least one Template before setting up a Loan 2 Click Templates on Loans and Properties Menu to display the Templates screen 3
142. eld Save Close Click to close the screen ji 3 Ifthe difference between principal and or interest on borrower or investor s side exceeds maximum rounding error you may change the amount either for the borrower or for one or more investors 4 If you have changed an amount on borrower side you must click Save before you click Investors tab 5 When you click Save the corresponding error code disappears if the difference between the amounts becomes less than the maximum rounding error 6 You may hit lt Tab gt key to move from one field to the next Alternatively you may click inside a field and modify it 7 To display a record enter the Loan ID or use Finder to select a record SYNDi Loan Manager User Manual Page 228 Chapter 10 Billing 10 5 Investors Tab 1 The Investors tab is displayed as follows SYNDi Edit Billing Data Sample Financial Company Borrower Investors Misc Charaes Loan ID DAMPLA Damascus Plaza Investor ID BARJIM a Jim Baryi Investment Number 2727 Stat Date 04 11 2005 Principal 0 00 Billing Date 109 2007 Interest 947 92 Amount Loaned 100 000 00 Miscellaneous Charges 121 46 Interest Rate 11 3750 Discharge Penalty 8 00 Principal Paid to date 0 00 Fee 56 88 Interest Paid to date 19 862 17 N R Tax 0 GST 8 j Eix Close 2 The fields shown on the screen are described below Investor ID Enter the Investor ID maximum 16
143. ence number assigned by SYNDi Enter the date of transaction The date must be prior to the next billing date of the loan but not prior to the start date Page 202 Chapter 8 Borrower Payments Paid To Document No Principal Prepaid Interest Amount Advanced Cross Ref No SYNDi Loan Manager User Manual The range of valid dates is displayed on the screen for reference The system displays Borrower s name If the check is being issued to a 3 party such as the law firm or realty broker enter the name in this field maximum 60 characters Enter check number or relevant information maximum 20 alphanumeric characters user defined Displays the amount set up as the principal in the loan record This field is available only if you have not set up Multiple Investors in Company Profile If the borrower is prepaying some amount as interest enter it here This amount will be deducted from the payment amount SYNDi write a Miscellaneous Transaction as Unapplied Cash You may apply it fully or partially on monthly basis in Borrower Receipts Displays the amount to be advanced to the borrower It is equal to the principal minus any miscellaneous charges that have been set up for the purpose of applying to loan advance If the loan has been set up with prepaid interest the interest amount is also deducted from the principal to calculate Amount Advanced Cross Reference Number is a 19 character field that i
144. enders it inactive Displays the date on which the charge was billed last time Normally it is the last billing date of the loan Displays the date on which the charge will be billed Normally it is the next billing date of the loan but the user may change it to a date later than the next billing date The date gets updated automatically when the loan is billed If the next application date of the miscellaneous charge falls after the maturity date of the loan it is applied on the maturity date for the last time and is automatically rendered inactive Check it to indicate to the system that the charge should be billed If the Frequency is Next Billing the system unchecks it after the charge is billed If it has to be activated again at a later date e g NSF charges check it again and the charge will be billed next time billing is run If the Frequency is Every Billing the Active box will remain checked unless you uncheck it manually Normally the distribution of amount to be paid to investors is done in proportion to their percentage of contribution to the loan A list of investors with corresponding amounts is displayed and you may change the individual amounts if necessary In the example shown above the investors will be paid a total of 500 Unapplied amount is the difference between the total investor amount and the sum of the amounts for individual investors This amount must be zero in order to save the Miscellaneous Cha
145. ents Entry Investors Misc Charges Enter Payments in Block Print Unposted Payments Print Payments Statement Print Posted Payments Print Payment Voucher Verify Bank Accounts Post Payments Close The functions shown on the screen are described below Enter Payments in Block This option displays all billed loans for which investor payments have not been processed The user is provided the opportunity to flag all or some loans for which the payments have to be distributed The program processes these payments in full and makes them available to be printed and posted See Section 13 4 Print Unposted Payments Generates a report showing unposted payments to investors for selected loans See Sample Report in Appendix A Print Payments Statement Payment Statements Report displays unposted payments and lists all entries to be processed for direct bank deposit It must be printed before posting See Sample Report in Appendix A Print Posted Payments SYNDi Loan Manager User Manual Page 265 Chapter 13 Investor Payment Generates a report showing posted payments to investors for selected loans and date range See Sample Report in Appendix A Print Payment Voucher Generates a report showing investor payments in a range of billing date Bank Account Verification This function is used if you are using SYNDi EFT to send monthly payments to investors through Electronic Funds Transfer P
146. er 3 Running the Application 3 13 Upgrading SYNDi Loan Manager 1 If you are already running an old version of the program you should upgrade it to the new version to take advantage of new functionality and to fix any bugs in the old version Before you upgrade SYNDi Loan Manager to the latest version make sure that you have received the Activation Key for the new version from INDUS SYSTEMS All clients who are currently subscribing to the annual Software Assurance program are eligible to receive the Activation Key for the new version without any charge Locate the folder in which SYNDi Loan Manager has been installed on your network We will call it Application Folder Locate the folder called Setup within the application folder If not found create one Download SYNDi zip from http www S YNDi ca save it in the Setup sub folder and unzip it Get into Templates in the Database Location and locate the following files CheckLayout dot Document Template for check layout BorDiscNotice dot Document Template for Borrower Discharge Notice InvDiscNotice dot Document Template for Investor Discharge Notice Payout dot Document Template for Payout Statement NSFLetter dot Document Template for Payment Return Letter These templates may not be compatible with the new version of SYNDi Loan Manager and should be deleted When the program does not find them in that folder it copies new templates from the Application Folder Howe
147. er ADMIN The Date field on the Login screen indicates the current date It is displayed on all reports generated during the session and is used as the default date while entering transactions If you require this date to be different from the current date enter it in the format set in Windows or click the Calendar button next to the date field to choose the desired date All dates in this manual have been displayed in mm dd yyyy format The actual display will depend on the date format set on your machine Please see Acceptable Date Formats later in this section SYNDi Loan Manager User Manual Page 22 Chapter 3 Running the Application 6 Click Login to display Main Menu Acceptable Date Formats 7 Following are acceptable date formats dd mm yy mm dd yy dd mm yyyy mm dd yyyy yyyy mm dd dd mm yy mm dd yy dd mm yyyy mm dd yyyy yyyy mm dd If you are using any other format please change it to one of those shown above for SYNDi to work properly You may do that by going to Regional and Language Options in Control Panel SYNDi Loan Manager User Manual Page 23 Chapter 3 Running the Application 3 3 Main Menu SYNDi Loan Manager User Manual Main Menu is displayed when the user clicks the Login button on the Login screen SYNDi Loan Manager supports two different forms of menus and you may choose either on depending on your preference Tree Menu When you enter SYNDi Loan Manager for the first time
148. er Manual Page 289 Chapter 16 Loan Transfer Simply Accounting Interface 8 If SYNDi Loan Manager is interfaced with Sage Simply Accounting make sure that the program and any other programs accessing Simply Accounting are closed Then open Simply Accounting in single user mode 9 Click File gt Import Export gt Import Transactions The following wizard is displayed 10 Choose import miscellaneous transactions into Simply Accounting and click Next The wizard prompts you to perform a backup Click Backup and follow the instructions and then Next 11 The wizard now prompts you to select a file to be imported into Simply Accounting Navigate through the wizard to point to Import Transactions Wizard The Import Transactions wizard will help you import miscellaneous transactions invoices orders quotes or time slips into Simply Accounting Would you like to g or time slips Click Natta rantina SYNDiGLEntries txt in the Database Location The following screen is displayed 12 Click Next to start importing the data When the import is completed Simply Accounting displays import summary Click Finish to complete the import action 13 Follow the instructions in Simply Accounting for further processing SYNDi Loan Manager User Manual Page 290 Chapter 16 Loan Transfer Import Transactions Wizard Select File Select the import file that contains the miscellaneous transactions you want to import
149. er Misc Charges Display Change Add Delete 15 Loan Discharge Display Edit Generate Cancel Post 16 Loan Adjustments Display Change Add Delete Post 17 Investor Receipts Display Change Add Delete Post 18 Billing Report Edit Process Cancel Post 19 Borrower Receipts Display Change Add Delete Reverse Post 20 Investor Payments Display Change Add Delete Post 21 Check Generation Allow 22 Investor Transfers Display Change Add Delete Post 23 Delete Old G L Entries Allow 24 Cancel Latest Billing Allow 25 Transfer G L Entries Allow 26 Reports and Inquiries Allow 8 The user setup screen displays a table showing the security level for each function When a new user is set up the security level is set to 0 for each function which does not allow access to that function Level 1 signifies the lowest level of security and allows access to all operations in a function Level 2 allows access to all but the last operation As the level increases additional operations are disallowed Thus Level 3 allows all but the last two operations Consider Investor Receipts Function 17 The various levels of security have the following significance Level 0 Level 1 Level 2 Level 3 Level 4 Level 5 SYNDi Loan Manager User Manual No Access Allow Display Change Add Delete and Post Allow Display Change Add and Delete Allow Display Change and Add Allow Display and Change Allow Display only Page 89 Chapter 4 Setting up
150. er the Account Number or use Finder to select a record Enter the new description and click Save to save changes 7 To delete a record click Delete You cannot delete an account number that has already been assigned in company profile or has been used in generating journal entries SYNDi Loan Manager User Manual Page 66 Chapter 4 Setting up the Application 4 2 Banks 3 You will need to set up at least one bank with which you do banking so that your Bank Code and Account Number may be printed on the Bank Deposit Report If you use electronic funds transfer to pay the investors you will have to set up their bank account codes as well Click Banks on Setup screen to display the following screen m SYNDiLM Banks Setup Sample Financial Company Mi d Bank ID SCOTIA ols Transit Number 0010 01087 Bank Name Bank of Nova Scotia S BranchName Sherbrook Branch gt Address 2276 Civil Lines o o City Markham Prov State ON PostalCode M5F 1F1 Country Canada Tel DO i i Fax Contact Jim Culen GL Account hoo Ael First City Bank Accont SCS Account No 02818349 C Next Check 273 Remarks Save Delete The fields shown on the screen are described below Bank ID A code set up to identify a bank Maximum 10 characters g Finder is used to display a list of all banks in the Banks table ry Scroll is used display previous or next bank F record by hitting up or down
151. erable License to use the Software and agree to the following Terms and Conditions Accordingly You may use the software and documentation for Your own internal purposes only at Your normal place of business i e one location on a single server and local area network for payment of the Initial License Fee as well as the Annual License and Support Fees if applicable until this Agreement is cancelled or defaulted make copies of the programs for backup purposes only and make one copy of the documentation for each additional concurrent user You have licensed for the Software You will receive one electronic copy of the Documentation with the Initial License Fee Your continued use of the Software is granted annually with Your payment of the Annual License and Support Fee if applicable You acknowledge that the Software and Documentation as well as other Materials contain confidential information that is proprietary to INDUS and or other third parties You will take the same care to safeguard these materials as You take to safeguard Your own confidential information You will not receive source code for the Software You may not e modify the programs other than those modules which allow modification such as reporting tools lookup tables etc e sell or otherwise transfer the programs to any other party e provide copies of the software or documentation to anyone outside Your establishment for any reason We warrant that the Software w
152. eses It is not necessary to type zero cents For instance 2365 is displayed as 2 365 00 13 Percentage fields can be typed and are displayed up to four decimal places For instance 10 5 is displayed as 10 5000 14 Rates are displayed up to 3 decimal places with a plus or minus sign For instance 2 310 means prime minus 2 31 in percentage SYNDi Loan Manager User Manual Page 38 Chapter 3 Running the Application 3 8 Finder Button 5 Finder button see Section 3 8 is normally located on the right side of a field You may either enter a value in the field or use Finder button to display a search screen listing all records in a table and then select a record from there Search Borrowers Find u BorrowerlD Description Address1 Bell Catering 1160 Birchmount Road Jim Blouski 1160 Birchmount Road Dataflow Systems 1160 Birchmount Road Full Slate Holdings Ltd 1160 Birchmount Road Goldberg Realty 1160 Birchmount Road Jacobson Partners Ltd 1160 Birchmount Road Wei Cheng Lin 1160 Birchmount Road Queen s Place 1160 Birchmount Road Samuel Sampson 1160 Birchmount Road Henry Srinivasan 1160 Birchmount Road If the field on which you have clicked Finder is blank the search screen displays all records in the table and the Find field is shown as blank If the number of records is larger than the screen can accommodate you could use the scroll area on the right side of
153. est is calculated for the life of the loan and then allocated to each month by proportion using reverse sum of the digits methodology SYNDi uses 12 Month Year as the default if the payment frequency is in units of months However in case of weekly and bi weekly payment frequencies SYNDi uses Exact Year as the default The choice of Calculation Method depends on your company policy Typically for a 100 000 loan at 12 with blended payments and no compounding amortized over one year the total interest is as follows Method Normal Year Leap Year 360 Day Year 6 618 53 6 618 53 365 Day Year 6 586 40 6 586 40 Exact Year 6 586 40 6 600 64 12 Month Year 6 618 53 6 618 53 Sum of Digits 12 000 00 12 000 00 No Compounding 7 If the calculation method is 12 Month Year the interest for a portion of the period for first and last payments is calculated by multiplying the number of days by the Daily Interest Rate which is obtained by dividing the Effective Rate of the period by 30 In case of full periods the interest is calculated by multiply the Effective Rate by the number of periods 8 If the calculation method is 365 Day Year or Exact Year the interest is calculated daily and accumulated over a period or part thereof SYNDi Loan Manager User Manual Page 6 Chapter 1 Introduction 9 Sum of Digits Method For example consider a 100 000 loan to be repaid in monthly installments
154. et the same subject and the message It will be easy for you to make some changes to the existing message and you don t have to enter the full message again After you done with the subject and message entries you can go back to the List tab and click email button and all your selected investors will receive their email with their respective T5 slips as attachments SYNDiLM Prepare T5 Slips Sample Financial Company Parameters List Message Subject T5 Slips for 2012 Font Bii Message Your 75 sip for 2072 fs attached Please cut if in the middie attach top porlon with pow fax return and retain the bottom portion for gous records John Thompson Print Upload Confirm Email Close 21 To upload the XML file to CRA system you must have an internet connection and Internet Explorer on your machine Once you are sure about the connection click the Upload button and SYNDi will take you to the website for Canada Revenue Agency You must follow all the instructions on the website that guides thru the process of uploading your XML file to CRA s system Once you click the upload button you will see the internet explorer browser with the following screen SYNDi Loan Manager User Manual Page 304 Chapter 16 Loan Transfer Filing Information Returns Electronically 14 15 and other types of returns Windows Internet Explorer DER g i sttp wmw cra arc gc cafesrve srycejrfimet html z je z File Edt
155. ets the next billing date as February 19 instead of March 9 which would fall after the maturity date The last billing is therefore run for the period covering February 10 to February 19 i e 10 days 3 The last billing includes the entire principal balance as the balloon payment leaving the balance zero 4 Payment Frequency In case of most loans the interest and a portion of principal in case of blended payments is payable on monthly basis SYNDi allows the following payment frequencies Term Loans Daily Weekly Bi weekly Semi monthly Monthly Bi monthly Quarterly Semi annual Annual SYNDi Loan Manager User Manual Page 4 Chapter 1 Introduction The duration between two successive payments is termed as period Thus for monthly payments the period is one month while for weekly payments the period is one week 5 Compounding Frequency Compounding Frequency establishes the number of times in a year the interest is compounded SYNDi allows the following compounding frequencies None simple interest Daily Weekly Bi weekly Semi monthly Monthly Bi monthly Quarterly Semi annual Annual For most interest only loans the payment frequency is monthly with no compounding In case of blended payments the payment frequency is usually monthly In Canada the compounding frequency is usually semi annual while in U S it is same as payment frequency F
156. first note will be displayed Go to Loans setup and enter 200 000 in Principal Payment so that this amount will be billed After that either delete the note or uncheck Hold Billing so that the note will not be displayed again 2 When billing is run on December 9 2003 the second note is displayed Go to Loans setup and change the rate of interest to 10 75 After that either delete the note or uncheck Hold Billing so that the note will not be displayed again 3 When billing run will run on November 9 2004 the third note will be displayed Go to Loans setup and enter 200 000 in Principal Payment so that this amount will be billed After that SYNDi Loan Manager User Manual Page 127 Chapter 4 Setting up the Application either delete the note or uncheck Hold Billing so that the note will not be displayed again 4 When billing is run on December 9 2004 the fourth note is displayed Go to Loans setup and change the rate of interest to 11 75 After that either delete the note or uncheck Hold Billing so that the note will not be displayed again SYNDi Loan Manager User Manual Page 128 Chapter 4 Setting up the Application 8 Pop up Reminders 1 If a Note has Remind Me box checked it pops up if the current date and time have exceeded Reminder Date and Time The frequency with which these reminders pop up depends on the frequency in minutes set in the Company Setup menu See Section 4 3 2 If you want a
157. g message is displayed Check Save j You have changed the name of the bank A Do you want to apply the change to all branches If you click Yes the bank name in all records with the same bank number will be changed otherwise the name will be applied only to the record being added or changed SYNDi Loan Manager User Manual Page 69 Chapter 4 Setting up the Application 4 3 Company Profile If SYNDi is interfaced with QuickBooks it is necessary that QuickBooks be open with the right company when you enter this screen 1 The Company Setup screen is displayed when the user clicks Company Profile on Setup screen 2 Hit lt Tab gt through various fields and change them if necessary 3 The screen contains five tabs described below SYNDiLM Company Profile Sample Financial Cc lol x Company Options E Mail Intearation Descriptions Company Enter name and address of your company and the Database Location Options Enter key parameters to determine the flow of the system E Mail If you will use SYNDi to send e mails to borrowers and investors you can set up the parameters on this tab Integration Define whether the program is set up as a Standalone package or it is integrated with Sage Simply Accounting Sage ACCPAC ERP or QuickBooks Descriptions This screen contains default descriptions for various types of transactions You may change them if necessary You may access various tabs by click
158. g on your tax laws If you have set up your system without Multiple Investors the Tax Authorities box is not displayed If no sales tax is charged on management fee leave all the field blank otherwise you may set up a maximum of three levels of tax e g federal state and county Enter the description for each tax authority maximum 20 alphanumeric characters and the percentage You cannot set up tax for an authority without setting up the tax for preceding level Interest on Unpaid If the borrower misses a payment you may Balance calculate interest on unpaid balance Define the G L account to which interest will be posted and if all or a portion of interest has to be paid to investor indicate the percentage SYNDi Loan Manager User Manual Page 140 Chapter 5 Working with Loans Accounts Tab 1 12 The tab is displayed as follows when the user clicks tab header SYNDiLM Template Setup Sample Financial Company Payments to Borrowers DA Loan Receivable 1040 a 3 Loan Receivable CR Bank jozo Q First City Bank Account Receipts from Borrowers DR Bank 1020 a First City Bank Account CR Receivable from Borrowers fi 200 a 3 Receivable from Borrowe Receipts from Investors DR Bank 1020 Q gt First City Bank Account CR Investors in Trust 1050 Q e Investors in Trust Payments to Investors DR Investors in Trust 1050 a Investors in Trust DR Payable to Investors 2300 a Payable to Invest
159. ger User Manual Page 281 Chapter 14 Generating Checks One Thousand One Hundred Fifty Three Dollars and Forty One Cents 2007 01 31 1 153 41 Sitara Gustov YYYY MM DD 1160 Birchmount Road Scarborough Ontario M1P 2B8 Payee ID Paid To Check Date Check Number Check Amount GUSSIT Sitara Gustov 07 12 2007 2182 1 153 41 Reference Loan ID Description Amount 8387 8694 DAMPLA Payment to Investor 496 94 8388 8710 DOR1872 Payment to Investor 108 90 8393 8793 PARK2781 Payment to Investor 547 57 Payee ID Paid To Check Date Check Number Check Amount GUSSIT Sitara Gustov 07 12 2007 2182 1 153 41 Reference Loan ID Description Amount 8387 8694 DAMPLA Payment to Investor 496 94 8388 8710 DOR1872 Payment to Investor 108 90 8393 8793 PARK2781 Payment to Investor 547 57 Sample Check SYNDi Loan Manager User Manual Page 282 Chapter 16 Loan Transfer Chapter 15 Periodic Processing 15 1 Delete Old G L Entries 1 Journal entries are generated as various transactions are entered as shown in Company Profile Setup section 4 3 These entries should be printed and posted into General Ledger before they are deleted at the end of each month as shown in this section Click Delete Old G L Entries on Periodic Processing Menu to display the following screen SYNDi LMS Delete G L Entries Sample Financial Company Pf Make sure that you have printed a
160. h may have certain features turned off and which can run only for 30 days If you are running Trial Version 1 Make sure that Trial Version is clicked 2 Enter the name of your company exactly as it will be when you decide to purchase the software and run full version 3 Click Save If you are running Full Version 1 Make sure that Full Version is clicked 2 Enter the 6 digit customer ID assigned to you by INDUS 3 Enter the company name exactly as it was provided to INDUS at the time of purchasing the software 4 Enter the Installation Code and the Activation Key provided by INDUS or click Get Key to obtain keys over Internet 5 Click Save SYNDi Loan Manager User Manual Page 20 Chapter 3 Running the Application Chapter 3 Running the Application 3 1 Running the Trial Version 1 Click Start gt Programs gt SYNDi Loan Manager gt SYNDi Alternatively click the shortcut you may have created to run the program If you are running the Trial version the following screen is displayed If you have purchased the software and received the Installation Code and the Activation Key click Activate to indicate that you are ready to register otherwise click Continue to keep using the Trial version Expiry Date Reminder You are currently licensed to use this program for a limited period It has 30 days left including today before A it expires If you have an Activation Code and want to enter it at
161. he Application Activate the Application Chapter 3 Running the Application JL SYA 3 3 3 4 3 5 3 6 3 7 3 8 3 9 3 10 3 11 3 12 3 13 3 14 3 15 Running the Trial Version Login Screen Main Menu Setup Menu Loan and Properties Menu Periodic Processing Menu Screen Management Finder Button Printing Reports Setting up a New Company Creating Sub Folders Setting up Workstations Upgrading SYNDi Loan Manager Creating SQL Server Database Common Problems with SQL Server Databases Chapter 4 Setting up the Application 4 1 4 2 4 3 G L Accounts Banks Company Profile Company Tab Options Tab E Mail Tab 4 4 4 5 4 6 4 7 4 8 4 9 4 10 4 11 4 12 Integration Tab Descriptions Tab Users Setting up Users Security Levels Optional Fields Miscellaneous Charge Codes Loan Status Codes Prime Rates Borrowers Applicant Tab 1 Applicant Tab 2 Optional Fields Tab Investors Name and Address Tab Personal Data Tab Payment Tab Documents Tab Group Tab Optional Fields Tab Reminders Other Parties Chapter 5 Working with Loans 5 1 5 2 5 3 5 4 5 5 5 6 5 7 5 8 Introduction Setting up a Template Settings Tab Options Tab Accounts Tab 1 Accounts Tab 2 Loan Maintenance Details Tab Terms Tab Notes Tab Property Tab Contacts Tab Documents Tab Optional Fields Tab Manage Properties Fund a Loan Enter Miscellaneous Charges Discharge a Loan Renew a Loan
162. he Print icon on the top left hand corner of the screen Before the report is sent to the printer the Printer Setup screen is displayed Make sure to set the printer orientation to Portrait or Landscape depending on the report unless you have already chosen printer as a destination E Export Click to save the report as HTML or Text file AAA fi noe Zoom Select the magnification to view the report properly Pages M fi gt pl Pages Click left and right arrow buttons to browse through the report 14 Some of the reports can be e mailed or faxed to the invertors Choose E Mail Fax as the print destination wherever available The system exports the report as an HTML file and saves it in SYNDi Loan Manager User Manual Page 44 Chapter 3 Running the Application Reports folder within the Application Folder It then uses Microsoft Outlook to send the report to the investor 15 The system looks for the e mail address in the investor record to send the report If the e mail address is blank it uses the fax number to fax the report If the fax number is blank as well a message is displayed and the report is not sent to the investor SYNDi Loan Manager User Manual Page 45 Chapter 3 Running the Application 3 10 Setting up a New Company 1 After you have played with Sample Financial Company it is time to set up your own company SYNDi Loan Manager allows you to set up multiple companies if ne
163. he Receipt Number or use Finder to select a record You cannot modify a receipt once it has been posted 6 To delete a receipt click Delete You cannot delete a receipt that has already been posted SYNDi Loan Manager User Manual Page 251 Chapter 12 Borrower Receipts 12 5 Principal and Interest Tab 1 The tab is displayed as follows SYNDiLM Borrower Receipts Sample Financial Co OX Menu Receipts Entry Principal and interest Misc Charges Unapplied Cash Deductions Principal and Interest Select All Select None _ Apply BillingD ate MiscChgDue MiscChaRec p No 05 01 2012 0 00 0 00 0 00 0 00 150 00 0 00 04 30 2012 03 31 2012 39 0 00 02 29 2014 854 44 0 00 01 31 2012 0 00 4 956 9 12 31 2011 0 00 4 962 8 Amount to be applied 29 081 51 2 This table displays billing records for various loans You may click on any row in the table to select it The columns in each row are described below Apply Double click the column to apply receipt to the billing record The entry under Apply changes from No to Yes Double click it again and notice that it changes back to No Billing Date Date on which the record was billed PrincipalDue Displays outstanding principal billed PrincipalRec Principal Received Displays the principal to be paid in the current receipt InterestDue Displays outstanding interest billed InterestRec Interest Received Disp
164. he XML file if not done so e mail T5 slips to inverstors if necessary and enter the Confirmation Number that you received from CRA when you uploaded the data 9 If you click No all earlier transactions that were processed will be deleted and you must click Load again to load the data 10 From the list of the displayed investors you may either process all transactions by clicking All and then clicking Process or you may select investors one at a time by double clicking the No value against the investor record under the column Apply Double clicking under the Apply column makes the values No to Yes and vice versa 11 The next screen displays investors whose T5 slips have been generated and you have to upload them to CRA or print them SYNDi Loan Manager User Manual Page 299 Chapter 16 Loan Transfer SYNDiLM Prepare T5 Slips Sample Financial Company Parameters List Message Print C Email Bahn Otto info indussys com Chong Jim register indussys com Dingo Ben register indussys com Ken Drew Associates register indussys com Gambol David register indussys com Gambol Julie register indussys com Piper Peter register indussys com Watchman James register indussys com Total Count 0 Error Count 0 Total Amount 0 00 Print Upload Confirm Email Close 12 Clicking the Upload button will take you to Canada Revenue Agency website where you will hav
165. he borrower decides to pay a portion of the principal during the life a loan or discharges the loan before the maturity date In this case the principal amount is entered with a negative sign The borrower may also pay certain amounts for interest and penalty which are entered as positive amounts The program runs a special billing run and applies these amounts to the investors You must run Borrower Receipts and Investor Payments and post them after the loan adjustment is posted b The borrower may require additional loan which comes from one or more existing investors or new investors The principal amount is entered without a minus sign and The program processes investor receipts and the borrower payment when the loan adjustment is posted It is necessary to post the adjustment after it has been entered in order to be considered as part of billing The Loan Adjustments screen is displayed as follows when the user clicks Adjustment on the Details tab of Loan Maintenance screen see Section 5 3 SYNDi LMS Loan Adjustments Sample Financial Company Menu Loan Adjustments Entry Investors Menu Print various listings and post adjustments Loan Adjustments Entry Enter loan adjustments Investors Enter investor distribution You may access the tabs by clicking on the tab header SYNDi Loan Manager User Manual Page 208 Chapter 9 Loan Adjustments 9 2 Loan Adjustments Entry Tab 1 Th
166. he middle Cross Reference Numbers must be unique If two or more Loan IDs or Investor IDs have the same characters in the first 9 positions you may get duplicate Cross Reference Numbers and the system displays an error message if it encounters a duplicate Duplicate Cross Reference Numbers may also be generated if an investor contributes to a loan more than once In such cases you must change the Cross Page 180 Chapter 6 Investor Receipts Add Save Delete HE Close SYNDi Loan Manager User Manual Reference Number to make it unique If the investor is paid by check and the Bank ID is blank the Cross Reference Number may be left blank Click to add a new record Click to save an existing record It is high lighted only when the user changes a field Click to delete an existing record Click to close the screen Page 181 Chapter 6 Investor Receipts 6 3 Terms Tab 1 The Terms tab is displayed as follows Ss Term Interest Rate Payment Type Amortize Over Payment Amount Fee Payment Cycle Term End Date Investment Type Registered Investments Plan Type RRSP Q Registered Retirement Saving Plan Plan Number 1234 45 45657 TrusteelD TD ael TD Trust SYNDiLM Investor Receipts Sample Financial Co _ ol x 60 months 0 days Fixed Variable 8 5000 Blended C Interest only s5 years Payment Frequency Monthy v 2051 65 Recalculate Compoun
167. he value can be changed if necessary This window displays all miscellaneous charges including prepaid interest Before you fund a loan enter all Miscellaneous Charges with Loan Advance as the Frequency see Section 5 5 When you fund the loan all Miscellaneous Charges e g holdbacks admin fees etc are deducted from the payment amount Click to add a new record Page 204 Chapter 8 Borrower Payments Save Click to save an existing record It is high lighted only when the user changes a field Delete Click to delete an existing record Close Click to close the screen iig 3 To enter a new payment click New to clear the screen and enter Loan ID If the record is already present in the table you may modify it or delete it provided it has not been posted However if the payment has been posted the system displays the following message This payment has already been posted You will not be able to delete it or save any changes to this payment OK 4 You may hit lt Tab gt key to move from one field to the next Alternatively you may click inside a field and modify it 5 To modify an existing record enter the Loan ID or use Finder to select a record If the record has not been posted enter various fields and click Save to save changes 6 Once you have initiated the billing process you cannot enter a payment until billing has been posted 7 To delete a record click Delete You cannot
168. heck Entry Tab Chapter 15 Periodic Processing 15 1 Delete Old G L Entries 15 2 Cancel Latest Billing 15 3 Accounting Interface 15 4 Purge Old Data 15 5 Prepare T5 Slips Chapter 16 Loan Transfer 16 1 Introduction 16 2 Entering Loan Transfers Chapter 17 Loan Documents 17 1 Introduction 17 2 Setting up Loan Documents 17 3 Entering Data 17 4 Generating Loan Documents 17 5 Applying Loan Advances Chapter 1 Introduction Chapter 1 Introduction 1 1 What is SYNDi Loan Manager SYNDi is a suite of software packages designed for the financial market It consists of the following programs e SYNDi Loan Manager e SYNDi Fund Manager e SYNDi Investment Ledger e SYNDi Electronic Funds Transfer This manual deals exclusively with SYNDi Loan Manager which manages loans in cases where a single lender or a group of lenders investors lends money for a loan SYNDi Loan Manager is available in two editions 1 SYNDi Professional Edition manages loans provided by a single lender It cannot be interfaced with an external accounting package 2 SYNDi Premium Edition provides full features with ability to manage multiple lenders in a loan It can be interfaced with a number of external accounting packages Wherever SYNDi is mentioned henceforth in this manual it stands for SYNDi Loan Manger Premium Edition exclusively If you are using the Professional Edition all references to lenders and investors
169. hen the user changes a field Click to delete an existing record Click to close the screen 3 To set up anew note click New to clear the screen SYNDi Loan Manager User Manual Page 126 Chapter 4 Setting up the Application 4 You may hit lt Tab gt key to move from one field to the next Alternatively you may click inside a field and modify it 5 To modify an existing record enter the Note ID or use Finder to select a note 6 To delete a note click Delete 7 Controlling Billing through Reminders The most powerful feature of reminders is their use in controlling the billing process Consider the following scenario Loan Number BIR1160 for Samuel Sampson was set up for 775 000 at 9 5 interest on November 10 2002 According to the terms of the Loan the borrower will pay 200 000 at the end of each year and the rate of interest will be increased by 1 Enter the following notes to remind you when it is time to bill the extra principal installment and to increase the interest rate Make sure that you check Hold Billing so that the note is displayed when billing is run 11 09 2003 Samuel Sampson will pay 200 000 on this billing Enter 200 000 in Principal Payment 11 10 2003 Change interest rate to 10 75 11 09 2004 Samuel Sampson will pay 200 000 on this billing Enter 200 000 in Principal Payment 11 10 2004 Change interest rate to 11 75 1 When billing run will run on November 9 2003 the
170. i E maximum 16 alphanumeric characters user defined Finder is used to display a list of all records in the Properties table Scroll is used display previous or next record by hitting up or down arrow Fly is used to set up a new Property or maintain existing properties Appraised Value Enter the Appraised Value Selling Price Enter the Selling Price SYNDi Loan Manager User Manual Page 162 Chapter 5 Working with Loans Other Loans Outstanding Balance Loan To Value Legal Description Address City State Prov PostalCode Country Type Category Class SYNDi Loan Manager User Manual If there are any third party mortgages on the property which have not been entered into SYNDi enter the total outstanding amount of such loans in this field Displays outstanding balance on all loans on the specified property including Other Loans Displays the Loan To Value LTV Ratio as a percentage See Note below Enter legal description of the property Three address lines maximum 60 alpha numeric characters each Name of the city maximum 30 alphanumeric characters State or province maximum 20 alphanumeric characters Zip code or postal code maximum 10 alphanu meric characters Country Name maximum 20 alphanumeric characters User defined field maximum 16 alphanumeric characters You may display the predefined Type Codes by clicking the Finder button or define
171. i e interest minus C Gross Net administration fee minus any taxes deducted Load Process Print Upload Confirm SYNDi Loan Manager User Manual Page 296 Chapter 16 Loan Transfer 6 The buttons on the screen are described as follows Load Process Print Upload Confirm SYNDi Loan Manager User Manual When the Load button is clicked the system checks if there are any transactions from a previous run that do not have Confirmation Number The system assumes that the run is not complete Upload the transactions to CRA if necessary e mail T5 Slips to investors if not already done and enter the Confirmation Number received from CRA If no pending transactions from a previous run are found then assuming that you have checked Original on the screen and had processed only some of the investors in earlier runs the system displays the remaining investors If you have checked Amended then only those investors are displayed for whom original T5 Slips were run earlier Click this button to start processing the T5 slips If there are any errors they will be displayed on the screen Print the Error report and correct errors before running T5 s again Later in this document details are provided for correcting errors If no errors are found a list of investors with interest amounts is displayed Details of further processing are described later in this chapter Clicking the Print bu
172. ial damages of any character whatsoever including without limitation damages for loss of profits loss of goodwill loss of confidential or other information for business interruption work stoppage computer failure or malfunction for personal injury loss of privacy for failure to meet any duty including a duty of good faith or of reasonable care for negligence whether active or passive and for any other pecuniary or other loss whatsoever arising out of or in any way related to the use or inability to use the software or otherwise under or in connection with any provision of this agreement even in the event of fault tort including negligence and gross negligence strict liability breach of contract or breach of warranty by INDUS and even if INDUS has been advised of the possibility of such damages In no event will INDUS be liable for any damages in excess of the list price INDUS charges for a license to the software This limitation of liability shall not apply to liability for death or personal injury to the extent that applicable law prohibits such limitation Software License and User Agreement Table of Contents Chapter 1 Introduction 1 1 1 2 What is SYNDi Loan Manager General Features Loan Processing Cycle Interest Calculation 1 2 1 No Compounding Interest Only Loans Blended Payments 1 2 2 Semi Annual Compounding Interest Only Loans Blended Payments Chapter 2 Installation Zeke 22 Install t
173. ich are listed in this Agreement Where Conversion services are performed they are done so on a time and expenses basis at current rates unless otherwise indicated In all cases Customer is responsible for providing data for conversion and INDUS takes no responsibility for the integrity and accuracy of this data Customer is responsible for ensuring that it keeps proper archives and paper records of the data as it existed prior to conversion in the event that it may be needed at some date in the future Where Installation Training Implementation and Consulting Services are provided they are done so on a time and expenses basis for the agreed upon rates herein The Customer may request additional services at any time and INDUS will provide these services at the prevailing rates which are subject to change All requests for additional services must be made in writing by the Customer Training services may be conducted at INDUS facilities or at the Customer s place of business or at other facilities All costs for equipment such as computers classroom projectors etc and all other expenses will be the responsibility of the Customer INDUS reserves the right to limit class size for each training course Annual License and Support Fees The Annual License and Support Fee if applicable covers Your right to continue using the Software at Your site within the licensing constraints Your continued service and maintenance of the product to e
174. if the borrower is an individual in which case you will enter the first name and the last name Finder is used to display a list of all records in the Borrowers table Scroll is used display previous or next record by hitting up or down arrow New is used to clear the screen while setting up a new record Enter the first name of the borrower if the Borrower Type is Personal maximum 29 alphanumeric characters Page 102 Chapter 4 Setting up the Application Last Name Company Name Address City State Prov PostalCode Country Tel Fax E Mail Contact Remarks User ID SYNDi Loan Manager User Manual Enter the last name of the borrower if the Borrower Type is Personal maximum 29 alphanumeric characters Enter the company name of the borrower if the Borrower Type is Corporate maximum 60 alphanumeric characters Three address lines maximum 60 alpha numeric characters each Name of the city maximum 30 alphanumeric characters State or province maximum 20 alphanumeric characters Zip code or postal code maximum 10 alphanumeric characters Country Name maximum 20 alphanumeric characters Telephone number maximum 20 alphanumeric characters Fax number maximum 20 alphanumeric characters E mail address of the borrower maximum 200 alphanumeric characters Contact name maximum 60 alphanumeric characters A user defined memo field This field is displayed on
175. ile to print Checks NSFLetter dor Microsoft Word template file to print NSF letters SYNDi Loan Manager User Manual Page 18 Chapter 2 Installation 2 2 Activate the application 1 In order to activate SYNDi Loan Manager you must have Administrator rights If in doubt please check with your IT administrator or log in as Administrator 2 Click Start gt Programs gt SYNDi Loan Manager gt SYNDi The following message is displayed Activation Status Unclear unclear Please click OK to correct the problem or Cancel to Exit It appears that the Activation Status of this program is Cancel 3 This message is displayed when the program is run for the first time Click OK to continue 4 The following screen is displayed Software Activation C Trial Version Full Version have the Installation Code Customer ID 100200 Company Name INDUS SYSTEMS Product ID 2375 1070 Installation Code 1503 0867 0455 000848 Activation Key _ 7C0A 6620 7042 If you have purchased SYNDi a Customer ID has been assigned to you An Installation Code and an Activation Key has also been e SYNDi Loan Manager User Manual Page 19 Chapter 2 Installation mailed to you If you do not have the necessary information just enter your Customer ID and Company Name and click Get Key to connect to Internet and generate the keys In the meantime you may run the software as Trial version whic
176. ill be calculated as the specified number above or below the prime rate on or immediately before the start date of the loan or the last billing date As the prime rate is modified over the life of the loan the interest will change when monthly installment is calculated Payment Payment Frequency is same as in the Loan Frequency record SYNDi Loan Manager User Manual Page 195 Chapter 7 Investor Transfers Compounding Calculation Method Payment Type Amortized Over Payment Amount SYNDi Loan Manager User Manual Compounding Frequency is same as in the Loan record Calculation Method is same as in the Loan record Choose if the payment will be blended or interest only The default value is taken from the investor receipt for From Investor In case of blended payments enter the amortization period in years The default value is taken from the investor receipt for From Investor In case of blended payments the program calculates payment If you change any of the terms click Recalculate button to calculate the new value of Payment Amount Page 196 Chapter 7 Investor Transfers 7 4 Optional Fields Tab 1 The tab is displayed as follows SYNDi LMS Investor Transfers Sample Financial Company Menu Transfers Entry Terms OptFields Value Corporate gt Investment Type Add Close The optional fields defined for investor receipts are listed
177. ill perform substantially in accordance with its written specifications and Documentation however it is licensed to You without specific warranty except as provided through this agreement INDUS takes no responsibility for any direct indirect or consequential damages including but not limited to lost profits lost revenues failure to realize expected savings or other commercial or economic losses of any kind or any damages caused by Your failure to meet Your responsibilities Our liability for damages for any cause whatsoever including negligence is limited to the amounts You have paid to INDUS hereunder for the initial License Fees Your responsibilities include making the choice to use the Software and Services and obtaining results from their use You agree to operate the Software in an environment and on equipment that meets our specifications You agree to implement appropriate safeguards for Your data through the use of adequate backup and backup media storage procedures INDUS is not responsible for Your data or its backup and recovery All Third Party Software is provided to You without direct warranty from INDUS with INDUS acting as an agent You agree to be bound by and sign all the applicable License Agreements and Support Agreements for Third Party Software where necessary Services Provided Under This Agreement Software License and User Agreement 1 Our responsibilities are for the stipulated fees to provide the services wh
178. ing on the tab header The fields on each tab are described below SYNDi Loan Manager User Manual Page 70 Chapter 4 Setting up the Application Company Tab 4 The tab is displayed as follows SYNDiLM Company Profile Sample Financial Company Options E Mail Intearation Descriptions Name Address City State Prov Tel Fax E Mail Contact Broker License No Admin License No Account Number Sample Financial Company z481 Woodbine Avenue Suite 203 Markham ON PostalCode L3R 2W1 905 940 0751 jinfo indusflow com John Smith 123456789RZ0001 DE Location C SYNDi Transmitter Number MM1 23456 DE Name SYNDiSample mdb Address City State Prov PostalCode Tel Fax Contact SYNDi Loan Manager User Manual Name of your company maximum 60 alphanumeric characters Two address lines maximum 60 alphanumeric characters each Name of the city maximum 30 alphanumeric characters State or province maximum 20 alphanumeric characters Zip code or postal code maximum 10 alphanumeric characters Telephone number maximum 20 alphanumeric characters Fax number maximum 20 alphanumeric characters Contact name maximum 60 alphanumeric characters Page 71 Chapter 4 Setting up the Application Broker License No If you are a mortgage broker enter your Broker License Number here otherwise leave it blank Admin License No If you are a mortg
179. investor is selected the corresponding record in the table is highlighted Contributions from the investor selected in the table are displayed on the top portion of the screen The area at the bottom of the screen shows total contributions to the loan from all investors A contribution can be deleted by selecting it in the table and hitting lt Delete gt key You can delete only unposted receipt If you attempt to delete a receipt that has already been posted the following message is displayed CETT This investment cannot be deleted since it is already posted In order to review the details of a contribution select the record in the table and hit lt Enter gt key The investor receipt screen Chapter ount Start D 50 000 00 6 10 2004 Bill Baroodwala 100 000 00 6 10 2004 Sebastian Bingor 175 000 00 6 10 2004 Bary Goldberg 50 000 00 6 10 2004 Bary Higgert 308 75 UINIOH 75 000 00 6 10 2004 John Jingle 3 00 0 00 T EE 463 08 6 is displayed and the cursor is positioned at Receipt Number Hit lt Tab gt to display the receipt record You may add another receipt on the fly by hitting lt Insert gt key while positioned at a record in the table The Print button at the bottom of the screen becomes enabled while you are on Investors tab Click to print the Loan Profile that displays the contents of the table SYNDi Loan Manager User Manual Page 157 Chapter 5 Working with Loans Contacts Tab 33 The t
180. ions Liability The system allows up to three accounts for sales tax on management fee The non resident tax is calculated as a percentage of interest after deducting management fee and sales taxes if any 4 Borrower Receipts When monthly installment received from a borrower is entered into the system it generates the following journal entry DR Bank in Trust Asset CR Receivable from Borrowers Asset 5 Investor Payments Finally the installment from the borrower is distributed to investors and the system generates the following entry DR Investors in Trust principal portion Asset DR Payable to investors interest minus deductions Liability CR Bank in Trust Asset Following is a simple set of G L accounts Assets 1020 Bank 1 in Trust 1030 Bank 2 in Trust 1040 Loan Receivable 1050 Investors in Trust 1200 Receivable from Borrowers Liabilities 2200 Sales Tax 1 Payable 2210 Sales Tax 2 Payable 2220 Sales Tax 3 Payable 2300 Payable to Investors 2400 Interest for Distribution 2500 Non Resident Tax Payable Revenue 4400 Fee Income SYNDi Loan Manager User Manual Page 64 Chapter 4 Setting up the Application Expenses 5000 Rounding Errors The system allows up to 45 characters in the account number that ensures flexibility needed to handle any type of General Ledger 3 The fields shown on the screen are described below Account No 2 wl Description Account Typ
181. ions of investors subscribing to the loan Page 334 Chapter 17 Loan Documents 17 4 Generating Loan Documents 1 Once the data has been entered and saved click on Tab 1 to display the list of documents 2 Click Loan Documents to generate Administration Agreement Investor Disclosure and Investor Acknowledgement 3 After SYNDi has generated the documents Tab 13 is displayed as shown below Otto Bahn info indussys com Jim Chong register indussys com David Gambol register indussys com Julie Gambol register indussys com Peter Piper register indussys com James Watchman register indussys com Print EMail Save Delete 4 This screen is used to print investor documents and or e mail them to individual investors The e mail address of each investor comes from the Investors table 5 Click All or None to select the investors for whom Loan Documents have to be printed and or e mailed You may also double click in the Selected column to select or unselect and individual investor SYNDi Loan Manager User Manual Page 335 Chapter 17 Loan Documents 17 5 Applying Loan Advances 1 Applying first advance Once the loan has been finalized and you are ready to close it go to Tab 1 and click Apply Loan Advance It performs the following functions a generates investor receipts b posts investor receipts c displays borrower payments screen to fund th
182. irector of brokerage Is the appraiser related to the broker SYNDi Loan Manager User Manual Page 331 Chapter 17 Loan Documents Tab 11 Declaration 3 24 The tab is displayed as follows Declaration 3 JCORS551 6 Will the proceeds be used to refinance redeem an existing mortgager portion of proceeds will redeeem the balance in existing loan If purchase of existing mortgage is it currently in default or has it been in default in last 12 months M Yes Interest Benefits to broker I Yes Please sign the document Yes No Save Delete 25 This screen is used to answer the following questions Will the proceeds be used to refinance redeem an existing mortgage If purchase of existing mortgage is it currently in default or has it been in default in last 12 months Interest benefits to the broker 26 Please sign the documents Click Yes or No If you click No the document displays DO NOT SIGN in signature areas otherwise if a signature file is present see Section 17 2 Step 6 above the agent s signature is displayed in signature areas SYNDi Loan Manager User Manual Page 332 Chapter 17 Loan Documents Tab 12 Investor Subscriptions 27 The tab is displayed as follows SYNDiLM Loan Documents Sample Financial Con Investor Subscriptions o x C0R5516 Participating Investors a Investor ID GAMJUL a Julie Gambol a AdvNum AdvDate Available Subsc
183. is also flagged as a Write off If an overpayment is left it may be applied to the account for later reconciliation provided you have set up a code for On Account Receipt in Template Setup see Section 5 2 Typically if a borrower overpays you may keep overpaid amount for application to future billings If you do not check this box the overpayment is applied to the principal Page 250 Chapter 12 Borrower Receipts Add Click to add a new record Save Click to save an existing record It is high lighted only when the user changes a field Delete Click to delete an existing record Reverse Click to reverse a posted receipt see section 12 9 Apply If you want to apply the amount without selecting outstanding billing in Principal and Interest Tab you may click Apply to apply the amounts automatically SYNDi applies to oldest interest first followed by Miscellaneous Charges and finally to Principal Close Click to close the screen i 3 To enter a new borrower receipt click New to clear the screen and hit lt Tab gt Enter Borrower ID and hit lt Tab gt again or select a borrower by clicking the Finder button If the borrower has outstanding balance the system displays a table listing unapplied billing records for the specified borrower The outstanding transactions can be viewed and modified by switching to Principal and Interest tab 4 Click Add to add the receipt 5 To modify an existing record enter t
184. ista and Windows 7 You can run SYNDi on Windows Vista and Windows 7 You will have to make the following modification to your Windows configuration 1 Launch MSCONFIG from Run menu 2 Click on Tools a Serall dawn till van find Disahle HAC Click an that line ta hinhlinht Click Next to continue Cancel 14 Click Next to complete the setup SYNDi Loan Management System SYNDi Loan Management System has been sucessfully installed Click Close to exit 15 Click Close to exit setup SYNDi Loan Manager User Manual Page 17 Chapter 2 Installation 16 Browse through the Application Folder e g c Program Files S YNDi It must contain the following files SYNDi exe SYNDi Program Files SYNDiSample mdb Database for a sample company to understand the functionality of the program BlankS YNDi mdb Blank database to be used later to build the database for your system PLEASE DO NOT MODIFY OR DELETE THIS FILE SYNDi User Manual pdf User manual for SYNDi Loan Manager Print it for handy reference Microsoft Office User manual to integrate SYNDi Integration pdf Loan Manager Microsoft Office PayoutStatement dot Microsoft Word template file to print Payout Statements MasterDischargeNotice dot Microsoft Word template file to print Borrower Discharge Notice InvestorDischargeNotice dot Microsoft Word template file to print Investor Discharge Notice CheckLayout dot Microsoft Word template f
185. it also backs the Next Billing Date so that you can run that billing again SYNDi Loan Manager User Manual Page 286 Chapter 16 Loan Transfer 15 3 Accounting Interface Accpac Interface 1 This screen is used to perform two functions a Downloading Chart of Accounts and Banks from Accpac into SYNDi b Transferring entries to Accpac A R A P and G L This function downloads Chart of Accounts and Banks from Accpac 2 Transfer to Accpac Transaction Date From 08 04 2013 to 08 04 2013 This function transfers accounting entries to Accpac All receipts are transferred as Misc Receipts to Receipts batch in A R All payments are transferred as Misc Payments to a Payments batch in A P All non banking entries are transferred to a journal entries batch in G L Process a Download from Accpac 2 Click the first choice and then click Process to download Chart of Accounts and Banks from Accpac into SYNDI It should be performed as soon as SYNDi is integrated with Accpac as shown in Section 4 3 Integration Tab or when a new G L account is set up or a new bank is defined in the accounting package This process deletes existing data from Accounts and Banks tables and copies new data into the tables 3 This function deletes existing accounts and banks from SYNDi and copies new information into the tables 4 If any existing templates or Miscellaneous Charge Codes use G L accounts th
186. it displays Tree Menu as shown below SYNDi LMS Menu Sample Financial Company a 6 6 6 6 BS g a D 5 El Optional Fields Notice that there are four basic functions Setup Transactions Periodic Processing and Reports amp Inquiries in the left pane of the window Every function performed in the program falls into one of these categories The items under each category are displayed in the right pane You can click on the plus sign on any function to expand the items within that function Assuming that you have successfully logged into SYNDi Loan Manager and are running Sample Data click on the plus sign to expand Borrowers and a list of all borrowers is displayed Click on any borrower to display the borrower record Once a category or an item has been expanded by clicking the plus sign it is changed to a minus sign and can be collapsed back by clicking on the minus sign Notice the following icons on top of the menu You can perform each function by a single click Page 24 Chapter 3 Running the Application Classic Menu Close Center Setup Transactions Periodic Processing Reports and Inquiries SYNDi Loan Manager User Manual Removes the Tree menu and displays the Classic menu If you switch to Classic menu you will remain on it when you log in next time unless you switch back to Tree menu Close SYNDi Loan Manager Determines the position where each SYNDi Loan M
187. it keeps on changing each year Please enter the 2 numbers and click Continue to step two button If these numbers are valid the website will take you to the next screen otherwise it will give you an error Error 050 Authentication failed Check your Account Number then try again Internet File Transfer Authentication Windows Internet Explorer Ge https arc gc ca ebcijleb0 uploac aC slidate BIB 4 x P Live Search File Edit Yiew Favorites Tools Help H Favorites Ss H Suooeste Free Hotmail Web Slice Gallery Internet File Transfer Authentication a gt Gl Sl dh pager Safety Tos Bel soy teen e Canada Canada Revenue Agency www cra gc ca Francais Contact Us Return to Filing Internet File Transfer XML Information rsa To file your electronic information return you must provide the following information Electronically Step1 Identification area Need to retrieve your Web access code Error 050 Authentication failed Check your Account Number then try again Your Account Number 123456789RZ7946 Note Do not enter dashes or spaces in the Account Number AND Your Web Access code eeccee Note Your Web Access Code contains letters which are identified with an asterisk and must be entered in the same case as they appear on the correspondence you have received Continue to step two 25 Once you enter the correct information you will be taken to
188. ke interest payments The options are same as those for Billing Frequency Normally the Interest Payment Frequency is same as Billing Frequency e g Monthly In certain circumstances you may bill the borrower Monthly but may require interest payments on Quarterly basis There are four options available 1 360 Day Year in which each year consists of 360 days and is divided into 12 equal months with 30 days in each month 2 365 Day Year in which each year consists of 365 days with no interest calculated on February 29 of a leap year 3 Exact Year in which each normal year consists of 365 days while a leap year consists of 366 days 4 12 Month Year in which each year consists of 365 days and is divided into 12 equal months with 30 416667 days in each month 5 Sum of Digits Rule of 78 According to the Page 136 Chapter 5 Working with Loans Fee Charged From Investors Warn When Interest Rate Exceeds Default Billing Day Are loans linked to Properties SYNDi Loan Manager User Manual Rule of 78 interest is calculated for the life of the loan and then allocated to each month by proportion using reverse sum of the digits methodology See Notes 6 to 9 in Section 1 2 The first method is suitable for payment frequencies based on months while the other two methods are recommended for weekly and bi weekly payments If Method 1 or 4 is used as the Default Calculation Method it will be used for loan
189. lance If no outstanding Balance is found the LTV Ratio is zero otherwise it is Balance Base Value X 100 As the balance on loans linked to a property decreases due to blended payments or discharge of one or more loans the LTV Ratio decreases accordingly SYNDi Loan Manager User Manual Page 164 Chapter 5 Working with Loans Details Tab 4 This tab displays balances on all loans related to the property including Other Loans It also contains three descriptive fields for Notes related to the Property Notes 1 Outstanding Loans P Other Loans Save Delete 5 The Number of Units field can be used for instance to enter the number of apartments in a building Normally it should be set to 0 If you are printing Loan Documents the figure will be used for Investor Disclosure see Chapter 17 SYNDi Loan Manager User Manual Page 165 Chapter 5 Working with Loans 5 5 Fund a Loan Please see Borrower Payments Chapter 8 SYNDi Loan Manager User Manual Page 166 Chapter 5 Working with Loans 5 6 Enter Miscellaneous Charges If SYNDi is interfaced with QuickBooks it is necessary that QuickBooks be open with the right company when you enter this screen 1 Click Mise Charge on the Details tab of Loan Maintenance screen to display the following screen SYNDi LMS Misc Charge Entry Sample Financial Company
190. late ID CONVERT Q Converted from previous version Borrower ID BLOM g fimBlouski lt Citi s S Description Avenue Steet Plaza Principal 100 000 00 Down Payment oo Balance 98 436 42 Payment 795 36 Start Date 0170172010 Hii Interest Rate Fixed Variable J 8 5000 Term 60 Months O Days Actions Status Ma fete __Funding _ Discharge Stop Billing a MiscChge Adjustments In Process il Loan Docs Save Delete Profile Amortization Investors Inquiry Close 5 The fields shown on the screen are described below Loan ID A code set up to identify a loan maximum 16 alphanumeric characters user defined It is recommended that the first six characters of Loan ID be unique g Finder is used to display a list of all records in the Loans table You may choose to search loans either by Loan ID Loan Description Borrower ID or Borrower Name You may also filter the list to include loans with given Loan Status Scroll is used display previous or next record T by hitting up or down arrow New is used to clear the screen while setting up a new record Template ID Enter the ID of the template that will describe the loan SYNDi Loan Manager User Manual Page 145 Chapter 5 Working with Loans Borrower ID a a Description Principal Down Payment Start Date Interest Rate Term a SYNDi Loan Manager User Manual Enter the Borrowe
191. lays the interest to be paid in the current receipt MiscChgDue Displays outstanding Miscellaneous Charges SYNDi Loan Manager User Manual Page 252 Chapter 12 Borrower Receipts billed MiscChgRec Miscellaneous Charge Received Displays the Miscellaneous Charges to be paid in the current receipt Select All Check to enter Yes in the Apply column of each row Select None Check to enter No in the Apply column of each row 3 Double click on No under the Apply column for the billing record if more than one for which the receipt is being entered The table shows all billing in the descending order of billing date You may be interested only in the first few records since older records may have just some unpaid NSF charges which will be cleared at the time of Loan Discharge 4 The following figure shows the second record selected The Interest Received field displays the same amount as Interest Due field assuming that you want to apply the entire amount SYNDiLM Borrower Receipts Sample Financial Co TOX Menul Receipts Entry Principal and Interest Misc Charges Unapplied Cash Deductions Principal and Interest SelectAll Select None Apply BilingDate PrincipalDue _ PrincipalRec _ InterestDue _ InterestRec __ MiscChqDue MiscChaRec gt 05 01 201 0 00 0 00 0 00 0 00 150 00 150 00 04 30 2014 4 939 77 0 00 03 31 2012 4 945 76 0 00 02 29 2012 4 951 71 4 951 71 01 31 2012 4 956 92 4 956 92
192. lick to add a new record Click to save an existing record It is highlighted only when the user changes a field Page 317 Chapter 17 Loan Documents Delete Click to delete an existing record Close Click to close the screen SYNDi Loan Manager User Manual Page 318 Chapter 17 Loan Documents Tab 2 General Information 5 The tab is displayed as follows General Information Contract Number Agent ID Mortgage Amount Closing Date Term months Payments per year Amortization years Compounding N A Rate m SYNDiLM Loan Documents Sample Financial Co o x C0R5516 CORVETTE BONJAM QJ JamesBond n 1 235 000 570572011 36 Maz Mo First Payment Date 06 01 2011 Last Payment Date 0570572014 Maturity Date 05 05 2014 35 Rank First Mortgage Payments Payment Amount Agent License No only l 9 777 08 B2089123 Save Delete Lenders 0 6 The fields shown on the screen are described below Contract Number Agent ID Mortgage Amount Closing Date Term months Payments per year Amortization years Compounding SYNDi Loan Manager User Manual User defined code to identify the loan It may or may not be same as Loan ID The agent is defined in Other Parties Total amount of mortgage which could be advanced in 1 to 6 installments Start Date of the loan Defined in Loans Table Calculated from Payment Frequency of th
193. lick to add a new record Click to save an existing record It is high lighted only when the user changes a field Click to delete an existing record Click to close the screen 3 To enter a new investor payment click New to clear the screen Hit lt Tab gt Enter Loan ID and hit lt Tab gt or select a loan by clicking the Finder button If there is no outstanding borrower receipt to be distributed the following message is displayed SYNDi Loan Manager User Manual Page 268 Chapter 13 Investor Payment Message ee There are no receipts from borrower that can be applied to this payment OK 4 If there are outstanding borrower receipts waiting to be distributed the system displays the outstanding amounts If there are more than one billing records for a loan the billing dates are displayed in the descending order 5 Choose the billing date for which the borrower receipt has to be distributed 6 Enter Payment Date and hit lt Tab gt 7 Click Investors Tab to display the principal interest fee N R Tax and sales tax for each investor SYNDi LMS Investor Payments Sample Financial Company BEE Menu Payments Entry avestas Misc Charges investor _ BINSEB 2364 0 0 7167475 0 00 E GOLBAR 2362 oa 138544 831 0 00 41 HIGBAR 236 0 0 395 84 237 0 00 1 19 _ JINJOH 2371 0 0 59375 356 0 00 1 78 _ KNOBEN 2368 na 197 92 11 88 0 00 05
194. ll GZL entries that you are going to delete This function will delete all GZL entries up to the cut off date given below If this date is not acceptable Cut off Date UPEP Process The fields shown on the screen are described below Cut off Date Displays the last date of the previous month You may change this date if necessary The system deletes all G L entries up to and including the cut off date Process Click to delete G L entries with transaction date up to and including cut off date SYNDi Loan Manager User Manual Page 283 Chapter 16 Loan Transfer Close Click to close the screen 4 If no entries are found with transaction date up to cut off date the following message is displayed There are no entries with the specified cut off date to be deleted OK 5 If one or more entries are found with transaction date up to cut off date a message similar to the following screen is displayed i 18 entries will be deleted Do you want to proceed 6 Click Yes to delete the entries SYNDi Loan Manager User Manual Page 284 Chapter 16 Loan Transfer 15 2 Cancel Latest Billing 1 One or more latest billing runs can be cancelled for a particular loan provided no borrower receipt has been entered 2 Click Cancel Latest Billing on Periodic Processing Menu to display the following screen m SYNDiLM Cancel Latest Billing Sample Fina Loan ID AVE 1077 Avenue Street Pl
195. llment received from borrowers are entered using this function Enter receipts from borrowers print unposted receipts and bank deposit slips and post transactions After the monthly installment has been received from the borrower this function is performed to distribute the amount payable to each investor Enter payments print unposted transactions and payment statement and post transactions Investors can withdraw during the term of a loan and be replaced by new investors in the syndicate Enter transfer of funds from one investor to another investor print unposted transfers and post transfers Periodic Processing is run to delete old General Ledger journal entries closed loans inactive borrowers and investors and other unnecessary pieces of information It also Page 27 Chapter 3 Running the Application cancels the latest billing if necessary Reports and Print various reports generated by the system Inquiries or view them on the screen SYNDi Loan Manager User Manual Page 28 Chapter 3 Running the Application 3 4 Setup Menu 1 Setup Menu is displayed when the user clicks the Setup icon on the Main Menu SYNDiLM Setup Menu Sample Financial G L Accounts Si Borrowers Banks Reminders Other Parties 2 2 Sh Investors 2 Company Profile c a a s a Optional Fields Investment Types Misc Charge Codes Brokers Commission Prime Rates SYNDiService 2 2 2 2 gt 2 I
196. lows Residential Commercial Industrial Land e g Vacant Lot Other e g Mobile Home Other e g Place of Worship Other e g Theatre Other e g Heritage Property Other e g Golf Course O CO YE DV MN BY GQ DN Re Step 4 Define Ranks Each Loan must have a Rank that specifies mortgage type Please refer to Section 5 3 to set up Ranks The valid Ranks for Loan Documents to work properly are as follows First Mortgage Second Mortgage Third Mortgage Other Other Other Other Other CO OD MN BPG NW Re SYNDi Loan Manager User Manual Page 313 Chapter 17 Loan Documents Step 5 Set up Other Parties SYNDi treats all entities other than Borrowers and Investors as Other Parties Thus Mortgage Agents Lawyers Guarantors and Appraisers are Other Parties See Section 4 12 to learn how to set up Other Parties Before you set up Other Parties you will need to set up Party Types as shown in Section 4 12 Following are some recommended Party Types Agent Guarantor Lawyer Appraiser TITIA LS You may define other Party Types as you need When you set up an Agent make sure that you enter his her License Number in the Remarks field Step 6 Set up Agents Signature Files SYNDi can embed the Agent s electronic signature on a document The signature file should be saved as Agent D jpg
197. ly if you have indicated in Company Profile that you are using eS YNDi to provide web access to the borrowers to display their records When a new borrower is set up the User ID is same as BorrowerID However you may change it if required The program checks to ensure that each User ID is assigned to one and only one borrower Page 103 Chapter 4 Setting up the Application Password This field is displayed only if you have indicated in Company Profile that you are using eS YNDi to provide web access to the borrowers to display their records When a new borrower is set up the password is set as password all lower case characters and no quotes When borrowers log into their eSYNDi account for the first time they must change the password for future access Add Click to add a new record Save Click to save an existing record It is highlighted only when the user changes a field Delete Click to delete an existing record Close Click to close the screen ii 6 To set up a new borrower click New to clear the screen Enter Borrower ID If the record is already present in the table the data is displayed and the fields could be modified 7 You may hit lt Tab gt key to move from one field to the next Alternatively you may click inside a field and modify it 8 If you do not click the New button while entering a new record the data from the previous record remains on the screen You may change any fields if ne
198. m Contact Us Help Search Filing inf jon returns electronicall Internet file transfer XML Forms and publications If you use payroll commercial or in house developed software to manage your busine you can submit files of up to 150 MB over the Internet using the Internet file transfer AEE application Use this method to file original or amended T1204 T215 T3 T4 T4A T4 E T O OAS T4A P T4A NR T4E T4RSP T4RIF T5 T5007 T5008 T5018 NR4 AGR 1 RR Site map Contribution Receipts Return SAFER or TFSA information return New for 2013 you car now submit a T550 APPLICATION FOR REGISTRATION using the Internet file transfer Individuals portal Business SE Enter Internet file transfer XML secure Web site Other groups Search CRA Need to retrieve your Web access code Topics for Internet file transfer XML How to file using Internet file transfer SYNDi Loan Manager User Manual Page 305 Chapter 16 Loan Transfer 23 Click the button Enter Internet file transfer XML secure Web site the next page will be the Disclaimer Internet file transfer Go to the bottom of the page and click I Agree 24 Once you click I Agree button you will go next web page where you will be asked to enter your Account Number and the Web Access Code The Account Number is the number that was assigned to your company by CRA The Web Access code is sent to you by CRA every year and
199. ment Discharge SYNDi Loan Manager User Manual Fly is used to set up a Rank Code on the fly When a loan is set up initially the status is set to 1 Active and may be changed as necessary If the status is changed to a code for which the Stop Billing indicator is checked see section 4 7 billing ignores the loan When a loan is discharged the status is changed to 0 paid out When a new loan is set up the In Process flag is set automatically It simply stops the program from posting investor receipts The objective is to set up the loan initially and get commitments from investors as you go through the marketing process As you enter investor receipts they are just considered commitments and do not get posted In the meantime you may delete those receipts if the commitment is withdrawn or change the amount as necessary Once all contributions from investors have been finalized and actually received you may fund the loan which posts investor receipts removes the In Process flag Prompts the user to enter miscellaneous charges allocated for loan discharge and enters borrower payment to fund the loan Once the loan is funded it is ready for regular processing After the loan has been set up and all investor receipts have been entered and posted click to display Borrower Payments screen Chapter 8 Click to set up miscellaneous charges other than those set up for loan discharge Section 5 7 Click to enter a
200. mounts becomes less than the maximum rounding error 5 You may hit lt Tab gt key to move from one field to the next Alternatively you may click inside a field and modify it SYNDi Loan Manager User Manual Page 230 Chapter 10 Billing 10 6 Misc Charge Tab 1 The Misc Charge tab is displayed as follows SYNDi Edit Billing Data Sample Financial Company Borrower Investors 5 LoanID DAMPLA InvestorID BARJIM Investment Number 2727 MiscChgID Description Amount b INTCAL Late Payment Charge Close 2 The fields shown on the screen are described below Loan ID Investor ID Investment Number Investment Table Save SYNDi Loan Manager User Manual Displays Loan ID for which miscellaneous charges are being edited Investor ID is displayed only if you are editing miscellaneous charges for an investor Investment Number is displayed only if you are editing miscellaneous charges for an investor Displays a list showing Miscellaneous Charge Code Description and the amount for each charge To change the amount just highlight it type the new amount and hit lt Tab gt If you do not wish to apply a charge change the amount to zero Click to save changes made to any of the amounts Page 231 Chapter 10 Billing 3 Ifyou have changed a miscellaneous charge you must click Save before you click Borrower or Investor tab 4 If you come to
201. mple Financial Company Access may include reading and modifying QuickBooks data as well as enhancing the QuickBooks user interface The Application Calls Itself SYNDi Loan Management System Certificate Information This application does not have a certificate QuickBooks cannot verify the developer s identity r QuickBooks Solutions Marketplace Search for information about this application at the QuickBooks Solutions Marketplace Do you want to allow this application to read and modify this company file C Yes prompt each time C Yes whenever this QuickBooks company file is open Yes always allow access even if QuickBooks is not running E Allow this application to access personal data such as Social Security Numbers and customer credit card information Tell me Continue Cancel Help 27 Click on Yes whenever this QuickBooks company file is open and the click Continue The following screen may be displayed Confirm to Proceed ep This application is not signed with a digital certificate IF you allow unsigned applications to v7 access your file a different application could use the same application name and possibly misuse your data For suggestions about enhancing the safety of your company s data click Help 4re you sure you want to allow this access 28 Click Yes to allow access to SYNDi QuickBooks confirms permission to access the data by displaying the following
202. n Excel macros which will import relevant data and massage it All such Excel worksheets should be save in dblocation Templates CustomReports folder SYNDiLM Reports Menu Sample Financial Master Listings Transaction Listings Letters Custom Reports SYNDi Loan Manager User Manual Page 40 Chapter 3 Running the Application 2 Master Listings SYNDi LMS Master Listings Menu Sample Financial Company Loans Borrowers Client Profile Banks Summary Reminders G L Accounts Investor Detail Investor Summary 3 Transaction Listings Borrower Reports m SYNDiLM Transaction Listings Menu Sample Fina 15 x 3 Investor Reports ReportDescription Please select a report Aged Accounts Receivable gt eal Amortization Schedule O Billing Reports O Delinquency Summary Report G L Detail Report G L Summary Report Loan Balance Summary Loan Expiry Report toon Matiy Repo toon Statement Loans Due for Repayment O Misc Charges Report Paid Out Report _ Principal Recovered SYNDi Loan Manager User Manual Page 41 Chapter 3 Running the Application Investor Reports SYNDiLM Transaction Listings Menu Sample Fina a a a S E a 2 E E a E a 4 Letters You may design customized letters to borrowers investors and other parties using Mail Merge in
203. n and enter Loan ID If the record is already present in the table you may modify it or delete it provided it has not been posted However if the adjustment has been posted the system displays the following message Message eee This Adjustment has already been posted You will not be able to delete it or save any changes to this payment 4 You may hit lt Tab gt key to move from one field to the next Alternatively you may click inside a field and modify it 5 To modify an existing record enter the Loan ID or use Finder to select a record If the record has not been posted enter various fields and click Save to save changes 6 To delete a record click Delete You cannot delete a record that has already been posted SYNDi Loan Manager User Manual Page 211 Chapter 9 Loan Adjustments 9 3 Increasing Loan Amount 1 The borrower may require additional amount before the loan is discharged In this case the amount should be entered without minus sign in the Principal field Notice that the interest and penalty fields under Adjustment Amount disappear SYNDi LMS Loan Adjustments Sample Financial Company BEE Menu Loan Adjustments Entry Investors Adjustment Number NEW BJO Loan ID BIR1160 a iD 160 Birchmount Road Date josyi6 2007 BE Date Range 03 10 2007 to 04 09 2007 Document No 21753 Paid to Khan Associates Barristers Rate 9 5000 Balance 725 000 00 Penalty 3 months St
204. n the Main Menu are as follows Setup Setup menu is used to set up borrowers investors loans and various parameters used by the system Loans and Set up new loans modify loan records fund Properties discharge and renew loans and enter adjustments and sundry transactions Maintain Properties SYNDi Loan Manager User Manual Page 26 Chapter 3 Running the Application Investor Receipts Billing Misc Transactions Borrower Receipts Investor Payments Investor Transfers Periodic Processing SYNDi Loan Manager User Manual Enter receipts from investors for new loans print unposted receipts bank deposit slips posted receipt and post transactions The Billing process calculates the monthly installment for each loan and bills it to the borrower If all installments are payable on the same day says the last day of the month billing will be run once a month otherwise it is run several times a month and picks up only those loans for which the payment is due The procedure also distributes interest and principal if any to investors in proportion of their contribution and calculates miscellaneous charges and deductions This function is used to enter unapplied cash receipts from borrowers Such receipts can be applied later to individual billings You can also use this function to bill or receive service charges such as NSF fees etc on ad hoc basis After billing has been run checks for loan insta
205. n the current receipt 3 Ifthe Amount is being partially paid or not being paid click on the amount in Amount Received column to highlight it Type the new value and hit the lt Tab gt key SYNDi Loan Manager User Manual Page 255 Chapter 12 Borrower Receipts 12 7 Unapplied Cash Tab 1 The tab is displayed as follows SYNDiLM Borrower Receipts Sample Financial Co TOX Menu Receipts Entry Principal and Interest Misc Charaes E Unapolied Gashi Deductions Unapplied Cash C Select All Select None matt ete bere dap Peel p No 05 02 2012 0 0 Milt Accaurt Recess Unapplied Cash 5 000 00 2 This table contains unapplied receipts entered earlier Chapter 11 If you want to apply any of them double click on No under the Apply column and change Amount Received if necessary 7 Click on Receipts Entry tab and make sure that the Total Applied Amount is equal to the Receipt Amount entered earlier 8 Click Add to add the receipt 9 Overpayments Overpayments can be entered only if the Receipt Amount exceeds Total Amount Due and all outstanding transactions are fully applied The extra amount reduces the principal unless you check On Account in which case it is left unapplied for future receipts SYNDi Loan Manager User Manual Page 256 Chapter 12 Borrower Receipts 12 8 Deductions Tab 1 The tab is displayed as follows SYNDiLM Borrower Receipts Sample Financial Co OX
206. ned Finder is used to display a list of all loans in the temporary billing data table Scroll is used display previous or next loan by hitting up or down arrow New is used to clear the screen Principal amount billed to the borrower The total principal distributed to investors is shown next to it If the difference between the two amounts is greater than the maximum rounding error set in the company profile error code 5 is assigned Interest amount billed to the borrower The Page 227 Chapter 10 Billing total interest distributed to investors is shown next to it If the difference between the two amounts is greater than the maximum rounding error set in the company profile error code 6 is assigned Miscellaneous This entry shows various charges applied in the Charges billing run The amounts can be edited by switching to Miscellaneous Charge Tab Discharge Penalty If the loan is being discharge earlier than the normal maturity date The program calculates Discharge Penalty which is equal to the interest for the number of months specified in the Loans record Fix The principal or interest on borrower side may not be equal to the corresponding amount on the investor side due to rounding issues If there are penny differences you may click Fix to change the amounts on the Borrower side and save the record Click to save changes made to any of the amounts It is highlighted only when the user changes a fi
207. new or existing folder enter one below or click Browse Folder CAProgram Files SYNDi Browse SYNDi Loan Manager User 15 Cancel Previous Chapter 2 Installation 11 Read the License Agreement carefully as you scroll through the text If you do not agree with the agreement click Cancel to exit the setup otherwise click I Agree and then click Next to proceed to the following screen 12 Notice that the default folder in which the software will be installed called Application Folder is C Program Files S YNDi If you wish to install it on a network drive or another local drive or in another directory click Browse button and browse through the directory structure to choose the desired drive and directory e g L S YNDi and click Next to display the following screen SYNDi Loan Management System The installer is ready to install SYNDi Loan Management System on your computer Click Next to start the installation Cancel Previous 13 Click Next to copy necessary files into the specified folder When the copying is finished the following screen is displayed SYNDi Loan Manager User Manual Page 16 Chapter 2 Installation i SYNDi Loan Management System READ ME a You will need an Installation Key and Activation Code from INDUS SYSTEMS in order to activate this application In the meantime you may use the software for 30 days RUNNING SYNDi on Windows V
208. ng package Normally SYNDi Loan Manager is set up as a standalone package but could later be interfaced with Sage Simply Accounting Sage ACCPAC ERP or QuickBooks 9 If SYNDi Loan Manager is being interfaced with any of the accounting packages through ODBC enter the DSN Name in the DB Name field exactly as it is defined in the system The DB Name should contain the database name which should be same as Company ID defined in Accpac The connection is made through SQL Server Native Client for downloading accounts and banks and through Accpac API in case of uploading batches 10 Incase of Simply Accounting interface the program enters sysadmin in the User ID field If you have set up security in the accounting package enter the password that will successfully open the package otherwise leave it blank In case of ACCPAC ERP or QuickBooks interface the User ID and the password fields are not displayed 11 IfSYNDi is integrated with Accpac ERP and you want to generate a single journal entry for each billing batch then set Posting Level to Summary If you have set it to Detail a separate journal entry will be SYNDi Loan Manager User Manual Page 78 Chapter 4 Setting up the Application generated for each loan 12 If you will write manual checks for borrowers and investors in Accpac ERP check Write check in Accpac box When you transfer entries to Accpac all payments will be transferred to Payments batch in A P modul
209. ng is run Set up names and addresses of parties other than borrowers and investors such as corporate lawyers handling loans Tax authorities to whom property tax is remitted other vendors etc 4 The items on the Setup screen are listed in the order in which you will use them For instance the first item is G L Accounts since you cannot perform any function without setting up the account set 5 When you set up the system for the first time it is important that you follow the sequence shown on the screen SYNDi Loan Manager User Manual Page 31 Chapter 3 Running the Application 3 5 Loan and Properties Menu 1 Loans and Properties Menu is displayed when the user clicks the Loans and Properties icon on the Main Menu m SYNDiLM Loans and Properties Menu Sa Properties Loans Ej Properties g Templates Property Types Loan Status Codes Property Categories Ranks Property Classes Loan Transfer 4 The items listed on the left side of the screen are related to Loans while the items on the right side are related to Properties If you do not link loans to real estate properties the items on the right side are not displayed 5 The items included on Loans and Properties Menu are as follows Loans This screen is used to set up a new Loan review or modify an exiting Loan record or to delete an inactive Loan Templates Every Loan must have a Template which determines various settings for the L
210. ng with Loans The transaction is applied at the time of advancing the loan to the borrower while initially funding the loan You cannot choose this option once the loan has been funded Miscellaneous charges such as Brokerage Fees could be entered under such Miscellaneous Charge Transactions applied to loan advance cannot be distributed to investors When this option is chosen the investor percen tage is automatically changed to zero If you have already funded the loan but have not posted Borrower Payment you can still enter a miscellaneous charge to be applied to loan advance but you cannot change it or delete it unless you delete the borrower payment first If the borrower payment has already been posted you cannot enter any miscellaneous charge to be applied to loan advance and cannot change or delete existing charges You can apply a charge to loan advance only if the investor percentage is zero Quarterly The transaction is applied after every three months and remains active until the user renders it inactive Semi annual The transaction is applied after every six months and remains active until the user renders it inactive Annual The transaction is applied after every twelve months and remains active until the SYNDi Loan Manager User Manual Page 169 Chapter 5 Working with Loans Last Billed Next Billed Active Unapplied Amount Add SYNDi Loan Manager User Manual user r
211. note to stop popping up delete the note or uncheck Remind Me checkbox and save the note 3 If you want to postpone the pop up change the Reminder Date and time and save the note 4 When you start SYNDi Loan Manager and enter Main Menu Classic or Tree view for the first time all reminders on which reminders are due are displayed Once they are closed they will subsequently be displayed after the interval set in Company Profile SYNDi Loan Manager User Manual Page 129 Chapter 4 Setting up the Application 4 12 Other Parties 1 Click Other Parties on Setup screen to display the following screen m SYNDiLM Other Parties Setup Sample Financial Ga m d N ame and Address PartyID SMIJOH apol Party Type O Other Party LastName Smith C Corporate Address 7481 Woodbine Avenue Suite 203 lUpperFlor lt is sSCS City Markham State Prov on Postal Code L3R 2w1 Country Canada Tel 905 940 0751 Fax 905 940 0341 E Mail finfo indusssys com SS Contact John or Boo Remarks FirstName John Save Delete 2 The fields shown on the screen are described below Party ID a Party Type First Name SYNDi Loan Manager User Manual A code set up to identify the other party maximum 16 alphanumeric characters user defined Finder is used to display a list of all records in the Lawyers table Scroll is used display previous or next record by hitting up
212. nsit Number consists of a 4 digit Inistution Number of the bank followed by a hyphen followed by a 5 digit Branch Number If the Institution Number is less than 4 digits add zeroes on the left For instance if the Institution Number is 016 and the Branch Number is 20715 the Transit Number will be 0016 20715 SYNDi Loan Manager User Manual Page 117 Chapter 4 Setting up the Application Account No Default Investment Type Plan Type Plan Number Trustee D Default Payment Cycle SYNDi Loan Manager User Manual If payments have to be made through direct deposit enter the Bank Account Number of the investor 7 to 12 numeric characters User defined field can be left blank You may also set up valid Investment Types by clicking Fly When a new investor receipt is entered the default Investment Type specified in the Investor record is used but the value could be changed For Canadian users valid Investment Types are as follows 1 Individual 2 Joint 3 Corporation Association etc 4 Saving Plan e g RRSP RRIF etc Trust 5 Government These types are used while generating annual T 5 slips If the Investment Type is 4 registered Investment you should enter the Plan Type You can define Plan Types by clicking the Fly button Enter the Plan Number for the investor if it is a Registered Invertment A Trustee is normally a bank that is holding the Registered Investment
213. nsure that it performs in accordance with our specifications e Your unlimited access to INDUS Support Services Hotline for assistance during normal INDUS business hours Training is not included this is for support services only e our supply of updates to the Software and documentation that in our opinion have universal appeal to be delivered through scheduled product updates The following services are not covered by any Licensing and Support Fees data conversions custom programming report and special forms creation unless specifically indicated user training including excessive use of our Hotline because of a lack of training or comprehension on site visits to Your site by our support staff applicable costs related to installation of updates including conversion training installation shipping media etc diagnosis and correction of third party software and or hardware problems such as network and printing problems new modules which INDUS deems to be considered separate to the Software and outside of the update process services required as a result of any modifications to the Software performed by anyone other than INDUS personnel data recovery and other services required as a result of failure of Your computer or network environment If You fail to pay the Annual Licensing and Support Fee if applicable within 90 days of an anniversary date we have the right to cancel Your Licence at which time You will forfeit Your right to contin
214. nt Pour obtenir des renseignements Devises trang res Num ro de compte du b n ficiaire lisez le verso Privacy Act Personal information Bank number CRA PPU 150 and CRA PPU 005 Lai sur 1a protection des renseignements personnels Fichiers de renseignements personnels ARC PPU 150 et ARC PPU 005 T5 12 to Canada Revenue Agence du revenu Year T 5 Agency i Conde 2012 STATEMENT OF INVESTMENT INCOME Dividends from Canadian corporations Dividendes de saciet s canadennes Federal credit Cr dit fed ral Ann e ETAT DES REVENUS DE PLACEMENTS Acualameuni d sigtle dividends 25 Taxable amount cf sligbe dividends Dividend Fri atgele Interest from Canadian sources 18 Capital gains dividends 20024 88 i pa Montantimposable dos dvdendes Sa aidan A Montant rl des Giidenden diterriv s gi ra Cr dit diemp t pour dividendes d termin s Int r te de scurce canadienne Dividendes sur gains en capital Actual amount of dividends Taxable amount cf dividends Dividend tax credit for dividends ji i n ther than eligible video olaran sighedvidends 12 char han olgble didenda Raport Code 22 Radipiant klentitcation number 22 Recipient typ ie 123456789 1 Montant r el des dividendes Montant imposable des dividendes Cr dit d emp t pour dividendes gt iii ures que dee dividendes ditermin s autres que dss dhidendes d termings autres que dea dividendes determin s
215. num we have P 100 000 and i 9 the interest for 21 days is l 100 000x lt 21 517 81 365X100 11 In order to calculate blended payment P4 for certain number of days d multiply the payment amount Pn by 12 and divide the result by 365 to get one day s payment which when multiplied by the number of days will give the required result Thus 12Xd P P lt d m 365 Thus if the monthly blended payment is 804 62 as calculated in step 7 above the payment for 21 days is P 804 62X Z2 _ 555 52 365 12 The principal portion of the payment can be obtained by subtracting from it the interest portion i e 555 52 517 81 37 71 13 The interest in the example quoted in this section will be calculated according to the following amortization schedule Month Principal Payment Interest Principal Balance 1 100 000 00 804 62 750 00 54 62 99 945 38 2 99 945 38 804 62 749 59 55 03 99 890 35 3 99 890 35 804 62 749 18 55 45 99 834 90 4 99 834 90 804 62 748 76 55 86 99 779 04 5 99 779 04 804 62 748 34 56 28 99 722 76 6 99 722 76 804 62 747 92 56 70 99 666 06 7 99 666 06 804 62 747 50 57 13 99 608 93 8 99 608 93 804 62 747 07 57 56 99 551 37 9 99 551 37 804 62 746 64 57 99 99 493 39 10 99 493 39 804 62 746 20 58 42 99 434 97 11 99 434 97 804 62 745 76 58 86 99 376 10 12 99 376 10 804 62 745 32 59 30 99 316 80 If the term of the loan is one year the last payment will be 804 62 99 316 80 100 121 43 so that the balance is ze
216. o delete a record click Delete You cannot delete a record that has already been posted 9 RSP Accounts If the investor contribution is coming from a Registered Retirement Saving Plan RRSP it could be done as follows 1 Set up a bank with Bank ID 0000 followed by a 5 digit Branch ID Enter a description such as RSP Account for Bank Name and the name of the institution for the Branch Name e g 0000 00001 RSP Account Scotia Bank 0000 00002 RSP Account TD Trust 2 While entering the investor receipt enter one of the banks defined for RSP Accounts in Bank ID field and the RRSP account number in the Account Number field 10 Interest Free Loans While entering an interest free loan enter the interest rate as 0 fixed If a fixed dollar amount has to be recovered on monthly basis set the Payment Type as Blended amortized over the period of the loan Enter the installment amount in the Payment Amount field Consider a 12 000 interest free loan over one year period such that the borrower will pay 1 000 a month Set Payment Type to Blended Compounding to None and Amortization Period as 12 months Set the Payment Amount to 1 000 SYNDi Loan Manager User Manual Page 187 Chapter 6 Investor Receipts 6 6 Menu Tab 1 The tab is displayed as follows SYNDi LMS Investor Receipts Sample Financial Company BEE Receipts Entry Terms Activity Opt Fields Print Unposted Receipts Print B
217. o you want to send a letter to the borrower Yes No Click Yes to display the letter and print it The letter is saved automatically as JoanID_ReverseReceiptNumber_NSF doc The template for the letter NSFLetter dot is located in Templates sub folder of Database Location In order to change the layout of the letter you may edit NSFLetter dot in Microsoft Word SYNDi Loan Manager User Manual Page 259 Chapter 12 Borrower Receipts Sample Financial Company 7421 Woodhme Avenue Suite 203 Maxkham Ontario L3R 271 Ta 905 940 0751 Fax 905 940 0341 Nowember 4 2003 Goldberg Realty 1160 Bircomourt Road Scarborough Ontario MI1P 2B3 PAYMENT RETURN ADVICE Please note that the following payment made by you has been rebumed by the bank E will be appreciated if you make amrangemerts to send your payment right amay The partioulars are given below Accomt Number WARPLAZ Description Warsak Plaza Reference Receipt Number 8420 8463 Receipt Date Dec 18 2007 Amount 11 197 93 Service Charge 150 00 Total Amount 11 347 93 Yours truly Sample Financial Compary 10 Print the letter before closing it 11 A Reminder is created to follow up with borrower SYNDi LMS Reminders Setup Sample Financial Company Reminder ID 1 a Reminder Type C General Loan Borrower Other Loan ID BIR1160 a 1160 Birchmount Road Effective Date 0670972005 Bit at Iv 00 AM C PM Remind Me r N
218. oan record and to establish General Ledger accounts to which transactions pertaining to that Loan will be posted Before you set up the first Loan in your database you must set up a Template to which the Loan will belong You may create more than one Template if necessary SYNDi Loan Manager User Manual Page 32 Chapter 3 Running the Application Loan Status Codes Ranks Loan Transfer Properties Property Types Property Categories Property Classes When a new Loan is set up it is assigned Status Code 1 Active and when it is paid out the Status Code becomes 0 Paid Out You may define additional Loan Status Codes if necessary A user defined field You may transfer all or a portion of balance from one loan to another This feature is especially useful in case of Construction Loans where you may set up a loan as the Credit Line with zero or low interest rate and then advanced money from it to another loan as needed The Borrower ID must be same for both loans If Loans are linked to real estate properties you may set up a Property using this screen A user defined field A user defined field A user defined field 6 Following are references in this manual to various functions Loans Loans Templates Loan Status Codes Ranks Loan Transfer Properties Properties Property Types Property Categories Property Classes SYNDi Loan Manager User Manual Section 5 3 Section 5 2 Section 4 7
219. older than the current date You may change it if necessary The program selects all paid out loans with maturity date up to the specified date The Maturity Date Cut off is displayed only if you have selected to purge loans When you click Select All every record displayed in the table is marked for purge It is Page 294 Chapter 16 Loan Transfer indicated by the Process column displaying Yes When you click Deselect All every record displayed in the table which is marked for purge gets unmarked If you want to purge most of the loans displayed on the screen click Select All and then unmark the loans that you want to exclude by clicking on Yes to select it and double clicking it Process Click to perform the purge Close Click to close the screen 4 Itis suggested that you purge loans first followed by borrowers and then investors so that the borrowers and investors connected to the purged loans will also get purged provided they are not connected to other loans SYNDi Loan Manager User Manual Page 295 Chapter 16 Loan Transfer 15 5 Prepare T5 Slips 1 This module prepares T5 slips for filing tax with Canada Revenue Agency CRA on an individual or corporation s investment income These T5 slips are prepared based on paid interest or earned interest for a specific year 2 The program has the option to process print and upload to CRA T5 slips for either all or selected inves
220. on Tab 2 has been increased to accommodate the amount committed for the new advance SYNDi Loan Manager User Manual Page 329 Chapter 17 Loan Documents Tab 9 Declaration 1 20 The tab is displayed as follows SYNDiLM Loan Documents Sample Financial Cor H Ed The borrower is broker s brother in law 21 This screen is used to answer the following questions Does the broker have any interest in the property Does anyone related to the broker have any interest in the property Is the borrower related to the broker SYNDi Loan Manager User Manual Page 330 Chapter 17 Loan Documents Tab 10 Declaration 2 22 The tab is displayed as follows Declaration 2 JCORS5S1 6 Is the mortgage broker or any party with other than an arm s length business relationship to the mortgage broker acting as lender for this mortgage loan If Yes describe nature of relationship and name and address of lender Yes re iz Is the borrower related to an Officer Partner director of Brokerage I Yes ee pa Is the appraiser related to broker M Yes El Save Delete 23 This screen is used to answer the following questions Is the broker or any party with other than an arm s length business relationship to the mortgage broker acting as lender for this mortgage loan If yes describe the nature of relationship and name and address of the lender Is the borrower related to an officer partner d
221. or down arrow New is used to clear the screen while setting up a new record A two character User defined field You may set up Party Types for Agents Brokers Lawyers and other contacts Enter the first name if entering personal information maximum 29 alphanumeric characters Page 130 Chapter 4 Setting up the Application Last Name Name Address City State Prov PostalCode Country Tel Tj ax E Mail Contact Remarks Add Save Delete Close SYNDi Loan Manager User Manual iiy Enter the last name if entering personal information maximum 29 alphanumeric characters Enter the party s name if entering Corporate information maximum 60 alphanumeric characters Three address lines maximum 60 alpha numeric characters each Name of the city maximum 30 alphanumeric characters State or province maximum 20 alphanumeric characters Zip code or postal code maximum 10 alphanu meric characters Country Name maximum 20 alphanumeric characters Telephone number maximum 20 alphanumeric characters Fax number maximum 20 alphanumeric characters E mail address maximum 200 alphanumeric characters Contact name maximum 60 alphanumeric characters A user defined memo field Click to add a new record Click to save an existing record It is highlighted only when the user changes a field Click to delete an existing record Click to close the scr
222. or instance in case of monthly payments the compounding frequency would also be monthly 6 Interest Calculation Methods SYNDi allows five interest calculation methods depending on payment frequency 1 360 Day Year Each year is divided into 12 equal months with the same number of days It translates to 30 days per month or 360 days per year This method is ideal and generally accepted if the payment frequency is in units of months semi monthly monthly bi monthly quarterly semi annual or annual but is not suitable for weekly or bi weekly payments 2 365 Day Year Each year consists of 365 days with February 29 of a leap year being an interest free day It is suitable for all payment frequencies SYNDi Loan Manager User Manual Page 5 Chapter 1 Introduction 3 Exact Year In this case a normal year contains 365 days while a leap year consists of 366 days Daily interest is calculated on the basis of 365 calendar but interest is charged for February 29 as well You could use it for more exact calculations 4 12 Month Year Each year consists of 365 days and is divided into 12 equal months with the same number of days It translates to 30 416667 days per month This method is suitable if the payment frequency is in units of months semi monthly monthly bi monthly quarterly semi annual or annual but is not suitable for weekly or bi weekly payments 5 Sum of Digits Rule of 78 According to the Rule of 78 inter
223. or which the billing will be cancelled Process Click to cancel the billing Close Click to close the screen 4 The Type in the grid is B for regular billing and A for a Loan Adjustment or an Overpayment 5 You cannot cancel a billing to which you have already applied a Borrower Receipt totally or partially Thus the Balance should be same as the Total amount billed If the Borrower Receipt applied to a Billing has been reversed you will be able to cancel the billing 6 You can reverse only the latest billing ot Type B However any billing of Type A can be reversed 7 If you have reversed an old billing to Type A be aware that the interest in subsequent Regular billings was calculated on the basis of principal balance which included the cancelled billing Thismight give rise to inaccuracies and you may have to edit the next Regular billing to correct the amount if necessary 7 If no error jas been found click Process and the following message is displayed Check Save 7 Are you sure you want to cancel this billing 8 Click Yes to cancel the billing 9 Canceling billing deletes records from Billing Data and Transactions tables and generates reversing G L entries with Cancel Date as the Transaction Date It also subtracts principal billed and interest billed from the borrower and investor records and reverses miscellaneous charges fee withheld tax and sales taxes if any If you have cancelled Regular billing
224. ord It is highlighted only when the user changes a field Delete Click to delete an existing record rn EE Close Click to close the screen 3 To set up a new user click New to clear the screen Enter User ID If the record is already present in the table the data is displayed and the fields could be modified 4 You may hit lt Tab gt key to move from one field to the next Alternatively you may click inside a field and modify it 5 To modify an existing record enter the User ID or use Finder to select a record Enter the fields and click Save to save changes 6 To delete a record click Delete You cannot delete user ADMIN SYNDi Loan Manager User Manual Page 88 Chapter 4 Setting up the Application Security Levels 7 The following table specifies user rights for various functions in SYNDi Loan Manager 1 Set up Company Profile Display Change 2 Set up Borrowers Display Change Add Delete 3 Set up Investors Display Change Add Delete 4 Set up Misc Charge Codes Display Change Add Delete 5 Set up Other Parties Display Change Add Delete 6 Set up G L Accounts Display Change Add Delete 7 Setup Banks Display Change Add Delete 8 Set up Users Display Change Add Delete 9 Maintain Reminders Display Change Add Delete 10 Setup Loan Status Codes Display Change Add Delete 11 Set up Optional Fields Display Create Delete 12 Set up Loans Display Change Add Delete 13 Close Loans Process 14 Ent
225. ors CR Bank fi 020 a First City Bank Account Save Delete Print 13 This screen is used to define G L account numbers for receipts and payments It is necessary that all accounts used in the template must have been set up already as shown in Section 4 1 14 If you are providing loans in Cash the entry is debited to Loan Receivable and credited to Bank when loan is funded Payments to Borrowers However if you are providing loan in kind e g leasing equipment or selling real estate you will credit the G L account for the asset being financed instead of crediting the loan to the bank If SYNDi is interfaced with an accounting package such as Sage Accpac ERP the transaction will be transferred as Miscellaneous Disbursement in Accounts Payable module otherwise it is transferred as a journal entry in G L module 15 Enter the account number maximum 45 alphanumeric characters for each line or use Finder to select an account number from Accounts table 16 If SYNDIi is integrated with QuickBooks it uses the List ID for the account The List ID in QuickBooks is transparent to the user Just use the Finder button to access account numbers from QuickBooks SYNDi Loan Manager User Manual Page 141 Chapter 5 Working with Loans without bothering yourself with knowing or typing List IDs SYNDi Loan Manager User Manual Page 142 Chapter 5 Working with Loans Accounts Tab 2 17 The tab is displayed as foll
226. ost Payments This function marks all unposted payments as posted Posted payments cannot be modified or deleted The system displays the following message to confirm if transactions should be posted Confirm Posting Gg i Do you really want to post If you have already printed unposted payments and payments statement click Yes to post transactions SYNDi Loan Manager User Manual Page 266 Chapter 13 Investor Payment 13 3 Payments Entry Tab 1 The Payments Entry tab is displayed as follows SYNDiLM Investor Payments Sample Financial Gs yi Z Menu Payments Entry Investors Misc Charaes Reference No NEW ay Loan ID JBAN2365 a Payment to Investor Biling Date 0673072011 0573172011 Payment Date 0370172011 H I Write off 04 30 2011 03 31 2011 EELS FCBANK g 02 28 2011 Due ___ Other Payments _ This Payment Principal 0 00 0 00 0 00 Interest J 1 770 84 0 00 1 770 84 Mise Charges 63 61 0 00 J 63 61 Fee 88 54 ou Eai N R Tax 50 12 o oo abe Sales Tax 11 51 ass aust Total 1 684 28 l 0 00 1 684 28 Status Unposted Balance J 0 00 E Delete 2 The fields shown on the screen are described below Reference No A numeric code assigned by the system from the Next Payment Number in Company Profile table Whenever a new payment is generated the Next Payment Number in Company Profile table is incremented by 1 To access an existing
227. osted Posted receipts cannot be modified or deleted The system displays the following message to confirm if transactions should be posted Confirm Posting i Do you really want to post If you have already printed unposted receipts click Yes to post transactions SYNDi Loan Manager User Manual Page 245 Chapter 12 Borrower Receipts 12 3 Working with Batches 1 When you click Borrower Receipts on Main Menu and want to enter anew Receipt the following screen is displayed showing all unposted batches created by you If the screen displays 0 for Batch Number and the list of unposted batches is blank it means that there are no unposted batches in the database Batch No ob Batch Date 0871872012 Batch Type RB Borrower Receipts User ID ADMN Description Borrower Receipt Unposted Batches 2 Click New button next to Batch Number SYNDi assigns the next available batch number Change the Description if necessary SYNDi will remember the new wording and will be displayed every time you create a new batch 3 Click Add to create the batch You should create a new batch every day and enter all payments in that batch If you don t want this newly assigned batch number you must click Add and then click Delete to remove the new batch number A batch can be deleted only if it does not have any entries in it 4 If one or more batches created in the past have not been posted yet they will be displayed
228. ote Samuel Sampson will pay 200 000 on this billing Enter 200 000 in Principal a Payment Leave the payment frequency zero so that this amount is billed only on this billing SYNDi Loan Manager User Manual Page 260 Chapter 12 Borrower Receipts 12 13 14 15 The Reminder date and time is set at 24 hours later Change it to appropriate date and time before saving the Reminder If you have turned on SYNDi Reminder System by allowing pop up menus in Company Profile the Reminder will pop up to keep reminding you until you uncheck Remind Me box After you have reversed a receipt t you must post it If have indicated in Company Profile that you charge NSF fee it will automatically be applied at the next billing run Check Reversal creates a borrower receipt record in the Transactions table with negative values and displays it with status Reversal on Finder screen The original receipt is also maintained in the table but the status is changed from Posted to Check Ret SYNDi Loan Manager User Manual Page 261 Chapter 12 Borrower Receipts 12 10 Processing Borrower Receipts in Block 1 Itis suggested that this option be used only while entering borrower receipts in large numbers It does not allow partial receipts and does not give the user much control It also does not consider unapplied receipts or service charges that have not been billed to any particular loan The procedure de
229. otes V every 5 minutes Maximum Rounding Allowed 0 010 Exclude first day from interest calculation Payments Next Ref 8953 Maintain multiple investors Use Last Name first for borrowers Enforce User Security Do you use Brokers Iv v Do you have web interface to SYNDi E r r B c Variable interest rates based on Prime LIBOR Company s Bank Bank ID CCB a Canadian Commerce Bank 5516 Corvette Cresce Account 201762012101 Display Pop up Check if you want to display pop up reminders Reminders see Section 4 11 If you decide to display reminders enter the interval in minutes after which reminders will pop up The interval starts when you enter Main Menu and SYNDi Reminder System keeps track of elapsed time It is turned off if you choose not to display reminders The interval depends on the volume of activity If you decide to maintain your calendar of appointments in SYNDi Loan Manager you may want to check every 15 minutes otherwise every hour or longer Maximum When monthly interest is calculated at the time Rounding Allowed of billing it is distributed among investors in proportion of their contribution Due to rounding of the interest portion for each investor to the nearest penny there may be a few cents difference between the amount collected from the borrower and the amount distributed to the investor This difference is set initially as 1 2 cent by the system but could SYNDi
230. ou sending it to individual investors the filename ends in Investors The filenames are divided into 3 parts First part is T5_S second part is the year and the third part is the sequence number The highest sequence number for an year represents the latest T5 slip for that specific year These files are saved in the folders as follows DocType FileName Folder Path Pdf T5_S2012001_Investors pdf Database Location Documents T5Slips Pdf T5_S2012001_CRA pdf Database Location Documents T5Slips Xml T5_2012 xml Database Location Documents 17 If you want to print the Investors copy then you must select the latest file for that year filename must end in _Investor in the folder C SYNDi Documents TS5Slips A sample file selection screen for printing T5 slips is displayed here 18 If you choose to print T5 for CRA the snap shot is as follows 19 When you are done with the printing of the T5 slips for either CRA or investors you may upload the XML copy of the T5 document to CRA website 20 A snapshot of the T5 slip for the Investor is here SYNDi Loan Manager User Manual Page 302 Chapter 16 Loan Transfer T5_S2012001_Investors pdf Adobe Reader File Edit Yiew Document Tools Window Help Iv Canada Revenue Agence du revenu Year T5 Agency ar Oanada 2012 STATEMENT OF INVESTMENT INCOME Dividends from Canadian corporations Dividendes de societ s canadiennes Federal credit Cr dit fed red Ann e ETAT DES
231. ount Percentage Borrower Percentage Investor Percentage Loan Discharge SYNDi Loan Manager User Manual miscellaneous charge will be credited It is normally an income account while the miscellaneous charge gets debited to the Receivable from Borrowers Account defined in the Company Profile Select from the Drop Down List Possible values are 3 Flat Amount 4 Percentage of Original Principal If the Miscellaneous Charge Type is Flat Amount enter the amount to be billed otherwise enter the percentage This if the Miscellaneous Charge Type is Percentage of Original Principal the system will calculate the miscellaneous charge as the percentage of original amount loaned You may also leave the value as zero since the true value will be entered when the Miscellaneous Charge Code is applied to a loan If all or part of the amount has to be paid by the borrower enter the percentage between 0 and 100 The calculated amount will be credited to the G L Account set above and debited to receivable from Borrower defined in the Company Profile If a portion or part of the amount has to be paid to investors enter the percentage between 0 and 100 The calculated amount will be debited to the G L Account set above and credited to Payable to Investors 2 defined in the Company Profile Check it if you want the miscellaneous charge to be applied at the time of discharging the loan When a new loan is created the program a
232. ount number needs to be changed double click in any column other than Verified The following screen is displayed Change Bank Account Transit Number joo1 0 00922 Account 930491 6 OK Cancel Change Transit Number and or Account Number and click OK to close the screen The entry in EnteredBy column now displays the current user and the Verified column shows that the record is Blocked 12 Click Close to close the Bank Verification screen SYNDi Loan Manager User Manual Page 275 Chapter 14 Generating Checks Chapter 14 Generating Checks 14 1 Introduction 3 Once a payment has been posted you may print a check for an investor or a borrower You can also print checks to financial institutions holding RRSP accounts and to tax agencies collecting Property Taxes However before you do that it is important that you set up a bank Refer to Section 4 2 for the procedure to set up a bank Make sure that you enter the account number and the Next Check Number The program increments the next check number by 1 every time a check is printed However if you write any checks manually it does not keep track of the next check number For this reason it is suggested that you reset the Next Check Number in the bank record just before a check run You may set up multiple bank accounts if necessary Click Generate Checks on Periodic Processing screen to display the following screen SYNDi LMS Generate Checks Sam
233. over 12 months Add the digits of each month from 1 to 12 e g 1 2 3 4 5 6 7 8 9 10 11 12 78 The interest is allocated in reverse proportion across the life of the loan Thus 12 78 of the interest applies to the first month 11 78 to the second month and so forth down to 1 78th at the end of the 12th month Next calculate the simple interest for the loan 100 000 X 12 X 1 year 12 000 The total payment will therefore be 112 000 which comes to 9 333 33 per month Notice that rounding may result in minor differences For instance 9 333 33 X 12 111 999 96 which is 0 04 short in total payment This difference is applied to the first month as shown below Month Brought Payment Interest Principal Carried Forward Forward 1 100 000 00 9 333 37 1 846 15 7 487 22 92 512 78 2 92 512 78 9 333 33 1 692 31 7 641 02 84 871 76 3 84 871 76 9 333 33 1 538 46 7 794 87 77 076 89 4 77 076 89 9 333 33 1 384 62 7 948 71 69 128 18 5 69 128 18 9 333 33 1 230 77 8 102 56 61 025 62 6 61 025 62 9 333 33 1 076 92 8 256 41 52 769 21 7 52 769 21 9 333 33 923 08 8 410 25 44 358 96 8 44 358 96 9 333 33 769 23 8 564 10 35 794 86 9 35 794 86 9 333 33 615 38 8 717 95 27 076 91 10 27 076 91 9 333 33 461 54 8 871 79 18 205 12 11 18 205 12 9 333 33 307 69 9 025 64 9 179 48 12 9 179 48 9 333 33 153 85 9 179 48 0 00 Total 112 000 00 12 000 00 100 000 00 The following section deal with mathematical formulas to calc
234. ows the current date If you want to print a report displaying records for all dates between the beginning of the year and the current date do not change these fields otherwise enter the proper range Note that the value in the To field cannot be less than the value in the From field 9 The Detailed Summary option is available on certain reports only If displayed select whether you will print the detailed report or the summary report SYNDi Loan Manager User Manual Page 43 Chapter 3 Running the Application 10 For certain reports the fields under Range 1 and or Range 2 may be disabled if they are irrelevant 11 Click Continue to generate the report or Cancel to exit the screen without generating the report 12 If you have chosen Screen as the Destination the report is displayed as follows a1 x 75 X Sample Financial Services Inc Loan History 16 4 2003 Page 1 Loan ID Borrower ID Billing Date Amount Loaned Principal Interest Balance APPLE 65 POTTER 09 12 2002 1 000 000 00 0 00 6 849 34 1 000 000 00 09 1 2003 1 000 000 00 0 00 8 333 33 1 000 000 00 09 2 2003 1 000 000 00 0 00 8 333 33 1 000 000 00 09 3 2003 1 000 000 00 0 00 8 333 34 1 000 000 00 09 4 2003 1 000 000 00 0 00 8 333 34 1 000 000 00 Total 0 00 40 182 69 Pages Kii gt pi 13 The fields shown on the screen are described below Print If you have not chosen printer as the destination you may still print the report by clicking t
235. ows when the user clicks tab header 18 19 20 Al Billing DR Receivable from Borrowers hao O Receivable from Borrowe CR Loan Receivable Principal 1040 Loan Receivable CR Interest Income 420 O g interest Income DR Interest Income mo g Interest Income CR Fee Income a00 Fee Income CR Sales Tax 1 jz0008F t s OC CS JEST Payable CR Non Resident Tax 250 8 t lt i COS a Non Resident Tax CR Payable to Investors 230 a Payable to Investors DR CR Rouning Errors ooo Rounding Errors Bad Debt Expense Soo O g Bad Debt Expense Save Delete Print This screen is used to define G L account numbers for transactions generated during billing It is necessary that all accounts used in the Template must have been set up already as shown in Section 4 1 Enter the G L account number maximum 45 alphanumeric characters for each line or use Finder to select an account number from Accounts table Once all entries have been made click Save to save the Template Click Close to close the screen SYNDi Loan Manager User Manual Page 143 Chapter 5 Working with Loans 5 3 Loan Maintenance 2 The Choose Loans from Loan and Properties menu to open Loan Maintenance Screen 3 The screen contains seven tabs described below Details Terms Notes Property Contacts Main screen to set up the loan Enter the Borrower ID loan description start
236. payment enter the reference number and hit lt Tab gt g Finder is used to display a list of payments in the Transaction table New is used to clear the screen while setting up a new record Loan ID Enter the Loan ID maximum 16 alphanumeric characters user defined Bank ID Enter the Bank ID of the bank from which funds will be withdrawn This field is optional unless SYNDi is integrated with an accounting SYNDi Loan Manager User Manual Page 267 Chapter 13 Investor Payment Payment Date Write off g Billing Date Outstanding Amounts Table Add Save Delete JU EE Close package Enter the date of payment If Write off is checked the amount is credited to Bad Debt Expense instead of Bank as specified in Company Profile The transaction is also flagged as a Write off Finder is used to display a list of all loan records in the Billing Data table Displays billing dates of up to 24 undistributed borrower receipts in the descending order of date The user may select a billing date by clicking on it The Due column shows the amounts billed on the selected billing date The Other Payments column displays the amounts distributed through other partial payments if any The This Payment column displays the amounts to be distributed through the current payment transaction If the outstanding balances are to be paid fully the user may click Add to create the transaction C
237. played The new database has been created We will now exit the application Please run it again 13 Click OK to exit the screen SYNDi is terminated to initialize the database 14 Run SYNDi again to enter the system SYNDi Loan Manager User Manual Page 50 Chapter 3 Running the Application 3 11 Creating Sub Folders While creating the database SYNDi Loan Manager also creates the following sub folders in the Database Location Templates Documents SYNDi Loan Manager User Manual This folder contains document templates for various form and letters When SYNDi Loan Manager is installed it includes the following files as Microsoft Word templates PayoutStatement dot MasterDischargeNotice dot InvestorDischargeNotice dot CheckLayout dot NSFLetters dot When the program is run for the first time these files are copied automatically into Templates sub folder and renamed as follows Payout dot Payout Statement BorDiscNotice dot Discharge Notice for Borrower InvDiscNotice dot Discharge Notice for Investors CheckLayout dot Layout for checks SYNDi Loan Manager uses this folder to place documents created during various functions e g when a loan is discharge it creates a Payout Statement a Discharge Notice for the borrower and a Discharge Notice for each investor These documents are named as follows Payout_ yyyyMMddhhmmdd doc DischargeNotice_Borrower_yyyyMMddhhmmdd doc DischargeNotice_InvestorID_
238. ple Financial Company Bank ID 0260 01082 Description Bank of Montreal Granville Branch Account Number 2071 2736 25 Next Check Number p187 Payee Type Investors Borrowers C RRSP Accounts Tax Agencies OK Cancel The fields shown on the screen are described below SYNDi Loan Manager User Manual Page 276 Chapter 14 Generating Checks Bank ID If a Bank ID has been set up in Company Profile Section 4 3 it is displayed here but it can be changed If there are unposted checks waiting to be posted printed the Bank ID cannot be changed Assuming that there are no unposted checks in the database and that no bank has been defined in Company Profile the Bank ID is blank However if there are any unposted checks waiting to be posted the Bank ID is already filled All unposted checks form a batch of checks and must belong to the same bank You cannot change the Bank ID until you have posted all checks Enter Bank ID if necessary or select it using Finder The program displays the Next Check Number If you have written manual checks and the Next Check Number is not correct close the screen and go to Bank Setup to reset the Next Check Number Description Displays the name of the bank Account Number Displays the account number set in Banks table or the Company Profile It can be changed if necessary Next Check Displays the next check number set for the Number bank in Banks Table Paye
239. pt to indicate the table to which the optional Field will be associated Field Name Enter the name of the field e g Loan Type Credit Rating etc maximum 20 alphanumeric characters New is used to clear the screen while setting up a new field Field Type You may choose the Field Type from the drop down list Following are the valid field types Text Use this type to define descriptive fields such as Loan Type First Second etc or Property Type e g Commercial Residential etc SYNDi Loan Manager User Manual Page 91 Chapter 4 Setting up the Application Validation Type Existing Fields SYNDi Loan Manager User Manual Number Use this type to define numeric data e g credit rating appraised value etc Yes No Use this type to define fields that require a yes or no answer e g Zoning appropriate Date Use this field to define dates e g Realty Tax Due Date Insurance Premium Due Date etc You may choose the Validation Type from the drop down list Following are the valid validation types No Validation The system will accept any List Range Non Blank value including blanks You may define a set of values e g for Type of Loan you may define First Second Third etc If you choose List as the validation type a list of values opens and you may enter allowable values If you define your values as codes e g 1 2 3 etc you may enter a description to explain the signifi
240. r Cryptographic O Members are authorized t Distributed COM Members are allowed to la E Event Viewer Shared Folders 4 Local Users and Groups Users Event Log Readers Members of this group can E Groups Guests Guests have the same acce Performance IIS_IUSRS Built in group used by Inte i Device Manager Network Configur Members in this group can 4 amp Storage Performance Log Members of this group ma f Disk Management Performance Mo Members of this group can iy Services and Applications Power Users Power Users are included f Replicator Supports file replication in ane Tinas dines come manana Beste 10 Right click on Group and select New Group to display the following screen Enter SYNDiGroup and a description Click create to create the group New Group 2E Group name SYNDiGroup Description SYNDi User Group Members Add Remove D Adding Users to Local User Group 11 12 While on Computer Management screen in Control Panel double click SYNDiGroup from the list of groups in the right panel The Group Properties screen is displayed showing a list of users in Members box It should be blank at this point Click the Add button to display the following screen SYNDi Loan Manager User Manual Page 57 Chapter 3 Running the Application Select this object type User
241. r 3 Running the Application SYNDiService network It monitors the database and performs certain predefined functions such as notifying users and sending e mails to borrowers about their accounts reminders about unpaid bills etc Add Click to add a new record Save Click to save an existing record It is highlighted only when the user changes a field Delete Click to delete an existing record rn EE Close Click to close the screen 5 To set up anew company click Add The system will check the folder in which the database will reside We will refer to it as the Database Location It is important that this folder must exist and that you must have full access rights to it If the folder is located on network you must assign a drive letter to its root It is desirable but not necessary to keep the database in the Application Folder 6 If the specified folder does not exist the following message is displayed Confirm Folder does not exist Do you want to create it Click Yes to create the folder Click Add again to add the database specifications to the Company List 7 The new database appears in the Company List 8 Click Close to close the screen and return to Login screen Click the Finder button next to Company Name to display a list of all companies already set up SYNDi Loan Manager User Manual Page 48 Chapter 3 Running the Application SYNDi LMS Login Om SYNDi Premium f Release 5 7E L
242. r 6 Investor Receipts Investor ID a E Investment Type Description Lawyer ID Gross Amount Net Amount SYNDi Loan Manager User Manual characters user defined Finder is used to display a list of all records in the Loans table Fly is used to set up a loan on the fly Enter the date of transaction The date must be prior to the next billing date of the loan If the loan has never been billed before the date must not be prior to the start date If the loan has been billed at least once the date should not be prior to the last billing date The range of valid dates is displayed on the screen for reference Enter the Investor ID maximum 16 alphanumeric characters user defined Finder is used to display a list of all records in the Investors table Fly is used to set up an investor on the fly While entering a new receipt the system retrieves the Investment Type from the investor record The value can be changed if necessary Enter check number or description The lawyer that is used for the loan is automatically entered on a new receipt but you may change the Lawyer ID if necessary Enter amount contributed by the investor Net Amount is the actual amount received from the investor Normally it is equal to the Gross Amount except for Term Loans with prepaid interest For instance if you set up a 24 month 100 000 loan with 12 prepaid interest with annual compounding the interest amount
243. r ID for the loan maximum 16 alphanumeric characters user defined Once the loan has been set up you cannot change this field Finder is used to display a list of all records in the Borrowers table Once the loan has been set up the Finder button cannot be used Fly is used to set up a Borrower ID on the fly Once the loan has been set up the Fly button cannot be used Description of the loan maximum 60 alphanumeric characters Principal amount of the loan must be less than ten billion dollars Once the loan has been setup and the amount advanced to the borrower you can change the Principal only through Loan Adjustments Down payment amount if any Date on which the loan is advanced to the borrower Indicate whether the interest rate will be fixed or variable In case of fixed rate enter the percent interest rate In case of variable rate the interest will be calculated as the specified number above or below the prime rate on or immediately before the start date of the loan As the prime rate is modified over the life of the loan the interest will change when monthly installment is calculated Term of the loan in months and days For example in case of a five year loan the term should be entered as 60 i e 12X5 months and zero days Finder is used to display a list of all Rank Codes Page 146 Chapter 5 Working with Loans E Status Stop Billing In Process Funding Misc Charge Adjust
244. ral reminders Enter the code for the entity for which the note is being entered If the Note Type is General no code is required in this field Page 125 Chapter 4 Setting up the Application Effective Date Remind Me Reminder Date Personal Hold Billing Add Save Delete nL EE Close Enter the date and time on which the note will take effect For new reminders the current date and time is displayed as the default Change it if necessary Check the box if you want to see a pop up reminder If Reminder checkbox in Options tab of Company Profile Setup is not checked The screen displays the message SYNDi Reminder System turned off In this case no Reminders will pop up Enter the date and time after which you would want to see the pop up reminder As a default the date and time 24 hours from the Effective Date is set Change it if necessary Check if you want to label the note as personal in which case it can be viewed only by the user who created it If a note is not personal it can be flagged as personal later but only by the user who created the note Displays the User ID of the user who created the note Description of the note unlimited number of alphanumeric characters If Hold Billing is checked the note is displayed as a reminder at the time of billing when the effective date approaches Click to add a new record Click to save an existing record It is highlighted only w
245. ransactions 1 Investor Receipts In a typical scenario when a Loan is set up you form a syndicate consisting of one or more investors As their checks are received they are deposited in a trust account The G L entry for the transaction is DR Bank in Trust Asset CR Investors in Trust Asset Both of these accounts are defined as assets and act as clearing accounts 2 Borrower Payments When contributions from all investors have been received money is advanced to the borrower and the following journal entry is made DR Loan Receivable Asset CR Bank in Trust Asset This clears the Bank account and leaves the amount in Loan Receivable account 3 Billing Billing calculates the monthly installment containing interest plus any principal paid as blended payment or as lump sum The journal entry is as follows DR Receivable from Borrowers Asset CR Loan Receivable principal portion Asset CR Interest for Distribution interest portion Liability The system also calculates deductions from the interest and calculates the amount payable to investors DR Interest for Distribution Liability CR Management Fee Income Revenue SYNDi Loan Manager User Manual Page 63 Chapter 4 Setting up the Application CR Sales Tax 1 Payable Liability CR Sales Tax 2 Payable Liability CR Sales Tax 3 Payable Liability CR Non Resident Tax Payable Liability CR Payable to investors interest minus deduct
246. reen are described below Print Unposted Transfers Generates a report showing unposted transfers for selected loans see Sample Report in Appendix A Print Posted Transfers Generates a report showing posted transfers for selected loans and specified date range see Sample Report in Appendix A Post Transfers This function marks all unposted transfers as posted Posted transfers cannot be modified or deleted The system displays the following message to confirm if transactions should be posted SYNDi Loan Manager User Manual Page 199 Chapter 7 Investor Transfers Confirm Posting i A Do you really want to post If you have already printed unposted transfers click Yes to post transfers SYNDi Loan Manager User Manual Page 200 Chapter 8 Borrower Payments Chapter 8 Borrower Payments 8 1 Introduction After a new loan has been setup and money has been received from investors and posted it is paid to the borrower and the payment is entered in the system It is necessary to post the payment after it has been entered in order to be considered as part of billing It is mandatory that the total amount paid to the borrower is equal to the principal entered in the loan record The Borrower Payments screen is displayed as follows when you fund the loan You may access this screen anytime by clicking Funding button on the Details tab of Loan Maintenance screen See Section 5 5 SYNDi
247. rge record To change the amount for individual investors click the amount field to highlight it overtype the amount and hit lt Tab gt Click to add a new record Page 170 Chapter 5 Working with Loans Save Click to save an existing record It is highlighted only when the user changes a field Delete Click to delete an existing record Close Click to close the screen iig 3 To set up a new record click New to clear the screen Enter the Miscellaneous Charge Code If the record is already present in the table the data is displayed and the fields could be modified 4 You may hit lt Tab gt key to move from one field to the next Alternatively you may click inside a field and modify it 5 To modify an existing record enter the Miscellaneous Charge Code or use Finder to select a record Enter the fields and click Save to save changes 6 If you have set up a term loan with prepaid interest do not enter the interest amount as a miscellaneous charge since the system already deducts it from borrower payment SYNDi Loan Manager User Manual Page 171 Chapter 5 Working with Loans 5 7 Discharge a Loan 1 Once a loan reaches maturity or is discharged early choose Discharge a Loan on the Loan Setup Menu to display the following screen SYNDi LMS Loan Discharge Sample Financial Company Loan ID BIR1160 Discharge Date 03 15 2007 Send paymentto investors 1160 Birchmount Road
248. ribed ChkRec Fee Rate InvType Applied 25 000 X 9 51 Yes 5 5 2011 1 6 30 2011 100 000 X 3 51 173172012 371572012 0 9 51 0 9 51 9 21 2012 o 3 51 Group Name I Investor D David Gambol GAMDAY gt Julie Gambol GAMJUL 225 000 Save Delete 28 Investor ID Table of Advances SYNDi Loan Manager User Manual Subscriptions The fields shown on the screen are described below Enter the Investor ID for whom the subscription is being entered In order to view a list of investors participating in the loan click the corresponding Finder button The table displays Advance Number Advance Date Available Amount subscribed Amount Check Receivabed indicator Fess Interest Rate Investment Number and Applied indicator You can enter the amount subscribed by an investor in any advance provided it has not been applied If the amount has already been received double click ChkRec field to mark it with an X The Subscribed Amount cannot exceed Available Amount Page 333 Chapter 17 Loan Documents Group Subscriptions SYNDi Loan Manager User Manual If the investor belongs to a Group a list of members of the Group with their contributions is displayed at the bottom of the screen To modify the contributions of another member of the group just double click on the row Displays a listing showing the names and contribut
249. ro SYNDi Loan Manager User Manual Page 10 Chapter 1 Introduction 1 2 2 Semi Annual Compounding Interest Only Loans 1 Interest is compounded on semi annual basis but charged monthly in case of Canadian mortgages This was done traditionally to coincide with the harvest time and the convention is still retained The effective monthly interest rate comes out to be slightly less than the value obtained by simply dividing the per annum rate by 12 In this case the effective monthly interest rate r is calculated from the annual interest rate i by using the following formula 1 i 6 r 1 asl For example if the rate is 9 per annum the effective monthly rate will be 0 007363 which is slightly less than the monthly rate of 0 0075 calculated earlier under annual compounding Monthly interest is calculated by multiplying the principal amount P by the effective monthly rate I PXr Thus if the principal is 100 000 and the interest rate is 9 per annum we have P 100 000 and i 9 the monthly interest is I 100 000X 0 007363 736 30 which is less than 750 obtained earlier for annual compounding In order to calculate interest 74 for certain number of days d first calculate interest for one day by multiplying full month interest by 12 and dividing the answer by 365 and then multiply the value by the number of days f 12Xd I 365 Thus if the principal is 100 000 and the intere
250. rocess the date on which the billing was run is set as the Last Billing Date and the Next Billing Date is calculated Subsequent billings consider the period between the Last Billing Date exclusive and the Next Billing Date inclusive The last billing considers the period from the Last Billing Date exclusive to the Maturity Date inclusive Thus the first and last billing may be for part of a month while intermediate billings are for the entire month When billing is run it includes all loans for which the Next Billing Date is same as or prior to the date on which billing is run and the amount advanced to the borrower is greater than the principal paid by the borrower This means that the loans which have been fully paid off or the new loans on which the principal has not yet been advanced to the borrower will not be included in billing It is necessary that all payments receipts transfers and adjustment be posted before the billing run Billing does not proceed if the system finds any unposted transactions Loans with the status code which has Stop Billing code checked are not included in billing SYNDi Loan Manager User Manual Page 220 Chapter 10 Billing 10 2 Running Billing Click Billing on Main Menu to display a screen showing three type of loans a b c All loans which are due to be discharged You must run Loan Discharge procedure to remove such loans from billing Loans with a status th
251. rrors 201 Invalid Investment Type The value must be between 1 and 5 202 Corporate investors cannot have Investment Type 1 or 2 203 Individual Investors cannot have Investment Type 3 or 5 204 Invalid Business Number Social Insurance Number or Trust Account Number 205 The Joint Account holder s First Name or Last Name cannot be blank 206 Invalid Social Insurance Number for joint account 209 Address Linel cannot be blank 210 City cannot be blank 211 Province State cannot be blank 212 Province State is not valid 213 Postal Code cannot be blank 14 Correcting Company related Errors Go to Company Profile and correct the errors 15 Correcting Investor related Errors Most of these errors are generated from Investor records Go to Setup gt Investors and correct the errors Investment Type errors come from Investor Receipts and should be corrected by calling individual receipts Printing T5 slips 16 The pdf files are meant for printing One file is to be sent directly to CRA this has T5 slips for all investors Each page has 3 investors and the other file is for investors it has all selected investors and each investor receives 3 copies Each page has investor It gives you the option to select which type of file you want to print If you are sending T5 to CRA then you may select the latest file whole filename ends in SYNDi Loan Manager User Manual Page 301 Chapter 16 Loan Transfer CRA or if y
252. rs Period Matured Maturity Dat 03 09 2006 04 09 2006 1 Month 09 27 2006 03 09 2006 04 09 2006 1 Month Yes 04 09 2006 03 09 2006 04 09 2006 1 Month 04 10 2007 03 09 2006 04 09 2006 1 Month 10 09 2007 03 09 2006 04 09 2006 1 Month 05 30 2007 03 09 2006 04 09 2006 1 Month 10 15 2006 03 09 2006 04 09 2006 1 Month 08 30 2006 03 09 2006 04 09 2006 1 Month 05 08 2007 03 09 2006 04 09 2006 1 Month 08 30 2006 03 09 2006 04 09 2006 1 Month 06 14 2008 Cancel When billing data has been collected in temporary areas the Process button is dimmed and if the data has errors the Post button is also dimmed 7 Following is the list of error codes assigned during billing Principal Advanced is not equal to the Total Principal Balance Owed is not equal to Balance Loaned Monthly Blended Payment is less than calculated interest Principal calculated for borrower and investors not equal Interest calculated for borrower and investors not equal Principal Paid by Borrower and Principal Paid to Investors are not equal ANN We 8 Click Report to generate the Billing Report see Sample Report in Appendix A The report must be printed and filed before posting billing data If the data is edited and any changes made print the report again before filing it 9 Click Edit Section 10 3 to correct rounding errors in billing data Some errors such as Error Code 2 Prime Rate
253. s Personal Data Payment Documents Group Opt Fields Name First Name Address Mary Bahn Corporate Individual Mary LastName Bahn 7481 Woodbine Avenue Same State Prov Markham SOS Ontario PostalCode 1 3R 2W1 Country Tel Fax Soc Ins No 905 940 0751 905 940 0341 123 456 789 Remarks ee 13 The fields shown on the screen are described below Name Personal name maximum 60 alphanumeric characters Address Three address lines maximum 60 alphan umeric characters each Same Click to copy the address telephone number and Fax Number from the Name and Address tab City Name of the city maximum 30 alphanumeric characters State Prov State or province maximum 20 alphanumeric characters PostalCode Zip code or postal code maximum 10 alphanumeric characters Country Country Name maximum 20 alphanumeric SYNDi Loan Manager User Manual characters Page 115 Chapter 4 Setting up the Application Tel Fax Soc Ins No Remarks Telephone number maximum 20 alphanumeric characters Fax number maximum 20 alphanumeric characters For Canadian users this field represents 9 digit Social Insurance Number for the secondary investor if the investment is coming from a joint account This field is used while generating T5 slips If an investor is a corporation leave this page blank For non Canadian users this field is treated as user specified field and could b
254. s Service Accounts or Groups Object Types Erom this location indussys com Locations Enter the object names to select examples m Check Names mee emj 13 Type the login IDs or names of users in the object name box Hit carriage return after each name You may click Check Name to allow the system to check if all users in the list are valid Click OK If the user is valid it is added as a member of SYNDiGroup and the group Properties window is displayed again as shown below General W SYNDiGroup Description SYNDi User Group Members DOM_NTADMIN Christian Christian indussys com Changes to a user s group membership Remove are not effective until the next time the user logs on 14 You can click Add to add another user or click OK on the group properties screen SYNDi Loan Manager User Manual Page 58 Chapter 3 Running the Application E Linking User Group to SYNDi Database 15 You must link SYNDiGroup to Acme database 16 Open SQL Server Management Studio if not already in it 17 Expand the Security folder to expose a list of all folders and right click on the Login folder F Microsoft SQL Server Management Studio Eile Edit View Debug Object Explorer Connect B RAFI D820 SQL Server 10 50 1600 DON A Databases a Security a ca O Server Roles amp 39 Credentials i Cryptographic Providers E7 Audits 9 Server
255. s with payment frequencies based on months while Method 3 will be used for loans with weekly or bi weekly payment frequencies If Method 2 or 3 is used as the Default Calculation Method it will be used for all loans Please note that when you set up a new loan you can change the Calculation Method as necessary Default value of management fee charged from investors as a percentage of interest This value is used when an investor record is set up but could be modified in case it varies from investor to investor Displays a warning message if the interest rate set for a loan exceeds this value It is intended to catch inadvertent data entry errors If you want every loan to be billed on certain day of the month enter the day in this field 1 to 31 otherwise enter 0 in which case the loan will be billed on the day on which it was started Changing Default Billing Day does not affect existing loans If the loans are not necessarily real estate related you should leave this option unchecked otherwise you will have to define a Property and associate the loan to it This will enable you to track Loan to Value LTV ratio Page 137 Chapter 5 Working with Loans Use as Default Template Add Save Delete Print PERE Close Check it for the most common template When a new loan is set up the Default Template ID is displayed The entry can be changed if you are using another template for the new loan Click to
256. s defined for investor receipts are listed Just enter appropriate values for each field 3 To enter a new receipt click New to clear the screen Enter Loan ID Transaction Date and the Investor ID If the record is already present in the table the system displays a warning message such as Duplicate Investement WARNING This investor has already invested 40 000 00 in the current period A Check Investment Number 2822 Are you sure you want to enter this investment No 4 You may hit lt Tab gt key to move from one field to the next Alternatively you may click inside a field and modify it 5 To modify an existing record enter the Investment Number or use Finder to select a record Enter various fields and click Save to save SYNDi Loan Manager User Manual Page 186 Chapter 6 Investor Receipts changes You cannot modify a record that has already been posted with the exception of Fee Bank ID and Account Number 6 Each investment is identified by a unique Investment Number which consists of unique combination of Loan ID Investor ID and Start Date of the investment The Start Date is the date on which the investment is received It is same as the date on which the loan is advanced initially or the date on which an investor enters the loan as a result of loan adjustment or investor transfer 7 Once you have initiated the billing process you cannot enter a receipt until billing has been posted 8 T
257. s used if you process borrower receipts through direct deposits via SYNDi EFT This field goes to the bank when you EFT the information When the loan is funded the system builds the Cross Reference Number by joining the first 9 characters of Loan ID and the first 9 characters of the Borrower ID and putting a hyphen in the middle Cross Reference Numbers must be unique If Page 203 Chapter 8 Borrower Payments Borrower s Bank a E Account Miscellaneous Charges Add SYNDi Loan Manager User Manual two or more Loan IDs or Borrower IDs have the same characters in the first 9 positions you may get duplicate Cross Reference Numbers and the system displays an error message if it encounters a duplicate Enter the Transit Number and the account number of borrower s bank account While entering a new payment the system retrieves the baning information from the borrower record The value can be changed if necessary If you process borrower payments through preauthorized payments via SYNDi EFT this field is used when you EFT the information to the bank If a borrower pays by check leave the banking information blank Finder is used to display a list of all records in the Banks table Fly is used to set up a bank on the fly Enter the Bank Account Number for the borrower 7 to 12 numeric characters While entering a new payment the system retrieves the Account Number from the borrower record T
258. scellaneous Transactions 11 1 Introduction If SYNDi is interfaced with QuickBooks it is necessary that QuickBooks be open with the right company when you enter this screen Miscellaneous Transactions can be used to enter service charges such as NSF fee or an administration charge In this case you may either just bill the service charge if the actual amount has not been received or you may 1 actually receive it Click Misc Transactions on Main Menu to display the following screen containing two tabs described below SYNDi LMS Miscellaneous Transactions Sample Financial ome Menu Transaction Entry Menu Print various listings and post Miscellaneous Transactions Transaction Entry Enter Miscellaneous Transactions You may access various tabs by clicking on the tab header SYNDi Loan Manager User Manual Page 236 Chapter 11 Miscellaneous Transactions 11 2 Menu Tab 1 The tab is displayed as follows SYNDi LMS Miscellaneous Transactions Sample Financial R CM nu Transaction Entry 12h Print Uposted Transactions iB Print Posted Transactions iB Post Transactions 2 The functions shown on the screen are described below Print Unposted Transactions Generates a report showing unposted transactions Print Posted Transactions Generates a report showing posted transactions Post Transactions This function marks all unposted transactions as posted Posted transactions cannot
259. scellaneous charge Page 167 Chapter 5 Working with Loans G L Account Amount Borrower Investor Distribute Frequency SYNDi Loan Manager User Manual Displays the General Ledger Account to which the miscellaneous charge will be credited as defined in the Miscellaneous Charge Code Table Displays the amount to be billed as defined in the Miscellaneous Charge Code Table If the Miscellaneous Charge Type in the Miscellaneous Charge Code Table is defined as a percentage the amount is calculated at the time of setting up the miscellaneous charge Displays the percentage of the amount to be charged to the borrower as defined in the Miscellaneous Charge Code Table Displays the percentage of the amount to be paid to the investor as defined in the Miscellaneous Charge Code Table Click to distribute the total investor amount to individual investor Whenever you change Investor Percentage or the Miscellaneous Charge Amount you should click to distribute the amount properly so that the Unapplied Amount is zero You may choose one of the following options Next Billing The transaction is applied when the next billing is run and is rendered inactive Every Billing The transaction is applied whenever billing is run and remains active until the user renders it inactive Loan Discharge The transaction is applied at the time of discharging the loan Loan Advance Page 168 Chapter 5 Worki
260. screen SYNDi Loan Manager User Manual Page 84 Chapter 4 Setting up the Application Access Confirmation x You have chosen to grant the application SYNDi Loan Management System access to the QuickBooks company file Sample Financial Company whenever this QuickBooks file is open Access rights Read and modify QuickBooks data NOT including personal data Enhance the QuickBooks user interface Go Back 29 Click Done to proceed further Once QuickBooks is told that SYNDi is allowed to access it the routine described above Posting Level 30 If SYNDi is interfaced with one of the accounting packages you have to indicate whether you want to post at Detail level of at Summary level At Detail level a separate journal entry is generated for each transactions while at Summary level all transactions belonging to the same month are grouped together and posted at the end of the month SYNDi Loan Manager User Manual Page 85 Chapter 4 Setting up the Application Descriptions Tab 31 The tab is displayed as follows when the user clicks tab header SYNDiLM Company Profile Sample Financial Payment to Borrower Cheque Returned Cancelled Amount Due Loan Adjustment Cancel Billing nyestor Contribution Payment to Investor New Loan Advance 32 This screen is used to define default descriptions for various types of transactions You may ch
261. scribed below Broker Enter the amount if applicable Commission etc Legal Fees Enter the amount if applicable Administration Percentage of interest deducted from the Fee investor The value comes from the default set up in Company Profile The actual percentage may vary from investor to investor as specified in individual loans Other Charges Specify if applicable SYNDi Loan Manager User Manual Page 326 Chapter 17 Loan Documents Tab 7 Fees Payable By Borrower 15 The tab is displayed as follows Broker Fee 2 000 0 Brokerage 2 Co operating Broker Fee J Administration Fee 4 Appriximate Legal Fee Lawyer Legal Fees S Inspection amp Appraisal Fee Shnsurance Premium 1 Insurance Premium 2 Insurance Premium 3 J Insurance Premium 4 10 Tax on CMHC Insurance 11 Bonus 14 Finders Fee 16 A predefined set of 12 types of fees is provided Fill various rows as necessary and indicate whether it has to be deducted from the amount of loan SYNDi Loan Manager User Manual Page 327 Chapter 17 Loan Documents Tab 8 Dates and Commitments 17 The tab is displayed as follows SYNDiLM Loan Documents Sample Financial Cons M d Dates and Commitments C0R5516 Commitment Date 0570572012 Mortgage Proposal Date 0570572012 HH Disclosure Statement Date 0570772012 il Mortgage arranged before 0570572012 Hal Advances dvNum Ad
262. scribed in Sections 12 4 to 12 7 for entering individual receipts provides better control and allows partial receipts 2 Clicking Enter Receipts in Block on Menu tab displays the following screen m SYNDiLM Borrower Receipts Sample Financial C I Ed Receipt Date 04 30 2011 fasi C Select Self Admin Description Borrower Receipt Select Al De select All Bank ID cce al LoaniD BillingDate p SelfAdmir Process Date a P gt 2 28 2011 1160 Birchmount Road 5 766 39 Yes 3 31 42011 1160 Birchmount Road ST Yes 4 30 2011 1160 Birchmount Road 5 766 3 Yes 5 31 2011 1160 Birchmount Road 5 766 3 Yes 6 30 2011 1160 Birchmount Road 5 766 39 Yes 3 31 2011 2251 Circle Square 708 33 f 4 30 2011 2251 Circle Square 708 33 5 31 2011 2251 Circle Square 708 33 6 30 2011 2251 Circle Square 708 33 5 31 2011 5516 Corvette Crescent 2 368 49 6 30 2011 5516 Corvette Crescent 2 789 58 2 28 2011 Damascus Plaza 5 843 75 3 31 42011 Damascus Plaza SBa 4 30 2011 Damascus Plaza 5 843 7 FID IMN anaana Diaan E OAD Total of Loans 76 Total Receipts f 66 042 09 Process Close 3 The fields shown on the screen are described below Receipt Date Enter the date on which the payments from borrowers have been received All billed transactions are displayed in a grid in the sequence of billing date and loan ID All self administered loans are displayed
263. ser Manual Displays the entry in the original Borrower Payment Displays principal balance If the borrower is paying a fixed amount enter it with minus sign This amount will be added to the principal paid when the loan adjustment record is posted If the borrower needs additional amount any time during the life of the loan enter the additional amount in this field without minus sign If the borrower will be paying additional interest enter it without minus sign The amount will be added to interest paid when the loan adjustment record is posted If the borrower will be paying additional interest as penalty enter it without minus sign The amount will be added to interest paid when the loan adjustment record is posted If the loan adjustment shows payment from the borrower principal and or interest The program distributes the amounts among the participating investors and displays them on Investors Tab See Sections 9 3 and 9 4 The total principal and interest are displayed in the Investor Total fields If the loan adjustment is for additional principal paid to the borrower enter Investor IDs and corresponding contributions Click to add a new record Click to save an existing record It is high lighted only when the user changes a field Click to delete an existing record Click to close the screen Page 210 Chapter 9 Loan Adjustments 3 To enter a new adjustment click New to clear the scree
264. ser Manual Page 176 Chapter 6 Investor Receipts Chapter 6 Investor Receipts 6 1 Introduction This function is used only if you have indicated in the Company Profile that you maintain multiple investors After a new loan has been setup potential investors are contacted to join the syndicate When a contribution is received from an investor it is entered as a receipt Each receipt generates a unique Investment Number and the program applies all billings and disbursements to the investment An investor may have multiple investments in a loan When all receipts have been entered they should be posted in order to be considered part of billing It is mandatory that the total amount received from investors is equal to the principal entered in the loan record The Investor Receipts screen is displayed when the user clicks Investor Receipts on Main Menu Click Investor Receipts on Main Menu to display the following screen containing two tabs described below SYNDi LMS Investor Receipts Sample Financial Company Menu Receipts Entry Terms Activity Opt Fields Menu Print various listings and post receipts Receipts Entry Enter investor receipts Terms Establishes interest rate and related factors Activity Display the principal and interest paid to date Opt Fields Enter optional fields defined for investor receipts You may access various tabs by clicking on the tab header SYNDi Loan Manager
265. sit Number will be 0012 27601 SYNDi Loan Manager User Manual Page 107 Chapter 4 Setting up the Application Account No Enter the Bank Account Number of the borrower 7 to 12 numeric characters SYNDi Loan Manager User Manual Page 108 Chapter 4 Setting up the Application Opt Fields Tab 14 The tab is displayed as follows SYNDi LMS Borrowers Setup Sample Financial Company Applicant 1 Applicant 2 Payment Name Value gt Credit Rating A Save Delete Close 15 The optional fields defined for borrowers are listed Just enter appropriate values for each field SYNDi Loan Manager User Manual Page 109 Chapter 4 Setting up the Application 4 10 Investors 1 Investors Maintenance screen is displayed when the user clicks Investors on Setup Menu 2 Hit lt Tab gt through various fields and change them if necessary 3 The screen contains six tabs described below SYNDiLM Investors Setup Sample Financial Company C Name and Address Personal Data Payment Documents Group Opt Fields Name and Address Enter individual corporate name and address of the investor Personal Data Enter personal name and address of the investor Payment Enter investment type tax percentage and fee rate The screen also displays investor contribution to various loans Documents This tab displays investor documents saved in Documents Catalog
266. slips are to be generated If you have processed all investors in previous runs and have indicated that you are generating Original T5 Slips SYNDi returns the message There is no data for specified year If you are filing the T5 slips for the first time for specific year you must select the option Original All investors will be displayed whose original T5 slips have not been generated earlier If you choose Amended you will get a list of only those investors whose original T5 slips have been run You must select either Paid or Earned interest option By default Paid is selected Select either Gross or Net amount By default Net amount is selected Page 298 Chapter 16 Loan Transfer 7 When you click the Load button SYNDi initially checks for any T5 Run Number 2012001 was not fully processed since it does not have Confirmation Number If you have already uploaded printed T5 slips in this submission please click Yes to enter the Confirmation Number now If you want to cancel this run you may click No in which case all T5 slips in this run will be deleted and you will have to process them again Do you want to enter the Confirmation Number Yes No transactions that were processed earlier but not yet finalized blank confirmation number If it finds such transactions you are prompted to upload them or delete them in which case you can reprocess them 8 If you click Yes then you can upload t
267. st rate is 9 per annum we have P 100 000 and i 9 the interest for 21 days is p 12 2 736 30 508 35 365 SYNDi Loan Manager User Manual Page 11 Chapter 1 Introduction Blended Payments 4 The formula for calculating the payment is as follows 1 l r 1 iqy n 1 a P Principal Balance Pm Payment Amount n Amortization period in months i Annual interest rate as percentage l 9X 100 P PX m where 5 To calculate the principal portion of the installment subtract the interest calculated earlier from the payment amount P 6 Consider a loan of 100 000 with interest rate of 9 amortized over 30 years The payment is calculated as follows P 100 000 n 30X12 360 i 9 r 0 045 2X 100 1 1 0 045 1 17 360 1 004 7 Out of the payment of 792 83 the principal payment can be calculated by subtracting interest as calculated in step 2 above i e 792 83 736 30 56 53 The principal balance after the first payment will be 100 000 56 53 99 943 47 and the interest will be calculated on this value P 100 000X 792 83 8 In order to calculate interest 74 for certain number of days d first calculate interest for one day by multiplying full month interest by 12 and dividing the answer by 365 and then multiply the value by the number of days SYNDi Loan Manager User Manual Page 12 Chapter 1 Introduction E 12Xd I 3
268. t 2 Payment Opt Fields Applicant 1 Enter name and address of the borrower Applicant 2 Enter name and address of the co applicant e g spouse if any Payment If the monthly receipts from the borrower will come through Electronic Funds Transfer EFT enter the Bank ID and the account number of the borrower Opt Fields Enter the optional fields defined for borrowers You may access various tabs by clicking on the tab header The fields on each tab are described below SYNDi Loan Manager User Manual Page 101 Chapter 4 Setting up the Application Applicant Tab 1 4 The tab is displayed as follows SYNDi LMS Borrowers Setup Sample Financial Company Applicant 1 Applicant 2 Payment Opt Fields Borrower ID First Name Company Name Address City State PostCode Country Tel Fax E Mail Contact Remarks BLOJIM ao Corporate Personal Jim LastName Blouski 1160 Birchmount Road Scarborough Ontario M1P 2B8 Canada 416 751 0751 416 751 9289 register indussys com Brian Smallwood St Delete Close 5 The fields shown on the screen are described below Borrower ID Borrower Type First Name SYNDi Loan Manager User Manual A code set up to identify a borrower maximum 16 alphanumeric characters user defined Choose Corporate if the borrower is a company is which case you will enter the company name Choose Personal
269. t Amount SYNDi Loan Manager User Manual Page 214 Chapter 9 Loan Adjustments 11 Click Add to add the Loan Adjustment SYNDi Loan Adjustments Sample Financial Company Menu Investors View Adjustments e Record Number 0 Loan ID BIR1160 ejm 1160 Birchmount Road Date 01715 2007 fa Date Range 01 10 2007 to 02 09 2007 Document No j21 753 Paid to Khan Associates Barristors Balance 725 000 00 Ref No NEW Status Penalty 3 months Adjustment Amount Principal 25 000 00 gt 0 Pay Borrower lt 0 Receive from Borrower Investor Total Principal 25 000 00 gt 0 Receive from Investor lt 0 Pay Investor Add Delete Close SYNDi Loan Manager User Manual Page 215 Chapter 9 Loan Adjustments 9 4 Reducing Loan Amount and Entering Interest Adjustment 1 Occasionally a borrower may pay a lump sum amount to reduce the principal In this case the amount should be entered with minus sign in the Principal field SYNDi Loan Adjustments Sample Financial Company Menu Loan Adjustments Entry Investors View Adjustments e Record Number m Loan ID BIR1160 ISD 1160 Birchmount Road Date 01 15 2007 Be Date Range 01 10 2007 to 02 09 2007 Document No 21753 Paid to Khan Associates Barristors Principal 725 000 00 Ref No NEW Status eSz7 Penalty 3 months Adjustment Amount Principal 25 000 00 Interest f 39 04 Pen
270. tails Enter details if the level of Priority A is Other Face Amount Enter the original amount advanced in Priority A encumbrance Amount Owing Enter the balance for Priority A encumbrance In Default Enter Yes or No Name of Enter the description of the party to whom Mortgagee monies are owed under Priority A Any Other Party Enter the description of any other party to whom monies are owed under Priority A SYNDi Loan Manager User Manual Page 324 Chapter 17 Loan Documents Priority B Details Face Amount Amount Owing In Default Name of Mortgagee Any Other Party SYNDi Loan Manager User Manual Indicate the rank 1 2 3 or other If no monies are owed under Priority B click None Enter details if the level of Priority B is Other Enter the original amount advanced in Priority B encumbrance Enter the balance for Priority B encumbrance Enter Yes or No Enter the description of the party to whom monies are owed under Priority B Enter the description of any other party to whom monies are owed under Priority B Page 325 Chapter 17 Loan Documents Tab 6 Fees Payable By Investors 13 The tab is displayed as follows Fees Payable By Investors C0R5516 Broker Commission etc 0 00 Legal Fees 0 00 Administration Fee 5 May vary from investor to investor Other Charges HST 13 Save Delete 14 The fields shown on the screen are de
271. te interest on unpaid balance uncheck here if you do not want to calculate interest for the individual loan Additional In Interest only loans SYNDi calculates Principal interest only at each billing such that the entire Deduction principal is payable at the end of the term However if the borrower pays down a flat amount say 500 a month You may enter it as the amount You may also specifiy the Start Date after which the additional payment will be applicable and the Stop Date after which the additional amount will not be deducted Normally these dates are same as Loan Start Date and Maturity Date respectively 16 Term Loans A Term Loan is defined as a loan for which the total interest for the term is charged at the end of the term For instance if the Start Date of a 100 000 loan at 12 interest only with no compounding is February 21 2008 and the term is 12 months the Maturity Date of the loan will be February 20 2009 In such a case set Billing Day to 0 Billing will run on February 20 2009 to bill the principal amount of 100 000 plus interest of 10 000 17 Interest Free Loans While entering an interest free loan enter the interest rate as 0 fixed If a fixed dollar amount has to be recovered on monthly basis set the Payment Type as Blended amortized over the period of the loan Enter the installment amount in the Payment Amount field Consider a 12 000 interest free loan over one year period such that the borro
272. te the billing data collected in the temporary area by Process function You can use this button if you have already clicked Process button but have not posted the data yet Please note that any edits done to the billing data are lost Close Click to close the screen 4 When the interest and principal if any is calculated for the borrower it is distributed among the investors in the proportion of their contribution Occasionally there may be differences between the amount calculated for the borrower and the amount distributed to investors due to rounding If the difference exceeds the rounding error set in Company Profile it is flagged as an error If any loan is flagged as error the billing cannot be posted unless the billing data is edited to remove the error condition or the source of error cleared outside billing and processed again As long as the error is present the Post button remains dimmed 5 To initiate billing click Process If errors are encountered the following message is displayed Billing cancelled due to errors Please check Pre Billing Report and correct errors before running Billing again OK 6 The system displays a summary of billed loans as follows SYNDi Loan Manager User Manual Page 223 Chapter 10 Billing SYNDi Billing Sample Financial Company Biling Date 04 09 2006 BE Loans From dQ To 2222222222222272 a 7 include matured loans Last Billing This Billing Erro
273. the Application 9 The highest level of security depends on the function Thus the highest level for Investor Receipts is 5 while the highest level for setting up loans Function 12 is 4 10 In order to change a user right highlight the level and enter the new value before saving the record 11 ADMIN is a special user with the lowest security Level 1 for all functions You cannot change the user rights for ADMIN SYNDi Loan Manager User Manual Page 90 Chapter 4 Setting up the Application 4 5 Optional Fields 1 Click Optional Fields on Setup screen to display the following screen SYNDi LMS Optional Field Setup Sample Financial Company Table Loan v Field Name Type of Property io Field Type Text v Value Description a e m Five or more unit res Validation Type List emmers Industrial Size 50 Vacant land or const gt Other Active Existing Fields pe Si etivi pe gt Type of Property Text 50 No Non Blank Zoning appropriate for proposed use Date 10 No No Validation List Ri w Appraised Value Number Yes1 0 No No Validation List Re Existing orNew Text 10 No Non Blank Previous Loan Date Date 10 No No VYalidation List Ra Delete 2 The fields shown on the screen are described below Table From the drop down list you may choose Borrower Investor Loan or Investor Recei
274. the Bank ID of the bank used for transfer of funds This field is optional unless SYNDi is integrated with an accounting package Enter the date of transaction The date must be prior to the next billing date of the loan If the loan has never been billed before the date must not be prior to the start date If the loan has been billed at least once the date should not be prior to the last billing date The range of valid dates is displayed on the screen for reference Enter the Investor ID maximum 16 alphanumeric characters user defined from whom the amount will be withdrawn It is necessary that the investor must be part of the syndicate and must have outstanding balance You may also select the investor by double click in the record selector area in investors table Finder is used to display a list of all records in the Investors table Enter the Investor ID maximum 16 alphanumeric characters user defined to whom the amount will be transferred You may also select the investor by double click in the record selector area in investors table if the investor wishes to increase his contribution Finder is used to display a list of all records in the Investors table Fly is used to set up an investor on the fly Enter amount transferred The system displays the balance of the principal for the From Investor If the investor is transferring only a portion of the balance enter it otherwise leave it unchanged Page 1
275. the digits methodology See Notes 6 to 9 in Section 1 2 The first method is suitable for payment frequencies based on months while the other two methods are recommended for weekly and bi weekly payments In case of blended payments enter the amortization period in years This field is disabled if you have set the payment type as interest only The payment for a period is calculated automatically for blended payments on the basis of principal interest rate payment frequency compounding frequency calculation method and amortization period You may change the value if necessary Once the loan has been set up the system cannot change the payment amount automatically if you change any parameter Page 152 Chapter 5 Working with Loans Maturity Date Expected Repayment Next Billing Date Last Billing Date Self Administered SYNDi Loan Manager User Manual affecting the calculation unless you click the Recalculate button The maturity date is calculated on the basis of start date and term Thus if the start date is March 20 2008 and the term is 24 months the maturity date will be March 20 2010 The maturity date can be changed if necessary but it must always be after the last billing date When the maturity date arrives the last billing is run on that date even if the next billing date has not yet approached The principal balance is added to the payment amount to calculate balloon payment an
276. the next page where it will ask you to upload your T5 XML document Upload your document and you will receive a Confirmation of Receipt also called Submission Number Keep this number in a secure place 26 Working with Original and Amended T5 Slips When you process T5 slips for the first time they are sent to CRA as Originals but if there is any discrepancy that you find later in the information processed for any investor you can re send those specific TS slips as Amended ones To do so you must click the Amended option button and then click the Load button You will see the list of SYNDi Loan Manager User Manual Page 306 Chapter 16 Loan Transfer all investors with No value under Apply column Here double click the No value under the column Apply for the investor whose T5 slip you want to process again Click Process button to repeat the process The screen snapshot shows that Amended T5 slip will be processed again for InvestorID CHOJIM Once the investors T5 slips are processed you will not be able to process the same investors as T5 slip as originals SYNDi Loan Manager User Manual Page 307 Chapter 16 Loan Transfer Chapter 16 Loan Transfer 16 1 Introduction 0 You may transfer all or a portion of balance from one loan to another This feature is especially useful in case of Construction Loans where you may set up a loan as the Credit Line with zero or low interest rate and then advanced money
277. to perform the following functions a Enter checks received from borrowers and apply them to existing receivables b Enter checks received from borrowers and apply them to billed service charges Chapter 11 c Apply existing unapplied receipts Chapter 11 to outstanding receivables d Write off outstanding receivables in case of foreclosure or bankruptcy Click Borrower Receipts on Main Menu to display the following screen containing two tabs described below SYNDiLM Borrower Receipts Sample Financial Co OX n j Receipts Entry Principal and Interest Misc Charaes Unapplied Cash Deductions Menu Process borrower receipts in block print various listings and post receipts Receipts Entry Enter borrower receipts This option allows freedom to enter partial receipts and write offs Principal and Interest Details of principal and interest in outstanding billing records Misc Charges Details of outstanding Miscellaneous Charges in the selected billing record Unapplied Cash Details of unapplied receipts entered through Miscellaneous Transactions SYNDi Loan Manager User Manual Page 242 Chapter 12 Borrower Receipts Deductions If you are deducting any charges e g down payment holdbacks administration fee etc you can enter them on this tab 3 You may access various tabs by clicking on the tab header 4 If you have enforced User Security in company profile setup ple
278. tors from the displayed list By default none of the investors are selected to be processed but if you need to select all investors from the list you may click All button If you want to remove any investor double click on the value Yes under Apply column at the investor row the value will become No and that investors information will not be processed for T5 slip 3 This module prints hard copies of T5 slips as well as generates XML document that conforms to CRA T5 schema and can be uploaded to CRA through internet link that is provided to us 4 If errors are encountered during processing of these slips they are displayed on the screen and steps are provided to correct those errors When you are done with the corrections then only you can generate the T5 XML document for uploading to CRA and MS Word copies of the T5 slips document for the Investors as well as CRA 5 When you click Prepare T5 Slips from Periodic Processing menu the following screen is displayed with 3 tabs will all fields and buttons as described below m SYNDiLM Prepare T5 Slips Sample Financial Cc Parameters ist Message Run Number a Year for which T5 Slips are being generated 2012 Indicate if you are generating original or amended T5 Returns Original Amended Indicate whether you will report interest earned during the year orthe Paid C Earned interest actually paid during the year Are you reporting gross amount or net amount
279. ts enter the number of years over which the loan will be amortized The default amortization period is taken from the Loan record but could be changed if necessary In case of Blended payments the program calculates the payment for a period made to the investor If the terms of the loan are changed the payment can be recalculated by clicking the Recalculate button or entered manually While entering a new receipt the system retrieves the percentage of management fee from the investor record The value can be changed if necessary An investor may be paid in the following cycles Monthly Quarterly Semi Annual Annual On Maturity In case of Monthly payments an investor can be paid on any date after running billing In case of Quarterly payments an investor can be paid on any date after March 31 June 30 September 30 and December 31 for all billings run before or during the first second third and fourth quarters of the calendar year For Semi Annual payments an investor can be Page 183 Chapter 6 Investor Receipts Investment Type Plan Type Plan Number Trustee ID SYNDi Loan Manager User Manual paid on any date after June 30 and December 31 for all billings run before or during first and second half of the calendar year For Annual payments an investor can be paid on any date after December 31 for all billings run before or during a calendar year If the Payment Frequnecy is On Maturi
280. tton displays the Unposted T5 Summary for selected investors based on the loaded data If you clicked Process and no errors were found SYNDi prepares T5 Slips saves them in files and generates XML file to be uploaded to CRA s website Click Upload button to access CRA s web page Once the data has been uploaded to CRA s website it returns a Submission Number which should be entered as the Confirmation Number to the database so that SYNDi knows that the T5 run has been completed successfully Click Confirm to enter the Confirmation Number Page 297 Chapter 16 Loan Transfer Close Parameters Tab This tab has the following fields Run Number Year for which T5 Slips are being generated Indicate if you are generating Original or Amended T5 Returns Indicate whether you are reporting earned interest or interest actually paid during the year Are you reporting Gross amount or Net amount i e interest minus any fee minus any taxes deducted SYNDi Loan Manager User Manual Click this button to exit the T5 slip module This field is used to enter and search for previous T5 Runs The Run Number is generated by SYNDi when you click Generate button Any run that does not have the Confirmation Number is considered incomplete If you generate less than 50 slips and send the copies to CRA instead of uploading the data you should enter 0000000 for Confirmation Number Enter the year for which T5
281. ty the investor is paid all instalments when the loan is discharged Payment Cycle may vary from investment to investment When an investor receipt is created it uses the Default Payment Cycle from the Investors Table but can be changed if necessary See Section 4 10 for explanation Page 184 Chapter 6 Investor Receipts 6 4 Activity Tab 1 The tab displays the contribution of the current investor and total contribution of investors to the loan as well as principal and interest paid to date It also displays the amount advanced to the borrower and the principal and interest paid to date by the borrower SYNDi LMS Investor Receipts Sample Financial Company BEE Opt Fields Menu Receipts Entry Terms i Loan ID BIR1160 Investor ID GOLBAR Principal Borrower ID Interest Paid Principal Paid Borrower 725 000 00 SAMSAM 189 406 14 0 00 Amount Loaned Amount Committed Interest Paid Principal Paid This Investor 175 000 00 0 00 45 718 86 0 00 Amount Loaned Amount Committed Interest Paid Principal Paid All Investors 725 000 00 0 00 189 406 14 50 000 00 Save Delete Close SYNDi Loan Manager User Manual Page 185 Chapter 6 Investor Receipts 6 5 Optional Fields Tab 1 The tab is displayed as follows SYNDi LMS Investor Receipts Sample Financial Company Menu Receipts Entry Terms Activity Opt Fields gt Investment Type 2 The optional field
282. ue using the Software Additional Items e All applicable taxes and delivery charges are in addition to the listed prices INDUS reserves the right to increase rates for Services at any time without notice INDUS reserves the right to increase Annual Fees if applicable with 30 days advance notice from any renewal date e Neither party shall be liable for delay or failure in performance resulting from acts beyond their control including but not limited to Acts of God acts of war riot fire flood or other disaster acts of government strike lockout communication line or power failures failure inoperability or destruction of Your computer e This Agreement shall be governed by and in accordance with the laws of the Province of Ontario Canada e The Customer shall have no right to assign this Agreement without the express written permission of INDUS e This Agreement and any Schedule attached hereto contains the complete and exclusive statement of the Agreement between the parties with respect to the subject matter hereof and supersedes all prior and contemporaneous agreements understandings proposals negotiations representations or warranties of any kind whether oral or written No oral or written representation that is not expressly contained in this Agreement is binding on INDUS e The customer acknowledges that there are no warranties or conditions expressed or implied arising out of this Agreement including but not limite
283. ulate interest in various scenarios and are intended for advanced readers If you do not want to concern yourself with such details you may ignore the rest of this chapter SYNDi Loan Manager User Manual Page 7 Chapter 1 Introduction 1 2 1 No Compounding Interest Only Loans l Monthly interest rate r is calculated by dividing the annual interest rate i by 12 number of months in the year r 12X100 For example if the rate is 9 per annum the monthly rate will be 0 0075 Monthly interest is calculated by multiplying the principal amount P by the monthly rate I PXr Thus if the principal is 100 000 and the interest rate is 9 per annum we have P 100 000 and i 9 the monthly interest is I 100 000X 0 0075 750 In order to calculate interest for part of the month calculate daily rate by multiplying the annual interest rate i by the number of days d and dividing by 365 number of days in the year For example if the rate is 9 per annum the daily rate will be 9 365 or 0 02465753 Interest Z for certain number of days d is calculated by multiplying the principal amount P by the monthly rate divided by 100 P iXd 365X100 Thus if the principal is 100 000 and the interest rate is 9 per annum we have P 100 000 and i 9 the interest for 21 days is I 100 000 X me 517 81 365X 100 SYNDi Loan Manager User Manual Page 8 Chapter 1 Introduction
284. uments in accordance with the Mortgage Brokerages Lenders and Administrators Act of Ontario Canada e Statement of Mortgage e Administration Agreement e Investor Disclosure Statement e Investor Acknowledgement Templates can be set up for other jurisdictions Loan Documents are available only if you are managing Multiple Investors and are generated at the time of originating a loan Loan Documents are generated as a xls file if you are using Microsoft Excel 2003 or as a pdf file if you use Microsoft Excel 2007 or higher It is necessary to have Microsoft Excel installed on your computer Loan Documents can also be e mailed automatically to investors if you are using Microsoft Outlook for your e mails and the investor has a valid e mail address specified in the Investors table SYNDi Loan Manager User Manual Page 312 Chapter 17 Loan Documents 17 2 Setting up Loan Documents Step 1 Specify Multiple Investors Make sure that you have specified in Company Profile Setup Section 4 3 that you maintain Multiple Investors If not do it now Step 2 Link Properties In order to generate Loan Documents it is necessary that Loans be linked to Properties This can be done in Templates Setup Section 5 2 by checking that Loans are linked to Real Estate Properties Step 3 Define Property Types Please refer to Section 5 4 to set up Property Types The valid Property Types for Loan Documents to work properly are as fol
285. unpaid balance Close 15 The fields shown on the screen are described below Rank Billing Day SYNDi Loan Manager User Manual User defined field maximum 16 characters Rank is normally specified for mortgages e g io 34 mortgage etc The day on which the payment is calculated This process is called billing Following are valid values for Billing Day for each payment frequency Term 0 Daily 0 Weekly 0 Bi weekly 0 Semi monthly 1 or 2 Monthly Between 1 and 31 Bi monthly Between 1 and 31 Quarterly Between 1 and 31 Semi Annual Between 1 and 31 Annual Between 1 and 31 Page 150 Chapter 5 Working with Loans Payment Type Penalty Months Billing Frequency Compounding SYNDi Loan Manager User Manual In cases where the valid value of Billing Day is zero SYNDi sets the billing process automatically depending on the payment frequency For semi monthly payments billing is run on the 1 and the 16 of the month if Billing Day is set to 1 and on the 15 and the last day of the month if Billing Day is set to 2 In other cases Billing Day represents the day of the month on which billing is run If the number of days in a month is less than Billing Day then billing will be run on the last day of that month Select if the borrower will pay interest only or blended payment so that the payment includes a portion of principal calculated according to the formulas given below Enter th
286. utomatically generates all Miscellaneous Charge Codes for which Loan Discharge is checked and applies them at the time of discharge When you define a Miscellaneous Charge Code with Loan Discharge checked it is not applied automatically to existing loans and a Miscellaneous Charge record has to be created manually Page 95 Chapter 4 Setting up the Application Add Click to add a new record Save Click to save an existing record It is highlighted only when the user changes a field Delete Click to delete an existing record Close Click to close the screen rn EE 3 To set up a new record click New to clear the screen Enter the Miscellaneous Charge Code If the record is already present in the table the data is displayed and the fields could be modified 4 You may hit lt Tab gt key to move from one field to the next Alternatively you may click inside a field and modify it 5 If you do not click the New button while entering a new record the data from the previous record remains on the screen You may change any fields if necessary and then click Add to add the record 6 To modify an existing record enter the Miscellaneous Charge Code or use Finder to select a record Enter the fields and click Save to save changes 7 To delete a record click Delete You cannot delete a record if the Miscellaneous Charge Code has been assigned to a loan 8 Itis mandatory that either the Borrower percentage or the Investor
287. vDate Committed Subscribed Available Applied _ 5 5 2011 350 000 350 000 0 6 30 2011 400 00 400 000 OYes 1431 2012 250 00 250 000 OYes 3 15 2012 500 000 500 000 OYes 9 21 2012 200 000 200 000 0 Mortgage Amount Committed Subscribed Available Save Delete 18 The fields shown on the screen are described below Commitment Date Enter applicable date Disclosure Enter applicable date Statement Date Mortgage Proposal Enter applicable date Date Mortgage arranged Enter applicable date before Fund Advance Provision is there to enter dates for Dates installments in which the total mortgage amount will be brought to the level specified on Tab 2 The date for the first installment is always equal to the Closing Date specified on Tab 2 and cannot be changed Committed This column contains the amounts committed to the borrower for each installment The total of all commitments should be equal to the SYNDi Loan Manager User Manual Page 328 Chapter 17 Loan Documents mortgage amount Subscribed This column displays the total amount subscribed by investors for each installment Investor subscriptions are entered on Tab 12 Available This column displays the amount still available to be subscribed for each installment 19 In order to enter a new advance click in the empty date field under the last advance date and enter the date Just make sure that the mortgage amount
288. ve an existing record It is Save ie highlighted only when the user changes a field Delete Click to delete an existing record Click to close the screen HEE Close 6 To set up anew investor click New to clear the screen Enter Investor ID If the record is already present in the table the data is displayed and the fields could be modified 7 You may hit lt Tab gt key to move from one field to the next Alternatively you may click inside a field and modify it 8 If you do not click the New button while entering a new record the data from the previous record remains on the screen You may change any fields if necessary and then click Add to add the record SYNDi Loan Manager User Manual Page 113 Chapter 4 Setting up the Application 9 To modify an existing record enter the Investor ID or use Finder to select a record Enter various fields and click Save to save changes 10 To delete a record click Delete You cannot delete an investor record that has already been assigned to a loan 11 While entering a new record the name address telephone number and fax number on Name and Address tab is automatically copied into the Personal Data tab You may change the values if necessary SYNDi Loan Manager User Manual Page 114 Chapter 4 Setting up the Application Personal Data Tab 12 The tab is displayed as follows SYNDiLM Investors Setup Sample Financial Company Name and Addres
289. ver if you have customized these templates or have embedded you company logo your changes will be lost One strategy could be to leave them there for the time being and see how the new version of SYNDi Loan Manager treats them If you start getting errors in one or more templates you may have to delete them and run the program so that it copies the latest template After that you can customize those templates Install SYNDi Loan Manager as described in Section 2 1 of the User Manual Make sure that you install it in the same folder in which it SYNDi Loan Manager User Manual Page 54 Chapter 3 Running the Application 10 11 12 13 was installed initially otherwise you may get version conflicts Run SYNDi Loan Manager and Activate it using the Activation Key for the new version When the database is opened the following screen is displayed Data Upgrade You are using version 5 7 of the application but the data is from version 5 6 It is important that you back up your data before you upgrade it If you have not backed up the data please do not proceed to upgrade If you want to upgrade the data now click Proceed otherwise click Cancel Cancel It is recommended that you make a copy of SYNDi mdb in case you have to revert to it If you have not already done so click Cancel and run the program again after making a backup copy Click Proceed to upgrade the database The upgrade process may take a fe
290. w minutes depending on the volume of data The program displays the progress of conversion as it goes through various tables and modifies them Please do not turn the machine off while the conversion is in progress Please note that once a database has been upgrading it cannot be used with an older version of the program When conversion is completed the program confirms that Data Upgrade is successful and displays main menu SYNDi Loan Manager User Manual Page 55 Chapter 3 Running the Application 3 14 Creating SQL Server Database A Creating SQL Server Database 1 SYNDi uses SQL Native Client to connect to the database If you have SQLExpress installed you will have to download the SQL Active Client from Microsoft otherwise it gets installed automatically in full blown version of SQL Server However it is not recommended to use SQLExpress with SYNDi 2 In this section we are using the user interface for Microsoft SQL Server 2008 If you have a different version the interfacec may be slightly different 3 Suppose you are creating a SYNDi database for Acme Financial Services and want to call the database Acme Run SQL Server Management Studio right click on Databases folder and choose New Database Enter Acme for the database name aned click OK 4 Once the database Acme has been created it is blank and you have to create necessary tables in it It can be done as follows a Run SQL Server Management Studio
291. wer will pay 1 000 a month Set Payment Type to Blended Compounding to None and Amortization Period as 12 months Set the Payment Amount to 1 000 SYNDi Loan Manager User Manual Page 154 Chapter 5 Working with Loans Notes Tab 18 The tab is displayed as follows SYNDi LMS Loan Maintenance Sample Financial Company BEE Property Contacts Documents Opt Fields Remarks 1077 Avenue Street West Toronto ON M3A 0B0 le e Note 1 Co signer George Smith Check credit rating a Note 2 Past history good No default history a See Mortgage ERIN651 in 1995 Note 3 Principal Advanced 100 000 00 Investor Commitments Principal paid to date 2 270 72 Interest paid to date 30 220 88 Borrower Balance 97 729 28 Investors Balance 0 00 Save Delete Profile Amortization Investors Inquiry Close 19 The fields shown on the screen are described below Remarks A memo field of virtually unlimited size to enter descriptive statements Notes 3 memo fields of virtually unlimited size to enter descriptive statements 20 The screen also displays various control totals such as the amount advanced to the borrower principal and interest paid to date by the borrower total balance owed by the borrower and total balance owed to investors SYNDi Loan Manager User Manual Page 155 Chapter 5 Working with Loans Property Tab 21 This tab is used only if loans are linked to properties as specifi
292. y also zero out all principal interest fee withheld tax and sales tax amounts by clicking the Initialize button and retyping the amounts as required making sure that the total amounts should be equal to the amounts shown on the Loan Adjustments Entry screen You may also click the Distribute button to recalculate the distributed amounts 7 Once the Borrower and Investor amounts are in balance click Add to add the record to the database 8 If you have received an amount as an interest adjustment from the borrower you may enter it with zero principal and distribute it to the investors through Loan Adjustments The interest amount should be entered without a minus sign SYNDi Loan Manager User Manual Page 217 Chapter 9 Loan Adjustments 9 5 Menu Tab 1 The tab is displayed as follows SYNDi Loan Adjustments Sample Financial Company E Henui Adiustments Entry E Print Unposted Adjustments i5 Print Posted Adjustments iE Post Adjustments Delete 2 The functions shown on the screen are described below Print Unposted Adjustments Generates a report showing unposted adjustments for selected loans and date range See Sample Report in Appendix A Print Posted Adjustments Generates a report showing posted adjustments for selected loans and date range See Sample Report in Appendix A Post Adjustments This function marks all unposted adjustments as posted Posted adjustments cannot be modifi
293. y time a check is returned to the borrower the NSF Miscellaneous Charge Code will be applied See Section 4 6 Prepaid Interest This field is available only if you have Code indicated in the Company Profile that you do not deal with multiple investors When you set up a new loan and deduct prepaid interest at the time of advancing the loan SYNDi will use the Miscellaneous Charge Code specified in this field to deduct the prepaid interest amount automatically from the amount advanced Set up a Miscellaneous Charge Code and enter it here See Section 4 6 Down payment If you charge the borrower a deposit or down Code payment before advancing the loan amount set up a Miscellaneous Charge Code Section 4 6 SYNDi Loan Manager User Manual Page 139 Chapter 5 Working with Loans and specify it on this screen When the deposit is received the G L account specified in the Miscellaneous Charge Code is credited When the loan is funded that account is debited so that it acts as a clearing account The option to set up Down payment Code is not available if you have checked Multiple Investors in Company Profile Late Payment This field is used only if you are using SYNDi Charge Code Service to automate messages to borrowers On Account While entering Borrower Receipts Chapter Receipt 12 you may leave a receipt on account to be applied later Tax Authorities Tax can be calculated on fee charged from investors dependin

Read User Manual - INDUSFLOW SYSTEMS

Contents

Download Pdf Manuals

Related Search

Related Contents