Get Journal Entries

GET

/qje

GET

/v1/qje

curl https://api.gappify.com/v1/qje \
     -H "Authorization: Bearer <token>"

[
  {
    "id": 1,
    "name": "name",
    "vendor_id": "vendor_id",
    "subsidiary": "subsidiary",
    "subsidiary_id": "subsidiary_id",
    "department": "department",
    "department_id": "department_id",
    "glaccount": "glaccount",
    "glaccount_id": "glaccount_id",
    "class": "class",
    "class_id": "class_id",
    "project": "project",
    "project_id": "project_id",
    "currency": "currency",
    "currency_id": "currency_id",
    "debit": 1.1,
    "credit": 1.1,
    "je_date": "2023-01-15",
    "je_reversal_date": "2023-01-15",
    "je_memo": "je_memo",
    "line_description": "line_description",
    "status": "POSTED",
    "period": "2023-01-15",
    "po_source_system_id": 1,
    "po_number": "po_number",
    "po_line_id": "po_line_id",
    "po_line_description": "po_line_description",
    "po_line_amount": 1.1,
    "created_at": "2024-01-15T09:30:00Z",
    "updated_at": "2024-01-15T09:30:00Z",
    "external_id": "external_id",
    "location": "location",
    "location_id": "location_id",
    "preparer": "preparer",
    "group_id": "group_id",
    "posted_by": "posted_by",
    "posted_at": "2024-01-15T09:30:00Z",
    "region": "region",
    "region_id": "region_id",
    "je_id": "je_id",
    "service_start_date": "2023-01-15",
    "service_end_date": "2023-01-15",
    "company": "company",
    "company_id": "company_id",
    "intercompany": "intercompany",
    "intercompany_id": "intercompany_id",
    "channel": "channel",
    "channel_id": "channel_id",
    "je_reject_reason": "je_reject_reason",
    "rejected_by": "rejected_by",
    "rejected_at": "2024-01-15T09:30:00Z",
    "threshold_support_document": "threshold_support_document",
    "product": "product",
    "product_id": "product_id",
    "je_batch": "je_batch",
    "resubmitted": true,
    "deleted_at": "2024-01-15T09:30:00Z",
    "reviewed": true,
    "reporting_amount": 1.1,
    "subsidiary_amount": 1.1,
    "reporting_currency": "reporting_currency",
    "subsidiary_currency": "subsidiary_currency",
    "reporting_currency_id": "reporting_currency_id",
    "subsidiary_currency_id": "subsidiary_currency_id",
    "po_line_amount_usd": 1.1,
    "po_balance_usd": 1.1,
    "error_details": "error_details",
    "prepaid_account": "prepaid_account",
    "prepaid_account_id": "prepaid_account_id",
    "is_prepaid": true,
    "custom_text_1": "custom_text_1",
    "custom_text_2": "custom_text_2",
    "custom_text_3": "custom_text_3",
    "custom_text_4": "custom_text_4",
    "custom_text_5": "custom_text_5",
    "custom_date_1": "2023-01-15",
    "custom_date_2": "2023-01-15",
    "custom_date_3": "2023-01-15",
    "custom_date_4": "2023-01-15",
    "custom_date_5": "2023-01-15",
    "custom_numeric_1": 1.1,
    "custom_numeric_2": 1.1,
    "custom_numeric_3": 1.1,
    "custom_numeric_4": 1.1,
    "custom_numeric_5": 1.1
  },
  {
    "id": 1,
    "name": "name",
    "vendor_id": "vendor_id",
    "subsidiary": "subsidiary",
    "subsidiary_id": "subsidiary_id",
    "department": "department",
    "department_id": "department_id",
    "glaccount": "glaccount",
    "glaccount_id": "glaccount_id",
    "class": "class",
    "class_id": "class_id",
    "project": "project",
    "project_id": "project_id",
    "currency": "currency",
    "currency_id": "currency_id",
    "debit": 1.1,
    "credit": 1.1,
    "je_date": "2023-01-15",
    "je_reversal_date": "2023-01-15",
    "je_memo": "je_memo",
    "line_description": "line_description",
    "status": "POSTED",
    "period": "2023-01-15",
    "po_source_system_id": 1,
    "po_number": "po_number",
    "po_line_id": "po_line_id",
    "po_line_description": "po_line_description",
    "po_line_amount": 1.1,
    "created_at": "2024-01-15T09:30:00Z",
    "updated_at": "2024-01-15T09:30:00Z",
    "external_id": "external_id",
    "location": "location",
    "location_id": "location_id",
    "preparer": "preparer",
    "group_id": "group_id",
    "posted_by": "posted_by",
    "posted_at": "2024-01-15T09:30:00Z",
    "region": "region",
    "region_id": "region_id",
    "je_id": "je_id",
    "service_start_date": "2023-01-15",
    "service_end_date": "2023-01-15",
    "company": "company",
    "company_id": "company_id",
    "intercompany": "intercompany",
    "intercompany_id": "intercompany_id",
    "channel": "channel",
    "channel_id": "channel_id",
    "je_reject_reason": "je_reject_reason",
    "rejected_by": "rejected_by",
    "rejected_at": "2024-01-15T09:30:00Z",
    "threshold_support_document": "threshold_support_document",
    "product": "product",
    "product_id": "product_id",
    "je_batch": "je_batch",
    "resubmitted": true,
    "deleted_at": "2024-01-15T09:30:00Z",
    "reviewed": true,
    "reporting_amount": 1.1,
    "subsidiary_amount": 1.1,
    "reporting_currency": "reporting_currency",
    "subsidiary_currency": "subsidiary_currency",
    "reporting_currency_id": "reporting_currency_id",
    "subsidiary_currency_id": "subsidiary_currency_id",
    "po_line_amount_usd": 1.1,
    "po_balance_usd": 1.1,
    "error_details": "error_details",
    "prepaid_account": "prepaid_account",
    "prepaid_account_id": "prepaid_account_id",
    "is_prepaid": true,
    "custom_text_1": "custom_text_1",
    "custom_text_2": "custom_text_2",
    "custom_text_3": "custom_text_3",
    "custom_text_4": "custom_text_4",
    "custom_text_5": "custom_text_5",
    "custom_date_1": "2023-01-15",
    "custom_date_2": "2023-01-15",
    "custom_date_3": "2023-01-15",
    "custom_date_4": "2023-01-15",
    "custom_date_5": "2023-01-15",
    "custom_numeric_1": 1.1,
    "custom_numeric_2": 1.1,
    "custom_numeric_3": 1.1,
    "custom_numeric_4": 1.1,
    "custom_numeric_5": 1.1
  }
]

