For all LPL Financial Formats
We will never manually tag values for LPL’s data labeling or reconciliation tagging.
Meaning, when you come across an LPL statement in a client’s Trust Accounting To-do sub stack, you will have to table tag every single value, as you would if you were creating a labeled sample.
Only “Normal Tags” (Provider, Account Number, Period Start & End) do not need to be table tagged.
Please double check the Period Start & End dates in the metadata field to make sure they are tagged correctly according to the statement’s format.
Format 1.1
Step 1
Step 2
If the Cash Activity Summary table is on one single page (and not split between two pages)
Tag the table as normal.
If the Cash Activity Summary is split between two pages
First tag all the values present in each half of the table
Then table tag the missing values on each half of the table
Extractions:
Beginning Balance
Returns
Ending Balance
TX: Deposits
TX: Withdrawals
TX: Purchases
TX: Sales
Dividends
Interest
Capital Gains
Distributions
TX: Reinvestments
TX: Fees
TX: Other
Equations:
TX: Income
={dividends} + {interest} + {capital gains} + {distributions}
Gain/Loss
={returns} - {tx: income} - {tx: fees} - {tx: other} - {tx: reinvestments}
The normal Transaction Detail guidelines will be followed and used for these statements
Table Name: Transaction Detail
Column Names: Date, Description, & Amount
Format 1.2
Extractions:
Beginning Balance
TX: Deposits
TX: Withdrawals
Dividends
Interest
Capital Gains
Distributions
Gain/Loss
Ending Balance
TX: Fees
Equations:
TX: Income
={dividends} + {interest} + {capital gains} + {distributions}
The normal Transaction Detail guidelines will be followed and used for these statements
Table Name: Transaction Detail
Column Names: Date, Description, & Amount
Format 2.1
Step 1
Step 2
Step 3
Extractions:
Beginning Balance
TX: Deposits
TX: Withdrawals
Returns
Ending Balance
TX: Sales
Distributions
Other In
Other Out
TX: Purchases
TX: Reinvestments
TX: Fees
Equations:
Gain/Loss
={returns} - {tx: income} - {tx: fees} - {tx: other} - {tx: reinvestments}
TX: Income
={dividends} + {interest} + {distributions}
TX: Other
={other in} + {other out}
The normal Transaction Detail guidelines will be followed and used for these statements
Table Name: Transaction Detail
Column Names: Date, Description, & Amount
Format 2.2
Step 1
Step 2
Extractions:
Beginning Balance
TX: Deposits
TX: Withdrawals
Returns
Ending Balance
TX: Sales
Dividends
Interest
Distributions
Other In
TX: Purchases
TX: Reinvestments
TX: Fees
Other Out
Equations:
TX: Other
={other in} + {other out}
TX: Income
={dividends} + {interest} + {distributions}
Gain/Loss
={returns} - {tx: income} - {tx: fees} - {tx: other} - {tx: reinvestments} - {tx: other}
The normal Transaction Detail guidelines will be followed and used for these statements
Table Name: Transaction Detail
Column Names: Date, Description, & Amount
We will not include Income Not Yet Paid in the Transaction Detail.