Hello Amigos:
Our not for profit is setting up BC as our new ERP, but I've run on to a snag I didn't anticipate and hope you can help me with a work-around or better option.
As a NFP we have to keep up with numerous funds. BC doesn't have native functionality for fund accounting, but several people thought we could handle each fund as a separate job.
The idea was to treat each donor as a "customer." Donations to a particular fund would be treated as a payment to the job-fund. Vendors would be paid from the job-fund and thus we could keep a running total for the job, sort of like viewing one's bank account, with credits, debits, and running balance. Something like this:
XYZ School Construction Fund | |||
Description | Donation | Expense | Running Total |
John Smith donation | 10,000 | 10,000 | |
Bill Jones donation | 2,000 | 12,000 | |
architectural fee | (3,000) | 9000 | |
Mary Garcia donation | 50,000 | 59,000 | |
James Baker donation | 40,000 | 99,000 | |
Contractor draw | (29,000) | 70,000 |
Now the problem i've just discovered is that a job in BC can only have one customer and thus we can't create separate "sales invoices" or receipts for each donor, nor can we create a report detailing the separate donations to a particular fund by donor.
I'd be very grateful for any suggestions for a good way to do this, or a specific work around for this issue.
Thanks in advance for your help!