Fullscreen Image

Triggering the Recalc? Flag

Certain events will flip the Recalc? flag on a lease accounting schedule from No to Yes. When this happens, you will need to recalculate your lease accounting schedule.

ClosedReport On User Who Triggered Recalc? Flag

If you want to include data about the user (or users) to caused the Recalc? flag to be triggered in a report, add the following fields to your report:

  • Needs Recalc Modified by Member List (SLSummary.NeedsRecalcModifiedByMemberIDList): this field lists all members who have made changes that would cause the Recalc? flag to change

  • Needs Recalc Modified by Last Member (SLSummary.NeedsRecalcModifiedByLastMember): this field lists the last member whose action would have caused the Recalc? flag to change

As with most member fields, you can also use these fields to filter by a foreign key. This means that you can apply a filter to these fields to pull related member data into your report.

ClosedReal Estate Contracts

The following sections explain the events and field changes which trigger the Recalc? flag for a real estate contract.

ClosedEvents Which Trigger the Recalc? Flag

The following events will flip the Recalc? flag to Yes on a real estate contract:

  • Adding or Deleting an Accounting Assumption Adjustment

    • Impacts: ASC 842, IFRS 16, GASB 87

    • Notes: Adding or deleting an accounting assumption adjustment will cause rent schedules associated with its configured ASC 842, IFRS 16, or GASB 87 schedule IDs to be flagged as needing recalculation.

  • Adding or Deleting an Alternate Rent Schedule

  • Adding or Deleting a Covenant

    • Impacts: ASC 842, IFRS 16, GASB 87

    • Notes: Adding or deleting a covenant will cause rent schedules associated with its configured ASC 842, IFRS 16, or GASB 87 schedule IDs to be flagged as needing recalculation.

  • Adding or Deleting an Expense Schedule

    • Impacts: ASC 840, ASC 842, IFRS 16, GASB 87

  • CPI Retro Payment Adjustments

    • Impacts: IFRS 16, GASB 87

    • Notes: If there is a retro payment adjustment to a rent expense schedule due to a CPI-indexed increase, the associated IFRS 16 or GASB 87 schedule will be flagged as needing recalculation.

      Important!

      CPI retro payment adjustments do not flag ASC 842 schedules as needing recalculation.

  • Deleting a CPI Expense Schedule

  • Editing an Existing ASC 842 Test and then Locking It

    • Impacts: ASC 842

    • Notes: Locking a test does not trigger the Recalc? flag. The flag is only triggered if changes are also made.

  • Extending a Contract Using the Extend Contracts Wizard

    • Impacts: ASC 842, IFRS 16, GASB 87

      This only triggers the Recalc? flag if there is a currently active schedule on the contract.

      Important!

      As of 21.06, the Recalc? flag is triggered in the following circumstances:

      • If a contract is NOT month-to-month

      • If a contract is month-to-month AND the extension is greater than or equal to 1 year.

    • Notes: To learn how to extend a contract using the Extend Contracts Wizard, follow the Extend Contracts procedures.

ClosedField Changes Which Trigger the Recalc? Flag

Additionally, changes to the fields in the following tables will flip the Recalc? flag to Yes on a real estate contract. Expand the sections below to learn more about which fields impact the Recalc? flag, and on which pages these fields usually appear.

ClosedAcctingAssumptionAdjust Table

The AcctingAssumptionAdjust table contains fields which appear on the Contract > Accounting Info > Accounting Assumptions page, in the Accounting Assumption Adjustments table.

Default UI Label

Database Table - Field Name

Straight Line /

ASC 840

ASC 842

IFRS 16

GASB 87

ASC 842 Schedule

AcctingAssumptionAdjust.CodeASC842ScheduleID

 

x

 

 

IFRS 16 Schedule

AcctingAssumptionAdjust.CodeIFRS16ScheduleID

 

 

x

x

Begin Date

AcctingAssumptionAdjust.BeginDate

 

x

x

x

End Date

AcctingAssumptionAdjust.EndDate

 

x

x

x

First Payment Amount

AcctingAssumptionAdjust.FirstPaymentAmount

 

