One solution i have...  You can received the deposit in cash management to a cash clearing account.  Then you can enter a credit invoice in accounts payable for the deposit amount and credit same clearning account to wash. Then when you pay your water bill include the full bill and this credit invoice.. hope this works.

One solution i have...  You can received the deposit in cash management to a cash clearing account.  Then you can enter a credit invoice in accounts payable for the deposit amount and credit same clearning account to wash. Then when you pay your water bill include the full bill and this credit invoice.. hope this works.

Thanks for your help

Not sure if its different in Sage100 but for Sage300CRE I have to create two separate transactions for a couple of reason:

1. the deposit transaction in CM module - need this item for my month-end bank reconciliation

2. and the credit invoice to pay against it in A/P