Xero Accounting Endpoint: JournalsAccrual - Revision history

Nic at 22:47, 23 January 2023

2023-01-23T22:47:52Z

← Older revision		Revision as of 17:47, 23 January 2023
Line 2:		Line 2:

	The Xero '''JournalsAccrual''' [[Xero Accounting Endpoints\|endpoint]] provides the journal records on an accrual basis that had a material impact on your general ledger.		The Xero '''JournalsAccrual''' [[Xero Accounting Endpoints\|endpoint]] provides the journal records on an accrual basis that had a material impact on your general ledger.

			Note an alternate endpoint named [[Xero Accounting Endpoint: JournalsAccrualTable\|JournalsAccrualTable]] is available which provides a format that can more easily integrate with Tableau, SSIS and Azure Data Factory.

	This endpoint does not internally support filters due to the Xero API Architecture. Only the '''JournalNumber''', '''JournalDate''' and '''CreatedDateUTC''' fields can be filtered. Furthermore, these fields do not support all types of operators or complex filters.		This endpoint does not internally support filters due to the Xero API Architecture. Only the '''JournalNumber''', '''JournalDate''' and '''CreatedDateUTC''' fields can be filtered. Furthermore, these fields do not support all types of operators or complex filters.

Nic at 22:14, 21 March 2022

2022-03-21T22:14:46Z

← Older revision		Revision as of 17:14, 21 March 2022
Line 3:		Line 3:
	The Xero '''JournalsAccrual''' [[Xero Accounting Endpoints\|endpoint]] provides the journal records on an accrual basis that had a material impact on your general ledger.		The Xero '''JournalsAccrual''' [[Xero Accounting Endpoints\|endpoint]] provides the journal records on an accrual basis that had a material impact on your general ledger.

	This endpoint does not internally support filters due to the Xero API Architecture. Only the '''JournalNumber''' and '''CreatedDateUTC''' fields can be filtered. Furthermore, these fields ~~only~~ support ~~the GREATER THAN (gt aka >) and GREATER OR EQUAL (ge aka >=)~~ operators.		This endpoint does not internally support filters due to the Xero API Architecture. Only the '''JournalNumber''', '''JournalDate''' and '''CreatedDateUTC''' fields can be filtered. Furthermore, these fields do not support all types of operators or complex filters.

	For journals on a cash basis, see [[Xero Accounting Endpoint: JournalsCash\|JournalsCash]].		For journals on a cash basis, see [[Xero Accounting Endpoint: JournalsCash\|JournalsCash]].

Nic at 00:03, 1 February 2022

2022-02-01T00:03:18Z

← Older revision		Revision as of 19:03, 31 January 2022
Line 2:		Line 2:

	The Xero '''JournalsAccrual''' [[Xero Accounting Endpoints\|endpoint]] provides the journal records on an accrual basis that had a material impact on your general ledger.		The Xero '''JournalsAccrual''' [[Xero Accounting Endpoints\|endpoint]] provides the journal records on an accrual basis that had a material impact on your general ledger.

			This endpoint does not internally support filters due to the Xero API Architecture. Only the '''JournalNumber''' and '''CreatedDateUTC''' fields can be filtered. Furthermore, these fields only support the GREATER THAN (gt aka >) and GREATER OR EQUAL (ge aka >=) operators.

	For journals on a cash basis, see [[Xero Accounting Endpoint: JournalsCash\|JournalsCash]].		For journals on a cash basis, see [[Xero Accounting Endpoint: JournalsCash\|JournalsCash]].

Nic at 01:02, 11 January 2022

2022-01-11T01:02:59Z

← Older revision		Revision as of 20:02, 10 January 2022
Line 103:		Line 103:
	:A [[Field Type: Text\|text field]] that provides the [[Xero Accounting Field: TaxTypes\|tax type]].		:A [[Field Type: Text\|text field]] that provides the [[Xero Accounting Field: TaxTypes\|tax type]].

	;~~TaxType~~		;TaxName
	:A [[Field Type: Text\|text field]] that provides the name of the tax rate.		:A [[Field Type: Text\|text field]] that provides the name of the tax rate.

