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.
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.