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

Announcements

News and Announcements icon
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 119

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
    159 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
    119 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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,344 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,742 Super User 2026 Season 1

#3
AndrewThomas81 Profile Picture

AndrewThomas81 1,231

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans