ValteraTools CFO services
  1. Valtera
  2. Tools
  3. Excel templates
  4. Reconciliation statement (Excel)
Excel template · Settlements

Reconciliation statement: Excel template

You fill in the left side, the counterparty fills in the right: the template calculates turnover, the closing balance and who owes whom, and shows at once if the two parties' data differ.

Updated:
Valtera_Reconciliation_statement_EN.xlsx · 9 KB · Sheets: Guide, Reconciliation
Format: .xlsx · Excel, Google Sheets, LibreOffice · No sign-up required
Other languages: Azerbaijani · Russian
Valtera_Reconciliation_statement_EN.xlsx — Reconciliation · Preview with sample data
Period01.07.2026–30.09.2026
Our companyExample LLCTIN (VÖEN)1234567891
CounterpartyPartner LLCTIN (VÖEN)9876543211
Basis (contract)Sales contract No. 15 dated 12.01.2026
Opening balance1,500+ the counterparty owes us, − we owe the counterparty
Per our recordsPer counterparty records
DateDocumentDebitCreditDateDocumentDebit
Opening balanceOpening balance
05.07.2026Delivery note No. 1014,72005.07.2026Delivery note No. 101
18.07.2026Payment order No. 583,00018.07.2026Payment order No. 583,000
03.08.2026Delivery note No. 1172,36003.08.2026Delivery note No. 117
21.08.2026Payment order No. 644,72021.08.2026Payment order No. 644,720
08.09.2026Delivery note No. 1281,18008.09.2026Delivery note No. 128
25.09.2026Return note No. 323625.09.2026Return note No. 3236

What the template includes

  • Period, parties, TIN (VÖEN) and contract.
  • Opening balance: a positive figure is the counterparty's debt, a negative figure is your debt.
  • Two tables side by side: "According to our data" and "According to the counterparty's data" (date, document, debit, credit), 30 rows.
  • Turnover and closing balance for each party separately.
  • Conclusion sentence: "As of 30 September 2026, … owes: … manat". The difference check is shown in green or red.
  • Signature lines: the director and chief accountant of both parties.

How to use it

Fill in the file and send it to the counterparty: they fill in the right table from their own records and send it back. If the difference is zero, print and sign the statement. For a one-off statement, the online version is faster: the Word file is ready at once.

Frequently asked questions

What goes in the debit and credit columns?

In your records, debit: goods, work and services you delivered to the counterparty. Credit: payments and returns you received from them. In the counterparty's table they are on the opposite side: your debit is their credit.

Let us run the numbers

Valtera keeps the books and tax records of small and mid-sized companies and, as an outsourced CFO, takes responsibility for revenue growth and cash flow.