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!