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.
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 or from currency revaluation 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.

Important — a single net balance, not two columns

Receivables (221.x) and payables (521.x) merge into a single chronological register, with a signed balance. Positive means the partner owes you, negative that you owe them. Each document appears on a single row, with its debit and credit summed.

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:

  • the sale (debit on 221) and the payment to the supplier (debit on 521) raise the balance;
  • the collection from the customer (credit on 221) and the supplier's invoice (credit on 521) lower the balance.

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 exchange-rate differences. On foreign-currency documents, different rates give small discrepancies.

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 does not cover the whole settlement position. It reads only 221.x and 521.x. Advances given (224.x) and advances received (523.x) stay outside it. At the annual stocktake you check them separately, from the account ledger, otherwise your position against the partner stays incomplete.

Example. The partner has a receivable of 12.000 lei on 221.1 and an advance received of 5.000 lei on 523.1. The act shows 12.000 lei. The real settlement position is 7.000 lei in your favour.

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 never touched 221 or 521Check the document's entry with the J button on its form.
A difference of a few baniRounding on the exchange rateRecord the exchange-rate difference.
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?​

Trade receivables (221 with all its analytics) and trade payables (521 with all its analytics). Advances given (224.x) and advances received (523.x) do not enter this report. You check them separately, from the account ledger.

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 movement on 221 and 521. For a single account you use the account ledger.

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 balances on 221.x and 521.x and serves as a supporting document. It is frequently asked for at tax audits. It does not confirm advances — those you document separately.

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.