Use Income by Customer and Deposit Detail reports | Pixie CRM Help Centre Canonical: https://pixiecrm.com/help-centre/customer-income-and-deposit-reports Publisher: Pixie Technologies LLC Accounting & Bookkeeping · How-to guide Use Income by Customer and Deposit Detail reports Pixie CRM guidance. Follow the route for your workspace, check your role and enabled modules, and verify the result before moving on. Analyse revenue by customer and trace bank deposits back to the payments or transactions that produced them. Audience: Finance and account managers; Feature: Customer income reporting; Module v1.4.5; Where to goAccounting → Reports (https://pixiecrm.com/help-centre/topic/report) → Income by Customer (https://pixiecrm.com/help-centre/topic/customer) Summary / Deposit 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 Analyse revenue by customer (https://pixiecrm.com/help-centre/topic/customer) and trace bank deposits back to the payments (https://pixiecrm.com/help-centre/topic/payment) or transactions that produced them. 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 Income by Customer (https://pixiecrm.com/help-centre/topic/customer) Summary and Deposit Detail as distinct reports (https://pixiecrm.com/help-centre/topic/report) because revenue and cash are different measures. Accrual income can exist before payment (https://pixiecrm.com/help-centre/topic/payment); deposits can include non-customer (https://pixiecrm.com/help-centre/topic/customer) receipts. Use Accounts Receivable ageing to connect customer (https://pixiecrm.com/help-centre/topic/customer) revenue, invoice (https://pixiecrm.com/help-centre/topic/invoice) and payment (https://pixiecrm.com/help-centre/topic/payment) positions. Follow these steps - Run Income by Customer (https://pixiecrm.com/help-centre/topic/customer) Summary for the period. - Check top, negative or unexpected customer (https://pixiecrm.com/help-centre/topic/customer) totals. - Go to source invoice (https://pixiecrm.com/help-centre/topic/invoice) and credit activity. - Run Deposit Detail for cash-receipt analysis. - Compare batch deposits with customer (https://pixiecrm.com/help-centre/topic/customer) payments (https://pixiecrm.com/help-centre/topic/payment). - Reconcile (https://pixiecrm.com/help-centre/topic/reconciliation) bank totals. - Export management results with basis and period labelled. Settings to check Income by Customer (https://pixiecrm.com/help-centre/topic/customer) SummaryAggregates recognised income by customer (https://pixiecrm.com/help-centre/topic/customer) for the period. Customer (https://pixiecrm.com/help-centre/topic/customer) relationshipDepends on converted source transactions carrying customer (https://pixiecrm.com/help-centre/topic/customer) context. Deposit DetailShows bank deposit composition. Credits and refundsCan reduce net customer (https://pixiecrm.com/help-centre/topic/customer) income or cash. Date basisUse consistent cash or accrual interpretation. 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 equate revenue with cash received. - Review customer (https://pixiecrm.com/help-centre/topic/customer) credits and refunds. - Check (https://pixiecrm.com/help-centre/topic/check) missing customer (https://pixiecrm.com/help-centre/topic/customer) links on manual entries. - Protect commercially sensitive results. - 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)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)sales accounting (https://pixiecrm.com/help-centre/topic/sales)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 Accounts Receivable ageing reports (https://pixiecrm.com/help-centre/accounts-receivable-ageing-reports)Use Profit & Loss reports (https://pixiecrm.com/help-centre/profit-and-loss-reports)Use Deposit Detail and Check Detail reports (https://pixiecrm.com/help-centre/banking-deposit-and-check-reports)Convert sales invoices to Accounting (https://pixiecrm.com/help-centre/convert-sales-invoices-to-accounting)Accounting report centre overview (https://pixiecrm.com/help-centre/report-centre-overview)Use Balance Sheet reports (https://pixiecrm.com/help-centre/balance-sheet-reports)