SVGR Finance — Close Schedules

Module 01

Fixed Asset Register

Asset master, depreciation schedules (SLM & WDV), trial balance reconciliation and disposal management.

Gross Block

—

Total cost

Acc. Depreciation

—

Cumulative

Net Book Value

—

Closing balance

This Period Dep.

—

Current month

TB Variance

—

vs Data Hub

Asset Master

Depreciation Schedule

TB Reconciliation

Journal Entries

Import

Add / Edit Asset

Asset Code*

Asset Name*

Category*

Currency

Gross Cost*

Acc. Dep. B/F (migration)

Residual Value %

Residual Value (Amt)

Depreciation Method

Rate % p.a.*

📋 Schedule II reference rate will appear here

Purchase Date

Dep. Effective From*

Location / Dept

Supplier / Invoice Ref

Status

Disposal Date

Disposal Proceeds

Impairment Written-off

Notes

Code	Asset Name	Category	Method	Gross Cost	Acc. Dep.	NBV Today	Dep. Rate %	Projected Closure	Status

Depreciation Schedule

Asset Roll-Forward All Assets · Current FY

Fixed Assets — Trial Balance Reconciliation

Click Reconcile to compare register vs Data Hub trial balance.

Depreciation Journal Entries

Import Fixed Assets from CSV

📂 Click or drag & drop a CSV file here

Required columns: code, name, category, cost, method, rate, start_date | Optional: purchase_date, currency, residual_pct, acc_dep_bf, location, supplier

CSV Template

code,name,category,currency,cost,acc_dep_bf,residual_pct,method,rate,purchase_date,start_date,location,supplier,status,notes
FA-001,Dell Server R740,computers,INR,350000,0,5,WDV,31.67,2023-04-01,2023-05-01,IT Dept,Dell India,active,
FA-002,Office Furniture Set,furniture,INR,120000,24000,5,SLM,6.33,2022-08-15,2022-09-01,HO,Office Mall,active,

Month-End Close Pack SVGR Advisory

🔒

Your month-end close pack is ready

We've drafted every closing journal and schedule tie-out — depreciation, prepayment amortisation, accruals & reversals, loan interest — so the books close clean and on time. Unlock it with a free 20-minute review.

Book a free review → WhatsApp us

Module 02

Prepayment Schedule

Multi-period prepayments, monthly amortisation releases, unexpired balance reconciliation and P&L variance.

Total Prepaid (BS)

—

Unexpired balance

This Period Release

—

P&L charge due

Overdue (Unexpensed)

—

Benefit period expired

Active Prepayments

—

Open items

Active Prepayments

Release Schedule

Import

Add Prepayment

Reference*

Description*

Vendor / Payee

Currency

Amount Paid*

FX Rate (to Reporting CCY)

Payment Date

Benefit Period Start*

Benefit Period End*

Expense Account (P&L)

Ledger Ref

Ref	Description	Vendor	CCY	Amount	Benefit Period	Monthly Release	Released to Date	Balance (BS)	Status

Monthly Release Schedule

Import Prepayments from CSV

📂 Click or drag & drop CSV

Required: ref, desc, amount, benefit_start, benefit_end | Optional: vendor, currency, fx_rate, payment_date, exp_account

Module 03

Accruals & Reversals

Period-end accruals, auto-reversal tracking, estimate vs actual variance and period lock controls.

Total Accrued (BS)

—

Current period liability

Pending Reversals

—

Awaiting reversal

Estimate Variance

—

Accrual vs actual invoice

Period Status

—

Lock / Open

Accruals Register

Reversal Tracker

Import

Add Accrual

Reference*

Description*

Accrual Period

Currency

Estimated Amount*

FX Rate

Expense Account

Accrual Account (BS)

Actual Invoice Date

Actual Invoice Amount

Reversal Status

Ref	Description	Period	CCY	Estimated	Actual Inv.	Variance	Rev. Status	Exp. Account

Reversal Tracker & Period Lock

● Period Open

No accruals added yet.

Import Accruals from CSV

📂 Click or drag & drop CSV

Required: ref, desc, period, amount | Optional: currency, fx_rate, exp_account, acc_account, inv_date, inv_amount

Module 04

Loan Amortisation — EIR

Full Effective Interest Rate (Ind AS 109 / IFRS 9) amortisation schedule with Newton-Raphson EIR solver, forex revaluation and P&L variance.

Total Carrying Amount

—

All loans combined

EIR Interest This Period

—

P&L finance cost

Coupon Due This Period

—

Cash outflow

FX Revaluation

—

Exchange gain / (loss)

Loan Master

EIR Schedule

Import

Add Loan

Loan Reference*

Description

Lender

Currency

Face Value (Principal)*

Transaction Costs (upfront)

Net Proceeds (auto)

Coupon Rate % p.a.*

EIR % p.a. (auto-calculated)

Drawdown Date*

Maturity Date*

Payment Frequency

Payment Amount (Coupon)

Status

Opening Balance (migration)

Ref	Description	Lender	CCY	Face Value	Carrying Amount	EIR %	Coupon %	Maturity	Status

EIR Amortisation Table

Import Loans from CSV

📂 Click or drag & drop CSV

Required: ref, face_value, coupon_rate, start_date, maturity_date | Optional: desc, lender, currency, tx_costs, freq, payment_amount

Module 05

Variance Analysis

Consolidated schedule vs ledger reconciliation. Schedule Says = the carrying value computed by this tool (depreciation, amortisation, EIR). Ledger Shows = the balance pulled from the Data Hub raw ledger for the matching GL account. Connect to Data Hub to auto-populate the Ledger column and compute variances.

ℹ No Ledger Data = Data Hub not connected. Open Data Hub, import raw ledger, then return here — variances populate automatically from GL balances.  ·  Amber = variance exists but within your configured materiality threshold (Settings & FX panel).  ·  Material Var. = variance exceeds threshold — investigate before month-end close.

Reconciled

—

Amber

—

Material Var.

—

Total Variance

—

Module	Item	Schedule Says	Ledger Shows	Variance	Status	Note

Configuration

Settings & FX Rates

Global depreciation policy, materiality thresholds, foreign exchange rates per period and Schedule II reference rates.

Global Settings

Depreciation — First Month Policy

Financial Year Start Month

Variance Tolerance

EIR Iteration Cap

FX Rates — Current Period

Enter rates as 1 USD/AUD/GBP/AED/SGD = X INR (or X reporting currency). Used for translating foreign currency balances.

Schedule II Reference Rates (India — Companies Act 2013)

Category	Useful Life	SLM Rate %	WDV Rate %	Residual
Buildings (Factory)	30 yrs	3.17%	10.34%	5%
Buildings (Non-Factory / Office)	60 yrs	1.58%	5.00%	5%
Plant & Machinery (General)	15 yrs	6.33%	18.10%	5%
Furniture & Fittings	10 yrs	9.50%	25.89%	5%
Vehicles (Motor Cars)	8 yrs	11.88%	31.23%	5%
Computers & IT Equipment	3 yrs	31.67%	63.16%	5%
Office Equipment	5 yrs	19.00%	45.07%	5%
Intangible Assets (Software)	3 yrs	33.33%	—	0%

Audit Compliance

Audit Trail

Immutable log of all additions, edits, deletions and period locks across all schedule modules.

No audit entries yet.