• Home
• About
• Control Panel

Aged Receivables List report (#RPTARLR01)

Last updated:		Applies to:		In industries:		Of versions:		Special contents:
20120228 (Andy)		Pro, MultiUser, MultiSite, MultiView				7.X (and higher)		n/a

About the Aged Receivables List report

This report is accessed via Reports, then Management. This report will show you active Customers whose balance owing is not equal to zero. The total owing on this report includes the amount owing for all Berths / Units / Vaults and Agreements for that Customer.

The report shows the Berth / Unit / Vault or Agreement numbers (depending how the report is sorted) the Customer name, the date of the last payment made and the balance owing. The balance owing is split across the time periods that you have specified via Maintenance, System Setup then the Reports & Refunds tab (eg 1-30 days, 31-60 days, 61-90 days and 90+ days).

The report also has 3 other columns:

• In Credit - This is the amount that the Customer is in credit by (the total of the Total Balance Due if this is a negative).
• Rent In Advance - The total amount of rent that has been billed past the date of the report.
• Paid in Advance - The total amount of rent that has been paid in advance, calculated on a daily basis.

Note: You can change the way this report is sorted by changing the reporting system preference. This is under Maintenance, System Setup, then the Reports & Refunds tab. Using the option Report column display you can control whether to print this report by Berth No. / Unit no. / Vault No. or by Customer Code. If printing by Customer Code, please note that the report will be sorted by Customer CODE and not by Customer name. Please also note that changing this system preference affects the sort order for the following reports: Customer Balances report, Aged Receivables List, Income Occupancy Reconciliation, Rent Roll Report, Summary of Charges, and the Prepaid Report.Note: You can change the period of these days under Maintenance, System Setup, then the Reports & Refunds tab. The option Aged Receivables Breaks is what determines the time periods. It will default to 1,30,60,90.

Note: The 'In Credit' column and the 'Paid In Advance' column will not necessarily be the same figure. For example, say a Customer has been billed 6 months in advance at $100 a month, and the Customer has paid that $600, bringing their account balance to $0. The In Credit amount for this Customer would be $0, but the paid in advance column would be $600. If the Customer had paid $800 their Agreement balance would be in credit by $200, so the In Credit column would read $200 but the paid in Advance column would read $800.Important: The Paid in Advance total on the Aged Receivables List is unlikely to be the same as the Paid in Advance total on the Prepaid report. There are 3 reasons for this...

1) The Aged Receivables report is based on Customer totals, whereas the Prepaid Report is based on Agreements. If a Customer has more than one Agreement, the paid in advance total could potentially be different on the Aged Receivables when compared with the same figure on the Schedule of Prepaid Rent.

2) The Aged Receivables List is always calculated on a Daily Basis, which is likely to produce a slightly different result for some Customers compared with calculating the Prepaid report on a whole month basis.

3) The Paid in Advance on the Prepaid report also includes prepayments of other types of transactions, not just rent. The Aged Receivables only includes prepayments of rent. This last reason is likely to be where most of the differences lie.