Are you new to our Trial Balance program? Here is what you need to know about submitting data.
Submit your Trial Balance Report
Export a summary Trial Balance report from your system as an XLSX file. If you can't export an XLSX file, send us a CSV.
Send us an unedited file. We aim for the TB file to be easy for you to create quarter after quarter in the same format.
Include the right information in your report. Every accounting system has a slightly different format, and we work with what your system generates. Please make sure your report includes the following:
- Account numbers— Each line item needs to have a unique number. If you use accounts and subaccounts, please include both.
- Account Descriptions— Each account needs a description. We rely on descriptions to map your data to the chart of our accounts specific to the Benchmarking program for your group.
- Dollar Values for the period - Include values summarized at the account level. Typically, we receive one of the following formats:
- Ending Balance for the period - this is the best format to ensure accurate data
-
- Debits and Credits only - typically from Quickbooks accounting systems
-
- All of the details (Starting Balance, Debits and Credits, and Ending Balance)
Remember...
- Trial Balance files should balance
- When submitting for multiple periods, upload in order - upload 3/31 before 6/30
- Use the same file format for every upload, including headers and column names e.g., the same columns in the same order each time you upload
How to Upload Files
Log in to the CoMetrics Dashboard and submit the file.
- Sign into https://secure.cometrics.com/sign-in
- Select Uploads > Upload Type > Trial Balance
- Select the Closing Date that matches the end of the period for the file you are Uploading.
- Choose the file.
- Leave us a note about any new accounts or changes.
- Click on Send File.