Use bank reconciliation reports | Pixie CRM Help Centre Canonical: https://pixiecrm.com/help-centre/bank-reconciliation-reports Publisher: Pixie Technologies LLC Accounting & Bookkeeping · How-to guide Use bank reconciliation reports Pixie CRM guidance. Follow the route for your workspace, check your role and enabled modules, and verify the result before moving on. Follow this guide to review completed reconciliation summaries and transaction-level details for each bank account and statement period. Audience: Finance managers and auditors; Feature: Reconciliation reports; Module v1.4.5; Where to goAccounting → Reports (https://pixiecrm.com/help-centre/topic/report) → Bank Reconciliation (https://pixiecrm.com/help-centre/topic/reconciliation) Summary / Detail 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 Review completed reconciliation (https://pixiecrm.com/help-centre/topic/reconciliation) summaries and transaction-level details for each bank account (https://pixiecrm.com/help-centre/topic/banking) and statement period. 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 module provides separate Bank Reconciliation (https://pixiecrm.com/help-centre/topic/reconciliation) Summary and Bank Reconciliation (https://pixiecrm.com/help-centre/topic/reconciliation) Detail report (https://pixiecrm.com/help-centre/topic/report) endpoints. These reports (https://pixiecrm.com/help-centre/topic/report) are based on the module's reconciliation (https://pixiecrm.com/help-centre/topic/reconciliation) records, not merely the current bank register. A report (https://pixiecrm.com/help-centre/topic/report) can show a completed reconciliation (https://pixiecrm.com/help-centre/topic/reconciliation) even if later transactions were edited; use reopen controls and audit review when underlying data changes. Pair the report (https://pixiecrm.com/help-centre/topic/report) with the statement and supporting source documents for a complete audit file. Follow these steps - Go to the Summary report (https://pixiecrm.com/help-centre/topic/report) and select account and period. - Verify beginning and ending statement balances. - Go to the Detail report (https://pixiecrm.com/help-centre/topic/report). - Check cleared withdrawals, deposits, outstanding items and adjustments. - Trace exceptions to the register and source transaction. - Export or print the report (https://pixiecrm.com/help-centre/topic/report). - Retain it with the official statement. Settings to check Account and periodIdentify the reconciled bank and statement dates. Statement balanceThe external ending balance. Book balanceThe Accounting balance used in reconciliation (https://pixiecrm.com/help-centre/topic/reconciliation). Outstanding itemsTransactions not cleared in the statement. AdjustmentsEntries created to resolve genuine differences. Completion statusShows whether the reconciliation (https://pixiecrm.com/help-centre/topic/reconciliation) is final. 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 - Use the same period as the bank statement. - Investigate stale outstanding items. - Do not rely on a summary without detail for material accounts. - Protect bank reports (https://pixiecrm.com/help-centre/topic/report) as confidential data. - 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)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)Plaid (https://pixiecrm.com/help-centre/topic/plaid) Related guides Reconcile a bank account (https://pixiecrm.com/help-centre/reconcile-a-bank-account)Use posted bank transactions and the banking register (https://pixiecrm.com/help-centre/use-posted-bank-transactions-and-the-banking-register)Reopen or restore a bank reconciliation (https://pixiecrm.com/help-centre/reopen-or-restore-a-bank-reconciliation)Export, print and filter Accounting reports (https://pixiecrm.com/help-centre/export-print-and-filter-accounting-reports)Banking workspace overview (https://pixiecrm.com/help-centre/banking-workspace-overview)Create and manage an Accounting bank account (https://pixiecrm.com/help-centre/create-an-accounting-bank-account)