We are involved in the Building Industry where projects have retention - 2.5% of project value withheld from payment for 12 months after the project is completed.
I would like to move these retention amounts out of AR and into another AR type account called Retention. This is so that it doesn't show as an outstanding as it's not due receivable. Also to be able to know the value of Retentions as a whole.
Started to try this by creating an item called Retention which'll hit the Retention account but I'm not able to create an item to hit a non PL GL account. And in Sales Invoices, I can't seem to hit a specific GL account like with Purchase Bills.
I used to be able to do something in MYOB but can't seem to recreate in Reckon.
How I process to get a net result that is:
* CR AR
DB Retention - (AR type account)
And then the reverse after 12 months?