A journal entry can add, edit, or reverse a transaction to a journal. When writing journal entries, be sure to balance the general ledger by posting offsetting entries. A journal entry is an owned element of general ledger transaction (GLBATCH).


List Journal Entries

readByQuery

<readByQuery>
    <object>GLBATCH</object>
    <fields>*</fields>
    <query>JOURNAL = 'GJ'</query>
    <pagesize>100</pagesize>
</readByQuery>
<readByQuery>
    <object>GLBATCH</object>
    <fields>*</fields>
    <query>JOURNAL = 'GJ' AND STATE = 'S'</query>
    <pagesize>100</pagesize>
</readByQuery>

Parameters

Name Required Type Description
object Required string Use GLBATCH
fields Optional string Comma-separated list of fields on the object to list. For best performance and predictability, limit the number of fields. To return all fields, omit the element or provide * for the value.
query Required string SQL-like query based on fields on the object. Illegal XML characters must be properly encoded. The following SQL operators are supported: <, >, >=, <=, =, like, not like, in, not in. When doing NULL comparisons: IS NOT NULL, IS NULL. Multiple fields may be matched using the AND and OR operators. Joins are not supported. Single quotes in any operands must be escaped with a backslash - For example, the value Erik's Deli would become 'Erik\'s Deli'.
pagesize Optional integer Custom page size between 1 and 1000 items (Default: 100)

query

Name Required Type Description
STATE Optional string State of the journal entry. Use I for Draft, S for Submitted, X for Partially Approved, A for Approved, P for Posted, R for Declined, L for Reversal Pending, or Z for Reversed.

Get Journal Entry

read

<read>
    <object>GLBATCH</object>
    <keys>31</keys>
    <fields>*</fields>
</read>

Parameters

Name Required Type Description
object Required string Use GLBATCH
keys Required string Journal entry RECORDNO to get
fields Optional string Comma-separated list of fields on the object to get. For best performance and predictability, limit the number of fields. To return all fields, omit the element or provide * for the value.

Create Journal Entry

create

Create a journal entry with a reversal

<create>
    <GLBATCH>
        <JOURNAL>PYRJ</JOURNAL>
        <BATCH_DATE>03/31/2016</BATCH_DATE>
        <REVERSEDATE>04/01/2016</REVERSEDATE>
        <BATCH_TITLE>Payroll accrual 03/31/2016</BATCH_TITLE>
        <ENTRIES>
            <GLENTRY>
                <ACCOUNTNO>2080</ACCOUNTNO>
                <DEPARTMENT>ADMIN</DEPARTMENT>
                <LOCATION>100</LOCATION>
                <CURRENCY>USD</CURRENCY>
                <TR_TYPE>-1</TR_TYPE>
                <AMOUNT>1450.80</AMOUNT>
                <EXCH_RATE_TYPE_ID>Intacct Daily Rate</EXCH_RATE_TYPE_ID>
                <DESCRIPTION>Accrued salaries</DESCRIPTION>
            </GLENTRY>
            <GLENTRY>
                <ACCOUNTNO>6500</ACCOUNTNO>
                <DEPARTMENT>ADMIN</DEPARTMENT>
                <LOCATION>100</LOCATION>
                <CURRENCY>USD</CURRENCY>
                <TR_TYPE>1</TR_TYPE>
                <AMOUNT>1450.80</AMOUNT>
                <EXCH_RATE_TYPE_ID>Intacct Daily Rate</EXCH_RATE_TYPE_ID>
                <DESCRIPTION>Salary expense</DESCRIPTION>
            </GLENTRY>
        </ENTRIES>
    </GLBATCH>
</create>

Create a journal entry with a custom allocation

