The profit and loss reports show what your association earned and spent over a period: income by category, expenses by category, and the difference. There are four. Use Profit vs Loss Summary for the board, Profit vs Loss by Month to see the trend, Profit vs Loss Detail to find out why a number is what it is, and Profit vs Loss as Percentage of Income to see where each dollar goes.
Before you start: you need Reports access. Picking dates, exporting and scheduling work the same as on every report. See Run, filter, export and favorite a report.
Note: There's no report called "Income Statement" or "Statement of Revenue and Expenses". Profit vs Loss Summary is that report. Its title can't be changed.
The four reports
All four are in the Business Overview Reports section of Reports.
Report | Opens on | What it shows |
Profit vs Loss Summary | This month | One total per income and expense category. Turn on Compare to another date range for a second column. |
Profit vs Loss by Month | This FY | One column per month in the range, then a Total column. |
Profit vs Loss Detail | This FY | Every entry behind each income and expense category, with date, description, debit and credit. |
Profit vs Loss as Percentage of Income | This FY | Each category's total and its % of Income. |
Each report has Starting date and Ending date, the date chips, Hide $0.00 balances (on by default) and Show results. They run as soon as you open them, and again whenever you click a date chip.
Run the Profit vs Loss Summary
On Reports, click Profit vs Loss Summary.
Pick the range: a chip such as This year or Last FY, or type a Starting date and Ending date.
To leave out categories with nothing in them, keep Hide $0.00 balances on. Turn it off to list every category.
Click Show results.
The report has two columns, Category and Total, and these sections:
Income — your income categories, with subcategories under their parent. Then Total Income.
Expenses — your expense categories. Then Total Expenses.
Net Total — Total Income minus Total Expenses. A negative number means you spent more than you took in.
Click a category to open its Account Register for the same dates and see every entry in it.
Compare two periods
Turn on Compare to another date range.
The first range becomes First date range, and a Second date range appears. PayHOA fills in the neighboring period: Last month when the first range is This month, Last year for This year, Last FY for This FY (and the other way round). Change it if you need to.
Click Show results.
The report adds a second total column headed with the second range's dates, and the subtitle shows both ranges.
Run the other three
Profit vs Loss by Month puts each month of the range in its own column, so you can spot a month that's out of line. Wide ranges are easier to read as a PDF or in the CSV.
Profit vs Loss Detail lists every entry posted to each income and expense category: the Entry Date, Description, Recorded Date, Recorded By, Reference, Debit, Credit and Balance. This is the report to use when a total doesn't look right. Each line tells you which invoice, payment, payable, transaction or journal entry it came from.
Note: The Balance column on Profit vs Loss Detail is a running balance for the category. It starts at $0 on your Starting date and doesn't carry in earlier periods, so the last balance under a category is its total for the range and matches Profit vs Loss Summary for the same dates.
Profit vs Loss as Percentage of Income shows each category's total and what percentage of Total Income it is. Total Income is always 100%. The percentages only appear when total income for the range is more than $0; otherwise the report says No income to report in selected range.
What counts on the profit and loss
The profit and loss reports read your ledger. A dollar shows up only once it's in the ledger with an income or expense category.
Counts | Doesn't count |
Approved bank transactions with an income or expense category | Transactions still on For review, and uncategorized ones |
Journal entries to an income or expense category | Transfers between your own accounts |
Payables (bills), once — the bill and its payment aren't counted twice | Excluded transactions |
Owner invoices and payments, depending on your basis (below) | Deleted invoices, and payments that failed or were returned |
System categories such as Platform Fees, Discounts and Bad Debt when they have entries | Money moving between balance-sheet accounts, such as reserve contributions recorded as transfers |
A deleted or returned item isn't erased. PayHOA records a reversing entry on the date it changed, so the total for the original period can change. You'll see both entries on Profit vs Loss Detail.
Cash or accrual
Your association uses one basis for every report. See Cash vs accrual, and the fiscal year.
Cash basis | Accrual basis | |
Owner income | When the money reaches your bank, on the date of the approved bank deposit it arrived in, in the invoice's income category. If the invoice isn't active yet on that date, the money waits in Prepayments and moves to the income category on the invoice's active date. | When the invoice becomes active, on its invoice date (not its due date) |
Payables | When the bill is paid | When the bill is confirmed, on its invoice date |
Bank transactions and journal entries | On their own date | On their own date |
So the same month can show different income on each basis. On accrual, a year of dues invoiced on January 1 all shows in January.
Important: On cash basis, a check or cash payment you recorded doesn't count as income until it's linked to a bank deposit and that deposit is approved on Transactions. A recorded payment that's never linked to a deposit never reaches the profit and loss. See Link owner payments to deposits.
Prepayments and "Uncategorized Account Credits"
On cash basis, money an owner pays when there's no open invoice for it (an overpayment, a payment ahead of the next invoice, or a payment whose invoice was deleted) has no income category yet. It shows on the profit and loss under Prepayments, dated by the bank deposit it arrived in. When that credit is later applied to an invoice, it moves out of Prepayments and into the invoice's income category, on the later of the deposit date and the invoice's active date. Prepayments never appears on accrual basis. On the older accounting system the same line is called Uncategorized Account Credits.
To see which units have that money, run Prepayments by Unit. See Payment reports and Reports: common questions.
Which report shows what makes up Prepayments? The two reports answer different questions. Profit vs Loss Detail lists the entries behind the Prepayments line, with the date each prepayment was deposited, but only entries dated inside the date range you picked. Prepayments by Unit lists every unit that holds a prepayment or unused credit on its As of date, whenever that money came in. So use Profit vs Loss Detail to explain the Prepayments amount for a period, and Prepayments by Unit to see who holds credit now.
Don't delete a paid invoice to make the line go away. That turns the payment into a credit and adds to it.
On the older accounting system: the profit and loss reports work the same way, but bank deposits only count as income on accrual basis when the transaction is marked Outside Revenue. Profit vs Loss by Month refuses ranges over 10 years with That date range is too long. This report shows a column for every month, so please choose a range of 10 years or less. See Accounting V2 and V1: what changes in your reports and chart.
When the profit and loss doesn't match the bank
The profit and loss isn't a bank statement: it leaves out transfers and counts income on your basis's dates. Work through these in order:
Unreviewed transactions. Anything still on For review isn't counted. See Review and categorize transactions.
Transfers recorded as income or expense. A move between your own accounts should be a transfer. See Record transfers between accounts.
A bill counted twice. If a payable was paid and the bank transaction for it was also given an expense category, the expense appears twice. See How payables show up in your books.
Excluded transactions. Excluded rows never count. See Exclude, delete or fix duplicate transactions.
Basis and dates. On accrual, owner income is dated by the invoice, not the deposit. On cash, it's dated by the bank deposit the payment arrived in, so a payment made on the 30th that's deposited on the 2nd counts in the next month.
Recorded checks never linked to a deposit (cash basis). They aren't income until they're linked to an approved deposit. See Link owner payments to deposits.
A bank transaction that never reached PayHOA. Income the bank posted, such as interest, isn't on the profit and loss or the Account Register if the transaction didn't come in from the bank; search Transactions for the amount, and see A transaction is missing.
Returned owner payments. The bank statement shows the deposit and a separate withdrawal for the return; on cash basis, the profit and loss takes the returned amount back out of income instead, so total income is lower than the statement's deposits. On accrual, the income was counted when the invoice became active, so a return reopens the invoice and doesn't change income. See My P&L doesn't match my bank.
Then run Profit vs Loss Detail for the same range and look at the category that's off. To see a bank account's balance, use the Balance Sheet instead. See Balance sheet and trial balance.
Troubleshooting
Problem | What to do |
A category is missing | It probably has $0 in the range. Turn off Hide $0.00 balances. |
Dues income is lower than expected, or short by one unit's assessment | On accrual, income is what was invoiced in the range. Click the income category to open its Account Register and look for a unit with no invoice or a deleted one. See My dues income is lower than I expected. |
Income or an expense is in the wrong year | |
A transaction is in the bank account's register but not on the profit and loss or in the category's register | Check the dates first: Profit vs Loss Summary opens on This month, while Profit vs Loss Detail opens on This FY, so it can be on the detail and missing from the summary. Then check whether it's a transfer, excluded, split, or a bill payment whose expense counted on the bill's invoice date. See Where is the other side? |
A category shows (deleted) | It was deleted from the chart of accounts but still has an amount in the range. Its history stays on your reports, and the label can't be switched off; the line goes once its amount for the range is $0.00. If the amount is transactions, recategorize them. If it's a starting balance entered on the category by mistake, set that starting balance to 0 in the chart of accounts (turn on Show deleted). This isn't the same as a deleted transaction on the general ledger. See Troubleshooting in the categories article. |
Income went up, or doubled, after I linked payments to deposits | On cash basis a recorded check counts as income only once it's linked to an approved deposit, so a rise by the amount linked is expected. More than that means the same money is in your books twice, usually a deposit that also has an income category of its own. See My income went up (or doubled) after I linked payments to deposits. |
The profit and loss doesn't match my bank statement | It isn't meant to: it leaves out transfers and counts income and expenses on your accounting method's dates. See When the profit and loss doesn't match the bank above and Why doesn't this report match my bank statement? |
I recategorized a transaction and the old category still shows | Open Profit vs Loss Detail and find the transaction. If the old line is still there with no reversal, the transaction may be split, or the change didn't save. See Reports: common questions. |
Last year's numbers changed | Something dated in that year was added, edited, deleted or recategorized after you first ran the report. Run Profit vs Loss Detail for that year and compare. |
Please select a second date range. | Compare to another date range is on and the second range is empty. Fill it in or turn the toggle off. |
For other messages, see the troubleshooting table in Run, filter, export and favorite a report.
