Aged Receivables Report

To access this report, go to Reports > Accounts Receivable> Aged Receivables

Use this report to print a list of invoices using a time factor. The report separates the invoices into four sections of time. It can be used to review the status of current Accounts Receivable balances. Quickly view which invoices are past due according to the criteria that is established. Data from the detail ledgers summarizes all entries for an AR invoice, credit, or receipt. The detail entry amounts for an invoice are netted together creating a summary amount due.

These are the System Default reports available for Aged Receivables:

Aged Receivables Report
End of Year Outstanding Invoices Report

Tip: If you're not familiar with the MIP Cloud Report Builder interface, see Report Builder for an introduction.

You can choose to use the report as-is by selecting Export or View, or make edits to the report by selecting Edit.

If you choose to make edits to the report, the Report Builder page will display. From this page, use the Setup tab to choose the columns you'd like to appear on the report. You can rename the columns under the Column Heading.

The following columns are available to include in the report:

Column	Description
Class	This item is used to limit or sort a range of customer IDs. Assign it to different IDs so that they can be grouped together. The report shows the class-Financial Counseling or Budget Counseling, for example.
Type	This is used as a second-level sort for Class. Use it to limit or sort a range of customer IDs. For example, within the Class Financial Counseling, you might assign Types Bankruptcy, Debt Consolidation, or Refinancing. The report would show these types.
Customer ID	The customer entered on the Transactions>Accounts Receivable>Invoices form.
Customer Name	The name assigned to the customer using the Maintenance>Accounts Receivable>Customers form.
Status	The status of the customer ID-Active, Inactive, or Discontinued.
Invoice/Credit Number	The invoice or credit number entered on the AR Invoices form.
Invoice/Credit Date	The invoice or credit date entered on the AR Invoices form.
Due Date	The due date entered on the AR Invoices form.
Invoice/Credit Description	The description entered on the AR Invoices or AR Credits form.
Credit Type	The credit type of Applied Credit, Prepayment, or On Account displays. This was selected on the Enter AR Credits and Enter AP Credits forms.
Account Code	The account code associated with a transaction, plus the Group Code selected on the Groups tab. The report prints the account code, such as, 201, 05, or 45001. The system displays one column for each code type, such as Fund Code or GL Code.
Account Title (plus Group Code selected from Group Sets)	The title associated with each code above, plus the Group Title selected on the Groups tab. The report prints one column for each code type, such as Fund Title or GL Title.
Account Short Title (plus Group Code selected from Group Sets)	The short title for the title above (15 characters or less), plus the Groups Short Title selected on the Groups tab.
Source Currency	The currency type assigned to the session, such as USD, CAD, or EUR. Currencies were created and activated by the Administrator using the Organization>Currency Setup form.
Source Currency Description	The description associated with the session currency, such as US Dollar, Canadian Dollar, or Euro.
Current	For functional currency, the sum of the records having a date greater than or equal to the aging date. Enter the aging date and specify either Due Date or Invoice Date on the Options tab. For non-functional currency, the Source Current times the Exchange Rate.
Aging Period 1	For functional currency, the sum of the records having invoices with a date between one day before the aging date through the number of days in the first Aging Period box on the Options tab. For non-functional currency, the Source Aging Period 1 times the Exchange Rate.
Aging Period 2	For functional currency, the invoices with a date between one day before the first Aging Period box through the number of days in the second Aging Period box. For non-functional currency, the Source Aging Period 2 times the Exchange Rate.
Aging Period 3	For functional currency, the invoices with a date between one day before the second Aging Period box through the number of days in the third Aging Period box. For non-functional currency, the Source Aging Period 3 times the Exchange Rate.
Over Aging Period 3	For functional currency, the sum of the records having a date equal or less than the Aging date minus Aging Period 3 Days plus 1. The Aging Date is either the Due Date or the Invoice Date selected on the Options tab. For non-functional currency, the Source Over Aging Period 3 times the Exchange Rate.
Total	For functional currency, a total of all aging columns (Current, Aging Period 1, Aging Period 2, Aging Period 3, and Over Aging Period 3). For non-functional currency, the Source Total times the Exchange Rate.
Source Current	The sum of the records having a date greater than or equal to the aging date. Enter the aging date and specify either Due Date or Invoice Date on the Options tab.
Source Aging Period 1	The sum of the records having invoices with a date between one day before the aging date through the number of days in the first Aging Period box on the Options tab.
Source Aging Period 2	The invoices with a date between one day before the first Aging Period box through the number of days in the second Aging Period box.
Source Aging Period 3	The invoices with a date between one day before the second Aging Period box through the number of days in the third Aging Period box.
Source Over Aging Period 3	The sum of the records having a date equal or less than the Aging date minus Aging Period 3 Days plus 1. The Aging Date is either the Due Date or the Invoice Date selected on the Options tab.
Source Total	A total of all source aging columns (Source Current, Source Aging Period 1, Source Aging Period 2, Source Aging Period 3, and Source Over Aging Period 3).
Billing Contact Title	The title for the billing contact person, such as Ms. or Mr.
Billing Contact Name	The name of the billing contact.
Billing Contact Position	The billing contact's position, such as Sales Rep or Owner.
Billing Contact Email	The email address for the billing contact.
Billing Voice Number	The billing contact's voice telephone number.
Billing Fax Number	The billing contact's fax number.
Billing Address	The street or post office address of the billing contact.
Billing City	The city of the contact.
Billing State/Prov.	The state or province of the contact.
Billing Postal Code	The postal code for the designated billing city/state.
Billing Country	The country associated with the Billing Address.
{User Defined Field} - Customers	A customer type user defined field and its data. There will be a separate column for each field that was created by the Administrator using the Report Builder Setup Tab.
{User Defined Field} - Transaction Documents	A transaction document type user defined field and its data. There is a separate column for each field.
{User Defined Field} - AR Invoices	An AR Invoice type user defined field and its data. There will be a separate column for each field.
{User Defined Field} - AR Invoice Detail	An AR Invoice Detail type user defined field and its data. There will be a separate column for each field.

Use the Filter tab to narrow down and define the data using the available filters.

Use the Options tab to Summarize Amounts on the report, implement security features, and more.

Select "Summarize Amounts" to add amounts together and display one line item with the total amount. All document information must be identical for the system to add items together.

Select "Do Not Allow Changes to this Report" to secure the report so that other users cannot save their changes to it. This option can only be undone by the user that locked the report.
Select "Year End Adjustments" to include year end adjustments on the report. This entry type was designated during transaction entry.
Select "Open Entries in Detail" to include opening balances (system or user opening entries) in detail.
Select "Replace total debits and credits with Balance" to show the net amount for each segment where totals have been requested. Otherwise, the report displays the total debits and total credits for each segment.
Select "Suppress Lines with All Zeros" so that documents with zero amounts do not print. This eliminates records having zero in all amount columns. If it is not selected, every line prints, even if it has a zero value.

Use the Layout tab to change the font and page setup for a report.