<create>
    <GLBATCH>
        <JOURNAL>PYRJ</JOURNAL>
        <BATCH_DATE>03/31/2016</BATCH_DATE>
        <REVERSEDATE>04/01/2016</REVERSEDATE>
        <BATCH_TITLE>Payroll accrual 03/31/2016</BATCH_TITLE>
        <ENTRIES>
            <GLENTRY>
                <ACCOUNTNO>2080</ACCOUNTNO>
                <DEPARTMENT>ADMIN</DEPARTMENT>
                <LOCATION>100</LOCATION>
                <CURRENCY>USD</CURRENCY>
                <TR_TYPE>-1</TR_TYPE>
                <AMOUNT>1450.80</AMOUNT>
                <EXCH_RATE_TYPE_ID>Intacct Daily Rate</EXCH_RATE_TYPE_ID>
                <DESCRIPTION>Accrued salaries</DESCRIPTION>
            </GLENTRY>
            <GLENTRY>
                <ACCOUNTNO>6500</ACCOUNTNO>
                <CURRENCY>USD</CURRENCY>
                <TR_TYPE>1</TR_TYPE>
                <AMOUNT>1450.80</AMOUNT>
                <EXCH_RATE_TYPE_ID>Intacct Daily Rate</EXCH_RATE_TYPE_ID>
                <DESCRIPTION>Salary expense</DESCRIPTION>
                <ALLOCATION>Custom</ALLOCATION>
                <SPLIT>
                    <AMOUNT>450.80</AMOUNT>
                    <LOCATIONID>100</LOCATIONID>
                    <DEPARTMENTID>ADMIN</DEPARTMENTID>
                </SPLIT>
                <SPLIT>
                    <AMOUNT>700.00</AMOUNT>
                    <LOCATIONID>100</LOCATIONID>
                    <DEPARTMENTID>SUPPORT</DEPARTMENTID>
                </SPLIT>
                <SPLIT>
                    <AMOUNT>300.00</AMOUNT>
                    <LOCATIONID>100</LOCATIONID>
                    <DEPARTMENTID>SALES</DEPARTMENTID>
                </SPLIT>
            </GLENTRY>
        </ENTRIES>
    </GLBATCH>
</create>

Parameters

Name Required Type Description
GLBATCH Optional object Object to create

GLBATCH

Name Required Type Description
JOURNAL Required string GL journal symbol
BATCH_DATE Required string Posting date in format mm/dd/yyyy.
REVERSEDATE Optional string Reverse date in format mm/dd/yyyy. Must be greater than BATCH_DATE.
BATCH_TITLE Required string Description of entry
HISTORY_COMMENT Optional string Comment added to history for this transaction
REFERENCENO Optional string Reference number of transaction
BASELOCATION_NO Optional string Source entity ID. Required if multi-entity enabled and entries do not balance by entity.
SUPDOCID Optional string Attachments ID
STATE Optional string State to create the entry in. Posted to post to the GL, otherwise Draft. (Default: Posted)
ENTRIES Required array[GLENTRY] Must have at least two lines (one debit, one credit).
Custom fields Optional varies This object supports custom fields.

GLENTRY

Name Required Type Description
DOCUMENT Optional string Document number of entry
ACCOUNTNO Required string Account number
CURRENCY Optional string Transaction currency code. Required if multi-currency enabled.
TRX_AMOUNT Required currency Transaction amount. Absolute value, relates to TR_TYPE.
TR_TYPE Required string Transaction type. 1 for Debit, otherwise -1 for Credit.
EXCH_RATE_DATE Optional string Exchange rate date in format mm/dd/yyyy. If null, defaults to BATCH_DATE.
EXCH_RATE_TYPE_ID Optional string Exchange rate type. Required if multi-currency enabled and EXCHANGE_RATE left blank. (Default Intacct Daily Rate)
EXCHANGE_RATE Optional currency Exchange rate. Required if multi currency enabled and EXCH_RATE_TYPE_ID left blank. Exchange rate amount to 4 decimals.
DESCRIPTION Optional string Memo. If left blank, set this value to match BATCH_TITLE.
ALLOCATION Optional string Allocation ID. All other dimension elements are ignored if allocation is set. Use Custom for custom splits and see SPLIT element below.
DEPARTMENT Optional string Department ID
LOCATION Optional string Location ID. Required if multi-entity enabled.
PROJECTID Optional string Project ID
CUSTOMERID Optional string Customer ID
VENDORID Optional string Vendor ID
EMPLOYEEID Optional string Employee ID
ITEMID Optional string Item ID
CLASSID Optional string Class ID
CONTRACTID Optional string Contract ID
WAREHOUSEID Optional string Warehouse ID
SPLIT Optional SPLIT[] Custom allocation split. Required if ALLOCATION equals Custom. Multiple SPLIT elements may then be passed.
Custom fields Optional varies This object supports custom fields.

SPLIT

Name Required Type Description
AMOUNT Required currency Split transaction amount. Absolute value. All SPLIT element’s AMOUNT values must sum up to equal GLENTRY element’s TRX_AMOUNT
DEPARTMENTID Optional string Department ID
LOCATIONID Optional string Location ID. Required if multi-entity enabled.
PROJECTID Optional string Project ID
CUSTOMERID Optional string Customer ID
VENDORID Optional string Vendor ID
EMPLOYEEID Optional string Employee ID
ITEMID Optional string Item ID
CLASSID Optional string Class ID
CONTRACTID Optional string Contract ID
WAREHOUSEID Optional string Warehouse ID

Create Journal Entry (Legacy)

create_gltransaction

