Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Cash Basis Accounting

(0) ShareShare
ReportReport
Posted on by 20

Dear All, 

My customer is an ONG which has the accounting principle of the cash basis instead of the accrual basis. 

Could anyone confirm if this accounting principle is eligible in D365FO? If so, could you explain how to set it up?

Basically, the revenues and expenses are recognize when the payment is received, not when the invoices are posted.

Many Thanks in advance, 

Joan

  • Joan Bonilla Profile Picture
    20 on at
    RE: Cash Basis Accounting

    Hi Morem, 

    This solution sounds promising. I will test it and let you know. If you or anyone else have more ideas that could help, please let me know

    Many thanks

    Joan

  • MM-20051452-0 Profile Picture
    on at
    RE: Cash Basis Accounting

    Hi Joan, 

    Customers require Cash Basis accounting usually depends on General Ledger & Cash & bank management to fulfill their requirements. However, we can follow with multiple workarounds based on Projects & Procurement processes that will require some manual follow ups. 

    - For project transactions (Revenues & expenses), you can use Fixed Project types and setup with WIP accounts and on monthly basis you can transfer the settled transactions to P&L. 

    - For General vendor expenses, you can use the Vendor invoice register to update accruals accounts and with payment, post Vendor invoice approval with method of payment cash. 

    Regards, 

    Momen Mansour

  • Joan Bonilla Profile Picture
    20 on at
    RE: Cash Basis Accounting

    Hi Ludwig,

    Thanks for your prompt response.

    ONG: NGO (I just typed it in Spanish by mistake, apologies)

    Basically this NGO is a projects-based company. They receive and manage donations to fund fixed price projects. They  will use all the transactions from the projects and accounting module (timesheets, fee journals, expense journals etc), as well as purchase requisitions and purchase orders. Public Sector module will be activated.

    So they told me that they recognize the revenue when they collect the money from the customer payment journal, not when they post the invoice. Same with the procurement end.

    Many thanks in advance for your help, and please do not hesitate to ask me any further doubts

    Regards

    Joan

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Cash Basis Accounting

    Hello Joan,

    Can you explain what you use the abbreviation ONG for?

    Also, can you give us a brief outline of what transactions you plan to record in D365FO?

    (sales orders, purchase orders, etc.)

    Many thanks,

    Ludwig

  • Joan Bonilla Profile Picture
    20 on at
    RE: Cash Basis Accounting

    Hi Ramit,

    Thanks for your answer. How would you implement that in MR?

    Regards

    Joan

  • Ramit Paul Profile Picture
    22,387 Most Valuable Professional on at
    RE: Cash Basis Accounting

    Cant you just create management reporter to have your PL and BS report there?

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,309 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,160 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Product updates

Dynamics 365 release plans