Release Notes

In this release we added a new Recurring Expenses section to the BSIC spreadsheet, accessible via RECURRING_EXPENSE_ADDRESS, and updates several existing output cell addresses that have shifted as a result.

What's new?

Mortgage

BSIC - cell address update

A new Recurring Expenses section has been added to the Business Self-Income Calculator (BSIC) spreadsheet and now accessible via RECURRING_EXPENSE_ADDRESS. This enhancement gives you deeper visibility into recurring expense data as part of the income calculation workflow. However, this addition has caused a downward shift for several existing output cell addresses. If your integration references BSIC cell addresses programmatically, you must update those references to reflect the latest values.

Affected constants

The following constants have shifted and must be updated:

EXPENSE_FACTOR_TYPE_ADDRESS
BUSINESS_CPA_EXPENSE_PERCENTAGE_ADDRESS
BUSINESS_PROFIT_AND_LOSS_GROSS_REVENUE_ADDRESS
BUSINESS_PROFIT_AND_LOSS_EXPENSE_ADDRESS
NSF_ADDRESS
AVERAGE_DEPOSIT_ADDRESS
PERCENTAGE_AMOUNT_ADDRESS
LARGE_DEPOSIT_THRESHOLD_ADDRESS
LARGE_DEPOSIT_FLAG_ADDRESS

📘
Note
NSF_ADDRESS has the largest shift of all affected constants. Please pay special attention when updating this reference.

Update all affected constant references in your integration to the latest cell addresses. Refer to the latest BSIC spreadsheet for the exact updated values. For questions or help updating your integration, contact your Ocrolus account team or reach out at [email protected].

Migration Example

    EXPENSE_FACTOR_TYPE_ADDRESS = "F19"
    NSF_ADDRESS = "G18"