Use Accounts Payable ageing reports | Pixie CRM Help Centre Canonical: https://pixiecrm.com/help-centre/accounts-payable-ageing-reports Publisher: Pixie Technologies LLC Accounting & Bookkeeping · How-to guide Use Accounts Payable ageing 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 unpaid supplier balances by age in summary and detailed bill or purchase-invoice views. Audience: Accounts payable and finance staff; Feature: Accounts Payable ageing; Module v1.4.5; Where to goAccounting → Reports (https://pixiecrm.com/help-centre/topic/report) → Accounts Payable Ageing 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 unpaid supplier (https://pixiecrm.com/help-centre/topic/vendor) balances by age in summary and detailed bill (https://pixiecrm.com/help-centre/topic/bill) or purchase (https://pixiecrm.com/help-centre/topic/purchase)-invoice (https://pixiecrm.com/help-centre/topic/invoice) views. 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 Accounts Payable Ageing Summary and Detail endpoints. Data can originate from Accounting bills (https://pixiecrm.com/help-centre/topic/bill) and, when active, Purchase (https://pixiecrm.com/help-centre/topic/purchase) module transactions. The ageing total should agree with the payable control account. Differences can arise from manual journals (https://pixiecrm.com/help-centre/topic/journal-entry) to control accounts, missing conversion or incorrect payment (https://pixiecrm.com/help-centre/topic/payment) allocation. Use vendor (https://pixiecrm.com/help-centre/topic/vendor) profiles and Pay Bills (https://pixiecrm.com/help-centre/topic/bill) for operational follow-up. Follow these steps - Run the Summary as of the review date. - Identify overdue bills (https://pixiecrm.com/help-centre/topic/bill), duplicate vendors (https://pixiecrm.com/help-centre/topic/vendor) and credit balances. - Go to Detail for material suppliers (https://pixiecrm.com/help-centre/topic/vendor). - Compare bills (https://pixiecrm.com/help-centre/topic/bill), purchase invoices (https://pixiecrm.com/help-centre/topic/purchase) and payments (https://pixiecrm.com/help-centre/topic/payment). - Investigate unallocated or deleted payments (https://pixiecrm.com/help-centre/topic/payment). - Plan approved payment (https://pixiecrm.com/help-centre/topic/payment) runs. - Reconcile (https://pixiecrm.com/help-centre/topic/reconciliation) the total to the accounts-payable control account. Settings to check Ageing bucketsGroup current and overdue liabilities. Vendor (https://pixiecrm.com/help-centre/topic/vendor) summaryShows total outstanding by supplier (https://pixiecrm.com/help-centre/topic/vendor). DetailLists bills (https://pixiecrm.com/help-centre/topic/bill) or supplier (https://pixiecrm.com/help-centre/topic/vendor) invoices (https://pixiecrm.com/help-centre/topic/invoice), dates, due dates and remaining balances. As-of dateControls ageing. Payments (https://pixiecrm.com/help-centre/topic/payment), debit notes and refundsAdjust outstanding supplier (https://pixiecrm.com/help-centre/topic/vendor) balance when represented correctly. 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 pay from the report (https://pixiecrm.com/help-centre/topic/report) without verifying source approval (https://pixiecrm.com/help-centre/topic/approval). - Use the same as-of date as the ledger. - Review supplier (https://pixiecrm.com/help-centre/topic/vendor) credits. - Protect vendor (https://pixiecrm.com/help-centre/topic/vendor) payment (https://pixiecrm.com/help-centre/topic/payment) 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)reconciliation (https://pixiecrm.com/help-centre/topic/reconciliation)journal entry (https://pixiecrm.com/help-centre/topic/journal-entry)supplier bill (https://pixiecrm.com/help-centre/topic/bill)vendor (https://pixiecrm.com/help-centre/topic/vendor)check (https://pixiecrm.com/help-centre/topic/check)report (https://pixiecrm.com/help-centre/topic/report)purchase (https://pixiecrm.com/help-centre/topic/purchase)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) Related guides Supplier bills overview (https://pixiecrm.com/help-centre/supplier-bills-overview)Pay a supplier bill (https://pixiecrm.com/help-centre/pay-a-supplier-bill)Convert Purchase orders, invoices, payments and refunds (https://pixiecrm.com/help-centre/convert-purchase-orders-invoices-payments-and-refunds)Use General Ledger, Journal and Trial Balance reports (https://pixiecrm.com/help-centre/general-ledger-journal-and-trial-balance-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)