From Amalgam: Consolidate multiple entities into one and make elimination entries where General Ledgers can’t.

This template is perfect of accounting systems like Quickbooks that don’t accommodate multiple entities.

It works by Amalgam connecting to multiple entities across distinct tabs in this workbook. It pulls in Trial Balance reports which can be updated each period in one click. Those entities are mapped for consistent aggregation based on a user-defined mapping table. The distinct entity Trial Balance reports from Amalgam then feed the “Consolidation” sheet which normalizes each entity’s data and allows for eliminations.

From there, the data are fed a formatted Income Statement and Balance Sheet, which can be printed to PDFs for distribution.