Categories
Bank Deposit Banking Deposit Pay Bills Vendor Credit

How to handle refund on a debit card from a vendor to the project

How to handle refund on a debit card from a vendor? It’s downloaded as a bank deposit in bank feed. How can I assign that credit to the project?

It involves few steps process to handle vendor refund on a debit card to the project in QBO.

1) Create Vendor Credit (Plus sign at the top right > Vendors > Vendor Credit)
a. Select Vendor payee
b. Select same expense account used to enter original transaction
c. Enter amount
d. Select Customer/Project
e. Save
 

VENDOR CREDIT FORM
VENDOR CREDIT FORM

 
2) Go to Banking (Left Dashboard > Banking)
a. Under “For Review” tab, locate refund deposit on a debit card from a vendor
b. Click the transaction row
c. Switch radio button from “Add” to “Find Match”
d. Under “Resolve difference” drop-down arrow, select “Add new transactions”
e. Under add transactions tab, enter vendor refund credit
Payee = Vendor payee (gave you refund)
Category = Accounts Payable (A/P) account
Amount = Refund amount
f. Save
 
ADD NEW TRANSACTIONS BOX
ADD NEW TRANSACTIONS BOX

 
ENTER DEPOSIT REFUND AS A NEW TRANSACTION
ENTER DEPOSIT REFUND AS A NEW TRANSACTION

 
NOTE: If QuickBooks is not connected with the bank account (Plus sign at the top right > Others > Bank deposit). It will take to the same deposit screen.
 
3) Go to Pay Bills to clear both credit and deposit from vendor’s A/P account (Plus sign at the top right > Vendors > Pay Bills)
a. Select Vendor line check box to clear the account. It should be zero amount
b. Save
 
PAY BILLS FORM
PAY BILLS FORM

 
That should do it.
 
For step by step video tutorials, check out our YouTube video. If you like this video don’t forget to like and subscribe!

 

Categories
Bank Deposit Bank Register Banking Customers

How do I match a new Invoice to a payment that’s already been deposited to a bank account

This article will show how to link a deposit from a customer to an Invoice. Let’s assume the customer payment was entered first through Bank Deposit (this may be from bank feed or entered manually) instead of Receive Payment form and then you’ve created an invoice later, you can follow the steps below to link the deposit to the invoice.

First, you will need to find the deposit you’ve originally entered in QuickBooks. To do that, follow the steps below:

  • Choose Accounting on the left > Chart of Accounts at the top.
  • In the Action column, select View register.
  • Locate the correct deposit and click anywhere on it.
  • Click Edit.
  • You will see screenshot something similar to this one below.

 

Now, edit the deposit. To do that, follow the steps below:

  • In the Received From column, select the drop-down arrow in row 1.
  • Choose the correct Customer’s name.
  • In the Account column, select the drop-down arrow in row 1.
  • Choose Accounts Receivable.
  • Click Save.
  • See below screenshot for reference.

 

 

The final step is to match the deposit to the Invoice.

  • Choose the Plus (+) at the top of the screen.
  • Choose Receive Payment.
  • Choose the Customer’s name.
  • The Receive Payment form will now show both the invoice and the deposit (you may need to scroll down to see both).
  • Put a check in the boxes next to the invoice and deposit.
  • Click Save.
  • See below screenshot for reference.
  • This process links the payment to the invoice.

 

 

The payment will now show in the Customer center listed as a deposit.
The payment will zero out the invoice and the Accounts Receivable.
 

 

Categories
Bank Deposit bank feed bank feeds/page/2/ Banking Customers Invoice Receive Payment Receiving Payment

How to handle fees (Paypal and Square) deducted from customer payments in QuickBooks Online

This article deals with step-by-step instructions on how to manually recording fees (Paypal or Square) and then match the deposit transactions in bank feed —Review items from your bank and link each item to an existing record.

EXAMPLE – Signed up for Square (or PayPal) so that I could accept credit cards. I will be paying the fee myself, not the customer. So when I give a customer an Invoice for $1,000.00, they will swipe their card and have $100 taken from the customer. Square (or PayPal) will take their fee off the top and then deposit $970.00 into my business checking account. My bank feed under review items from bank link will show $970.00 deposit ($1,000 customer payment less $30 fee).

Here’s how to handle fees (Square and Paypal) deducted from Customer payments in QuickBooks Online:

 

1. Identify the customer Invoices that were paid via Square or Paypal.

