Use Deposit Detail and Check Detail reports | Pixie CRM Help Centre Canonical: https://pixiecrm.com/help-centre/banking-deposit-and-check-reports Publisher: Pixie Technologies LLC Accounting & Bookkeeping · How-to guide Use Deposit Detail and Check Detail 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 deposits and check activity by account, date, payee and transaction reference. Audience: Treasury and accounting staff; Feature: Banking transaction reports; Module v1.4.5; Where to goAccounting → Reports (https://pixiecrm.com/help-centre/topic/report) → Deposit Detail / Check (https://pixiecrm.com/help-centre/topic/check) 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 deposits and check (https://pixiecrm.com/help-centre/topic/check) activity by account, date, payee and transaction reference. 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 Deposit Detail and Check (https://pixiecrm.com/help-centre/topic/check) Detail. These complement the Banking (https://pixiecrm.com/help-centre/topic/banking) register, feed and reconciliation (https://pixiecrm.com/help-centre/topic/reconciliation) reports (https://pixiecrm.com/help-centre/topic/report). A deposit may represent multiple customer (https://pixiecrm.com/help-centre/topic/customer) payments (https://pixiecrm.com/help-centre/topic/payment); use matching and source references to explain the total. Check (https://pixiecrm.com/help-centre/topic/check) Detail should be reviewed with the check register (https://pixiecrm.com/help-centre/topic/check) and void history. Follow these steps - Run Deposit Detail for the bank and period. - Compare deposits with customer (https://pixiecrm.com/help-centre/topic/customer) payments (https://pixiecrm.com/help-centre/topic/payment) or other sources. - Run Check (https://pixiecrm.com/help-centre/topic/check) Detail. - Check check (https://pixiecrm.com/help-centre/topic/check) sequence, voids and payees. - Trace exceptions to the check register (https://pixiecrm.com/help-centre/topic/check) or banking feed (https://pixiecrm.com/help-centre/topic/banking). - Compare with reconciliation (https://pixiecrm.com/help-centre/topic/reconciliation) reports (https://pixiecrm.com/help-centre/topic/report). - Export the reviewed report (https://pixiecrm.com/help-centre/topic/report). Settings to check Deposit DetailLists deposit transactions and their source or allocation. Check (https://pixiecrm.com/help-centre/topic/check) DetailLists checks (https://pixiecrm.com/help-centre/topic/check), payees, amounts, numbers and status. Bank account (https://pixiecrm.com/help-centre/topic/banking)Filter to the account under review. Date rangeUse statement or audit period. ReferenceTrace to payments (https://pixiecrm.com/help-centre/topic/payment), bills (https://pixiecrm.com/help-centre/topic/bill) or other source records. StatusCheck outstanding, cleared or voided state where available. 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 - Investigate gaps in check (https://pixiecrm.com/help-centre/topic/check) numbering. - Do not treat printed checks (https://pixiecrm.com/help-centre/topic/check) as cleared. - Check batch deposits. - Protect bank and payee 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:invoice (https://pixiecrm.com/help-centre/topic/invoice)payment (https://pixiecrm.com/help-centre/topic/payment)banking (https://pixiecrm.com/help-centre/topic/banking)reconciliation (https://pixiecrm.com/help-centre/topic/reconciliation)supplier bill (https://pixiecrm.com/help-centre/topic/bill)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)vendor (https://pixiecrm.com/help-centre/topic/vendor)tax (https://pixiecrm.com/help-centre/topic/tax)customers (https://pixiecrm.com/help-centre/topic/customer) Related guides Use the check register, reprint and void controls (https://pixiecrm.com/help-centre/use-the-check-register-reprint-and-void)Use bank reconciliation reports (https://pixiecrm.com/help-centre/bank-reconciliation-reports)Convert invoice payments to Accounting (https://pixiecrm.com/help-centre/convert-invoice-payments-to-accounting)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)