Word Real Estate Templates 30960 | Re 1 Leasesinleasesoutinternalexternal 0

Partial file snippet.

Sheet 1: Summary

	
	
	
	
	
	
	
	
	
	
	
		These posting schemas relates to Lease-IN (where the UN rents space). 
Also External and Internal Lease-Outs in Real Estate. External Lease-Outs are leases where the space is leased to a UN agency external to Umoja, or any other commercial entity. Internal Lease-Outs are leases where the space is leased to an entity internal to Umoja.
		

		

		

		

		

		

	
	
		

		

		

		

		

		

	
	
		

		

		

		

		

		

	
	
		

		

		

		

		

		

	
	
		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

	
	
		#
		Step Description
		Who (Provider/receiver of service)
		Doc Type
		Debit/Credit
		GL Acct
		GL Name
		R/S
		Amount
		Object
	
	
		1.1
		SES Acceprtance
		

		WE
		Dr
		74102010
		OE Infrastructure Service Rental of Premise
		R
		 1,000.00 
		CC, IO,WBSE
	
	
		

		

		

		WE
		Cr
		35401010
		GR/IR
		NA
		 (1,000.00)
		

	
	
		

		

		

		

		

		

		

		

		

		

	
	
		1.2
		Invoice
		

		RE
		Dr
		35401010
		GR/IR
		NA
		 1,000.00 
		

	
	
		

		

		

		RE
		Cr
		35101510
		AP Commercial Vendor
		NA
		 (1,000.00)
		

	
	
		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

	
	
		2
		Post Receivable RE-Lease OUT External 
		FA.05 Senior Approver GL AP AR CO
		RL
		Dr
		151XXXXX
		AR GL [BP customer]
		NA
		 1,000.00 
		

	
	
		

		

		

		RL
		Cr
		691XXXXX
		SP/NSP Revenue 
		S
		 (1,000.00)
		RE Contract
	
	
		

		

		

		RL
		Dr
		691XXXXX
		SP/NSP Revenue 
		S
		 1,000.00 
		RE Contract
	
	
		

		

		

		RL
		Cr
		691XXXXX
		SP/NSP Revenue 
		S
		 (1,000.00)
		RE Object
	
	
		

		

		

		

		

		

		

		

		

		

	
	
		2
		Post Receivable RE-Lease OUT INTERNAL
		FA.05 Senior Approver GL AP AR CO
		RL
		Dr
		7XXXXXXX
		Expense XXXX
		R
		 1,000.00 
		

	
	
		

		

		

		RL
		Cr
		691XXXXX
		SP/NSP Revenue 
		S
		 (1,000.00)
		RE Contract
	
	
		

		

		

		RL
		Dr
		691XXXXX
		SP/NSP Revenue 
		S
		 1,000.00 
		RE Contract
	
	
		

		

		

		RL
		Cr
		691XXXXX
		SP/NSP Revenue 
		S
		 (1,000.00)
		RE Object
	
	
		

		

		

		

		



Sheet 2: PS-RE.1 LEASE-IN

	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		PS-RE.1 Lease IN
		Financial Accounting
		Controlling
		Funds Management
		Grants Management
		
	
		Business Scenario
		

		Doc
 type
		Dr/Cr
		PK
		* GL Account 
		Description
		Amount
		Grant
		Commitment
 Item
		Fund**
		Obj Type
		Object
		Cost Element
		
		Ezra Agao:
In FM posting lines, budget consumption and FI debit entries will have a (-) sign. Decreases in budget consumption and FI credit entries will have a (+) sign

		Amount
		Value Type
		Amount Type
		Real/ Stat
		Commitment
 Item
		CI Name
		Real Estate Object
		Fund** 
		Funds
