Bank Reconciliation and Cash Receipts

(0) Share

Report

Posted on by Bill Campbell

We encountered a situation yesterday when the AR clerk was preparing the Bank Deposit slip for Feb 28 (retro active data entry)

She records transactions in Cash Receipt entry and assigns the transactions to the selected Bank Account ( Checkbook ) completes the entry and applies to the invoice (s) as needed. NO problems with this.

Where we find the challenge is when it comes to creating the Deposit Slip in Financial >> Bank Deposits

Yesterday she was able to find all transactions on the slip but 4. When she looked into the Bank Reconciliation screen the 4 separate cash receipts were showing there as recorded already.

The question is 'how do the individual transactions end up in the Reconcile window when they were not included in a deposit transaction?'

Question
Is there a way to determine how / who / when a transaction got to the Bank Reconciliation window?

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

soma 24,410 on at

Like (0)

Report

What is GP version? Is automatic deposit enabled?

Was this reply helpful? Yes No
Bill Campbell 12 on at

Like (0)

Report

GP2015 with the last SP for US and Canadian Payroll - not sure of the number at this time.

How / Where do you set Automatic Deposit?

I am not sure of this feature.

Was this reply helpful? Yes No
MattPaulen 6,912 on at

Like (1)

Report

Hi Bill,

The option is under Tools >> Setup >> Company >> Company >> Options. It's called "Automatically post cash receipt deposits".

See here for a more detailed explanation of how it works: community.dynamics.com/.../microsoft-dynamics-gp-2015-r2-new-features-auto-deposit-cash-receipts-in-bank-rec

Was this reply helpful? Yes No
Bill Campbell 12 on at

Like (0)

Report

Ok, so I get that when I mark this option it is going to post directly to the Bank Reconciliation window and the user will not have to go to the Bank Deposit window and build the 'deposit slip' to match what went into the bank on a given transaction.

I think I can see the advantage of this for some clients, however, this one in particular wants to select the transactions for the deposit slip for the day - " it is easier to reconcile if the deposits are all the same "

Now my question is -

How is it possible to get a deposit transaction to the Bank Reconciliation screen without doing a Bank Deposit step - and without having the Auto Deposit selected?

This is the big issue I am trying to address. Right now there were about 40 transactions that ended up in the Bank Reconciliation screen as single transactions - not grouped together - showing single line values. The user says nothing was done differently.

Wondering if posting Cash Receipts without a batch has any impact on this process? Does the system then just force the transaction to the Bank Reconciliation screen?

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

Bill,

If you zoom back on these transactions in the check register, what transaction does it take you to?

Kind regards,

Leslie

Was this reply helpful? Yes No
Suggested answer

Bill Campbell 12 on at

Like (0)

Report

In solving another matter related to the Saving Cheques in the Cash Receipts system I learned that there were a number of modules installed by the IT manager that are not 'core' and we are not using or configuring at this client.

Then challenge is that once a module is installed, part - but not all - of the features of that module start to work with the system.

In our case it was the Payment Document Management ( 2150 ) module that was causing the problem. I don't know the module and I am not sure of all that it does, but since we do not have it configured completely it is interfering with the processing of the Deposits.

What is happening is that the cheque type transactions from Cash Receipt are getting intercepted and because of one thing or another they are finding their way to the Reconciliation window.

As soon as the module is removed from the Dynamics Set and the user re-logs back to GP - the process works as expected and as we designed with this client.

Was this reply helpful? Yes No