# Statement Management

Maica offers you the flexibility to manually send statements to all participants for a selected statement period, alternatively there is a set and forget method to send statements on a monthly basis. This article explains how this can be achieved directly in Maica Settings under Statement Management.&#x20;

Before we get into the details, you will need to ensure two things:&#x20;

* The **From Email Address** is selected.  This defines the email address that the statement is sent from. Be sure to firstly add this by navigating to `Organization-Wide Addresses` under Salesforce Setup.
  * Learn more about setting up an Organization-Wide Address [here](https://help.salesforce.com/s/articleView?id=000358240\&type=1).

![Selecting the From Email Address in Maica Settings](https://558904096-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKdn9R0jFmixyPeVowFpF%2Fuploads%2FS8UDV74wwkn9o3K2LuKe%2Fimage.png?alt=media\&token=b02b0816-5ff1-447e-ac62-050ea904dbfc)

* The **Participant Statement Email Template** is selected.  This defines the email template containing the funding statement generated for the selected period.&#x20;
  * `Maica NDIS Plan Participant Statement` is the default template from Maica. In the [Participant Statement Email Template](https://kb.maica.com.au/ndis-management/participant-statement/participant-statement-email-template) section, you will learn how to customise the email template.

![Selecting the Statement Email Template in Maica Settings](https://558904096-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKdn9R0jFmixyPeVowFpF%2Fuploads%2FMCn2nrerajYJeViXHtT9%2Fimage.png?alt=media\&token=cd06d159-ec10-46ce-a449-86734320fb73)

## &#x20;Manually send monthly funding statements

With just a few clicks, Maica can send on demand statements to all your participants. Everything you need to configure this can be found in the **Email Statements** section:

* Select the `Statement Period` via the **Start Date** and **End Date** and click **Email Now**.<br>

![Manually sending Funding Statements via Maica Settings](https://558904096-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKdn9R0jFmixyPeVowFpF%2Fuploads%2FmFcRWOEPaq3VX76cdoMG%2Fimage.png?alt=media\&token=c875111f-9422-44ab-b0b2-c6ecce985a3a)

* A confirmation screen will be displayed immediately confirming this action, if you would like to proceed, click **Confirm** for Maica to send statements to your participants for the selected period.

![](https://558904096-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKdn9R0jFmixyPeVowFpF%2Fuploads%2FY7N4So4496m7cYtHdTJv%2Fimage.png?alt=media\&token=de1f47b4-afb3-4cc7-935a-4e495d6e0068)

## Schedule and automatically send monthly funding statements &#x20;

{% hint style="info" %}
Maica can automate this monthly process for you so participants receive their monthly statements. You can do so by simply toggling the **Schedule Statement** to activate it and follow a few extra steps.
{% endhint %}

![Scheduling the automated dispatch of Funding Statements via Maica Settings](https://558904096-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKdn9R0jFmixyPeVowFpF%2Fuploads%2FiACKMLuZL8YkAe0LuNHV%2Fimage.png?alt=media\&token=7b4bf7d8-d67b-4756-b4c4-58cbfad61882)

* Once the **Schedule Statement** toggle is enabled, you will be prompted to assign the **Day** and **Time** in which the statement is sent to participants.&#x20;
* On save, Maica will calculate the next scheduled date to send the statement.
* You can also track the progress and any errors during the statement run by accessing the report that is linked.

{% hint style="warning" %}
Please note: Salesforce enforces a limit of 5000 external emails each day.  Any emails beyond the 5000 limitation will fail.  You can read more in the following [Salesforce Article](https://help.salesforce.com/s/articleView?id=sf.limitations_email_mass.htm\&type=5).
{% endhint %}

## Who Will Receive a Statement?

Maica provides the following two filter options where **you can decide** who will be included in the automated Statement process:

<figure><img src="https://558904096-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKdn9R0jFmixyPeVowFpF%2Fuploads%2FbcjLu2WhuGjBRmcuUpnM%2Fimage.png?alt=media&#x26;token=8ae088d5-6688-4a75-8820-29e66e0fa9c2" alt=""><figcaption><p>Maica provides two filter options to decide who is included in your Statement run</p></figcaption></figure>

### All Active Plans

* `Plan Start Date` is less than or equal to the Start of the Month
* `Plan End Date` is greater than or equal to the End of the Month
* `Exclude From Plan` is not set to TRUE

Or, for a more technical user:

{% code overflow="wrap" lineNumbers="true" %}

```
SELECT Id
FROM Plan__c
WHERE Start_Date__c <= :startDate
AND End_Date__c >= :endDate
AND maica__Exclude_From_Statement__c != true
```

{% endcode %}

### All Active Plans with Standard Bookings

This filter includes all the `Plan` based conditions described above with an additional filter added on the `Service Booking` object to include only those Plan records with an associated **Standard Service Booking**.

Or, for a more technical user:

{% code overflow="wrap" lineNumbers="true" %}

```
AND (Id IN (SELECT maica__Plan__c FROM maica__Service_Booking__c WHERE maica__Booking_Type__c = 'ZSAG'))
```

{% endcode %}

### Exclude from Plan

In the section above, you will have noticed a reference to a filter called **Exclude from Plan**.  This filter references a handy checkbox on the `Plan` record that allows you to manually exclude a Participant from being included in the automated monthly Statement process.

For example: you have a Participant with an Active `Plan` in Salesforce who is no longer one of your clients.  By setting Exclude from Statement = TRUE, this former client will not receive an automated Statement email.

<figure><img src="https://558904096-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKdn9R0jFmixyPeVowFpF%2Fuploads%2FpTVWe9babamQycz8sflT%2Fimage.png?alt=media&#x26;token=6a653221-5ea0-4a91-82a7-22b95b4ac1da" alt=""><figcaption><p>The Exclude from Statement checkbox on the Plan record</p></figcaption></figure>

{% hint style="info" %}
For the automated Statement batch, the `Start Date` and `End Date` are set from the **previous month**.

For any manually sent Statements, the `Start Date` and `End Date` are set by the user using the filters in the Quick Action.
{% endhint %}