Retrieve a list of Journal Entries based on specified filters.

Authentication

AuthorizationBearer

Bearer authentication of the form Bearer <token>, where token is your auth token.

Query parameters

perioddateOptional

Period for which the journal entry is being posted. Will be in the YYYY-MM-DD format. It will be set to the current period if not provided

statusenumOptional

Holds the status of the journal entry line.

POSTED: If the QJE Roundtrip integration is implemented, this status confirms that the JE has been successfully created in the ERP.
UNPOSTED: The QJE has been created from Transaction data but has not yet been submitted to the ERP.
REJECTED: The QJE Manager has rejected the QJE and sent it back to Transactions for review and updates.
FAILED: If the QJE Roundtrip integration is implemented, this status indicates that the JE was rejected by the ERP. Users can make the necessary corrections in Transactions and resubmit the QJE for processing.
EXTRACTED: The QJE Manager has clicked “Submit JE”, and the QJE has been queued for processing in the ERP.

Allowed values:

vendor_idstringOptional

Id of the Vendor/Supplier. This value will match the source/vendors:source_system_id.

created_atdatetimeOptional

Journal Entry created date and time stamp.

updated_atdatetimeOptional

Journal Entry updated date and time stamp.

exclude_pendingbooleanOptional

Filters out records already in progress to avoid double processing. Must be combined with status=extracted, returns available records and marks them with a temporary Pending ID lock.

