How to generate the borrower statement of account for a line of credit loan?
This part of the documentation discusses how to generate the borrower Statement of Account for a line of credit loan.
Even though at the time the finance charges are assessed a borrower billing statement is produced, it may be necessary at times to generate a statement of account on demand. Unlike the billing statement, the statement of account can be produced for any range of dates, and its summary section provides the amount of interest the borrower paid year-to-date as well as for the reporting period.
TIP: Provide a more professional looking statements by incorporating your company's logo. To learn how click here.
NOTE: We suggest pre-printing Your Billing Rights on the reverse side of the billing statement.
The statement of account can be generated from the Lines of Credit Grid or from Tasks & Reports.
To print the borrower Statement of Account from the grid:
- Click on the
Loan Servicing drop-down menu in the left panel of The Mortgage Office®.
- Click the Loans drop-down menu.
- Click Lines of Credit from the list that drops down.
- From the Lines of Credit grid, select the loan you want to modify.
TIP: If the record you want to edit is not visible, use the grid's vertical scroll bar to scroll the contents of the grid up or down, or click Find to search for the record by entering your own search criteria. For additional information see How to Use Find and How to Use the Data Grids.
- Click
Print and from the drop-down choose to print a statement for the selected borrower or for multiple borrowers.
- From the dialog box that pops, you have the option to select All Loans or Selected Loans by Account from the drop-down list.
TIP: When you choose Select Loans by Account you must enter starting and ending account numbers in then From and To input fields. You can enter the same starting and ending account number to select a single loan, or you can enter a logical range to select multiple loans. For example, if you enter HBT as the starting and ending accounts, all loans with account numbers starting with HBT will be included.
TIP: Click to open a lookup window that allows you to select a record from a list of existing records. For more details see How to Use Lookup Windows.
- Select Envelope Size. Select an envelope size from the drop-down list. The available choices are:
- None. Default. No special adjustments are made for window envelopes.
- DFS-771 (4 1/8 x 9 in)
- Size 9 (3 7/8 x 8 7/8 in)
- Size 10 (4 1/8 x 9 1/2 in)
TIP: You can use the Window Envelope Alignment tool to adjust the location in which the company's return address and the recipient's address are printed. For more details see How to use window Envelope Alignment tool.
- Select the Statement Period from the list.
The available options are:
- All Dates
- Month to Date
- Quarter to Date
- Year to Date
- Last Month
- Last Quarter
- Last Year
- Custom Period
- Select Loan Categories to Include or Exclude. Use this option to include or exclude loans based on their categories.
- Click
Next.
- Select Borrowers presents a list of borrowers based on the criteria and options you entered in the prior step. You may individually check or uncheck borrowers you do not want to send a statement to.
TIP: You can use the Select All and Clear All hyperlinks near the bottom of the window to check or uncheck all borrowers on the list.
NOTE: You won't be able to proceed to the next and final step unless one or more borrowers are selected.
- Click
Next.
- Click
to preview the statements, and
to send statements to the list of borrowers via E-mails.
- Click Edit Message to open a dialog window and edit the E-mail message text. The message can be a maximum of 1,024 characters long.
Override delivery options and preview statements for all selected loans will allow you to override the delivery options in the borrower file and will preview statements for all of the selected loans regardless of options chosen.
Create attachments will save a copy of the statement in the borrower's file.
- Click
or the grey X in the corner of the assistant to exit.
TIP: To know more about how to use the print preview window, click here.
To print the borrower Statement of Account from Tasks & Reports:
- Click on
Loan Servicing in the left panel of The Mortgage Office®.
- Click Tasks & Reports.
- Under the Line of Credit / HELOC section, click
Borrower Statement of Account.
- Select Loans by Account. The drop-down choices are:
- All Loans
- Select Loans by Account.
TIP: If you choose to select loans by account, click the lookup tool in the From: & To: fields to choose a range of borrowers. Read more about the lookup tool here.
-
Select Envelope Size. This selection aligns the location of the borrower's address on the statement with several commonly available window envelops. The drop-down choices are:
- None (best for sending the statement via e-mail or exporting it to PDF format)
- DFS-771 (4-1/8 x 9)
- Size 9 (3-7/8 x 8-7/8)
- Size 10 (4-1/8 x 9-1/2)
- Next, use the options found in the Statement Period section and select a range of dates. This selection determines the amount of activity printed on the statement as well as the period-to-date and year-to-date information displayed in the summary section of the statement.
NOTE: If you select All Dates from the list, the statement will not report any year-to-date interest.
- The available options are:
- All Dates
- Month to Date
- Quarter to Date
- Year to Date
- Last Month
- Last Quarter
- Last Year
- Custom Period
TIP: If you want to manually enter From: and To: dates, select Custom Period from the drop-down list.
-
If necessary, use the Select Categories to Include or Exclude dialog to include or exclude loans based on their categories.
NOTE: Categories are keywords or phrases that help you create logical loan groups. To learn more read How to Use the Categories Window.
TIP: You may, as many times as needed, use the Next and
Back navigation buttons to retrace your steps and make changes.
- Click
Next.
- The next step, Select Borrowers, presents a list of borrowers based on the criteria and options you entered in the prior step. By default, all borrowers are selected to receive a statement, but you may individually uncheck borrowers you do not want to send a statement.
TIPS:
- You can use the Select All and Clear All hyperlinks near the bottom of the window to check or uncheck all borrowers on the list.
- The Export to Excel hyperlink will download all
checked borrowers to your computer's Downloads folder.
NOTE: You won't be able to proceed to the next and final step unless one or more borrowers are selected.
- Click Next, which brings you to the Preview or E-mail Statements dialog box with the following options:
Override delivery options and preview statements for all selected loans
Create Attachments
- The Window Envelope Alignment hyperlink brings up the following options under Select Envelope Style:
- DFS-771 (4-1/8 x 9)
- Size 9 (3-7/8 x 8-7/8)
- Size 10 (4-1/8 x 9-1/2)
- Once you've chosen an envelope style, press
Apply or
Cancel.
- Click
to bring you back the Preview or E-mail Statements dialog box.
- To preview a statement, click
Preview Statements. For additional information see How to Use the Print Preview Window.
- To email a statement, click
Email Statements.
-
To edit a message, click
Edit Message to edit the message text. The message can be a maximum of 1,024 characters long.
- To preview a statement, click
- Click
when you are finished.
Copyright © Applied Business Software, Inc. All Rights Reserved.