Accounting & Bookkeeping · How-to guide

Use Profit & Loss reports

Pixie CRM guidance. Follow the route for your workspace, check your role and enabled modules, and verify the result before moving on.

Analyse income, cost of sales and expenses using standard, detail, comparison, year-to-date, 12-month and percentage views.

Audience: Finance managersFeature: Profit & Loss reportsModule v1.4.5

Jump to steps

Where to goAccounting → Reports → Profit & Loss

Before you startThis guide follows Accounting and Bookkeeping module version 1.4.5. The required access is Accounting Reports: View. A related screen can remain hidden when an optional module is inactive, a source record is in an ineligible status, the selected account is inactive or the user is not an assigned approver.

What you’ll accomplish

Analyse income, cost of sales and expenses using standard, detail, comparison, year-to-date, 12-month and percentage views. It forms part of Pixie CRM Enterprise CRM's Accounting & Bookkeeping module and uses the module's permission-aware controller, status and mapping flow rather than a generic spreadsheet process.

How it works

The controller provides Profit & Loss, Detail, Comparison, Year-to-Date Comparison, 12 Months and As a Percentage of Total Income, plus budget reports.

Revenue, cost and expense grouping follows Chart of Accounts classifications and mappings.

Cash-versus-accrual settings can materially change timing; label reports accordingly.

Follow these steps

Select the reporting period and basis.
Run the standard Profit & Loss.
Go to Detail for material accounts.
Use Comparison or YTD with matched periods.
Use 12 Months to identify trend.
Use Percentage view to review cost structure.
Compare with budget and trace variance to the ledger.

Settings to check

Profit & LossIncome and expense activity for a period.

DetailShows underlying account or transaction detail.

ComparisonCompares selected periods.

Year-to-Date ComparisonCompares cumulative results.

12 MonthsDisplays monthly activity across a year.

As % of Total IncomeShows relative cost and margin structure.

Budget variantsCompare actual results with the selected budget.

Check it worked

After the action is saved, Pixie CRM keeps the Accounting record connected to its source and updates the visible status or ledger data supported by this workflow. Review the saved result rather than relying only on a success message. Where the action posts accounting data, total debits and credits must balance and the accounts must match the approved mapping or manual selection.

Open the saved record and confirm its final status.
Review the source reference and every debit and credit line where ledger data was created.
Use the relevant register, ageing, reconciliation or report to verify the wider effect.

Common mistakes to avoid

Use consistent basis and dates.
Do not compare a partial month with a full month without explanation.
Review unconverted invoices and expenses.
Explain income-statement modifications.
Use the least destructive correction available and record the reason for material changes.
Do not bypass a permission, approval or closed-period control by changing unrelated data.

Accounting and data safetyDeletion, reset, void, refund, mapping, journal and reconciliation actions can change financial history. Use approved access, retain supporting evidence and validate the result in the General Ledger or relevant control report.

Browse connected topics:invoice expense reconciliation Chart of Accounts check budget report approval mapping double-entry sales accounting tax customers

Was this guide useful?Your response is stored only in this browser.

Use Profit & Loss reports

What you’ll accomplish

How it works

Follow these steps

Settings to check

Check it worked

Common mistakes to avoid

Related guides