Microsoft Dynamics GP (Archived)

Non-AR Cash Receipts

(0) Share

Report

Posted on by Steven London

185

Does anyone have a good method for entering cash receipts that are not Sales/AR related and not from customers?

An example of this would be a refund from an insurance company for an overpayment of premium?

I have been advised by GP support to enter a general journal entry for these, but I want to enter it through a sub-ledger.

*This post is locked for comments

All responses (7)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

Re: Re: Re: Re: Re: Re: Re: Non-AR Cash Receipts

Roger that, Mark.
mpolino on at

Like (0)

Report

Re: Re: Re: Re: Re: Re: Non-AR Cash Receipts

Nice job Ian! You beat me to the answer and saved me some time that I need for other things!

Mark
Community Member Microsoft Employee on at

Like (0)

Report

Re: Re: Re: Re: Re: Non-AR Cash Receipts

Hi Steve,

You probably need to deposit the Receipt.

To do this, go to Transactions >> Financial >> Bank Deposits....select your Chequebook and any receipts waiting to be deposited will be listed in the scrolling window at the bottom. 'Tick' the receipt you just posted, verify information such as deposit date is correct, and click on Post. The receipt should now show up in your register / reports.

In your case, since you are not using Bank Rec, deposit each receipt individually so that each receipt is listed seperately in your reports (you could group a number of receipts together into one deposit in GP...as you might deposit a number of cheques together in your bank...and the total figure would appear on your bank statement...in this way you can reconcile directly to your bank statement...and not have to add up a number of GP transactions to get a match to your bank statement....since you don't use GP Bank Rec...its not an issue).

Hope the above helps.

Best regards, Ian.
Steven London 185 on at

Like (0)

Report

Re: Re: Re: Re: Non-AR Cash Receipts

Ian:

Thanks again, but the transaction is not showing up on the Checkbook Register. Any ideas?

Steve
Community Member Microsoft Employee on at

Like (0)

Report
Re: Re: Re: Non-AR Cash Receipts

Hi Steven,

Yes, you have a number of options.

Reports >> Financial >> Chequebook >> Chequebook Register....and you can filter this report by type.

Create a smartlist ... Smartlist >> Financial >> Bank Transactions...and filter as you need by transaction type etc.

Enquiry >> Financial >> Chequebook Register ..call up the Chequebook ID you want, and click on the Print Icon at the top of the window (really, this is the same as option 1 above, but your options to filter are limited to reconciled / un reconciled....date...and transaction number).

There are other reports, but these will give you what you want.

Best regards,
Steven London 185 on at

Like (0)

Report

Re: Re: Non-AR Cash Receipts

Thanks Ian.

We are not using the bank rec module. If I begin entering my Non-AR cash reciepts this way, will I be able to run a report on them?
Community Member Microsoft Employee on at

Like (0)

Report

Re: Non-AR Cash Receipts

Not sure if a General Journal is the approach they meant....are you sure they said this?

The proper way is to enter a Bank Tranasaction...Transactions >> Financial >> Bank Transaction.

In the Option field, select Receipt.

Enter the date, Chequebook ID, and a Receipt Number (Eithre from a lodgement book, or the transaction number from your bank statement). Then enter the Recevied from, description, and amount fields.

In the scrolling window at the bottom, distribute this receipt transaction in your GL. The Debit will default to the GL account associated with your Chequebook ID....and you choose the Credit.

Using this method, you get a valid transaction in your bank module that you can reconcile if you use bank reconciliation.

Hope this helps.