---
title: "Import Supplier eStatement"
canonical: "https://kb.myframeworks.com.au/space/CO/30509996/Import%20Supplier%20eStatement"
format: markdown
---
In addition to the CSV format and FTP method described below, supplier statements can now also be imported using the **ITM Supplier Statement** format or a custom format created in Supplier Statement Import Format Maintenance. See the **Supplier eStatement Import via Import task** and **Supplier eStatement Quick Import** sections for details.

Refer to the following reference guide for further information:

> Macro (toc)

## Supplier Statement .csv Format


All fields are mandatory aside from Statement Ref in the Header Line, so even if a value is not applicable a '0' should be entered so as not to misalign the file columns. 

Refer to the below template format for .csv supplier statement imports:



The transaction types available are:  
   
Invoice   
Claim   
Discount   
Journal   
Payment   
Debit Note   
Credit Note

Note: Mitre10 Store ID field in the .csv is the Mitre10 Store ID not the Branch code, as per Branch Maintenance:

![image](media://5da940ab-b311-4d16-81e3-f6b76b20118e)

## <span style="color: #003366">Supplier eStatement Import via Import task</span>

| **Step** | **Process** |
| --- | --- |
| 1 | From the hamburger menu go to **Supplier Statement Import** task |
| 2 | Select Upload Method - <span style="color: #000000">**CSV Import**</span><span style="color: #000000"> or </span><span style="color: #000000">**EStatement via FTP **</span> then tick Import File: [Unknown Attachment] report only. When ticked, transactions will NOT be imported into the** Supplier Statement Reconciliation** screen and will generate a report only. Leave unticked > Macro (inline-media-image)

 to  import the transactions when processed.<br>> ⚠️ The **CSV import** option will prompt for a text file with the format as per below sample:
> ⚠️ 
> ⚠️ ![image](media://1e2d724f-ce0a-4852-9987-25e06a1fa784)
> ⚠️ 
> ⚠️ <span style="color: #000000">** Estatement via FTP**</span><span style="color: #000000"> method will be used to connect to Mitre10, read the .xml files left on their main server, bring them down and import them.</span>
> ⚠️ 
> ⚠️ **ITM Supplier Statement** and custom formats use the field mapping defined for that format in Supplier Statement Import Format Maintenance, and must be uploaded as a **.csv** file. |
| 3 | Click **Upload CSV** to upload the CSV file. Then click "Submit" button at bottom right of screen |
| 4 | Once the task is finished check on the **Output **tab that task log has no reported errors then click the Generated Reports .html link to view import report.<br>Confirm that all the files from the .CSV has been processed.<br>> ⚠️ The Branch Number specified in the CSV file is first matched against the Branch Store ID, and if not matched, it will then compare against the Branch ID.
> ⚠️ 
> ⚠️ The Supplier ID will first be checked against the list of Suppliers in the system. If no matched has been found, it will then be checked against the Mitre 10 Suppliers. |
| 5 | When importing using **ITM Supplier Statement** or a custom format, note the following differences from the CSV Import format described above: the transaction type (Invoice or Credit) is set automatically from the sign of the imported amount rather than a Transaction Type column; **Invoice Number** is used to automatically match the imported line to an existing invoice in Supplier Statement Reconciliation, where one exists; and a line with a missing or invalid **Store Id** is skipped and reported as an error rather than imported. |

## <span style="color: #003366">Supplier eStatement Quick Import</span>

| **Step** | **Process** |
| --- | --- |
| 1 | From the hamburger menu type **Supplier Statement Reconciliation **(or navigate to** Payables - Transaction Processing - Supplier Statement Reconciliation **from the navigation tree) |
| 2 | Click > Macro (inline-media-image)

. The supplier statement import popup is displayed. |
| 3 | Select the upload method - CSV import, EStatement via FTP (for Mitre10 only), ITM Supplier Statement, or a custom format created in Supplier Statement Import Format Maintenance, and upload/attach the file. Uploads using **ITM Supplier Statement** or a custom format must be in **.csv** format. |
| 4 | Click "Save" to import the file. |

##   
View Imported Supplier Statements

| **Step** | **Process** |
| --- | --- |
| 1 | From the hamburger menu type **Supplier Statement Reconciliation **(or navigate to** Payables - Transaction Processing - Supplier Statement Reconciliation **from the navigation tree) |
| 2 | Search for the imported file/s, search options include Branch, Supplier, Date to and From:<br>![image](media://4162f756-16b6-411d-8db9-6181494eeffe) |
| 3 | Transactions matching the search criteria will be returned under **Results:**<br>![image](media://8dbdcf4b-9ee9-44c3-b3a0-8068a545702f)<br>**Columns displayed include:**<br>> Macro (nested-table) |