Check fails for actuals months
Check account mappings
Have all balance sheet accounts been mapped? If not, map the missing accounts to the relevant rows in Francis.
Check for misclassified accounts
Have you incorrectly mapped P&L accounts to the balance sheet, or vice versa? Check the account category label (I, EX, A, or L) in the mapping interface. Any account showing I or EX on a balance sheet row is in the wrong place. Move it to the correct section.
Check for wrong-side mappings
Have you mapped asset accounts to the liability side, or vice versa? Francis flips the sign of liability accounts, so a wrong-side mapping causes a mismatch. Remap to the correct side.
Check for manual overrides
Are there manual overrides in the balance sheet? Look for cells with a yellow corner indicator. Remove the override or update the value to match your GL.
Check for non-GL rows
Does the balance sheet contain rows with values not sourced from your GL? Review each row. Any row driven by a hardcoded value or formula not tied to your GL mapping will cause a mismatch. Remove it or map it to a GL account.
Adjust retained earnings
If you use QuickBooks Online, Xero, or NetSuite, have you manually adjusted retained earnings? If not, apply the adjustment. See your integration setup guide for the steps.
Check fails for forecast months
Resolve actuals first
Is the check passing for actuals months? If not, resolve that first before troubleshooting forecasts.
Link Cash to ending cash
Have you forecasted the asset line item Cash as ending cash from the cash flow statement? If not, set the Cash row formula to
= "Cash end period"[0].Check the cash flow validation
Is the cash flow check passing for actuals months? If not, resolve the cash flow check before continuing.
Check non-cash line items
Have all non-cash line items been forecasted correctly? These don’t flow through the cash flow statement but still affect the balance sheet. Common causes:
- Retained earnings should equal last period’s value plus this period’s net profit.
- Accumulated depreciation should equal last period plus this period’s depreciation expense.
- Investments in subsidiaries (equity method) should equal last period plus this period’s income from subsidiaries.
All cash-related P&L and balance sheet line items flow through the cash flow statement and affect the cash asset line. Errors there won’t cause the balance sheet to go out of balance, but they may distort the cash value itself.