Billing statements are automatically generated at the end of each billing cycle. LoanPro will be able to access transaction statements from the most recent billing period up to 25 years in the past. This article will explain how to access statements for loan and line of credit accounts. We'll also walk through detailed field mappings, dynamic variable syntax, related database tables, and workflow steps for template updates.

Statement mapping

LoanPro’s context engine allows embedding dynamic fields within HTML templates. These variables (e.g., [[v('path')]] or [[formatNumber('path','2','.',' ,')]]) pull live customer, account, and transaction data directly from the LoanPro database. Refer to the complete list of database tables as well as formatting variables with functions articles for more information. 

Dynamic field mapping

Workflow for creating or updating templates

1. List all required dynamic placeholders for the statement (customer, balances, transactions).
2. Map each placeholder to the correct variable path and verify the database source.
3. Insert the placeholders into the HTML structure, preserving syntax.
4. Implement repeat loops for transaction tables or sections.
5. Test the template in Sandbox by generating it within a test account under ‘Statements’.
6. Statement template must be assigned to the account under ‘Account Settings’ > ‘Settings’ >
7. Edit ‘Which template will accounts use for statements by default?’.
8. Validate all values (balances, names, due dates) render correctly.
9. Maintain version control and a changelog of updates.

Accessing loan statements

To download statements as a PDF, use the billing tool. This is also helpful if you would like to print and mail bills to your customers using the billing templates that LoanPro provides. It can be found by navigating to Tools > Customer Communication > Billing inside your company account. If you want your billing statements to be entirely custom, you can create a Dynamic Template as a billing statement instead.

To send loans to billing, navigate to Account Manager and select the loans you would like to send. Click the 'Send to Billing' link. This will send you to the ‘Billing’ section in the Communication Suite. Here, you can choose your billing options and generate statements. 

At the top of the page are multiple billing template options. The image to the right of these options previews how the statement will look. You can set defaults for many of these values by clicking 'Defaults' in the top-right corner of the page. The template options you can adjust include the following: 

At the bottom of the page, you can remove any previously selected loans from the billing queue by clicking the red trash icon to the right of individual loans.

To generate the billing statements for the loans you have selected, click 'Generate' in the top-right corner of the page. This will generate PDFs for the statements you have created. To view the PDFs, click the 'Billing' header which will now display a notification counter of the form generation requests in the last 24 hours.

Accessing line of credit statements

In LMS, navigate to Lines of Credit >  Inside a Line of Credit account > Statements.

The statement is categorized by each the billing cycles of the account and provides details about the period through a number of different fields:

The download button at the far right of each entry lets you download the statements as a PDF. Clicking the arrow will open a new side window with more information about the transaction. 

To create a statement template, navigate to Settings > Line of Credit > Statements. Click ‘Add’ at the top right of the page to add a new template. On this page, you can give your template a name and choose whether you want it to be active/inactive using the ‘Status’ toggle switch. Turning the switch on sets the template as ‘Active’, which will make it available to use for a billing statement in an individual account. 

Below the ‘Name’ field is a dropdown menu for the template's file type. 'HTML' will open up our Dynamic Templates editor where you can use HTML to create your template in the software. Similar to Dynamic Templates, these templates use context variables that will pull data from the borrower's accounts and merge it into the templates. Once you finish creating your template, click ‘Save Changes’ at the top right of the page. 

The main ‘Statements’ page will show you all of the templates you've created in your tenant. At the right of each listing are the options to ‘Edit’ or ‘Delete’ your template. 

Once you've created a few statement templates, you can assign them to a line of credit account. This will ensure that the billing statement generated on the account will use the template that is assigned to it. To assign a statement template, go into an individual account and navigate to Account Settings > Settings. The ‘Account Settings’ section should be at the top of this page. Click the pencil icon at the top right to edit the ‘Account Settings’ section. Scroll until you see the ‘Statement Type’ field and click it to choose a template from the dropdown menu. 

It's important to remember that the templates that are set to the “Active” status in Lines of Credit > Statements will be available as an option in the ‘Statement Type’ field. After choosing the statement template for this account, click the ‘Save’ button at the bottom. 

Automating statement creation

You can automatically send billing statements to your customers at the end of each billing period after they're auto-generated using event-based notifications. Again, the process is different for loan and line of credit statements.