A Write-Off transaction is used to record partial or total loan amounts that are not recovered. A Regular write-off will apply the entire amount to the loan’s principal balance. Accordingly, the amount to be written off cannot exceed the principal amount owing on the loan. A Customized write-off will allow the user to allocate the amounts to be written off for the various outstanding loan amounts (principal, interest, fees and insurance). The total amount of the Write-Off transaction is calculated by the program by summing the amounts entered on the Allocate screen and cannot be edited by the user.

From within a loan, select Transactions in the navigation tree.

1. Click the New button, or select File | New | Transaction from the menu.
2. From the Action drop-down menu, select Write-Off.
3. From the Sub-action drop-down menu, select Customized.
4. Click the Allocate button.
5. Distribute the amount to be written off to the appropriate outstanding amounts.
6. Click OK to save the allocated amounts. The total of the allocated amounts will appear in the Amount field (read only).
7. Click Calculate. Verify the results of the transaction in the Verification pane.
8. If satisfied, click Post to post the transaction to the loan.
9. Click the Close button to close the Add Transaction dialog box.
10. Select the General Loan Information screen.
11. Change the Loan Status to Bad Debt.
12. Un-select the Active check-box to make this loan inactive.
13. Click Save & Close.

Recovery payments can be recorded in a loan that has been written off as long as that loan is still active and it’s status has not been set to Paid in Full. Because the loan has already been written off, the recovery payment will not be applied to loans receivable, like a regular payment. Instead, the general ledger transaction will be exported to your accounting system as a debit to the bank account and a credit to bad debt recoveries.

1. From within a loan, select Transactions in the navigation tree.
2. Click the New button, or select File | New | Transaction from the menu.
3. From the Action drop-down menu, select Recovery.
4. Click the Allocate button.
5. Enter the amounts to be recovered in the appropriate fields.
6. Click OK to save the allocated amounts. The total of the allocated amounts will appear in the Amount field (read only).
7. Click Calculate. Verify the results of the transaction in the Verification pane.
8. If satisfied, click Post to post the transaction to the loan.
9. Click the Close button to close the Add Transaction dialog box.
10. Back on the loan record, click the Save & Close button.

Custom filtering may be applied to many of the grids within TEA to further refine the results displayed within a list. A filter can be set on one or more of the columns within a grid so that only those records meeting a specified criteria will be displayed in the grid. For example, within the loans module, a filter may be placed on the loan type column so that only term loans and line of credit loans will be included in the list. If a grid has auto-filtering enabled, a small, outlined down-arrow will be displayed next to some or all column headers. Once a filter is applied to a grid, the setting may be saved so that even if TEA is closed and then reopened the custom setting will remain in effect.

1. From any module in TEA, click the drop-down arrow beside a column header and select Custom.
2. Using the drop-down menus, select the filter criteria.
3. To use the And or the Or operator to combine two conditions, simply click in the Radio Button next to the desired operator. Set the parameters of the second condition as desired.
4. Click OK to execute the filter and to close the Custom AutoFilter window.

Note: After running a filter, a small blue triangle appears in place of the black down arrow to the right of the name of a column, indicating the column to which the filter is applied.

Anytime a change is made to a grid in TEA by a user, those changes can be saved. Grid settings are saved by the individual user so changes made by one user will not affect the grid of another TEA user.

1. After changing any of the grid settings or formatting, select View | Grid Settings from the menu.
2. If this feature is enabled for the particular grid you are viewing, click Save Settings.

Note: Every screen that has changes made to the grid settings must be saved individually. Only the changes of the grid currently displayed will be saved.

4. Cleaning up the Data directory - Keeping TEA IX Running Smoothly

There are 3 primary file types that belong in the Data directory: *.DAT, *.IDX, and *.BLB. Miscellaneous files (*.TXT, *.TMP, and *.ZIP) are sometimes copied in the Data directory inadvertantly, while others are created during the update process. Once your update is completed successfully, you should delete all *.DBK, *.IBK, and *.BBK files. This will keep your directory free of unnecessary files.

Contact us:

© 2006 CommonGoals Software, All rights reserved. Microsoft, Excel, PowerPoint and Windows are registered trademarks of Microsoft Corporation in the United States and/or other countries.