17 Account Analysis by Correspondence

This chapter contains these topics:

• Section 17.1, "About Account Analysis by Correspondence,"

• Section 17.2, "Processing Options,"

• Section 17.3, "Data Selection,"

• Section 17.4, "Data Sequencing,"

• Section 17.5, "Report,"

• Section 17.6, "Fields Description."

17.1 About Account Analysis by Correspondence

Navigation

From Correspondence (G74R09), select 22 Acc.Anal. by Correspondence

Russian Legislation defined Legal Reports to be presented to the Fiscal Authority.

One report is the Account Analysis by Correspondence based on Correspondence Accounting information.

This process generates the formatted report that meets the legal requirement.

This is a Batch Process that takes data from the Correspondence Balance File and the Account Master File.

The processing options establish Selection criteria and Mode of Processing.

The information entered into the processing options is validated, if errors are found, a report indicating the error message prints and the process ends.

The system only prints Accounts from the Correspondence Balance File that meet the Selection criteria in processing options and Data Selection.

17.2 Processing Options

See Section 52.3, "Acc. Analisys by Correspondence - Summary (P74R0925)."

17.3 Data Selection

Data Selection is based on F0901 file - Account Master.

You can select any field in the Account Master File for Data Selection.

If during the process no data is selected as a result of Selection criteria in Processing Options and Data Selection, the following Error Message prints:

• 116V - No Data Found. No data was found for this instance. Check your data selection.

17.4 Data Sequencing

The process contains two DREAM Writer versions, one to print the report in Detailed mode and a second to print the report in Summary mode.

The Data Sequencing for Summary mode has as first sequence field the Category Code XX, where XX must be the Summary Account Category Code Nbr assigned to contain the Summary Statutory Account Code in the range of 01-20.

The Data Sequencing for Detailed mode has as first sequence field the Category Code XX, where XX must be the Acct Category Code Nbr in the Correspondence Setup File (X0CCNB).

Figure 17-1 Data Sequence Setup (Account Analysis) screen

Description of "Figure 17-1 Data Sequence Setup (Account Analysis) screen"

The users are responsible to correctly set the Category Code Number in the first Sequence field of the DREAM Writer.

17.5 Report

Figure 17-2 Account Analysis by Correspondence Report (1 of 2)

Description of "Figure 17-2 Account Analysis by Correspondence Report (1 of 2)"

Figure 17-3 Account Analysis by Correspondence Report (2 of 2)

Description of "Figure 17-3 Account Analysis by Correspondence Report (2 of 2)"

17.6 Fields Description

17.6.1 Report Heading

Field	Explanation
Selected Period	From Processing Option 1.
Legal Company	From Processing Option 2.
Correspondence Account Code	For Summary mode, the two-character Summary Statutory Code that resides in the Category Code informed in Processing Option 6. For Detailed mode, the four Statutory Code characters that reside in the Category Code Nbr indicated in the Correspondence Setup File (X0CCNB).
Currency Code	From Processing Option 6.
Name of the Account	The Name of the Account is retrieved from the Description 1 (DL01) of the UDC 09/nn, where nn is the Category Code Number entered in the Processing Option for Summary mode or, if the PO is left blank, the Category Code Number located in the Correspondence Setup File (X0CCNB).
Currency Code Description	The Description of the Currency Code is retrieved from the Description (DL01) of the Currency Code File (F0013).

17.6.2 Detail

Field	Explanation
Correspondence Account	For Summary mode, the two-character Summary Statutory Code that resides in the Category Code informed in Processing Option 7. For Detailed mode, the four Statutory Code characters that reside in the Category Code Nbr indicated in the Correspondence Setup File (X0CCNB).
Base Currency DR Offset	The added up debit amounts from F74R0912 File of the accounts with the Ledger Types indicated in Processing Option 3. It is the addition of the amounts in fields XBAN01 and XBAN14 only for those records within the period indicated in Processing Option 1.
Base Currency CR Offset	The added up credit amounts from F74R0912 File of the accounts with the Ledger Types indicated in Processing Option 3. It is the addition of the amounts in fields XBAN15 and XBAN28 only for those records within the period indicated in Processing Option 1.
Currency DR Offset	The added up debit amounts from F74R0912 File of the accounts with the Ledger Type CA. It is the addition of the amounts in fields XBAN01 and XBAN14, only for those records within the period indicated in Processing Option 1.
Currency CR Offset	The added up credit amounts from F74R0912 File of the accounts with the Ledger Type CA. It is the addition of the amounts in fields XBAN15 and XBAN28, only for those records within the period indicated in Processing Option 1.

17.6.3 Footer

Field	Explanation
Total Activity	The addition of the amounts in debit and credits columns.

17.6.4 Separate Final Page

Field	Explanation
Opening Balance	Retrieved from Correspondence Balance File corresponding to the period of the beginning date. The obtained amount is Debit Balance - Credit Balance. For Summary mode, the F74R0912 has several records and the system prints a sum of these amounts. For All Accounts calculate the opening net balance by adding up the appropriate period DR column - CR column from the balance file for that account. (XBAN15 - XBAN28) subtracted from (XBAN01 to AN014). The Bal.FWD is added only if the account is not a Profit & Loss account. If the net result is a positive amount and accounts is A, then print as positive and print literal as DR. If the net result is a positive amount and accounts is P, then print as negative and print literal as CR. If the net result is a positive amount and accounts is B, then print as positive and print literal as DR. If the net result is a negative amount and accounts is A, then print as negative and print literal as DR. If the net result is a negative amount and accounts is P, then print as positive and print literal as CR. If the net result is a negative amount and accounts is B, then print as positive and print literal as CR.
Total DR Movements	Aligned with the previous amount, the added amount of the Debit Amounts included in the detail. DR literal prints on the right side of the amount.
Total CR Movements	Aligned with the previous amount, the added amount of the Credit Amounts included in the detail. CR literal prints on the right side of the amount.
Closing Balance	For All Accounts calculate the closing net balance by adding up the appropriate period DR column - CR column from the balance file for that account. (XBAN15 - XBAN28) subtract from (XBAN01 to AN014). If the net result is a positive amount and accounts is A, then print as positive and print literal as DR. If the net result is a positive amount and accounts is P, then print as negative and print literal as CR. If the net result is a positive amount and accounts is B, then print as positive and print literal as DR. If the net result is a negative amount and accounts is A, then print as negative and print literal as DR. If the net result is a negative amount and accounts is P, then print as positive and print literal as CR. If the net result is a negative amount and accounts is B, then print as positive and print literal as CR.