x

x

x

Frequency

AcctingAssumptionAdjust.CodeFrequencyID

 

x

x

x

Last Payment Amount

AcctingAssumptionAdjust.LastPaymentAmount

 

x

x

x

Payment Amount

AcctingAssumptionAdjust.PaymentAmount

 

x

x

x

Secondary Rent Schedule Allocation Percent

AcctingAssumptionAdjust.SecondaryRentSchedAllocPercent

 

x

x

x

Proration Method

AcctingAssumptionAdjust.CodeProrationMethodID

 

x

x

x

ClosedAlternateRentSchedule Table

The AlternateRentSchedule table contains fields which appear on the Contract > Payment Info > Alternate Rent page.

Default UI Label

Database Table - Field Name

Straight Line /

ASC 840

ASC 842

IFRS 16

GASB 87
Begin Date AlternateRentSchedule.BeginDate  

x

x

x
End Date AlternateRentSchedule.EndDate  

x

x

x
Expense Reduction Amount AlternateRentSchedule.ExpenseReductionAmount  

x

x

x
Expense Reduction Percent AlternateRentSchedule.ExpenseReductionPercent  

x

x

x
Set Payments for Recurring Expenses On Hold AlternateRentSchedule.SetExpHoldFlag  

x

x

x

ClosedContract Table

The Contract table contains fields which appear on the Contract > Details > Summary page.

Default UI Label

Database Table - Field Name

Straight Line /

ASC 840

ASC 842

IFRS 16

GASB 87

Currency Type

Contract.CodeCurrencyTypeID

 

x

x

x

Expiration Date

Contract.ExpireDate

 

x

x

x

Payment End Date

Contract.PaymentEndDate

 

x

x

x

ClosedContractFinancialTest Table

The ContractFinancialTest table contains fields which appear on the Contract > Accounting Info > Accounting Assumptions pages, the Contract > Accounting Info > ASC 842 Rent Schedule page, and the Contract > Accounting Info > IFRS 16 Rent Schedule page.

Note:

When changes to these fields are made on the Accounting Assumptions page, the Recalc? flag is flipped to Yes.

Default UI Label

 Database Table - Field Name

Straight Line /

ASC 840

ASC 842

IFRS 16

GASB 87

Accounting Begin Date

ContractFinancialTest.Topic842BeginDate

 

x

x

x

Accounting End Date

ContractFinancialTest.Topic842EndDate

 

x

x

x

Discount Rate

ContractFinancialTest.DiscountRate

 

x

x

x

PV Of Other Adjustments

ContractFinancialTest.PVOfOtherAdjustments

 

x

x

x

PV Of Structuring Costs

ContractFinancialTest.PVOfStructuringCosts

 

x

x

x

ASC 842 Schedule

ContractFinancialTest.CodeASC842ScheduleID

 

x

 

 

IFRS 16 Schedule

ContractFinancialTest.CodeIFRS16ScheduleID

 

 

x

x

Dismantling / Restoring Costs

ContractFinancialTest.DismantlingStorageCostAmount

 

 

x

x

Impairments

ContractFinancialTest.ImpairmentsAmount

 

x

x

x

Initial Direct Costs

ContractFinancialTest.InitialDirectCostsAmount

 

x

x

x

Lease Incentive Amount

ContractFinancialTest.LeaseIncentivesAmount

 

x

x

x

Payments Before Commencement (Less Incentives)

ContractFinancialTest.PreCommencePayAmount

 

x

x

x

ClosedContractTerm Table

The ContractTerm table contains fields which primarily appear on the Contract > Abstract Info > Terms page.

Important!

The Recalc? flag may or may not be triggered, depending on what value you are changing the Term Status to. See the second table to learn when the Recalc? flag is triggered.

Default UI Label

Database Table - Field Name

Straight Line /

ASC 840

ASC 842

IFRS 16

GASB 87

Status

ContractTerm.CodeTermStatusID

x

x

x

x

In the table below, cells marked with an x are circumstances when the Recalc? flag is triggered. Blank cells are circumstances when the Recalc? flag is not triggered. N/A appears in cells where the cell describes a scenario with no change, for example Active to Active.

