Nic: Created page with "== Overview == The Xero '''BalanceSheetAdvanced''' endpoint provides closing balance sheet values for a range of parameters to produce a number..."

2024-09-05T03:26:47Z

Created page with "== Overview == The Xero '''BalanceSheetAdvanced''' endpoint provides closing balance sheet values for a range of parameters to produce a number..."

New page

== Overview ==

The Xero '''BalanceSheetAdvanced''' [[Xero Accounting Endpoints|endpoint]] provides closing balance sheet values for a range of parameters to produce a number of different values.

It is a [[Function Endpoints|function]] that accepts a series of parameters.

== Parameters ==

The BalanceSheetAdvanced is a [[Function Endpoints|function]] that accepts the following parameters.

;FromDate
:A [[Field Type: Date|date field]] that determines the start date for which to produce values.
:If omitted, it will use the first date of the last calendar month.

;ToDate
:A [[Field Type: Date|date field]] that determines the end date for which to produce values.
:If omitted, it will use the last date of the last calendar month.

;PaymentsOnly
:A [[Field Type: Boolean|true/false field]] that determines if only payments are included.
:If omitted, it will be set to False.

;StandardLayout
:A [[Field Type: Boolean|true/false field]] that determines if the values are produced only for accounts that are in the [[Xero Accounting Endpoint: Accounts|accounts]] endpoint.
:If omitted, it will be set to True.

;Periods
:A [[Field Type: Integer|whole number field]] that determines the number of additional periods to include on the report. It must be used in conjunction with the '''TimeFrame''' parameter.
:If omitted, it will not include additional periods.
:Possible values are 1 to 11.

;TimeFrame
:A [[Field Type: Text|text field]] that specifies what type of periods to compare. It must be used in conjunction with the '''Periods''' parameter.
:If omitted, it will not include additional periods.
:Possible values are:
:* '''Month'''
:* '''Quarter'''
:* '''Year'''

;TrackingOptionID
:A [[Field Type: GUID|guid field]] that specifies the specific [[Xero Accounting Endpoint: TrackingCategories|tracking category option]].
:If omitted, OdataLink will choose one present within Xero.

;TrackingOptionID2
:A [[Field Type: GUID|guid field]] that specifies a secondary list [[Xero Accounting Endpoint: TrackingCategories|tracking category options]].
:If omitted, OdataLink will only provide data for a single [[Xero Accounting Endpoint: TrackingCategories|tracking category option]] as specified by '''TrackingCategoryID''' and '''TrackingOptionID'''.

== Fields ==

The following fields are available for the '''BalanceSheetAdvanced''' endpoint.

;DataFileID
:A [[Field Type: GUID|guid field]] that provides the id of the xero data file as setup in OdataLink.

;DataFileName
:A [[Field Type: Text|text field]] provides the name of the xero data file as setup in OdataLink.

;DataFileCode
:A [[Field Type: Text|text field]] provides the code of the xero data file as setup in OdataLink.

;Date
:A [[Field Type: Date|date field]] that indicates the end date used to produce the values.
:This will match the ToDate entered as [[#Parameters|parameter]].

;Period
:A [[Field Type: Text|text field]] that indicates the periods that are being queried.
:Possible values are:
:* '''Month'''
:* '''Quarter'''
:* '''Year'''

;PaymentsOnly
:A [[Field Type: Boolean|true/false field]] that indicates if only payments are included.
:This will match the PaymentsOnly entered as [[#Parameters|parameter]].

;StandardLayout
:A [[Field Type: Boolean|true/false field]] that indicates if values are produced only for accounts that are in the [[Xero Accounting Endpoint: Accounts|accounts]] endpoint.
:This will match the StandardLayout entered as [[#Parameters|parameter]].

;Periods
:A [[Field Type: Integer|whole number field]] that indicates the number of additional comparison periods to include.
:This will match the Periods entered as [[#Parameters|parameter]].

;TimeFrame
:A [[Field Type: Text|table field]] that indicates what type of periods to compare.
:This will match the TimeFrame entered as [[#Parameters|parameter]].

;TrackingOptionID
:A [[Field Type: GUID|guid field]] that indicates the [[Xero Accounting Endpoint: TrackingCategories|tracking option]] used.
:This will match the TrackingOptionID entered as [[#Parameters|parameter]].

;TrackingOptionID2
:A [[Field Type: GUID|guid field]] that indicates the [[Xero Accounting Endpoint: TrackingCategories|tracking option]] used.
:This will match the TrackingOptionID2 entered as [[#Parameters|parameter]].

;LineType
:A [[Field Type: Text|text field]] that indicates the type of line.
:Possible values are:
:* '''Header''': Indicates the row contains a header.
:* '''Detail''': Indicates the row contains the value of a given account.
:* '''Total''': Indicates the row contains a calculated value.

;AccountID
:A [[Field Type: GUID|GUID field]] that provides the id of the account.
:This field can be used to link to the [[Xero Accounting Endpoint: Accounts|Accounts]] endpoints.
:This field will be set to null for rows whose '''LineType''' is not set to '''Detail'''.

;AccountName
:A [[Field Type: Text|text field]] that provides the account name or the name of a header or total.

;AccountLineType
:A [[Field Type: Text|text field]] that provides the a descriptive field to indicate the type of account or row.

;LineDescription
:A [[Field Type: Text|text field]] that provides the generic description for this amount.

;Amount
:A [[Field Type: Decimal|decimal field]] that provides the value for the row.

== Xero API ==

For a detailed run through of the endpoint, you can see the [https://developer.xero.com/documentation/api/accounting/reports#balance-sheet Xero API].

== Related Fields ==

:None

== Related Endpoints ==

:[[Xero Accounting Endpoint: Accounts|Accounts]]
:[[Xero Accounting Endpoint: BalanceSheet|BalanceSheet]]
:[[Xero Accounting Endpoint: BalanceSheetByMonth|BalanceSheetByMonth]]
:[[Xero Accounting Endpoint: BalanceSheetTable|BalanceSheetTable]]
:[[Xero Accounting Endpoint: BalanceSheetMultiPeriodTable|BalanceSheetMultiPeriodTable]]
:[[Xero Accounting Endpoint: BalanceSheetByTrackingOption|BalanceSheetByTrackingOption]]

== Related Topics ==

:[[Xero Accounting Models]]
:[[Xero Accounting Endpoints]]

Xero Accounting Endpoint: BalanceSheetAdvanced - Revision history

Nic: Created page with "== Overview == The Xero '''BalanceSheetAdvanced''' endpoint provides closing balance sheet values for a range of parameters to produce a number..."