Compare Profit and Loss Across Periods

Why a single profit and loss figure hides the story

A profit and loss statement for one month tells you whether the business made money. It does not tell you whether that is better or worse than usual, or why. Most owners and managers only find out how a month compared when the accountant sends the year-end pack, or when they rebuild the comparison in a spreadsheet themselves.

Rebuilding it takes time and introduces mistakes. Two exports are pasted side by side, accounts that appear in one period and not the other break the alignment, and the percentage changes are calculated with formulas that nobody checks. The result is a table of differences with no clear starting point.

A better comparison starts from the structure of the statement. Revenue, cost of sales and gross profit show whether pricing and purchasing held up; operating expenses and operating profit show whether running costs stayed under control; other income and expenses explain the rest. With both periods in one statement and a month-by-month view behind it, the cause of a change is usually two clicks away.

Why this happens

The profit and loss is run for one period at a time.
Comparisons are rebuilt from exports in a spreadsheet.
Cost of sales is mixed in with operating expenses, hiding gross margin.
Changes are read line by line instead of from the subtotals down.
There is no month-by-month view to show when a change began.

Biznsbook addresses this through multi-step income statement, previous-period and prior-year comparison, monthly trend, general ledger drill-down in the Accounting module, built on the same ledger that every posted sale, bill, payroll run and voucher updates.

Financial reporting rarely fails because the arithmetic is hard. It fails because the numbers are rebuilt by hand every month and nobody trusts the copy. Reading the ledger directly removes that step.

Step-by-step: Compare Profit and Loss Across Periods

Written for owners, bookkeepers and finance managers in small and mid-sized businesses using Biznsbook Accounting, where sales, purchases, inventory and payroll post to the same ledger the reports read.

Set up the statement structure. In Transaction accounts, give purchase and stock cost accounts the Cost of goods sold sub type and non-trading items the Other income or Other expense sub types. The income statement places accounts by these sub types.
Run the income statement. Open Accounting → Financial reporting → Income statement and pick the dates, or a quick range such as last month or year to date.
Add a comparison. Choose Previous period or Same period last year. Whole months compare with the same number of months before; other ranges with the same number of days.
Read the subtotals first. Compare gross profit, operating profit and net profit and their margins. The change chips are green when income rises or costs fall, red the other way.
Find the lines that moved. Within the section that changed, sort your attention by the largest change in amount, not the largest percentage on a small account.
See when it started. Open Monthly trend for the last twelve months to see whether the change was a one-off month or a steady drift, with gross margin shown for each month.
Trace it to the ledger. Click any account, or any month in the trend, to open the general ledger for those dates and see the documents behind the amount. Export either report to Excel for the board pack.

Review results after the first full monthly cycle. Adjust roles, mappings, or approvals where the same exception repeats.

Inside Biznsbook, every financial report has a short "How this is built" note at the bottom and the Accounting guide (Accounting → Accounting guide) walks through each screen. This article focuses on the finance process behind those screens.

Common mistakes to avoid

Mistake 1: The profit and loss is run for one period at a time. Repeating this each month usually shows up first in a management pack nobody trusts.
Mistake 2: Comparisons are rebuilt from exports in a spreadsheet. Repeating this each month usually shows up first in a management pack nobody trusts.
Mistake 3: Cost of sales is mixed in with operating expenses, hiding gross margin. Repeating this each month usually shows up first in a management pack nobody trusts.
Mistake 4: Changes are read line by line instead of from the subtotals down. Repeating this each month usually shows up first in a management pack nobody trusts.
Mistake 5: There is no month-by-month view to show when a change began. Repeating this each month usually shows up first in a management pack nobody trusts.

Each of these turns a monthly review into an argument about whose spreadsheet is right. Report from the ledger instead.

Best practices that hold up as you scale

Set up the statement structure — In Transaction accounts, give purchase and stock cost accounts the Cost of goods sold sub type and non-trading items the Other income or Other expense sub types.
Run the income statement — Open Accounting → Financial reporting → Income statement and pick the dates, or a quick range such as last month or year to date.
Add a comparison — Choose Previous period or Same period last year.
Read the subtotals first — Compare gross profit, operating profit and net profit and their margins.
Find the lines that moved — Within the section that changed, sort your attention by the largest change in amount, not the largest percentage on a small account.

