Help

1

V14 Could someone explain the complete CASH Payment Receipt process from Invoice

Avatar
Rashid Shahid

I noticed in Odoo V14 there are two new accounts in a Cash Journal, Outstanding Receipt and Outstanding Payments. When I click on Register Payment on an Invoice and select my Cash Journal the invoice Status goes to In Payment. I can't figure out what I need to do now to make this invoice in Paid Status. Also what I need to do in order to have the cash received reflect into the Cash Account instead of the Outstanding Receipts Account. Below is a video showing my current procedure.

https://youtu.be/d4OsvD-eA-I

1 Comment
Avatar
Discard
Avatar
Quina
-

I've tried to do the steps describe, but cash flow statement show entries on different categories such as "Cash flows from unclassified activities" instead of Cash flows from operating activities

1 Answer
6
Avatar
Ray Carnes (ray)
Best Answer

At the start of each day, create a Cash Log.  Click NEW TRANSACTIONS:



Enter the STARTING BALANCE for your float, let’s say you start with $1000 to give change:



Create your Invoices and register Payments as you normally would, then at the end of the day, come back to the Journal (you will see how much cash your Customers paid you, in this example, we received $600 in cash payments):


Click NEW TRANSACTIONS again, enter the amount of cash you received during the day as a line item in the Transactions section and enter the ENDING BALANCE, verifying it matches your end float.




Click SAVE and POST and then RECONCILE:

You will see all the recorded payments for the day:


You then click each of them (make sure no Partner is selected after you find the first amount) and can match them to the daily Cash Sales amount:




Note: If your real ending cash balance is over or under the computed balance, you will need to add another line for the amount over/under so you can match it to your over/under account during reconciliation.

11 Comments
Avatar
Discard
Avatar
Rashid Shahid
-

You're the best Ray! Thanks for the detailed answer. This should probably be in the documentation

Avatar
Ray Carnes (ray)
-

Note that as of this week, we are allowing a CASH Journal to bypass the OUTSTANDING accounts (you would use the same GL account for each of (1) the Cash Account; (2) the Outstanding Reciepts; and (3) the Outstanding Payments. Cash transactions will then bypass the IN PAYMENT status and these Journals won't have to be reconciled like I describe above. This configuration supports organizations that have no Cash Report and/or who don't wish to reconcile Cash. We recommend not using the Cash Journal for any other purpose if this is the case. If you use Cash to pay expenses, to advance employees, or anything resembling a cash box [or if you are required to keep a record of cash inflows], you can benefit from creating a second Cash Journal that does use the Outstanding accounts so you can generate and reconcile statements at the time you count the float and/or close your books.

Avatar
Elvis Skora
-

@ Ray Has the logic been changed for Internal Transfers in v14? When doing in v14 a cash or bank internal transfer, it does not appear the field 'Transfer To' Journal like in v13?

Avatar
Ray Carnes (ray)
-
Avatar
Elvis Skora
-

@Ray Thanks a lot for the detailed answer.

Avatar
Ray Carnes (ray)
-

A way to optimize this process would be to use BATCH PAYMENTS. For each DAY create a BATCH, then you only have to reconcile ONE line with your cash intake for the day, not all the individual blue payment lines.

Avatar
Paresh Wagh
-

@Ray: You the man. Thanks for the clear and crisp explanation. It has saved the day for me.

Avatar
Paresh Wagh
-

Hi Ray: Quick follow up question. Is it appropriate to "write-off" the over/under during reconciliation in addition to entering it in the Float?

Avatar
Ray Carnes (ray)
-

The starting balance PLUS the transactions has to equal the ENDING BALANCE (we do this by not allowing the Float / Statement / Day) to post unless the ENDING BALANCE matches the COMPUTED BALANCE. If you have lost or found money during the close, you can write it off to an over/under account during reconcilation but it should not be entered anywhere else - only KNOWN amounts are entered in the Float.

Avatar
Thomas Arbib
-

Hello Ray,

I can't find how to configure the cash journal to bypass the OUTSTANDING accounts. Is it in the payments configuration tab of the journal ? Could you explain please?

Avatar
Ray Carnes (ray)
-

You would use the same GL account for each of (1) the Cash Account; (2) the Outstanding Receipts; and (3) the Outstanding Payments. So on the Journal, set each of these to the same account. Cash transactions will then bypass the IN PAYMENT status and these Journals won't have to be reconciled like I describe above.