Docs
ERP Crystal
MFG
Finance
Reports
Receivable / Payables (AR/AP) & Aging Report

Receivable / Payables (AR/AP) & Aging Report

Receivable / Payables & Aging - User Guide

1. Introduction 📊💰

Cash flow is the lifeblood of any manufacturing business. The Receivable / Payables (AR/AP) Report is the primary tool for your credit control team. It doesn’t just show “who owes what”; it provides a multi-dimensional analysis of your debt, including how long money has been outstanding, the future cash flow requirements, and the interest penalties incurred due to late payments.

ℹ️

Purpose of this Report:

  • Debt Recovery: Identify exactly which bills are overdue and by how many days.
  • Cash Flow Projection: Forecast exactly how much money is due to be collected/paid in the next 7, 14, or 28 days.
  • Interest Calculation: Automatically calculate interest penalties on overdue bills for commercial negotiations.
  • Credit Limit Audit: Compare outstanding balances against a party’s authorized credit limit.
  • Automated Communication: Send professional aged statements directly to customers via email with a single click.

This report is essential for Credit Controllers, Accounts Managers, and Sales Teams.

2. Key Analysis Modules 🚀

A. Aged Summary (The 0-360 View)

The report automatically buckets every outstanding invoice into standard timeframes:

  • Not Due: Bills where the credit period is still active.
  • 0-30 to 181-360 Days: Standard overdue buckets.
  • Above 360 Days: Critical bad-debt risks that require immediate legal or management intervention.

B. Interest on Overdue OS (Penalty Logic)

  • Dynamic Rates: Enter a custom interest rate (e.g., 18%) and a grace period (e.g., 5 days).
  • Financial Impact: Calculates the exact “Interest Amount” lost due to late payment, allowing you to raise interest debit notes or use this as a bargaining tool during settlement.

C. Due Date Wise Report (Planning)

  • Weekly Projection: Categorizes upcoming receivables into “Due in 7 Days,” “Due in 14 Days,” etc.
  • Treasury Management: Use this to plan for salary disbursements or large raw material purchases based on expected inflows.

3. Advanced Features & Controls 🛠️

  • Age Doc Type Control:
    • Ref Date: Compute aging from the day the bill was raised.
    • Due Date: Compute aging from the day the credit period ended (standard for credit control).
  • Automatic Notes Integration: The report automatically scans your database and pulls in:
    • LC No & Date: If the bill is backed by a Letter of Credit.
    • PDC Status: If you have already received a Post-Dated Cheque for the invoice.
    • Follow-up Status: Short-term status updates from your collection team.
  • One-Click Emailing: Blitz your customers with their latest statements. The system pulls up to 4 registered email IDs from the Party Master and attaches the aged report as a professional document.

4. Understanding Data Columns 📊

  • Ref No & Date: The specific Invoice or Purchase Bill being tracked.
  • Amount: The original bill value.
  • Net Amount: The current pending balance (after adjusting for partial payments or credit notes).
  • Aging: Total days the money has been stuck.
  • Interest Amount: The lost opportunity cost calculated at your specified rate.
  • Credit Days: The authorized credit period given to the customer.

5. Source Transactions 🔄

The reporting engine synthesizes data from:

  1. Unified AR/AP View: A real-time consolidation of Invoices, Bills, Debit/Credit Notes, and Vouchers.
  2. Party Master: Defines credit limits, payment terms, and contact email addresses.
  3. Collection Status: Captures follow-up comments and payment promises.

6. Best Practices / Tips 💡

  • The Sales Officer Filter: Run the report by “Sales Officer.” Hold your sales team accountable for the “Quality” of the sales they make by showing them the aging of their specific portfolio.
  • The Sunday Statement Blast: On the first day of every week, use the Email feature for all customers in the “30+ Days” bucket. This keeps your company at the top of their payment priority list.
  • Grace Period Discipline: Always set a Grace Period of 2-3 days in the interest report to account for bank clearance delays. This ensures you only charge for genuine payment delays.
  • Reference vs. Due Date: Use “Ref Date” for internal performance analysis (how fast do we turn inventory to cash?) and “Due Date” for external follow-ups (who is actually late?).
Financial Ledger & Final Accounts ReportCash & Bank Book Reports