2. Receive Payment of open invoice amount (create “+” sign > customers > receive payment) . Select the invoices that were paid. Make sure to select “Deposit-to” that this payment is being deposited into your Undeposited Funds account.

 

NOTE: To ensure that the associated transaction processing fee is recorded accurately, the invoice payment must be applied manually through the “Receive Payment” screen (rather than through the matching feature). A manual deposit must also be entered (step 3).

3. Add a new Deposit. Click on the Create or “+” sign and go to “Other” and click on Bank Deposit.

4. Select appropriate invoice(s) “Select the payments included in this deposit” tab

5. Record the processing fee part of the transaction under Add New Deposits tab.

Make sure to enter the amount of the processing fee as a negative number so that it deducts from the total deposit amount.
Received From = Square or Paypal Vendor
Account = Fees (Expense or COG account)

6. Total deposit amount should match your deposit to accept the transaction in bank feed.

 

7. Go back to Banking and under the Dashboard, locate your deposit under “For Review” tab. Since the processing fee has now been manually recorded in QuickBooks, you will be able to match your Square or Paypal deposit.

 

Categories
Bank Deposit Customers Expense Expenses Invoice Reports

Why mark it billable to a customer and select “track returns for customers” box on a bank deposit

This has to do with reflecting accurate direct expenses related to customers on Income by Customer Report.

If you are depositing a vendor/supplier refund for an expense that was previously Billed to a customer, select “Track returns for customers” box and choose that same customer on the deposit and mark it Billable.

For example, if you buy a material for a customer’s job, you would bill the expense to the customer. But if the customer later returns the material to you and you return it to the vendor/supplier for a refund that you are depositing, you need to mark the deposit billable to that same customer and also select “Track returns for customers” box. Otherwise, it will show as customer billed for the material expense, and the vendor credit will not appear on Income by Customer Summary Report.


 





 
Here is an example of what happens when $1,000 billable purchase returned to the supplier for a refund and deposited that money in the bank. The goal is to show zero expense related to that customer.

SHOWING RESULT WITHOUT BILLABLE AND RETURNS FROM CUSTOMERS

deposit without billable-and track returns for customers
deposit without billable-and track returns for customers
income by customer summary without billable track returns from customers
income by customer summary without billable track returns from customers

SHOWING RESULT WITH BILLABLE AND RETURNS FROM CUSTOMERS

deposit with billable and track returns for customers
deposit with billable and track returns for customers
income by customer summary with billable track returns from customers
income by customer summary with billable track returns from customers

 
WATCH VIDEO
QuickBooks Online Plus: Track returns for customers box on Deposit Form


 





 

Categories
Bank Deposit Bank Register Banking Journal Entry Refund Receipt Sales Receipt

How do you match a deposit to a receipt when the credit card refund is more than the actual deposit

Example:
We received a credit card payment from customer A ($334.00) and sent a credit card refund ($1,000.00) to customer B on the same day. This resulted in a net negative deposit ($666.00) from our credit card merchant provider. How to match a refund receipt and a regular receipt in order to properly match the deposit in our bank account from the bank feed.

sales receipt
sales receipt
refund receipt
refund receipt

QuickBooks Online won’t allow creating a negative bank deposit. If the total deposit is negative, you will need to create a Journal Entry to move the funds from Undeposited Funds to the bank account.

deposit negative
deposit negative

Here’s how to create that Journal Entry and move the funds from Undeposited Funds account to Bank account.

journal entry
journal entry
  • Click the Create (+) at the top of your Home screen.
  • Choose Journal Entry from the drop down (if you don’t see it, try clicking Show more).
  • Set the Date of the transaction (same as bank posted transaction date).
  • On the first distribution line of the Journal Entry:
  • In the Account column, choose Undeposited Funds.
  • In the Debit column, enter the amount of the deposit.
  • On the second distribution line of the Journal Entry:
  • In the Account column, choose the appropriate bank account.
  • Set the Credit column to the amount of the deposit.
  • Click Save and close. This will show a deduction from the bank account in the Bank Register in QBO.

Next, you will want to group the Journal Entry with the payments to create a $0 deposit and remove the payments from Undeposited Funds.

deposit zero with je
deposit zero with je
  • Click the Create (+) at the top of your Home screen.
  • Choose Bank Deposit from the drop-down.
  • Select the payments (negative and positive) and the Journal
  • The entry you just created (the total should be zero).
  • Click Save and close.

