cancel
Showing results for 
Search instead for 
Did you mean: 
rode1
Level 1

Have a customer that is also a vendor, The customer pays my invoice but deducts the amount for their vendor bill, How should this transaction be entered / accounted for?

Thank you for your answer, but what type of account is your "prepaid"? Other current asset?

SuzySan
Level 1

Have a customer that is also a vendor, The customer pays my invoice but deducts the amount for their vendor bill, How should this transaction be entered / accounted for?

Thank you very much.

This worked and was easy to execute

 

CBM1
Level 1

Have a customer that is also a vendor, The customer pays my invoice but deducts the amount for their vendor bill, How should this transaction be entered / accounted for?

Is the prepaid account and income account or expense account?

Dakota Hardscape Supply
Level 2

Have a customer that is also a vendor, The customer pays my invoice but deducts the amount for their vendor bill, How should this transaction be entered / accounted for?

this does not work 

Ryan_M
Moderator

Have a customer that is also a vendor, The customer pays my invoice but deducts the amount for their vendor bill, How should this transaction be entered / accounted for?

Hi @Dakota Hardscape Supply,

 

I'll share insight on your concern about recording transactions for your vendor, who's also your customer. 

 

You can follow the steps provided by @qbteachmt above. You use a clearing account to record the transactions. 

 

You'll need to create the clearing account first. Here's how:

 

  1. Highlight the Accounting tab.
  2. Select Chart of Accounts.
  3. Click New.
  4. Set the Account Type to Bank, then the Detail Type to Cash on hand.
  5. Enter an account name.
  6. Press Save and Close.

Check out this article for more details: Record a barter transaction. Scroll down to Step 2: Create an invoice and receive payment to continue this process. 

 

Post a reply below if you have other concerns with your QuickBooks Online company. I'll be sure to take care of it. 

Anonymous
Not applicable

Have a customer that is also a vendor, The customer pays my invoice but deducts the amount for their vendor bill, How should this transaction be entered / accounted for?

To make this answer clearer and more useful to non-accounting experts (i.e. people who run their own small businesses and enter transactions into their QuickBooks on their own), could you please provide the following:

  1. What is a "JE"? I'm assuming you mean "Journal Entry"? But many non-experts won't get that.
  2. " I have an account called Pre-paid": OK, what kind of account is it? Expense? Income? Accounts Receivable? Something else? A non-expert won't be able to follow your instructions without that detail.
  3. In your example, you don't state the amounts for each credit and debit, so it's not clear which step should contain the amount of the invoice to the customer/vendor, and which should contain the amount of the bill from the customer/vendor. The original poster used an example of an invoice of $500 to the customer/vendor, and a bill from the customer/vendor in the amount of $200. Could you plug those amounts into your example to make it more clear?

 

The community appreciates your help. By taking a little extra time to add detail and refrain from using acronyms, more people can benefit!

Anonymous
Not applicable

Have a customer that is also a vendor, The customer pays my invoice but deducts the amount for their vendor bill, How should this transaction be entered / accounted for?

To make this answer clearer and more useful to non-accounting experts (i.e. people who run their own small businesses and enter transactions into their QuickBooks on their own), could you please provide the following:

  1. What is a "JE"? I'm assuming you mean "Journal Entry"? But many non-experts won't get that.
  2. " I have an account called Pre-paid": OK, what kind of account is it? Expense? Income? Accounts Receivable? Something else? A non-expert won't be able to follow your instructions without that detail.
  3. In your example, you don't state the amounts for each credit and debit, so it's not clear which step should contain the amount of the invoice to the customer/vendor, and which should contain the amount of the bill from the customer/vendor. The original poster used an example of an invoice of $500 to the customer/vendor, and a bill from the customer/vendor in the amount of $200. Could you plug those amounts into your example to make it more clear?

 

The community appreciates your help. By taking a little extra time to add detail and refrain from using acronyms, more people can benefit!

MirriamM
Moderator

Have a customer that is also a vendor, The customer pays my invoice but deducts the amount for their vendor bill, How should this transaction be entered / accounted for?

Thanks for joining the thread, ChaosFreak and providing detailed information about your concern.

 

I'm here to answer your query.

 

To start, you're right that JE is a Journal entry. You can use this transaction as a last resort when entering a transaction. For more details about this, see this article: Create a journal entry in QuickBooks Online.

 

Then, as for your Prepaid account question. I'd like to verify if how do you set it up? Is it a Prepaid expense or Prepaid income?

 

prepaid expense is a purchase you make for goods or services you will receive in the future or over a specified period. You initially recorded this as an asset as they have future economic benefits and are expense at the time realized. On the other hand, the prepaid income is used as a customer prepayment before the invoice has been created for the sale of inventory items.

 

