Reconciliation for Accountants

Accountants, such as a revenue specialist, can use several reports to understand the details of FI documents created in revenue posting runs and to identify differences between Revenue Accounting and the general ledger.

Report A

Item	Details
Report name	FI Documents and Revenue Accounting Contracts
Intended users	Accountants
Selection criteria	Company code (required): You can select only one company code. Fiscal year and period (required): You can run this report for only one period at a time. Accounting principle (required): You can select only one company code. Revenue reconciliation key: You can run this report against data that is associated with specific revenue reconciliation keys. Revenue reconciliation keys are part of the technical implementation of the Revenue Accounting system. For more information, see the Revenue Reconciliation Keys section. G/L document: You can run this report against data that is associated with specific G/L documents. G/L account: You can run this report against data that is associated with specific G/L accounts. Revenue accounting contract: You can run this report against data that is associated with specific revenue accounting contracts. Posting category: You can use this option to select posted items that relate to a certain category, such as Revenue Adjustment.
Comparison for reconciliation	Typically, the accountant uses this report to display posting details instead of identifying differences. This report displays the corresponding line items in the posted FI documents. The accountant can see which contracts are included in this posting and which performance obligations are included in each contract. A total line is displayed that indicates the value of a G/L document line item that has been posted to a certain G/L account.
Indication of differences	No applicable
Reconciliation action	No applicable

Report B

Item	Details
Report name	Accounts Between Revenue Accounting and G/L
Intended users	Accountants
Selection criteria	Company code (required): You can select only one company code. Fiscal year and period (required): You can run this report for only one period at a time. Accounting principle (required): You can select only one company code. G/L account: You can perform reconciliation against data that is associated with specific G/L accounts. Has difference: You can select this option to only display items that have differences.
Comparison for reconciliation	This report compares the posted amounts by period between Revenue Accounting and the general ledger. If the amount posted by Revenue Accounting under the specific account differs from the amount actually posted in the general ledger, it is identified as a difference.
Indication of differences	The report result displays postings made to the revenue-related accounts. Items that have differences are indicated with a red traffic light. Items that do not have differences are indicated with a green traffic light.
Reconciliation action	This type of difference typically occurs because a user has made postings manually to the general ledger. You can check the posting history to identify the issue.

Example Example

The revenue-related accounts are determined as follows:

Revenue-Related Account	G/L Account
Account for Receivable Adjustment	300001 (Receivable Adjustment Service)
Account for Unbilled Revenue	300002 (Unbilled Revenue Service)
Account for Deferred Revenue	300003 (Deferred Revenue Service)

After the accountant has performed the revenue posting run for the period 2014001, the system transfers the following postings to the general ledger. In this case, the first two accounts have amounts but the third account has a zero amount.

G/L Account	Posted Amount in Revenue Accounting
300001 (Receivable Adjustment)	100
300002 (Unbilled Revenue)	200
300003 (Deferred Revenue)	0

The accountant then runs this reconciliation report and receives a result that resembles the following:

Period	G/L Account	Amount Posted by Revenue Accounting	Posted Amount in G/L	Difference
201401	300001 (Receivable Adjustment)	100	100	0
201401	300002 (Unbilled Revenue)	200	200	0
201401	300003 (Deferred Revenue)	0	50	-50

The report result indicates that Revenue Accounting does not post any amount to account 300003 (Deferred Revenue) but an amount of 50 is posted to the account. In this case, a difference of 50 occurs. This situation typically occurs because a user has made postings manually in the general ledger.

End of the example.