Xero Accounting Endpoint: JournalsCash
Jump to navigation
Jump to search
Overview
The Xero JournalsCash endpoint provides the journal records on an cash basis that had a material impact on your general ledger.
For journals on an accrual basis, see JournalsAccrual.
Fields
The following fields are available for the JournalsCash endpoint.
- JournalID
- A guid field that provides the id of the journal record.
- JournalDate
- A date field that provides the date to which the journal record applies.
- JournalNumber
- A 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 text field provides a descriptive reference (could be an invoice numnber or reference).
- SourceID
- A guid field that provides the source unique id of the transaction that generated this journal.
- This can be linked to other endpoints.
- SourceType
- A 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 table field that provides the list account values applicable for this journal record.
- See JournalLines Fields for more information.
- CreatedDateUTC
- A date time field that indicates the date and time this journal was created.
JournalLines Fields
The JournalLines Fields include the following sub fields.
- JournalLineID
- A guid field that provides the id of the journal record.
- This field cannot really be linked to other endpoints.
- AccountID
- A GUID field that provides the id of the account.
- This field can be used to link to the Accounts endpoints.
- AccountCode
- A text field that provides the account code.
- This field can be used to link to the Accounts endpoints.
- AccountType
- A text field that provides the account type.
- AccountName
- A text field that provides account name.
- Description
- A text field that provides line description.
- NetAmount
- A decimal value that tax exclusive amount.
- GrossAmount
- A decimal value that tax inclusive amount.
- TaxAmount
- A decimal value that tax amount.
- TaxType
- A text field that provides the tax type.
- TaxType
- A text field that provides the name of the tax rate.
- TrackingCategories
- A table field that provides the list tracking categories assigned to this journal line.
Xero API
For a detailed run through of the endpoint, you can see the Xero API.
Related Fields