Statement

Returns a list of bank statement transactions for Bankfeeds

Date Released: May 2014 Date Updated: Mar 2021
URLSupports
/{cf_uri}/Banking/Statement GET |  PUT |  POST |  DELETE
Please note: While accessibility via the API is available to both AccountRight and new Essentials files. Not all features will be displayed in Product for new Essentials

The elements list below details information for Statement. To view the descriptions for the elements you can either hover any attribute to reveal details or click here to show all details inline.

Items shown with are required when posting or puting data
Items shown with are read-only elements

Attribute Details

  • UIDGuid (36)
  • Unique guid identifier for the bank statement.
  • StatementDateDateTime
  • Date when the BankStatement was pulled into AccountRight, format YYYY-MM-DD HH:MM:SS { 'StatementDate': '2014-09-10 13:33:02' }
  • DateDateTime
  • Transaction date, format YYYY-MM-DD HH:MM:SS { 'Date': '2014-09-10 13:33:02' }
  • DescriptionString
  • Description text for the transaction.
  • Account
  • The following set of information pulls through details for an Account
    • UIDGuid (36)
    • Foreign Key: Unique identifier for the account in the form of a guid.
    • NameString (30)
    • Account name belonging to the account record.
    • DisplayIDString (6)
    • Account code format includes separator ie 1-1100{ 'DisplayID': '1-1100' }
    • URIString
    • Uniform resource identifier associated with the account object.
  • AmountDecimal (13.2)
  • Dollar amount of the withdrawal or deposit.
  • IsCreditBoolean
  • True indicates a credit into account.
    False indicates a withdrawal from account.
  • SourceTransactionsString
  • Source transaction.
    • UIDGuid (36)
    • Foreign Key: Unique identifier for the source transaction in the form of a guid.
    • TransactionTypeString (30)
    • Transaction types consist of the following:
      Bill
      Invoice
      SupplierPayment
      CustomerPayment
      SpendMoneyTxn
      ReceiveMoneyTxn
      TransferMoneyTxn
      GeneralJournal
      InventoryAdjustment
      CreditRefund
      CreditSettlement
      DebitRefund
      DebitSettlement
    • URIString
    • Uniform resource identifier associated with the transaction object.
  • Status String
  • Status can consist of the following:
    Uncoded
    Coded
    Hidden
  • ReferenceString
  • Additionl reference field for the transaction
  • URIString
  • Uniform resource identifier encompasses all types of names and addresses that refer to objects on the web.
  • RowVersionString
  • Incrementing number that can be used for change control but does does not preserve a date or a time.


Paging: default page size is set to 400 with a maximum of 1000 results.

Example json GET response

  • {
  • "UID" : "d6c733d5-fcff-40d9-a1a4-b5536f571d9a",
  • "StatementDate" : "2013-08-30T00:00:00",
  • "Date" : "2013-09-07T00:00:00",
  • "Description" : "BANK FEE",
  • "Account" : {
    • "UID" : "7772dc25-5ee6-4a61-994e-28c04b8a35fc",
    • "Name" : "General Cheque Account 1",
    • "DisplayID" : "1-1110",
    • "URI" : "{cf_uri}/GeneralLedger/Account/7772dc25-5ee6-4a61-994e-28c04b8a35fc"
    • },
  • "Amount" : 0.29,
  • "IsCredit" : false,
  • "SourceTransactions" : null,
  • "Status" : "Uncoded",
  • "Reference" : "1932266",
  • "URI" : "{cf_uri}/Banking/Statement/d6c733d5-fcff-40d9-a1a4-b5536f571d9a",
  • "RowVersion" : "-2694559952051109888"
  • }
Hypermedia in the MYOB Business API

The {cf_uri} is provided by the Company File endpoint.

Read more about Hypermedia in the MYOB Business API in our best practice guide.