Skip to main content
Skip table of contents

Direct Bill Aging .ng

Direct Bill Aging

Report Description:  The Direct Bill Aging report provides real-up-to-date details on accounts receivable activity, invoice activity and settlement activity. This report categorizes activity by how long they have been aging in 30-day intervals. 

Date Range: Current day and up to 365 days in the past

Available Report Columns for Following Sections:

Column Name

Column Description

Amount Includes Taxes and Fees

Calculation

Company Name

Local direct bill company name on the reservation.

Not Applicable

Not Applicable 

Company Code

Local direct bill company code (ex - 5010).

Not Applicable

Not Applicable

Current

Current balance aged between 0 and 7 days.

YES

current = (all charges + taxes) - (adjustments)

Over 7

Balance aged between 8 and 14 days.

YES

Over 7 = (all charges + taxes) - (adjustments)

Over 14

Balance aged between 15 and 30 days.

YES

Over 14 = (all charges + taxes) - (adjustments)

Over 30

Balance aged between 31 and 60 days.

YES

Over 30 = (all charges + taxes) - (adjustments)

Over 60

Balance aged between 61 and 90 days.

YES

Over 60 = (all charges + taxes) - (adjustments)

Over 90

Balance aged between 91 and 120 days.

YES

Over 120 = (all charges + taxes) - (adjustments)

Over 120

Balance aged between 121 and 150 days.

YES

Over 120 = (all charges + taxes) - (adjustments)

Over 150

Balance aged 151+ days.

YES

Over 151 = (all charges + taxes) - (adjustments)

Total

Total balance across all aging periods for the company.

YES

Total = (sum of all balances current:over 150)

Accounts Receivable section: Total amount un-invoiced by the company, categorized by aging period.

Invoices section:  Total invoiced amount not yet settled, broken down by aging period for the company.

Settlement section: the total amount settled by aging period for the company.

Totals section:  summary of total amounts for Accounts Receivables, Invoices and Settlements by aging period. 

Misc Report Information:

Available Features:

  • Export:  ability to download and save the file into an alternate format.

  • Filter:  filter a range of data based on criteria defined by the user.

  • Highlight:  also known as conditional formatting is the ability to highlight certain values making them easier to identify.

Available Configuration:

  • User Preferences:  allows the user to customize their report view by repositioning or removing columns.

  • Property Preferences:  allows the property to customize the report view for all users by repositioning or removing columns. 

  Baseline Configuration:

  • Property Preferences Settings:

    • Following columns to be disabled for initial deployment:

      • Not Applicable

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.