Skip to content

Reports

Financial Reports and Analytics in MatterX

Financial reporting in MatterX allows financial and business professionals to create, maintain, deploy, and view financial statements. It moves beyond traditional reporting constraints to help you efficiently design various types of reports. MatterX includes several reports, tracing functions, and tools that help auditors or controllers who are responsible for reporting to the finance department. Financial reporting includes support for dimensions, so account segments or dimensions are immediately available. No other tools or configuration steps are required.

Financial Reports

Report Object ID Description
Trial Balance 6 Shows the chart of accounts with balances and net changes. You can choose to see a trial balance for selected dimensions. You can use the report at the close of an accounting period or fiscal year.
Trial Balance by Period 38 Shows the opening balance by general ledger account, the movements in the selected period of month, quarter, or year, and the resulting closing balance.
Trial Balance/Budget 9 Shows a trial balance in comparison to a budget. You can choose to see a trial balance for selected dimensions. You can use the report at the close of an accounting period or fiscal year.
Detailed Trial Balance 4 Shows a detail trial balance for selected general ledger accounts. You can use the report at the close of an accounting period or fiscal year. You can define which accounts are included in the report by setting filters.
Trial Balance/Previous Year 7 Shows a trial balance in comparison to the previous year's figures. You can choose to see a trial balance for selected dimensions. You can use the report at the close of an accounting period or fiscal year. The previous year means the same period one calendar year earlier.
Account Schedule 25 Account schedules can be used to display the general ledger accounts in a different way than in the chart of accounts. For example, account schedules can be used for reports on key figures.

Accounts Receivable Reports

To help you manage your accounts receivable in MatterX, standard reports and analytics are built in. The following table describes some of the key reports in accounts receivable reporting.

Report Object ID Description
Aged Accounts Receivables 120 Shows the amount outstanding with clients broken down into time intervals for the overdue time. The report also displays the part of the clients' balance that is not due and can be shown with or without document details for each client. This report is the main report for reconciling client ledger to G/L. Assuming you have not allowed direct posting to the accounts used in the client posting groups' receivables account, this report is a specification of the amounts you find in G/L.
Client Statement 1316 Generates a client statement for a specified time interval. It's usually sent to the clients to give them an overview of outstanding amounts and also as a reminder to pay any overdue amounts. You can choose to show the overdue amounts in a separate section. You can include an aging band similar to the one used in the Aged Receivables report. For the aging band, you typically set 30D, which means 30 days intervals such as30, 60, 90, and 90+ days overdue, from the ending date, or 1M+CM, which will be the current month in a separate interval and then monthly intervals for the preceding months. Note: In the client list, this report also has a separate action, Scheduled Statements. This option does not filter to the client you have selected. It's the same report but used when you want to send statement to all/more clients.
Client - Balance to Date 121 Shows the open client ledger entries until the ending date. This report shows similar content as the client statement but with no indication if the entry is overdue. Note: The date filter will be applied to the detailed client ledger entries. This means that if you have payments later than the ending date that have been applied to invoices in within the date range, the invoices will appear in the report as they have not been closed as per the ending date.
Client – Trial Balance 129 Shows the net changes for clients for the period specified in the date filter as well as the net change year-to-date for the fiscal year corresponding to the period selected. The report is grouped by client posting groups and will give a different view of the client ledger than the Aged Account Receivables report. Note: If you haven't set up any accounting period, the system will not know what fiscal year to use and will either show year-to-date from the most recent fiscal year defined or just select the period, which may or may not be from beginning of a year.
Client – Detail Trial Balance 104 Shows all the client ledger entries within the specified date filter. This report is generally used to check that all entries for a specific client are accounted for, or other internal checks on client ledgers.
Client - Payment Receipt 211 Creates a payment receipt for each client ledger entry of type Payment. If the payment has been applied to invoices, the invoices will be specified; otherwise, it will just state the payment amount as unapplied. This report is used to send to clients that want documentation for receipt of payment.
Reconcile Client and Vendor Accounts 33 Shows the G/L entries resulting from posting client and vendor entries split per G/L account and posting groups. This report is used for reconciling the balances on client and vendor ledgers to general ledger balances.
Client – Summary Aging Simp. 109 This is a legacy version of an accounts receivables aging report. We recommend you use the Aged Accounts Receivables report instead.
Sales Statistics 112 Shows amounts for sales, profit, invoice discount, and payment discount in LCY, and the profit percentage for each client. The costs and profits are given as both the original and adjusted amounts. The original costs and profits are those values that were calculated at the time of posting, and the adjusted costs and profits reflect changes to the original costs of the items in the sales. The cost adjustment amount shown in the report is the difference between the original cost and the adjusted cost. The figures are divided into three periods. You can select the length of the period, starting on a selected date. There are also columns for amounts before and after the three periods. Use the report to analyse earnings from an individual client and earnings trends, for example. This report can also be used in accounts receivable as it's easier to do a quick look-up of posted payments, discounts, and sales for a given client.
Client List 101 Shows various kinds of basic information for clients, such as client posting group, discount group, finance charge and payment information, salesperson, the client's default currency and credit limit in your local currency (LCY), and the client's current balance (in LCY). The report can be used, for example, to maintain the information in the client table.

