Sage 2009 - Charity Accounts - The Book-keepers Forum (UK)

ADAS · Guru

Sage 2009 - Charity Accounts

semsley · Guru

Hi Tony

I did not know that Sage did actual Fund Accounting. I work for a couple of charities one has Sage Instant Plus V16, the other Quickbooks. On the Sage I give each restricted fund a Dept No and account for the income and expenditure using dept reports.

I did used to do another one which had Line 50 can't remember the version but that also had the facility to do P & L and Balance Sheet for the Depts.

Pitfalls to watch out for at year end are double counting income if invoicing internal income to the funds.

Sheila

-- Edited by semsley on Wednesday 1st of June 2011 11:09:11 PM

ADAS · Guru

Hi Sheila,

Thanks for the reply, I'll bear that in my mind.

Do you go as far as to split e.g wages control accounts to funds?

One feature I quite like about Sage is you can map your chart of accounts to a SOFA report. I haven't done this yet but should be handy as the client wanted a bespoke chart of accounts.

semsley · Guru

Do you go as far as to split e.g wages control accounts to funds?

Yes, ish - we split the staff into Core Staff, Project Staff and Cleaning Staff on Sage. We also use Freelancers who we assign to the relevant project/fund.

We have very detailed timesheets where staff allocate every 15 mins to a project/ fund, this time is then logged on a spreadsheet for charging to the fund for monitoring and reporting to funders at an hourly rate taking into account on-costs, but this is not on replicated Sage.

For the QB charity I split all the wages between the projects, some of the staff work x hours on one project and x hours on another. Again I use a spreadsheet and use a % of monthly salary + % employers NI and journal between the projects.

HTH

Sheila