Journal Entries
The JournalEntry Object
A Rutter Journal Entry represents the atomic transaction used in any accounting system. It must contain at least one credit and debit, and the sum of credit and debit amounts must equal 0.
Files can be attached to Rutter Journal Entries in the form of Rutter Attachments.
Properties
id
stringThe Rutter generated unique ID of the journal entry.
platform_id
stringThe platform specific ID of the journal entry.
subsidiary_id
stringnullableThe Rutter ID of the Subsidiary linked to the journal entry. Supported for NetSuite.
issue_date
stringThe ISO 8601 timestamp for the issue date of the journal entry.
currency
enumnullablecurrency_rate
stringnullableThe exchange rate between the business default currency and the currency of the journal entry.
deposited
booleannullableIf the journal entry debits the 'Undeposited Funds' account, this field will show whether the journal entry has been deposited (usually in another Bank Deposit transaction). Null if the journal entry doesn't debit the 'Undeposited Funds' account or if the platform does not support this field.
memo
stringnullableThe memo of the journal entry.
line_items
arrayline_items
attributescreated_at
stringfilterablenullableThe ISO 8601 timestamp that the journal entry was created.
updated_at
stringfilterablenullableThe ISO 8601 timestamp that the journal entry was last updated.
last_synced_at
stringfilterableThe ISO 8601 timestamp when the journal entry was last synced by Rutter.
platform_url
stringnullableA URL pointing to the object in the underlying platform. When no URL exists for the specific object, the value may be a larger URL containing the object.
platform_data
objectOptionalThe raw platform data corresponding to the Rutter object.
List Journal Entries
Request Parameters
access_token
stringqueryRequiredThe access token of the connection.
cursor
stringqueryOptionalUsed to paginate to the next batch of objects. Should be a copy of the next_cursor
value from the previous response.
limit
integerqueryOptionalUsed to limit the number of returned objects. Defaults to 50.
filter
stringqueryOptionalNot currently supported on Sage Intacct or Sage Business Cloud. Used to specify a filtering criteria for response objects. Refer to Filtering Objects to understand the syntax for the filtering criteria. The filtering syntax only supports fields decorated with a filterable
tag in the response object.
Filterable fields: created_at
, updated_at
, last_synced_at
.
sort
stringqueryOptionalUsed to sort the response objects, e.g. last_synced_at ASC
. If a value is provided but ASC
or DESC
is not, defaults to ASC
. If omitted, defaults to updated_at DESC
. Supports only fields decorated with a filterable
tag in the response object except on Sage Intacct and Dynamics 365 Business Central. For those platforms, only updated_at_min
, updated_at_max
and last_synced_at_min
fields are supported and not deprecated.
Sortable fields: created_at
, updated_at
, last_synced_at
.
expand
enumqueryOptionalInclude platform specific data (includes additional fields not provided by the Rutter object).
last_synced_at_min
integerqueryOptionalDeprecated - use filter
instead. Used to filter objects with a last_synced_at
value greater than or equal to the supplied value. Should be a Unix time in milliseconds.
updated_at_max
integerqueryOptionalDeprecated - use filter
instead. Used to filter objects with a updated_at
value less than or equal to the supplied value. Should be a Unix time in milliseconds.
updated_at_min
integerqueryOptionalDeprecated - use filter
instead. Used to filter objects with a updated_at
value greater than or equal to the supplied value. Should be a Unix time in milliseconds.
force_fetch
enumqueryOptionalUsed to force a response even if the underlying connection has not finished its initial sync.
Response Body
- QuickBooks
- Xero
- QuickBooks Desktop
- NetSuite
1{
2 "journal_entries": [
3 {
4 "id": "00000000-0000-0000-0000-000000000000",
5 "platform_id": "12345678",
6 "subsidiary_id": "00000000-0000-0000-0000-000000000000",
7 "issue_date": "2023-01-02T02:34:56.000Z",
8 "currency": "USD",
9 "currency_rate": "1",
10 "deposited": true,
11 "memo": "For goods sold.",
12 "line_items": [
13 {
14 "platform_id": "12345678",
15 "tax_rate_id": "123",
16 "amount": 12.34,
17 "description": "Debit amount for goods sold",
18 "tax_amount": 1.23,
19 "account_ref": {
20 "id": "00000000-0000-0000-0000-000000000000",
21 "name": "Expenses"
22 }
23 },
24 {
25 "platform_id": "12345678",
26 "tax_rate_id": "123",
27 "amount": -12.34,
28 "description": "Credit amount for goods sold",
29 "tax_amount": 0,
30 "account_ref": {
31 "id": "00000000-0000-0000-0000-000000000000",
32 "name": "Cash"
33 }
34 }
35 ],
36 "created_at": "2023-01-02T02:34:56.000Z",
37 "updated_at": "2023-01-02T02:34:56.000Z",
38 "last_synced_at": "2023-01-02T02:34:56.000Z",
39 "platform_url": "https://platform.com/resource?id=123",
40 "platform_data": {
41 "id": 123,
42 "data": "Varies by platform"
43 }
44 }
45 ],
46 "next_cursor": "MTY3NDgzMTk0Ml82MDY4ZDI0ZC02NGRmLTRmN2EtYTM0Ny0zN2ZmNjY5MGVmMjU=",
47 "connection": {
48 "id": "00000000-0000-0000-0000-000000000000",
49 "orgId": "00000000-0000-0000-0000-000000000000",
50 "platform": "NETSUITE"
51 }
52}
Fetch a Journal Entry
Request Parameters
id
stringpathRequiredThe unique ID of the object.
access_token
stringqueryRequiredThe access token of the connection.
id_type
enumqueryOptionalUsed to indicate the type of id
that is supplied. Defaults to rutter
. Not currently supported on Sage Intacct or Sage Business Cloud.
force_fetch
enumqueryOptionalUsed to force a response even if the underlying connection has not finished its initial sync.
Response Body
- QuickBooks
- Xero
- QuickBooks Desktop
- NetSuite
1{
2 "journal_entry": {
3 "id": "00000000-0000-0000-0000-000000000000",
4 "platform_id": "12345678",
5 "subsidiary_id": "00000000-0000-0000-0000-000000000000",
6 "issue_date": "2023-01-02T02:34:56.000Z",
7 "currency": "USD",
8 "currency_rate": "1",
9 "deposited": true,
10 "memo": "For goods sold.",
11 "line_items": [
12 {
13 "platform_id": "12345678",
14 "tax_rate_id": "123",
15 "amount": 12.34,
16 "description": "Debit amount for goods sold",
17 "tax_amount": 1.23,
18 "account_ref": {
19 "id": "00000000-0000-0000-0000-000000000000",
20 "name": "Expenses"
21 }
22 },
23 {
24 "platform_id": "12345678",
25 "tax_rate_id": "123",
26 "amount": -12.34,
27 "description": "Credit amount for goods sold",
28 "tax_amount": 0,
29 "account_ref": {
30 "id": "00000000-0000-0000-0000-000000000000",
31 "name": "Cash"
32 }
33 }
34 ],
35 "created_at": "2023-01-02T02:34:56.000Z",
36 "updated_at": "2023-01-02T02:34:56.000Z",
37 "last_synced_at": "2023-01-02T02:34:56.000Z",
38 "platform_url": "https://platform.com/resource?id=123",
39 "platform_data": {
40 "id": 123,
41 "data": "Varies by platform"
42 }
43 },
44 "connection": {
45 "id": "00000000-0000-0000-0000-000000000000",
46 "orgId": "00000000-0000-0000-0000-000000000000",
47 "platform": "NETSUITE"
48 }
49}
Create a Journal Entry
Request Parameters
access_token
stringqueryRequiredThe access token of the connection.
Request Body
response_mode
enumOptionalThe response mode for our async endpoints. prefer_sync
allows calling the API in a best-effort, synchronous fashion and wait for the response. If this takes too long we will instead return the asynchronous response. This is the default behavior. async
makes the API respond with the asynchronous response. See Asynchronous Operations.
journal_entry
objectjournal_entry
attributesResponse Body
- Xero
- QuickBooks Desktop
- NetSuite
1{
2 "journal_entry": {
3 "currency_code": "USD",
4 "memo": "For goods sold.",
5 "line_items": [
6 {
7 "account_id": "00000000-0000-0000-0000-000000000000",
8 "amount": 12.34,
9 "description": "Debit amount for goods sold."
10 },
11 {
12 "account_id": "00000000-0000-0000-0000-000000000000",
13 "amount": 12.34,
14 "description": "Credit amount for goods sold."
15 }
16 ],
17 "created_at": "2023-01-02T02:34:56.000Z"
18 }
19}
1{
2 "journal_entry": {
3 "id": "00000000-0000-0000-0000-000000000000",
4 "platform_id": "12345678",
5 "subsidiary_id": "00000000-0000-0000-0000-000000000000",
6 "issue_date": "2023-01-02T02:34:56.000Z",
7 "currency": "USD",
8 "currency_rate": "1",
9 "deposited": true,
10 "memo": "For goods sold.",
11 "line_items": [
12 {
13 "platform_id": "12345678",
14 "tax_rate_id": "123",
15 "amount": 12.34,
16 "description": "Debit amount for goods sold",
17 "tax_amount": 1.23,
18 "account_ref": {
19 "id": "00000000-0000-0000-0000-000000000000",
20 "name": "Expenses"
21 }
22 },
23 {
24 "platform_id": "12345678",
25 "tax_rate_id": "123",
26 "amount": -12.34,
27 "description": "Credit amount for goods sold",
28 "tax_amount": 0,
29 "account_ref": {
30 "id": "00000000-0000-0000-0000-000000000000",
31 "name": "Cash"
32 }
33 }
34 ],
35 "created_at": "2023-01-02T02:34:56.000Z",
36 "updated_at": "2023-01-02T02:34:56.000Z",
37 "last_synced_at": "2023-01-02T02:34:56.000Z",
38 "platform_url": "https://platform.com/resource?id=123",
39 "platform_data": {
40 "id": 123,
41 "data": "Varies by platform"
42 }
43 }
44}
Update a Journal Entry
If a field value is provided, that field will take the updated value. If the field is not provided, the existing value will persist. Note: PATCH /journal_entries
not yet supported for Netsuite Advanced Intercompany Journal Entries.
Request Parameters
id
stringpathRequiredThe Rutter generated unique ID of the object.
access_token
stringqueryRequiredThe access token of the connection.
Request Body
response_mode
enumOptionalThe response mode for our async endpoints. prefer_sync
allows calling the API in a best-effort, synchronous fashion and wait for the response. If this takes too long we will instead return the asynchronous response. This is the default behavior. async
makes the API respond with the asynchronous response. See Asynchronous Operations.
journal_entry
objectjournal_entry
attributesResponse Body
- NetSuite
1{
2 "journal_entry": {
3 "transaction_date": "2023-01-02T02:34:56.000Z",
4 "currency_code": "USD",
5 "currency_rate": 1,
6 "memo": "For goods sold.",
7 "line_items": [
8 {
9 "account_id": "00000000-0000-0000-0000-000000000000",
10 "total_amount": 12.34,
11 "description": "Debit amount for goods sold."
12 },
13 {
14 "account_id": "00000000-0000-0000-0000-000000000000",
15 "total_amount": -12.34,
16 "description": "Credit amount for goods sold."
17 }
18 ]
19 }
20}
1{
2 "journal_entry": {
3 "id": "00000000-0000-0000-0000-000000000000",
4 "platform_id": "12345678",
5 "subsidiary_id": "00000000-0000-0000-0000-000000000000",
6 "issue_date": "2023-01-02T02:34:56.000Z",
7 "currency": "USD",
8 "currency_rate": "1",
9 "deposited": true,
10 "memo": "For goods sold.",
11 "line_items": [
12 {
13 "platform_id": "12345678",
14 "tax_rate_id": "123",
15 "amount": 12.34,
16 "description": "Debit amount for goods sold",
17 "tax_amount": 1.23,
18 "account_ref": {
19 "id": "00000000-0000-0000-0000-000000000000",
20 "name": "Expenses"
21 }
22 },
23 {
24 "platform_id": "12345678",
25 "tax_rate_id": "123",
26 "amount": -12.34,
27 "description": "Credit amount for goods sold",
28 "tax_amount": 0,
29 "account_ref": {
30 "id": "00000000-0000-0000-0000-000000000000",
31 "name": "Cash"
32 }
33 }
34 ],
35 "created_at": "2023-01-02T02:34:56.000Z",
36 "updated_at": "2023-01-02T02:34:56.000Z",
37 "last_synced_at": "2023-01-02T02:34:56.000Z",
38 "platform_url": "https://platform.com/resource?id=123",
39 "platform_data": {
40 "id": 123,
41 "data": "Varies by platform"
42 }
43 }
44}
Delete a Journal Entry
Request Parameters
id
stringpathRequiredThe Rutter generated unique ID of the object.
access_token
stringqueryRequiredThe access token of the connection.
Request Body
response_mode
enumOptionalThe response mode for our async endpoints. prefer_sync
allows calling the API in a best-effort, synchronous fashion and wait for the response. If this takes too long we will instead return the asynchronous response. This is the default behavior. async
makes the API respond with the asynchronous response. See Asynchronous Operations.
Response Body
- QuickBooks
1{
2 "code": "deleted",
3 "success": true
4}
Have questions?
Contact support for personalized guidance.