Understanding the Profit & Loss Statement in Simple Books

Introduction

The Profit & Loss Statement in Simple Books summarises income and expenses from accounting journals for a chosen reporting period. It uses the net Sales Revenue posted by invoices and the expense-account postings created by supplier bills, business expenses and mileage claims, then subtracts total expenses from total income.

This guide documents that calculation exactly as it is currently implemented. It focuses on the accounts included, the debit and credit treatment, date filtering, report states and present limitations. For the detailed mechanics of individual postings, use the linked double-entry bookkeeping guide rather than treating this summary report as a source-entry page. This is general product guidance, not accounting or tax advice.

What a Profit & Loss Statement is

A Profit & Loss Statement, often shortened to P&L, reports income and expenses over a period and shows the resulting profit or loss. It is a performance report rather than a list of assets and liabilities at one point in time.

The current Simple Books page presents four summary cards—Revenue, Expenses, Net Profit or Net Loss, and Status—followed by a financial statement containing Income rows, Total Income, Expense rows, Total Expenses and the net result. A positive result is labelled Net Profit, a negative result Net Loss, and a zero result with financial activity Break-even.

If the selected journal set contains no Income or Expense account activity, the page shows No data. It does not treat balance-sheet-only activity as a zero-profit statement.

Why businesses use a Profit & Loss Statement

A P&L helps a business review financial performance for a period. In the current report, it can help you:

see the net Sales Revenue recorded through invoice journals;
review costs grouped into the available expense accounts;
compare total income with total expenses;
identify whether the selected journal period produced a profit, loss or break-even result; and
choose an account for deeper investigation in the General Ledger.

A P&L reports what the journals contain. A calculated profit does not confirm that every transaction, category, date or VAT treatment is complete and correct.

How Simple Books calculates Profit & Loss

Simple Books loads the authenticated user’s saved journals, validates the complete journal set, applies the optional reporting dates, and builds Trial Balance-style account totals from the journals inside the selected period. It then selects only accounts whose chart type is Income or Expense.

For each included account, the current formulas are:

Income account amount = account credits − account debits.
Expense account amount = account debits − account credits.
Total Income = sum of all included Income account amounts.
Total Expenses = sum of all included Expense account amounts.
Net result = Total Income − Total Expenses.

Amounts are rounded to two decimal places. Contra or reversal activity is respected: a debit to an Income account reduces its reported income, while a credit to an Expense account reduces its reported expense. An abnormal negative account amount is displayed in accounting parentheses.

Income accounts currently included

The current chart of accounts contains one Income account: 4000 Sales Revenue. Sales invoice journals credit this account for the invoice’s net amount. Where an invoice contains active line items, Simple Books can create separate Sales Revenue journal lines for those item descriptions, but they all accumulate into account 4000 for Profit & Loss.

The gross invoice total is not reported as revenue. The gross amount is debited to Trade Receivables, while VAT greater than zero is credited separately to VAT Output. Trade Receivables is an Asset and VAT Output is a Liability, so neither is selected for the P&L.

Invoice Paid or Unpaid status does not control inclusion. The report reads the saved sales journal and its journal date; current payment-status actions do not replace that journal or add a receipt entry.

Expense accounts currently included

The current Expense accounts are:

5000 General Expenses for unmatched bill and expense categories;
5200 Travel & Mileage for travel, mileage and related mapped categories;
5300 Utilities;
5400 Professional Fees; and
5500 Software & Subscriptions.

Supplier bills debit the mapped Expense account for their net amount. Ordinary expenses do the same. Mileage claims debit Travel & Mileage for the full calculated claim amount and have no VAT journal line.

Where a bill or expense contains VAT, VAT Input is debited separately and is excluded from P&L because it is an Asset account. Trade Payables and Employee Reimbursements Payable are also excluded because they are Liabilities. The report therefore uses net bill and ordinary-expense costs, but the full mileage claim.

Gross profit and net profit calculations

