How to Configure the Sublease Receivable Posting Setup

Table of Contents

For maturity analysis disclosures, the receivable needs to be split across different G/L accounts based on how soon it is due.

Sublease Receivable Posting Setup is where you define which G/L account the system should use for each time band and lease category. Once it is set up, the system automatically keeps the correct amounts in the correct accounts each time sublease postings are run, so no manual reclassification is needed.

It can be turned on in Lease Setup under Accounting Settings via "Split By Receivable Posting Setup"
 

Make sure the G/L accounts you want to split the receivable into already exist (one per maturity band you want to track). This is set up per lease category, so if different categories of subleases need different account splits, set each one up separately. See steps below.

  1. Open the Sublease Receivable Posting Setup list.
  2. For each lease category you sublease under, add one line per time band you want to report on. Example:

Maturity Band

Maturity Band is a date formula marking where that band ends (e.g., 1Y for "everything due within the next year").

 
  1. Make sure your bands are entered in increasing order and cover the full expected term of the subleases in that category. Otherwise, some of the receivable won't have anywhere to go.

Once this is set up, each time sublease receivable postings are run, the system calculates how much of the total receivable balance falls due within each time band and moves the amounts between the relevant G/L accounts accordingly. This ensures that your trial balance reflects an accurate and up-to-date maturity split.