Finance | Project Operations, Human Resources, ...

Cash Batch and Bank Fees

(1) Share

Report

Posted on by CA-27040912-0

Importing a Cash Receipts Batch would normally Debit Cash for the amount of the Check and Credit an A/R account for the same amount which is also the total of the invoices being paid (Entries in the RRM20201 Open Transactions Apply table).

However US Bank when depositing money in our KeyBank account for a customer, will keep 1.3% or so as a fee.

So when I import the Cash batch, I want the PYMNT record to Debit Cash for the amount of the check, Credit the A/R account for sum of the amount being applied and then also Debit a /Fee/ account for the amount of the Bank so that the Debits / Credits balance.

Example:

Account Debit Amt Credit Amt

Cash 34,449.13

A/R 34,898.32

Fee Acct 449.19

When I do this, and try tp post the batch in GP, I get an error message: /The Accounts Receivable Distribution does not equal the Actual Amount/ even the the entry is in balance.

The Post report shows the correct distribution, and it lists the individual invoices being applied that equal the A/R Credit amount, but the Batch Total on the report shows the amount of the Check only $34,449.13

I must not be setting some value correctly when importing the batch. Thoughts?

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

Lisa at AonC.com 1,154 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Check your Distribution Types. RECV should total $34,898.32. CASH should be $34,449.13. Curious what you have Fee Account distribution type set to.

If you aren't familiar with Distribution Types, open the unposted transaction in GP Cash Receipts Entry window. Click Distributions. Note the distribution types, accounts, and amounts. Click the Default button. Note how the values changed from what they were based on your import.

Was this reply helpful? Yes No
CA-27040912-0 6 on at

Like
a
(0)

Report
Copy link

Link copied!

For the Bank Fee, I used a Distribution Type of 8 (Other)

It would not let me use 1 (cash) or 3 (AR) as it thought it was duplicate.

I thought of using 12 (Misc) or 16 (Finance Charge) would one of those or something else be better?

Was this reply helpful? Yes No
Suggested answer

Lisa at AonC.com 1,154 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

The correct Distribution Type is based on how you are mapping the values into the Amount fields. Did you do this step to determine what GP is expecting the distribution types to be? This is the fastest/easiest way to determine what GP is expecting.

>>If you aren't familiar with Distribution Types, open the unposted transaction in GP Cash Receipts Entry window. Click Distributions. Note the distribution types, accounts, and amounts. Click the Default button. Note how the values changed from what they were based on your import.

You may find that you don't like the distribution types the default shows and you can fix that by adjusting what Amount fields you are mapping the data to in Integration Manager.

Was this reply helpful? Yes No
CA-27040912-0 6 on at

Like
a
(1)

Report
Copy link

Link copied!

OK, so manually entering a transaction in our Test database, the distribution worked when Picked RECV (which is the same for the AR Account).

So the entry looked like this:

DEBIT CREDIT

CASH 1400.00

AR 1417.02

FEE 17.02

In the RM10101 /*Distribution Work and Open */ table, the column SEQNUMBR was different for each record.

Cash was 16384

AR was 32738

FEE was 49152

And that seems to have worked.

Was this reply helpful? Yes No