Accounts Payable Reports

To help you manage your accounts payable in MatterX, standard reports and analytics are built in. The following table describes some of the key reports in accounts payable reporting.

Report Object ID Object ID
Aged Accounts Payable 322 Shows overdue balances for vendors in overdue time intervals. The overdue amounts can be shown by due date, posting date, or by document date as needed. You can choose to show the amounts in local currency (LCY) and print details of the overdue documents. The time intervals can have headings with dates or with number of dates overdue, relative to the specified aging by type. This report is the main report for reconciling vendor ledger to G/L. Assuming that you have not allowed direct posting to the accounts used in the vendor posting groups' payables account, this report is a specification of the amounts you find in the general ledger.
Vendor - Balance to Date 321 Shows the vendor balance by the ending date of the specified date range. You can choose to display the vendor balance in your local currency (LCY). Select the Include Unapplied Entries field to show entries that have been closed by the ending date but have been un-applied (opened) at a later date. Select the Show Entries with Zero Balance to show vendors with a balance of zero by the ending date of the date filter. The date filter applies to the detailed vendor ledger entries for the entries in the report. If you have payments later than the ending date that have been applied to invoices in within the date range, the invoices will appear in the report as they have not been closed as by the ending date.
Vendor – Trial Balance 329 Shows the net changes for vendors for the period specified in the date filter as well as the net change year-to-date for the fiscal year corresponding to the period selected. The report is grouped by vendor posting groups and will give a different view of the vendor ledger than the Aged Accounts Payable report. Note: If you haven't set up any accounting period, the system will not know what fiscal year to use and will either show year-to-date from the most recent fiscal year defined or just select the period, which may or may not be from beginning of a year.
Vendor – Detail Trial Balance 304 Shows all the vendor ledger entries within the specified date filter. The report shows the vendor's beginning balances relative to the date filter.
Purchase Statistics 312 Shows purchase statistics for each vendor. This includes information for five periods, starting on the date that you specify. The report includes the total purchases, payments, finance charges, and discount information including the payment discounts taken and lost. Statistics are calculated for purchases before the date entered, at three one-month intervals from the date entered, and for a period including all purchases made after the third one-month interval. This report can also be used in accounts payable as it's easier to do a quick look-up of posted payments, discounts, and other transactions for a given vendor.
Vendor – Summary Aging 305 Legacy report for aged accounts payable. We recommend that you use Aged Accounts Payables report instead. You can choose a period length and a date to use as set overdue per date.
Payments on Hold 319 Shows vendor ledger entries where the On Hold field is not blank.
Vendor Pre-Payment Journal 317 Shows the payment journal with payment discount and tolerance information. The report can be used to check payments before creating payment files and posting the journal. Note: The report will show payment discounts incorrectly when multiple credit memos have been used in an application. In this case, the payment discount for the additional credit memos will be shown as an un-applied amount.
Vendor – List 301 Shows various kinds of basic information for vendors, such as vendor posting group, discount and payment information, priority level and the vendor's default currency, and the vendor's current balance (in LCY). The report can be used, for example, to maintain the information in the Vendor table.