Reconcile a bank account | Pixie CRM Help Centre Canonical: https://pixiecrm.com/help-centre/reconcile-a-bank-account Publisher: Pixie Technologies LLC Accounting & Bookkeeping · How-to guide Reconcile a bank account Pixie CRM guidance. Follow the route for your workspace, check your role and enabled modules, and verify the result before moving on. Compare the Accounting bank register with a bank statement and complete a controlled reconciliation for the statement period. Audience: Accounting staff; Feature: Bank reconciliation; Module v1.4.5; Where to goAccounting → Reconcile (https://pixiecrm.com/help-centre/topic/reconciliation) or Accounting → Banking (https://pixiecrm.com/help-centre/topic/banking) → Reconcile (https://pixiecrm.com/help-centre/topic/reconciliation) Bank Account (https://pixiecrm.com/help-centre/topic/banking) Before you startThis guide follows Accounting and Bookkeeping module version 1.4.5. The required access is Accounting Reconcile (https://pixiecrm.com/help-centre/topic/reconciliation): View, Create or Edit. 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 Compare the Accounting bank register with a bank statement and complete a controlled reconciliation (https://pixiecrm.com/help-centre/topic/reconciliation) for the 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 supports both the main Reconcile (https://pixiecrm.com/help-centre/topic/reconciliation) area and a bank-account reconcile (https://pixiecrm.com/help-centre/topic/reconciliation) workflow, with transaction tables, save-for-later, finish and completeness checks (https://pixiecrm.com/help-centre/topic/check). It can offer adjusting-entry and leave-uncleared choices for unresolved items. Use an adjusting entry only when it represents a real, approved accounting event. Completed reconciliations (https://pixiecrm.com/help-centre/topic/reconciliation) feed the Bank Reconciliation (https://pixiecrm.com/help-centre/topic/reconciliation) Summary and Detail reports (https://pixiecrm.com/help-centre/topic/report). Follow these steps - Select the bank account (https://pixiecrm.com/help-centre/topic/banking). - Enter statement dates and ending balance. - Verify the beginning balance. - Check withdrawals and deposits and mark or match statement items. - Investigate unmatched and uncleared transactions. - Use Save for Later if the review is incomplete. - When the difference is resolved, complete the reconciliation (https://pixiecrm.com/help-centre/topic/reconciliation) and retain the report (https://pixiecrm.com/help-centre/topic/report). Settings to check Bank account (https://pixiecrm.com/help-centre/topic/banking)The ledger account (https://pixiecrm.com/help-centre/topic/chart-of-accounts) being reconciled. Statement start and end datesDefine the period. Beginning balanceMust agree with the prior reconciliation (https://pixiecrm.com/help-centre/topic/reconciliation). Ending statement balanceTaken from the official bank statement. Cleared transactionsMatched withdrawals and deposits included in the statement. DifferenceMust be zero or handled through an approved adjustment before completion. 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 force a zero difference with an unexplained adjustment. - Do not reconcile (https://pixiecrm.com/help-centre/topic/reconciliation) the same statement period twice. - Verify outstanding items are genuine timing differences. - Complete reconciliation (https://pixiecrm.com/help-centre/topic/reconciliation) before close books. - 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:payment (https://pixiecrm.com/help-centre/topic/payment)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)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 Make a reconciliation adjustment (https://pixiecrm.com/help-centre/make-a-reconciliation-adjustment)Reopen or restore a bank reconciliation (https://pixiecrm.com/help-centre/reopen-or-restore-a-bank-reconciliation)Use bank reconciliation reports (https://pixiecrm.com/help-centre/bank-reconciliation-reports)Configure the financial year and close books (https://pixiecrm.com/help-centre/configure-financial-year-and-close-books)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)