Depending on applicable regulations or business limitations, specific API requests may not be available for your use.

Get Account Transactions

This request returns a summary of transactions in a brokerage account.

Request URL

Syntax GET /restapi/accounts/{accountnumber}/transactions?daterange=6m
Example URL https://api.uat.foliofn.com/restapi/RA1234ABCD/transactions?dateRange=1m&ticker=AMZN,APPL&category=Deposits&subcategory=Cash&cashsweep=N

Request Query Parameters

Parameter Required? Description
daterange N Default to 3 days. It can be a date range. The format of a date should be “MM-dd-yyyy”. The start date and the end date should be separated by a comma, (“,”). For example, “daterange=11-01-2013,09-01-2014”. In additional to a customdate range, the value of daterange parameter could also be a code. See the other valid codes in Date Range Codes table below.
category N Transaction category name. See Transaction Codes
subCategoryName N Transaction sub category name. See Transaction Codes
ticker N Ticker symbol. You can pass mutiple tickers as comma delimited string, for example ticker="AMZN,AAPL,FB"
cashsweep N Default to 'Y'. Indicator for showing cash sweep transactions or not. 'Y' means show. 'N' means not show.

Date Range Codes

Code Description
3d Three days
5d Five days
10d Ten days
30d Thirty days
1m One month
3m Three months
6m Six months
12m Twelve months
1y One year
3y Three years
5y Five years
Mtd Month to date
Ytd Year to date

Transaction Category Codes

Code Description
Deposits Includes checks, transfers, and other deposits
Withdrawals Includes checks, transfers, and other withdrawals
Internal Transfers Displays internal account transfers
Trades Displays buys and sells, including reinvestments
Distributions Includes dividends, interest, and other security distributions
Fees Includes fee transactions and commissions
Corporate Actions Includes splits, mergers, and other corporate actions
Sweep Includes sweep buys and sells

Transaction Sub Category Codes

Code Description
Cash Deposit List cash deposits
Securities (Transfer) Deposit List security transfers (external to account)
Cash Withdrawal List cash withdrawals
Securities (Transfer) Withdrawal List security transfers (external to account)
Miscellaneous Deposits List all miscellaneous deposits
Miscellaneous Withdrawals List tax withholding and miscellaneous withdrawals
Transfers In List internal account transfers in
Transfers Out List internal account transfer out
Buys Lists all buys except reinvestments
Sells List all sells
Reinvestments List all reinvestments
Dividends List cash dividends and dividend adjustments
Interest List interest payments and interest adjustments
Capital Gain Distribution List long-term and short-term capital gain distributions
Stock Dividends List stock dividends received
Return of Capital List return of capital distributions
Cash Liquidations List cash distributions resulting from a merger or final security distribution
Administrative List all fees not considered Investment Management or Trading Expenses
Investment Management List fees for Investment Management services
Trading Expenses List fees directly or indirectly associated with the purchase or sale of securities
Fee Credit List fee credits
Exchanges List exchanges into or out of the folio or account
Mergers List merger transactions
Name Changes List ticker, CUSIP, and description changes
Stock Splits List forward and reverse stock splits
Spin-offs List spin-offs and spin-off adjustments
Others List all other corporate actions
Sweep Buys List sweep buys
Sweep Sells List sweep sells

Response Data Fields

Field Values Description
accountId Account identifier for Folio transaction occurred in
categoryName see Transaction Codes Transaction category name
commission Trade commission
date Date in ISO-8601 format
folioName Name of folio
marketNet Used for internal transfers, same value as 'net'
marketPrice Used for internal transfers, same value as 'price'
net Net dollar value
Notes Additional notes on transactions (If applicable)
price Price per share
quantity Quantity of shares
subCategoryName see Transaction Codes Sub category of the transaction categoryName
symbolName Name of security
ticker Ticker
transactionCode see Transaction Codes Folio transaction code
transactionDesc see Transaction Codes Description of transaction
transactionId Transaction identifier
transactionType see Transaction Codes Additional information on type of transaction

