Skip to main content

Balance sheet and trial balance

The Balance sheet shows what your association has and owes on one date: bank balances and other assets, liabilities, and equity.

M
Written by Michael Bollinger

The Balance sheet shows what your association has and owes on one date: bank balances and other assets, liabilities, and equity. The Trial balance lists the debit or credit balance of every account on one date, including income and expense categories, which is what an accountant or auditor usually asks for. This article explains what each line means and why a number can differ from what you expect.

Before you start: you need Reports access. Picking the date, exporting and scheduling work the same as on every report. See Run, filter, export and favorite a report.

Run the balance sheet

  1. On Reports, under Business Overview Reports, click Balance Sheet.

  2. The report runs straight away as of today. To see another day, pick an As of date and click Show results.

  3. Hide $0.00 balances is on by default. Turn it off to see every account, including empty ones.

The results card is titled Balance sheet, with As of MM/DD/YYYY underneath, and has Schedule, Export CSV and Save as PDF. The table has two columns, Label and Total.

Under the page title you'll see Ledger updated {date} at {time}: the last time anything was written to your ledger. The ledger updates itself as invoices, payments, payables and transactions change, so there's nothing to refresh.

Click any account to open its Account Register, from the start of your fiscal year to the as-of date, and see the entries that make up the balance.

What's on the balance sheet

The report has two halves: Assets, and Liabilities and Equity. Each group ends with a Total for … line, and each half with Total for Assets or Total for Liabilities and Equity.

Assets

  • Bank Accounts — every bank account connected to PayHOA, with its ledger balance. If your association has the PayHOA financial account, its balance is the Treasury Balance line here.

  • Other Assets — asset accounts you added to your chart of accounts (a reserve fund kept elsewhere, a CD, equipment), then the system accounts PayHOA keeps for you:

Line

What it is

Accounts Receivable

What owners owe on active invoices. New charges are added to it automatically, and payments take them off.

Funds in Transit

Online payments owners have made that haven't reached your bank yet. It clears when the payout lands.

Undeposited Funds

Check and cash payments you've recorded that haven't been linked to a bank deposit yet. It clears when you link them to the deposit. See Link owner payments to deposits.

How Undeposited Funds moves. When you record a check or cash payment, Accounts Receivable goes down by the amount of the payment and Undeposited Funds goes up. If the payment is ahead of an invoice or more than the owner owes, Prepaid Revenue goes up in place of Accounts Receivable going down. When you link the payment to its bank deposit, PayHOA moves the amount from Undeposited Funds to the bank account. Until then the money is counted in Undeposited Funds, not in the bank line.

How to see what is in Funds in Transit. To see which payments make up the Funds in Transit balance, click the Funds in Transit line on the balance sheet: the Account Register opens for that account. Or go to Reports → Account Register, pick a date range, choose only Funds in Transit under Select account and click Show results. Each online payment is an entry that raises the balance, and each payout that reaches your bank is an entry that lowers it; what's left is money still on its way. Funds in Transit is tracked on accrual basis, so on cash basis it isn't on the balance sheet or in the list of accounts. See Look at one account: the account register.

The balance sheet shows an amount in Funds in Transit, but clicking it shows no detail. The register that opens from the balance sheet starts on the first day of your fiscal year. Payments dated before that aren't listed row by row; they're inside the Balance before line at the top of the account. Type an earlier Start date and click Show results to see them. For a plain list of the payments still on their way to your bank, with the date each is due, go to the dashboard instead: open the deposit account's row on the Accounts card and click View details next to Upcoming deposits. See Dashboard cards. If the balance sheet amount is from payments that reached your bank long ago and it never clears, contact PayHOA's accounting support (accounting@payhoa.com or 859-249-8828) with the As of date, the amount and a screenshot of the register.

On the older accounting system: the Account Register shows no entries for Funds in Transit, whatever dates you pick, so if you ran it and got nothing you didn't do anything wrong. There, Funds in Transit isn't an account with entries behind it. The balance sheet works the figure out each time you run it, from the online payments made by the As of date whose payout hadn't reached your bank by then, and it shows on cash basis as well as accrual. To see the payments behind it, use the dashboard list above for today's figure, or the Payments filters below for a past date. You're on the older system if Reports has no Trial Balance report; see Which version am I on?

