O2C Accounts Receivable Analytics using SQL

Overview

SQL project focused on Accounts Receivable (AR) and Order-to-Cash (O2C) analytics using the IBM Finance Factoring dataset.

The project analyzes customer payment behavior, invoice disputes, settlement performance, invoice aging, and customer risk using MySQL.

Dataset

IBM Finance Factoring – Late Payment Histories

Key fields:

• Customer ID
• Country Code
• Invoice Number
• Invoice Amount
• Days Late
• Days To Settle
• Disputed Status

Key Analysis

• Customer Payment Behavior Analysis
• Invoice Aging Analysis
• Customer Risk Classification
• Dispute Analysis
• Settlement Performance Analysis
• Revenue Concentration Analysis
• High-Value Late Customer Identification

SQL Concepts Used

• SELECT
• WHERE
• GROUP BY
• ORDER BY
• HAVING
• LIMIT
• CASE WHEN
• COUNT(), SUM(), AVG()

Tools

• MySQL
• SQL
• GitHub

Author

Prateek Kandwal