From / To Blank / Empty Active Available Declined Exercised Expired Likely

Blank / Empty

N/A

x

 

 

x

 

x

Active

x

N/A

x

x

 

 

 

Available

 

x

N/A

 

x

 

x

Declined

 

x

 

N/A

x

 

x

Exercised

x

 

x

x

N/A

x

 

Expired

 

x

 

 

x

N/A

x

Likely

x

 

x

x

 

x

N/A

ClosedCovenant Table

The Covenant table contains fields which primarily appear on the Contract > Abstract Info > Covenants page.

Default UI Label

Database Table - Field Name

Straight Line /

ASC 840

ASC 842

IFRS 16

GASB 87

Accounting Adjustment Type

Covenant.CodeAccountingAdjustmentTypeID

 

x

x

x

ASC 842 Schedule

Covenant.CodeASC842ScheduleID

 

x

 

 

IFRS 16 Schedule

Covenant.CodeIFRS16ScheduleID

 

 

x

x
Currency Covenant.CodeCurrencyTypeID   x x x

Financial Amt

Covenant.CovenantAmount

 

x

x

x

Effective Date

Covenant.CovenantDate

 

x

x

x

Secondary Schedule Allocation

Covenant.SecondaryRentSchedAllocPercent

 

x

x

x

ClosedExpenseSchedule Table

The ExpenseSchedule table contains fields which primarily appear on the Contract > Payment Info > Recurring Expenses page, but appear in the Expense Schedule / Escalations section of the page, or the Expense Schedule Wizard.

Default UI Label

Database Table - Field Name

Straight Line /

ASC 840

ASC 842

IFRS 16

GASB 87

Annual Amount

ExpenseSchedule.AnnualAmount

x

x

x

x

Begin Date

ExpenseSchedule.BeginDate

x

x

x

x

End Date

ExpenseSchedule.EndDate

x

x

x

x

First Payment Amount

ExpenseSchedule.FirstPaymentAmount

x

x

x

x

Last Payment Amount

ExpenseSchedule.LastPaymentAmount

x

x

x

x

Payment Amount

ExpenseSchedule.PaymentAmount

x

x

x

x

Payment Rate

ExpenseSchedule.PaymentRate

x

x

x

x

is CPI?

ExpenseSchedule.IsCPI

 

 

x

x

ClosedExpenseSetup Table

The ExpenseSetup table contains fields which primarily appear on the Contract > Payment Info > Recurring Expenses page.

Default UI Label

Database Table - Field Name

Straight Line /

ASC 840

ASC 842

IFRS 16

GASB 87

Secondary Rent Schedule Allocation Amount

ExpenseSetup.SecondaryRentSchedAllocAmount

 

x

x

x

Secondary Rent Schedule Allocation Percent

ExpenseSetup.SecondaryRentSchedAllocPercent

  

x

x

x

Currency Type

ExpenseSetup.CodeCurrencyTypeID

 

x

x

x

CPI Index

ExpenseSetup.CodeCPIIndexID

   

x

x

Pay in Arrears?

ExpenseSetup.IsPayArrears

 

x

x

x

Payment Due Day

ExpenseSetup.PaymentDueDay

 

x

x

x

Proration Method

ExpenseSetup.CodeProrationMethodID

 

x

x

x

ClosedEquipment Contracts

The following sections explain the events and field changes which trigger the Recalc? flag for an equipment contract.

ClosedEvents Which Trigger the Recalc? Flag