resubmittedbooleanOptional

Indicates if the Journal Entry was resubmitted after being rejected within Gappify. It is either 0 (False) or 1 (True).

reviewedbooleanOptional

Indicates if the Journal Entry was reviewed at any point. It is either 0 (False) or 1 (True).

Response

List of Journal Entry retrieved successfully.

idinteger

Gappify generated unique identifier for the journal entry.

namestring

Vendor/Supplier name.

vendor_idstring

Id of the Vendor/Supplier. This value will match the source/vendors:source_system_id.

subsidiarystring

Subsidiary name linked to the journal entry. This value will match the name in source/coa:name.

subsidiary_idstring

Subsidiary id linked to the journal entry. This value will match the source/coa:source_system_id.

departmentstring

Department name linked to the journal entry. This value will match the source/coa:name.

department_idstring

Department ID linked to the journal entry. This value will match the source/coa:source_system_id.

glaccountstring

GLAccount name linked to the journal entry. This value will match the source/coa:name.

glaccount_idstring

GLAccount ID linked to the journal entry. This value will match the source/coa:source_system_id.

classstring

Class name linked to the journal entry. This value will match the name in source_coas.

class_idstring

Class id linked to the journal entry. This value will match the source_system_id in source_coas.

projectstring

Project name linked to the journal entry. This value will match the name in source_coas.

project_idstring

Project id linked to the journal entry. This value will match the source_system_id in source_coas.

currencystring

Currency in which the transaction will be posted in the JE. Will match the name in the currency list of source_coas.

currency_idstring

Currency id in which the transaction will be posted in the JE. Will match the source_system_id in the currency list of source_coas.

debitdouble

Journal entry debit amount based on transaction currency. Will be blank for the credit line.

creditdouble

Journal entry credit amount based on transaction currency. Will be blank for the debit line.

je_datedate

Journal entry date as entered by the user when posting the lines. Will be in the YYYY-MM-DD format.

je_reversal_datedate

Journal entry reversal date as entered by the user when posting the lines. Will be in the YYYY-MM-DD format.

je_memostring

Journal entry memo description/details as entered by the user when posting the lines.

line_descriptionstring

Holds the value of the description field from the Transaction line record.

statusenum

Holds the status of the journal entry line.

POSTED: If the QJE Roundtrip integration is implemented, this status confirms that the JE has been successfully created in the ERP.
UNPOSTED: The QJE has been created from Transaction data but has not yet been submitted to the ERP.
REJECTED: The QJE Manager has rejected the QJE and sent it back to Transactions for review and updates.
FAILED: If the QJE Roundtrip integration is implemented, this status indicates that the JE was rejected by the ERP. Users can make the necessary corrections in Transactions and resubmit the QJE for processing.
EXTRACTED: The QJE Manager has clicked “Submit JE”, and the QJE has been queued for processing in the ERP.

Allowed values:

perioddate

Period for which the journal entry is being posted. Will be in the YYYY-MM-DD format.

po_source_system_idinteger

Purchase order Id on the journal entry for accrual manager lines originating from purchase order lines. It should match source/purchase_order:source_system_id

po_numberstring

Purchase order number on the journal entry for accrual manager lines originating from purchase order lines.

po_line_idstring

Purchase order line Id on the journal entry for accrual manager lines originating from purchase order lines.

po_line_descriptionstring

Purchase order line description on the journal entry for accrual manager lines originating from purchase order lines.

po_line_amountdouble

Purchase order line amount on the journal entry for accrual manager lines originating from purchase order lines.

created_atdatetime

QJE created date and time stamp.

updated_atdatetime

QJE updated date and time stamp.

external_idstring

Combination of Subsidiary, Transaction Currency, Date.

locationstring

Location name linked to the journal entry. This value will match the name in source_coas.

location_idstring

Location id linked to the journal entry. This value will match the source_system_id in source_coas.

preparerstring

