---
title: "Pennylane multiple companies report each month · Hypamoon"
description: "Several companies in Pennylane? Each month one report with every company side by side and added up, per account group you choose, next to last month."
url: https://hypamoon.com/connect-to/pennylane/group-reporting
---

1.  [Connect to](https://hypamoon.com/connect-to)
2.  [Pennylane](https://hypamoon.com/connect-to/pennylane)
3.  Multiple companies report

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.

[Start free](https://app.hypamoon.com/?mode=signup&utm_source=connect-to&utm_campaign=pennylane/group-reporting)

## 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.

[Build this in your chat](https://hypamoon.com/connect?via=connect-to~pennylane/group-reporting&say=a%20monthly%20report%20with%20each%20of%20our%20companies%20in%20Pennylane%20side%20by%20side%20and%20added%20up%2C%20per%20account%20group%20I%20choose%2C%20next%20to%20the%20month%20before.)

[Start free](https://app.hypamoon.com/?mode=signup&utm_source=connect-to&utm_campaign=pennylane/group-reporting)

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

## More for teams on Pennylane

-   [**I want to send a customer one overview of what they still owe, not an email per invoice.**](https://hypamoon.com/connect-to/pennylane/statements)
-   [**I want to see the margin per line and on the whole quote while I make it.**](https://hypamoon.com/connect-to/pennylane/quote-margin)
-   [**I want a received supplier invoice to go to the person who handles that supplier, not to everyone.**](https://hypamoon.com/connect-to/pennylane/received-supplier-invoices)
-   [**I want a quote followed up automatically when the customer has not answered after two weeks.**](https://hypamoon.com/connect-to/pennylane/quote-follow-up)
-   [**I want to see which accepted quotes are only partly invoiced without opening each quote.**](https://hypamoon.com/connect-to/pennylane/partly-invoiced-quotes)
-   [**I want to work out the interest on late invoices and invoice it.**](https://hypamoon.com/connect-to/pennylane/late-payment-interest)
-   [**I want customers to be told automatically that their subscription renews soon.**](https://hypamoon.com/connect-to/pennylane/subscription-renewals)
-   [**Everything for Pennylane**](https://hypamoon.com/connect-to/pennylane)