The following events will flip the Recalc? flag to Yes on an equipment contract:

  • Adding or Deleting an Expense Schedule

    • Impacts: ASC 840, ASC 842, IFRS 16, GASB 87

  • Adding or Deleting a Covenant

    • Impacts: ASC 842, IFRS 16, GASB 87

    • Notes: Adding or deleting a covenant will cause rent schedules associated with its configured ASC 842, IFRS 16, or GASB 87 schedule IDs to be flagged as needing recalculation.

  • Adding or Deleting an Accounting Assumption Adjustment

    • Impacts: ASC 842, IFRS 16, GASB 87

    • Notes: Adding or deleting an accounting assumption adjustment will cause rent schedules associated with its configured ASC 842, IFRS 16, or GASB 87 schedule IDs to be flagged as needing recalculation.

      Important!

      If an adjustment is applied to the contract, it will flip the Recalc? flag for both the contract and the asset. If the adjustment is applied to the asset, it will only flip the Recalc? flag of the asset.

  • Editing an Existing ASC 842 Test and then Locking It

    • Impacts: ASC 842

    • Notes: Locking a test does not trigger the Recalc? flag. The flag is only triggered if changes are also made.

  • Extending an Equipment Contract Using the Extend Contracts Wizard

    • Impacts: ASC 842, IFRS 16, GASB 87

      This only triggers the Recalc? flag if there is a currently active schedule on the contract.

      Important!

      As of 21.06, the Recalc? flag is triggered in the following circumstances:

      • If a contract is NOT month-to-month

      • If a contract is month-to-month AND the extension is greater than or equal to 1 year.

    • Notes: To learn how to extend an equipment contract using the Extend Contracts Wizard, follow the Extend Contracts procedures.

ClosedField Changes Which Trigger the Recalc? Flag - Contract-Level

Changes to the fields in the following tables will flip the Recalc? flag to Yes on an equipment contract. Expand the sections below to learn more about which fields impact the Recalc? flag, and on which pages these fields usually appear.

Note:

These fields flip the Recalc? flag to Yes at the contract-level. See the section below for asset-level triggers.

ClosedAcctingAssumptionAdjust Table

The AcctingAssumptionAdjust table contains fields which appear on the Equipment Contract > Accounting Info > Accounting Assumptions pages, in the Accounting Assumption Adjustments table.

Default UI Label

Database Table - Field Name

Straight Line /

ASC 840

ASC 842

IFRS 16

GASB 87

ASC 842 Schedule

AcctingAssumptionAdjust.CodeASC842ScheduleID

  

x

 

 

IFRS 16 Schedule

AcctingAssumptionAdjust.CodeIFRS16ScheduleID

 

 

x

x

Begin Date

AcctingAssumptionAdjust.BeginDate

 

x

x

x

End Date

AcctingAssumptionAdjust.EndDate

 

x

x

x

First Payment Amount

AcctingAssumptionAdjust.FirstPaymentAmount

 

x

x

x

Frequency

AcctingAssumptionAdjust.CodeFrequencyID

 

x

x

x

Last Payment Amount

AcctingAssumptionAdjust.LastPaymentAmount

 

x

x

x

Payment Amount

AcctingAssumptionAdjust.PaymentAmount

 

x

x

x

Secondary Rent Schedule Allocation Percent

AcctingAssumptionAdjust.SecondaryRentSchedAllocPercent

 

x

x

x

Proration Method

AcctingAssumptionAdjust.CodeProrationMethodID

 

x

x

x

ClosedContract Table

The Contract table contains fields which appear on the Equipment Contract > Details > Summary page.

Default UI Label

Database Table - Field Name

Straight Line /

ASC 840

ASC 842

IFRS 16

GASB 87
Expire Date

Contract.ExpireDate

x

x

x

x
Payments End Date

Contract.PaymentsEndDate

x

x

x

x

ClosedContractFinancialTest Table

The ContractFinancialTest table contains fields which appear on the following pages:

  • Equipment Contract > Accounting Info > Accounting Assumptions

  • Equipment Contract > Accounting Info > ASC 842 Rent Schedule

  • Equipment Contract > Accounting Info > ASC 842 Rent Schedule > ASC 842 Equipment Schedules

  • Equipment Contract > Accounting Info > IFRS 16 Rent Schedule

  • Equipment Contract > Accounting Info > IFRS 16 Rent Schedule > IFRS 16 Equipment Schedules

  • Equipment Contract > Accounting Info > GASB 87 Rent Schedule

  • Equipment Contract > Accounting Info > GASB 87 Rent Schedule > GASB 87 Equipment Schedules

