


Wishing you the best with working this out! There are some feature differences between the US and Canadian version of the program, so making sure you have insight from those using the same version as you is key. If you're using the US version of the software, I recommend re-posting your question there. With that in mind, I'd just like to note that I see you've mentioned New York State and it looks like other active threads you've been on are in the US QuickBooks Community as well. You may also receive some feedback from accountant users here in the QuickBooks Community. You can also filter for your specific version of the program to make sure you're connecting with the right person. Using the Find an Accountant link, you can browser our list of QuickBooks-certified accountants near you. An accountant familiar with QuickBooks would be an even bigger asset as they may have some ideas for workarounds within the software. An accountant would have the know-how to give you the best direction for managing these transactions in your books. This is true not only because of how the credits apply but also because of how you receive them. I'll point you in the right direction.įor this kind of setup, an accountant's touch would be a great asset. Since you already know that you can't apply a vendor credits to different vendors, it sounds like you're familiar with how the program works overall. I can absolutely see how this would be a complicated scenario to handle in QuickBooks Desktop. I appreciate that you've taken the time to go over your situation in so much detail. (one idea we have had is to create a separate Customer for each account - so a single vendor with 4 separate customers, so you could run a report that totals the vendor bills for a specific customer.)
DIFFERENT BILLS TO PAY HOW TO
Trying to create a three separate vendor credits for the amount for each account x 2 solar accounts is also problematic and difficult to track.Īny suggestions on how to structure this? You can imagine having a single vendor reflect 4 different account balances would be a nightmare. I will also add to the confusion - We don't know the amount of the solar credits unit the MONTH AFTER the bill is paid - which means we are usually Overpay the bill, and this shows up as a credit on the following month. If we make a SINGLE vendor for Con Ed - how the heck can we track the account balances for each account? (Can't have more than one A/R - A/P line in a transaction). If we keep each account as a separate vendor, we can't cross-apply a credit to multiple vendors. The same for unit 4 which also has solar. So if unit 2 earned $100 in solar power, and the bill for unit 2 was only $25, then $75 is applied first to account 1 and then the balance to Account 3. HOWEVER - the Solar panels earn Credits which are applied to ALL 4 Accounts. To make things "easy" in QB, we were setting up each account as separate vendor - bills are entered and paid - balances are easy to see. Con Ed thinks of each account as it's own independent account. There are 4 Electric accounts, 2 of the accounts have solar panels.Īll of the accounts are with Con Edison (New York state).Įach of the accounts is billed and paid separately.
