Best way to balance vendor accounts when job costing is attached
Have multiple vendor accounts that have job costing attached but have erroneous balances due. I could go vendor by vendor (over 350) to repost payments. Journal entries invalidate the job costing. Is there a better way?
The most common cause of an incorrect vendor balance is a transaction error. Let's first run the Vendor Balance Detail report to identify the cause of the incorrect vendor balance.
To create the Vendor Balance Detail report, here's how:
Go to the Vendors menu.
Choose the Vendor Center.
From the Vendors list, select the vendor.
Go to the Transactions tab on the right.
Select the Show drop-down.
Choose Balance Details.
Use the Filter by and Date drop-down arrows to narrow the transaction list further.
Review the transactions.
If the balance is too high, you may have entered a bill and created a check to pay for it instead of going through the Pay Bills window. You can refer to this article for more detailed steps: Bill shows as unpaid after writing a cheque.
If the balance is too low, you may have entered the wrong amount in a transaction. Find the bill or bill payment in the Vendor Balance Detail report then edit it.
Also, I'd recommend consulting with your accountant so you'll be guided accurately on the adjustments that you'll make.
Keep me posted if you have other questions. I'm always here to help.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
We have to collect some data when you use this website so it works and is secure. We'd also like your consent to collect data to study how people use our site. Doing so helps us improve our services and allows us to tailor the marketing you see on our site. Select 'Accept cookies' to agree or 'Cookie settings' to choose which cookies we use. You can change your mind at any time by clicking the 'Manage Cookies' link.
Choose your cookie preferences
Some cookies are needed to make our website work and can't be turned off. But we need your consent to use others that are not essential. You can make your choices below and update them at any time using the 'Manage Cookies' link. To find out more, visit our Cookies Policy.
These cookies are necessary for the site to function. They also help us keep your data safe.
These cookies allow us to enhance your experience and remember your preferences, region or country, language, and accessibility options.
These cookies tell us how customers use our website. We study and organize this data to help us optimise our content and provide you with personalised experiences.
These cookies help us provide you with relevant communications and ads in our products and on other sites.