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/Budget Line — entity reference
REFERENCE · Last reviewed

Budget Line — entity reference

One planned amount for a GL account inside a budget, either for the whole fiscal year or for one fiscal period. Lines are added from the budget's Related tab with Quick Add. Only one line may exist per budget, GL account and fiscal period (an annual line with no period counts as its own period), the amount must be greater than zero, and lines cannot be added or edited while the parent budget is Confirmed. Budget vs Actual sums the lines per GL account and shows only profit and loss accounts of the budget's company. In the monthly layouts a line with a period lands in that period and an annual line is spread evenly across the year.

Fields

FieldLabelTypeRequiredWhat it does
BranchIdBranchLookup → BranchBranch recorded on the line for reference. Budget vs Actual does not split the budget by branch; its Branch picker narrows only the Actual column. Hidden on tenants with a single location.
BudgetAmountBudget AmountCurrencyThe planned figure. Must be greater than zero; enter income and expense budgets as positive amounts. Favourable or unfavourable variance is decided by whether the account is income or expense, never by the sign of this value.
BudgetIdBudgetLookup → BudgetThe budget this line belongs to. Filled in automatically when the line is added from the budget's Related tab.
BusinessUnitIdBusiness UnitLookup → BusinessUnitBusiness unit recorded on the line for reference. Budget vs Actual scopes actuals by the budget header's business unit, not by this field.
CreatedByIdCreated ByLookup → UserAccountYes
CreatedDateTimeCreated OnDateAndTimeYes
FiscalPeriodIdFiscal PeriodLookup → FiscalPeriodThe period the amount belongs to. Leave it empty for an annual amount, which the monthly layouts spread evenly across the fiscal year's periods. A period from a different fiscal year is treated like an annual amount.
GLAccountIdGL AccountLookup → GLAccountThe account being budgeted; only active accounts are offered. Budget vs Actual shows the line only if this is a profit and loss account of the budget's company, so lines on balance sheet accounts are stored but never shown.
IdIdGuidYes
ModifiedByIdModified ByLookup → UserAccountYes
NameGL Account NameText, uniqueYesA label for the line, typed by the user. Required, and unique across every budget line in the organisation, not only within one budget, so include the budget in it (for example FY27-OPS Travel). Nothing in the comparison reads it.
OwnerIdOwnerLookup → UserAccountYes
PartnerAccountIdPartner AccountLookup → AccountThe company, repeated on the line. Not on the standard line form and not filled in automatically; Budget vs Actual uses the budget header's company instead.
RecordTypeIdRecord TypeGuid, hidden
UIPropsUI PropsText
UpdatedDateTimeUpdated OnDateAndTimeYes

Actions

ActionLabelTypeWhat it does
BulkDeleteDeleteDeleteDelete the selected records.
CloneCloneServerAction (Clone)Create a copy of this record
DeleteDeleteDeleteDelete
DeleteInListDeleteDeleteDelete in a list page
EditEditEditEdit
EditListRowEditEditEditListRow
NewNewNewNew

Lookup filters

FilterLookup fieldNotes
GL Account FilterGLAccountId