Receivables/Payables
In the reports for financial institutions, you can review:
- outstanding items,
- overdue outstanding items on the specific day in the past by suppliers and customers,
- debit transactions,
- credit transactions,
- debit balance,
- credit balance by customers and suppliers for a specific period in the past.
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.
Here is a description of the form and its individual elements.
|
Table of contents:
- Toolbar
- Header
- Tabs
|
Toolbar enables various functionalities in the Document Type register.
In the header of the form, enter the data necessary to enter the type of document. The created document type is defined with the following data:
|
ID
|
Enter any three-digit alphanumeric code of the type document in the field.
|
|
Short name
|
In the field, enter any short name of the type document that is printed on reports.
|
|
Name
|
Enter the descriptive name of the document type in the field.
|
|
Record Only
|
The field is marked in yellow if it is a record type documents.
|
|
Group
|
Each type of document can be assigned a group so that it can be properly grouped in the menu.
|
|
Link to LT/LX menu
|
The setting of the field is mainly intended for accounting firms whose users of LT/LX programs connect via the cloud to the database on which the accounting firms also works, as well as independent users of LT/LX versions.
 |
HINT
For more detailed instructions and field descriptions, see the chapter Link to LT/LX menu.
|
|
|
Classification
|
Select the document type classification from the drop-down list. Classifications can be created on the Classification Scheme form.
|
3.1 Accounts Receivable/Payable
In this section, define the settings for the display type.
|
Customer Accounts
|
Enter customer accounts separated by semicolons when entering multiple accounts.
|
|
Supplier Accounts
|
Enter supplier accounts separated by semicolons when entering multiple accounts.
|
|
Show For customers
|
Enter a number to show the records in the overview for the Receivables tab. A value of -1 means 'for all buyers'. A value of 10 means ten customers.
|
|
Show For Suppliers
|
Enter a number to show the records in the overview for the Payables tab. A value of -1 means 'for all suppliers'. A value of 5 means 5 suppliers.
|
|
Sum for others (customers)
|
If the value -1 is not entered in the Show for customers field, a separate item with the sum of other customers (Sum of others) can be displayed by activating this radio button.
|
|
Sum for others (suppliers)
|
If the value -1 is not entered in the Show for Suppliers field, a separate item with the sum of other suppliers (Sum of others) can be displayed by activating this radio button.
|
|
Sort customers; Sort suppliers
|
Select the sorting option from the drop-down menu. The available options include:
- Sort – By balance descending
- Sort – By balance ascending
|
hint
Example 1: Show for 10 customers and sort by balance descending; checkmark for sort by outstanding receivables due: The display shows the ten customers with largest outstanding receivables according to the outstanding receivables due at the date of the review.
Example 2: Show for 10 customers and sort by balance descending; tick on debit turnover for the last 6 months: The display shows the ten largest customers by debit turnover for the last 6 months.
|
|
|
Sort by
|
The display can be sorted according to two records (display mode) in the Receivables and Payables tabs. This option is checked. The column will be grayed out in the report.
|
|
Receivables
|
This setting is connected to the Sort By setting. If Sort By and Receivables are checked, this means that the row in the display mode (in this case Debit transaction) will be primarily sorted descending in the Receivables tab.
|
|
Payables
|
This setting is connected to the Sort By setting. If Sort By and Payables are checked, this means that the row in the display mode (in this case Credit transaction) will be primarily sorted descending in Payables tab.
|
|
Display Mode
|
From the drop-down menu, select one of the following (these options will be displayed as columns in the report):
- Outstanding Items
- Overdue Outstanding Items
- Debit Transactions
- Credit Transactions
- Debit Balance
- Credit Balance
|
|
Interval
|
Select the time interval from the drop-down menu (month, day, quarter).
|
|
No.
|
Enter the number of units for display (for example: -3 with interval month in column Debit and Credit transactions and also debit and credit balance means 3 months in the past from the date of the report).
For a more detailed overview of transactions, it is recommended to use the Day interval.
|
|
Use Date
|
Select the option from the drop-down menu:
- Document Date
- Due Date
- Target Date (from journal entry header)
 |
WARNING
Setting Use Date only affects Debit and Credit transactions and Debit and Credit Balance. It does not affect the Outstanding Items or Overdue Outstanding Items.
|
|
|
Show share for payables
|
Program shows a percentage in the grid for the selected data in the report.
|
|
Show share for receivables
|
Program shows a percentage in the grid for the selected data in the report.
|
4. Notes
In this tab you may enter and edit notes of which text can be displayed at the bottom of document type. You can create pre-prepared notes templates in the Document Texts.
5. Permissions
On the Permissions tab, we set authorizations to one or more users at the same time.