Which payments made up Funds in Transit on a past date, for example at year end for an auditor? No report lists only the payments that were still in transit on one date: the Account Register lists every payment in and every payout out for the dates you pick. To get that list, go to Payments and click Filters. Under Payment method choose Bank account and Credit card. Set Payment date to a range that ends on the date you need, and Deposit date to a range that starts the day after it and ends today; fill in both dates of each range. Click Apply filters. The list is the online payments made on or before that date whose payout reached your bank after it (some people call them unmatched or undeposited payments). To hand it to your auditor, tick the payments and click Actions → Download CSV. A payment that still has no deposit date today isn't in this list; it's on the dashboard's Funds in Transit list. If the list doesn't add up to the balance sheet figure, contact PayHOA's accounting support (accounting@payhoa.com or 859-249-8828) with the As of date, both figures and the export. See Find, filter and export payments.

Liabilities

Liability accounts you added (a loan, a credit card, money held for someone), then the system accounts:

Line

What it is

Prepaid Revenue

Money owners have paid that isn't owed yet: overpayments and other account credit, and payments made on an invoice before its active date. It comes back out when the invoice becomes active or the credit is used to pay an invoice. It only shows when it isn't $0, unless you turn off Hide $0.00 balances. The older accounting version calls this line Accounts Receivable - Prepaids. To see whose money it is and how to clear it, see Clear a balance in Prepaid Revenue below.

Accounts Payable

Bills you've confirmed in Payables but haven't paid yet, dated by each bill's invoice date. See How payables show up in your books.

Equity

On the current accounting system, equity on the balance sheet is the accounts listed here. It isn't one figure worked out as total assets minus total liabilities; only the older accounting version adds a calculated Equity line like that.

Equity accounts you added, then the system accounts:

Line

What it is

Opening Balance

The other side of starting balances. When you enter a starting balance on an account or category, or add an opening-balance invoice to a unit, the matching amount goes here. See Assets, liabilities, equity and bank accounts in the chart.

Excluded

The other side of bank transactions you excluded. Excluding a transaction keeps it off the profit and loss, but the money still moved in or out of the bank, so the amount stays in the bank account's balance (its Ledger balance on Transactions) and the other side is tracked here. See Exclude, delete or fix duplicate transactions.

Net Income

Income minus expenses from the start of the current fiscal year to the as-of date, plus any journal entries made straight to Net Income in that year.

Retained Earnings

Income minus expenses for every earlier fiscal year, plus any starting balance or journal entries on Retained Earnings.

What Opening Balance should look like. Opening Balance bridges the gap while you enter starting balances, so that assets still equal liabilities plus equity. For example, give a bank account a starting balance of $10,000.00 and Opening Balance becomes $10,000.00. Then enter $10,000.00 of starting balances on liability or equity accounts, such as a reserve fund equity account, and Opening Balance goes back to $0.00. Once every starting balance is entered it's usually $0.00, though not always, depending on the financials you brought over.

When an amount lands in Excluded. Excluding is for bank transactions that raise or lower a bank balance but shouldn't count as income or an expense. A typical example is the opening deposit into a new bank account when the old account the money came from isn't in PayHOA.

System accounts can be renamed in the chart of accounts, for example to add an account number (1310 - Accounts Receivable). The balance sheet uses whatever name the chart shows. The system equity accounts can't be deleted.

Note: The report doesn't force Total for Assets and Total for Liabilities and Equity to match, so they can differ. One known cause is a journal entry posted to an account your accounting basis hides (for example Accounts Receivable on cash basis): the other side of the entry still shows. If the totals differ and you can't see why, contact PayHOA's accounting support with the as-of date and both totals.

Cash vs accrual: lines that are hidden

Your association's accounting basis decides which system accounts appear. See Cash vs accrual, and the fiscal year.

Line

Cash basis

Accrual basis

Accounts Receivable

Hidden

Shown

Funds in Transit

Hidden

Shown

Undeposited Funds

Hidden

Shown

Prepaid Revenue

Hidden

Shown

Accounts Payable

Hidden

Shown

Opening Balance, Excluded, Net Income, Retained Earnings

Shown

Shown

On cash basis, money only counts when it moves, so there's nothing owed to or by the association to show. On cash basis, money owners paid ahead shows in the Prepayments income category on the profit and loss instead of in Prepaid Revenue. On accrual basis, Prepayments is hidden from every report. Net Income and Retained Earnings are worked out on your basis, so they differ between cash and accrual.

