Prepare a reconciliation act in SBIS against 1C
The agent assembles the reconciliation act in SBIS for a counterparty, matches it against settlements in 1C and shows the lines where the two sides disagree.
Medium · 25 min · once a quarter
Who it fits
- The counterparty works through SBIS and sends their own statement — it needs to be checked line by line, not by the closing balance.
- The statement is agreed over several rounds and you need to know what changed between versions of the document.
- Not a fit if settlements run in several currencies or through agency arrangements: line-by-line matching will produce false discrepancies there.
Generate a reconciliation statement with [counterparty] for [period] in SBIS and check it against the settlements in 1C. Match line by line: date, document, debit, credit. Collect separately the lines that we have and the counterparty doesn't, that the counterparty has and we don't, and those that match on the document but differ on the amount. Don't level out differing balances by fudging: the discrepancy must break down into specific lines, and if it doesn't, say so. Take the document's SBIS status into account: sent, signed, rejected, cancelled — an unsigned document cannot be treated as agreed. Output the statement in the standard form, a line-by-line discrepancy sheet indicating the side and the status, and the closing balance from both sides.
Copy the prompt or open it straight in a chat with the agent.
Try for freeHow the agent does it
Pick the counterparty and the period
If the counterparty has already sent their statement, attach it: the agent will reconcile both sides line by line rather than only our data against SBIS.
Collect and match
The agent generates the statement in SBIS, reads the document statuses and merges the lines with the 1C postings, marking whose line is missing and what status the document is in.
Check the result
A signature on the statement closes the period — a discrepancy not broken down into lines becomes your loss once it's signed
Review the reconciliation statement. List: — lines matched by amount without a matching document number or date; — documents in "sent" or "rejected" status that you counted as agreed; — the part of the balance discrepancy that didn't break down into specific lines; — offsets, prepayments and refunds recorded by the two sides in different periods; — lines that got into the statement from another contract with the same counterparty. Say what can be fixed on our side before signing and what will have to be agreed with the counterparty.
A second prompt — the agent uses it to review its own work and show what's left for you.
What you set
SBIS, 1C. From you: the counterparty, the period and the counterparty's statement, if they sent one.
What you'll need
СБИС