Next, go back to banking center (bank feed). You may see MATCH now for that transaction. If not, click that transaction row for refund receipt. Locate and match transaction from the list there. Save.

radio button switch from add to find match
radio button switch from add to find match
match transaction
match transaction

Video Tutorial

QuickBooks Online QBO – how to match negative credit card daily sales receipts | refund deposit

Categories
Bank Deposit Banking Vendor Vendor Credit Vendors

Handling Multiple Vendors Refund Checks Deposit in QBO

Categories
Bank Deposit Banking Customers Receive Payment

I have already received payments in QBO from multiple customers. How to make them match with a single deposit I see in my bank feed.

You’ve two ways to match with bank feed deposit.

1) Match it directly from the bank feed downloaded transactions.

Select a row for deposit in question. The row expands to show you “Find other matching transactions” button. Once you click this button, you will see a long list of possible match transactions. To easily locate your deposits, change payment date as you’ve recorded. Select payments (type = payment) to match with bank feed deposit amount. Make sure difference is zero. Save. Done.

find other matching transactions1
find other matching transactions1

2) Manual. This will take few steps, but you will see green MATCH sign once done.
a) Go back to “Receive Payment” (create+ sign > customer > receive payment > upper left corner clock, locate payment) screen for customer payment you’ve already recorded and change Deposit to: “Undeposited Funds” instead of a bank account. Do the same for other customer payments that you want to match to a batch deposit.
b) Bank Deposit (create + sign > other > bank deposit) – check existing payments from the list to match batch bank deposit. Make sure to check correct bank account if you’ve multiple bank accounts. Save. Done. Save and Close.
c) Go back to banking center (bank feed) and now you should see green Match sign for that deposit. Click Match. It should disappear from the list.

Note: #2 is recommended process in QBO if you’ve merchant card payments or use bank deposit slip from depositing checks from various customers.

If you found our answers useful then please contribute few bucks to support this forum. Thank you!





Thank you!






Sign up QuickBooks for a 30-day FREE Trial

QuickBooks USA





QuickBooks Canada








Categories
Bank Deposit Customer Center Customers

How to use track return for customers field shown on deposit form

“Track returns for customers” has to do with whenever you invoice your client for billable expenses (time and material) and the client pays less (for a variety of reasons) than invoice amount. This is a way to correctly track returns for customers account and receive payment to match deposit amount. In case, you will need to invoice deduction portion (same client or different client), you will also check billable box.
See screenshot below.

track returns for customers
track returns for customers

Note: Billable to customers feature option is available in PLUS plan only (not available in Essentials and Simple Start).

If you found our answers useful then please contribute few bucks to support this forum. Thank you!





Thank you!






Sign up QuickBooks USA

Categories
1099 Bank Deposit Chart of Accounts Check Expense Expenses Vendor Vendors

Owner paid a subcontractor with his own money. How to make sure Vendor shows up on 1099 and still able to write the reimburse check to the Company Owner

First, you will need to create a new dummy bank account. You will also need a due to the owner as a liability type account to use it for later reimbursement.

Step#1 Use bank deposit form (create + sign > other > bank deposit) to record contributed amount by the owner to pay a contractor. Account to show as due to the owner liability type account. See screenshot below.

owner deposit
owner deposit

Step#2 Use Expense form (create + sign > vendor > expense) to create contractor expense posted to appropriate expense account. See screenshot below.

contractor expense
contractor expense

Step#3 Use Check form (create + sign > vendor > check) to write the reimburse check to the Company Owner. See screenshot below.

check to owner
check to owner

In case there is no need to reimburse the owner (step#1), you will use a capital contributed account which would be an Owner’s Equity type account.

Review of 1099 vendors and payments list. See screenshot below.

review 1099 vendors payments
review 1099 vendors payments

If you found our answers useful then please contribute few bucks to support this forum. Thank you!





Thank you!






BUY QuickBooks Online - Anytime, Anywhere. Easily Track Sales, Bills and Expenses.
Beach Vacation Rentals under $100 a night
Save on Smartphones from Verizon Wireless!
Over 4000+ STD Test Centers Nationwide. Order Testing Today!

Sign up QuickBooks for a 30-day FREE Trial

QuickBooks USA





QuickBooks Canada








Categories
Bank Deposit Bank Register Banking

Learning Undeposited Funds Account in QBO