<create_gltransaction>
    <journalid>PYRJ</journalid>
    <datecreated>
        <year>2017</year>
        <month>03</month>
        <day>31</day>
    </datecreated>
    <reversedate>
        <year>2017</year>
        <month>04</month>
        <day>01</day>
    </reversedate>
    <description>Payroll accrual 03/31/2016</description>
    <gltransactionentries>
        <glentry>
            <trtype>-1</trtype>
            <amount>1450.80</amount>
            <glaccountno>2080</glaccountno>
            <memo>Accrued salaries</memo>
            <locationid>100</locationid>
            <departmentid>ADMIN</departmentid>
            <currency>USD</currency>
            <exchratetype>Intacct Daily Rate</exchratetype>
        </glentry>
        <glentry>
            <trtype>1</trtype>
            <amount>1450.80</amount>
            <glaccountno>6500</glaccountno>
            <memo>Salary expense</memo>
            <locationid>100</locationid>
            <departmentid>ADMIN</departmentid>
            <currency>USD</currency>
            <exchratetype>Intacct Daily Rate</exchratetype>
        </glentry>
    </gltransactionentries>
</create_gltransaction>

Parameters

Name Required Type Description
journalid Required string GL journal symbol
datecreated Required object Posting date
reversedate Optional object Reverse date. Must be greater than posting date.
description Required string Description of entry
referenceno Optional string Reference number of transaction
sourceentity Optional string Source entity ID. Required if multi-entity enabled and entries do not balance by entity.
customfields Optional customfield[] Custom fields
gltransactionentries Required array[glentry] Must have at least two lines (one debit, one credit).

datecreated

Name Required Type Description
year Required string Year yyyy
month Required string Month mm
day Required string Day dd

reversedate

Name Required Type Description
year Required string Year yyyy
month Required string Month mm
day Required string Day dd

glentry

Name Required Type Description
trtype Required string Transaction type. 1 for Debit, otherwise -1 for Credit.
amount Required currency Transaction amount. Absolute value, relates to trtype.
glaccountno Required string Account number
document Optional string Document number of entry
memo Optional string Memo. If left blank, set this value to match journal entry description.
locationid Optional string Location ID. Required if multi-entity enabled.
departmentid Optional string Department ID
customerid Optional string Customer ID
vendorid Optional string Vendor ID
employeeid Optional string Employee ID
projectid Optional string Project ID
itemid Optional string Item ID
classid Optional string Class ID
contractid Optional string Contract ID
warehouseid Optional string Warehouse ID
customfields Optional customfield[] Custom fields
currency Optional string Transaction currency code. Required if multi-currency enabled.
exchratedate Optional string Exchange rate date in format mm/dd/yyyy. If null, defaults to journal entry posting date.
exchratetype Optional string Exchange rate type. Required if multi-currency enabled and exchrate left blank. (Default Intacct Daily Rate)
exchrate Optional currency Exchange rate. Required if multi currency enabled and exchratetype left blank. Exchange rate amount to 4 decimals.

Update Journal Entry

update

<update>
    <GLBATCH>
        <RECORDNO>1</RECORDNO>
        <JOURNAL>PYRJ</JOURNAL>
        <BATCH_DATE>03/31/2016</BATCH_DATE>
        <REVERSEDATE>04/01/2016</REVERSEDATE>
        <BATCH_TITLE>Payroll accrual 03/31/2016</BATCH_TITLE>
        <ENTRIES>
            <GLENTRY>
                <ACCOUNTNO>2080</ACCOUNTNO>
                <DEPARTMENT>ADMIN</DEPARTMENT>
                <LOCATION>100</LOCATION>
                <CURRENCY>USD</CURRENCY>
                <TR_TYPE>-1</TR_TYPE>
                <AMOUNT>1450.80</AMOUNT>
                <EXCH_RATE_TYPE_ID>Intacct Daily Rate</EXCH_RATE_TYPE_ID>
                <DESCRIPTION>Accrued salaries</DESCRIPTION>
            </GLENTRY>
            <GLENTRY>
                <ACCOUNTNO>6500</ACCOUNTNO>
                <DEPARTMENT>ADMIN</DEPARTMENT>
                <LOCATION>100</LOCATION>
                <CURRENCY>USD</CURRENCY>
                <TR_TYPE>1</TR_TYPE>
                <AMOUNT>1450.80</AMOUNT>
                <EXCH_RATE_TYPE_ID>Intacct Daily Rate</EXCH_RATE_TYPE_ID>
                <DESCRIPTION>Salary expense</DESCRIPTION>
            </GLENTRY>
        </ENTRIES>
    </GLBATCH>
</update>

Parameters

Name Required Type Description
GLBATCH Optional object Object to update

GLBATCH

