latestOpenAPI 3.0.02026-08-10233809957.8 KB

5cdfae3fa1fa

Journal Entries

Gets the latest journal entries for a business.

get/journalEntries

Query parameters

businessNamestring required
serviceName'freshbooks' | 'quickbooks' | 'quickbooksDesktop' | 'xero' | 'oracleNetsuite' | 'sageBusinessCloud' | 'sageIntacct' | 'dynamicsBusinessCentral' | 'dynamics365Finance' | 'myob' | 'zohoBooks' required
startDatestring

Transaction date greater than or equal to parameter in the format: YYYY-MM-DD.

endDatestring

Transaction date less than or equal to parameter in the format: YYYY-MM-DD.

offsetnumber

The offset is the position in the dataset of a particular record.

limitnumber

This is the size of the results set you would like (default: 100).

orderBystring
totalCreditnumber float

Total amount of an journal entry credit line item.

totalDebitnumber float

Total amount of an journal entry debit line item.

Response

countnumber required

Example response

{
  "count": 1,
  "meta": {
    "reportId": [
      "5fad8a342a88364234392fb5"
    ],
    "serviceName": "xero",
    "businessName": "Railz",
    "createdAt": "2020-11-25T01:02:03Z",
    "updatedAt": "2020-11-30T01:02:03Z",
    "startDate": "2020-11-25T01:02:03Z",
    "endDate": "2020-11-30T01:02:03Z"
  },
  "data": [
    {
      "id": "1",
      "postedDate": "2021-03-09T10:18:29.985Z",
      "createdDate": "2021-03-09T10:18:29.985Z",
      "currencyRate": 1.13,
      "subsidiaryRefs": [
        {
          "id": "1",
          "name": "Railz Financial"
        }
      ],
      "memo": "Example bill memo.",
      "sourceModifiedDate": "2021-03-09T10:18:29.985Z",
      "totalCredit": 129.99,
      "totalDebit": 129.99,
      "currencyRef": {
        "id": "CAD",
        "name": "Canadian Dollar",
        "symbol": "USD,CAD"
      },
      "lines": [
        {
          "description": "Services rendered.",
          "credit": 100.5,
          "debit": 3,
          "taxAmount": 20.5,
          "accountRef": {
            "id": "145",
            "name": "Example account"
          },
          "entityRef": {
            "id": "1",
            "name": "ABC Inc.",
            "type": "vendor"
          },
          "taxRateRef": {
            "id": "1",
            "name": "HST",
            "effectiveTaxRate": 13
          },
          "id": "1",
          "trackingCategoryRef": {
            "id": "4040",
            "name": "Region",
            "option": "East",
            "optionId": "40401"
          }
        }
      ],
      "bankAccountNumber": "11200"
    }
  ]
}