web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Multiple Customers per Job? Fund accounting with BC

(0) ShareShare
ReportReport
Posted on by 113

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!

I have the same question (0)
  • Suggested answer
    JAngle Profile Picture
    133 on at

    A fund dimension is the one we’ve used for a collection of our NFP clients. If you’re sold on jobs take a look at: appsource.microsoft.com/.../PUBID.progressussoftware|AID.progressuseu|PAPPID.131f85d1-48f2-481c-8d5a-849b16e388e6

    It allows for multiple customers per job

  • Verified answer
    Atahualpa Profile Picture
    113 on at

    We're mostly sold on BC, but not at all sold on handling funds as separate jobs. If there is a better way to do that we'd like to know. I know of an app created to enable BC to do fund accounting, but it's pricey for a small NFP. I've looked briefly at Progressus but it seems like it's all about projects and not really about fund accounting. I may be misunderstanding, but seems like we would be buying a whole lot of machinery to get a small bit of ancillary functionality that we need. But I will take another look at it. I didn't look at it very closely. Thanks for your suggestion.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,151

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,443 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,092 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans