User Support Forum

We currently have 4 cd's with our bank which when originally entered, were combined as one lump sum. One of the CD's is restricted by the donor for emergency use by our Trustees in case we needed a major repair, like a roof or boiler, etc. However this CD is on the books with the others as one total under our unrestricted general fund account. How can I adjust this to reflect 4 separate CD's, 3 still under General and the one under Buildings & Grounds restricted fund.

First, create the accounts for the buildings and grounds restriction (adjust the account numbers and levels to your liking)

Fund Accounting, Maintain Chart of Accounts, ADD (detail,income, level 5)
01-3210-101 Buildings and Grounds Equity
Note: this is under the Temporarily Restricted Equity Group in the default chart of accounts
01-4210-101 Buildings and Grounds Income (closes to 3210)
Note: this is under the Temporarily Restricted Income Group in the default chart of accounts
01-4810-101 Building and Grounds Release (closes to 3210)
and if needed:
01-4999-000 General Release (closes to 3110, unrestricted)

If your existing CD assets are in 01-1260-000, then I would add a group account and move the amounts as follows: ($400, $500, $700 are unrestricted, and $650 is restricted, total in current account is therefore, $2,250)

Fund Accounting, Maintain Chart of Accounts, ADD (Group,asset, level 4)
01-1255-000 CDs (Group account)
01-1260-000 CD #1 (rename the existing account and change to detail, level 5)
01-1262-000 CD #2 (detail, asset, level 5)
01-1264-000 CD #3
01-1266-101 CD #4 Buildings and Grounds (restricted amount)

Move the unrestricted amounts:
DB 01-1262-000 CD #2 $500.00
CR 01-1260-000 CD #1 $500.00

DB 01-1262-000 CD #2 $700.00
CR 01-1260-000 CD #1 $700.00

Move the restricted amount:
(assuming that you credited General Tithes when receiving the amount):
DB 01-4110-000 General Tithes $650.00
CR 01-4210-101 Buildings and Grounds (restricted income account) $650.00

DB 01-1266-101 CD #4 $650.00
CR 01-1260-000 CD #1 $650.00

Note: this leaves $400.00 in 01-1260-000 CD #1

When you spend the money from CD #4, if you access the money directly from the CD account to an expense account:
Fund Accounting, Enter Transactions:
DB 01-5810-000 building expense $amount
CR 01-1266-101 CD #4 $amount
DB 01-4810-101 $amount (this will update the restriction)
CR 01-4999-000 $amount (this will update the restriction)

The use of the -101 subaccount on the restriction allows you to use the sub-account filter on reports to view all of the restriction transactions at one time.