Customer work, connected.

Help & supportMyAccount
Pixie CRM
Try Pixie for a 14-day free trial
Accounting & Bookkeeping · How-to guide

Filter and export account registers

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

Narrow register activity by account and transaction attributes, then retain a controlled output for review or audit.

Audience: Accounting and audit staffFeature: Register reviewModule v1.4.5
Jump to steps
Where to goAccounting → Registers
Before you startThis guide follows Accounting and Bookkeeping module version 1.4.5. The required access is Accounting Registers: 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

Narrow register activity by account and transaction attributes, then retain a controlled output for review or audit. 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 exposes register tables and a transaction-filter endpoint. Filtering is performed against the ledger records, so source-document filters can differ from the CRM's operational list.

A register export is evidence of the selected view, not a replacement for bank reconciliation or Trial Balance.

For a complete audit trail, pair the register with Journal or Transaction Detail by Account reports.

Follow these steps

  1. Go to Registers and choose the account.
  2. Apply the date range and available transaction filters.
  3. Check the first and last rows for period boundaries.
  4. Go to source records for exceptions.
  5. Use the supported export or browser print process.
  6. Label the retained output with account, period and generation date.

Settings to check

Account filterSelect the ledger account under review.
Date rangeUse exact inclusive dates.
Transaction filterLimit the list by available type or status.
Export contextVerify whether the export contains the current filtered view.
Running balanceInterpret from the correct opening point.

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

  • Do not compare exports produced with different filters.
  • Verify whether voided or deleted records are excluded.
  • Protect exported financial data.
  • Use formal reports for signed financial statements.
  • 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:bankingreconciliationChart of Accountscheckreportapprovalmappingdouble-entryclass
Use account registersUse transaction and account audit reportsUse General Ledger, Journal and Trial Balance reportsExport, print and filter Accounting reportsChart of Accounts overviewCreate and edit a Chart of Accounts account

Search the platform, integrations and practical Help Centre guides.

Press Esc to close.Browse every page