xMatix
Sign in Request demo
xMatix
PRODUCTS
SalesField Sales & SFACRMRewardsClaimsInventoryProcurementWarehouse 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
Auto DMSConsumer Goods DMSSales Force Automation (SFA) 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 whose monthly fiscal periods decide which dates a journal can post into. Generate Periods fills it with one Open period per calendar month of the window, and Generate Fiscal Days can add one row per date flagged working or non-working. A posting needs an Open period covering its date inside a fiscal year whose own status is also Open, so the year's status gates every period beneath it. When a posting date has no covering period, an April to March year with Open monthly periods is created automatically for the company. The trial balance, profit and loss, balance sheet, cash flow, ratio and statutory-filing actions are all run from this record, and Close Year posts the year-end closing journal to retained earnings.

Fields

FieldLabelTypeRequiredWhat it does
CreatedByIdCreated ByLookup → UserAccountYes
CreatedDateTimeCreated DateDateAndTimeYes
EndDateEnd DateDateThe last day of the fiscal year, which must be after the start date or the save is refused. The last period ends on this date, and the year-end closing journal is dated on the last period's end date.
IdIdGuidYes
LabelLabelTextAn optional display name for the year. It is not on the create form; when present it is used in messages and in the closing journal's description.
ModifiedByIdModified ByLookup → UserAccountYes
NameNameTextYesThe year's name, for example FY2026-27. It also names the year-end closing journal, which is called CLOSE- followed by this name. Years created automatically for a posting date are named this way.
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 DateDateThe first day of the fiscal year. Generate Periods and Generate Fiscal Days refuse to run until both the start and end date are set, and the first period starts on this date even if it is mid-month.
StatusStatusTextThe year-level status, defaulting to Open and using the fiscal-period vocabulary of Open, Closed and Locked. It is a plain text field and it gates posting: a journal is refused in any period of a year whose status is anything other than Open, even when the period itself is Open. No action writes it; Close Year posts the closing journal but leaves this status unchanged, so set it yourself to stop or allow postings into the whole year.
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 reads the year's profit and loss, reverses every income and expense account with a balance, and books the net profit or loss to a retained-earnings account that must be supplied as an argument. The journal is dated on the last period's end date and is posted immediately, so that period and the year must still be Open. It changes no status, closes no period and does not check whether the year was already closed. The record-page button supplies no argument, so run from there it stops with a message asking for the retained-earnings account.
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 Open fiscal period for each calendar month of the year's date range, labelled by month and numbered from 1, shortening the first or last period when the year starts or ends mid-month. It refuses when the year lacks a valid start and end date, and refuses if any period already exists rather than topping up, so regenerating means deleting the existing Open 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.