Data Normalization
Meld normalizes the data you receive from service providers. While you can always see the raw service provider response both in the serviceProviderDetails object of each endpoint when getting data as well as from the Activity Log, Meld does several things to normalize the data you receive.
Balance Signage
Balance signage should generally positive for all account types. This includes loan, mortgage, and credit accounts, where positive balances indicate the amount of money a user owes.
Transaction Signage
Service providers use different signage for deposite vs withdrawals. Meld standardizes the signage to the following:
-
Positive -- Positive signage means that money has moved out of the account. Transactions with positive signage include withdrawal and debit.
-
Negative -- Negative signage means that money has moved into of the account. Transactions with negative signage include deposits.
Investment Types
For both investments and investment holdings, Meld normalizes the investment type in the response.
-
For investment holdings, the Meld types are
STOCK,MUTUALFUND,CASH,OTHER,REALESTATE,ETF,DERIVATIVE, andDIGITALASSET. -
For investment transactions, the Meld types are
SELL,BUY,CANCEL,CASH,OTHER, andTRANSFER.
Transaction Status
Transactions will have one of the following statuses:
-
Pending -- All transactions start as
PENDING. A pending transaction is a payment, deposit, or purchase that has been approved but not yet fully processed. -
Posted --
PENDINGtransactions will move toPOSTEDwithin a few days. The typical time period for a transaction to move from pending to posted is one to five business days, with generally a two week maximum on rare occasion. -
Expired -- On rare occasions,
PENDINGtransactions get cancelled and therefore stop showing up in the service provider responses. When this occurs, the transaction becomesEXPIRED.
As a result, when updating account transaction data, a period of two weeks (fourteen days) is recommended in order to capture transaction changes. After two weeks, it is extremely rare for any information about a transaction to change.
Transaction Categories
While providers themselves group transactions into their own categories, Meld also normalizes transaction categories between providers. Here is the list of provider category mappings to Meld categories:
Updated 2 months ago