Advance holders reports
The following reports are available for advance holders in Russia.
- Advance holder balance report
- Advance holder transactions report
- Transaction settlements report
- Advance report
- Advance holder turnover register
These reports can be accessed by going to Accounts payable > Inquiries and reports > Advance holders inquiries and reports.
Advance holder balance report
The Advance holder balance report displays the balances of the amounts that are paid to or received from advance holders in an organization. Accountants generate this report periodically or daily to review and monitor the debts of an advance holder.
When you generate this report, the following parameters are displayed. You can use these parameters to filter the data that will be displayed on the report.
FastTab | Field |
Description |
|---|---|
Parameters | To date |
Select the date on which to generate the advance holder amount balance report. |
Parameters | Currency distribution |
Select this check box to display the advance holder amount balance grouped by currency code. |
Records to include | Worker ID |
The identification number of the employee for whom the advance holder amount balance is displayed. If no employee is selected, then the report will include all employees. |
Advance holder transactions report
The Advance holder transactions report displays the expense transactions of an employee and the amounts that are paid in advance to that employee. Accountants generate this report periodically or daily to review and monitor the advance transactions.
When you generate this report, the following parameters are displayed. You can use these parameters to filter the data that will be displayed on the report.
FastTab | Field |
Description |
|---|---|
Parameters | Main accounts only |
Select this check box to display only main accounts in the report. |
Records to include | Employee |
The identification number of the employee for whom the transaction report is generated. |
Records to include | Advance holder |
The identification number of the advance holder for whom the transactions are posted. |
Transaction settlements report
The Transaction settlements report displays cash refunds and advance amounts that are paid to an employee by the legal entity. Accountants generate this report periodically or daily to analyze transactions that occur in multiple currencies between an employee and the legal entity to calculate the debt balance of the employee.
When you generate this report, the following parameters are displayed. You can use these parameters to filter the data that will be displayed on the report.
Field |
Description |
|---|---|
Worker ID |
Select the identification number of the employee for whom the transaction settlements report is generated. |
To date |
Select a date up to which the transactions are included on the report. |
Real-time settlement |
Select this check box to include real-time settlement transactions to the report. |
Advance report
To print an advance report in a form that is legally required in Russia, you need to print the report after an advance invoice that is issued to an advance holder is settled. You need to select a particular advance report number to be included in the report.
Note
The amounts on the Advance report page are recalculated on the date when the payment journal for the advance holder is posted.
The Advance report will be print in Microsoft Excel format.
Advance holder turnover register
An additional report, Advance holder turnover register is available in General ledger > Inquiries and reports > Turnover balance statement.
When you generate this report, the following parameters are displayed. You can use these parameters to filter the data that will be displayed on the report.
Field |
Description |
|---|---|
Date interval code |
Select the value of the period from the table of date intervals. |
From date |
Enter the start date of the period for generating the report. Manually select or insert from the selected code of interval dates. |
To date |
Enter the end date for the period for generating the report. Manually select or insert from the selected code of interval dates. |
Currency type |
Select the transaction's currency type from the list. These values can be used: Standard currency, Secondary currency, and Stated currency. |
Currency |
Enter the secondary currency of the transaction. This field is available if the currency type is Stated currency. |
Main account |
Enter the accounting record of employee advances for which the report will be generated. |
Financial dimensions |
Provide the dimensions codes if it is necessary to choose transactions with specific codes for the report. If the dimensions are not populated, the system will select transactions for the report having any dimension codes. |
Print ranges |
Set the option to display request conditions when printing the report. |
Delete zero line |
Set the option to not print zero lines or columns. |
Total accounts |
Set the option to print total accounts. |
Show transactions |
Set the option to display the transactions of advance holders. |
In the Details and sorting parameters section, select the available fields to be included into the report. On the Records to include tab, define additional filtering conditions, if needed.