The Client Statement tab offers a complete, real-time financial overview for each client—covering invoices, payments, credit notes, refunds, and outstanding balances. It is essential for maintaining transparency, tracking financial performance, and managing receivables with accuracy.
🔍 Purpose
Provide a consolidated financial summary for each client.
Help account managers track payments, outstanding dues, and adjustments at both project and invoice levels.
Serve as a ready reference for client communication and internal audits.
🧩 Sections in the Client Statement
👤 Client Overview
Displays high-level information:
Company Name
Client Full Name & Designation
Account Manager
Location & Contact Info
Financial Summary:
Billable Amount
Invoiced Amount
Uninvoiced Amount
Paid Amount
Unpaid Amount
📁 Projects
Column
Description
Project Name
Linked project under the client
Net Amount
Total before tax
Tax
Tax applied on billable items
Total Amount
Net + Tax
Paid
Payment received for that project
Outstanding
Due amount remaining
📦 Billable Items
Column
Description
Date
Billing date
Project
Linked project
Billed Items
Description of the service/product billed
Invoiced
Status (INVOICED / DRAFT)
Net Amount
Amount before tax
Tax
Tax amount
Total
Net + Tax
Invoice No.
Linked invoice number
🧾 Invoices
Column
Description
Date
Invoice issue date
Project
Linked project
Invoice No.
System-generated unique invoice ID
Status
UNPAID / PART / PAID / CANCELLED
Net Amount
Before tax
Tax
Tax amount
Total
Net + Tax
💰 Payments
Column
Description
Payment ID
Unique system ID
Invoice Number
Invoice to which payment was applied
Payment Date
Date of payment
Invoice Amount
Total value of invoice
Amount Paid
Payment received
Xction Fees
Transaction charges (if any)
Amount Received
Final amount post deductions
Mode
Cash / Bank / UPI / Other
Reference No.
Bank ref. or payment proof
💳 Credit Notes
Column
Description
Date
Issue date of credit note
Credit Note
Unique CN number
Invoice No.
Linked invoice
Debit Note No.
(If linked to a debit note)
Total Amount
Value credited
Status
Active / Voided
🔁 Refunds
Column
Description
Refund Date
Date refund was processed
Amount
Refunded amount
Transaction ID
Payment gateway/bank reference
Invoice No.
Invoice associated
Credit Note No.
Base credit note for refund
📚 Ledger
Chronological transaction history for the client across all projects.
Date
Reference
Type
ID
Debit (₹)
Credit (₹)
Advance Balance (₹)
Outstanding (₹)
DD/MM/YYYY
Invoice #123
Invoice
INV-001234
50,000.00
—
0.00
50,000.00
DD/MM/YYYY
Payment #567
Payment
PAY-000567
—
25,000.00
0.00
25,000.00
DD/MM/YYYY
Credit Note #45
Credit Note
CN-000045
—
10,000.00
0.00
15,000.00
DD/MM/YYYY
Refund #78
Refund
REF-000078
—
2,000.00
0.00
13,000.00
DD/MM/YYYY
Advance #88
Advance
ADV-000088
—
20,000.00
20,000.00
0.00
DD/MM/YYYY
Invoice #124
Invoice
INV-001245
18,000.00
—
2,000.00
0.00
Notes:
Same calculation logic as Project Ledger.
Advance Balance shows available credit at client level, usable against future invoices.
✅ Use Cases
Share with clients as official account statement.
Internally track collection status per project/invoice.
Audit payments, credit notes, and manual adjustments.
Quickly identify clients with overdue balances.
💡 Tips
Always ensure Credit Notes are linked to the correct invoices.
Use the Ledger section to troubleshoot mismatches in amounts.
Before issuing refunds, verify the corresponding Credit Note is issued and active.
