--- title: "Reconcile an Imported Supplier Statement" canonical: "https://kb.myframeworks.com.au/space/CO/30510362/Reconcile%20an%20Imported%20Supplier%20Statement" format: markdown --- Reconcile imported supplier statement lines against Frameworks accounts payable transactions to verify that your supplier records match the supplier's statement. The reconciliation process combines automatic matching with manual matching to resolve all statement lines. > 📝 ## Prerequisites > 📝 > 📝 - A supplier statement has been imported via the **Import Supplier Statements** scheduled task or the quick import function on the **Supplier Statement Reconciliation** dashboard, using any available Upload Method - the existing hard-coded formats, **ITM Supplier Statement**, or a custom format created in Supplier Statement Import Format Maintenance. > 📝 - The **Supplier Statement Reconciliation** screen is accessible from **Payables > Transaction Processing > Supplier Statement Reconciliation**. > 📝 - The supplier's invoices have been entered and posted in Frameworks before attempting to reconcile. ## The Reconciliation Workflow 1. Navigate to **Payables > Transaction Processing > Supplier Statement Reconciliation**. 2. Search for the imported statement using the Branch, Supplier and Date filters, then click **Find**. 3. Click the **Statement Reference** hyperlink in the results grid to open the reconciliation screen for the selected statement. 4. Review automatically reconciled lines on the **Reconciled** tab. 5. Manually match any remaining unreconciled lines on the **Unmatched** tab. 6. Print or email a reconciliation summary report. --- ## Review Automatically Reconciled Statement Lines When a supplier statement is imported, Frameworks automatically matches statement lines to accounts payable transactions based on matching criteria. All automatically reconciled lines appear on the **Reconciled** tab. ### Automatic Matching Criteria The automatic matching process matches a statement line to an accounts payable transaction when all of the following criteria are met: - The same supplier. - The same invoice reference number on both the statement line and the AP transaction, or the same creditor reference for invoices imported via the **Import Mitre 10 Creditor Invoices** process where the creditor reference is populated. - The same transaction amount on both the statement line and the AP transaction. > ℹī¸ This automatic matching process applies in the same way regardless of which Upload Method was used to import the statement, including statements imported using the **ITM Supplier Statement** format or a custom format created in Supplier Statement Import Format Maintenance. ### Steps 1. Click the **Statement Reference** hyperlink in the results grid to open the reconciliation screen. 2. Click the **Reconciled** tab to view all automatically matched statement lines. Each row displays the statement line matched to its corresponding AP transaction. 3. Review the matched lines to confirm the automatic matches are correct. 4. If a matched line is incorrect, enable the checkbox next to the statement line. The corresponding AP transaction is automatically selected. Click **Remove Match** to remove the match and return both lines to the **Unmatched** tab for manual reconciliation. ### Result Correctly matched lines remain on the **Reconciled** tab. Unmatched lines are moved to the **Unmatched** tab where they can be manually matched. --- ## Reconcile Unmatched Statement Lines Statement lines that were not automatically matched appear on the **Unmatched** tab. The left side of the screen displays unmatched statement lines. The right side displays unmatched AP transactions (labelled "To Match"). Manually select statement lines and AP transactions with matching values to reconcile them. ### Steps 1. Click the **Unmatched** tab. Unmatched statement lines are displayed on the left. Unmatched AP transactions are displayed on the right. 2. Enable the checkbox next to the statement line you want to match. 3. Enable the checkbox next to the corresponding AP transaction on the right. The selected statement total and the selected AP transaction total must be equal for the **Match** button to become active. If the difference between the totals is within the tolerance configured in the **EStatement General** settings, the **Match** button is also enabled. 4. Click **Match** to reconcile the selected lines. The matched lines move to the **Reconciled** tab. 5. Repeat steps 2 to 4 for each remaining unmatched statement line. ### Creating an Expense Invoice from a Statement Line If an unmatched statement line has no corresponding AP transaction in Frameworks, you can create an expense invoice directly from the statement line. 1. Click the plus (+) icon next to the unmatched statement line. The **Expense Invoice Entry** window opens with the statement line details pre-populated as a template. 2. Enter the GL account details for the expense invoice. 3. Click **Save**, then click **Post** to post the expense invoice. 4. The AP transaction list on the right refreshes automatically. The new transaction appears in the "To Match" list and can be matched to the statement line. ![image](media://f62449c2-4144-4bda-8604-deb907dddafb) ### Transferring Payments from Other Suppliers If a payment appears under a different supplier, you can transfer the payment to the statement supplier. 1. Click **Find Invoices**. A window opens displaying payments for other suppliers that can be transferred. 2. Select the payment to transfer to the statement supplier. Partially paid payments cannot be transferred. 3. Confirm the transfer. The payment appears in the "To Match" list for the statement supplier. ### Result When all statement lines are matched, the **Difference** value on the reconciliation screen displays as $0.00 (highlighted green), confirming the supplier statement is fully reconciled. --- ## Print a Reconciliation Summary You can print or email a reconciliation summary report at any point during the reconciliation process. ### Steps 1. Click **Print Reconciliation** at the bottom of the **Unreconciled** tab. 2. Select the output method: print, email or fax. 3. The report displays a summary of unmatched statement lines and unmatched AP transactions with their reference numbers, dates and amounts. --- ## Related Tasks **Before this procedure:** - [Import a Supplier Statement](https://sterlandsupport.atlassian.net/wiki/spaces/fwksproau/pages/30509996) (via scheduled task or dashboard quick import) **During this procedure:** - [Expense Invoice Entry](https://sterlandsupport.atlassian.net/wiki/spaces/fwksproau/pages/30524458) (for creating invoices from unmatched statement lines) **After this procedure:** - Supplier Statement Reconciliation can be used within [Payment Selection Batches](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28396048) to import reconciled statements for payment processing. > ✅ ## Related Information > ✅ > ✅ - *Supplier Statement Reconciliation Dashboard - Field Definitions [TBC]* > ✅ - [Supplier Dashboard](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28397304) > ✅ - [Invoice Maintenance Screen](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28390250) - Field Definitions > ✅ - [Stock Invoice Approval Screen](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28385042) - Field Definitions ## Additional Notes - The **Recon Tolerance Value** configured in the **EStatement General** settings determines the maximum allowable difference between the statement total and the AP transaction total when matching. If the difference exceeds the tolerance, the **Match** button is not enabled. - The **Initial Cutoff Date** in the **EStatement General** settings is used to exclude supplier transactions before a specified date from the "To Match" list. - The **Recon Rounding Account** GL account in the **EStatement General** settings is used for the expense invoice posted when a small difference exists between the statement total and the matched AP transaction total.