Net Income, Retained Earnings and the year end

  • Net Income covers the current fiscal year to date. On a balance sheet as of March 31, with a fiscal year that starts January 1, it's January through March, not just March. That's why it won't match a profit and loss for one month. Run Profit vs Loss Summary from the fiscal year start to the as-of date and Net Total should match it.

  • Retained Earnings is everything before the current fiscal year.

  • If your earlier statements used other names: what many HOA financial statements call current year surplus (or deficit), or excess of revenues over expenses, is Net Income here, and it is year to date, not one month. What they call fund balance or members' equity is the equity section: results from earlier years are in Retained Earnings, this year's is in Net Income, and a separate reserve fund balance is an equity account you add yourself. See Show the reserve fund in equity.

  • At the start of each fiscal year, last year's Net Income moves into Retained Earnings automatically. There's no year-end closing entry to make. This is how the current accounting system (Accounting V2) works; you're on it if Reports has a Trial Balance report. An equity account you added yourself for prior years' earnings isn't updated at year end; see How do I adjust a prior-years' net income or retained earnings account.

  • The split follows your fiscal year start. If you change the fiscal year start, earlier balance sheets are worked out again on the new year. See Cash vs accrual, and the fiscal year.

On the older accounting system: the year isn't closed for you. If there's no Trial Balance report on your Reports page and the Balance Sheet shows an Update now link, your association is on the older system, where the year is closed by hand with journal entries. Contact PayHOA's accounting support (accounting@payhoa.com or 859-249-8828) before your year end, give your fiscal year's end date and ask for the year-end closing steps.

PayHOA has no closing date or period lock: entries dated in a finished year can still be added or changed, and the balance sheet for that year changes with them. See Can I lock a closed month or year, or set a closing date?

Deleted accounts on the balance sheet

A deleted bank account or other account keeps showing, with (deleted) after its name, while it has a balance on the as-of date. It's left off once its balance is $0 and it had no starting balance. To clear a deleted account that still has a balance, move the balance to another account with a journal entry, or restore the account and fix it. See Assets, liabilities, equity and bank accounts in the chart.

If the balance beside (deleted) is a starting balance you typed in when you set up your books, not transactions, don't offset it with a journal entry. Go to Budgets → Chart of accounts, turn on Show deleted on the account's tab, click the account, change Starting balance to 0 and click Save changes. The label itself can't be switched off, and there's no way to reset the books and start over; see If you entered starting balances wrongly, or want to start over.

Clear a balance in Prepaid Revenue

Prepaid Revenue (called Accounts Receivable - Prepaids on the older accounting version) is owner money that hasn't been applied to an active invoice yet. It's a liability because the association is holding money for charges that haven't come due. It isn't an error, and there's no button that removes it. To find out whose money it is and bring it down:

  1. On Reports, run Prepayments by Unit with the As of date set to your balance sheet's date. It lists each unit with invoices paid ahead or unused Account Credit, and Total Prepaids. See Payment reports.

  2. For money paid ahead on an invoice, do nothing. It leaves Prepaid Revenue on the invoice's active date.

  3. For unused credit, it leaves Prepaid Revenue when it pays one of the owner's invoices. PayHOA applies credit to the next open invoice for you.

  4. If the owner shouldn't have the credit, or should get the money back, see Account credit.

Don't use a journal entry to zero the line. A journal entry changes the balance sheet but not the owner's credit, so the two stop agreeing.

The balance sheet shows a prepayment that Prepayments by Unit doesn't list, or the report's total is lower than the Prepaid Revenue line. The usual cause is a deleted unit, not a hidden or inactive one. Prepayments by Unit leaves out units that have been deleted. Deleting a unit removes its unpaid invoices, but money the unit had paid ahead and its unused credit stay in Prepaid Revenue. This happens most often when a unit was deleted after a sale and entered again as a new unit: the credit belongs to the deleted record, so it isn't on the new unit's account history either. To find it, click Prepaid Revenue on the balance sheet to open its Account Register. It's split by unit and still names deleted units, so look for a unit that isn't in your Units list, or one that's listed twice. You can't apply or refund a deleted unit's credit yourself. Contact PayHOA support with the balance sheet's As of date, the amount and the unit's name; support can find the deleted unit and restore it, and the credit can then be refunded or applied as in Account credit.