The current Simple Books Profit & Loss report does not calculate or display a separate Gross Profit subtotal. The chart has no Cost of Sales account type or cost-of-sales section, and the statement does not classify some expenses as direct costs before other operating expenses.

The implemented result is:

Net Profit or Loss = Total Income − Total Expenses.

If the result is greater than zero, the page labels it Net Profit and shows status Profit. If it is below zero, the absolute amount is displayed under Net Loss and the status is Loss. Exactly zero with Income or Expense activity is labelled Break-even.

Do not confuse this result with project Gross profit, which is an operational project calculation based on allocated gross transaction values, or with the Dashboard’s monthly Difference line. Those pages use different data and rules.

Date filtering and reporting period behaviour

Date From and Date To are optional, inclusive journal-date filters. Date From includes journals on or after its calendar date. Date To includes journals on or before it. With both fields blank, Simple Books uses all loaded journals. After changing either date, select Refresh.

Date From must be on or before Date To. An invalid range shows Check dates, leaves the totals blank and asks you to adjust the filters. Journal dates use their written YYYY-MM-DD calendar date without timezone shifting.

Before applying the chosen period, Simple Books validates every loaded journal and checks that every journal has a valid calendar date. A malformed journal outside the selected period still makes the report unavailable. This prevents an invalid record from being hidden by the date filter and producing apparently complete partial totals.

If the in-range journals contain no Income or Expense activity, the page shows No data even if they contain valid Asset, Liability or Equity postings.

Relationship to the General Ledger

The General Ledger uses the same saved journals but displays the individual debit and credit lines for one selected account. Profit & Loss groups those lines into account totals and includes only Income and Expense chart types.

To investigate a P&L row, open the General Ledger and select its corresponding account, such as Sales Revenue, Utilities or Software & Subscriptions. Use matching Date From and Date To values so both reports examine the same journal period.

The current P&L statement displays account names and amounts as plain text. It does not provide direct account-code links into the General Ledger. The General Ledger’s filtered running balance also starts at zero for the in-range journals, while the P&L uses the same in-range account movements to calculate its period amount.

Relationship to the Trial Balance

The Trial Balance accumulation is the calculation foundation for Profit & Loss. For the filtered journals, Simple Books totals debits and credits by account. Profit & Loss then selects the Income and Expense accounts from those balances and applies its account-type sign rules.

An Income account’s Trial Balance-style net is debits minus credits, but P&L reports Income as credits minus debits so ordinary credit revenue appears positive. An Expense account already has the debit-oriented amount needed by P&L: debits minus credits.

The current Trial Balance has no date filter and uses all loaded journals. Profit & Loss can use a date range, so the figures should only be compared directly when their journal scope is equivalent.

Relationship to the Balance Sheet

The Balance Sheet builds from journals up to an optional inclusive As at date. It lists Asset, Liability and Equity accounts rather than displaying Income and Expense accounts directly.

For the same Balance Sheet journal set, Simple Books runs the Profit & Loss calculation and adds its net result to displayed equity as Current Year Profit or Current Year Loss. A £500 P&L profit therefore increases displayed total equity by £500; a loss reduces it.

To compare the reports, set Profit & Loss Date To to the Balance Sheet As at date and leave Date From blank. That gives both reports journals from the beginning of the available data through the same reporting date.

Why Profit & Loss and Dashboard figures differ

The operational Dashboard does not calculate accounting profit. Its Income vs Bills chart uses gross invoice totals and gross bill totals, includes every payment status, excludes expenses and mileage, and labels the difference between those two series Difference.

Profit & Loss instead reads journals, uses net invoice revenue, includes the net expense portions of bills and ordinary expenses, includes the full mileage claim, and excludes VAT Input and VAT Output. Paid status does not determine P&L inclusion. These deliberate differences mean Dashboard Difference and P&L Net Profit should not be expected to match.

The Dashboard guide documents its operational calculations in detail; use that guide rather than treating the Dashboard chart as a financial statement.

Worked examples

Invoice, bill, expense and mileage in one period

