Skip to main content

Billing

How to View a Profit and Loss Overview in Invoice Office

View your profit and loss in Invoice Office — see revenue, costs and gross margin by period, ledger account or product category for quick financial insights.

Updated 5 min read

To see a profit and loss overview in Invoice Office, open the Profit and loss report under Finance. This P&L report shows your revenue, cost and profit for the period you choose, compares them with earlier years, and lists the amounts per ledger account. You can export it as Excel, CSV or PDF for your accountant.

This guide covers where to find the report, how to read it, how to change the period, and how to export it. For a month-by-month board of charts, use the finance dashboard.

Step 1 — Open the report

Go to Finance → Profit & loss. You can also open it from Dashboards → Finance → Profit & loss.

The Finance menu in Invoice Office with the columns Reports and Transactions; under Reports, Profit & loss is outlined in red

The report opens on the Current year. It needs the rights to view reports and finance, so ask the account owner if you can’t see it.

Step 2 — Read the four key figures

The tiles at the top give you a quick financial overview of the selected period:

  • Revenue — what you earned.
  • Cost — what you spent.
  • Profit — revenue minus cost. When it is negative, the tile is called Loss.
  • Profit margin — profit as a percentage of revenue.
The Profit and loss report in Invoice Office with the tiles Revenue €133,500.00, Cost €99,550.00, Profit €33,950.00 and Profit margin 25.43%, each compared with 2025, above a monthly Revenue chart and a Revenue chart per ledger account

Each tile compares the figure with the same period last year, so the same months and days. Below the tiles, this revenue and cost report charts your revenue and cost per month and per ledger account, the profit margin, and a Three year trend. Use Table, PNG or CSV under a chart to see or download its figures. Customize lets you hide the tiles, charts and tables you don’t need.

Step 3 — Choose the period

Click the period button, Current year by default, and choose a period such as Last quarter, Last year or Last 12 months. The tiles, charts and tables all follow it.

The period menu open on the Profit and loss report, listing Current Month, Current week, Last Month, Last week, Current quarter, Last quarter, Current year, Last year, Last 12 months and Year to date; the period button is outlined in red

For exact dates:

  1. Click Filter options.
  2. Set the Date range.
  3. Click Apply. Save and apply saves it under a name in the period menu.
The Filter options window with Date range set to Current year, from 01-01-26 to 30-10-26; the Apply button is outlined in red

The period is the only filter. You can’t filter the report on one ledger account or a group of accounts, but the next step shows where to find them.

Step 4 — See the amounts per ledger account

The Profit and loss table lists your ledger accounts under Revenue and Cost, with a total for each and your Profit or Loss at the bottom.

The Profit and loss table with Revenue accounts Product sales, Services and Hosting, Cost accounts Purchases, Salaries, Rent, Software and Travel, totals and a Profit row for 2024, 2025 and 2026; the Export menu is open on PDF, Excel and CSV and the Export button is outlined in red

Compare the columns with care. The last column covers the period you selected. The two columns before it always show the full calendar year. So in October, your current year isn’t complete yet while last year’s column is.

The headings use the year your period starts in. With Last 12 months, the last column carries last year’s label, and the two earlier columns move back a year.

Two options above the table change what you see:

  • Show ledger account zero also lists accounts without an amount. Tick it, then click Filter options → Apply.
  • Show account code shows or hides the Ledger account code column.

To look closer at an account:

  • Turn on Show account code, then click the code to open the ledger account report for that account.
  • Click the magnifying glass beside the name to see the journal entries behind the amount.

Step 5 — See revenue per product category

Further down, Revenue per income category breaks your revenue down by product category. It shows the categories that are linked to a ledger account with bookings in the period.

The Revenue per income category table with Furniture €41,200.00, Electronics €18,800.00, Accessories €16,400.00 and Lighting €12,560.00 on the Product sales ledger account, and a total of €88,960.00

Step 6 — Export the P&L for your accountant

  1. Choose the period first. The export follows the period on your screen.
  2. In the Profit and loss table, click Export.
  3. Choose Excel, CSV or PDF.

Excel and CSV list each ledger account, its code and its amount for the selected period. The PDF also shows totals and the date range. No file includes the two earlier years, the tiles or the charts. To include accounts without an amount, apply Show ledger account zero first.

For the bookings behind these figures, see journals and ledger accounts. Any doubts? Contact us and we will help.

Was this article helpful?

If something is missing or did not work as described, tell us and we will fix the article.

Try it in Invoice Office

Create a free account to follow these steps yourself, or log in if you already have one.