Outstanding Contract Amount Report
Hi team,
It was be very useful to have a report which, by open rental contract, which gives you the following:
1) The total contract value (excluding tax) of all the lines
2) Life-to-date amount billed on contract (excluding tax) - all rental line amounts that are tagged billed = true
3) Remaining amount on contract (excluding tax) - all rental line amounts that are tagged billed = false
In the attached example, the total value of this contract (assume it's only one line) is 12x70 (ex. tax) = $840.00. Of which, the total amount billed is the first 9 lines ($630) which works out to be a remaining amount on the line (contract) of $840 - $630 = $210.
This report, when managing large volumes of contracts will give us the ability to easily understand what needs to be re-signed/renewed and also give us an idea of the invoicing backlog that is secured for the future.
Thanks,
Tim
Comments: 4
-
24 Mar, '23
olivianeed a way to view forecasted revenue, or at least a way to see how much revenue is on the open contracts
-
25 Aug, '23
Tim@olivia, completely agree!
-
25 Aug, '23
Daren Christoffersen AdminOutstanding Contract Amount Report will be in the next release of rentals (Fall 2023)
-
04 Dec, '23
Daren Christoffersen AdminV12 was released late last week and includes the "Outstanding Contract Amount" report.
You can find the report under actions on the "Business Manager" role center (Reports > Rental Reports > "Outstanding Contract Amount") or by searching in the "Tell Me" search window.