How can I track electricity & gas separately for same vendor

[isaiahvi]

How do I track gas & electric that is the same Vendor? I"m setting up a new vendor in PCP 11.5. The vendor is Pacific Gas & Electric (PG&E). This vendor provides both gas and electicity and they send us one bill for both. I want to be able to pay the bill with one check, but have the ability to report on gas & electricity separately. What's the best way to do this if it is even possible? I tried to creat two vendors for the same vendor ID and enter Gas for debit in one vendor and Electricity for debit in the other vendor record, but PCP won't allow duplicate vendors. I understand the reason for this error. How can I track electricity and gas separately for the same vendor?

Thank you!

[NeilZ]

How do I track gas & electric that is the same Vendor? I"m setting up a new vendor in PCP 11.5. The vendor is Pacific Gas & Electric (PG&E). This vendor provides both gas and electicity and they send us one bill for both. I want to be able to pay the bill with one check, but have the ability to report on gas & electricity separately. What's the best way to do this if it is even possible? I tried to creat two vendors for the same vendor ID and enter Gas for debit in one vendor and Electricity for debit in the other vendor record, but PCP won't allow duplicate vendors. I understand the reason for this error. How can I track electricity and gas separately for the same vendor?

Thank you!

I would think that you have two separate expense accounts for utilities. You would reference both of these on when entering the Invoice in Accounts Payable.

The transactions on the invoice would look something like this:

01-1110-000 Checking CR 179.00
01-5901-000 Natural Gas DB 97.00
01-5902-000 Electric DB 82.00

Hope this helps.

[isaiahvi]

How do I track gas & electric that is the same Vendor? I"m setting up a new vendor in PCP 11.5. The vendor is Pacific Gas & Electric (PG&E). This vendor provides both gas and electicity and they send us one bill for both. I want to be able to pay the bill with one check, but have the ability to report on gas & electricity separately. What's the best way to do this if it is even possible? I tried to creat two vendors for the same vendor ID and enter Gas for debit in one vendor and Electricity for debit in the other vendor record, but PCP won't allow duplicate vendors. I understand the reason for this error. How can I track electricity and gas separately for the same vendor?

Thank you!

I would think that you have two separate expense accounts for utilities. You would reference both of these on when entering the Invoice in Accounts Payable.

The transactions on the invoice would look something like this:

01-1110-000 Checking CR 179.00
01-5901-000 Natural Gas DB 97.00
01-5902-000 Electric DB 82.00

Hope this helps.

Thanks Neil this is very helpful! What I had done originally was setup PG&E as a new venodor in Accounts > Accounts Payable > Setup > Maintain Vendor Records. In the "Account Information" tab, I setup the Debit/Credit account information so that it automatically fills in that information when I go to "Maintain Open Invoices"....in my case it was for the Electric bill. I do have a different expense account setup (default from PCP 11.5) for both gas and electric, but in the "Account Information" tab it only allows one expense account to be automatically filled in. I hope I'm making sense? Anyway, I can live with that and just enter another line item for gas and adjust the totals to match the total bill...this is easy since the totals for each service (electric/gas) is separated on the bill. Thanks again!

[tborgal]

You could also set this up as a repeating item in Accounts Payable. This way you can enter both debit accounts but when you release it every month you will need to change the amounts.