Center**
		Funded
 Program
		Amount
		Value Type
		Dr/Cr
		Real/
 Stat
		GL Account
		Commitment
 Item
		Grant 
		Sponsored Class
 IF Applicable
		Sponsored Program
 IF Applicable
	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		STEP 1: CREATE  REAL ESTATE OBJECTS
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		From a financial perspective for Lease IN (where the UN is the lessee) this step is informational for the Real Estate Obj is informational. No postings created. Note it can be linked to the PO (there is a field related to Real Estate Objects on the PO to derive the account assignment info).
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		STEP 2: Create the Shopping Cart
		

		

		

		

		

		

		

		

		

		

		

		

		 (1,000.00)
		50
		 0100 
		 R 
		74102010
		 OE Infrastructure Service Rental of Premise 
		 RO #XXXXX/XX 
		eg 10UNA
		12345
		FPNR
		

		

		

		

		

		

		

		

		

	
	
		

		The Real Estate object fields are entered on the SC
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		STEP 3: Create the PO
		

		

		

		

		

		

		

		

		

		

		

		

		 1,000.00 
		50
		 0200 
		 R 
		74102010
		 OE Infrastructure Service Rental of Premise 
		 RO #XXXXX/XX 
		eg 10UNA
		12345
		FPNR
		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		 (1,000.00)
		51
		 0100 
		 R 
		74102011
		 OE Infrastructure Service Rental of Premise 
		 RO #XXXXX/XX 
		eg 10UNA
		12345
		FPNR
		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		STEP 4: Create the Lease IN
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		No accounting effect. The SRM contract is entered into the General data tab. Same object referenced in the Purchase Order is attached on the Objects tab of the Lease-In automatically.
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		STEP 5: SES entered 
		WE
		Dr
		81
		74102010
		 OE Infrastructure Service Rental of Premise 
		 1,000.00 
		GMNR
		74102010
		eg 10UNA
		CTR
		12345
		74102010
		 1,000.00 
		51
		 0200 
		 R 
		74102010
		 OE Infrastructure Service Rental of Premise 
		 RO #XXXXX/XX 
		eg 10UNA
		12345
		FPNR
		

		

		

		

		

		

		

		

		

	
	
		

		Tcode ML81N
		WE
		Cr
		96
		35401010
		GR/IR
		 (1,000.00)
		GMNR
		35401010
		eg 10UNA
		BU
		RO #XXXXX/XX
		74102010
		 (1,000.00)
		54
		 0100 
		 R 
		74102010
		 OE Infrastructure Service Rental of Premise 
		 RO #XXXXX/XX 
		eg 10UNA
		12345
		FPNR
		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		STEP 6: Invoice receipt created
		RE
		Dr
		86
		35401010
		GR/IR
		 1,000.00 
		GMNR
		35401010
		eg 10UNA
		

		

		

		 1,000.00 
		51
		 0200 
		 R 
		74102010
		 OE Infrastructure Service Rental of Premise 
		 RO #XXXXX/XX 
		eg 10UNA
		12345
		FPNR
		 1,000.00 
		54
		Dr
		S
		35401010
		74102010
		GMNR
		

		

	
	
		

		Tcode MIR7
		RE
		Cr
		31
		33XXXXXX
		AP (Vendor BP)
		 (1,000.00)
		GMNR
		33XXXXXX
		eg 10UNA
		

		

		

		 (1,000.00)
		54
		 0100 
		 R 
		74102010
		 OE Infrastructure Service Rental of Premise 
		 RO #XXXXX/XX 
		eg 10UNA
		12345
		FPNR
		 (1,000.00)
		54
		Cr
		S
		33XXXXXX
		33XXXXXX
		GMNR
		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		STEP 7: Payment Document
		KZ
		Dr
		25
		33XXXXXX
		AP (Vendor BP)
		 1,000.00 
		GMNR
		33XXXXXX
		eg 10UNA
		

		

		

		 1,000.00 
		54
		 0200 
		 R 
		74102010
		 OE Infrastructure Service Rental of Premise 
		 RO #XXXXX/XX 
		eg 10UNA
		12345
		FPNR
		 1,000.00 
		54
		Dr
		S
		33XXXXXX
		74102010
		GMNR
		

		

	
	
		

		Tcode MIR7
		KZ
		Cr
		50
		11XXXX14
		Cash CUR XXXXEFT AP
		 (1,000.00)
		GMNR
		11XXXX14
		64QVA
		

		

		

		 (1,000.00)
		57
		 0250 
		 R 
		74102010
		 OE Infrastructure Service Rental of Premise 
		 RO #XXXXX/XX 
		eg 10UNA
		12345
		FPNR
		 (1,000.00)
		Y2
		Cr
		S
		11XXXX14
		11XXXX14
		GMNR
		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		 1,000.00 
		57
		 0250 
		 R 
		74102010
		 OE Infrastructure Service Rental of Premise 
		 RO #XXXXX/XX 
		eg 10UNA
		12345
		FPNR
		

		

		

		

		

		

		

		

		

	
	
		

		

		ZZ
		Dr
		40
		11701010
		Csh MAIN Pool
		 1,000.00 
		GMNR
		11001000
		64VQA
		

		

		

		

		

		

		

		

		

		

		

		

		

		 1,000.00 
		Z1
		Dr
		S
		11701010
		

		GMNR
		

		

	
	
		

		

		ZZ
		Cr
		50
		11701010
		Csh MAIN Pool
		 (1,000.00)
		GMNR
		11001000
		eg 10UNA
		

		

		

		

		

		

		

		

		

		

		

		

		

		 (1,000.00)
		Z1
		Cr
		S
		11701010
		

		GMNR
		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	



Sheet 3: PS-RE.2 LEASE-OUT (EXT)

	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		PS-RE.2 Lease OUT (External).
		Financial Accounting
		Controlling
		Funds Management
		Grants Management
		
	
		

		The Lesee is NOT an entity within the UN-Sec using Umoja
		Doc
 type
		Dr/Cr
		PK
		* GL Account 
		Description
		Real Estate Key
		Amount
		Grant
		Commitment
 Item
		Fund**
		Obj Type
		Object
		Cost Element
		
		Ezra Agao:
In FM posting lines, budget consumption and FI debit entries will have a (-) sign. Decreases in budget consumption and FI credit entries will have a (+) sign

		Amount
		Value Type
		Amount Type
		Real/ Stat
		Commitment
 Item
		CI Name
		Fund** 
		Funds
Center**
		Funded
 Program
		Amount
		Value Type
		Dr/Cr
		Real/
 Stat
		GL Account
		Commitment
 Item
		Grant 
		Sponsored Class
 IF Applicable
		Sponsored Program
 IF Applicable
	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		STEP 1: CREATE the LEASE CONTRACT (RE.03 Lease Creator)
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		The contract will have the dates, the frequency of billing, the amounts, the house bank for the lessor, the BP of the lessee. Note: The information for the revenue posting is coming from the RE-Object (Posting Parameters), not the contract. This is saved and goes to workflow.
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		STEP 2: Contract Approval (RE.04-Contract Approver), approve or reject 
		

		

		

		

		

		

		

		

		

		

		

		

		

		 Note there is no forecast of revenue postings for Lease-Out External 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Note: this is approved through workflow
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		STEP 3: Post invoice for particular period (FA.05 Financial Senior User GL AP AR CO)
		RL
		Dr
		01
		151XXXXX
		AR GL [BP customer] Note 5.
		

		 1,000.00 
		GMNR
		151XXXXX
		

		

		

		

		

		

		

		

		

		

		

		

		

		 1,000.00 
		55
		Dr
		S
		151XXXXX
		151XXXXX
		GMNR (note 4.)
		

		

	
	
		

		

		RL
		Cr
		50
		691XXXXX
		SP/NSP Revenue Note 1
		REC 1000/200000123 (note 3)
		 (1,000.00)
		GMNR
		691XXXXXS
		From RE-Obj Note 2
		REC
		REC #Contract
		691XXXXX
		 (1,000.00)
		54
		 0100 
		 S 
		691XXXXXS
		 SP/NSP Revenue Note 1 
		From RE-Obj Note 2
		From RE-Obj Note 2
		From Fund Center
		 (1,000.00)
		Y7
		Cr
		S
		691XXXXX
		691XXXXXS
		GMNR (note 4.)
		

		

	
	
		

		Tcode RERAPP. Note the notificaiton to the FA.05 user is manual, usually sent in an email etc. They will also notify the FA.05 what period to bill.


		RL
		Dr
		40
		691XXXXX
		SP/NSP Revenue Note 1
		REC 1000/200000123 (note 3)
		 1,000.00 
		GMNR
		691XXXXXS
		From RE-Obj Note 3
		REC
		REC #Contract
		691XXXXX
		 1,000.00 
		54
		 0100 
		 S 
		691XXXXXS
		 SP/NSP Revenue Note 1 
		From RE-Obj Note 3
		From RE-Obj Note 3
		From Fund Center
		 1,000.00 
		Y7
		Cr
		S
		691XXXXX
		691XXXXXS
		GMNR (note 4.)
		

		

	
	
		

		RL
		Cr
		50
		691XXXXX
		SP/NSP Revenue Note 1
		RO 1000/200123/01 (note 3)
		 (1,000.00)
		GMNR
		691XXXXXS
		From RE-Obj Note 4
		RO
		RO #XXXXX/XX
		691XXXXX
		 (1,000.00)
		54
		 0100 
		 S 
		691XXXXXS
		 SP/NSP Revenue Note 1 
		From RE-Obj Note 4
		From RE-Obj Note 4
		From Fund Center
		 (1,000.00)
		Y7
		Cr
		S
		691XXXXX
		691XXXXXS
		GMNR (note 4.)
		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		STEP 4: Creation of an invoice number/document for vendor (FA.05 Financial Senior User GL AP AR CO)
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Tcode RERAIV. This is done to link the accounting document in 3. with an invoice number and to create a PDF to send to the vendor.
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Note 1: the revenue GL used depends on the Condition selected in the contract (these conditions relate to Flow types and the Flow types are mapped in config to GLs, See list in tab)

