xMatix
Sign in Request demo
xMatix
PRODUCTS
SalesField SalesCRMRewardsClaimsInventoryProcurementWarehouse ManagementField ServiceServiceSupportTelephony & MessagingFinance & AccountingPayrollExpense ManagementCommercePortalsAnalytics & ReportingData StudioMobile AppSee all products →
PLATFORM
Platform overviewApp BuilderAutomationIntegrationsSecurity & GovernanceChange ManagementDevelopers
SENSE AI
Sense AI overviewSense AssistSense ControlSense VisionAI StudioTrust & governanceIn Claude & ChatGPTUse cases
SOLUTIONS
FMCG & DistributionManufacturing & Dealer NetworksAutomotive & DealershipsPharma & HealthcareConsumer DurablesAgri-InputsBuilding MaterialsService NetworksWarehousing & 3PLFinancial AccountingERP SoftwareIndia GST ComplianceUAE VAT & e-InvoicingSaudi ZATCA & VATAll solutions →
RESOURCES
Knowledge CenterDeveloper & CLIBlogGuidesWhat is xMatix?Company facts
COMPANY
AboutCareersPartnersEventsContactAuthorsLegal
Sign in Request demo
Home/Docs/Entity Reference/Fiscal Year — entity reference
REFERENCE · Last reviewed

Fiscal Year — entity reference

The accounting calendar of one company, a dated window that owns the fiscal periods a journal must post into. GeneratePeriods fills it with one calendar-month period per month of the window. It is also the anchor every finance statement is run from: the trial balance, profit and loss, balance sheet, cash flow, ratio and statutory-filing server actions are all mounted on this record rather than on a separate reporting entity. Its own status is a year-level rollup and is not what gates posting; each fiscal period carries the status that does.

Fields

FieldLabelTypeRequiredWhat it does
CreatedByIdCreated ByLookup → UserAccountYes
CreatedDateTimeCreated DateDateAndTimeYes
EndDateEnd DateDate
IdIdGuidYes
LabelLabelText
ModifiedByIdModified ByLookup → UserAccountYes
NameNameTextYes
OwnerIdOwnerLookup → UserAccountYes
PartnerAccountIdPartner AccountLookup → AccountThe company that owns this accounting calendar, and a frequent cause of statements that come back blank. The balance sheet and trial balance select their periods by matching this company rather than by fiscal year, so a calendar stamped with a different company than the one being reported yields an empty statement with no error raised. The profit and loss path selects periods by fiscal year instead and keeps working, and that asymmetry is the diagnostic tell.
RecordTypeIdRecord TypeGuid, hidden
StartDateStart DateDate
StatusStatusTextA year-level rollup that defaults to Open and reuses the fiscal-period vocabulary of Open, Closed and Locked. No finance server action ever writes it: the close actions operate on each fiscal period's own status, and the year-end close posts its closing journal without touching this field, so treat it as manually maintained rather than as evidence the year is actually closed.
UIPropsUI PropsText
UpdatedDateTimeModified DateDateAndTimeYes

Actions

