Ubouk
Sign in
← Help Center
Accounting & financial reports~4 min · 3 steps

Read aged receivables

Identify outstanding balances by due date and overdue bucket.

  1. 1

    Choose the balance date

    Open Read aged receivables from Reports. Use an As of preset or enter Custom date, then Apply. This is an organization-wide balance through that date; it does not limit invoices to a start date or batch. Payments settle the oldest due amounts first. Financial reports require owner, administrator or finance manager access.

    Screenshot: Choose the balance date. The blue outlines identify the controls described in this step.

    Select the screenshot to enlarge it. The blue outline marks the control to use.

  2. 2

    Read the overdue buckets

    Read Client, Invoice and Due date, then Not due, 0-30, 31-60, 61-90 and 90+. Each remaining instalment is aged from its own due date, so one invoice can appear on several rows. Balance due is the open amount at the selected cutoff, including invoices issued before that month. Use the oldest overdue rows to prioritize follow-up.

    Screenshot: Read the overdue buckets. The blue outlines identify the controls described in this step.

    Select the screenshot to enlarge it. The blue outline marks the control to use.

  3. 3

    Export the filtered report

    Open Export and choose Excel workbook (.xlsx) or CSV file (.csv). The file uses the active filters and current language. The screen shows at most 500 rows; exports include every matching row. If there are no results, check the date and clear restrictive filters. If a historical journal backfill warning appears, have the missing history completed before treating totals as complete.

    Screenshot: Export the filtered report. The blue outlines identify the controls described in this step.

    Select the screenshot to enlarge it. The blue outline marks the control to use.

Keep going

Accounting & financial reports
Track late and upcoming instalments

See which scheduled amounts remain unpaid and when they are due.

Accounting & financial reports
Read client balance summaries

Compare outstanding debt, available account credit and the net balance for each client.

Accounting & financial reports
Use aged balances for payment reminders

Connect existing unpaid-balance automations to overdue buckets and stop reminders after payment.