Transaction Codes

Category Name Sub-category Names Transaction Code Transaction Description Transaction Type
Deposits Cash CDEP Client Deposits Check
Deposits Cash CDEP Client Deposits Bill Pay
Deposits Cash CDEP Client Deposits Check Returned
Deposits Cash CDEP Client Deposits Wire
Deposits Cash CDEP Client Deposits Electronic Funds Transfer
Deposits Cash CDEP Client Deposits Wire Returned
Deposits Cash CDEP Client Deposits Cash Transfer
Deposits Securities (Transfer) TSRI Transfer Security Receive In Securities (Transfer)
Deposits Securities (Transfer) XSRI Transfer Reg Security Receive In Securities (Transfer)
Deposits Securities (Transfer) SRI Security Receive In Securities (Transfer)
Deposits Miscellaneous Deposits UNRS Unrestrict Shares Misc. Deposit
Deposits Miscellaneous Deposits CDEP Client Deposits Misc. Deposit
Deposits Cash SRI Security Receive In Cash Transfer
Withdrawals Cash CLTW Client Withdrawals Check
Withdrawals Cash CLTW Client Withdrawals Wire
Withdrawals Cash CLTW Client Withdrawals Electronic Funds Transfer
Withdrawals Cash CLTW Client Withdrawals Cash Transfer
Withdrawals Securities (Transfer) TSDO Transfer Security Deliver Out Securities (Transfer)
Withdrawals Securities (Transfer) XSDO Transfer 144A Security Deliver Out Securities (Transfer)
Withdrawals Securities (Transfer) SDO Security Deliver Out Securities (Transfer)
Withdrawals Miscellaneous Withdrawals CLTW Client Withdrawals Misc. Withdrawal
Withdrawals Miscellaneous Withdrawals CLTW Client Withdrawals Withholding Tax
Withdrawals Miscellaneous Withdrawals IADJ Fund Dividend/Interest Withholding Tax
Withdrawals Miscellaneous Withdrawals RS Restrict Shares Misc. Withdrawal
Withdrawals Miscellaneous Withdrawals WOFF Writeoff Misc. Withdrawal
Withdrawals Cash SDO Security Deliver Out Cash Transfer
Withdrawals Cash CLTW Client Withdrawals Check Returned
Withdrawals Cash CLTW Client Withdrawals Wire Returned
Internal Transfers Transfers In SRI Security Receive In Transfers In
Internal Transfers Transfers Out SDO Security Deliver Out Transfers Out
Trades Buys B Buy Window Trade
Trades Buys B Buy Direct Trade
Trades Buys B Buy Trade
Trades Sells S Sell Window Trade
Trades Sells S Sell Direct Trade
Trades Sells S Sell Trade
Trades Reinvestments B Buy Reinvestments
Trades Buys B Buy Paper Trade
Trades Sells S Sell Paper Trade
Distributions Dividends CDIR Cash Dividend Receipt Dividend
Distributions Dividends IADJ Fund Dividend/Interest Dividend
Distributions Interest IADJ Fund Dividend/Interest Interest
Distributions Interest CDEP Client Deposits Interest
Distributions Capital Gain Distribution CGDLT Long Term Capital Gains Distribution Capital Gain Distribution
Distributions Capital Gain Distribution CGDST Short Term Capital Gains Distribution Capital Gain Distribution
Distributions Capital Gain Distribution CDEP Client Deposits Capital Gain Distribution
Distributions Capital Gain Distribution IADJ Fund Dividend/Interest Capital Gain Distribution
Distributions Stock Dividends SD Stock Dividend Stock Dividend
Distributions Stock Dividends SRI Security Receive In Stock Dividend
Distributions Stock Dividends SDO Security Deliver Out Stock Dividend
Distributions Return of Capital RCAPPRO Return of Capital Prorated Return of Capital
Distributions Return of Capital RCAP Return of Capital Return of Capital
Distributions Return of Capital IADJ Fund Dividend/Interest Return of Capital
Distributions Cash Liquidations CLQ Cash Liquidation Cash Distribution
Distributions Cash Liquidations CLQF Cash Liquidation Final Cash Distribution
Fees Administrative CLTW Client Withdrawals Express Mail
Fees Administrative CLTW Client Withdrawals Wire Transfer
Fees Administrative CLTW Client Withdrawals Certificate Delivery Same Regi
Fees Administrative CLTW Client Withdrawals Late Trade Settlement Fee
Fees Administrative CLTW Client Withdrawals Physical Corporate Action
Fees Administrative CLTW Client Withdrawals Returned Check/ACH Fee
Fees Administrative CLTW Client Withdrawals NSF Fee
Fees Administrative CLTW Client Withdrawals Stop Payment
Fees Administrative CLTW Client Withdrawals Check Copy
Fees Administrative CLTW Client Withdrawals Research Fee
Fees Administrative CLTW Client Withdrawals Restricted Securities (Rule 14)
Fees Administrative CLTW Client Withdrawals DTC Transfers
Fees Administrative CLTW Client Withdrawals Check Reorder
Fees Administrative CLTW Client Withdrawals Account Closing Fee
Fees Administrative CLTW Client Withdrawals Voluntary Corporate Action
Fees Administrative CLTW Client Withdrawals Misc. Fee
Fees Administrative CLTW Client Withdrawals Transfer of Secuities b/w acco
Fees Administrative CLTW Client Withdrawals Transfer of Securities & Tax L
Fees Administrative CLTW Client Withdrawals Transfer of cash
Fees Administrative CLTW Client Withdrawals Check Processing Fee
Fees Administrative CLTW Client Withdrawals Acat Transfer Fee
Fees Administrative CLTW Client Withdrawals Paper Statement Fee Advisor
Fees Administrative CLTW Client Withdrawals Charge off Fee
Fees Administrative CLTW Client Withdrawals QR fee w/o
Fees Administrative CLTW Client Withdrawals IRA Maintenance Fee
Fees Administrative CLTW Client Withdrawals Waived Incoming Transfer Fees
Fees Administrative CLTW Client Withdrawals Low Balance Fee
Fees Administrative CLTW Client Withdrawals Designated Beneficiary Plan Fee
Fees Administrative CLTW Client Withdrawals Inactivity Fee
Fees Administrative MFEEI Management Fee - Internal Invalid Email Fee
Fees Administrative MFEEI Management Fee - Internal Manual Fee Upload - Admin
Fees Administrative CDMF Cash Deposit Management Fees Fee Credit - Admin
Fees Administrative MFEEI Management Fee - Internal Fixed Income Fee - FOLIOfn
Fees Administrative MFEEI Management Fee - Internal Closed Account - Residual Bala
Fees Administrative MFEEI Management Fee - Internal IRA Maintenance Fee
Fees Administrative MFEEI Management Fee - Internal Express Mail
Fees Administrative MFEEI Management Fee - Internal Wire Transfer
Fees Administrative MFEEI Management Fee - Internal Certificate Delivery Same Regi
Fees Administrative MFEEI Management Fee - Internal Late Trade Settlement Fee
Fees Administrative MFEEI Management Fee - Internal Physical Corporate Action
Fees Administrative MFEEI Management Fee - Internal Returned Check/ACH Fee
Fees Administrative MFEEI Management Fee - Internal NSF Fee
Fees Administrative MFEEI Management Fee - Internal Stop Payment
Fees Administrative MFEEI Management Fee - Internal Check Copy
Fees Administrative MFEEI Management Fee - Internal Research Fee
Fees Administrative MFEEI Management Fee - Internal Restricted Securities (Rule 14)
Fees Administrative MFEEI Management Fee - Internal DTC Transfers
Fees Administrative MFEEI Management Fee - Internal Check Reorder
Fees Administrative MFEEI Management Fee - Internal Account Closing Fee
Fees Administrative MFEEI Management Fee - Internal Voluntary Corporate Action
Fees Administrative MFEEI Management Fee - Internal Misc. Fee
Fees Administrative MFEEI Management Fee - Internal Transfer of Secuities b/w acco
Fees Administrative MFEEI Management Fee - Internal Transfer of Securities & Tax L
Fees Administrative MFEEI Management Fee - Internal Transfer of cash
Fees Administrative MFEEI Management Fee - Internal Check Processing Fee
Fees Administrative MFEEI Management Fee - Internal Acat Transfer Fee
Fees Administrative MFEEI Management Fee - Internal Paper Statement Fee Advisor
Fees Administrative MFEEI Management Fee - Internal Charge off Fee
Fees Administrative MFEEI Management Fee - Internal QR fee w/o
Fees Administrative MFEEI Management Fee - Internal Waived Incoming Transfer Fees
Fees Administrative MFEEI Management Fee - Internal Low Balance Fee
Fees Administrative MFEEI Management Fee - Internal Designated Beneficiary Plan Fee
Fees Administrative MFEEI Management Fee - Internal Inactivity Fee
Fees Administrative CLTW Client Withdrawals Invalid Email Fee
Fees Investment Management MFEEI Management Fee - Internal Advisor Fee
Fees Investment Management MFEEI Management Fee - Internal Model Management Fee
Fees Investment Management MFEEI Management Fee - Internal Manual Fee Upload - Management
Fees Investment Management CDMF Cash Deposit Management Fees Fee Credit - Management
Fees Investment Management MFEEI Management Fee - Internal Fixed Income Fee - Advisor
Fees Investment Management CLTW Client Withdrawals Model Management Fee
Fees Trading Expenses MFEEI Management Fee - Internal FOLIOfn Fee
Fees Trading Expenses MFEEI Management Fee - Internal Maintenance Fee
Fees Trading Expenses CLTW Client Withdrawals Broker Assisted Trade
Fees Trading Expenses CLTW Client Withdrawals Dividend Foreign Tax Withheld
Fees Trading Expenses CLTW Client Withdrawals LT Capital Gains Foreign Tax W
Fees Trading Expenses CLTW Client Withdrawals ST Capital Gains Foreign Tax W
Fees Trading Expenses CLTW Client Withdrawals Return of Cap Foreign Tax With
Fees Trading Expenses CLTW Client Withdrawals Dividend Domestic Tax Withheld
Fees Trading Expenses CLTW Client Withdrawals Mutual Fund Redemption Fee
Fees Trading Expenses CLTW Client Withdrawals ADR Fee
Fees Trading Expenses MFEEI Management Fee - Internal W9 Withholding
Fees Trading Expenses MFEEI Management Fee - Internal Broker Assisted Trade
Fees Trading Expenses MFEEI Management Fee - Internal Dividend Foreign Tax Withheld
Fees Trading Expenses MFEEI Management Fee - Internal LT Capital Gains Foreign Tax W
Fees Trading Expenses MFEEI Management Fee - Internal ST Capital Gains Foreign Tax W
Fees Trading Expenses MFEEI Management Fee - Internal Return of Cap Foreign Tax With
Fees Trading Expenses MFEEI Management Fee - Internal Dividend Domestic Tax Withheld
Fees Trading Expenses MFEEI Management Fee - Internal Mutual Fund Redemption Fee
Fees Trading Expenses MFEEI Management Fee - Internal ADR Fee
Fees Trading Expenses IADJ Fund Dividend/Interest ADR Fee
Fees Fee Credit CDEP Client Deposits Manual Fee Upload - Admin
Fees Fee Credit CDEP Client Deposits W9 Withholding
Fees Fee Credit CDEP Client Deposits Designated Beneficiary Plan Fee
Fees Fee Credit CDEP Client Deposits Dividend Foreign Tax Withheld
Fees Fee Credit CDEP Client Deposits LT Capital Gains Foreign Tax W
Fees Fee Credit CDEP Client Deposits ST Capital Gains Foreign Tax W
Fees Fee Credit CDEP Client Deposits Return of Cap Foreign Tax With
Fees Fee Credit CDEP Client Deposits Dividend Domestic Tax Withheld
Fees Fee Credit CDEP Client Deposits Express Mail
Fees Fee Credit CDEP Client Deposits Wire Transfer
Fees Fee Credit CDEP Client Deposits Certificate Delivery Same Regi
Fees Fee Credit CDEP Client Deposits Late Trade Settlement Fee
Fees Fee Credit CDEP Client Deposits Physical Corporate Action
Fees Fee Credit CDEP Client Deposits Returned Check/ACH Fee
Fees Fee Credit CDEP Client Deposits NSF Fee
Fees Fee Credit CDEP Client Deposits Stop Payment
Fees Fee Credit CDEP Client Deposits Check Copy
Fees Fee Credit CDEP Client Deposits Research Fee
Fees Fee Credit CDEP Client Deposits Restricted Securities (Rule 14)
Fees Fee Credit CDEP Client Deposits DTC Transfers
Fees Fee Credit CDEP Client Deposits Check Reorder
Fees Fee Credit CDEP Client Deposits Account Closing Fee
Fees Fee Credit CDEP Client Deposits Voluntary Corporate Action
Fees Fee Credit CDEP Client Deposits Misc. Fee
Fees Fee Credit CDEP Client Deposits Transfer of Secuities b/w acco
Fees Fee Credit CDEP Client Deposits Transfer of Securities & Tax L
Fees Fee Credit CDEP Client Deposits Transfer of cash
Fees Fee Credit CDEP Client Deposits Broker Assisted Trade
Fees Fee Credit CDEP Client Deposits Check Processing Fee
Fees Fee Credit CDEP Client Deposits Acat Transfer Fee
Fees Fee Credit CDEP Client Deposits Paper Statement Fee Advisor
Fees Fee Credit CDEP Client Deposits Charge off Fee
Fees Fee Credit CDEP Client Deposits QR fee w/o
Fees Fee Credit CDEP Client Deposits Mutual Fund Redemption Fee
Fees Fee Credit CDEP Client Deposits IRA Maintenance Fee
Fees Fee Credit CDEP Client Deposits Waived Incoming Transfer Fees
Fees Fee Credit CDEP Client Deposits Inactivity Fee
Fees Fee Credit CDEP Client Deposits ADR Fee
Fees Fee Credit CDEP Client Deposits Invalid Email Fee
Fees Fee Credit CDEP Client Deposits Model Management Fee
Fees Fee Credit CDEP Client Deposits Fixed Income Fee - Advisor
Fees Fee Credit CDEP Client Deposits Fixed Income Fee - FOLIOfn
Fees Fee Credit CDEP Client Deposits Closed Account - Residual Bala
Fees Fee Credit CDEP Client Deposits Advisor Fee
Fees Fee Credit CDEP Client Deposits FOLIOfn Fee
Fees Fee Credit CDEP Client Deposits Maintenance Fee
Fees Fee Credit CDEP Client Deposits Low Balance Fee
Fees Fee Credit CDEP Client Deposits Manual Fee Upload - Management
Corporate Actions Exchanges EXNI Exchange Non Taxable - In Corporate Action
Corporate Actions Exchanges EXNO Exchange Non Taxable - Out Corporate Action
Corporate Actions Exchanges EXTI Exchange Taxable - In Corporate Action
Corporate Actions Exchanges EXTO Exchange Taxable - Out Corporate Action
Corporate Actions Exchanges SRI Security Receive In Corporate Action
Corporate Actions Exchanges SDO Security Deliver Out Corporate Action
Corporate Actions Mergers MER Cash merger Corporate Action
Corporate Actions Mergers IADJ Fund Dividend/Interest Corporate Action
Corporate Actions Name Changes NC Name Change Name Change
Corporate Actions Stock Splits SS Stock Split Shares Added
Corporate Actions Stock Splits SRI Security Receive In Shares Added
Corporate Actions Stock Splits SS Stock Split Shares Removed
Corporate Actions Stock Splits SDO Security Deliver Out Shares Removed
Corporate Actions Spin-offs SPNI Non-Taxable Spinoff In Corporate Action
Corporate Actions Spin-offs SPNO Non-Taxable Spinoff Out Corporate Action
Corporate Actions Spin-offs SPTI Taxable Spinoff In Corporate Action
Corporate Actions Spin-offs SPTO Taxable Spinoff Out Corporate Action
Corporate Actions Spin-offs SDO Security Deliver Out Corporate Action
Corporate Actions Spin-offs SRI Security Receive In Corporate Action
Corporate Actions Others CLTW Client Withdrawals Pending Rights
Corporate Actions Others IADJ Fund Dividend/Interest Legal
Corporate Actions Others SDO Security Deliver Out Legal
Corporate Actions Others SRI Security Receive In Legal
Corporate Actions Others SRI Security Receive In Tender
Corporate Actions Others SDO Security Deliver Out Tender
Corporate Actions Others CLTW Client Withdrawals Tender
Corporate Actions Others CDEP Client Deposits Tender
Corporate Actions Others IADJ Fund Dividend/Interest Call
Corporate Actions Others SRI Security Receive In Call
Corporate Actions Others SDO Security Deliver Out Call
Corporate Actions Mergers SDO Security Deliver Out Corporate Action
Corporate Actions Mergers SRI Security Receive In Corporate Action
Sweep Sweep Buys B Buys Sweep Buys
Sweep Sweep Sells S Sells Sweep Sells

