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.
When you notice discrepancies in your dashboard reporting, it can be 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.
Remember that we map your accounts to a shared chart of accounts to make your financial performance 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 into https://secure.cometrics.com/sign-in 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, please save your Mapping Check File document to your computer and submit it to CoMetrics so we can make the necessary changes.
Sign into https://secure.cometrics.com/sign-in.
Depending on your access, follow one of these paths.
- Select Uploads > Upload Type > Other
- Select Uploads > Click Here To Upload > Trial Balance, Other Surveys > Next > Upload Type > Other