Choose Upload trial balance on Enter Cost Data and follow the steps. Nothing commits until you review the mappings.
What the file needs
A CSV or Excel file, or a range pasted from Excel including the header row. It needs an account number, an account name, and either debit and credit columns or one balance column.
Steps
- Choose Upload trial balance and load or paste the file.
- Confirm the columns. Rate Studio detects each one, and you can change any with the drop-down above it. If your file has a category column or a department column, Rate Studio uses them to map accounts.
- Map departments (see How do I map departments to pools?), then map categories (see How do I map categories and review account mappings?).
- Review the accounts (see How do I map categories and review account mappings?). The amounts are already in your cost data, so this step is about the mappings.
- Check the control totals: the file total, the imported total and the total in cost data should agree (see My trial balance control totals don't agree: what do I check?).
- When everything is reviewed, choose Apply and continue. If a structure has an intermediate pool, Rate Studio then takes you to its allocation data (How do I enter intermediate pool allocation data?).
Safety checks
Import warns about duplicate account numbers and compares your file's rows and dollars with what was imported.
Next year's file
Upload the new file. Your saved mappings are kept, every amount is replaced, and only what changed is listed. See How do I update mappings when I upload next year's file?.
If this doesn't work: if the control totals don't agree, see My trial balance control totals don't agree: what do I check?.
Watch: Upload and map a trial balance, from 0:16
Full guide section: Enter Cost Data
Related: How do I map categories and review account mappings? | How do I map departments to pools? | My trial balance control totals don't agree: what do I check?