How do I check my trial balance mapping?

If you notice discrepancies in your CoMetrics dashboard reporting, the cause is often a mapping issue. We import your Trial Balance and map it to a chart of accounts shared by all the companies in your group. In doing so, we may have mapped some items incorrectly. You can review your mapping and request changes with a Mapping Check File.

CoMetrics maps your accounts to a shared chart of accounts so your financial performance is directly comparable to your peers.

We recommend a two-part process to review:

Compare your internal reports to the Trends report in the CoMetrics Dashboard
Download and review the Mapping Check file

On a high-level basis, total assets, liabilities, equity, net income, etc., should match your internal reports. However, we don't expect to match on a line-by-line basis as you drill into the details.

Review Trends Report

Sign in to the CoMetrics Dashboard. Choose Trends and view the data in a yearly format.
Begin by comparing subtotals for summary accounts in the Dashboard to those in your internal statements for the Balance Sheet and Income Statement. If you notice discrepancies, drill down to see additional detail. Make notes about any numeric discrepancies you notice.
Once you've reviewed the Trends compared to your internal reports, you are ready to review your Mapping Check File.

Review Mapping Check File

Sign in to the CoMetrics Dashboard and select Check Trial Balance Mapping.
Choose the desired Fiscal Year and Quarter; the system will create and download an Excel file to your computer. Upon opening the file, you will see several tabs:

Instructions give an overview of how to use the file.
The Mapping tab shows how each account has been mapped.
The Common Chart tab shows all the standard accounts and data from your quarterly submission.

Use the Comments column in the Mapping tab to note questions or request changes. Once you finish your review, save your Mapping Check File and submit it to CoMetrics so we can make the necessary corrections. To submit your file, sign in to the CoMetrics Dashboard. Depending on your access level, follow one of the paths below.

Select Uploads > Upload Type > Other
Select Uploads > Click Here to Upload > Trial Balance, Other Surveys > Next > Upload Type > Other

How do I check my trial balance mapping?

Participants in the Quarterly Benchmarking programs send trial balance reports that we map to a standard chart of accounts. A review of your mapping will ensure accuracy and understanding of how your data is handled.

Review Trends Report

Review Mapping Check File