Skip to main content

Debtors and Creditors Transactions Report

Purpose​

Analysis of the status of debtors and creditors transactions for the selected period with document-level details: invoices, payments, rectifying invoices, settlements, and offsets.
Control of balances, unapplied advances, and multicurrency amounts (conversion to euros when multicurrency accounting is enabled).

Features​

  • Filters: period, my company, counterparty.
  • Groupings: my company, counterparty, settlements/advance, document.
  • Amounts displayed both in the document currency and in euros.
  • Drill-down to source documents.

Nuances and limitations​

  • Only posted documents are included in the report.
  • Conversion to euros is performed according to the multicurrency accounting settings (the conversion method is determined by the accounting parameters configured in the system).

Step-by-step setup and execution​

  1. Open Sales or Purchases > Debtors and Creditors Transactions in the Reports section.
  2. Select the Debtors and Creditors Transactions by Counterparty option.
  3. Set the period and specify Debtor or Creditor.
  4. Click Generate.

Expected result:
The report displays a table with opening balance, turnovers, and closing balance by counterparties/documents.
Unapplied advances are shown in a separate Advance group.
When multicurrency accounting is enabled, amounts are displayed both in the settlement currency and in the accounting currency — euro, with grouping by settlement currency.

  1. Select the Debtors and Creditors Balances option.
  2. Set the period and specify Debtor or Creditor.
  3. Click Generate.

Expected result:
The report displays only open documents: unpaid or partially paid invoices, as well as unallocated cash receipts and expenses.

Tips​

tip
  • If an advance remains unapplied (the balance of the advance document is greater than zero), check the payment allocation to invoices.
  • To save modified report settings, create your own report variant and reuse it later.