Name Required Type Description
RECORDNO Required integer Journal entry RECORDNO to update
BATCH_DATE Required string Posting date in format mm/dd/yyyy
BATCH_TITLE Required string Description of entry
HISTORY_COMMENT Optional string Comment added to history for this transaction.
REFERENCENO Optional string Reference number of transaction
BASELOCATION_NO Optional string Source entity ID. Required if multi-entity enabled and entries do not balance by entity.
SUPDOCID Optional string Attachments ID
STATE Optional string State to update the entry to. Posted to post to the GL, otherwise Draft.
ENTRIES Required array[GLENTRY] Must have at least two lines (one debit, one credit).
Custom fields Optional varies This object supports custom fields.

GLENTRY

Name Required Type Description
DOCUMENT Optional string Document number of entry
ACCOUNTNO Required string Account number
CURRENCY Optional string Transaction currency code. Required if multi-currency enabled.
TRX_AMOUNT Required currency Transaction amount. Absolute value, relates to TR_TYPE.
TR_TYPE Required string Transaction type. 1 for Debit, otherwise -1 for Credit.
EXCH_RATE_DATE Optional string Exchange rate date in format mm/dd/yyyy. If null, defaults to BATCH_DATE.
EXCH_RATE_TYPE_ID Optional string Exchange rate type. Required if multi-currency enabled and EXCHANGE_RATE left blank. (Default Intacct Daily Rate)
EXCHANGE_RATE Optional currency Exchange rate. Required if multi currency enabled and EXCH_RATE_TYPE_ID left blank. Exchange rate amount to 4 decimals.
DESCRIPTION Optional string Memo. If left blank, set this value to match BATCH_TITLE.
ALLOCATION Optional string Allocation ID. All other dimension elements are ignored if allocation is set. Use Custom for custom splits and see SPLIT element below.
DEPARTMENT Optional string Department ID
LOCATION Optional string Location ID. Required if multi-entity enabled.
PROJECTID Optional string Project ID
CUSTOMERID Optional string Customer ID
VENDORID Optional string Vendor ID
EMPLOYEEID Optional string Employee ID
ITEMID Optional string Item ID
CLASSID Optional string Class ID
CONTRACTID Optional string Contract ID
WAREHOUSEID Optional string Warehouse ID
SPLIT Optional SPLIT[] Custom allocation split. Required if ALLOCATION equals Custom. Multiple SPLIT elements may then be passed.
Custom fields Optional varies This object supports custom fields.

SPLIT

Name Required Type Description
AMOUNT Required currency Split transaction amount. Absolute value. All SPLIT element’s AMOUNT values must sum up to equal GLENTRY element’s TRX_AMOUNT.
DEPARTMENTID Optional string Department ID
LOCATIONID Optional string Location ID. Required if multi-entity enabled.
PROJECTID Optional string Project ID
CUSTOMERID Optional string Customer ID
VENDORID Optional string Vendor ID
EMPLOYEEID Optional string Employee ID
ITEMID Optional string Item ID
CLASSID Optional string Class ID
CONTRACTID Optional string Contract ID
WAREHOUSEID Optional string Warehouse ID

Delete Journal Entry

delete

<delete>
    <object>GLBATCH</object>
    <keys>1</keys>
</delete>

Parameters

Name Required Type Description
object Required string Use GLBATCH
keys Required string Journal entry RECORDNO to delete

Delete Journal Entry (Legacy)

delete_gltransaction

<delete_gltransaction key="1234"></delete_gltransaction>

Parameters

Name Required Type Description
key Required string Journal entry record number to delete

List Journal Entry Lines

readByQuery

<readByQuery>
    <object>GLENTRY</object>
    <fields>*</fields>
    <query></query>
    <pagesize>100</pagesize>
</readByQuery>

Parameters

Name Required Type Description
object Required string Use GLENTRY
fields Optional string Comma-separated list of fields on the object to list. For best performance and predictability, limit the number of fields. To return all fields, omit the element or provide * for the value.
query Required string SQL-like query based on fields on the object. Illegal XML characters must be properly encoded. The following SQL operators are supported: <, >, >=, <=, =, like, not like, in, not in. When doing NULL comparisons: IS NOT NULL, IS NULL. Multiple fields may be matched using the AND and OR operators. Joins are not supported. Single quotes in any operands must be escaped with a backslash - For example, the value Erik's Deli would become 'Erik\'s Deli'.
pagesize Optional integer Custom page size between 1 and 1000 items (Default: 100)

Get Journal Entry Line

read

<read>
    <object>GLENTRY</object>
    <keys>1</keys>
    <fields>*</fields>
</read>

Parameters

Name Required Type Description
object Required string Use GLENTRY
keys Required string Journal entry line RECORDNO to get
fields Optional string Comma-separated list of fields on the object to get. For best performance and predictability, limit the number of fields. To return all fields, omit the element or provide * for the value.

Provide feedback