Nic at 01:01, 11 January 2022

2022-01-11T01:01:38Z

← Older revision		Revision as of 20:01, 10 January 2022
Line 90:		Line 90:

	;NetAmount		;NetAmount
	:A [[Field Type: Decimal\|decimal field]] that tax exclusive amount.		:A [[Field Type: Decimal\|decimal field]] that provides the tax exclusive amount.
			:This will be a positive value for a debit and negative for a credit

	;GrossAmount		;GrossAmount
	:A [[Field Type: Decimal\|decimal field]] that tax inclusive amount.		:A [[Field Type: Decimal\|decimal field]] that tax provides the inclusive amount.
			:This field is calculated as NetAmount + TaxAmount.

	;TaxAmount		;TaxAmount

Nic at 05:20, 22 September 2021

2021-09-22T05:20:09Z

← Older revision		Revision as of 00:20, 22 September 2021
Line 1:		Line 1:
	== Overview ==		== Overview ==

	The Xero '''JournalsAccrual''' [[Endpoints\|endpoint]] provides the journal records on an accrual basis that had a material impact on your general ledger.		The Xero '''JournalsAccrual''' [[Xero Accounting Endpoints\|endpoint]] provides the journal records on an accrual basis that had a material impact on your general ledger.

	For journals on a cash basis, see [[Xero Accounting Endpoint: JournalsCash\|JournalsCash]].		For journals on a cash basis, see [[Xero Accounting Endpoint: JournalsCash\|JournalsCash]].
Line 126:		Line 126:
	:[[Xero Accounting Endpoint: TaxRates\|TaxRates]]		:[[Xero Accounting Endpoint: TaxRates\|TaxRates]]
	:[[Xero Accounting Endpoint: TrackingCategories\|TrackingCategories]]		:[[Xero Accounting Endpoint: TrackingCategories\|TrackingCategories]]


			== Related Topics ==

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

Nic at 04:21, 22 September 2021

2021-09-22T04:21:12Z

← Older revision		Revision as of 23:21, 21 September 2021
Line 90:		Line 90:

	;NetAmount		;NetAmount
	:A [[Field Type: Decimal\|decimal ~~value~~]] that tax exclusive amount.		:A [[Field Type: Decimal\|decimal field]] that tax exclusive amount.

	;GrossAmount		;GrossAmount
	:A [[Field Type: Decimal\|decimal ~~value~~]] that tax inclusive amount.		:A [[Field Type: Decimal\|decimal field]] that tax inclusive amount.

	;TaxAmount		;TaxAmount
	:A [[Field Type: Decimal\|decimal ~~value~~]] that tax amount.		:A [[Field Type: Decimal\|decimal field]] that tax amount.

	;TaxType		;TaxType

Nic: Created page with "== Overview == The Xero '''JournalsAccrual''' endpoint provides the journal records on an accrual basis that had a material impact on your general ledger. For..."

2021-09-20T06:04:50Z

Created page with "== Overview == The Xero '''JournalsAccrual''' endpoint provides the journal records on an accrual basis that had a material impact on your general ledger. For..."

New page

== Overview ==

The Xero '''JournalsAccrual''' [[Endpoints|endpoint]] provides the journal records on an accrual basis that had a material impact on your general ledger.

For journals on a cash basis, see [[Xero Accounting Endpoint: JournalsCash|JournalsCash]].

== Fields ==

The following fields are available for the JournalsAccrual endpoint.

;JournalID
:A [[Field Type: GUID|guid field]] that provides the id of the journal record.

;JournalDate
:A [[Field Type: Date|date field]] that provides the date to which the journal record applies.

;JournalNumber
:A [[Field Type: Text|text field]] provides the journal number.
:This is a auto-generated sequential number that doesn't correspond or relate to the transaction/invoice number.

;Reference
:A [[Field Type: Text|text field]] provides a descriptive reference (could be an invoice numnber or reference).

;SourceID
:A [[Field Type: GUID|guid field]] that provides the source unique id of the transaction that generated this journal.
:This can be linked to other endpoints.

