Excel Add-In for NetSuite

Build 25.0.9434

accountingperiod

The AccountingPeriod table defines fiscal periods used for financial reporting, including start and end dates, and period statuses.

Columns

Name Type References Description
alllocked Boolean Indicates whether all transaction types are locked for this accounting period. This setting prevents any modifications, ensuring that financial reports remain accurate and compliant after period close.
allownonglchanges Boolean Indicates whether non-general ledger (non-GL) changes are permitted for this accounting period. This setting allows modifications to transactions that do not impact the general ledger, such as memo fields or classifications.
aplocked Boolean Indicates whether accounts payable (AP) transactions are locked for this accounting period. This setting prevents any modifications to vendor bills, payments, or related AP transactions after the period has closed.
arlocked Boolean Indicates whether accounts receivable (AR) transactions are locked for this accounting period. This restriction ensures that invoices, customer payments, and other AR transactions cannot be modified after closing.
closed Boolean Indicates whether the accounting period has been officially closed. A closed period prevents further financial activity and ensures compliance with financial reporting standards.
closedondate Date The date on which the accounting period was officially closed. This date helps track when financial statements were finalized and locked for auditing purposes.
enddate Date The last date of the accounting period, defining the range for financial reporting. This date determines when transactions are no longer recorded for this period.
fiscalcalendar String The fiscal calendar to which this accounting period belongs. This calendar setting ensures that financial reporting aligns with an organization's designated fiscal year structure.
isadjust Boolean Indicates whether this period is designated for adjustments only. Adjustment periods are typically used for post-closing corrections and financial reconciliations without affecting operational periods.
isinactive Boolean Indicates whether the accounting period is inactive. An inactive period is not available for new transactions but remains in historical records for reference and auditing.
isposting Boolean Indicates whether the period allows posting of financial transactions. Posting periods enable the entry of general ledger transactions, while non-posting periods can be reserved for reporting or adjustments.
isquarter Boolean Indicates whether this period represents a fiscal quarter. Quarterly periods are used for interim financial reporting and regulatory compliance.
isyear Boolean Indicates whether this period represents a fiscal year. Annual accounting periods are critical for financial statement preparation, tax reporting, and year-end closing processes.
parent String The parent accounting period in a hierarchical structure. This period is used for organizing periods within fiscal years, ensuring proper financial consolidation.
payrolllocked Boolean Indicates whether payroll transactions are locked for this accounting period. This setting ensures that employee payroll records and tax filings remain unchanged after processing.
periodname String The official name of the accounting period, used in financial reporting and transaction processing. This name typically follows a structured format, such as 'Q1 2025' or 'January 2025'.
startdate Date The first date of the accounting period, defining when financial transactions begin to be recorded for that period. This date establishes the reporting range for financial activities.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434