Note:

When changes to these fields are made on the Accounting Assumptions page, the Recalc? flag is flipped to Yes.

Default UI Label

Database Table - Field Name

Straight Line /

ASC 840

ASC 842

IFRS 16

GASB 87

Accounting Begin Date

ContractFinancialTest.Topic842BeginDate

 

x

x

x

Accounting End Date

ContractFinancialTest.Topic842EndDate

 

x

x

x

Discount Rate

ContractFinancialTest.DiscountRate

 

x

x

x

PV Of Other Adjustments

ContractFinancialTest.PVOfOtherAdjustments

 

x

x

x

PV Of Structuring Costs

ContractFinancialTest.PVOfStructuringCosts

 

x

x

x

ASC 842 Schedule

ContractFinancialTest.CodeASC842ScheduleID

 

x

 

 

IFRS 16 Schedule

ContractFinancialTest.CodeIFRS16ScheduleID

 

 

x

x

Dismantling / Restoring Cost Amount

ContractFinancialTest.DismantlingStorageCostAmount

 

 

x

x

Impairments Amount

ContractFinancialTest.ImpairmentsAmount

 

x

x

x

Initial Direct Costs Amount

ContractFinancialTest.InitialDirectCostsAmount

 

x

x

x

Lease Incentives Amount

ContractFinancialTest.LeaseIncentivesAmount

 

x

x

x

Pre-Commencement Payments Amount

ContractFinancialTest.PreCommencePayAmount

 

x

x

x

ClosedContractTerm Table

The ContractTerm table contains fields which primarily appear on the Equipment Contract > Abstract Info > Terms page.

Important!

The Recalc? flag may or may not be triggered, depending on what value you are changing the Term Status to. See the second table to learn when the Recalc? flag is triggered.

Default UI Label

Database Table - Field Name

Straight Line /

ASC 840

ASC 842

IFRS 16

GASB 87

Term Status

ContractTerm.CodeTermStatusID

x

x

x

x

In the table below, cells marked with an x are circumstances when the Recalc? flag is triggered. Blank cells are circumstances when the Recalc? flag is not triggered. N/A appears in cells where the cell describes a scenario with no change, for example Active to Active.

From / To Blank / Empty Active Available Declined Exercised Expired Likely

Blank / Empty

N/A

x

 

 

x

 

x

Active

x

N/A

x

x

 

 

 

Available

 

x

N/A

 

x

 

x

Declined

 

x

 

N/A

x

 

x

Exercised

x

 

x

x

N/A

x

 

Expired

 

x

 

 

x

N/A

x

Likely

x

 

x

x

 

x

N/A

ClosedCovenant Table

The Covenant table contains fields which primarily appear on the Equipment Contract > Abstract Info > Covenants page.

Default UI Label

Database Table - Field Name

Straight Line /

ASC 840

ASC 842

IFRS 16

GASB 87

Accounting Adjustment Type

Covenant.CodeAccountingAdjustmentTypeID

 

x

x

x

ASC 842 Schedule

Covenant.CodeASC842ScheduleID

 

x

 

 

IFRS 16 Schedule

Covenant.CodeIFRS16ScheduleID

 

 

x

x
Currency Covenant.CodeCurrencyTypeID   x x x

Covenant Amount

Covenant.CovenantAmount

 

x

x

x

Covenant Date

Covenant.CovenantDate

 

x

x

x

Secondary Rent Schedule Allocation Percent

Covenant.SecondaryRentSchedAllocPercent

 

x

x

x

ClosedExpenseSchedule Table

The ExpenseSchedule table contains fields which primarily appear on the Equipment Contract > Payment Info > Recurring Expenses and Equipment Contract > Payment Info > Recurring Expenses > Equipment Payment Setup pages, but appear in the Expense Schedule / Escalations section of the page, or the Expense Schedule Wizard.

Default UI Label

Database Table - Field Name

Straight Line /

ASC 840

ASC 842

IFRS 16

GASB 87

Annual Amount

ExpenseSchedule.AnnualAmount

x

x

x

x

Begin Date

ExpenseSchedule.BeginDate

