video1.0<iframe src="https://www.loom.com/embed/37c8b896b2e34bcaaa9f8a9baa2aee22" frameborder="0" width="1152" height="864" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>8641152Loomhttps://www.loom.com8641152https://cdn.loom.com/sessions/thumbnails/37c8b896b2e34bcaaa9f8a9baa2aee22-452d3dfc8b5c0c6f.gif231.791This Loom demonstrates how to build a consolidation sheet for five companies using action reporting with data pulled directly from Business Central. It emphasizes setting up the account card category and subcategory for every Business Central account number across all five companies, then running validations to ensure none are marked as Not Applicable. The walkthrough shows filtering on column I to find incorrect mappings, using details to correct the subcategory (for example equipment), and refreshing to confirm all account numbers are fully mapped. It then sets company selection, choosing the period as 12 for December or switching to accounting periods, and pulls current and prior year numbers for the selected companies.