ActionLabelTypeWhat it does
BulkDeleteDeleteDeleteDelete the selected records.
CheckCreditLimitCheckCreditLimitServerAction (CheckCreditLimit)Despite sitting on the fiscal-year action list, this evaluates one counterparty's credit limit against its open receivables and a proposed new amount, both of which are required arguments, and reports nothing about the year itself. It is hosted here only because the finance reporting actions are all mounted on this record, and the company is the only thing it actually takes from it.
CloneCloneServerAction (Clone)Create a copy of this record
CloseYearClose YearServerAction (CloseYear)Posts the year-end closing journal: it pulls the year's profit and loss balances from the statement engine, writes a reversing line against every non-zero income and expense account, and books the net result to the retained-earnings account supplied as a required argument. The journal is created and posted within the same call rather than left as a draft. It does not change this fiscal year's own status and it does not close any period, both of which are separate actions.
DeleteDeleteDeleteDelete
DeleteInListDeleteDeleteDelete in a list page
EditEditEditEdit
EditInLineEditUIActionEdit
EditInLine1EditEditInlineEditInLine
EditListRowEditEditEditListRow
GenerateAdt1NoticeADT-1 Auditor Appointment NoticeServerAction (GenerateAdt1Notice)Form ADT-1 notice of appointment of auditor (s.139, rule 4(2)), box by box for the fiscal year. Company and period details are derived; the auditor block comes from the Statutory Audit Report and the rest from the ADT-1 draft.
GenerateAoc4FilingAOC-4 FilingServerAction (GenerateAoc4Filing)Computes the AOC-4 annual filing pack (Balance Sheet + P&L + Notes to Accounts) for review; file the permanent copy via PublishedStatement.
GenerateApAgeingGenerate Ap AgeingServerAction (GenerateApAgeing)GenerateApAgeing
GenerateArAgeingGenerate Ar AgeingServerAction (GenerateArAgeing)GenerateArAgeing
GenerateAuditSchedulesAudit Schedules (All)ServerAction (GenerateAuditSchedules)Runs all four audit schedules together for the fiscal year: Fixed Assets, AR/AP Ageing, Provisions, and the Loan register.
GenerateBalanceSheetBalance SheetServerAction (GenerateBalanceSheet)Computes the balance sheet cumulatively up to the cut-off period, grouping into Schedule III equity-and-liabilities and asset blocks and folding cumulative profit and loss into reserves. Like the trial balance it resolves its periods by company, so a fiscal calendar owned by the wrong company yields an empty statement rather than an error.
GenerateBalanceSheetByAccountGroupBalance Sheet by Account GroupServerAction (GenerateBalanceSheetByAccountGroup)Chart-of-accounts grouped Balance Sheet (section bands + account tree).
GenerateBalanceSheetScheduleIIIBalance Sheet (Schedule III)ServerAction (GenerateBalanceSheetScheduleIII)Renders the statutory balance-sheet format with fixed Schedule III line items, in the same multi-column shape as its profit-and-loss counterpart: year over year, explicit date windows, or one column per posting-dimension value. This is the presentation a statutory filing pack expects, as distinct from the account-tree balance sheet.
GenerateBankBookBank BookServerAction (GenerateBankBook)Ledger of the bank control accounts for the year.
GenerateBudgetIncomeStatementBudget Income StatementServerAction (GenerateBudgetIncomeStatement)Budget vs actual income statement built from a budget.
GenerateCashBookCash BookServerAction (GenerateCashBook)Ledger of the cash control accounts for the year.
GenerateCashFlowGenerate Cash FlowServerAction (GenerateCashFlow)Produces the cash flow statement by the indirect method for the reporting window. Like the other single-statement generators it returns either the structured result or print-ready statutory markup depending on a format argument.
GenerateCashFlowByAccountGroupCash Flow by Account GroupServerAction (GenerateCashFlowByAccountGroup)Chart-of-accounts grouped Cash Flow Statement.
GenerateCashFlowForecastCash Flow ForecastServerAction (GenerateCashFlowForecast)Forward-looking cash flow forecast.
GenerateChangesInEquityChanges in EquityServerAction (GenerateChangesInEquity)Produces the statement of changes in equity as a multi-column grouped result spanning one or more fiscal years, taking the same year-selection arguments as the other grouped statutory statements.
GenerateComparativeStatementComparative StatementServerAction (GenerateComparativeStatement)Runs either the profit and loss or the balance sheet across several fiscal years side by side. Which of the two is an argument that quietly defaults to profit and loss, the span defaults to two years, and passing an explicit list of fiscal years overrides the year count entirely.
GenerateDayBookDay BookServerAction (GenerateDayBook)Chronological list of every posted journal line in the year.
GenerateDpt3ReturnDPT-3 Return of DepositsServerAction (GenerateDpt3Return)Form DPT-3 return of deposits (rules 16 & 16A) for this fiscal year, including the rule 2(1)(c) receipts table.
GenerateFinancialRatiosFinancial RatiosServerAction (GenerateFinancialRatios)Liquidity, solvency, profitability and efficiency ratios.
GenerateFixedAssetScheduleFixed Asset ScheduleServerAction (GenerateFixedAssetSchedule)Audit schedule: fixed-asset movement note (gross block, accumulated depreciation, net block) derived from the ledger for the fiscal year.
GenerateFundFlowGenerate Fund FlowServerAction (GenerateFundFlow)Produces the fund flow statement, showing sources and applications of funds across the window. It is a companion to the cash flow statement rather than a substitute, and answers a different question from it.
GenerateGeneralLedgerGeneral LedgerServerAction (GenerateGeneralLedger)Generate the General Ledger / account-balance tree (opening, movement, running and closing balances) over the chart of accounts.
GenerateInventoryComparativeInventory ComparativeServerAction (GenerateInventoryComparative)Closing stock / value per fiscal period (comparative columns) from the period-balance cache.
GenerateInventoryMovementInventory MovementServerAction (GenerateInventoryMovement)Per-book inventory movement (roll-forward vs the preceding period) with opening / closing.
GenerateInventoryValuationInventory ValuationServerAction (GenerateInventoryValuation)Per-book inventory valuation (on-hand cost and NRV carrying value) with the GL control tie-out.
GenerateInventoryValuationMatrixInventory Valuation (by dimension)ServerAction (GenerateInventoryValuationMatrix)Inventory carrying value pivoted into columns by branch / period (Balance Statement comparative).
GenerateInventoryValueStatementInventory Value StatementServerAction (GenerateInventoryValueStatement)Inventory carrying value + quantity per column (point-in-time or Opening/Change/Closing movement) for the Balance Statement.
GenerateLoanScheduleLoan ScheduleServerAction (GenerateLoanSchedule)Audit schedule: employee loan register (opening + disbursed - repaid = closing) per loan, derived from LoanAdvance/LoanAdvanceRecovery.
GenerateMgt7AAnnualReturnMGT-7A Annual ReturnServerAction (GenerateMgt7AAnnualReturn)Form MGT-7A abridged annual return (s.92(1)) for this fiscal year, section by section.
GeneratePartyStatementGenerate Party StatementServerAction (GeneratePartyStatement)GeneratePartyStatement
GeneratePeriodsGenerate PeriodsServerAction (GeneratePeriods)Creates one calendar-month fiscal period for each month of the year's date range. It refuses when the year lacks a valid start and end date, and refuses outright if any period already exists rather than topping up, so re-running after a partial setup means deleting the existing periods first. Monthly is the only cadence it produces.
GenerateProfitAndLossProfit & LossServerAction (GenerateProfitAndLoss)Computes the profit and loss for the reporting window, grouping accounts by their Schedule III classification. Unlike the balance sheet and trial balance it selects its periods by fiscal year rather than by company, so it can still return figures in cases where those two come back empty because of a mis-stamped calendar.
GenerateProfitAndLossByAccountGroupP&L by Account GroupServerAction (GenerateProfitAndLossByAccountGroup)Chart-of-accounts grouped Profit & Loss (section bands + account tree).
GenerateProfitAndLossScheduleIIIP&L (Schedule III)ServerAction (GenerateProfitAndLossScheduleIII)Renders the statutory Statement of Profit and Loss with its fixed roman-numeral line items instead of the account tree, returned as a multi-column result. Columns can chain fiscal years, chain explicit date windows, or break out by a posting dimension with one column per business unit, branch, tax registration or cost centre plus a total.
GenerateProjectedIncomeStatementProjected Income StatementServerAction (GenerateProjectedIncomeStatement)Forward-looking income statement (run-rate or stored projection).
GenerateProvisionScheduleProvisions ScheduleServerAction (GenerateProvisionSchedule)Audit schedule: provisions movement note (opening + additions - utilized/reversed = closing) per provision type, derived from Provision-tagged GL accounts.
GenerateRelatedPartyDisclosureRelated Party DisclosureServerAction (GenerateRelatedPartyDisclosure)Nature-wise value of transactions with related parties and the balance outstanding, for the audit disclosure note.
GenerateResourceProfitabilityResource-wise ProfitabilityServerAction (GenerateResourceProfitability)Revenue and parts cost of the jobs each engineer/technician worked, less their logged time priced at their labour cost rate. Args: fromDate, toDate, resourceId, branchId, status, includeJobs, format.
GenerateRiskReportRisk ReportServerAction (GenerateRiskReport)Piotroski, Altman, Beneish, Montier and risk-ratio scoring.
GenerateTrialBalanceTrial BalanceServerAction (GenerateTrialBalance)Computes the trial balance for the company as at the requested cut-off, listing each account's net debit or credit and suppressing accounts with no movement at all. Empty output against a well-populated ledger usually means the fiscal calendar is stamped with a different company than the one being reported, because period selection on this path filters by company rather than by fiscal year.
GenerateTrialBalanceByAccountGroupTrial Balance by Account GroupServerAction (GenerateTrialBalanceByAccountGroup)Produces the trial balance arranged down the chart-of-accounts hierarchy rather than as a flat account list, returning debit, credit and closing columns per node. Prefer it over the flat trial balance when the question concerns account groupings instead of individual account balances.
GetBookOverlayStatusBook Overlay StatusServerAction (GetBookOverlayStatus)Reports whether a chosen secondary accounting book's stored valuation overlay is still current given inventory activity since it was last recomputed. The book is a required argument, and the primary book is never reported as stale because it is the general ledger itself.
NewNewNewNew
RebuildInventoryPeriodBalancesRebuild Inventory Period BalancesServerAction (RebuildInventoryPeriodBalances)Recompute the InventoryPeriodBalance cache from the ledger (prerequisite for the comparative view).
RecomputeBookOverlayRecompute Book OverlayServerAction (RecomputeBookOverlay)Rebuilds the per-book valuation deltas for every period of this fiscal year up to an as-of date that defaults to the year end, doing so across all secondary books rather than only the one being inspected, and reports how many periods it rewrote. Reach for it mid-period when a secondary book's statements are lagging recent inventory movement; period close runs the same recomputation as an advisory step.
SaveAdt1NoticeSave ADT-1 NoticeServerAction (SaveAdt1Notice)Stores the ADT-1 answers that have no ledger source (CIN, appointment date, auditor particulars, board resolution) on the draft PublishedStatement backing the notice. Merges by default; null clears a box, replace=true discards all.
SeedScheduleIIIClassificationsSeed ClassificationsServerAction (SeedScheduleIIIClassifications)Populates the Schedule III classification on the company's GL accounts by deriving a default from each account's existing account type, so a freshly imported chart of accounts groups into statutory statement lines without manual mapping. By default it only fills accounts that have none; an overwrite argument makes it replace mappings that are already set.
ViewForm3CDAuditForm 3CD Tax AuditServerAction (ViewForm3CDAudit)Clause-wise Form 3CD tax-audit report for this fiscal year.