How To: Import Accrual and Prepaid Actuals for Balance Sheet from Integrations

Situation

Forecast 5 Income & Cost records that are accruals/prepayments and separately invoiced records create a balance sheet data entry field linked to the P&L record but there is no Balance sheet GL Code from which to import the balance each month.

The general ledger financials do not separate these so we have no way of importing them based on the GL Code as it does not exist in the general ledger or Forecast 5.
E.g. a normal sale of an asset will most likely be in the debtors control.

You either need to manually create new records in the other assets and liabilities linked to the GL Code (Except Xero as Xero GL code is not used but an index)

Or manually update the accruals and prepayment entries in balance sheet.

For example

The P&L has a record "Holiday provision" is an accrual record.

In each month, an amount is accrued to the P&L e.g. 1000

The Balance Sheet may hold a Holiday Provision record or it might just be in accruals.

Suggested solution

If you have GL Balance sheet code “Holiday Provision“ then create a separate record in the other assets and liabilities section of the balance sheet and enter the GL Code ⁽¹⁾

When you import actuals, this record will be populated with the value from the balance sheet.

1) In Xero, the GL code is a hidden index field and is held in a different field in Forecast 5 so you can not add new GL codes into records as they will not be connected. You will need to redo the import mapping.