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.

Hi Alma. Basically, you would create a positive AP invoice for the refund and assign it to the cash account you will be depositing the check to. Do not post a separate transaction in 1-1 or 1-3 for the check as this will be taken care when the invoice is posted. Full instructions are in this Knowledgebase article.

Thanks for your help

Thanks so much 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