---
title: "QuickBooks Online restricted funds, per month · Hypamoon"
description: "Working out restricted fund balances in a spreadsheet? Get the balance of each fund from your QuickBooks Online classes each month, with what was spent."
url: https://hypamoon.com/connect-to/quickbooks-online/restricted-funds
---

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

For teams that run on QuickBooks Online

# QuickBooks Online restricted funds, per month

Nonprofits track restricted gifts and grants by class in QuickBooks Online. The balance sheet by class is part of the Advanced plan, so most work out the remaining balance per fund in a spreadsheet from a profit and loss by class.

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

## How it goes today

1.  Run profit and loss by class for the period.
2.  Add it to the balances of earlier years.
3.  Work out what is left per fund in a spreadsheet.
4.  Report each fund to the board or the funder.

## How it can go

**Each fund shows what came in, what was spent and what is left.**

Each month you get per fund the income and spending of the month and since the fund started, and the balance left. Funds that go below zero or run past their end date are marked.

## 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 by class from QuickBooks Online for the month and since the start date I give per fund. Show per fund the income, the spending and what is left, mark funds below zero or past the end date I enter, and email it to me and the treasurer.

[Build this in your chat](https://hypamoon.com/connect?via=connect-to~quickbooks-online/restricted-funds&say=a%20monthly%20balance%20per%20restricted%20fund%20from%20our%20QuickBooks%20Online%20classes%2C%20with%20income%2C%20spending%20and%20what%20is%20left.)

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

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)
-   [**Every month I add up the reports of each company in a spreadsheet.**](https://hypamoon.com/connect-to/quickbooks-online/group-reporting)
-   [**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)
-   [**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)
