Reconciliation statement in 1C: how to create one and handle discrepancies

Learn where to find and create a reconciliation statement in 1C 8.3, and how to analyze discrepancies with a counterparty.

  • Where to find a reconciliation statement in 1C 8.3
  • How to create a reconciliation statement
  • Why the data differs
  • Five reasons behind most discrepancies

A reconciliation statement in 1C is created as a single document, but its real value lies not in the “Fill” button, but in analyzing discrepancies. Below, learn where to find the document in 1C:Accounting 8.3, how to fill it in by contract and period, why the figures differ from the counterparty’s records, and how to analyze discrepancies line by line rather than by the closing balance.

Where to find a reconciliation statement in 1C 8.3

In 1C:Accounting 8.3, the document is available in two sections, but it is the same object: - “Sales” → “Reconciliation Statements” - for customers; - “Purchases” → “Reconciliation Statements” - for suppliers. The document contains tabs for our organization’s data and the counterparty’s data, a tab with additional accounts, and period settings. The approval flag locks the document after both parties agree, preventing silent edits to an already approved reconciliation.

How to create a reconciliation statement

  1. 01

    Select the counterparty and contract

    The contract must be specified explicitly. Without it, the statement will include all settlements with the counterparty, causing different contracts to offset each other.

  2. 02

    Set the period

    The period must match the one requested by the counterparty. A one-day difference produces different balances and an unnecessary dispute.

  3. 03

    Check accounting accounts

    A separate tab specifies which accounts are included in the reconciliation: settlements with customers, suppliers, and advance payments. Omitting the advance account is a typical reason for a “shortfall” in the statement.

  4. 04

    Fill in using the organization’s data

    The fill button imports our documents for the period. This is not yet a reconciliation—it is only our side.

  5. 05

    Enter the counterparty’s data

    The second tab is filled in using the statement received from the counterparty. You can copy our side into it and then edit it against the counterparty’s document.

  6. 06

    Compare and approve

    Discrepancies are reviewed line by line. Once agreed, the statement is marked as approved, printed, or sent via EDI.

Why the data differs

A discrepancy is almost never arithmetic. It means that two systems recorded the same event differently, or one of them did not record it at all.

Map out your integration landscape

Five reasons behind most discrepancies

The document has not been posted

A sales or receipt document is unposted in the database or was never created: the statement arrived by email but was not recorded in accounting. The counterparty has already included it in their reconciliation.

Payment under another contract

The payment arrived without a clear purpose and was allocated to another contract with the same counterparty. The counterparty total matches, but the contract balance does not.

Different recognition periods

The document is dated at the end of the month but received and posted in the following month. Both parties are correct, but their balances as of the reporting date differ.

Advance payment and offsetting

The advance payment is recorded in an advance account, but that account is not included in the reconciliation. Alternatively, the advance was offset by one party but not by the other.

VAT and rounding

A kopeck-level discrepancy is almost always caused by different rounding bases by line or a different rate in one party's document.

A separate case is matching totals with different underlying documents.

The balance matches, but we have posted a document missing from the counterparty's records, and vice versa—for the same amount.

This statement looks perfect but hides two errors at once.

Therefore, reconcile the list of documents, not the final line.

What to do about a discrepancy

  1. 01

    Find a line

    Compare document lists, not the total. Find differences by number, date, and amount—not by balance.

  2. 02

    Identify the party

    Determine which party is missing the document: it is unposted in our system, or the counterparty has not recorded it.

  3. 03

    Request the document

    The missing closing document is requested from the counterparty and posted in the accounts once received.

  4. 04

    Check payment allocation

    If both parties show the amount but under different contracts, reallocate the payment according to its purpose and the confirming letter.

  5. 05

    Record the disputed item

    Anything not resolved by the documents is handled separately: a dispute over contract terms, a write-off decision, or recognition of uncollectible debt.

  6. 06

    Approve the statement

    Once agreed, the statement is marked as approved and signed. The signature records the status of the settlements as of that date.

Why reconcile regularly instead of once a year

  1. A reconciliation statement is not an accounting formality.

  2. Once signed by both parties, it acknowledges the debt and interrupts the limitation period; in court, it serves as evidence of the status of the settlements.

  3. Without it, debt recovery relies solely on primary documents, which may not be sufficient.

  4. The practical reason is even simpler: the later a discrepancy is found, the more it costs to resolve.

  5. An unposted document found in the same month is a single accounting entry.

  6. The same document found a quarter later—a correction in a closed period, an amended return for

  7. VAT and a conversation with a counterparty whose responsible person has changed. This is where the gap arises between the view that everyone must reconcile monthly

  8. and how it works in practice: the process is manual and only covers about a dozen major counterparties.

  9. Once the portfolio exceeds fifty counterparties, selecting a sample is no longer a choice—it becomes a way to avoid doing the work.

  10. This is the point where reconciliation hand over to the agent: preparation, sending, correspondence, and line-by-line matching, leaving disputed items for a person. ### What this costs the company

  11. A section for the manager to whom the accountant is showing this material.

  12. Reconciliation is inherently manual: create the statement, send it, send reminders, wait, make the received version comparable, match the records, explain differences, and follow up until the documents are obtained.

  13. That is why most companies perform it selectively—for major counterparties and closer to reporting deadlines.

  14. The rest of the portfolio is not reconciled at all. What should you ask the team: -

  15. What share of counterparties have a signed reconciliation statement for the last quarter? -

  16. How many discrepancies were found at month-end—and how many could have been caught during reconciliation? -

  17. How much time per month is spent corresponding with counterparties about missing closing documents?

  18. If the answer to the first question is “only major counterparties,” receivables from the rest rely on primary documents without acknowledgment of the debt.

  19. This is not a matter of accountant discipline: selective reconciliation is driven by the workload involved, not willingness.

  20. This is where automation comes in: the agent handles the entire cycle—creates the statement, sends it via EDI, manages correspondence, recognizes the response in any format, matches it line by line, explains discrepancies, and passes only disputed items to a person.

  21. How it works and how much it costs—on the page reconciliation statement automation.

FAQ

Frequently asked questions about reconciliation statements in 1C

Where is the reconciliation statement in 1C 8.3?

In the “Sales” and “Purchases” sections, select “Reconciliation Statements.” It is the same document, opened from the customer’s or supplier’s side.

Is it mandatory to specify the contract?

In practice, almost always. Without a contract, the statement will include all settlements with the counterparty, and a debt under one contract will be offset by an advance under another—the total may be correct but the result will be meaningless.

Why does the balance match when the documents differ?

Because each party has a document missing from the other party's records for the same amount. The total matches, but two errors remain. Reconcile the list of documents, not the final line.

What should you do if the counterparty does not respond?

Record the fact of sending and reminders. The statement’s sending date matters for accounting, while debt recovery requires proof that the document was sent. Silence does not confirm the debt, but it does not invalidate the primary documents either.

Does a reconciliation statement interrupt the limitation period?

A statement signed by an authorised person acknowledges the debt, and the limitation period starts again. That is why the signatory's signature and authority matter more than the neatness of the document.

Can reconciliation be done via EDI?

Yes, electronic reconciliation statements are common practice and save most of the process: sending, obtaining signatures, and storage. Counterparties using different operators still occur, so some responses arrive by email and as scans.

How often should you reconcile?

Monthly reconciliation with all counterparties is the ideal, but rarely achievable manually. At a minimum, reconcile before year-end closing and with all counterparties carrying significant debt.

Discuss the article: Reconciliation statement in 1C: how to create one and what…

Enter your email or phone number so we can get back to you.

Send via: