3614985 - Balance on Clearing Lease Liabilities Account in G/L Account Line Items Report

• In the G/L Account Line Items report, a balance of amount ZZZ remains on the Clearing Lease Liabilities account YYY.
• This resulted from an invoice posting of amount ABC referencing Lease Contract XYZ, which had an amount PQR. 
• This creates a balance in the clearing account and the lease contract is closed now. 
• Note: 'ZZZ' refers to the balance amount, 'YYY' refers to the G/L Account Clearing Lease Liabilities, 'ABC' refers to the invoice amount, 'XYZ' refers to the Lease Contract ID, and 'PQR' refers to lease installment value.

SAP Business ByDesign

1. Go to the General Ledger work center.
2. Go to the Reports view.
3. Search for and open the report G/L Accounts - Line Item.
4. Enter the Company ID, Set of Books ID and select Apply.
5. Add Balance Company Currency column field.
6. There is a balance of ZZZ in the G/L account Clearing Lease Liabilities. Clarification is required on how this balance can be cleared. 

• The issue is because of rounding differences occurred while the calculations happening separately because of discount amounts provided.
• Consider the following example which describes the situation:

One of the line items in the supplier invoice is related to the lease contract XYZ.

Net amount for this line item = 359.95 EUR

Discounts = 1.53 EUR

Effective Net amount = 359.95 – 1.53 = 358.42 EUR

Tax percentage = 20 %

Tax amount for Net base amount (i.e., 358.42 EUR) = 71.58 EUR

Tax amount for Discounts (i.e., 1.53 EUR) = 0.31 EUR

Overall Net amount (i.e., Including Tax) = 358.42 + 71.58 = 430 EUR

Overall Discount (i.e., including Tax) = 1.53 + 0.31 = 1.84 EUR

Gross amount = Overall Net + Overall Discount = 430 + 1.84 = 431.84 EUR

Based on above calculation, the supplier invoice has posted into accounting with the amount 431.84 EUR whereas the lease installment value is 431.94 which was cleared through lease posting clearing run. There is a 0.10 EUR difference found in the supplier invoice journal entry against to the Lease clearing posting journal entry for the lease contract XYZ in the report.

A manual journal entry voucher of type 00047 - Manual Posting - Journal Entry Voucher has to be posted to get the balance value adjusted with the GL Account YYY.

3570659 - Initial Cost Not Posted to Expense account for Lease Contract with Expense Set of Books Relevance

Lease contracts, clearing balance, G/L account, Clearing Lease Liabilities. , KBA , AP-ACC-LM , Accounting Lease Management , How To