Revenue Momentum & Inward Collections
Monthly Sales (₹) vs Collections Inflow
Debtors Aging Matrix
Recovery Risk Breakdown
Cash Flow Velocity (Inflow vs Outflow)
Net Treasury Dynamics (Receipts vs Payments)
Warehouse Commodities (Bags & Valuation)
Paddy Rice & Wheat Stock Distribution
Top Debtors (Recovery Watchlist)
| Customer / Debtor | GSTIN | Balance Due | Action |
|---|---|---|---|
| Loading debtors... | |||
Recent Synced Vouchers (Live Tally Feed)
| Date | Type | Vch No | Party | Amount (₹) |
|---|---|---|---|---|
| Loading live vouchers feed... | ||||
DayBook & Voucher Register
Live 2-Way Tally Journal Vouchers & Invoices
| Date | Vch Type | Vch No | Particulars / Party | Amount (₹) | Narration |
|---|---|---|---|---|---|
| Loading DayBook vouchers... | |||||
Customer Debtors & Bill-by-Bill Aging
Google Sheets AllBills & Masters Parity with 100% Dynamic Aging Buckets
| Party Ledger Name | Group | GSTIN / State | Turnover (₹) | Closing Balance (₹) | Last Tx Date | Actions |
|---|---|---|---|---|---|---|
| Loading party directory... | ||||||
| Party Name | Bill Ref No | Bill Date | Dr/Cr | Pending Amount (₹) | Overdue Days | Aging Bucket | Action |
|---|---|---|---|---|---|---|---|
| Loading all outstanding bills matrix... | |||||||
| Customer / Buyer | GSTIN | Days Inactive | Last Purchase Date | Historical Sales (₹) | Current Balance (₹) | Churn Risk | Retention Action |
|---|---|---|---|---|---|---|---|
| Checking customer activity... | |||||||
| Customer Debtor Name | GSTIN / Contact | Total Outstanding (₹) | 0-30 Days (₹) | 31-60 Days (₹) | 61-90 Days (₹) | 90+ Days (₹) | Oldest Bill | MSME Status | 1-Click Remind |
|---|---|---|---|---|---|---|---|---|---|
| Calculating age buckets... | |||||||||
Commodity Item Reports & Profitability
Biz Analyst Parity: Sales/Purchase Volume, Bags, Gross Margin & Fast/Slow Velocity
| Commodity Item | HSN | Stock In Hand | Sales Volume | Sales Turnover | Purchase Volume | Purchase Turnover | Gross Margin | Velocity | Action |
|---|---|---|---|---|---|---|---|---|---|
| Loading item reports... | |||||||||
Duties & Taxes, GST Center & GSTR-1
100% Authentic Tally Ledger Balances, Output vs Input ITC, and Table 12 HSN Summary
Duties & Taxes Ledgers in Tally
100% Mirror| Tax / Duty Ledger Name | Accounting Group | Balance Amount (₹) | Dr / Cr | Audit Status |
|---|---|---|---|---|
| Loading tax ledgers... | ||||
GST Exemption & Mandi Note
Wholesale agricultural commodities (Paddy, Rice HSN 100610, Wheat HSN 100110) are strictly Exempt / 0% GST under CBIC notifications when traded loose/unbranded.
GSTR-1 Table 12: HSN-Wise Summary of Outward Supplies
Official GST portal format ready for statutory filing
| HSN Code | Description | UQC | Total Qty | Total Bags | Taxable Value (₹) | Rate | CGST (₹) | SGST (₹) | IGST (₹) | Total Value (₹) |
|---|---|---|---|---|---|---|---|---|---|---|
| Loading GSTR-1 Table 12 data... | ||||||||||
CA Tax Audit, Statutory Compliance & GST 360 Suite
Client Policy Configurator | Section 194N | Section 194Q | Section 206C(1H) | Section 194C | Rule 37 | MSME 43B(h) | Form 3CD
🌾 Section 194N Farmer Cash Exemption is Muted in Client Policy
Section 194N 2% TDS cash withdrawal exemption applies to APMC Mandi traders paying agriculturists / farmers. If your client is a general trader, manufacturer, or service provider, keeping this OFF is appropriate.
🌾 Section 194N APMC Mandi Cash Withdrawal Exemption (Khedut Payments Protection)
Under CBDT Notification No. 70/2019 read with Circular No. 14/2020, cash withdrawals by licensed APMC Mandi traders/commission agents for making payments to agriculturists / farmers ("Kheduts") for purchase of agricultural produce are 100% EXEMPT from 2% TDS under Section 194N.
Form 3CD Clause 21(d) / Section 40A(3): Rule 6DD(e) Agricultural Produce Cash Defense
Cash payments > ₹10,000 to cultivators/growers for agricultural produce are 100% exempt from disallowance under Rule 6DD(e).
| Voucher No | Date | Beneficiary / Cultivator | Cash Amount (₹) | Statutory Exemption Clause | Tax Audit Status (Form 3CD) |
|---|---|---|---|---|---|
| Scanning Section 40A(3) and Rule 6DD(e) schedules... | |||||
Form 3CD Clause 44: GST Expenditure Breakdown
Tax Audit Report| Expenditure Category | Value (₹) | % Share |
|---|---|---|
| Procurement from Unregistered Farmers (URD) | ₹47,20,511.50 | 100.0% |
| Procurement from GST Registered Entities | ₹0.00 | 0.0% |
| Total Procurement (Exempt Mandi Produce) | ₹47,20,511.50 | 100.0% |
*Note: 100% of inward procurement consists of agricultural produce (Paddy, Rice, Wheat) sourced directly from farmers, exempt from GST registration under Section 2(7) of CGST Act.
GST 360° Returns Parity & Cash Audit
GSTR-1 / 3B / BooksSection 43B(h) MSME Watchlist (> 45 Days Overdue)
Disallowance Risk| Creditor | Bill Ref | Amount (₹) | Days |
|---|---|---|---|
| Checking MSME compliance... | |||
Section 269ST Single-Day Cash Receipts (>= ₹2,00,000)
100% Tax Penalty| Voucher No | Date | Party | Cash Amount (₹) |
|---|---|---|---|
| Checking cash transaction limits... | |||
Create Sales Invoice
Live sequence sync with TallyPrime
Inventory Items (Bags ↔ QTL)
Live commodity conversion (0.60 QTL = 1 Bag)
Additional Accounting Ledgers (Tally LEDGERENTRIES.LIST)
Duties & Taxes (CGST/SGST/IGST), Round Off, Mandi Cess & Freight
Mandi Dispatch, Transport & E-Way Bill (TDL UDFs)
Dynamic TDL Column Mapping & Custom UDF Tags (Auto-Injected into Tally XML)
Create Receipt Voucher
Tally outstanding invoice knock-off
Create Payment Voucher (F5)
Settle Sundry Creditors (Farmers/Suppliers) & Expense Accounts
3-Way Statutory GST Reconciliation & DRC-01C Audit Desk
Cross-Verification: Tally Prime Inward Purchases vs GSTR-2B Portal vs GSTR-3B Table 4 with 7 Statutory Audit Buckets
1. Upload GSTR-2B Portal JSON
Auto-drafted inward supplies from suppliers (gst.gov.in). Supports batch files.
2. Upload Filed GSTR-3B JSON
Official filed GSTR-3B return downloaded from GST portal (Table 3.1 & 4).
| Statutory Audit Status | Supplier GSTIN & Name | Invoice / Bill No & Date | Period | Portal Tax (₹) | Tally Tax (₹) | Tax Diff (₹) | Statutory Clause & Risk | Action / Notice |
|---|---|---|---|---|---|---|---|---|
| Cross-verifying Tally purchases with GSTR-2B... | ||||||||
Purchase Invoice Entry (Inward Supplies)
Creditors & ProcurementRecord inward raw material & grain, supplier invoice numbers, custom charges, and dynamic TDL UDFs
Supplier (Sundry Creditor) & Bill Header
Inward Inventory Allocations
| Commodity / Stock Item | HSN | Quantity | Unit | Bags | Rate (₹) | Taxable (₹) | Del |
|---|
Additional Accounting Ledgers (Input Taxes, Round Off, Freight)
Dynamic Tally ledger mapping for statutory and expense charges
Transport, Dalal & Inward TDL UDF Fields
Brokerage, Truck No, Driver Phone, E-Way Bill & custom TDL tags
Journal Entry (General / Adjustments)
Double Entry BookkeepingReal-time debit & credit equilibrium verification (Total Dr = Total Cr) with dynamic Tally masters lookup
Journal Ledger Allocations
| Type | Particulars (Accounting Ledger) | Debit (₹) | Credit (₹) | Line Narration / Ref | Del |
|---|
Credit Note (Sales Return / Discount)
Credit NoteLinked to original invoice ref with statutory GST reason codes & item returns
Return Items / Rate Claim Allocations
| Stock Item | Return Qty | Unit | Rate (₹) | Taxable (₹) | Del |
|---|
Biz Analyst Momentum & Trading Velocity Engine
100% Pure Tally DataSales Velocity vs Purchase Momentum, Price Volatility Tracking, Real Gross Margins & 80/20 Pareto Concentration
Monthly Sales Inflow vs Procurement Outflow & Net Spread
Synced from Tally VouchersCommodity Price Volatility & Rate Spread
Min vs Max Realized Rate| Commodity | Avg Sale (₹) | Avg Pur (₹) | Spread (₹) | Volatility |
|---|
Real Gross Spread Margins %
(Sale - Purchase) / Sale %| Commodity | Sale (₹) | Pur (₹) | Gross Margin % | Sold (QTL) |
|---|
Inventory Movement Velocity (Fast / Slow / Non-Moving)
Billed turnover velocity derived from Tally inventory vouchers
| Commodity Name | Billed Turnover | Velocity Classification | Turnover Recommendation |
|---|
Top 80/20 Customer Concentration (Debtors)
Revenue Drivers| Party Name | Revenue (₹) | Bills | Share % | Cumulative |
|---|
Top 80/20 Procurement Concentration (Creditors)
Key Suppliers| Party Name | Procurement (₹) | Bills | Share % | Cumulative |
|---|