Britixo CRMBritixo CRMEnterprise Help Centre
Ctrl K
Accounting & Bookkeeping · How-to guide

Use Accounts Receivable ageing reports

Follow this guide to review unpaid customer balances by age in summary and detailed invoice views. The guide then takes you through the correct route, the checks to complete before making changes, the workflow in order, and the evidence to review afterwards.

Audience: Credit control and finance staffFeature: Accounts Receivable ageingModule v1.4.5
Jump to steps
Where to goAccounting → Reports → Accounts Receivable Ageing Summary / Detail
Before you startThis guide follows Accounting and Bookkeeping module version 1.4.5. The required access is Accounting Reports: View. A related screen can remain hidden when an optional module is inactive, a source record is in an ineligible status, the selected account is inactive or the user is not an assigned approver.

What you’ll accomplish

Review unpaid customer balances by age in summary and detailed invoice views. It forms part of Britixo Enterprise CRM's Accounting & Bookkeeping module and uses the module's permission-aware controller, status and mapping flow rather than a generic spreadsheet process.

How the module flow works

The module provides separate Accounts Receivable Ageing Summary and Detail endpoints. Ageing is driven by invoice and due dates and adjusted by payments and credits represented in Accounting.

The total should be reconciled with the accounts-receivable control account in General Ledger. Differences can indicate conversion, mapping or timing issues.

Operational invoice status and accounting conversion must both be reviewed.

Follow these steps

  1. Run the Summary as of the review date.
  2. Identify overdue customers and unusual credit balances.
  3. Go to Detail for each material balance.
  4. Compare invoice, payment and credit-note sources.
  5. Investigate unapplied credit or missing payment conversion.
  6. Follow credit-control procedure.
  7. Reconcile the total to the receivable control account.

Fields and decisions to review

Current and ageing bucketsCommonly current, 1–30, 31–60, 61–90 and 91+ days.
Customer summaryShows total outstanding by customer.
DetailLists invoices, dates, due dates, credits and balances.
As-of dateControls ageing calculation.
Payments and applied creditsReduce outstanding balances when correctly converted.

How to confirm it worked

After the action is saved, Britixo keeps the Accounting record connected to its source and updates the visible status or ledger data supported by this workflow. Review the saved result rather than relying only on a success message. Where the action posts accounting data, total debits and credits must balance and the accounts must match the approved mapping or manual selection.

  • Open the saved record and confirm its final status.
  • Review the source reference and every debit and credit line where ledger data was created.
  • Use the relevant register, ageing, reconciliation or report to verify the wider effect.

Controls, checks and common mistakes

  • Use the same as-of date for ledger reconciliation.
  • Do not chase a customer for a payment already received but unconverted.
  • Check disputed and credit balances.
  • Protect customer financial data.
  • Use the least destructive correction available and record the reason for material changes.
  • Do not bypass a permission, approval or closed-period control by changing unrelated data.
Accounting and data safetyDeletion, reset, void, refund, mapping, journal and reconciliation actions can change financial history. Use approved access, retain supporting evidence and validate the result in the General Ledger or relevant control report.
Browse connected topics:invoicepaymentcredit notereconciliationcheckreportapprovalmappingdouble-entrysales accountingexpensetaxcustomers
Convert sales invoices to AccountingConvert invoice payments to AccountingConvert credit notes, applications and refundsUse General Ledger, Journal and Trial Balance reportsAccounting report centre overviewUse Balance Sheet reports