KHIZHNYAKOV
What it is for
A reconciliation statement is usually put together by hand: you compare two lists of documents, look for mismatched amounts and recalculate the balance. Here you enter the documents in one table — your amounts on the left, the counterparty's on the right — and the spreadsheet finds the discrepancies, calculates the running balance and builds a statement with the phrase "debt in favour of…" and signature lines.
What is inside
- "Details": your organization, counterparty, contract, period, opening balance for both sides, supplier, comparison tolerance, signatories.
- "Transactions": up to 500 documents, your charge and payment amounts, the counterparty's amounts, differences, the reconciliation result and the running balance.
- "Discrepancies": a list of documents with a difference and a hint on what to check.
- "Statement": an A4 print form with the final balance, the debt wording, signature lines and a register of transactions.
- "Summary": turnover and balances for both sides, number of discrepancies, turnover by month and two charts.
Who it is for
Accountants and sales managers, purchasing staff, small companies and sole traders who need to reconcile accounts with a customer or supplier and prepare a statement without special software.
Compatibility
Excel 2007 and later, LibreOffice. No macros. The statement form is not a strict one; check its layout against your own requirements and those of your counterparty. The file is in English.