A bank account's balance or name is missing or wrong

If a bank account's balance is not showing on the balance sheet, is $0.00, or still has an old name, check these.

What you see

Why, and what to do

The bank account isn't listed

Its balance is $0.00 on the as-of date and Hide $0.00 balances is on. Turn it off.

The balance is $0.00 or too low

The account has no starting balance, or your As of date is before the starting balance's Balance as of date; the starting balance only counts from that date. See How do I change an account's starting balance?

Recent deposits or payments aren't in the balance

They're still on For review. A bank transaction only counts once it's approved. See Review and categorize transactions.

The balance isn't what the bank shows

The balance sheet shows the ledger balance, not the bank's balance. See the next section.

The account shows its old name

The balance sheet uses the account's name in the chart of accounts. Renaming a bank account on Transactions doesn't change it. Go to Budgets → Chart of accounts → Assets, click the account, change the Asset name and click Save changes.

On the older accounting system: also check that Hide from reports isn't ticked on the account in the chart of accounts, and that the account's Balance as of date is on or before your As of date; the older balance sheet leaves the account out otherwise. Then click Update now at the top of the Balance Sheet, because changes don't show until the ledger is rebuilt.

Why doesn't a bank line match my bank?

The Bank Accounts lines show your ledger balance, built from the transactions in PayHOA, not the balance your bank reports. They differ when transactions haven't been imported or approved yet, when there are duplicates, or when a starting balance is wrong. Compare the two on the Transactions page, and reconcile the account to find the difference. See Transactions overview, Reconcile a bank account and Reports: common questions.

If you've already reconciled the account and the balance sheet still shows a different bank balance, compare the balance sheet as of the statement's end date with the Register Balance on the reconciliation report. See My reconciliation balanced. Why is the bank balance on the balance sheet different?

On the older accounting system: the balance sheet shows the last daily rebuild of your ledger, and Update now next to Ledger updated rebuilds it straight away. There's no Hide $0.00 balances. Opening Balance, Excluded, Net Income, Retained Earnings and Undeposited Funds aren't listed as lines; instead a single Equity line makes the two halves balance, and accounts are listed alphabetically. See Accounting V2 and V1: what changes in your reports and chart.

Run the trial balance

The Trial balance is only on the current accounting system.

  1. On Reports, under Business Overview Reports, click Trial Balance.

  2. The report runs as of today. To see another day, pick an As of date and click Show results. You can pick a future date here.

  3. Hide $0.00 balances is on by default. Turn it off to see every account.

The results card is titled Trial balance, with As of MM/DD/YYYY, and has Schedule, Export CSV and Save as PDF. Under the page title you'll see Ledger updated {date} at {time}.

The table has Account Name, Debit and Credit, in five sections: Assets, Liabilities, Equity, Income and Expenses. The last row, Totals, adds up each column.

  • Assets, liabilities and equity show their balance from the beginning up to the as-of date.

  • Income and expense categories show only the current fiscal year to date, the same as Net Income on the balance sheet.

  • Net Income shows only journal entries made straight to it, because the year's income and expenses are already listed by category. Retained Earnings shows all earlier years.

  • Each account shows on its normal side: assets and expenses as debits, liabilities, equity and income as credits. A negative balance moves to the other column.

  • The same cash and accrual rules apply. On cash basis the trial balance also hides the Account Credits and Bad Debt categories; on accrual it hides Prepayments.

  • Deleted accounts with a balance show with (deleted). Deleted accounts with $0 are left off.

Click an asset, liability or equity account to open its Account Register from the start of the fiscal year to the as-of date. Clicking an income or expense category opens the Account Register page without that category picked; choose it under Select account yourself, or click the category on a profit and loss report.

Troubleshooting

Problem

What to do

Accounts Receivable or Accounts Payable is missing

Your association is on cash basis, or the balance is $0 and Hide $0.00 balances is on.

Undeposited Funds keeps growing

Check and cash payments haven't been linked to the bank deposits they went into. See Link owner payments to deposits.

Undeposited Funds or Funds in Transit is negative

More was taken out of the account than was put in. That usually means a bank deposit was linked as owner payments (or came in as a payout) for more than the payments recorded in PayHOA by that date. Open the account's Account Register to find the deposit. If you can't, contact PayHOA's accounting support with the as-of date and the amount.

I opened the Account Register for Funds in Transit and it's empty, or I need the payments behind the balance

