Get Started with AR Tracking
Upload your Tally ERP reports to start monitoring receivables in real-time.
Export from Tally
From Tally ERP, go to Display → Statement of Accounts → Outstanding and export as Excel.
Upload Master Report
Click Input → Master Report in the nav bar and select your exported Excel file.
Track & Collect
View aging, log payments, update call statuses, and export reports — all in your browser.
Total Outstanding
₹0
Total Collected
₹0
90+ Days Aging
₹0
Today Collected
₹0
Total Parties
0
Total Invoices
0
Pending Invoices
0
Paid Invoices
0
Calling List
0
Aging Bucket Summary
Aging Bucket Distribution
Outstanding by Group
90+ Days by Group
Call Status Summary
TOP OVERDUE PARTIES
| # | Party Name | Outstanding (₹) | Max Overdue (Days) | Aging Bucket | Invoices |
|---|
No overdue data
| Party Name | Invoice No | Group | Date | Due Date | Aging Bucket | Overdue | Original (₹) | Pending (₹) | Status | Call Status |
|---|
DSO (Days)
0
CEI (%)
0%
Avg Days Delinquent
0
90+ Delinquency %
0%
Bad Debt Risk (₹)
₹0
How This Dashboard Works
What is Accounts Receivable (AR) Aging? AR aging categorizes unpaid invoices by how long they've been outstanding. It helps you identify which customers are paying on time and which ones need follow-up.
How to use this dashboard:
- Upload your Master Report from Tally ERP (Input → Master Report) to populate the ledger with all invoices.
- Upload Payment Logs (Input → Payment Logs) or log payments manually in the Payment Desk tab to track what's been collected.
- Upload a Calling List (Input → Calling List) to sync call statuses and remarks from your collection team.
- Use the Calling List tab to prioritize follow-ups on invoices overdue >30 days. Update call statuses after each interaction.
- Export reports (Output → CSV/PDF/Sync JSON) to share with stakeholders or archive daily snapshots.
Tips for better cash flow:
- Focus on 90+ Day aging items first — these have the highest risk of becoming bad debt.
- Use WhatsApp/Email buttons in the Calling List to send quick payment reminders.
- Track the Today Collected KPI daily to measure collection team performance.
- Log all payments promptly to keep the DSO (Days Sales Outstanding) metric accurate.
- Export and backup your data via Sync JSON regularly — all data is stored only in your browser.
Sample Files & Expected Format
Master Report
| Expected Columns |
|---|
| S.No |
| Source Sheet |
| Date |
| Invoice No |
| Invoice Amount |
| Customer Name |
| Pending Amount |
| Due Date |
| Paid Amount |
| Outstanding Amount |
| Days Overdue |
| Aging Bucket |
| Risk Level |
| Remarks |
| Status |
Calling List
| Expected Columns |
|---|
| S.No |
| Source Sheet |
| Date |
| Invoice No |
| Invoice Amount |
| Customer Name |
| Pending Amount |
| Due Date |
| Paid Amount |
| Outstanding Amount |
| Days Overdue |
| Calling Status |
| Previous Remarks |
| New Remarks |
Data source: Tally ERP. All processing happens locally in your browser — nothing is uploaded to any server.