JournalEntries
Stores journal entries that record double-entry accounting adjustments, including debits and credits applied to accounts, used for financial corrections and accruals.
Table Specific Information
JournalEntries may be inserted, queried, or updated via the JournalEntries or JournalEntryLineItems tables. JournalEntries may be deleted by using the JournalEntries table.
Select
All filterable columns support the following operators:
- =
- !=
- >=
- <=
- >
- <
- IN
- LIKE
- CONTAINS
The driver processes other filters client-side within the driver.
Insert
To add a JournalEntry, there must be at least one credit line and at least one debit line where the total of the debit and credit Lines are equal to each other. The LineAggregate column may be used to specify an XML aggregate of Line Item data. Each _ denotes hierarchy. Use <Line> at the base level. The contents of LineAggregate will be sent to the API as is. All values for each field in the aggregate should adhere to the API's specifications (e.g. for dates in format yyyy-MM-dd, for date times in format yyyy-MM-dd'T'HH:mm:sszzz).The columns that may be used in the aggregates begin with the prefix 'Line_' to indicate they are part of the line item. Use the Line_ column along with the DocNumber to indicate which lines go with which JournalEntries. For example:
INSERT INTO JournalEntries (LineAggregate)
VALUES ('
<Line><Amount>0.02</Amount><DetailType>JournalEntryLineDetail</DetailType><JournalEntryLineDetail><PostingType>Debit</PostingType><Entity><Type>Customer</Type><EntityRef>24</EntityRef></Entity><AccountRef>33</AccountRef></JournalEntryLineDetail></Line>
<Line><Amount>0.02</Amount><DetailType>JournalEntryLineDetail</DetailType><JournalEntryLineDetail><PostingType>Credit</PostingType><AccountRef>14</AccountRef></JournalEntryLineDetail></Line>
')
Columns
| Name | Type | ReadOnly | References | Filterable | Sortable | Description |
| Id [KEY] | String | True | True | True |
Specifies the unique identifier (Id) of the journal entry. This value is assigned by QuickBooks Online and is used to reference the journal entry in other operations. | |
| SyncToken | String | True | False | False |
Specifies the version number of the journal entry. This version number is used to lock the object for use by one app at a time. When an application modifies an object, its sync token is incremented. Attempts to modify an object specifying an older sync token fail. Only the latest version of the object is maintained by QuickBooks Online. | |
| MetaData_CreateTime | Datetime | True | True | True |
Specifies the date and time when the journal entry record was created. This value is system-generated and is useful for auditing and tracking changes. | |
| MetaData_LastUpdatedTime | Datetime | True | True | True |
Specifies the date and time when the journal entry record was last updated. This value is system-generated and is useful for auditing and tracking changes. | |
| DocNumber | String | False | True | True |
Specifies the reference number for the transaction. This value can be used to cross-reference this journal entry with external documents or internal control numbers. | |
| TxnDate | Date | False | True | True |
Specifies the date entered by the user when this transaction occurred. This date determines the posting period for the journal entry. | |
| PrivateNote | String | False | False | False |
Specifies a private note about the transaction. This note does not appear on the transaction records by default and can be used for internal remarks or workflow tracking. | |
| Adjustment | Boolean | False | False | False |
Indicates whether the journal entry is an adjustment entry. Adjustment entries are typically used for year-end or period-end corrections and can affect how amounts are displayed in financial reports. | |
| LineAggregate | String | False | False | False |
Contains an XML aggregate of the line items that are part of the journal entry transaction. Each line item represents a debit or credit posting with account references, classes, customers, or other applicable metadata. | |
| TxnTaxDetail_TxnTaxCodeRef | String | False |
TaxCodes.Id | False | False |
Specifies the tax code that is applied to the transaction. This code determines how tax is calculated on the journal entry lines and links to the tax agency and rules configured in QuickBooks Online. |
| TxnTaxDetail_TotalTax | String | False | False | False |
Specifies the total tax calculated for the transaction, excluding any tax lines that are manually inserted into the transaction line list. This value is computed based on the assigned tax code. | |
| TxnTaxDetail_TaxLineAggregate | String | False | False | False |
Contains an XML aggregate of tax line items that are applied to the journal entry transaction. This aggregate includes each tax component or jurisdictional tax line that is calculated from the tax code rules. | |
| TotalAmt | Decimal | True | False | False |
Specifies the total amount of the transaction. This value is calculated by QuickBooks Online business logic, and any value you supply is overwritten by QuickBooks to ensure consistency. | |
| CurrencyRef | String | False | False | False |
Specifies the Id of the currency used in the transaction. This field links to the currency configuration that is used to value amounts in the journal entry. | |
| CurrencyRef_Name | String | True | False | False |
Specifies the name of the currency used in the transaction. This is the readable name that is associated with the currency Id. | |
| ExchangeRate | Decimal | False | False | False |
Specifies the currency exchange rate for the transaction. This field is valid only when the company file uses the multicurrency feature. In QuickBooks, exchange rates are always recorded as the number of home currency units it takes to equal one foreign currency unit. This field is available in only the UK, AU, and CA editions. | |
| TransactionLocationType | String | False | False | False |
Specifies the account location that is associated with the transaction. This field is valid in only the FR editions. The allowed values are WithinFrance, FranceOverseas, OutsideFranceWithEU, OutsideEU. | |
| TaxRateRef | String | False |
TaxRates.Id | False | False |
Specifies the Id of the tax adjustment rate that is applied to this journal entry. This Id links to the TaxRate entity in QuickBooks Online, which defines the tax rate percentage, tax agency, and jurisdiction details used to compute taxes. |
| TaxRateRef_Name | String | True | False | False |
Specifies the name that is associated with the tax adjustment rate identifier for this journal entry. | |
| HomeTotalAmt | Decimal | True | False | False |
Specifies the total amount of the transaction, expressed in the home currency. This includes the total of all the charges, allowances, and taxes. This field is valid in the UK, AU, and CA editions. | |
| RecurDataRef | String | True | False | False |
Specifies the identifier of the reference to the recurring transaction. It captures which recurring transaction template the journal entry was created from. | |
| GlobalTaxCalculation | String | True | False | False |
Specifies the method in which tax is applied to the journal entry transaction. The allowed values are TaxExcluded, TaxInclusive. |