Skip to content
  • There are no suggestions because the search field is empty.

Handling Control Total Out-of-Balance

This is usually caused when a new account is added in QuickBooks since the report was generated.

Flash Reports includes a built-in control total section with conditional formatting that flags when a report is out of balance. This most commonly happens when a new account has been created in QuickBooks after the report was generated, so its balance is included in the control total but the account itself has no line on the main report.

When the user reports an out-of-balance condition, follow this process:

  1. Locate the first out-of-balance total. Scan the control total section from the top down and identify the first row flagged by the conditional formatting. Fix issues in order - later out-of-balance totals are often downstream of the first one and may resolve once it's fixed. If the control totals are not found report this to the user and stop the process.

  2. Instruct the user to drill down on that total. Claude cannot trigger a Flash Reports drilldown directly - ask the user to run the drilldown on the flagged number in Flash Reports themselves, which will generate the detailed report of all transactions/accounts in a new worksheet in the current workbook.
  3. Compare the drilldown accounts to the main report. Identify any account(s) present in the drilldown detail that do not appear anywhere on the main report - these are the new accounts causing the imbalance.
  4. Insert the missing account(s) in the correct location. Add a row for each missing account in the section of the main report where it belongs (matching the ordering, grouping, and formula pattern of its account type/category), and link it in with the same formula structure used by its neighboring accounts so it feeds correctly into the section subtotal and the control total. Verify the section total formula actually references the new row. A row insert shifts relative ranges that fully sit below the insertion point, but any SUM/total term that pointed at a narrow fixed range (e.g. SUM(B30:B30) covering just a header or placeholder row) will NOT automatically expand to include a new standalone line item inserted into that gap. After inserting, open the section total's formula and confirm every new account is covered by one of its SUM terms - don't rely on the total simply recalculating without error; a missing term produces a correct-looking number with no error value, so it will not be caught by checking for #REF!/#VALUE!. If a term doesn't cover the new row, widen or add a term so it does, then re-check step 5.
  5. Re-check the control total. After inserting the account(s), confirm the flagged total now balances (conditional formatting clears). If it doesn't, or if another out-of-balance total remains, repeat from step 1 for the next flagged total.

Do not manually override or hardcode the control total or any subtotal to force a match - the imbalance must be resolved by adding the missing account, not by adjusting the total.