---
title: "Supplier eStatement Configuration Guide"
canonical: "https://kb.myframeworks.com.au/space/CO/30507242/Supplier%20eStatement%20Configuration%20Guide"
format: markdown
---
From the Frameworks Menu go to Miscellaneous Table Installer and run** InstallerFW6551: Mitre10 Supplier eStatement Account Reconciliation**. This will load the required eStatement flags that will need to be configured:

## Setup eStatement General:

1. From the Frameworks Menu go to **Miscellaneous Table Maintenance** and search for **EStatement General. **
2. Edit the **EStatement** **General** Parameters as required:

> ℹ️ - **Recon Tolerance Value** - This is the amount by which the statement line total may differ from the payment total in the recon 'To Match' screen. If the difference is greater than this amount then the 'Match' button will not be enabled.
> ℹ️ - **Notification Email Address** - This is the email address for when the scheduled task fails.
> ℹ️ - **Initial Cutoff Date** - This optional date will be used to ignore any supplier transactions before this date in the recon 'To Match' screen.
> ℹ️ - **Recon Rounding Account** - This GL account is used by the expense invoice that is posted when there is a difference between the statement total amount and the payment total amount in the 'To Match' recon screen.

3. Click the **Save** button.

## <span style="color: #172b4d">Setup eStatement Directories:</span>

1. From the Frameworks Menu go to **Miscellaneous Table Maintenance** and search for **EStatement Directories.**

![image](media://4c65cd1a-db09-4044-8dfa-a673216572f4)

These are the FTP directories for XML import option where to read & archived XML EStatement files received via FTP.

Values will be set by default to as per above.

2. On the Linux server create the following directories:

```
/prostix/live/estatement/send
/prostix/live/estatement/receive
/prostix/live/estatement/archive
```

3. Click the **Save** button

## Setup eStatement FTP Login Settings for Mitre10 sites:

1. From the Frameworks menu go to **Miscellaneous Table Maintenance** and search for **EStatement FTP Login Settings. **This stores the location of the FTP scripts.
2. Enter the parameters as per above for:
  - **Host** and **(S)FTP Port.**
  - The **User **and** Password **credentials** **as supplied by Mitre10.
  - The **Use (S)FTP Scripts** flag determines whether the scripts are used or if they are just ignored.  A possible scenario for this is if there is a problem with the server and you do not want the scripts to execute. By default this flag should is unticked unless store is a Mitre10 store receiving xml estatements.
3. Click the **Save** button.

## <span style="color: #003366">Setup eStatement FTP Scripts</span>

1. From the Frameworks Menu go to **Miscellaneous Table Maintenance** and search for **EStatment FTP Scripts. **This stores the FTP Script information .

![image](media://7563846e-d137-4d72-86d9-ce3439673025)

The information stored here is:

- The **Send Script **and **Receive Script** will default the the above filepath when the installer is run. Do not change these settings.
- The send and receive .sh scripts will be deployed as part of the code to **/prostix/{instance}/deploy/scripts** folder. Move the .sh scripts to **/prostix/bat **folder.

2. Update the **Email address for errors** filed to a nominated email to send errors to.
3. Click the **Save** button.

## Setup eStatement Import

1. From the home screen go to **My Shortcuts **and select the **Add** button.
2. When the popup search screen appears click on the **Close** button. A search box will now be available.
3. Enter **eStatementReconciliationSched **into the search box and click **Finish.**
4. The **Import Supplier Statements** task will now be added to your shortcuts menu.


## Setup eStatement menu Dashboard

1. From the Frameworks Menu navigate to **Screens & Menus **- **Menu Maintenance** to add the **Supplier Statement Reconciliation **menu option (if menu is not already displayed in the navigation tree).
2. Select **New** and enter details as per below:
3. Click the **Save** button.

## Setup Supplier Statement Import Format Maintenance (New Formats)

The generic default import format, named **Supplier Statement**, is created automatically by the Frameworks installer. No manual setup is required to use this default format - it's available immediately in **Supplier Statement Import Format Maintenance** (**Payables > Maintenance**), and as an **Upload Method** option on the **Supplier Statement Reconciliation** upload window and the **Import Supplier Statements** task.

To set up an additional custom format - for example, to match a specific supplier's non-standard statement layout - see [Create a Supplier Statement Import Format](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/993493002).