Skip to content
Hypamoon

For teams that run on Pennylane

Pennylane multiple companies report each month

Pennylane shows key figures across your companies on one dashboard. A monthly result per company and for the group together, per account group, still means exporting each trial balance and adding them up in a spreadsheet.

How it goes today

  1. Export the trial balance of each company at month end.
  2. Paste each export into a workbook, one tab per company.
  3. Map the accounts to your own groups and add them up.
  4. Email the combined sheet to the other directors.

How it can go

See every company side by side and added up, each month.

Each company has its own Pennylane key, which you paste in the portal once. You choose once which account numbers go into which group, such as revenue, purchases, staff and overheads. On the fifth working day of each month you get one report with each company in its own column, the group total next to it, and the month before for comparison. Amounts between your own companies are shown as they are booked; you decide what to leave out.

Say this in ChatGPT, Claude or Copilot

Your chat gets connected to Hypamoon first, with this request filled in. You paste your Pennylane key in the portal, never in the chat.

Your request

With Hypamoon, on the fifth working day of each month, take last month's trial balance of each of our companies in Pennylane and group the accounts into revenue, purchases, staff, overheads and result as I set once. Email me one report with a column per company, the total, and the month before. Leave amounts between our own companies as they are booked.

You create the Pennylane key yourself under Settings, Connectivity, Developers, on the Essential plan or higher. It stays yours.