cancel
Showing results for 
Search instead for 
Did you mean: 

Automatic Partial Recoupment of Downpayment based on GR/SE Amount

mlotacason
Explorer
0 Kudos
2,971

Good day!


Can i ask how do you treat or record your DP recoupment in your books. As of our current practice, it is during invoice processing and due to duration of the project the down payment will be be fully recouped on the last invoice/progress billing. As down payment transactions are part of or budget utilization report it causes negative utilization on the year the invoice was processed which is usually a year after the service or goods were rendered or delivered.

If we record the recoupment at the time the services/goods are rendered /delivered by debit Accounts Payable and credit Project Prepayment, this will result to positive or abnormal balance in the Accounts Payable account and will be subject for financial audit.

The solution i am thinking is the possibility if partial recoupment at the time of goods receipt or service entry if this can be done by the system automatically. The DP clearing entries from this partial recoupment will be captured in the budget utilization/FM (as our policy is to recoup based on percentage of services/goods delivered or rendered) and this will be disregarded in the financial accounting/FI (thru a reversal entry and recouped for financial accounting purposes will be recorded at the time of invoice processing).

Any thoughts on this or best practices you can share?


Thanks a lot.

Accepted Solutions (0)

Answers (1)

Answers (1)

iklovski
Active Contributor
0 Kudos

Hi,

I don't fully understand your doubt (maybe, with a concrete example it would be better), but I suggest you consulting this OSS note (and its affiliated ones) for the process of DP clearing and the budgetary impact:

1838093 - Down Payment Request and Down Payment Clearings in FM

Regards,
Eli

mlotacason
Explorer
0 Kudos

Hi Eli,

The system currently recoups the whole amount of down payment during GR but what we'd like to do, is to make dp recoupment proportionate with the amount of GR.

EX.

PO Amount: 1000

Down payment: 10

Partial Goods Receipts (50%): 500

DP Recoupment in the system (100%): -10

____________________________________________

is there a way to program the recoupment to be proportionate with the % GR:

Partial Goods Receipts (50%): 500

Partial DP Recoupment in Proportion to GR (50%): -5

Thank you.

Lui