x

x

x

x

End Date

ExpenseSchedule.EndDate

x

x

x

x

First Payment Amount

ExpenseSchedule.FirstPaymentAmount

x

x

x

x

Last Payment Amount

ExpenseSchedule.LastPaymentAmount

x

x

x

x

Payment Amount

ExpenseSchedule.PaymentAmount

x

x

x

x

Payment Rate

ExpenseSchedule.PaymentRate

x

x

x

x

ClosedExpenseSetup Table

The ExpenseSetup table contains fields which primarily appear on the Equipment Contract > Payment Info > Recurring Expenses page.

Default UI Label

Database Table - Field Name

Straight Line /

ASC 840

ASC 842

IFRS 16

GASB 87

Currency Type

ExpenseSetup.CodeCurrencyTypeID

x

x

x

x

Frequency

ExpenseSetup.CodeFrequencyID

 

x

x

x

Pay in Arrears?

ExpenseSetup.IsPayArrears

 

x

x

x

Payment Due Day

ExpenseSetup.PaymentDueDay

 

x

x

x

Proration Method

ExpenseSetup.CodeProrationMethodID

 

x

x

x

Secondary Rent Schedule Allocation Amount

ExpenseSetup.SecondaryRentSchedAllocAmount

 

x

x

x

Secondary Rent Schedule Allocation Percent

ExpenseSetup.SecondaryRentSchedAllocPercent

 

x

x

x

ClosedField Changes Which Trigger the Recalc? Flag - Asset-Level

Changes to the fields in the following tables will flip the Recalc? flag to Yes for an asset on an equipment contract. Expand the sections below to learn more about which fields impact the Recalc? flag, and on which pages these fields usually appear.

Note:

These fields flip the Recalc? flag to Yes at the asset-level. See the section above for contract-level triggers.

ClosedAcctingAssumptionAdjust Table

The AcctingAssumptionAdjust table contains fields which appear on the Equipment Contract > Accounting Info > Accounting Assumptions pages, in the Accounting Assumption Adjustments table.

Note:

If these fields are modified at the contract-level, the asset-level Recalc? flag will also be flipped to Yes.

Default UI Label

Database Table - Field Name

ASC 842

IFRS 16

GASB 87

ASC 842 Schedule

AcctingAssumptionAdjust.CodeASC842ScheduleID

x

 

 

IFRS 16 Schedule

AcctingAssumptionAdjust.CodeIFRS16ScheduleID

 

x

x

Begin Date

AcctingAssumptionAdjust.BeginDate

x

x

x

End Date

AcctingAssumptionAdjust.EndDate

x

x

x

First Payment Amount

AcctingAssumptionAdjust.FirstPaymentAmount

x

x

x

Frequency

AcctingAssumptionAdjust.CodeFrequencyID

x

x

x

Last Payment Amount

AcctingAssumptionAdjust.LastPaymentAmount

x

x

x

Payment Amount

AcctingAssumptionAdjust.PaymentAmount

x

x

x

Secondary Rent Schedule Allocation Percent

AcctingAssumptionAdjust.SecondaryRentSchedAllocPercent

x

x

x

Proration Method

AcctingAssumptionAdjust.CodeProrationMethodID

x

x

x

ClosedAsset Table

The Asset table contains fields that pertain to assets. The fields below appear on the Equipment Contract > Accounting Info > ASC 842 Test > Equipment Assumptions / ASC 842 Tests page.

Default UI Label

Database Table - Field Name

ASC 842

IFRS 16

GASB 87

Accounting Begin Date Override

Asset.AccountingBeginDate

x

x

x

Accounting End Date Override

Asset.AccountingEndDate

x

x

x

Accounting Method Override

Asset.CodeAccountingMethodOverrideID

x

x

x
Asset Operation Status Asset.CodeAssetOperationStatusID

x

x

x

Discount Rate Override

Asset.DiscountRateOverride

x

x

x

Does the Asset have a Specialized Use?

Asset.IsAssetTooSpecializedForLessor

x

x

x

Does Ownership Revert to Tenant?

