Reinvesting Fund income results in a negative Cash Balance in the Brokerage Account.

Legacy KB ID: 5239

Question

Why does my Brokerage account show a negative cash balance after I process a Reinvest Fund income transaction?  The negative balance is equal to the amount of Fund Income.

Answer

This issue arises when you.

·         Add a Single Managed Fund to a Share Brokerage account.

·         Use the Reinvest - Income Reinvested transaction; and

·         List the income received in the Trust/Fund field.

The Income is not recognized in the Brokerage Cash Account and the Cash Account is charged for the reinvestment, leaving a negative Cash Balance equal to the amount of the Fund Income. 

The same transaction on an Investment Account created as a Single Managed Fund type will not have this problem.

  

Workaround

Restore the Cash Balance with a transaction to a Liability Account:

1.    Setup Liability Account in Property & Debt – Reinvesting clearing

2.    Enter transaction – Increase amount against Brokerage account.

3.    The Cash Balance in the Brokerage account will be restored.

Offset the Liability account in relevant reports – Net worth.

1.    Reports > Net Worth & Balance > Net Worth

2.    Customize > Accounts > untick the Liability Account. 

Please Note that on the Investing Overview screen, the Cost Basis on the header total for the Fund will be incorrect by the accumulated amounts of Fund Income.

 

Alternative Method 1

1.    Enter Fund Income as Record an Income Event

2.    Reinvest income in Trust units with Buy – Shares bought

 

Alternate Method 2

Create separate Investing Account with type Single Managed Fund

 

 

Need more help?

Ask the Reckon Community at: https://community.reckon.com/reckon.

 

How did we do?

There is no option to change the Profit and Loss statement to Cash or Accrual accounting.

Cannot replace a category on a transaction in Quicken

Related Articles

Powered by HelpDocs (opens in a new tab)

Powered by HelpDocs (opens in a new tab)