Use transaction and account audit reports | Pixie CRM Help Centre Canonical: https://pixiecrm.com/help-centre/transaction-audit-reports Publisher: Pixie Technologies LLC Accounting & Bookkeeping · How-to guide Use transaction and account audit reports Pixie CRM guidance. Follow the route for your workspace, check your role and enabled modules, and verify the result before moving on. Investigate ledger activity through Account History, Recent Transactions, Transaction Detail by Account and Transaction List by Date. Audience: Accounting staff and auditors; Feature: Transaction audit reports; Module v1.4.5; Where to goAccounting → Reports (https://pixiecrm.com/help-centre/topic/report) → Bookkeeping / Transaction reports (https://pixiecrm.com/help-centre/topic/report) Before you startThis guide follows Accounting and Bookkeeping module version 1.4.5. The required access is Accounting Reports (https://pixiecrm.com/help-centre/topic/report): 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 (https://pixiecrm.com/help-centre/topic/approval). What you’ll accomplish Investigate ledger activity through Account History, Recent Transactions, Transaction Detail by Account and Transaction List by Date. It forms part of Pixie CRM Enterprise CRM's Accounting & Bookkeeping module and uses the module's permission-aware controller, status and mapping (https://pixiecrm.com/help-centre/topic/mapping) flow rather than a generic spreadsheet process. How it works The report (https://pixiecrm.com/help-centre/topic/report) controller exposes Account History, Recent Transactions, Transaction Detail by Account and Transaction List by Date. These reports (https://pixiecrm.com/help-centre/topic/report) complement the ledger and journal. For bank-specific evidence, use banking (https://pixiecrm.com/help-centre/topic/banking) register and reconciliation (https://pixiecrm.com/help-centre/topic/reconciliation) reports (https://pixiecrm.com/help-centre/topic/report). For customer (https://pixiecrm.com/help-centre/topic/customer) or vendor (https://pixiecrm.com/help-centre/topic/vendor) balances, use ageing reports (https://pixiecrm.com/help-centre/topic/report). If a transaction was deleted, the current ledger report (https://pixiecrm.com/help-centre/topic/report) may not show it; use Pixie CRM activity and organisational audit records as applicable. Follow these steps - Select the audit question and appropriate report (https://pixiecrm.com/help-centre/topic/report). - Set account and exact dates. - Check transaction references and descriptions. - Go to source records for exceptions. - Compare debits and credits (https://pixiecrm.com/help-centre/topic/double-entry) with the General Ledger. - Check (https://pixiecrm.com/help-centre/topic/check) recent edits or deletions through available activity logs. - Export the filtered evidence. Settings to check Account HistoryShows activity and changes for a selected account. Recent TransactionsSurfaces recently posted activity. Transaction Detail by AccountLists detailed lines grouped by account. Transaction List by DateChronological transaction listing. FiltersAccount, date, type or other available criteria. Source referenceLinks audit evidence to the originating workflow. 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 (https://pixiecrm.com/help-centre/topic/double-entry) must balance and the accounts must match the approved mapping (https://pixiecrm.com/help-centre/topic/mapping) or manual selection. - Open the saved record and confirm its final status. - Review the source reference and every debit and credit (https://pixiecrm.com/help-centre/topic/double-entry) line where ledger data was created. - Use the relevant register, ageing, reconciliation (https://pixiecrm.com/help-centre/topic/reconciliation) or report (https://pixiecrm.com/help-centre/topic/report) to verify the wider effect. Common mistakes to avoid - Do not rely on description alone. - Check transactions around period end. - Investigate duplicate amounts and references. - Keep exported audit data secure. - Use the least destructive correction available and record the reason for material changes. - Do not bypass a permission, approval (https://pixiecrm.com/help-centre/topic/approval) or closed-period control by changing unrelated data. Accounting and data safetyDeletion, reset, void, refund, mapping (https://pixiecrm.com/help-centre/topic/mapping), journal and reconciliation (https://pixiecrm.com/help-centre/topic/reconciliation) actions can change financial history. Use approved access, retain supporting evidence and validate the result in the General Ledger or relevant control report (https://pixiecrm.com/help-centre/topic/report). Browse connected topics:banking (https://pixiecrm.com/help-centre/topic/banking)reconciliation (https://pixiecrm.com/help-centre/topic/reconciliation)Chart of Accounts (https://pixiecrm.com/help-centre/topic/chart-of-accounts)vendor (https://pixiecrm.com/help-centre/topic/vendor)check (https://pixiecrm.com/help-centre/topic/check)report (https://pixiecrm.com/help-centre/topic/report)approval (https://pixiecrm.com/help-centre/topic/approval)mapping (https://pixiecrm.com/help-centre/topic/mapping)double-entry (https://pixiecrm.com/help-centre/topic/double-entry)expense (https://pixiecrm.com/help-centre/topic/expense)tax (https://pixiecrm.com/help-centre/topic/tax)customers (https://pixiecrm.com/help-centre/topic/customer) Related guides Use General Ledger, Journal and Trial Balance reports (https://pixiecrm.com/help-centre/general-ledger-journal-and-trial-balance-reports)Use account registers (https://pixiecrm.com/help-centre/use-account-registers)Review the activity log (https://pixiecrm.com/help-centre/review-the-activity-log)Export, print and filter Accounting reports (https://pixiecrm.com/help-centre/export-print-and-filter-accounting-reports)Accounting report centre overview (https://pixiecrm.com/help-centre/report-centre-overview)Use Balance Sheet reports (https://pixiecrm.com/help-centre/balance-sheet-reports)