Expense transactions

Create expense-transaction datasets to represent your customers spend

An expense transaction represents the context behind the purchase.

It can include details about the purchase from the mapping options, for example:

• The type of transaction, e.g. a payment or refund

• Which account in the general ledger the transaction should be reconciled to accountRef

• The associated tax rates taxRateRef

• Any applicable tracking categories trackingRefs

When pushing expenses, use your transaction id so that it can serve as an idempotency key. Codat validates id's to ensure that every id is unique to a company. This approach prevents duplicate transactions being created in your SMBs' accounting software.

Expense transaction

{
  "items": [
    {
      "id": "08ca1f02-0374-11ed-b939-0242ac120002",
      "type": "payment",
      "issueDate": "2021-05-21T00:00:00+00:00",
      "currency": "GBP",
      "currencyRate": 1.18,
      "merchantName": "Amazon UK",
      "lines": [
        {
          "netAmount": 110.42,
          "taxAmount": 14.43,
          "taxRateRef": {
            "id": "08ca1c6e-0374-11ed-b939-0242ac120002"
          },
          "accountRef": {
            "id": "08ca1c6e-0374-11ed-b939-0242ac120002"
          },
          "trackingRefs": [
            {
              "id": "08ca1c6e-0374-11ed-b939-0242ac120002"
            }
          ]
        }
      ],
      "notes": "Amazon UK | Online Purchase | Order 123XX45"
    }
  ]
}

Transaction types

The way Codat handles, maps and processes a transaction is based on the specified type of the transaction.

• payment

  Is used to represent any spend that takes place on the account and interest on credit purchases.

• refund

  Can be used to represent any refunds and returns on an original transaction.

• reward

  Can be used to represent reward redemptions such as cashback.

• chargeback

  Is similar to a refund in behavior and represents a return of transaction or payment sum which may have been disputed.

• transferIn

  A transfer that decreases the balance of the credit card account or increases the balance of a bank account.

  Can be used to represent a top up of debit card account, a pay down of a credit card account or a balance transfer to another credit card.

• transferOut

  A transfer that increases the balance of the credit account or decreases the balance of a bank account.

  Can be used to represent cash withdrawals or balance transfer to another credit card.

• adjustmentIn

  An adjustment that decreases the balance of the credit account or increases the balance of a bank account.

  Can be used to represent write-offs & transaction adjustments such as foreign exchange adjustments.

• adjustmentOut

  An adjustment that increases the balance of the credit account or decreases the balance of a bank account.

  Can be used to represent write-offs & transaction adjustments such as foreign exchange adjustments.