Note 2: All RE-Objects have assessed funds/fund center on them (Posting Parameters>Organisation Assignment), as the base rent collected on lease space is NSP and needs to be returned to MS. If any part of the revenue however relates to things that we dont need to return then that is SP. There is an FM Derivation rule set up so that if the GL is SP it will look up the fund then change the revenue fund to another i.e. from 10UNA to 10RCR or 10ICR to 10UNA (see list attached).

Note 3: As this is a transfer posting the system posts and debit and credit to the RE Contract then a Credit to the RE-Object.

Note 4: No revenue should be coming to a grant via rental income. Entities instructed not to do this.

Note 5: The BP is populated based in the BP number of the vendor on the RE-Contract (Partner tab).

The words contained in this file might help you see if this file matches what you are looking for:

...Sheet summary these posting schemas relates to leasein where the un rents space also external and internal leaseouts in real estate are leases is leased a agency umoja or any other commercial entity an step description who providerreceiver of service doc type debitcredit gl acct name rs amount object ses acceprtance we dr oe infrastructure rental premise r cc io wbse cr grir na invoice re ap vendor post receivable release out fa senior approver ar co rl xxxxx spnsp revenue s contract xxxxxxx expense xxxx psre lease financial accounting controlling funds management grants business scenario drcr pk account grant commitment item fund obj cost element ezra agao fm lines budget consumption fi debit entries will have sign decreases credit value stat ci fundscenter funded program sponsored class if applicable create objects from perspective for lessee this informational no postings created note it can be linked po there field related on derive assignment info shopping cart ro eg una fpnr fiel...

Related files

Share

Help

These posting schemas relates to Lease-IN (where the UN rents space). Also External and Internal Lease-Outs in Real Estate. External Lease-Outs are leases where the space is leased to a UN agency external to Umoja, or any other commercial entity. Internal Lease-Outs are leases where the space is leased to an entity internal to Umoja.








#	Step Description	Who (Provider/receiver of service)	Doc Type	Debit/Credit	GL Acct	GL Name	R/S	Amount	Object
1.1	SES Acceprtance		WE	Dr	74102010	OE Infrastructure Service Rental of Premise	R	1,000.00	CC, IO,WBSE
			WE	Cr	35401010	GR/IR	NA	(1,000.00)

1.2	Invoice		RE	Dr	35401010	GR/IR	NA	1,000.00
			RE	Cr	35101510	AP Commercial Vendor	NA	(1,000.00)


2	Post Receivable RE-Lease OUT External	FA.05 Senior Approver GL AP AR CO	RL	Dr	151XXXXX	AR GL [BP customer]	NA	1,000.00
			RL	Cr	691XXXXX	SP/NSP Revenue	S	(1,000.00)	RE Contract
			RL	Dr	691XXXXX	SP/NSP Revenue	S	1,000.00	RE Contract
			RL	Cr	691XXXXX	SP/NSP Revenue	S	(1,000.00)	RE Object

2	Post Receivable RE-Lease OUT INTERNAL	FA.05 Senior Approver GL AP AR CO	RL	Dr	7XXXXXXX	Expense XXXX	R	1,000.00
			RL	Cr	691XXXXX	SP/NSP Revenue	S	(1,000.00)	RE Contract
			RL	Dr	691XXXXX	SP/NSP Revenue	S	1,000.00	RE Contract
			RL	Cr	691XXXXX	SP/NSP Revenue	S	(1,000.00)	RE Object

Related files

Share

Share to social media

Help

Login Area