;SourceType
:A [[Field Type: Text|text field]] provides a indicates the source of the journal record.
:Possible values are:
:* '''ACCREC''': Accounts receivable invoice
:* '''ACCPAY''': Accounts payable invoice
:* '''ACCRECCREDIT''': Accounts receivable credit note
:* '''ACCPAYCREDIT''': Accounts payable credit note
:* '''ACCRECPAYMENT''': Payment on an accounts receivable invoice
:* '''ACCPAYPAYMENT''': Payment on an accounts payable invoice
:* '''ARCREDITPAYMENT''': Accounts receivable credit note payment
:* '''APCREDITPAYMENT''': Accounts payable credit note payment
:* '''CASHREC''': Receive money bank transaction
:* '''CASHPAID''': Spend money bank transaction
:* '''TRANSFER''': Bank transfer
:* '''ARPREPAYMENT''': Accounts receivable prepayment
:* '''APPREPAYMENT''': Accounts payable prepayment
:* '''AROVERPAYMENT''': Accounts receivable overpayment
:* '''APOVERPAYMENT''': Accounts payable overpayment
:* '''EXPCLAIM''': Expense claim
:* '''EXPPAYMENT''': Expense claim payment
:* '''MANJOURNAL''': Manual journal
:* '''PAYSLIP''': Payslip
:* '''WAGEPAYABLE''': Payroll payable
:* '''INTEGRATEDPAYROLLPE''': Payroll expense
:* '''INTEGRATEDPAYROLLPT''': Payroll payment
:* '''EXTERNALSPENDMONEY''': Payroll employee payment
:* '''INTEGRATEDPAYROLLPTPAYMENT''': Payroll tax payment
:* '''INTEGRATEDPAYROLLCN''': Payroll credit note

;JournalLines
:A [[Field Type: Table|table field]] that provides the list account values applicable for this journal record.
:See [[#JournalLines Fields|JournalLines Fields]] for more information.

;CreatedDateUTC
:A [[Field Type: DateTimeOffset|date time field]] that indicates the date and time this journal was created.

== JournalLines Fields ==

The [[#Fields|JournalLines Fields]] include the following sub fields.

;JournalLineID
:A [[Field Type: GUID|guid field]] that provides the id of the journal record.
:This field cannot really be linked to other endpoints.

;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.

;AccountCode
:A [[Field Type: Text|text field]] that provides the account code.
:This field can be used to link to the [[Xero Accounting Endpoint: Accounts|Accounts]] endpoints.

;AccountType
:A [[Field Type: Text|text field]] that provides the [[Xero Accounting Field: AccountTypes|account type]].

;AccountName
:A [[Field Type: Text|text field]] that provides account name.

;Description
:A [[Field Type: Text|text field]] that provides line description.

;NetAmount
:A [[Field Type: Decimal|decimal value]] that tax exclusive amount.

;GrossAmount
:A [[Field Type: Decimal|decimal value]] that tax inclusive amount.

;TaxAmount
:A [[Field Type: Decimal|decimal value]] that tax amount.

;TaxType
:A [[Field Type: Text|text field]] that provides the [[Xero Accounting Field: TaxTypes|tax type]].

;TaxType
:A [[Field Type: Text|text field]] that provides the name of the tax rate.

;TrackingCategories
:A [[Field Type: Table|table field]] that provides the list [[Xero Accounting Field: TrackingCategories|tracking categories]] assigned to this journal line.

== Xero API ==

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

== Related Fields ==

:[[Xero Accounting Field: AccountTypes|AccountTypes]]
:[[Xero Accounting Field: TaxTypes|TaxTypes]]
:[[Xero Accounting Field: TrackingCategories|TrackingCategories]]

== Related Endpoints ==

:[[Xero Accounting Endpoint: Accounts|Accounts]]
:[[Xero Accounting Endpoint: JournalsCash|JournalsCash]]
:[[Xero Accounting Endpoint: TaxRates|TaxRates]]
:[[Xero Accounting Endpoint: TrackingCategories|TrackingCategories]]