Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
First time posting a discussion question... I'll preface this by saying we are a small motor carrier and learning as we go.
Our motor carrier operations were established during the pandemic and shutdowns, so our fuel card vendor was not granting credit accounts during that time. We opened a secured account with a $1500 secured credit line and only had one semi over the road. It never occurred to me to set this vendor up with a negative open balance because we only ran one truck and and everything was expensed to that one truck. We also didn't anticipate expanding our motor carrier operations so soon.
Now we have three semis over the road - beginning 10/27/21 - and I track fuel by class (each semi). In addition, our vendor converted our secured account to a credit account - 10/27/21 - and rather than refunding the $1500, I opted for the vendor to retain those funds and apply it toward future balances. We pay our fuel bill weekly and this $1500 is applied toward the weekly balance. We just pay the remaining balance due.
Here's an example:
$3894.56 (10/28/21 - 11/3/21 total fuel invoiced)
-$1500.00 (security deposit applied)
-------------
$2394.56 (Balance Due from gwtruck)
Since the Vendor is already is already Active, the Opening Balance and as of fields are not available (greyed out) to edit. What is the best alternative method to record this?
Welcome to the Community, gwtruck. I appreciate your screenshot.
A vendor's opening balance will be grayed out if you've already created a bill on their account prior to entering it.
I'd recommend checking the vendor's transaction list to verify.
Here's how:
I've also included a detailed resource about entering supplier credits which may come in handy moving forward: Enter a vendor credit
If there's any additional questions, I'm just a post away. Have a great day!
Thank you for the response but I have already audited all the bills and payments for this vendor.
When we initially paid the $1500 for the secured line of credit, it was entered as an Expense because before 10/26/21, I just entered everything as one Expense and/or Bill and expensed everything to one truck. There was no need to enter account for the security deposit of $1500.
Now that we have a credit account and multiple classes, I need to be able to account for the $1500 credit that will remain on my AR account with them going forward.
How do I account for that now that I've had activity with them for almost a year?
Hello again, @gwtruck.
Thanks for letting us know that you’ve already audited the bills and payments for this vendor. This information will guide us on how to resolve your concern about entering the opening balance (vendor).
Let’s create a vendor credit and use the opening balance equity for the category. This makes sure the credit hits the expense account you use for this vendor. I’ll help and show you how to track this one in QuickBooks Online (QBO).
After adding the transaction, you can use this one toward any open or future bill. For more insights into this process, you can browse this article: Enter a credit from a vendor. It provides detailed information on how to track your account balance and credits using Accounts Payable.
Also, this link outlines the steps on how to manage your vendor or customer balances. From there, you’ll learn about the accounts affected for each accounting process.
Keep me posted below if you have clarifications about recording your vendor’s opening balance. I’ll be right here to help and make sure this is taken care of for you.
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.
For more information visit our Security Center or to report suspicious websites you can contact us here