Accounting & Bookkeeping · How-to guide

Use General Ledger, Journal and Trial Balance reports

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

Trace every posted debit and credit, review journal sequence and confirm total debits equal total credits.

Audience: Accounting staff and auditorsFeature: Core ledger reportsModule v1.4.5

Jump to steps

Where to goAccounting → Reports → General Ledger / Journal / Trial Balance

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

Trace every posted debit and credit, review journal sequence and confirm total debits equal total credits. 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 module provides Account List, General Ledger, Journal and Trial Balance as separate report endpoints. These are the primary tools for explaining financial statements.

General Ledger groups activity by account; Journal focuses on entries and chronology; Trial Balance summarises balances.

Use source links and transaction detail reports for deeper investigation.

Follow these steps

Run Trial Balance for the period or as-of date.
Verify total debits equal total credits.
Identify material or unexpected account balances.
Go to General Ledger for those accounts.
Use Journal to review transaction sequence and references.
Trace entries to source invoices, bills, payments or journals.
Export the reviewed reports with filters noted.

Settings to check

General LedgerActivity and balance by account.

JournalTransactions in journal or chronological context.

Trial BalanceDebit and credit balances across all accounts.

Date rangeControls included activity.

Opening and closing balanceExplain account movement.

Reference and sourceTrace to the operational record or manual entry.

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

A balanced Trial Balance can still contain classification errors.
Check control accounts.
Investigate unexplained manual journals.
Protect report exports.
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 payment reconciliation Chart of Accounts journal entry supplier bill check report approval mapping double-entry expense vendor tax

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

Use General Ledger, Journal and Trial Balance reports

What you’ll accomplish

How it works

Follow these steps

Settings to check

Check it worked

Common mistakes to avoid

Related guides