Remittance Ageing

The Remittance Ageing tab allows a Billing Operator or Billing Analyst to view payment information and generate Ageing Reports on demand.

Important!  The date range defaults to the last seven days. To modify the date range, click the calendar icon () in the page header. You can select presets for Today, Yesterday and today, Yesterday, Last 7 days, Last 30 days, This month, Previous month, or Custom range. The Custom range option allows you to edit the date range (the beginning date can be up to seven years in the past). The selected date range is reflected in the table's Received datetime column.

Tip:  To filter the table, click the filter icon () to open a dialog box. From here, you can select any of the available known values listed by FRMP.

The data can be sorted by any column (except for the Created datetime column) by clicking the desired column header. By default, the table is sorted by FRMP (primary sort) and Received datetime (secondary sort). The table consists of the following columns:

  • FRMP. The Financially Responsible Market Participant (retailer).
  • Received datetime. The date and time at which the remittance was recorded in MTS.
  • Filename. The name of the remittance file received (.csv format). The file name includes a date/time value.
  • Gross amount paid. The pre-tax amount paid.
  • GST amount paid. The Goods and Services Tax (GST) amount paid.
  • Net amount paid. The total amount paid (GST included).
  • Created datetime. The date and time at which the remittance record was created. MTS pulls this date directly from the Filename.
  • Username. The application or MTS user that last updated the remittance record.
  • Action (). Provides the option to View details about the remittance associated with the FRMP listed on that row. For more information, see Remittance Detail.

Tip:  To quickly locate one or more invoices, click Search (), enter all or part of a Filename, Invoice number, Transaction ID, NMI, or Net amount paid. You can use Boolean operators (such as AND, OR, and NOT) between additional search terms. Press Enter or click Search () again. The results appear in the list. To clear the results, click the X in the search box.

If you select one or more rows, the following Totals appear above the table:

  • Gross. The total of all Gross amount paid values for the selected records.
  • GST. The total of all GST amount paid values for the selected records.
  • Net. The total of all Net amount paid values for the selected records.

Note:  The Totals change as you select or deselect rows in the table or perform filtering or searching on the selections.

The Actions menu () in the page header provides the following options:

  • Import remittance file. Allows you to import a remittance file via bulk upload (.csv format).

    Note:  If the import file validates successfully, a confirmation will appear in a dialog box. If validation fails, an error log will appear. In this case, nothing is imported into MTS. You can click the copy icon () to copy the error message to your clipboard and then resolve the issue or notify the retailer.

  • Column order. Enables you to adjust the order of the columns. The adjusted order will persist in subsequent views if you use the same device and browser.
  • Column visibility. Enables you to adjust which columns are visible or hidden. The adjusted visibility will persist in subsequent views if you use the same device and browser.
  • Ageing report. Downloads a report (.xlsx format) that is generated based on the selected records for the selected date range. The report includes ageing data listed by FRMP retailer. This report can also be emailed to a configurable email address using the NETB_REMIT_EMAIL_FROM and NETB_REMIT_EMAIL_TO email groups.