BeeQube Documentation

Appearance

Payables Reports ​

The Payables reports in BeeBooks help you track outstanding bills, supplier balances, credits, and payments—so you can see what you owe, how long it’s been due, and detailed activity.

All payables reports support: Date range selection, Column customization, Sorting (A–Z / Z–A), Export (PDF, XLSX, CSV), and Advanced filters (where available).

1) Supplier Balance Summary ​

Summarizes balances for each supplier.

Columns

  • Supplier
  • Opening Balance (BDT)
  • Transaction Amount (BDT)
  • Paid Amount (BDT)
  • Due Amount (BDT)
  • Closing Balance (BDT)

Options

  • Include/exclude specific Suppliers with filters
  • Customize columns to display only what you need

2) AP Aging Summary ​

Shows outstanding payables categorized by aging periods.

Controls

  • Date — Select the cut-off date for the report
  • Date Type — Choose Due Date or Bill Date
  • Times — Number of intervals to display (e.g., 3×)
  • Gap Days — Length of each interval (e.g., 30 days)
  • Preview — Choose to preview Due Amount, Total Amount, Paid Amount, or Count

Columns (default)

  • Supplier
  • 0–29 Days (BDT)
  • 30–59 Days (BDT)
  • 60–89 Days (BDT)
  • 90+ Days (BDT)
  • Total (BDT)

Options

  • Customize columns
  • Adjust Times and Gap Days (e.g., 7-day, 10-day, or 30-day intervals)

3) AP Aging Details ​

Detailed view of aged bills per supplier.

Controls

  • Date Type — Bill Date or Due Date
  • Times & Gap Days — Define the aging intervals

Columns

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

Advanced Filters

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

4) Bills Details ​

List of all bills recorded.

Columns

  • Bill Number
  • Bill Date
  • Due Date
  • Supplier
  • Amount
  • Paid Amount
  • Status

Options

  • Group by: Bill Date, Due Date, Supplier, Status
  • Advanced filters: Bill Number, Bill Date, Due Date, Reference, Amount, Status

5) Supplier Credits Details ​

Details of credits received from suppliers.

Columns

  • Supplier Credit Number
  • Credit Date
  • Supplier
  • Payment Mode
  • Amount
  • Applied Amount
  • Status

Options

  • Group by: Credit Date, Supplier, Status, Payment Mode
  • Advanced filters: Credit Number, Credit Date, Payment Mode, Amount, Applied Amount, Status
  • Include/exclude columns

6) Payments Made ​

Tracks all payments made to suppliers.

Columns

  • Payment Number
  • Payment Date
  • Payment Mode
  • Supplier
  • Account
  • Amount
  • Amount Used
  • Reference
  • (Other optional columns available)

Options

  • Group by: Payment Date, Supplier, Payment Mode, Account
  • Advanced filters: Payment Number, Payment Date, Payment Mode, Reference, Amount
  • Include/exclude columns

7) Payable Summary ​

Summarized view of all payable transactions.

Columns

  • Date
  • Type (e.g., Bill, Expense, Supplier Credit)
  • Transaction Number
  • Supplier
  • Amount
  • Balance
  • Reference
  • Bill Due Date

Options

  • Group by: Date, Supplier, Status, Resource Type (Bill, Expense, Supplier Credit)
  • Advanced filters: Transaction Number, Resource Type, Supplier, Amount, Balance, Due Date, Bill Status, Supplier Credit Status
  • Include/exclude columns

8) Payable Details ​

Full breakdown of all payable entries.

Columns

  • Date
  • Payable Type (Bill, Expense, Supplier Credit, etc.)
  • Transaction Number
  • Supplier
  • Account Name
  • Item Name
  • Quantity
  • SKU
  • Unit Price
  • Final Amount

Options

  • Group by: Date, Supplier, Status, Resource Type, Account, Item
  • Advanced filters: Transaction Number, Resource Type
  • Include/exclude columns