Supplier Statement Reconciliation

{{company_name}}

{{company_address}}

Phone: {{phone}} | Email: {{email}} | Web: {{website}}

Supplier Statement Reconciliation

Supplier Statement Reconciliation

{{company_name}} {{company_address}} Phone: {{phone}} Email: {{email}} Website: {{website}}

SUPPLIER STATEMENT RECONCILIATION

Supplier Name: {{supplier_name}}

Supplier Account Number: {{supplier_account_number}}

Statement Date: {{statement_date}}

Reconciliation Period: From {{start_date}} to {{end_date}}

1. Opening Balance Reconciliation

Supplier Statement Opening Balance: {{supplier_opening_balance}}

Our Records Opening Balance: {{our_records_opening_balance}}

Difference: {{opening_balance_difference}}

Notes on Variance: {{opening_balance_notes}}

2. Invoices Received and Processed

The following invoices were received from the supplier during the reconciliation period and have been processed in our accounting system:

| Invoice Number | Invoice Date | Amount ({{currency}}) | Date Processed | Status |

|---|---|---|---|---|

| {{invoice_1_number}} | {{invoice_1_date}} | {{invoice_1_amount}} | {{invoice_1_processed_date}} | {{invoice_1_status}} |

| {{invoice_2_number}} | {{invoice_2_date}} | {{invoice_2_amount}} | {{invoice_2_processed_date}} | {{invoice_2_status}} |

| {{invoice_n_number}} | {{invoice_n_date}} | {{invoice_n_amount}} | {{invoice_n_processed_date}} | {{invoice_n_status}} |

Total Invoices Processed: {{total_invoices_processed}}

3. Payments Made

The following payments were made to the supplier during the reconciliation period:

| Payment Date | Payment Reference | Amount ({{currency}}) |

|---|---|---|

| {{payment_1_date}} | {{payment_1_reference}} | {{payment_1_amount}} |

| {{payment_2_date}} | {{payment_2_reference}} | {{payment_2_amount}} |

| {{payment_n_date}} | {{payment_n_reference}} | {{payment_n_amount}} |

Total Payments Made: {{total_payments_made}}

4. Credit Notes and Adjustments

Details of any credit notes or other adjustments issued by the supplier or processed internally:

| Reference | Date | Type (Credit Note/Debit Note/Adjustment) | Amount ({{currency}}) | Reason |

|---|---|---|---|---|

| {{adjustment_1_reference}} | {{adjustment_1_date}} | {{adjustment_1_type}} | {{adjustment_1_amount}} | {{adjustment_1_reason}} |

| {{adjustment_2_reference}} | {{adjustment_2_date}} | {{adjustment_2_type}} | {{adjustment_2_amount}} | {{adjustment_2_reason}} |

Total Adjustments: {{total_adjustments}}

5. Discrepancies and Actions Required

The following discrepancies have been identified between the supplier statement and our records:

| Description of Discrepancy | Our Record ({{currency}}) | Supplier Statement ({{currency}}) | Difference ({{currency}}) | Action Required | Responsible Person | Due Date |

|---|---|---|---|---|---|---|

| {{discrepancy_1_description}} | {{discrepancy_1_our_record}} | {{discrepancy_1_supplier_statement}} | {{discrepancy_1_difference}} | {{discrepancy_1_action}} | {{discrepancy_1_responsible}} | {{discrepancy_1_due_date}} |

| {{discrepancy_2_description}} | {{discrepancy_2_our_record}} | {{discrepancy_2_supplier_statement}} | {{discrepancy_2_difference}} | {{discrepancy_2_action}} | {{discrepancy_2_responsible}} | {{discrepancy_2_due_date}} |

Overall Reconciliation Status: {{reconciliation_status}}

6. Closing Balance Reconciliation

Calculated Closing Balance (Our Records):

Opening Balance (Our Records) + Total Invoices Processed - Total Payments Made + Total Adjustments = {{calculated_closing_balance}}

Supplier Statement Closing Balance: {{supplier_statement_closing_balance}}

Final Difference: {{final_difference}}

Notes on Final Variance: {{final_variance_notes}}

Prepared By:

Name: {{preparer_name}}

Title: {{preparer_title}}

Date: {{preparation_date}}

Approved By:

_____________________________

Name: {{approver_name}}

Title: {{approver_title}}

Date: {{approval_date}}