Template Questions
Mutual Funds
SDBA Flow Thru
Other Investments
Misc.
100

The template has many balance checks. Except for the Financial Report they are this color.

What is Blue.

100

This is the activity you have to manually link to the plan totals tab.

What are Distributions, Expenses and Transfers.
100

Plans with Master flow thru account. Distributions should be shown in what column on the plan totals tab. (Master or Participant).

What is the participant column. 


100

These are the four types of activities that can be included on the other investment tab (ins/outs)

What are:

Transfers

Contributions

Fee's

Distributions

100

Final adjustments for any Liabilities, carry forward contributions, or other receivables should always be made on this tab. 

What is Plan Totals. 

200

For the Financial Report set up the brokerage names link from here.

What is Plan Totals Row 108

200
If contributions are made to mutual funds. This is what you do with them.

What is link to contribution recon tab. 

200

This is how the per account for the master flow thru account should be set up to show a distribution.

What is one column titled distribution/ Distribution transfers. 

200

This is where the ins/outs for other investments should flow thru. 

What are the brokerage accounts or checking accounts.

200

These are the COLA limits for 2023 for EE, Catch up, and ER contributions. 

What is EE- $22,500

Catch up- $7,500

ER- $66,000

300

Template set up, Financial Report beginning balances link from here.

What is they do not link they are keyed. 

300

This is where you enter the per account activity for Mutual Finds.

What is the Mutual Funds Tab. 

300
This is what the difference would be if the Master Account (per account) column for distributions/ distribution transfers does not equal zero.

What is forfeiture money. 

300

What automatically links from the Other Investment Tab to the Plan Totals.

What is Nothing.

300

For Solo K plans with 1 participant and 1 account. This is what you choose on start here. Pooled or SDBA. 

What is the choice is based on how the account is titled. 

400

This is where you check to make sure you have not hidden any columns with data.

What is Start here Tab column F. 

400

This information automatically links from the Mutual Funds tab to the Plan totals.

What is Gain/ Loss and ending balance.

400

This is what needs to be done on the plan totals when a final contribution deposit (dated 12/29) does not transfer to participants. 

Set up transfers due. 

400

This is the value that is used for annuities and insurance.

What is Cash Surrender Value.


400

When you have an SDBA plan with master flow thru account this is what you must ALWAYS complete.

What is the per account tab. 

500

This is where you pull the Net Beginning Balance for the plan totals tab.

What is Prior Year Trust Accounting.

500

Mutual fund purchase are typically what type of activity.

What is contribution deposits. 

500

If a plan has contribution transfers due at the end of the year. This is what you do on the contribution recon tab with those transfer due amounts. 

What is allocate to participants in which they belong to. 

500

This is where the detailed transactions for rental income/ real estate expenses/ and limited partnership income get reflected.

What is the Per account tab and linked to per account section of plan totals.

500

This is how the per account tab should be set up for the master flow thru to show contribution transfer to each participant to make it easier to identify the total contribution transfers to each participant.

What is make a column for each participant receiving contribution transfers.