Skip to main content

Reconciling receivables and payables

Reconciliation shows you, for one partner and one period, every movement of receivables and payables, with the balance to date. You use it to compare your records against the partner's and to print the reconciliation act.

Where to find it: Sidebar → Sales → the Reconciliation tab

The reconciliation screen

1 the partner you are reconciling with · 2 generates the statement for the chosen period

When you need it​

  • Before a debt adjustment — you check the exact balance.
  • At the annual stocktake of receivables and payables.
  • When the partner sends you their act and you have to confirm it or contest it.
  • Before writing off a time-barred receivable.
  • At a tax audit, when reconciliation acts are asked of you.

What you do here​

  1. Open Sales → the Reconciliation tab.
  2. Pick the Partner.
  3. Pick the Period. The default is the current year.
  4. Press Generate.
  5. Compare against the partner's act.
  6. Press Print Act for bilateral signing. The button stays greyed out until you generate the report — there is nothing to print from an empty screen.

Faster, from any list. Right-click a row that has a partner — an invoice, a sales document, a bank operation, a statement row — and pick Reconciliation act — the partner name. The Reconciliation tab opens with that partner and the act already generated for the current year.

Note — reconciliation is a report, not a document

It creates nothing and changes nothing. It reads the journal entries already recorded. If you find differences, you correct them through separate documents and regenerate the report.

What the report contains​

The reconciliation generated for a partner

Until you press Generate, there is nothing under the filters — the report does not load itself when you pick the partner. After generating, two things appear: the green band with the four figures and, under it, the list of the documents that make them up, row by row, from the opening balance to the closing one. Under the closing balance it says in favour of whom it is — the sentence you read first when you call the partner. The document number in the list is usually a link: it takes you straight into the document that produced the row. Rows coming from manual entries stay plain text — they have no document of their own behind them.

The Print Act button at the top right opens the act in a new window, ready to print. If you need a file instead of paper, choose "Save as PDF" in the print dialog — the act comes out identical.

The panel at the top gives you four figures for the chosen period:

IndicatorWhat it means
Opening BalanceThe net balance at the start of the period
DebitTotal debit turnover in the period
CreditTotal credit turnover in the period
Closing BalanceThe net balance at the end of the period, with a note saying in whose favour it is

Under it, the chronological table has the Date, Document, Account, Debit, Credit and Balance columns. The document's name is a direct link to the source document. Account shows which accounts the document's amount went to — for example 221, 523 for a receipt that settled an invoice while the rest stayed an advance.

Important — a single net balance, not two columns

All settlements with the partner merge into one chronological ledger with a signed balance: receivables, payables, advances, loans — any account where the partner is the analytic. Positive means the partner owes you, negative means you owe the partner. Each document appears on one row, its debit and credit summed over every account it touched. So a 200 lei receipt that settled 120 lei of invoices and left 80 as an advance shows as 200 — exactly as the partner sees it.

A worked example​

SRL „Vinăria Codru" reconciles with SRL „Ambalaj Plus" for January 2025. The partner is both its supplier and its customer.

DateDocumentAccountDebitCreditBalance
Opening balance 01.01−2.500
05.01Supplier invoice 000000001252122.000−24.500
10.01Sales invoice 000000002322112.000−12.500
18.01Payment order 000000004452125.00012.500
22.01Bank operation 00000000512218.0004.500
Closing balance 31.014.500

Result: the closing balance is 4.500 lei in favour of SRL „Vinăria Codru". The partner owes them that amount.

How to read the balance​

Every row moves the balance by the difference between debit and credit:

  • a sale (debit on 221) and a payment to a supplier (debit on 521 or, as an advance, on 224) raise the balance;
  • a customer receipt (credit on 221 or, as an advance, on 523) and a supplier invoice (credit on 521) lower the balance.

When a journal line carries the partner on both sides — an advance settled against an invoice (523 → 221, 224 → 521) or a mutual offset (221 ↔ 521) —, it only moves money between the same partner's accounts. That line is not shown in the act, because it does not change the balance: the partner paid once, and the act shows the payment once, on its own date, and the invoice on its own.

