Unbilled Revenue Report
Reports Menu -> Revenue -> Unbilled Revenue Report
Reports Menu -> Automatic Reporting -> Function RSXD16 -> runs Unbilled Revenue Report
This report can be used to identify and estimate any potential revenue earned on Contracts that has not yet been billed and on Invoices that are currently "On Hold".
An optional accrual journal entry can be generated for posting to the G/L.
The estimate of unbilled earned rental revenue if all open contracts were to be billed up to a cut-off point (usually month end), can be based on a choice of two formulas:
•Earned billings using the complete rate structure defined for each rental on each contract
•More conservatively, estimate billings at the monthly rate when available, using the formula (Monthly Rate / 28 Days * bill days)
For example, if a contract had been previously billed to May 15th and the cut-off date was May 31st, the revenue from May 15th to May 31st would be calculated.
The report is an estimate only. It does NOT affect the contracts for future billing.
When the report is run for a date in advance, and using the P.O./Contract Accrual Report, it can be useful in giving a projection of month end performance at any point during the month.
The Unbilled Revenue Report can be setup to be run automatically with the results emailed to staff, by setting up RSXD16 with the relevant filters and email addresses in the Automatic Reporting.
Accrual Transaction feature:
Some firms accrue the unbilled revenue from their open contracts each month or at year end, in order to more accurately reflect the company's revenue position.
This report provides the option to automatically populate an Accrual Journal entry with the reported totals for rentals, sales, services, and damage waiver, that can then be posted using Post Standard Journals.
This processing is activated when an 'Accrual' type journal entry has been setup in Standard Journals and the journal number has been assigned for Unbilled Revenue Report Accrual Journal Entry Number in the Company Posting Parameters.
The 'Accrued Journal Entry' can be empty as the Unbilled Revenue Report will populate the transactions, replacing any transactions that may be previously have been entered.
Note: Currency exchange, and inventory exchanges, are not considered in the Accrued Journal.
If the journal is not generated automatically from the report output, the revenue amounts can still be manually recorded as an accrued journal entry and posted to the General Ledger.
Exclusions:
Certain Sales parts such as Fuel, and specific Rental products that are flagged in the Re-Order Information window in Sales Inventory, or in the Rental Information window in Rental Inventory never to cycle bill, are omitted from this revenue report, as they cannot be invoiced until the Contract is returned.
Rental revenue from Cylinder contracts created from Cylinder Entry is not considered in this report.
Any Power Kit components accompanying a Primary Non-Bulk Rental product on a Contract, are ignored in the revenue reporting as only the Primary products are ever invoiced.
For information on the Power Kit feature refer to Power Kits.
The report can be printed in summary or detail, includes or excludes revenue for sales products, and can be printed by division.
Selection filters for customer, site, contract, class and group are provided.
The summary breaks down the revenue totals by rentals, sales, damage waiver, services and taxes, and provides a grand total.
The detailed report provides an option to sort and print by "Bill To" or "Ship To" address and lists any Purchase Order# specified on the contract.
The rental amounts reflect any Rental Cap assigned to the product detail on the contract.
PREPARATION:
To accurately reflect the unbilled revenue for the month, confirm the following before printing the report:
•all new Contracts for this month are setup
•all Cycle Billing for the month is completed and no Cycle Billing for the next month has been done
•all Rental Returns for the month are completed and no Rental Returns for the next month have been done
The prompts to generate the report are:
BILLING DATE
Accept today's date or enter a preferred bill to date for the report.
This is the date for which the potential bill amount will be calculated for all open contracts.
Note: If rate changes have been made to products on a contract using the Update Contract Rental Pricing utility, and the report is being generated for a Billing Date prior to the effective date of the rate change, those products will be omitted from the report as related billing adjustments could not be made as of the old rate structure.
CUSTOMER, "ALL" OR "SEL"
Select one of the following options:
•Type ALL to include all customers in the report.
•To generate the report for a single customer enter the customer number or select one from the Accounting Customer Search window.
•Type SEL to select a several specific customers for the report, as outlined in the Selected Customers window.
SITE #, "ALL" OR "SEL"
Select one of the following options:
•Type ALL to include all Sites for the customers.
•To generate the report for a specific Site, enter the Site number.
oIf the report is being generated for ALL Customers then only Global Sites can be selected in the window.
oIf the report is being generated for a single specific Customer the Site number for that customer can be selected from the Site Search window.
•Type SEL to select specific Sites, as outlined in the Selected Sites window.
FROM CONTRACT #
Leave this field blank to include all Contracts, or type in the desired beginning Contract number, or select one from the Contract Search window.
TO CONTRACT #
Leave this field blank to include all Contracts, or type in the desired ending Contract number, or select one from the window.
Note: The Contract selection filter does not apply to the "On Hold" Invoices.
FROM PRODUCT CLASS
Leave this field blank for all Products Classes, or type in the desired beginning Product Class number, or select one from the Product Class Search window.
TO PRODUCT CLASS
Leave this field blank for all Products Classes, or type in the desired ending Product Class number, or select one from the window.
Note: In the Accrual Journal postings, the Class G/L Revenue accounts will respect any divisions setup to use "Revenue Posting by Tax Code".
FROM GROUP
Leave this field blank for all Products Groups, or type in the desired beginning group, or select one from the Group Search window.
TO GROUP
Leave this field blank for all Products Groups, or type in the desired ending group, or select one from the window.
DIVISION, "ALL" OR "SEL"
•Type ALL to include all divisions in the report.
•To print the report for a single division, leave this field blank for the Head Office Division, or enter a specific division code, or select a division from the drop-down list.
•Type SEL to select several specific divisions or divisions by accounting region to include in the report, as outlined in Division Select By Region.
The division selection is restricted by the Divisional Restricted Views assigned to the operator when the report is generated from the menu.
Divisional restricted views do not apply when the report is generated from Automatic Reporting.
PRINT BY DIVISION
Check this box to sort the contracts on the report within division.
Uncheck this box to disregard divisions in sorting and printing the contracts. The division does print for each contract.
INCLUDE ON HOLD INVOICES
Check this box to include current invoices that have not been posted because they have been flagged "On Hold" in Hold/Release Current Invoices.
Uncheck this box to exclude any invoiced revenue on the report even if it has not been posted.
Note: These invoices may or may not have originated from a contract and the invoice resulting from a contract that is returned to a different store could have been created for a different Division.
When the invoice has a source contract, it is the Contract Out division that prints on the PDF output.
Both "Out Div" and document "Div" are included on the spreadsheet output.
If an Accrual Journal is generated, the rental and sales revenue is reported as of the Contract Division OUT and the Services and DW revenue is reported as of the Invoice Division which was the Contract Division IN.
SELL SALES ITEMS
Check this box to include sales parts and rentals on the report.
Uncheck this box to exclude sales, and to print only rental equipment on the report.
PRINT CLASS TOTAL ONLY
Check this box to print only revenue totals per Product Class.
Uncheck this box if Product Class totals are not required on the report.
Note: Because these Product Class Totals do not include any damage waiver, services, or taxes that may also be on the contracts, the feature to populate an accrued journal entry is not provided if only the Class totals are printed.
SORT BY
Select one of the following sort options:
•Select Bill To Name to sort and print the contracts by billing name on the detailed report.
•Select Ship To Name to sort and print the contracts by Shipping name on the detailed report.
REPORT TYPE
Select one of the following reporting options:
•Select Summary to print only the Summarized report totals for Rental Revenue, Sales Revenue, Damage Waiver, Services, Taxes, and Grand Totals by division.
•Select Detail to generate the Detailed report.
The detailed output lists each Contract or Invoice with the document number separately, with the billing amounts for each outstanding item in the range. The product detail shows each product # and description, rental or sale, quantity, unit price, net price and extended amount. The detailed report can print the contracts according to the division.
The rental amounts reflect any maximum Rental Cap assigned to the product detail on the contract.
The spreadsheet output also exports the 'Billed Thru' date as explained below and the optional G/L Revenue Accounts.
The 'Date Out' does not apply to Invoices.
Billed Thru Date:
oOut: status (O) on Contract will have a ‘Billed Thru' date of the report “Billing Date” to reflect the potential revenue to this date less the "Accum Inv Amount"
oOff Rent: status (F) on Contract will show a ‘Billed Thru’ date of the “Off Rental Date” as there will be no more revenue since then
oReturned: status (R) will show a ‘Billed Thru’ date as of the “Rental Return” date as no more revenue is calculated
PRINT FULL ADDRESS
Uncheck this box if the contract address is not required on the report.
Check this box to print the contract "Bill To" or the "Ship To" address on the detailed report, according to the Sort By choice.
ACCRUED JOURNAL ENTRY
This option is disabled if only the Class totals are being printed, or if the operator does not have security access to create Standard Journals transactions.
This feature is activated if an Accrued Journal Entry number has been assigned for Unbilled Revenue reporting in the Company Posting Parameters.
The Journal transaction assigned can be empty as the report will populate the transactions with accounts, divisions and amounts, however if it is not empty as it had already been populated by a prior run, any existing transactions will be over-written.
The prompts are:
CREATE ACCRUAL JOURNAL ENTRY
Uncheck this box to prevent an Accrual Journal entry record from being created using the totals from this report.
Check this box to automatically populate an Accrual Journal entry and reversing entry with the reported totals for rentals, sales, services, and damage waiver.
ACCRUED REVENUE G/L ACCOUNT
If an Accrual Journal is to be created for the unbilled revenue, enter the 'holding' G/L account number to be used to balance the revenue postings in the Accrual Journal entry, or select one from the window.
When an Accrual Journal is generated for an Invoice that was created from a Contract and the Invoice Division is different from the Contract Out Division, all rental and sales revenue is reported as of the Contract Division OUT and all Services and DW revenue is reported as of the Contract Division IN which has become the Invoice division.
If the operator has security access to the Standard Journals programs, the accrual transactions are displayed after the report has been accepted.
Note: Any existing unposted journal details in the Accrual Journal entry will be deleted, and will be replaced with the values based on this report.
RATE STRUCTURE TO USE
This field will default to the selection last run by the operator.
Select one of the following formulas on which to base the unbilled rental revenue calculation:
•Select Current to estimate the earned billings using the exact rate structure defined for each rental product on each contract.
The resulting revenue reflects that value that would be billed if the contract was returned as of the cut-off date, so refer to Rental Return for rental revenue calculation details.
Note: This formula is the default that still applies to non-conforming products when the Monthly formula is selected.
•Select Monthly to use the more conservative formula on eligible rental products, which is based on the monthly rate.
i.e. Monthly Rate / 28 Days * bill days
This formula generates a zero revenue value for rentals pre-billed past the cut-off date of the report.
Calculation Requirements for determining 'Monthly' Rental Revenue:
When the Monthly formula is selected, any rental products that are configured to meet the "Monthly" criteria rules and requirements will reflect unbilled revenue based on the Monthly formula.
Any rental products that do NOT meet the "Monthly" criteria rules and requirements will reflect unbilled revenue based on the default Current formula. This would include rental items with a negative quantity, and items without a monthly rate in the rate structure on the contract.
The "Monthly" criteria rules and requirements include:
oContract must have a positive rental quantity.
oRental product detail must have a Rate Code in the Contract rate structure that has the same 'Hours' as the Hours In A Month defined in the Calendar.
oIf the accumulated billings is more than the calculated billing the system will report $0.00 and not credit anything back.
oThe Monthly billing method will not charge more than the monthly rate per month.
i.e. If a detail is already partially billed for the month (possibly at a higher daily rate), the unbilled revenue will not exceed monthly rate.
oAll rental products on a Contract that has been flagged for Seasonal billing, where the "Rental Rate Code" assigned in the document Rental Period window matches the Seasonal Rate code defined in the Company Rates Parameters, will always use the Current calculation.
oRental Cap processing is respected.
Note: The unbilled amounts for associated Damage Waiver, any Services as a percent of rental, and Taxes will also be impacted by the formula selected, as they are based on a percent of the rental revenue value.
REPORT OPTIONS
This value defaults to the operator preference as defined in Operators.
Select one of the output options to Print a report or export the data to Excel as outlined in Report Options.
INCLUDE REVENUE G/L ACCOUNT
This option is only available for the "Detailed" output with the Excel spreadsheet format where additional columns can be added.
Leave this field blank to exclude the G/L Account column.
Check this box to include the 'G/L Account' with 'Description' columns for the potential Revenue.
Finished?
A printer can be confirmed or re-selected from the Printer option located on the menu bar at the top of the screen.
Click ACCEPT to begin printing the report, or CANCEL to abort.
G/L Standard Journal Entry:
If an Accrued Journal Entry has been created and the operator has security access to the Standard Journal programs, the journal details are displayed as outlined in Standard G/L Journals.
The journal can be dated and posted to the G/L using Post Standard G/L Journals.
Note: If the report is re-run and another Accrued Journal entry is created before an earlier journal is posted, the earlier transactions will be over-written by the subsequent ones without ever being posted.
Topic Keyword: RSXD16