For teams that run on Business Central
Business Central group reporting across companies
Business Central consolidates through business units in a separate company, with exchange rates you set up and eliminations you enter as journal lines. Many groups with a few companies still export the figures of each company and add them up in a spreadsheet.
How it goes today
- Export the profit and loss of each company at month end.
- Paste them into one spreadsheet and line up the accounts.
- Convert the figures of companies that report in another currency.
- Take out what the companies charged each other by hand.
How it can go
See the results of each company side by side, with the group total, each month.
After each month end you get one overview with the profit and loss and balance of each company side by side and the group total, using an account mapping you check once and exchange rates you give. Amounts between your own companies show on their own line, so you can see them before you take them out.
Say this in ChatGPT, Claude or Copilot
Your chat gets connected to Hypamoon first, with this request filled in. You paste your Business Central key in the portal, never in the chat.
With Hypamoon, after each month end, read the profit and loss and balance sheet of each of our Business Central companies and put them side by side with a group total. Use the account mapping I check once and the exchange rates I give for companies in another currency. Show amounts between our own companies on a separate line. Email me the overview on the fifth working day.
Your IT administrator registers an app in your own Microsoft Entra ID with a client ID and secret and the Business Central API permission, then adds it on the Microsoft Entra Applications page in Business Central with only the permission sets this tool needs. It stays yours.
More for teams on Business Central
- I want a portal where my business customers can view their orders and invoices and place new orders.
- I want to email a batch of posted invoices, each to the invoice address of the customer who pays.
- I want my monthly reports emailed to me, with the dates moving along each month.
- I want statements sent to my customers each month without going through each customer card.
- When I send a reminder, I want the overdue invoices attached, so customers stop asking for copies.
- I want approvers reminded of what is waiting, and the requester told when it is approved or rejected.
- I want an email when a job queue entry stops, so someone can fix it and restart it.
- I want to download a month of invoices as PDFs at once, not one by one.
- I still type each line of each supplier invoice into Business Central.
- I want customers reminded about quotes they have not answered, before the quote expires.
- Everything for Business Central