A positive balance means the partner owes you. A negative balance means you owe them.

What to do when the amounts don't match​

  1. Compare document by document. Every row carries the document number and a link to it.
  2. Look for the missing documents. Invoices the partner has and you haven't recorded, or the other way round.
  3. Check the dates. An invoice dated 31.01 on your side and 01.02 on theirs falls in different months.
  4. Check the drafts. Unposted documents don't appear in the report.
  5. Check the currency. A euro document sits in the euro act, not the lei act — compare in the same currency as the partner.

Once you have identified the cause, you create the corrective documents, post them and press Generate again.

The reconciliation act​

Print Act opens the act in a separate window, ready to print or to save as PDF.

The act contains both parties' details, the period, the opening and closing balances, the list of documents and spaces for signatures. You print two copies: one for you, one for the partner.

The act includes advances. The partner has a 12.000 lei receivable on 221.1 and a 5.000 lei advance received on 523.1: the act shows 7.000 lei in your favour — the real settlement position.

Troubleshooting​

ProblemCauseFix
The Generate button does nothingYou haven't picked the partner or the periodFill both fields in.
The report is empty although the partner has documentsThe documents are draftsPost them. The report reads only journal entries that exist.
A document is missing from the reportIt doesn't carry the partner as the analytic on a balance-sheet account, or it carries the partner on both sides of the lineCheck the document's entry with the J button on its form.
A settlement made with Settle from advance is missingIt only moves the advance onto the invoice; the balance does not changeThat's normal. The advance receipt and the invoice each appear on their own row.
A foreign-currency document is missingIt sits in its currency's act, not in the lei actPick the currency from the buttons above the table.
The opening balance doesn't match the previous month's closing balanceDocuments were added or unposted in the previous periodRegenerate the report for the previous period and compare.
A partner has a balance but no rows in the periodThe balance comes from earlier periodsThat's normal. You see it in the Opening Balance.

Frequently asked questions​

Does reconciliation change the balances?​

No. It is a read-only report. You make corrections through separate documents.

Can I reconcile several partners at once?​

No. You pick one partner at a time and generate the report.

Which accounts enter the report?​

Every balance-sheet account in your chart that has the partner as its analytic:

  • trade receivables and payables (221, 521);
  • advances (224, 523, and long-term 163, 423);
  • related parties (223, 522);
  • loans, leasing, other receivables and payables (234, 544 …).

Any balance-sheet account where your chart of accounts puts the partner as the analytic enters — allowances or settlements with the budget too, if you put them on the partner. Your chart decides, not a list in the program. If you see an account you didn't expect, open the document: this is how entries booked on another partner come to light.

Does reconciliation include draft documents?​

No. Only posted ones, because only they have a journal entry.

Can I filter on a particular account?​

No. The report brings together every settlement account with the partner. For a single account you use the account ledger.

The partner has settlements in a foreign currency. What does the act show?​

Each currency gets its own act. If the partner has settlements in a single currency, the act opens straight in it; if there are several, buttons for them (MDL, EUR …) appear above the table and you pick the one to reconcile. The chosen currency shows on the green band and on the printed act, and Generate starts again from the suggested currency.

The currency act shows amounts in the settlement currency. Exchange-rate differences enter no act: they are yours, the partner doesn't have them. The lei act covers only the settlements without a currency.

Why is there a single balance and not two columns?​

Because the partner can be your supplier and your customer at the same time. The net balance tells you directly who owes whom, which is exactly the figure you negotiate.

How often should I reconcile?​

Monthly with big partners, quarterly with the rest, and always at the year-end close. And any time before an offset or at the partner's request.

Signed by both parties, it confirms the settlement balance with the partner — receivables, payables and advances — and serves as a supporting document. It is frequently asked for at tax audits.

How do I reconcile if the partner doesn't use POSfix?​

Each of you generates the act from your own system. You compare them and resolve the differences.