Receivables/Payables
Receivables / Payables
This report can be used for different financial movements:
- outstanding items and
- overdue outstanding items on the specific day in the past by vendors and customers and
- debit transactions,
- credit transactions,
- debit balance and
- credit balance by customers and vendors for the specific period in the past.
|
Customer Accounts
|
|
Enter customer accounts separated by a semicolon, when more than one account is entered. |
|
Supplier Accounts
|
|
Enter customer accounts separated by a semicolon, when more than one account is entered. |
| Show For customers |
|
Enter the number of records to display on a review of the panel Receivables. Value "-1" means "for all customers". Value 10 means for top 10 customers. |
| Show For Suppliers |
|
Enter the number of records to display on a review of the panel Payables. Value "-1" means "for all payables". Value 10 means for top 10 payables. |
| Sum for others (customers) |
|
Program shows SUM for ALL other customers in report in one record. Setting can be checked only if Show for IS NOT set to all (-1) |
| Sum for others (suppliers) |
|
Program shows SUM for ALL other suppliers in report in one record. Setting can be checked only if Show for IS NOT set to all (-1) |
| Sort customers; Sort suppliers |
|
We sort type of sort from drop down menu. There are two options: By balance descending and By balance ascending.
Example 1: Show for 10 customers and sort by balance descending; check on Overdue Outstanding Items: We will get top ten customers which have biggest debt on defined date in report.
Example 2: Show for 10 customers and sort By balance descending; check on Debit transactions for the last 6 month: Te report will gives ua top ten customers regarding debt turnover in the last 6 month from the set date.
|
| Sort by |
|
The display can be sorted according to two of the records (display mode) in tab Receivables an tab Payables. This is ticked. The column will be grayed in report. |
| Receivables |
|
This setting is connected to setting Sort By. If check box is on Sort By and Receivables, means that row in display mode (in this case Debit translaction) will bi primarily sorted by Descenting in tab Receivables. |
| Payables |
|
This setting is connected to setting Sort By. If check box is on Sort By and Payables, means that row in display mode (in this case Credit translaction) will bi primarily sorted by Descenting in tab Payables. |
| Display Mode |
|
From drop down menu choose: Outstanding items, Overdue Outstanding Items, Debit Transactions, Credit Transactions, Debit Balance or Credit Balance. This options form columns in the report. |
| Interval |
|
We choose time interval from drop down menu (month, day, quarter). |
| No. |
|
Enter the number of units for display (eg. -3 with inteval month in column Debit and Credit transactions and also debit and credit balance means 3 month in the past from the date of the report). For a more detailed overview of the turnovers we recommend using the interval Day. |
| Use Date |
|
We choose the option from drop down menu:
|
| Show share for payables |
|
Program shows percentage in grid for selected data in report |
| Show share for receivables |
|
Program shows percentage in grid for selected data in report |
 |
Setting Use date has impact only on Debit and Credit transactions and Debit and Credit Balance. It does not impact on outstanding items or overdue outstanding items.
|
To see an example follow this link Receivables / Payables.