Use the same report, the same dates and the same order every month. Consistency is what turns numbers into a trend people trust.

How Biznsbook supports this workflow

multi-step income statement is part of Biznsbook Accounting and reads the posted ledger directly, so the numbers match the trial balance and change the moment a document is posted. Every amount on the report can be opened in the general ledger to see the entries behind it.

previous-period and prior-year comparison is part of Biznsbook Accounting and reads the posted ledger directly, so the numbers match the trial balance and change the moment a document is posted. Every amount on the report can be opened in the general ledger to see the entries behind it.

monthly trend is part of Biznsbook Accounting and reads the posted ledger directly, so the numbers match the trial balance and change the moment a document is posted. Every amount on the report can be opened in the general ledger to see the entries behind it.

general ledger drill-down is part of Biznsbook Accounting and reads the posted ledger directly, so the numbers match the trial balance and change the moment a document is posted. Every amount on the report can be opened in the general ledger to see the entries behind it.

Access is permission-based: viewing reports needs View financial reports, and creating, approving or archiving budgets needs Manage budgets. Company admins see everything.

Suggested implementation timeline

Week 1: Check account sub types and account mapping so cost of sales, other income and expenses, cash, receivables and payables are classified correctly.
Week 2: Set up multi-step income statement and run the report for last month alongside your current spreadsheet.
Week 3: Agree with the owner or finance manager which lines and ratios go into the monthly pack.
Month 2: Run the monthly review from Biznsbook only and retire the spreadsheet copy.
Ongoing: Monthly review using reading a comparison from the top down.

Metrics to track monthly

Net profit and margin against budget, year to date
Number of cost lines over budget this quarter
Gross margin month by month
Days sales outstanding and cash runway

Start with three metrics; trend direction matters more than a single point-in-time snapshot.

Spreadsheets vs Biznsbook Accounting

Compare a typical export-and-spreadsheet process with Biznsbook multi-step income statement and the related Accounting reports.

Capability	Manual / Spreadsheet	Biznsbook
Second period	❌ Second export pasted beside the first	✅ Comparison column on the same statement
Structure	❌ One list of income and expenses	✅ Gross, operating and net profit with margins
Change	❌ Hand-written formulas	✅ Change and percentage change per line
Timing	❌ Not visible	✅ Monthly trend for 3 to 24 months
Cause	❌ Search the ledger separately	✅ Click through to the general ledger
Sharing	❌ Formatted by hand	✅ Excel export and clean print to PDF

Reading a comparison from the top down

Start with net profit and its change. Then ask which subtotal moved most: gross profit, operating expenses or other items. Inside that section, look at the two or three accounts with the biggest change in amount and open their ledger. Write one sentence per cause, such as higher freight on imported stock or a new lease from March. Three sentences like that are a better management report than a page of percentages.

Put the routine in your month-end checklist so it happens after every close, not only when a question comes up.

Frequently asked questions

What does previous period mean for a whole quarter?

When the dates are whole calendar months, the previous period is the same number of months immediately before. For April to June it is January to March. For any other range it is the same number of days before.

Can I compare against a budget instead?

Yes, through the Budget vs Actual report, which compares posted actuals with an approved twelve-month budget by month, quarter or year.

Why is an account in cost of sales and not operating expenses?

Because its sub type in the chart of accounts is Cost of goods sold. Change the sub type under Transaction accounts to move it, and every report follows.

Can I compare one branch or department?

When cost centers are on, pick a cost center on the income statement or the monthly trend. Opening balances are left out of a cost-center view because they carry no cost center.

Which date is used for each transaction?

The posting date of the journal. Documents posted into a closed period are not possible, so a closed month's comparison does not change after it is closed.

Can I export the comparison?

Yes. The income statement and the monthly trend export to real Excel files with numbers kept as numbers, and both print cleanly or save as PDF from the browser.

How this differs by industry

Retail

Retailers compare each month with the same month last year, not the month before, so seasonal peaks and quiet months are measured against their own history.

Wholesale & distribution

Distributors read gross margin first: if revenue grew but gross profit did not, supplier price rises or customer discounts are eating the growth.

Manufacturing

Manufacturers use the monthly trend to separate a single expensive repair month from a steady rise in overheads before deciding what to fix.