Asset.DoesTitleRevertToTenant

x

x

x

Fair Value of Asset

Asset.FairValueOfAsset

x

x

x

Initial Asset Balance Adjustment

Asset.InitialAssetBalanceAdjust

x

x

x

Initial Liability Balance Adjustment

Asset.InitialLiabilityBalanceAdjust

x

x

x

Portion of Asset Controlled

Asset. PortionOfAssetControlled

x

x

x

Remaining Economic Life

Asset.RemainingLife

Asset.CodeRemainingLifeFreqUnitID

x

x

x

ClosedContract Table

The Contract table contains fields which appear on the Equipment Contract > Details > Summary page.

Note:

If these fields are modified at the contract-level, the asset-level Recalc? flag will also be flipped to Yes.

Default UI Label

Database Table - Field Name

ASC 842

IFRS 16

GASB 87
Expire Date

Contract.ExpireDate

x

x

x
Payments End Date

Contract.PaymentsEndDate

x

x

x

ClosedContractFinancialTest Table

The ContractFinancialTest table contains fields which appear on the following pages:

  • Equipment Contract > Accounting Info > Accounting Assumptions

  • Equipment Contract > Accounting Info > ASC 842 Rent Schedule

  • Equipment Contract > Accounting Info > ASC 842 Rent Schedule > ASC 842 Equipment Schedules

  • Equipment Contract > Accounting Info > IFRS 16 Rent Schedule

  • Equipment Contract > Accounting Info > IFRS 16 Rent Schedule > IFRS 16 Equipment Schedules

  • Equipment Contract > Accounting Info > GASB 87 Rent Schedule

  • Equipment Contract > Accounting Info > GASB 87 Rent Schedule > GASB 87 Equipment Schedules

Note:

If these fields are modified at the contract-level, the asset-level Recalc? flag will also be flipped to Yes.

Default UI Label

Database Table - Field Name

ASC 842

IFRS 16

GASB 87

Accounting Begin Date

ContractFinancialTest.Topic842BeginDate

x

x

x

Accounting End Date

ContractFinancialTest.Topic842EndDate

x

x

x

Discount Rate

ContractFinancialTest.DiscountRate

x

x

x

PV Of Other Adjustments

ContractFinancialTest.PVOfOtherAdjustments

x

x

x

PV Of Structuring Costs

ContractFinancialTest.PVOfStructuringCosts

x

x

x

ASC 842 Schedule

ContractFinancialTest.CodeASC842ScheduleID

x

 

 

IFRS 16 Schedule

ContractFinancialTest.CodeIFRS16ScheduleID

 

x

x

Dismantling / Restoring Cost Amount

ContractFinancialTest.DismantlingStorageCostAmount

 

x

x

Impairments Amount

ContractFinancialTest.ImpairmentsAmount

x

x

x

Initial Direct Costs Amount

ContractFinancialTest.InitialDirectCostsAmount

x

x

x

Lease Incentives Amount

ContractFinancialTest.LeaseIncentivesAmount

x

x

x

Pre-Commencement Payments Amount

ContractFinancialTest.PreCommencePayAmount

x

x

x

ClosedContractTerm Table

The ContractTerm table contains fields which primarily appear on the Equipment Contract > Abstract Info > Terms page.

Important!

The Recalc? flag may or may not be triggered, depending on what value you are changing the Term Status to. See the second table to learn when the Recalc? flag is triggered.

Note:

If these fields are modified at the contract-level, the asset-level Recalc? flag will also be flipped to Yes.

Default UI Label

Database Table - Field Name

ASC 842

IFRS 16

GASB 87

Term Status

ContractTerm.CodeTermStatusID

x

x

x

In the table below, cells marked with an x are circumstances when the Recalc? flag is triggered. Blank cells are circumstances when the Recalc? flag is not triggered. N/A appears in cells where the cell describes a scenario with no change, for example Active to Active.

From / To Blank / Empty Active Available Declined Exercised Expired Likely

Blank / Empty

N/A

x

 

 

x

 

x

Active

x

N/A

x

x

 

 

 

Available

 

x

