Vizznity Logo
Interest Calculator
By Vizznity
Client-Side Sandbox • Zero Data Transmission
Vizznity 3D Logo
Vizznity
Enterprise Financial Assurance

INTEREST CALCULATOR

By Vizznity

Analyze customer payment delays and calculate interest directly from SAP receivable data with audit-grade transparency and zero cloud exposure.

Privacy First Architecture Your data stays with you. SAP data is processed locally in your browser memory and is never uploaded, transmitted, or saved to any persistent storage.
1
Setup Master
Prefix to Department Mapping
2
Upload SAP
Customer Ledger File (.xlsx / .csv)
3
Validate
Header & Field Integrity Check
4
Classify
RV Invoices & Prefix Routing
5
Match & Calc
Clearing Doc & Grace Period
6
Export
5-Sheet Audit Workbook
SAP Ledger Processing
Processes complete customer open and cleared item records with high performance in-memory indexing.
Automated Classification
Extracts Reference prefixes (e.g. YX, PX, NE) mapped to customizable Sub-Departments & Sales Types.
Document Date Clearing
Matches clearing docs across all document types (AB, BD, DZ, DA) using Document Date as real payment date.
Grace Period Threshold
Implements strict audit rules: grace period is an ignored delay threshold, not a deductible deduction.

Sub-Department Setup

Review and confirm invoice prefix classifications before processing the SAP ledger. NJ, DJ, and YJ department allocations are fully configurable.

Prefix Master Held In Session Memory
Any unmapped prefix encountered during SAP extraction will be highlighted as "Unrecognized Prefix — Review Required". You can modify these settings or add missing prefixes at any time without re-uploading your file.
Active Invoice Prefix Master Table
15 Prefixes Configured
Prefix Department Sub-Department Sale Type Description Active Actions

Upload SAP Customer Receivable Ledger

Upload the complete SAP customer receivable ledger for the review period (.xlsx, .xls, or .csv).

Drag & drop your SAP ledger here
or browse from your local computer (XLSX, XLS, CSV)

Data Validation

Verify that essential SAP receivable columns are present and correctly mapped before starting extraction.

SAP Field Mapping & Column Integrity
Automated Column Detection
Total Rows in Ledger
0
All transaction lines
RV Invoices Detected
0
Document Type = "RV"
Clearing Documents Indexed
0
Unique Document Numbers
Potential Review Items
0
Blank Ref / Due Date

Extraction & Prefix Classification

Invoices are extracted from Document Type 'RV' rows. Invoice Number and 2-character Prefix are derived strictly from the Reference column.

Classification Breakdown by Prefix
-
Prefix Department Sub-Department Sale Type Invoices Total Amount Status Action

Interest Calculation Parameters

Configure client-specific interest rates, day basis, and grace period thresholds.

Grace Period Threshold Configuration
Important Audit Rule: Grace Period is a Threshold, Not a Deduction
The grace period is an ignored delay threshold. If actual delay is within the selected grace period (e.g. 1 day late with 1 day grace), no interest is calculated.
However, if the delay exceeds the grace period (e.g. 3 days late with 1 day grace), interest is calculated on the FULL 3 days, NOT (3 - 1 = 2 days).
% p.a.
Default standard is 12.00% per annum.
Interest Formula: Payment Amount × Rate × Late Days / Day Basis

Calculation & Review

Examine calculation statistics, clearing document matches, and review items before finalization.

Active Parameters: Rate: 12.00% Grace Period: 1 Day Basis: 365 Days
RV Invoices
0
Total Population
Mapped Invoices
0
Payment Date Resolved
Unpaid Invoices
0
Blank/Open Clearing
Delayed Invoices
0
Late Days > Grace
Review Required
0
Requires Attention
Total New Interest
₹0.00
Calculated @ 12% p.a.

Results Dashboard & Working Data

Interactive review of calculated interest across departments, sales types, and individual customer invoices.

Total Invoices
0
₹0.00
Paid Invoices
0
Cleared via SAP
Delayed Invoices
0
Subject to Interest
Unpaid Invoices
0
Interest = ₹0.00
Review Required
0
Exception Items
Total New Interest
₹0.00
Recoverable Interest
Department-wise Invoice Amount Invoice Values
Department-wise New Interest @ 12% p.a.
Domestic vs Export Distribution By Invoice Amount
Payment Status Bifurcation Paid / Delayed / Unpaid / Review
S. No. Customer Name Inv No. Type Invoice Date Payment Amt Due Date Credit Days Payment Date Late Days Int % Int Amt SAP New Interest Remark Old Date Audit
Showing 0 of 0 records Click "View Calc" on any row to verify step-by-step mathematical proof.

Export Audit Excel Workbook

Generate a single professional Excel workbook with SUMMARY, YARN, FABRIC, MELANGE, and INTEREST WORKING sheets.

Workbook Structure Specification
5 Standard Audit Sheets
1. SUMMARY
Executive parameters, Main Summary by Department & Sale Type, Sub-Department breakdown, and Exception Audit Summary.
2. YARN
Detailed working population for invoices classified under the Yarn department.
3. FABRIC
Detailed working population for invoices classified under the Fabric department.
4. MELANGE
Detailed working population for invoices classified under the Melange department.
5. INTEREST WORKING
Comprehensive working dataset: Mapped, Unpaid, Delayed, and Review Required records with standardized remarks.
Appended to workbook title and filename if provided.
Export Filename Preview
Interest_Calculator_Vizznity_20260929.xlsx
Pre-Export Audit Reconciliation Verification
✓ 5 Exact Sheets: SUMMARY, YARN, FABRIC, MELANGE, INTEREST WORKING
✓ Zero Duplicates: Verified across Reference & Doc Number
✓ Total Reconciled: Summary = Working = Dept sheets
✓ Native Cell Types: Numeric amounts, dates & percentages
✓ Audit Formatting: AutoFilter, Freeze Panes & Print Titles
✓ Print Ready: A4 Landscape, Fit to 1 Page Wide