Best practices for handling multiple utility accounts in Sage 100 Contractor

How have others handled multiple utility accounts for the same job? What I mean is we have several accounts from the same Electricity provider, same water provider. Is there any easy way to identify them properly and keep them separated? We end up with dozens of vendor accounts for the same company. I've ended up putting the account number into the Vendor name for easy ID purposes.

Then I have to write a separate check for each account. Has anyone found a better way? Thank you.

Kind regards,

-Kevin

  • We have one vendor per utility company and use separate projects and/or prime contracts to track the different accounts. In our case, each project or prime tends to have its own accounts. 
    Then, we add either the address or account number to the bill reference field. Our accounting system is separated by project and prime, but it helps our AP confirm the account. 

    Hope this helps!