Income Statement & Balance Sheet shows money on the Investments line after all stocks are sold, or a figure that does not match the total cost basis of currently held securities.

When looking at the Income Statement & Balance Sheet, you might find a basis that doesn't match the current club holdings. This is often noticed after all stocks are sold, but can happen when comparing holdings at the end of the year

This happens when there some fractional share or cost basis left over after the final sale of the stock; if the number of shares or basis do not both go to zero, the security won't show up as active, but may still impact the Investments line on the Income Statement and Balance sheet report.

The easiest way to correct this will usually be to re-do the final sale for the stock. Doing so will have the system audit the transaction, and correct the issue. We suggest to have a pen or pencil, and a pad of paper handy when taking the following steps:

First, make a backup of the current club records

  • Go to Accounting > Utilities > Backup Manager
  • Click the Make Backup button. The site will take a few seconds, and then show a new entry in the list of backups. The backup will show the club name, as well as the day and time the backup was made.

 

Once you have the backup made:

  • When you are signed in to Club Accounting Online, go to Reports. Select Individual Security Ledger, and then click View Report.
  • Scroll down to the bottom of the page, and check the list of securities; sold securities will have a * after the name.
  • If you find a listing for a stock that was sold, but does not have a * after its name, click to select that security.

 

Once you have the stock selected:

  • Set the From date to the beginning of the year that the stock was sold.
  • Click the Submit button.
  • Find the final Sell Security transaction or transactions; often you will find two Sell entries on the same date; click the two word description to bring up the details of whichever Sell was listed last, on the report.
  • Make note of the transaction details, such as the date, amount, and the account used.
  • Click Edit to begin re-entering the transaction. By default, Club Accounting will remember all of the details, so the only change you will usually need to make is to advance the date of the transaction to one day later; beyond that, simply click Continue or Submit as needed to complete the transaction.

 

If you find that there is still some fractional share or cost basis left over after this, the same process can be used to re-check any transaction for the stock. The most common transactions to use this on will be Splits, Buys and Sells. If this becomes necessary, it will be best to start with the first Stock Split, or Stock Sell in the transaction history for the stock in question, and then work your way forward through the stock's history.

If you have re-checked all transactions for the stock, and the shares or cost basis continues to appear, please contact support to let us know.