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

Fund Accounting in Business Central

(0) ShareShare
ReportReport
Posted on by 113

Any suggestions for doing Fund Accounting in BC? I've heard that treating each fund as a project is one way of doing it. Is that recommended? Are there better options?

Thanks in advance for your help!

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

    The jobs method is the one I’ve discussed most with a colleague who knows GP. On top of the job I would setup a dimension called Fund and assign it to the job, plus all the others you need. PO’s and PI’s can be assigned at line level to the job. All dimensions from the job will follow on. You can perform postings to the g/l with the job g/l journal. If you only want postings on the job just use the job journal. WIP may not be applicable and you can ignore if so.

    I’ve discussed doing a modification with my colleague but it would be based on jobs still.

  • Suggested answer
    Community Member Profile Picture
    on at

    Hello,

    When Fund Accounting comes up in NAV or BC I always turn to an Addon/APP's:

    1. Tangicloud Fundamentals - tangicloud.com/.../

    2. BroadPoint N-F-P - www.broadpoint.net/.../dynamics-365-business-central-fund-accounting

    Hope these help.

    Thanks,

    Steve

  • Atahualpa Profile Picture
    113 on at

    Thanks for your help. Sorry to be slow in responding. I'm still trying to understand "jobs" and dimensions and have been watching videos and reading everything I can find on the subject.

    If I'm understanding you correctly, you're saying that we can indeed set up each fund as a "job" and thus keep track of beginning and ending balances for the fund/job, in addition to all income and expenses in that fund/job. You also suggest setting up a dimension called "Fund" which would essentially be a tag on the fund/job and all income and expense associated with it, by which we can also track those balances, expenses, and income. But, I think I must have misunderstood the purpose of the dimension. If it is just a tag linked to the fund/job and all associated balances, expenses, and income then what does the dimension do beyond what can already be tracked by the job?

    I'm probably asking a silly novice question. Thanks in advance for any help you have time to give me!

  • Suggested answer
    JAngle Profile Picture
    133 on at

    Job dimension is purely for using the standard reporting tools for g/l transactions. Account schedules and analysis views can then show you financial transaction detail about the job. If you only intend to post job journals then my comment can be ignored.

  • Atahualpa Profile Picture
    113 on at

    Thank you! This was very helpful!

  • Kerry Evans Profile Picture
    165 on at

    Treating each fund as a project is a common approach to fund accounting in BC, and it can be effective for many organizations. By setting up each fund as a project, you can track its revenue and expenses separately, which makes it easier to ensure that the funds are being used as intended and to report on their financial performance.

    However, there are other options for fund accounting in BC, and the best approach will depend on the specific needs of your organization. Some other approaches that you may want to consider include:

    Using fund accounting software: There are many software solutions available that are specifically designed for fund accounting. These systems can help you track revenue and expenses for each fund, generate reports, and manage compliance requirements.

    Using separate bank accounts: Some organizations choose to set up separate bank accounts for each fund, which can make it easier to track the inflows and outflows of each fund. However, this approach can be more time-consuming and may not be practical for organizations with a large number of funds.

    Using cost centers: Instead of setting up each fund as a project, you could set up cost centers to track the revenue and expenses for each fund. This approach can be less complex than setting up projects and may be a better fit for organizations with fewer funds.

    Ultimately, the best approach will depend on your organization's needs, resources, and the complexity of your fund accounting requirements. It may be helpful to consult with a financial advisor or accountant to determine the most appropriate approach for your organization.

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,229

#2
Jainam M. Kothari Profile Picture

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

#3
YUN ZHU Profile Picture

YUN ZHU 1,153 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans