Browse the guide›

VedronERP · Financial Statements

Receivables Register & AR Aging

The AR Aging tab has two views. The Receivables register lists everything customers and payment platforms still owe at a date and is reconciled to your balance sheet. Invoice ageing groups open invoices by how long they have been outstanding.

Receivables register

A receivable exists from the moment you sell until the money reaches your bank. The register shows every open item with its expected amount, receipts applied, open balance, age and a coloured status. It is rebuilt from dated events, so you can view any past date or month-end and nothing is overwritten.

Using the register

  1. Go to Financial Statements → M6 Reports → AR Aging and stay on Receivables register.
  2. Select the company — the register is reconciled to that company's balance sheet.
  3. Choose an As of date, or a Period (month) to see the month-end position and only that month's items.
  4. Filter by account (type a number or part of a name), status (Open items, Settled items, All) or search by reference or counterparty. Use the page controls for long lists.

Reconciling to the balance sheet

Every account your balance sheet reports under Trade & Other Receivables appears as a card with the register total and the ledger balance. Any difference is named (for example a platform fee not yet booked, or sales missing from an import); whatever is not explained is shown as an unexplained difference and must be resolved. At a month-end the Balance sheet check confirms that the ledger total equals the balance sheet figure; where the balance sheet presents a credit balance as a liability, the check lists those accounts. On a cash basis (revenue is booked when the money arrives), open invoices are listed in the register but are not in the ledger yet; that difference is shown as a named item, not as an error.

Statuses

  • Received in bank — the money has arrived.
  • In transit to bank — the platform has paid out, the bank has not received it yet.
  • Awaiting payout — included in a payout that has not been paid out yet.
  • Not batched yet — sold but not yet in any payout (shown net of an estimated fee).
  • Open — an invoice or ledger item that is not settled yet.
  • Part received — partly paid.

Month-end lock

After you have checked a finished month, press Lock for that period. The reconciled figure is stored with who locked it and when, and cannot be edited; if the underlying data changes later, the page shows a warning. A month cannot be locked while it is still open or while an account has an unexplained difference. The "What to do next" banner reminds you when the last completed month is not locked. Each company is locked separately: lock one company and month at a time after reviewing that company's register; the banner button opens the register on the right company and month.

Exporting

Press Export to download the register for chosen accounts of the selected company over a range of months (up to 36). Choose the datasets — summary and reconciliation, roll-forward, open items at each month-end, settled items, ageing — and a format: Excel, CSV, TSV, XML or JSON. Excel gives one sheet per dataset plus a Notes sheet; the other formats give one flat table. Locked months use their stored figures. A file only ever contains your own company's data.

Invoice ageing

The Invoice ageing view shows all open invoices grouped by how long they have been outstanding, to identify overdue receivables and prioritise collection. Enable "Exclude pre-paid / platform-collected" to remove advance-payment and platform-collected invoices, which are often paid before invoicing.

  • 0–30 days — current, within normal payment terms.
  • 31–60 days — slightly overdue, monitor.
  • 61–90 days — overdue, consider a payment reminder.
  • 90+ days — significantly overdue, escalate.

Tip: Review the register and lock the month before closing the period. Chasing overdue invoices is easier with a current list sorted by age.