cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Super Explorer ***

Payments

Hello,

Example:

I sold shoes to a customer and invoiced him $100. I used his plumbing services and he invoiced me for $200 but he told me to just payed the balance of $100 ,which I did with a check. But instead of me giving him the other $100 I gave him the shoes worth $100. 

How do I entered all this information in quickbooks and my bank statements. To record my sales and my expenses/repairs.

 

My invoice to him is still open in QB for the shoes of $100 that needs to be payed (to record my sales etc.) and in my bank statement theres is the check of $100 that I made out to him for the balance.

I hope I made sence, it's a bit complicated.

 

Pleas advice.

Thanks for all the help

3 Comments
QuickBooks Team

Re: Payments

Thanks for visiting us today, @Eve2019,

 

I appreciate the in-depth details you shared on your post. Let's make sure you're able to record your transactions correctly in QuickBooks Desktop.

 

We can enter a barter transaction in QuickBooks to record the exchange between you and the supplier. Let me guide you on how to do that:

 

Step 1: Create a Barter bank account.

  1. Go to the Lists menu.
  2. Select Chart of Accounts.
  3. Right-click anywhere then click New.
  4. Choose Bank then Continue.
  5. Enter the Account Name. (Example: Cash on Hand).
  6. Click Save and Close.

Before you enter the transactions, make sure to add the partner to your vendor and customer list. Please note that QuickBooks does not allow adding identical names, please make sure to alter the characters if necessary.

 

Step 2: Create and receive payment for the invoice for the barter transaction

  1. Click the Customers menu.
  2. Hit Create Invoices.
  3. Enter the customer name in the Customer: Job field.
  4. Fill the Date and Amount.
  5. Click the Receive Payments icon at the top of the invoice.
  6. Press Yes on the prompt.
  7. In the Customer Payment window, click More.
  8. Choose Add New Payment Method.
  9. Type Barter in the Payment Method field. Select Cash as the Payment Type.
  10. Click OK.
  11. In the Deposit To field, enter the barter bank account (Cash on Hand). Note: If you don't have this option, it's possible that the Undeposited Funds is your default deposit account. To check that, go to Edit>Preferences>Payments>Company Preferences. Once done, uncheck the Use Undeposited Funds as a default deposit to account box.
  12. Hit Save & Close.

Step 3: Enter and pay the bill for the barter transaction and the bank.

  1. Click the Vendors tab.
  2. Pick Create Bills.
  3. Enter the supplier's name in the Vendor field.
  4. On the Amount field, enter $200.00.
  5. Click the Pay Bill icon.
  6. Hit Yes on the prompt.
  7. On the Account field, select the barter account (Cash On Hand).
  8. On the Amt. To Pay column, enter the amount paid for the invoice of $100 to relieve the balance (sale) on the barter account.
  9. Press the Pay Selected Bills button then hit Pay More Bills.
  10. Mark the same vendor, the amount should show the remaining balance of $100.
    bill3.PNG
  11. This time, select which bank this payment is cleared in the Account field.
  12. Click Pay Selected Bills.

That should do it. I'm confident those steps will get you pointed to the right direction, @Eve2019. Please let me know how this goes. I'm here if you need further help. Wishing you a great and productive day!

Super Explorer ***

Re: Payments

Hi JenD,

 

I followed your steps. My last question is how should the invoice I created for this person show on my end letting me know its been paid. Because when I checked Customer invoice I still see the $200 open balance.

 

QuickBooks Team

Re: Payments

Hi there, @Eve2019.


I appreciate you following the steps shared by my colleague to record the transaction correctly in QuickBooks. Allow me to step in for a moment and help with the open invoice.


Step 2 provided above should fix the open transaction and mark it as paid. If this is not the case, make sure you don’t have an existing invoice when performing the solution.


After creating a Barter account, you’re advised to make an invoice and receive payment against it. If you already have one and enter another instead of applying the payment directly, the customer profile will show an open balance.


You can remove the $200 by deleting the previous invoice. The instructions given by @Jen_D should take care of recording this entry in QuickBooks. 


Here’s how to delete the transaction:

  1. Go to Customers menu and select Customer Center.
  2. Select the customer name.
  3. Choose the Transactions tab and select Invoices from the Show drop-down.
  4. Locate the invoice and open it.
  5. Click Delete at the top of the Create Invoice screen.
  6. Hit OK on the pop-up to delete the transaction.

 

 

 

Refer to this article for more information: Delete transactions by batch using Batch Delete/Void Transactions.


This should get you on the right track. 


Leave a comment below and let me know if this corrects the issue. I’m always here to assist you. Have a good one!