---
title: "QuickBooks Online consolidated reports, monthly · Hypamoon"
description: "Combining the profit and loss of several QuickBooks Online companies in a spreadsheet each month? Get them side by side with a total, on a day you choose."
url: https://hypamoon.com/connect-to/quickbooks-online/group-reporting
---

1.  [Connect to](https://hypamoon.com/connect-to)
2.  [QuickBooks Online](https://hypamoon.com/connect-to/quickbooks-online)
3.  Consolidated reports

For teams that run on QuickBooks Online

# QuickBooks Online consolidated reports, monthly

Each company is its own file in QuickBooks Online, and its reports show that one company. Owners with more than one company export each report and add them up in a spreadsheet to see the whole group.

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

## How it goes today

1.  Sign in to each company file in turn.
2.  Run the profit and loss and balance sheet for the month.
3.  Export each report to a spreadsheet.
4.  Add the companies up by hand and check the totals.

## How it can go

**See every company side by side with one total, without the monthly spreadsheet.**

Each month you get the profit and loss and balance sheet of each company side by side, with a total. You check once how the accounts of each company line up, and give the exchange rate if a company uses another currency. Amounts between your own companies stay on their own line, so your accountant can see them.

## Say this in ChatGPT, Claude or Copilot

Your chat gets connected to Hypamoon first, with this request filled in. QuickBooks Online works with a sign-in instead of a key: you sign in to QuickBooks Online once to give access, never in the chat.

Your request

> With Hypamoon, each month, take the profit and loss and balance sheet from each of our QuickBooks Online companies and put them side by side with a total. Ask me once how the accounts line up between the companies, use the exchange rate I give for companies in another currency, and keep amounts between our own companies on a separate line. Email it to me on the fifth of the month.

[Build this in your chat](https://hypamoon.com/connect?via=connect-to~quickbooks-online/group-reporting&say=the%20reports%20of%20each%20of%20our%20QuickBooks%20Online%20companies%20side%20by%20side%20with%20a%20total%2C%20every%20month%2C%20with%20amounts%20between%20our%20own%20companies%20on%20their%20own%20line.)

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

You create your own app on the Intuit Developer Platform and connect your QuickBooks company once. It stays yours.

## More for teams on QuickBooks Online

-   [**My customers want a receipt when they pay, and I send each one by hand.**](https://hypamoon.com/connect-to/quickbooks-online/payment-receipts)
-   [**I want statements to go out every month, only to customers who owe us.**](https://hypamoon.com/connect-to/quickbooks-online/statements)
-   [**Working out interest on every late invoice takes too much time.**](https://hypamoon.com/connect-to/quickbooks-online/late-payment-interest)
-   [**We raise prices each year and change every recurring invoice one by one.**](https://hypamoon.com/connect-to/quickbooks-online/recurring-invoice-prices)
-   [**I want to download a full year of receipts at once for my accountant.**](https://hypamoon.com/connect-to/quickbooks-online/document-archive)
-   [**I want to see per customer how many days they take to pay.**](https://hypamoon.com/connect-to/quickbooks-online/payment-behaviour)
-   [**A customer pays many invoices at once and I match each one by hand.**](https://hypamoon.com/connect-to/quickbooks-online/remittance-matching)
-   [**I make several purchase orders by hand from every estimate.**](https://hypamoon.com/connect-to/quickbooks-online/estimate-purchase-orders)
-   [**I keep a spreadsheet to spread prepaid bills over the months.**](https://hypamoon.com/connect-to/quickbooks-online/prepayments)
-   [**I want customers who do not answer an estimate to get a reminder.**](https://hypamoon.com/connect-to/quickbooks-online/estimate-follow-up)
-   [**I need invoices paid between two dates per rep, not invoices created.**](https://hypamoon.com/connect-to/quickbooks-online/sales-commissions)
-   [**Can you set credit limits for customers to stop invoices or orders being raised?**](https://hypamoon.com/connect-to/quickbooks-online/credit-limits)
-   [**QuickBooks Online doesn't let nonprofits create end-of-year donation letters for donors.**](https://hypamoon.com/connect-to/quickbooks-online/donor-statements)
-   [**It does not create a proper Canadian tax receipt.**](https://hypamoon.com/connect-to/quickbooks-online/donation-receipts)
-   [**We need a report that HMRC accepts when making a Gift Aid claim.**](https://hypamoon.com/connect-to/quickbooks-online/gift-aid)
-   [**Can I set up expenses to split automatically to classes by percentage?**](https://hypamoon.com/connect-to/quickbooks-online/cost-allocation)
-   [**How do I set up payment scheduling on an invoice?**](https://hypamoon.com/connect-to/quickbooks-online/payment-plans)
-   [**Is there a way to have QuickBooks flag a duplicate bill we entered by hand?**](https://hypamoon.com/connect-to/quickbooks-online/duplicate-bills)
-   [**How do you reconcile supplier statements to QuickBooks Online, like a bank statement?**](https://hypamoon.com/connect-to/quickbooks-online/vendor-statements)
-   [**I need to add retention to an invoice and release it when the job is complete.**](https://hypamoon.com/connect-to/quickbooks-online/retainage)
-   [**Is there a report for economic nexus with another state?**](https://hypamoon.com/connect-to/quickbooks-online/economic-nexus)
-   [**What is the best way to track restricted funds for my nonprofit?**](https://hypamoon.com/connect-to/quickbooks-online/restricted-funds)
-   [**Is it possible to sell a product at set, different price levels?**](https://hypamoon.com/connect-to/quickbooks-online/price-levels)
-   [**How can I use discounts to write off small amounts on my customer invoices?**](https://hypamoon.com/connect-to/quickbooks-online/small-balance-write-offs)
-   [**Can you close open estimates in a batch, not one by one?**](https://hypamoon.com/connect-to/quickbooks-online/close-old-estimates)
-   [**Now I have 90 some-odd payments to deposit.**](https://hypamoon.com/connect-to/quickbooks-online/undeposited-funds)
-   [**Does QuickBooks Online Plus have a notification for low inventory?**](https://hypamoon.com/connect-to/quickbooks-online/low-stock-alerts)
-   [**Will it notify you if you are going over budget?**](https://hypamoon.com/connect-to/quickbooks-online/budget-alerts)
-   [**Is there an easier way to track resale certificates?**](https://hypamoon.com/connect-to/quickbooks-online/resale-certificates)
-   [**I need to create a positive pay file for the bank.**](https://hypamoon.com/connect-to/quickbooks-online/positive-pay)
-   [**Since QuickBooks Online cannot import IIF files, I had to hunt down a way.**](https://hypamoon.com/connect-to/quickbooks-online/iif-import)
-   [**I chase clients every month about their uncategorized transactions.**](https://hypamoon.com/connect-to/quickbooks-online/uncategorized-questions)
-   [**We keep a depreciation schedule in a spreadsheet and post it by hand.**](https://hypamoon.com/connect-to/quickbooks-online/depreciation)
-   [**We need approvals, and on our plan that means upgrading to Advanced.**](https://hypamoon.com/connect-to/quickbooks-online/bill-approvals)
-   [**Our government customer wants a Peppol e-invoice, not a PDF.**](https://hypamoon.com/connect-to/quickbooks-online/peppol-invoices)
-   [**I was looking for months for a way to create a customer portal.**](https://hypamoon.com/connect-to/quickbooks-online/customer-portal)
-   [**I want to enter my stock count in QuickBooks without printing and typing.**](https://hypamoon.com/connect-to/quickbooks-online/stock-count)
-   [**Everything for QuickBooks Online**](https://hypamoon.com/connect-to/quickbooks-online)
