Sales Report/Statement of Revenue 

Displaying a Sales Reports/Statement of Revenue

Use

In this section you will display the revenue reports of all of the lease-outs adjusted by the sales settlement method in Business Entity 100.

Procedure

  1. Call up the transaction as follows:

Menu Path

Accounting ® Real Estate Management ® Rental accounting ® Sales-based rents ® Sales reports ® Display

Transaction Code

FOU3N

  1. Enter the following data:

Field

Data

Company code

3000

Sales year

2000

Other selection criteria

[Delete all other defaulted selections]

  1. Choose .

The sales report screen is divided in to two areas. The navigation area on the left side and the detail area on the right. The navigational area displays all lease-out and corresponding object hierarchy per condition type.

  1. In the navigation area of the screen click on couple of lease-out to display the corresponding detail information on the detail area part of the screen.
  2. Choose until the overview tree appears.

Creating a Sales Report/Statement of Revenue for your Lease-out

Use

For your lease-out, you stipulated that the tenant has to submit monthly sales reports. Now you will enter these sales reports in the system.

Procedure

  1. Call up the transaction as follows:

Menu Path

Accounting ® Real Estate Management ® Rental accounting ® Sales-based rents ® Sales reports ® Maintain with sales simulation

Transaction Code

FOU3NS

  1. Enter the following data:

Field

Data

Company code

3000

Lease-out

[The number of your lease-out]

Report from

01/01/2000 [January 1, 2000]

Report to

06/30/2000 [June 30, 2000]

Sales year

2000

Other selection criteria

[Delete all other defaulted selections]

  1. Choose .

The sales report screen with simulation is divided into three areas. The navigation area on the left side, the detail area on the right, and the simulation area on the bottom. The navigation area displays your lease-out and corresponding object hierarchy per condition type. The red traffic lights indicate that sales data has not yet been entered.

  1. Place your cursor on condition 0040 Sls bsd rent AP 1 in the detail area and choose Intervals.
  2. Enter the following data:

Report from

Report to

Sales in units

01/01/2000

01/31/2000

100,000

02/01/2000

02/29/2000

80,000

03/01/2000

03/31/2000

70,000

04/01/2000

04/30/2000

60,000

05/01/2000

05/31/2000

50,000

06/01/2000

06/30/2000

40,000

  1. Choose Transfer.

The traffic lights change to yellow, which means that sales data has been entered but has not yet been saved. Please note the calculation which took place for this condition in the simulation area of the screen.

  1. In the detail area of the screen place your cursor on condition 0041 Sls bsd rent AP 2 and choose Intervals.
  2. Enter the following data:

Report from

Report to

Sales in units

01/01/2000

01/31/2000

15,000

02/01/2000

02/29/2000

10,000

03/01/2000

03/31/2000

15,000

04/01/2000

04/30/2000

10,000

05/01/2000

05/31/2000

20,000

06/01/2000

06/30/2000

10,000

  1. Choose Transfer.
  2. In the simulation area of the screen you can see the two condition types. Per condition type you can see the amount of units sold which have been taken into account for this calculation (Rel.sales column), the amount of advance payments which the tenant paid over this period (Amount AP column), and the balance calculated including tax for each condition (Bal.inc.VAT column). The totals for the whole lease-in are summarized where appropriate in the yellow column.

  3. Choose .
  4. Choose until the overview tree appears.