CMS Fund Accounting - The Current Period Changes In The Beginning Balance Column On The Statement Of Financial Position Is Not Zero

PROBLEM:  The Current Period Changes in the Beginning Balance Column on the Statement of Financial Position is not zero. 

SOLUTION:  Print the Statement of Financial Position Report to get a hard copy of the report.  Make a note of the Shortcut Number of the Net Asset account (300 in the example below), and you'll need to know the amount in the Beginning Balance column under Current Period Changes (-$97.12 in the example below). 




Make sure you have a recent backup of your system before you begin this process.

From CMS Ledger, click File | Utilities | File Editor.

Click OK at the warning message.

Click Select Table to Edit and open ACCOUNTS.DB.

 

With your mouse, right-click the first number under the Shortcut Number column and choose Filter.

At Filter for Shortcut Number, type the shortcut number of your Net Asset account, our example was 300, and click OK. 

Now you should only see your Net Asset Account number.  Scroll to the right until you see the columns Carry Forward Balance, Beg Bal Last Month and Beginning Balance.

Click the Edit button at the top of the display.

If the Current Period Changes amount in the Beginning Balance Column was a Negative amount, subtract that amount from the totals in the Carry Forward Balance, Beg Bal Last Month and Beginning Balance.

If the Current Period Changes amount in the Beginning Balance Column was a Positive amount, add that amount from the totals in the Carry Forward Balance, Beg Bal Last Month and Beginning Balance.

In our example, the Current Period Changes was a negative, so we're going to subtract $97.12 from the totals, and in our example we'll:

  • Change the Carry Forward Balance from $34,589.11 to $34,491.99 (we’re subtracting out the $97.12).
  • Change the Beg Bal Last Month from $31,011.54 to $30,914.42.
  • Change the Beginning Balance from $31,011.54 to $30,914.42.

You'll need to refer to your Statement of Financial Position Report and calculate the correct amounts for your church based on the amount in the Current Period Changes in the Beginning Balance column and the amounts displayed in your Net Asset account.

Click Close.

Click File | Utilities | Recalculate Year | Finish.



Come back into CMS Ledger and click Process | Calculate Balances | Finish.

Now reprint your Statement of Financial Position Report and you should no longer see an amount in for the Current Period Changes in the Beginning Balance column, and the YTD Change column should now be the correct amount!

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.