Posting Check

Report Run:

There has been an addition of a new report that can be ran from Reporting section to accumulate any outstanding issues that would be with the leases:

Report side has 2 dates: Check from date and Check Until date:

If Check From date is not entered - within Lease Setup under Admin there is a new field for “Check Cut-off Date” which can be used to “skip” previous years issues that were fixed with manual entries

Any issues that would appear would be in Posting Check error list.

Currently checked error are:

Lease side:

  • Lease Status is "New" but there are leftover balances
  • Lease Category %1 does not exist
  • "Activation Posting on G/L" missing but marked in the Liability Schedule
  • "Activation Posting on G/L" but nothing marked in the Liability Schedule
  • "Activation Posting on G/L" happened multiple times without reversal
  • Monthly Posting on G/L are missing but marked in the Liability Schedule
  • Monthly Posting on G/L are missing but marked in the RoU Schedule
  • Monthly Posting on G/L are missing but marked in the Payment Schedule
  • Monthly Posting on G/L posted but not marked in the Liability Schedule
  • Monthly Posting on G/L posted but not marked in the RoU Schedule
  • Monthly Posting on G/L posted but not marked in the Payment Schedule
  • Payment posted but no line exists on the Payment Schedule
  • The Payment schedule does not match the amount on the Lease Liability Schedule
  • Termination entries are posted, but the Lease Status is Active
  • Expiration entries are posted, but the Lease Status is Active
  • A lease is marked as "Terminated" but no entries are created
  • A lease is marked as "Expired" but no entries are created
  • Lease Status is Terminated/Expired, but no "Actual Termination Date" is filled. Possible manual move
  • Lease Status is Active/Extended, but "Actual Termination Date" is filled. Possible manual move

Sublease Side:

  • Sub-lease Status is Terminated/Expired, but no "Actual Termination Date" is filled. Possible manual move
  • Sub-lease Status is Active/Extended, but "Actual Termination Date" is filled. Possible manual move
  • Sub-Lease marked as "Terminated" but no entries are created
  • Termination entries are posted, but Lease Status is Active
  • Instalment is posted, but no line exists on the Instalment Schedule
  • The Instalment schedule does not match the amount on the Sub-Lease Receivable Schedule
  • The Sub-Lease Status is "New" but there are leftover balances
  • "Activation Posting on G/L" is missing but marked in the Receivable Schedule
  • "Activation Posting on G/L" but nothing is marked in the Receivable Schedule
  • "Activation Posting on G/L" happened multiple times without reversal
  • Monthly Posting on G/L is missing, but marked in the Receivable Schedule
  • Monthly Posting on G/L is missing, but marked in the Instalment Schedule
  • Monthly Posting on G/L is posted, but not marked in the Receivable Schedule
  • Monthly Posting on G/L is posted, but not marked in the Instalment Schedule

Monthly check:

This report can also be turned on so that it runs each month in the Lease Setup under Admin via “Run Posting Check after Monthly” after your “Post to G/L” monthly process. There is no requirement to run it monthly, as it may increase the month-end posting time. However, for companies with a small number of leases, it is recommended, as it helps detect any errors in advance.

The report in both cases is just a compiler of problems

When run manually or after the month-end process, the report only collects issues. It does not resolve them. It is a useful tool for compiling existing lease-related issues, reducing the manual effort needed to identify the source of double bookings or mismatches between schedules and G/L entries.

The report does not check for amount differences. It only checks the entries.