Build an EDI reconciliation statement with a counterparty
The counterparty sent their statement and the totals disagree. The agent merges Diadoc documents with 1C postings and shows whose document dropped out.
Medium · 20 min · once a quarter
What you get
Reconciliation with Romashka LLC, Q1 Our balance: 1,240,000 ₽ Their balance: 1,186,000 ₽ Gap of 54,000 ₽ — two rows: UPD no. 314 of 12.02 for 54,000 — absent on their side UPD no. 288 of 05.02 — sent via EDI, never signed Both rows are marked "needs a decision" and left for the accountant: the agent does not fix them silently.
A sample on made-up data — your numbers will be your own.
Who it fits
- A quarterly reconciliation with a regular supplier, dozens of documents, some of them arriving via EDI.
- The counterparty sent their own statement and you need to see whose document fell out of whose books.
When it won't work
Some of the primary documents travel on paper — they aren't in Diadoc, so the statement comes out incomplete.
How the agent does it
Pick the counterparty
Name the period, and the contract if there is more than one with this counterparty. If you use your own statement form, attach it and the agent builds to it.
Merge the documents
The agent reads incoming and outgoing documents in Diadoc and settlements in 1C, merges them line by line and marks each document's EDI status.
Reread the gaps
This statement goes to the counterparty, so an error costs more than usual. Look at rows matched on amount alone, with no matching number or date.
What you set
You'll need Diadoc and 1C. From you: the counterparty, the reconciliation period and your own statement form, if you don't use the standard one.
What you'll need
Starter prompt
Copy the prompt or open it straight in a chat with the agent.
Prepare a reconciliation statement with [counterparty] for [period] using 1C and Diadoc data. Match every UPD and VAT invoice from EDI against a posting in 1C by number, date and amount. Collect the discrepancies: a document exists in Diadoc but isn't posted in 1C, is posted in 1C but never arrived via EDI, amounts or the VAT rate differ, the document was cancelled or replaced by a corrected one. Don't stop at a matching number: different contracts can share the same numbers — also check the contract and the amount, otherwise move the row into "needs a decision". Output the statement in the standard form broken down by dates and documents, a separate discrepancies sheet and the opening and closing balances — per our data and per the EDI documents.
Open in chatReview the reconciliation statement. List: — documents matched only by amount, without a matching number or date; — corrected and adjustment UPDs: was the original document counted twice; — documents sent via EDI but not signed by the counterparty; — rows where VAT was calculated at a rate different from the one stated in the document; — the balance discrepancy and exactly which rows it is made of. Don't fix anything silently: leave debatable rows in "needs a decision" — the accountant closes those.
A second prompt — the agent uses it to review its own work and show what's left for you.