Xero Accounting Endpoint: JournalsAccrual: Difference between revisions

(6 intermediate revisions by the same user not shown)

Line 1:

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

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.

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

Line 90:

Line 94:

;NetAmount

:A [[Field Type: Decimal|decimal ~~value~~]] 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

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

:A [[Field Type: Decimal|decimal field]] that tax provides the inclusive amount.

:This field is calculated as NetAmount + TaxAmount.

;TaxAmount

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

:A [[Field Type: Decimal|decimal field]] that tax amount.

;TaxType

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

Line 126:

Line 132:

:[[Xero Accounting Endpoint: TaxRates|TaxRates]]

:[[Xero Accounting Endpoint: TrackingCategories|TrackingCategories]]

== Related Topics ==

:[[Xero Accounting Models]]

:[[Xero Accounting Endpoints]]

@@ Line 1: / Line 1: @@
 == 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.
+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.
 For journals on a cash basis, see [[Xero Accounting Endpoint: JournalsCash|JournalsCash]].
@@ Line 90: / Line 94: @@
 ;NetAmount
-:A [[Field Type: Decimal|decimal value]] 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
-:A [[Field Type: Decimal|decimal value]] that tax inclusive amount.
+:A [[Field Type: Decimal|decimal field]] that tax provides the inclusive amount.
+:This field is calculated as NetAmount + TaxAmount.
 ;TaxAmount
-:A [[Field Type: Decimal|decimal value]] that tax amount.
+:A [[Field Type: Decimal|decimal field]] that tax amount.
 ;TaxType
 :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.
@@ Line 126: / Line 132: @@
 :[[Xero Accounting Endpoint: TaxRates|TaxRates]]
 :[[Xero Accounting Endpoint: TrackingCategories|TrackingCategories]]
+== Related Topics ==
+:[[Xero Accounting Models]]
+:[[Xero Accounting Endpoints]]