A consultant saves a £600 sales invoice made up of £500 net and £100 VAT. They also save a £240 Software supplier bill made up of £200 net and £40 VAT, a £120 Utilities expense made up of £100 net and £20 VAT, and a £45 mileage claim.

Sales Revenue: £500 income from the invoice journal.
Software & Subscriptions: £200 expense from the bill journal.
Utilities: £100 expense from the ordinary expense journal.
Travel & Mileage: £45 expense from the mileage journal.
Total Income: £500.
Total Expenses: £200 + £100 + £45 = £345.
Net Profit: £500 − £345 = £155.

The £100 VAT Output and combined £60 VAT Input do not appear in P&L. Nor do the gross Trade Receivables, Trade Payables and Employee Reimbursements Payable postings.

Date range excludes an earlier invoice

The same business also has a £300 net invoice dated 30 June. With Date From set to 1 July and the four July records above inside the period, the earlier £300 Sales Revenue is excluded. Total Income remains £500 and Net Profit remains £155. With Date From blank, the earlier invoice is included and the result rises by £300, assuming no other activity.

Net loss

In another period, Sales Revenue is £100 and the included expense accounts total £240. Simple Books calculates £100 − £240 = minus £140, labels the result Net Loss, displays £140.00 and gives the report status Loss.

Dashboard Difference is not the P&L result

Using only the £600 gross invoice and £240 gross bill above, the Dashboard chart Difference is £360. It ignores the £120 ordinary expense and £45 mileage claim. Profit & Loss uses £500 net revenue less £200, £100 and £45 of expenses, giving £155. The reports differ because their sources and calculations differ.

Common mistakes

Using gross invoice totals as P&L income. The report uses the net Sales Revenue journal credit and excludes VAT Output.
Expecting VAT Input to be an expense row. It is currently an Asset account; bills and ordinary expenses contribute their net expense posting.
Calling Dashboard Difference profit. It uses gross invoices and bills and omits expenses and mileage.
Expecting a separate gross-profit subtotal. The current report calculates only Total Income, Total Expenses and the net result.
Comparing reports with different dates. Match the journal period before investigating a difference.
Expecting Paid status to control inclusion. The report reads journals, and current status actions do not post settlement entries.
Recording one cost as both a bill and an expense. Each source can create its own expense journal and duplicate the P&L cost.
Deleting a source to remove its accounting effect. Current delete workflows do not reverse or delete the linked journal.
Ignoring a ledger-posting warning. A saved operational record whose journal write failed is absent from P&L.

Current implementation limitations

No gross-profit or cost-of-sales section: all current Expense accounts feed Total Expenses before the single net result.
One Income account: the current chart includes Sales Revenue only.
No direct General Ledger drill-down: P&L account rows display names and amounts but are not links.
No manual journals or opening-balance workflow: the current user interface does not provide those posting tools.
No P&L export, print, comparative-period or budget columns: the current page displays one selected journal period.
Payment status does not post settlement: marking an invoice, bill or expense Paid does not create Bank entries or clear receivables, payables or reimbursements.
Deletion does not reverse journals: deleting an invoice, bill, expense or mileage source does not currently create a reversal or remove its linked journal, so its income or expense can remain.
A journal write can fail after its source is saved: the operational record can exist while being absent from journal-based P&L.
No partial result for malformed data: an invalid loaded journal or invalid journal date makes the complete report unavailable, even when it falls outside the selected period.

Summary

The Simple Books Profit & Loss Statement validates the user’s journals, applies an optional inclusive reporting period, accumulates Trial Balance-style account totals, selects Income and Expense accounts, and calculates Total Income minus Total Expenses. The current Income account is Sales Revenue; expenses can appear in General Expenses, Travel & Mileage, Utilities, Professional Fees and Software & Subscriptions.

Use the General Ledger to inspect the postings behind a named row, the Trial Balance to understand the wider account set, and the Balance Sheet to see the net result included in displayed equity. Keep the present boundaries in mind: there is no separate gross-profit subtotal, no direct ledger drill-down, no manual-journal workflow, and current payment, deletion and failed-write behaviour can leave journal-based figures different from operational records.