Analysis of receivables and liabilities
PANTHEON
The report is intended for users who prepare analyses for the needs of financial institutions, such as banks.
Report can be accessed from the menu Financials | Special reports | Reports for financial institutions.
 |
HINT
The document type for the Analyses of receivables and payables must first be created in the Document Types register.
|
The settings can be accessed from the menu Settings | Program | Document Types. The Document Types register opens, where you click the panel Financials | Reports – Financials | Receivable/Payables.
Select the button New record and add ID/name of report:
Next, select the Customer and Supplier accounts i.e 12% and 22% (meaning all accounts starting with number 12 or 22 should be considered).
On tab Accounts Receivable/Payable in the column Display mode, from the drop-down menu, select options which should be displayed as columns in the report i.e:
- Outstanding Items
- Overdue Outstanding Items
- Debit Transactions
- Credit Transactions
- Non-due outstanding items
- Debt structure - overdue outstanding items (period 1) - add number of days in column No.
- Debt structure - overdue outstanding items (period 2)- add number of days in column No.
- Debt structure - overdue outstanding items (period 3)- add number of days in column No.
 |
Warning
In case you have selected the same period for Debt structure -overdue outstanding items in two rows with a different number of days, the program will issue a warning:
|
After settings in document type, open menu Financials | Special reports | Reports for financial institutions and select the button New record. Choose date:
Select the button
(Collect Data). Data is displayed in three different tabs:
|
HINT
Data displayed on report in columns Non-due outstanding items and Debt structure are the same as report of Debt structure.
|
By right-clicking the mouse, the report can be exported to Excel:
