BeeQube Documentation

Appearance

Receivables Reports ​

The Receivables reports in BeeBooks help you track outstanding invoices, customer balances, quotations, and payments received—providing both summarized and detailed views to manage collections and analyze customer credit activity.

All receivables reports support: Date range selection (Invoice Date, Due Date, Quotation Date, etc.), Column customization, Sorting (A–Z / Z–A), and Export (PDF, XLSX, CSV).

1) AR Aging Summary ​

Summarizes outstanding receivables grouped by aging periods.

Controls

  • Date — Select cut-off date
  • Date Type — Due Date or Invoice Date
  • Times — Number of intervals (e.g., 3×)
  • Gap Days — Interval length (e.g., 7, 10, 15, 30 days)
  • Preview — Show Due Amount, Total Amount, Paid Amount, or Count

Columns

  • Customer
  • 0–29 Days
  • 30–59 Days
  • 60–89 Days
  • 90+ Days
  • Total

Options

  • Include/exclude columns
  • (No advanced filters available)

2) AR Aging Details ​

Provides invoice-level details of aged receivables.

Controls

  • Date Type — Invoice Date or Due Date
  • Times & Gap Days — Define intervals (e.g., 15 days, 45 days, 60 days, 90 days)

Columns

  • Aging Group (e.g., 0–29 days)
  • Invoice Number
  • Invoice Date
  • Due Date
  • Customer
  • Amount
  • Paid Amount
  • Status

Advanced Filters

  • Invoice Number, Invoice Date, Due Date, Reference, Total Amount, Status

3) Invoice Details ​

Shows a complete list of invoices with status and payment tracking.

Controls

  • Date Type — Invoice Date or Due Date

Columns

  • Invoice Number
  • Invoice Date
  • Due Date
  • Customer
  • Salesperson
  • Amount
  • Paid Amount
  • Status

Options

  • Group by: Invoice Date, Due Date, Customer, Salesperson, Status
  • Advanced filters: Invoice Number, Invoice Date, Due Date, Reference, Total Amount, Status

4) Quotation Details ​

Tracks all customer quotations and their expiry status.

Controls

  • Date Type — Quotation Date or Expiry Date

Columns

  • Quotation Number
  • Quotation Date
  • Expiry Date
  • Customer
  • Salesperson
  • Total Amount
  • Status

Options

  • Group by: Quotation Date, Expiry Date, Customer, Salesperson, Status
  • Advanced filters: Quotation Number, Quotation Date, Expiry Date, Reference, Total Amount, Status

5) Customer Balance Summary ​

Summarizes each customer’s outstanding balances.

Columns

  • Customer
  • Opening Balance
  • Transaction Amount
  • Paid Amount
  • Due Amount
  • Closing Balance

Options

  • Include/exclude columns
  • Advanced filters: filter by specific Customers

6) Receivable Summary ​

Gives a transaction-level overview of receivables activity.

Columns

  • Date
  • Type — Invoice, Sales Receipt, Credit Note
  • Transaction Number
  • Customer
  • Salesperson
  • Amount
  • Balance
  • Reference
  • Invoice Due Date

Options

  • Group by: Date, Customer, Status, Resource Type (Invoice, Sales Receipt, Credit Note), Salesperson
  • Advanced filters: Transaction Number, Resource Type, Customer, Salesperson, Amount, Balance, Due Date, Invoice Status, Credit Note Status

7) Receivable Details ​

Full breakdown of all receivable entries.

Columns

  • Date
  • Type — Invoice, Sales Receipt, Credit Note
  • Transaction Number
  • Customer
  • Account Name
  • Item Name
  • Quantity
  • SKU
  • Unit Price
  • Final Amount

Options

  • Group by: Date, Customer, Status, Resource Type, Account, Item
  • Advanced filters: Transaction Number, Resource Type