A three-business-day management close is an operating target. It depends on reliable feeds, early reconciliations and a clear policy for unresolved items. Establish which reports are provisional, who signs them off and how corrections are tracked. The examples below use fictional data.
Move routine checks before month-end
| Workstream | Before cutoff | At close | Evidence |
|---|---|---|---|
| Purchases | Review open orders, receipts and invoice status. | Accrue obligations for goods and services received when appropriate; resolve receiving and price exceptions. | Receiving evidence, contract price and accrual-to-invoice link. |
| Cash | Import bank and gateway records daily. | Reconcile bank, merchant and COD balances, including timing differences. | Gross-to-net reconciliation and exception owners. |
| Data | Map source company, period and accounts. | Validate extraction counts, totals, missing batches and duplicates. | Source trial balance tie-out and dated extraction logs. |
| Intercompany | Match reciprocal balances and review terms. | Resolve cut-off differences and post controlled group eliminations. | Counterparty confirmations and elimination schedules. |
Choose an extraction route for TallyPrime
ODBC can expose supported collections such as ledgers and stock items. Enable ODBC in the applicable configuration and connect to the loaded company with the correct driver and configured port. Port 9000 is a common default, not a requirement. Do not assume the ERP exposes every voucher field as a conventional SQL table. Validate any custom collection against the installed release.
For XML over HTTP, enable the HTTP server and send the appropriate request to its configured endpoint on the authorised network. The header selects the request type and named report. This skeleton illustrates an export request; replace the sample company and report names with ones available in the installed configuration, and add date variables as supported. It was checked as XML, not executed against a live ERP.
<ENVELOPE> <HEADER> <VERSION>1</VERSION> <TALLYREQUEST>Export</TALLYREQUEST> <TYPE>DATA</TYPE> <ID>Configured MIS Report</ID> </HEADER> <BODY> <DESC> <STATICVARIABLES> <SVCURRENTCOMPANY>Example Company</SVCURRENTCOMPANY> </STATICVARIABLES> </DESC> </BODY> </ENVELOPE>For multiple instances, a connector can stage each feed before consolidation. Use authenticated access, entity and period filters, batch IDs, duplicate prevention and retry controls. Keep the reporting extraction separate from any posting workflow. If a connector creates journals, require documented approval, reconciliation and audit trail coverage. Check the Tally version and whether a third-party integration is supported before relying on it.
An example close calendar
| Phase | Work | Evidence |
|---|---|---|
| Day −2 | Review outstanding receipts and open orders, asset additions and disputed invoices. | Pre-close exception list. |
| Day 0 | Apply the entity’s actual period cutoff, record in-transit movements and control late postings. | Stock counts and cutoff evidence. |
| Day +1 | Reconcile cash and gateways; accrue unbilled receipts and services; check payroll balances. | Cash reconciliations and approved journals. |
| Day +2 | Post book depreciation and allocations; reconcile intercompany and GST information; review the trial balance. | Mapped and reconciled trial balance; tax schedule separate from book entries. |
| Day +3 | Review management reports, exceptions and release conditions with the controller. | Signed management pack and dated follow-up list. |
Seven worked examples
1. Retail: sales and bank settlements
Assume 18 stores in four states, ₹42 crore annual sales and 45,000 monthly transactions. A prior close consumed 10 days of sales entry and six additional days of settlement matching. Set up daily exports with store, tax classification, tender and settlement reference; check the product tax master for the actual supply date rather than applying sample GST rates to every product.
If 96.5% of the 45,000 transactions match by count, 43,425 match and 1,575 need review. Track exception value as well as count. If ₹8.40 lakh remains unmatched after reconciliation, classify pending settlements, fees, reversals and unsupported amounts before drawing a conclusion. Day +1 for reconciliations and Day +3 for the pack are targets.
2. Manufacturing: goods received before the invoice
Assume 68 open receipts total ₹145 lakh on the agreed cost basis, of which ₹95 lakh remains in raw materials and ₹50 lakh was issued. Of the issued amount, assume ₹40 lakh remains in work in progress and ₹10 lakh relates to output already sold. Debit raw material inventory ₹95 lakh, work in progress ₹40 lakh and cost of sales ₹10 lakh, and credit GRNI ₹145 lakh, if the ERP has not already recognised them. Apply the actual cost flow and avoid duplicating goods receipt or issue entries.
When the invoice arrives, clear GRNI against the payable and investigate any price or quantity variance. If the system reverses accruals, verify that it rebooks or clears them without double counting or losing the obligation. The gross receipt value is not necessarily a profit adjustment. GST ITC has its own conditions, including applicable document and return checks; an internal accrual alone does not establish it.
3. Fleet: match tolls, fuel and advances
For a fleet of 120 trucks, assume 5,000 trip expense records. If 92% match by count, 4,600 are matched and 400 need attention. Where available, use the issuer’s FASTag and fuel card feeds, verify vehicle and trip identifiers, and route receipt exceptions to an approver. Record travel advances separately from expenses until settled or supported.
If unresolved cash advances fall from ₹38 lakh to under ₹2 lakh, the reduction exceeds ₹36 lakh. Confirm whether the movement reflects cash returned, supported expenses or a correction. Set Day +2 as the trip review target rather than promising it will be met.
4. Professional services: revenue and billing
An engineering consultancy with 85 professionals and 60 projects should first assess each performance obligation. Only use over-time recognition if an Ind AS 115 paragraph 35 criterion is met. An hours-based input method must faithfully depict progress and exclude inputs that do not do so. Otherwise use the appropriate measure of progress, or recognise at a point in time when required.
For one qualifying performance obligation with a fixed allocated price of ₹20 lakh, 1,200 eligible hours out of 4,000 gives 30% progress and ₹6 lakh cumulative revenue. If ₹4 lakh was recognised previously, current revenue is ₹2 lakh. If ₹5 lakh has been billed and the remaining entitlement is conditional on further performance, the ₹1 lakh balance is a contract asset. A right unconditional except for the passage of time is a receivable. Treat advance retainers as contract liabilities to the extent that they precede the transfer of services.
5. Distribution: intercompany balances and in-transit stock
A parent and three subsidiaries reconcile ₹14.80 lakh of differences. An illustrative bridge is ₹8.50 lakh of unmatched billing, ₹4.20 lakh of shipments in transit and ₹2.10 lakh of credit notes. Agree recognition and cutoff using contract terms and evidence of transfer of control; a dispatch timestamp or crossing a border does not decide it alone.
| Check | Prior effort assumed | Improved control |
|---|---|---|
| Bilateral billing | 3 business days | Use reciprocal entity and invoice IDs and obtain approval before posting. |
| Goods in transit | 2 business days | Match dispatch and receipt to contractual control and record exceptions. |
| Group adjustments | 3 business days | Eliminate intragroup balances, income, expenses and unrealised profit where required. |
The assumed sequential effort totals eight business days. Group elimination under Ind AS 110 does not change legal entity books or remove a separate GST obligation; retain the bridge for each entity and GST registration.
6. E-commerce: reconcile net remittances
A seller with 35,000 monthly orders uses the settlement file to match payment gateway and cash-on-delivery receipts. For an illustrative batch, ₹100 lakh gross receipts less ₹8 lakh refunds, ₹4 lakh fees, ₹0.30 lakh GST TCS and ₹0.20 lakh income-tax withholding yields ₹87.50 lakh cash. The tax amounts are assumed statement entries, not a rate calculation. Match them against the relevant statutory records.
Section 52 of the CGST Act deals with GST TCS for applicable e-commerce operators; section 51 is a distinct GST deduction provision. Income-tax withholding is separate. Reconcile recorded revenue, taxes, credit notes, fees and cash based on each contract and applicable law; net cash remitted is not automatically revenue.
7. Fixed assets: reconcile book and tax schedules
An industrial manufacturer with ₹45 crore in gross fixed assets and 2,400 active asset records can automate data entry while keeping a reviewed fixed asset register. For an illustrative component at ₹12.60 lakh cost, ₹0.60 lakh residual value and a supported ten-year useful life, annual straight-line book depreciation is ₹1.20 lakh, or ₹0.10 lakh per full month. Three full months from availability for use give ₹0.30 lakh.
Record book depreciation by debiting expense or applicable asset cost and crediting accumulated depreciation. Check useful life, significant components, residual value and date available for use under Ind AS 16 and applicable Schedule II requirements. Maintain a separate tax depreciation schedule under the law for that period. A software report does not establish CARO compliance.
Seven reports for the management pack
- Flash profit and loss with the basis of margins and material period adjustments.
- Working capital and cash movement, including reconciled cash and clearing balances.
- Product and segment economics, with agreed cost allocation and reconciliation to the ledger.
- Budget variance analysis for price, quantity, mix and significant one-time items.
- Order book and short-term billing outlook, distinguished from recognised revenue.
- Compliance exceptions: relevant GST returns and credits, payroll, withholding and micro and small enterprise supplier aging. The MSMED Act deadline depends on written terms and acceptance; 45 days is a cap for agreed terms, not the default. Apply the income-tax deduction rule for the relevant period, including section 37(2)(g) under the 2025 Act.
- Rolling cash forecast, for example 13 weeks, with due dates, assumptions and a comparison to actual cash.
Frequently asked questions
1. What if supplier invoices are late?
Use evidence of receipt or service and a supportable estimate to accrue an existing obligation. Compare the invoice with the estimate when available and evaluate material differences and period adjustments; do not apply a fixed tolerance without considering the reporting framework.
2. Can a faster close increase risk?
Yes, if approvals or reconciliations are skipped. Test completeness, duplicate handling and journal approvals. An unresolved item can be escalated or disclosed in a provisional pack instead of being hidden to meet the date.
3. How are foreign subsidiary balances translated?
For a non-hyperinflationary foreign operation, translate assets and liabilities at closing rates and income and expenses at transaction-date rates. A representative average is acceptable only when it reasonably approximates actual rates. Reconcile translation differences in OCI and keep standalone monetary remeasurement separate.
4. Does an extract prove audit-trail compliance?
No. Under Rule 3(1) of the Companies (Accounts) Rules, for financial years starting on or after 1 April 2023 a company using accounting software to maintain its books must use software with the required transaction audit trail and dated edit log, which cannot be disabled. Auditor reporting is under Rule 11(g) of the Companies (Audit and Auditors) Rules. Test whether the trail operated for all relevant transactions, was not tampered with and was retained. Review interfaces and software that form part of the books.
5. How should a close deadline be managed?
Assign each reconciliation to an owner and agree escalation thresholds. Management reporting can distinguish estimates from final numbers, but the timetable does not override accurate cut-off or reporting requirements.
6. Can reporting be added without changing how journals are posted?
A controlled read-only extract can often be added separately. Test access, backups, report totals and release compatibility in an appropriate environment. If automated posting is added, use a separate approval, testing and reconciliation process.
Sources
- TallyHelp: XML integration and server configuration
- TallyHelp: XML header and request tags
- TallyHelp: ODBC data extraction
- Companies (Accounts) Rules, 2014: Rule 3(1)
- ICAI: audit trail reporting under Rule 11(g)
- ICAI compendium: Ind AS 2, inventories
- ICAI compendium: Ind AS 115, revenue
- ICAI compendium: Ind AS 110, group eliminations
- ICAI compendium: Ind AS 21, currency translation
- ICAI compendium: Ind AS 16, depreciation
- CBIC: CGST Act, sections 16, 51 and 52
- MSMED Act, 2006: sections 2 and 15
- Income-tax Act, 2025: section 37(2)(g) and transition