Check the dates first: the register that opens from the balance sheet starts at your fiscal year start. On the older accounting system the register has no entries for this account at all. For a list of the payments on a past date, filter Payments by payment date and deposit date. See How to see what is in Funds in Transit under Assets above.

Undeposited Funds shows on our balance sheet although we're on cash basis

PayHOA's own Undeposited Funds account is hidden on cash basis. Check Preferred Accounting Method: under Settings (the gear icon at the top right) → Preferences; if it says Accrual, the line is expected. If it says Cash, the line is an asset account with that name that someone added on Budgets → Chart of accounts → Assets: click the line to open its Account Register and see the entries posted to it. If neither explains it, contact PayHOA's accounting support with the as-of date and a screenshot.

A new line has appeared on the balance sheet that wasn't on earlier reports, for example Due to Reserve and Due from Operating

An account is listed once it has a balance on the As of date; with Hide $0.00 balances on, empty accounts are left off, so a line appears the first time something is posted to it. The only lines PayHOA adds by itself are the system accounts described in this article. Any other line is an account someone added on Budgets → Chart of accounts. Click the line to open its Account Register: each entry shows its Recorded Date and Recorded By, and the Reference link opens the journal entry or transaction behind it. A pair of due to and due from accounts with the same amount is the usual way books show money one fund owes another, such as operating owing reserves; PayHOA doesn't create or fill those accounts, so the entries were posted by one of your admins or your bookkeeper, usually as a journal entry.

A deleted bank account still shows

It still has a balance on the as-of date. See Deleted accounts on the balance sheet above.

Net Income doesn't match my monthly profit and loss

Net Income is fiscal year to date. See Net Income, Retained Earnings and the year end above.

Last year's net income on the profit and loss (income statement) doesn't match Equity or Net Income on the balance sheet

They aren't the same figure. On the current accounting system, run the balance sheet as of the last day of that fiscal year: Net Income then matches the P&L's Net Total for the year, and total equity also holds Opening Balance, Excluded, Retained Earnings and your own equity accounts. On the older accounting system the single Equity line is calculated as assets minus liabilities over your whole history, so it never equals one year's net income. See Why doesn't last year's net income on my P&L match Equity or Net Income on my balance sheet?

Our CPA says the general ledger has no equity accounts

On the current accounting system the General Ledger lists equity under Equities, but Net Income and Retained Earnings are worked out from income and expenses, so only entries posted straight to them show there. See Where is equity?

Numbers changed since I last ran it

Something dated on or before the as-of date was added, edited, deleted or recategorized since. Open the account's Account Register to see what changed.

The balances were right and are now badly wrong, or accounts have lost their starting (opening) balances

If nothing was entered that explains it, this needs PayHOA: contact PayHOA's accounting support straight away with the as-of date, one example account, the balance you expect and a screenshot, and don't re-enter starting balances. See My balances were right and are now wrong.

The bank line doesn't match my bank statement

The balance sheet shows the ledger balance on the as-of date, not the bank's. See Why doesn't a bank line match my bank? above and Why doesn't this report match my bank statement?

An account shows (deleted) and its balance is a starting balance

Set that account's Starting balance to 0 in the chart of accounts (turn on Show deleted). See Deleted accounts on the balance sheet above.

Does PayHOA produce an audited balance sheet or an audit report?

No. PayHOA doesn't perform audits; give your auditor the Audit Prep report packet. See Does PayHOA provide an audit or an audit report?

There's no Trial Balance tile

Your association is on the older accounting system.

There's no Update now

Your association is on the current accounting system, where the ledger is always up to date.

I was told to click Update now, Update Reports or Update General Ledger and can't find it

Those refresh the ledger on the older accounting system only. On the current system the balance sheet is up to date each time you run it, so there's nothing to click. If a number still looks wrong, see My general ledger or balance sheet didn't update.

A bank account's balance is missing, $0.00 or under an old name

See A bank account's balance or name is missing or wrong above.

There's an amount in Prepaid Revenue (or Accounts Receivable - Prepaids) I want to remove

It's owner money paid ahead or unused credit. See Clear a balance in Prepaid Revenue above.

The balance sheet doesn't match my bank reconciliation

Run it as of the statement's end date and compare the bank line with the reconciliation report's Register Balance. See Reports: common questions.

What's next

Did this answer your question?