Sage for charities nightmare. HELP!

Sage for charities nightmare. HELP!

Didn't find your answer?

I do the bookkeeping for a charity. I started a month ago and I am completing the Q2 report. The problem is the charity generally recharges expenses retrospectively between departments. this results in the central department bearing all the overhead costs initially and then the other departments making a lump contribution to spread it out more evenly at the end of the quarter. Prior to my taking on the role this has been apportioned in sage and it doesn't seem any entries have been made in sage.

How do I post the contribution journals without going through it transaction by transaction. there are 1500 transactions and it will be unfeasible to do it one by one.

Is anyone familiar with this particular issue with charities. 

Please HELP!

Replies (2)

Please login or register to join the discussion.

avatar
By RFL H
09th Nov 2012 14:31

A single Journal per category

I assume you know the amounts you need to post to each department?

e.g. On a % of total basis.

 You do a single journal for each category of expense as follows -

Credit the central department with the total to be distributed using the relevant NC.

Debit each of the other departments with their share using the same NC.

This will leave your TB for that NC unchanged but your departmental analysis updated.

Thanks (1)
avatar
By AANM
09th Nov 2012 15:24

Many thanks for your reply.Yes I have thought of doing it like that but they apportion a huge contribution at least 10000 to be recharged from the other departments to department one as a lump sum. These apportionments are not based on nominal codes and Sage cant do anything without NCs. I combed through the prior year's accounts and the accountant before me hadnt done this before either. I have since concluded its a case of someone unfamiliar with sage expecting it to do amazing stuff. I resorted to excel for the final report and everyone is happy:)

Thanks (0)