As for your last question, since every business structure is unique, I suggest reaching out to your accountant for additional guidance. They can ensure the correct account and amount is used to debit and credit the transaction.

 

Get back to me here if you have any other concern in managing your QuickBooks account. I'm always here to help. Take care always.

smomin
Level 2

Have a customer that is also a vendor, The customer pays my invoice but deducts the amount for their vendor bill, How should this transaction be entered / accounted for?

Hi MirriamM

Ok so I tried this and instead of deducting the amount of the billable expense from the customer invoice, it added that amount.

This is what I'm trying to do.  I have the same customer and vendor.  Let's call them ABC-C for Customer and ABC-V for vendor.

I invoiced ABC-C $1500 for Herbal tea.  They sent me a check for $1000.  They have $500 amount of expenses that they charged us in our invoice.  Lets the $500 they charged us was for $200 promotion discount and $300 for running ads for us for the Herbal Tea.  So I made a vender bill for ABC-V for $500, marked each expense as billable expense, then added ABC-C under Customer.

I went back to the invoice for ABC-C.  I added the Billable expenses.  Instead of deducting the invoice by $500, it increased it by $500.

Now if I added a (-) to the billable expense in the customer invoice it will deduct that amount and make the invoice "seem" correct.  But I don't know what will happen to the Vendor bill.  

Sorry, I am new to all this accounting stuff.  Any help would be appreciated.

 

Note:  I will we could just add expenses directly to the invoices.  That would be much easier.

 

Thank you

 

JamaicaA
QuickBooks Team

Have a customer that is also a vendor, The customer pays my invoice but deducts the amount for their vendor bill, How should this transaction be entered / accounted for?

You’re almost there, @smomin. I’ll lay down some information to help you zero out the invoice as well as the vendor bill.

I appreciate the things you’ve done so far. What you did to your invoice is correct. You can also create Vendor credit with the amount of 500 and apply it as payment to the vendor bill. This way, we can zero out the bill too.

 

Here’s how:

 

  1. Click + New and select Vendor credit.
  2. Select your vendor in the Vendor dropdown.
  3. Enter the necessary information.
  4. Select Save and close.

 

After that, we can apply the vendor credit to any open or future bill. I’ll show you how:

 

  1. Click + New.
  2. Select Pay bills.
  3. Select a bill for your vendor from the list. You'll see the available credit with this vendor in the Credit Applied field.
  4. Tap Save and send.


I highly recommend seeking help from your accountant if you want to know more tips on how to better record them. This way, we can make sure your books are accurate.

 

Once done, you can then proceed to reconciling your account in QuickBooks Online. It contains all the steps and guides to ensure your bank statements matched with QuickBooks.


Kindly leave a reply below if you need further assistance managing your invoices or vendor. I’d be glad to help you. Keep safe!

smomin
Level 2

Have a customer that is also a vendor, The customer pays my invoice but deducts the amount for their vendor bill, How should this transaction be entered / accounted for?

Thank you JamaicaA for your response.

You mentioned that what I did with the invoice was correct.  Do you mean changing the billable amount to a negative amount was correct?  I have attached the screenshots of what I did.

Also, how do I do the vendor credit?  And would that incorrectly affect my P&L reports?

Thank you, I appreciate your time. 

 

TirzahC
QuickBooks Team

Have a customer that is also a vendor, The customer pays my invoice but deducts the amount for their vendor bill, How should this transaction be entered / accounted for?

Thanks for getting back, smomin.

 

Changing your account preferences or unchecking the option to mark all expenses as billable won't affect or change the previous items/transactions created. The changes only affect on the transaction/s created after unchecking the Mark all expenses as billable box. However, marking expenses as billable also depends if the Billable column is manually checked/unchecked.

 

In, creating a vendor credit to make sure the credits hit the expense account you use for this vendor. In addition, to track credits for your vendors, you should consider entering bills in QuickBooks. This way you can track your account balance and credits using Accounts Payable. Otherwise, you can enter a note to remind yourself about this credit in the future.

 

Also,  P&L report displays your income and expenses. Income is the amount your business takes in while expenses are what it spends money on. If you want to see the snapshot of your business's accounts receivable, liabilities, and owner's equity or capital, you can open the Balance Sheet report.

 

If the amount is not reflected on your report accordingly, you can try to review the transaction created. Let's make sure that the correct account is used.

 

You might also want to read this article to learn how inventory tracking impacts your Profit and Loss report: Impacts of inventory tracking on balance sheet and profit & loss reports.

 

Additional details about managing vendor refunds or credits are discussed in these following articles:

Please don't hesitate to reach out to us again if you have other questions in mind. We're always here to help you out again.

isee
Level 1

Have a customer that is also a vendor, The customer pays my invoice but deducts the amount for their vendor bill, How should this transaction be entered / accounted for?