Response Example


HTTP/1.1 200 OK
Date: Thu, 14 Mar 2019 17:40:04 GMT
Transfer-Encoding: chunked
Location: https://api.uat.foliofn.com/restapi/accounts/RB18938005/transactions
Content-Type: application/json

[
  {
    "accountId" : "2445361",
    "categoryName" : "Distributions",
    "commission" : "0.00000",
    "date" : "2016-01-08T00:00:00.000-05:00",
    "folioName" : "Mid/Large Cap Blend",
    "marketNet" : "0.00000",
    "marketPrice" : "0.00000",
    "net" : "0.36000",
    "notes" : "",
    "price" : "0.00000",
    "quantity" : "0.77285",
    "subCategoryName" : "Dividends",
    "symbolName" : "MERCK & CO INC",
    "ticker" : "MRK",
    "transactionCode" : "CDIR",
    "transactionDesc" : "Cash Dividend Receipt",
    "transactionId" : "108",
    "transactionType" : "Dividend"
  }
]

Change Log

03/05/2020

  1. Remove the extra empty line(s)

03/14/2019

  1. Updated Response Data Fields
  2. Updated Response Example

03/24/2017

  1. Updated Date Range Codes
  2. Updated Response Data Fields
  3. Updated Response Example
  4. Added Notes Field

11/03/2016

  1. Added additional query paramenters

07/08/2016

  1. Reordered Page Sections

07/01/2016

  1. Updated Category Names to Transaction Codes table

02/01/2016

  1. Updated descriptions

Getting Started

Quick Start Guide

REST APIs

Account Service
Alert Service
Corporate Actions Service
Deposit & Withdrawal Service
Download Service
Firm Service
Folio and Trade Service
Member Service
Model Service
Performance Service
Private Placement Service
Reporting Service
Securities Service
Transfer Service
Upload Service

Resources

Terms and Codes
Utils