N/A

 

x

 

x

Declined

 

x

 

N/A

x

 

x

Exercised

x

 

x

x

N/A

x

 

Expired

 

x

 

 

x

N/A

x

Likely

x

 

x

x

 

x

N/A

ClosedCovenant Table

The Covenant table contains fields which primarily appear on the Equipment Contract > Abstract Info > Covenants page.

Note:

If these fields are modified at the contract-level, the asset-level Recalc? flag will also be flipped to Yes.

Default UI Label

Database Table - Field Name

ASC 842

IFRS 16

GASB 87

Accounting Adjustment Type

Covenant.CodeAccountingAdjustmentTypeID

x

x

x

ASC 842 Schedule

Covenant.CodeASC842ScheduleID

x

 

 

IFRS 16 Schedule

Covenant.CodeIFRS16ScheduleID

 

x

x

Covenant Amount

Covenant.CovenantAmount

x

x

x

Secondary Rent Schedule Allocation Percent

Covenant.SecondaryRentSchedAllocPercent

x

x

x

Covenant Date

Covenant.CovenantDate

x

x

x

ClosedExpenseSchedule Table

The ExpenseSchedule table contains fields which appear on the Equipment Contract > Payment Info > Recurring Expenses and Equipment Contract > Payment Info > Recurring Expenses > Equipment Payment Setup pages, but appear in the Expense Schedule / Escalations section of the page, or the Expense Schedule Wizard.

Note:

If these fields are modified at the contract-level, the asset-level Recalc? flag will also be flipped to Yes.

Default UI Label

Database Table - Field Name

ASC 842

IFRS 16

GASB 87

Annual Amount

ExpenseSchedule.AnnualAmount

x

x

x

Begin Date

ExpenseSchedule.BeginDate

x

x

x

End Date

ExpenseSchedule.EndDate

x

x

x

First Payment Amount

ExpenseSchedule.FirstPaymentAmount

x

x

x

Last Payment Amount

ExpenseSchedule.LastPaymentAmount

x

x

x

Payment Amount

ExpenseSchedule.PaymentAmount

x

x

x

Payment Rate

ExpenseSchedule.PaymentRate

x

x

x

ClosedExpenseSetup Table

The ExpenseSetup table contains fields which primarily appear on the Equipment Contract > Payment Info > Recurring Expenses page.

Note:

If these fields are modified at the contract-level, the asset-level Recalc? flag will also be flipped to Yes.

Default UI Label

Database Table - Field Name

ASC 842

IFRS 16

GASB 87

Currency Type

ExpenseSetup.CodeCurrencyTypeID

x

x

x

Frequency

ExpenseSetup.CodeFrequencyID

x

x

x

Pay in Arrears?

ExpenseSetup.IsPayArrears

x

x

x

Payment Due Day

ExpenseSetup.PaymentDueDay

x

x

x

Proration Method

ExpenseSetup.CodeProrationMethodID

x

x

x

Secondary Rent Schedule Allocation Amount

ExpenseSetup.SecondaryRentSchedAllocAmount

x

x

x

Secondary Rent Schedule Allocation Percent

ExpenseSetup.SecondaryRentSchedAllocPercent

x

x

x

ClosedFinancialAjustment Table

The FinancialAdjustment table contains fields which pertain to the accounting assumptions adjustments of an asset. These fields appear on the Equipment Contract > Payment Info > Recurring Payments > Equipment Payment Setup page in the Add / Edit Financial Adjustment window.

Important!

The Recalc? flag will only be triggered if you change the value in the Status to or from Likely.

Default UI Label

Database Table - Field Name

ASC 842

IFRS 16

GASB 87

Accounting Adjustment Type

FinancialAdjustment.CodeAccountingAdjustmentTypeID

x

x

x

Amount

FinancialAjustment.Amount

x

x

x
Effective Date

FinancialAjustment.EffectiveDate

x

x

x

Status

FinancialAdjustment.CodeFinancialAdjustmentStatusID

x

x

x

Accruent logo in white text.

© Copyright Accruent 2025Privacy PolicyTerms of UseLegal