Profit and Loss Statement: Auto-calculates income per property, per owner
Quick Links
What can the Profit and Loss Statement do for you?
The Profit and Loss Statement summarizes all income and expenses within a period to calculate net profit. Income from rent, utilities, fees, cleaning, etc., is automatically categorized and totaled from daily entries – no need for manual spreadsheets.
Find out how much an owner earned in the first half, whether a property profited or lost this quarter, or see full-year finances before tax by setting conditions and clicking a button.
How to Use
Step 1: Set report parameters
Access the report page from the feature list (click 'Reports' in the left menu, then select a report), and set the following conditions:
- Report Type: Select Income Statement.
- Choose Property/Owner/Company: Decide the scope of the report: focus on a single property, all properties under an owner, or the entire company's finances.
- Report Period: Freely choose start and end dates; not limited to full year or month. View a specific lease period, quarter, or custom range.
- Accounting Basis: Select Cash or Accrual basis; differences described in the next section.
How to choose between Cash and Accrual basis?
The same rent can appear in different periods on reports, depending on the accounting method used:
- Cash Basis: Based on the actual receipt date. The money's actual entry or exit date determines the period it is reported in. Choose Cash Basis to view actual cash flow.
- Accrual Basis: Based on the due date of receivables. Transactions are recorded in the period corresponding to the invoice date, irrespective of the cash flow. Choose Accrual Basis to view true performance over periods.
Step 2: Generate Report
Click to generate a report. The system will create a profit and loss statement divided into three sections:
- Income: All income items and amounts for the period, such as rent income, utility fee income, service fee income, cleaning fee income, totaled as Total Income.
- Expenses: All expense items and amounts for the period, totaled as Total Expenses. If there are no expense records for the period, it will display 'No records for this period.'
- Net Income This Period: Total income minus total expenses gives the profit or loss for this period.
Click the print icon at the top right of the report to print directly or save as PDF for accountants or owners.
Where do the report figures come from?
The Profit and Loss Statement requires no extra data entry; amounts are derived from two types of records you usually input into the system:
- Tenant Billing Cycle: Each charge in the lease billing cycle such as rent, utilities, and miscellaneous fees is automatically categorized into corresponding income or expense lines.
- Manual Journal Entry: Income and expenses outside the billing cycle (e.g., repair costs, insurance, depreciation) are recorded via manual journal entry and automatically included in reports.
In other words, keep regular entries to have an up-to-date Profit and Loss Statement without needing end-of-period adjustments.
FAQ
Why do cash and accrual report amounts differ?
This is normal. The two bases attribute the same transaction to different periods: cash basis considers the actual transaction date, while accrual basis considers the billing period the transactions belong to. If payments span different periods (e.g., late rent, prepaid amounts), the amounts in individual reports will differ, but the totals over time will match.
Can I view reports for a specific owner or property?
Yes. The filter dropdown allows you to select a single property, owner, or company. For property managers reporting to owners, simply select the respective owner to generate the reports.
What is the difference between an income statement and a balance sheet?
They differ in time perspective. An income statement shows operational results over a period, like a film (e.g., income and expenses from January 1 to June 30). A balance sheet is a financial snapshot at a specific point, like a photo (e.g., assets and liabilities on June 30). To see if you were profitable over six months, check the income statement; to see how much tenant money you hold or asset structure, check the balance sheet.
Why aren't deposits and prepaid electricity in the income statement?
Because these belong to tenants, not your revenue. Deposits are returned at lease end; prepaid electricity is held to offset future bills, bypassing monthly calculations. Any remaining balance is refunded upon move-out. Thus, initially, these are liabilities on the balance sheet, not the income statement. Only when offset against actual expenses do they appear as income for that period's income statement.