Email of the user that prepared the QJE (Transaction to QJE).

group_idstring

Identifier shared by the debit/credit line pair. Use this value when updating status via POST /qje/status-batch.

posted_bystring

Email of the user that posted the journal entry.

posted_atdatetime

Datetime stamp of when the journal entry was flagged as posted. Auto updated when JE is updated with a non null je_id.

regionstring

Region name linked to the journal entry. This value will match the name in source_coas.

region_idstring

Region ID linked to the journal entry. This value will match the name in source_coas.

je_idstring

Record Id of the resulting journal entry in the customer ERP. This value will be used to create link between Gappify QJE and Customers journal entry. Upon successful creation in the ERP system, update Gappify with a valid non null value to change status to POSTED.

service_start_datedate

Purchase order line start date on the journal entry for accrual manager lines originating from purchase order lines. This field can also hold transaction level start date as provided by Vendors.

service_end_datedate

Purchase order line end date on the journal entry for accrual manager lines originating from purchase order lines. This field can also hold transaction level end date as provided by Vendors.

companystring

Company name linked to the journal entry. This value will match the name in source_coas.

company_idstring

Company id linked to the journal entry. This value will match the source_system_id in source_coas.

intercompanystring

Intercompany name linked to the journal entry. This value will match the name in source_coas.

intercompany_idstring

Intercompany id linked to the journal entry. This value will match the source_system_id in source_coas.

channelstring

Channel name linked to the journal entry. This value will match the name in source_coas.

channel_idstring

Channel id linked to the journal entry. This value will match the source_system_id in source_coas.

je_reject_reasonstring

Reason if the QJE was ever rejected or is currently in rejected status within Gappify.

rejected_bystring

Email of the user that rejected the journal entry within Gappify.

rejected_atdatetime

Datetime stamp of when the journal entry was flagged as rejected within Gappify.

threshold_support_documentstring

Supporting details (can be words or url) for the journal entry.

productstring

Product name linked to the journal entry. This value will match the name in source_coas.

product_idstring

Product id linked to the journal entry. This value will match the source_system_id in source_coas.

je_batchstring

Unique reference to a JE outbound file.

resubmittedboolean

Indicates if the QJE was resubmitted after being rejected within Gappify.

deleted_atdatetime

Indicates timestamp of when the JE is soft deleted

reviewedboolean

Indicates if the QJE was reviewed at any point.

reporting_amountdouble

The Reporting currency converted amount as available on the transaction line.

subsidiary_amountdouble

The Subsidiary currency converted amount as available on the transaction line.

reporting_currencystring

The Reporting currency stamped on the transaction line. This value is derived from the Company settings.

subsidiary_currencystring

The Subsidiary currency stamped on the transaction line.

reporting_currency_idstring

The Reporting currency id as linked to COA currency values.

subsidiary_currency_idstring

The Subsidiary currency id as linked to COA currency values.

po_line_amount_usddouble

Purchase order line amount in USD currency on the journal entry for accrual manager lines originating from purchase order lines.

po_balance_usddouble

Purchase order line balance amount in USD currency on the journal entry for accrual manager lines originating from purchase order lines.

error_detailsstring

Update the field with error details upon failure to POS JE to the respective system.

prepaid_accountstring

GL account name used for prepaid expenses when posting prepaid journal entries. Links to source_coas name.

prepaid_account_idstring

GL account ID used for prepaid expenses when posting prepaid journal entries. Links to source_coas source_system_id.

is_prepaidboolean

Indicates whether the journal entry line represents a prepaid expense transaction.

custom_text_1string

User-defined custom text field

custom_text_2string

User-defined custom text field

custom_text_3string

User-defined custom text field

custom_text_4string

User-defined custom text field

custom_text_5string

User-defined custom text field

custom_date_1date

User-defined custom date field

custom_date_2date

User-defined custom date field

custom_date_3date

User-defined custom date field

custom_date_4date

User-defined custom date field

custom_date_5date

User-defined custom date field

custom_numeric_1float