My trial balance control totals don't agree: what do I check?

My trial balance control totals don't agree: what do I check?

The three control totals should agree. They are the file total, the imported total and the total in cost data, and Rate Studio tells you if they don't.

What to check

  1. Duplicate account numbers. Import warns about these before they reach your rates.
  2. Rows and dollars. Import compares the rows and dollars in your file with what was imported. Look for rows that did not come in.

On Calculate & Reconcile

Since version 3.22.0 the screen no longer repeats the control totals. It shows a short warning, with a link back to Enter Cost Data, only when the trial balance does not tie to your cost data. Follow the link and fix the import.

If a structure leaves dollars out of its pools, a separate red message appears (see 'Cost data not used by this structure' red message).

If this doesn't work: contact support (How do I contact support, report a bug or request a feature?) with your file and the totals you see.

Watch: Upload and map a trial balance, check the control totals from 2:08

Full guide section: Enter Cost Data

Related: How do I upload a trial balance? | How do I update mappings when I upload next year's file? | 'Cost data not used by this structure' red message