Hi everyone. I think we have a pretty unique situation.

Our club's chequing account has been previously split into 3 "virtual" accounts: General Account (this would be the balance remaining from the other two), Darts Fund, and Capital Replacement Fund. These are all supposed to be assets.

Members will want the treasurer (who I'm helping set this up) to show the balance of these 3 "accounts" on the monthly reports.

The previous treasurer used excel and calculated the balances that way. 

In Sage, though, I can't seem to figure out how to accurately show these 3 accounts without messing up reconciliation of the chequing account.

One suggestion so far was to add those accounts as customers and give them a credit, and make GL accounts in expenses. This would list them as expenses, though. Eventually, expenses will come out of these funds.

Another suggestion was to have them listed as bank accounts and take those amounts off the chequing account. We would have to alter the month-end balance on the bank statement for reconciliation, though. Plus, we would have to reconcile the other two accounts and essentially make up a statement for them. I really don't like this idea as it requires a lot more work than necessary.

In talking with the previous treasurer, she said normally you'd have separate bank accounts for them, but never bothered with it because the fees might outweigh any interest made.

It's been agreed to start one other savings account so that we can have the Cap. Replacement Fund separate. That doesn't solve the issue with the Dart Fund, and how to represent these accounts earlier in the fiscal year.

So that's our conundrum. If anyone has any suggestions, I am all ears.

Thank you