I hope as old as this thread is you can still help me.

I get a payment from a customer/vendor less a bill I own them.

I got stuck in your instructions where the clearing acct/prepaid is suppose to zero, in and out... 

Could you use number examplers:

I got paid say 9300 I owe 300 so they sent a check for 9000, I have bill for 300 and  invoice of 9000.

JaeAnnC
QuickBooks Team

Have a customer that is also a vendor, The customer pays my invoice but deducts the amount for their vendor bill, How should this transaction be entered / accounted for?

I appreciate you for following the thread, @isee.
 

Getting your issue resolved is our main concern. But I need more details about it.
 

May I know if you are using QuickBooks Desktop or QuickBooks Online? This way, I can determine and provide you with the best resolution.
 

I'd appreciate any additional details you can give. I'm looking forward to your reply. Have a nice day!

isee
Level 1

Have a customer that is also a vendor, The customer pays my invoice but deducts the amount for their vendor bill, How should this transaction be entered / accounted for?

Good day 

QB desktop Premier Plus is what I am using.

ISEE

GlinetteC
Moderator

Have a customer that is also a vendor, The customer pays my invoice but deducts the amount for their vendor bill, How should this transaction be entered / accounted for?

I've got another way to handle your payment , isee.

 

You can create a Barter account to record the barter transactions in QuickBooks Desktop. I'll show you the process.

 

First, set up the Barter Bank account. Here's how:

 

  1. Go to Accountant > Chart of Accounts.
  2. Click the Account drop-down and select New.
  3. Select Bank and click Continue.
  4. Enter the Account Name as Barter Account.
  5. Enter Opening Balance ($ 9,300).
  6. Click Save and Close.

 

Second, create an invoice and record the invoice payment

 

To create an invoice:

 

  1. From the Customers menu, select Create Invoices.
  2. Select the customer.
  3. Enter the required fields.
  4. Click Save and Close.

 

To record invoice payment:

 

  1. From the Customers menu, select Receive Payment.
  2. In the Received From the drop-down menu, select the customer's name.
  3. Enter the Amount received which is $9,000.
  4. Make sure the date is correct, then Add a new Payment Method by selecting the More drop-down.
  5. Enter Barter and click OK.
  6. Select Undeposited Funds from the Deposit TO drop-down.
  7. Click Save and Close.

SS1.PNG

Next, enter and pay the $ 300 bill you owe. 
SS2.PNG

 

Once done, create a Check using the Barter Account. Here are the steps:

 

  1. Go to Banking and select Write Checks.
  2. Ensure to choose the Barter Account.
  3. Enter the $9, 000 amount.
  4. Click Save and Close.
    ss3.PNG

With these instructions, you should be able to zero out the Barter account in no time!
ss4.PNG

 

If you need help reconciling the account to ensure the amount is balanced, you can check this link for detailed instructions on how: Reconcile an account in QuickBooks Desktop.

 

If you have additional questions about the process, feel free to add a reply below. I'll be sure to get back to you.

Bschanel2019
Level 1

Have a customer that is also a vendor, The customer pays my invoice but deducts the amount for their vendor bill, How should this transaction be entered / accounted for?

how did you zero out the invoice.

Rubielyn_J
QuickBooks Team

Have a customer that is also a vendor, The customer pays my invoice but deducts the amount for their vendor bill, How should this transaction be entered / accounted for?

I'm here to assist you with your question about zeroing out an invoice in QuickBooks, @Bschanel2019.

 

There are different ways to zero out your invoices in QuickBooks Online, and the method you choose will depend on the specific scenario you have.

 

Are you expecting a payment from your customers? If yes, then we can simply utilize the receive payment feature to zero out the invoice. Let me show you how: 

 

  1. Click + New and choose Receive payment.
  2. From the Customer dropdown, select the name of the customer.
  3. From the Payment method dropdown, choose the payment method (credit card, debit, PayPal, Venmo, or ACH bank transfer).
  4. From the Deposit to dropdown, select the account you put the payment into.  
  5. In the Outstanding Transactions section, choose the checkbox for the invoice you're recording the payment for.
  6. Enter the Reference no. and Memo if needed.
  7. Click Save and close.

 

If your customer owes you money but you can't collect it, you need to record them as a bad debt and write them off. This ensures your accounts receivable and net income stay up-to-date. For detailed steps, you can utilize this link: Write off bad debt in QuickBooks Online.

 

Additionally, I'll be sharing the following articles to help you personalize and handle invoices in QBO. These articles include steps to make the invoicing process smoother and more efficient for you.

 

 

If you have any further questions or encounter any challenges while implementing the steps we discussed, please don't hesitate to reach out to me again. I'm here to provide ongoing support and ensure that you can successfully manage your invoices and accounting tasks in QuickBooks.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us