Skip to content

Profit & Loss by Period

Published: · Updated: (12 days ago)· IZI Team

A P&L report answers one question: did the club make money in this period, and how much is left after expenses? IZI covers the full revenue side. You add the cost and expense data your accounting tool holds, and the result is a complete operating picture.

For day-to-day management, a monthly P&L is the right cadence — it matches rent cycles and purchasing. Quarterly works for tax purposes. If you want to track trends, export IZI data monthly and keep a rolling spreadsheet.

Pick the range: week, month, or quarter. All IZI data is shift-based, so a period is simply the sum of shifts that fall within it.

Revenue data comes from Shift History (see Shift Z-report for how each shift is structured).

In Shift History, set start and end dates, then sum across all shifts:

MetricWhere to find it
Accrual revenue”Accrual revenue” line on each shift
Sessions”Sessions” category in the Z-report
Bar”Bar” category
Combo”Combo” category
Refunds”Refunds” line — subtract this

Revenue for the period = sum of (Charges − Refunds) across all shifts.

Bar COGS is the purchase cost of goods actually sold.

Formula:

COGS = Purchases in period − (Closing inventory − Opening inventory)

Accurate COGS requires cost prices set on every product in the warehouse. Without them, COGS shows as zero and gross profit is overstated. See Expenses tracking for how to configure this.

IZI does not track operating expenses in the current version. Bring in the following from your own records:

Expense categoryData source
RentLease agreement
PayrollTimesheets, pay slips
Bar purchasesSupplier invoices
Internet and utilitiesBills
Equipment maintenanceService receipts
Licenses and subscriptionsIncluding IZI license
Revenue (from IZI)
− Bar COGS
= Gross profit
− Payroll
− Rent
− Internet and utilities
− Other expenses
= Operating profit (club EBITDA)
LineSource
Revenue: sessionsIZI → Sessions category
Revenue: barIZI → Bar category
Total revenueSum of lines
Bar COGSPurchases data
Gross profitRevenue − COGS
PayrollYour own data
RentYour own data
OtherYour own data
Operating profitFinal result
  • Rent
  • Salaries and payroll
  • Fixed asset depreciation
  • Taxes

Export the revenue data from IZI, then add these items in your spreadsheet or accounting tool to get a complete P&L.

Monthly is optimal for club management. Quarterly for tax reporting. To track trends over time, export from IZI each month and maintain a rolling history table.

Frequently asked questions

Can I export IZI data to Excel?

Yes. From Shift History and Analytics you can export to CSV or Excel. Set your date range and click Export.

Should I use accrual revenue or cash receipts?

Use accrual revenue (charges). Revenue is recognized when a session or bar sale occurs, not when the customer tops up. Top-ups are liabilities until redeemed. Revenue for the period = Charges - Refunds across all shifts.

Why does IZI revenue differ from my bank statement?

IZI uses the accrual method; your bank records cash received. Part of revenue may be paid with bonus points — IZI shows it as revenue, but no cash changes hands. For P&L purposes, always use IZI accrual revenue.