News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Cash Receipts Question

Finance | Project Operations, Human Resources, ...

Answered

Cash Receipts Question

(0) Share

Report

Report

Posted on by Darin722

55

I have done some research and cannot figure out if we can do this in GP or not. I was hoping someone may be able to help me. We are going to be offering payment of Sales Invoices through a third party payer so they are going to take a fee from us depending on if the client pays by ACH or credit card. We will know that fee at time of the cash receipt. Is there a way for us to add that into the cash receipt to charge it to the expense account we designate since we need to reflect we got less money but received the whole AR amount?

Categories:

Microsoft Dynamics GP

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Joseph Markovich 3,900 on at

Like (2)

Report

RE: Cash Receipts Question

Darin-

I've done this trick in the past and it has always worked well.

Since the fee is essentially a writeoff, in the master posting setup in GP (Administration > Posting > Posting Accounts) under Sales, change the Writeoffs account to be whatever account you want the fee to hit.

When entering cash receipts and applying to open transactions, enter the actual amount of cash you're going to receive in the Apply Amount column and the fee in the Writeoffs column. This will make the whole invoice paid, the proper amount of cash received and hit Bank Deposits/Reconciliation correctly and the fee gets posted to the GL.

I hope this helps.

Joe

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans