Goshen Accounting Services

View Original

How to Record a Returned Sales Receipt Payment in QuickBooks Online

I am always amazed to learn how people track things in QuickBooks Online. I was cleaning up a client’s file the other day and realized that they were using journal entries to record returned sales receipt payments from customers.

The problem with using journal entries is you bypass the sales form and expense form when you record the transaction this way and it makes it harder to see which customer’s profile was impacted by the returned payment.

There are very few instances, you should ever use journal entries to record a transaction in QuickBooks Online. This is not one of them.

In this tutorial, I will show you how to record a returned sales receipt payment and the bank fee without using a journal entry.

Things you will need

  • A copy of your bank statement or a copy of the returned payment transaction and bank fee

  • A copy of the original sales receipt

  • Activate the product/service expense side

To get started, log into qbo.intuit.com.

Step #1 Create a Sales Return income account

If you only have one product or service and you do not use the item details section on expense forms to mark transactions as billable to a customer, you can skip this step.

Click the accounting tab and select the chart of accounts.

Click the green new button to add a new revenue account.

  • Account type = Income

  • Detail type = Discounts/Refunds Given

  • Name = Sales Returns/Discounts/Refunds

  • Leave the description field blank

  • Make it a sub-account of your overall sales or revenue account already on your chart of accounts

  • Click save and close

QBO Income Account

Step #2 Make the product or service into a two-sided item

Click Sales and select Product and Services.

  • Find the product or service item you previously used in the original sales receipt.

  • Click edit next to the product or service name.

  • Scroll down to the “purchasing information” section and check the box next to “I purchase this product/service from a vendor”.

  • Leave the description field and cost field blank.

  • In the expense account box, select the income account you created in Step #1.

  • Leave the preferred vendor field blank.

  • Click save and close.

QBO Product and Service Part 1

QBO Product and Service Part 2

Step #3 Write a Check to record payment and bank fee

Click the +New icon

Under the vendors’ column, select write a check if recording a returned check or select expense if recording a returned payment from a merchant account. I prefer using the check method.

QBO Returned Customer Payment Check and Bank Fee

  • Payee = Bank name or merchant account name

  • Bank account = the checking account or merchant bank type clearing account the funds were deposited to

  • Payment date = the date the funds were returned

  • Check no = enter the real check number or ACH

  • Print later = keep this unchecked if you are not printing a check

  • Location tracking = enter the appropriate location or enter 1. Without donor restrictions for nonprofits

  • Under the Category details, enter the bank fee

    • Category = bank charges expense account

    • Description = bank fee for returned payment

    • Amount = bank fee

    • Customer = select the customer’s name

    • Billable = only check the box if you want to charge the customer back for the bank fee

    • Class = enter the appropriate class

  • Under the Item details, record the customer’s check that was returned to the bank.

    • Product/service = select the original product or service used in the original sales receipt

    • Description = bounced payment due to insufficient funds

    • Qty = 1

    • Rate = total amount that was bounced

    • Amount = QBO will auto-fill this box

    • Customer = select the customer’s name

    • Class = enter the appropriate class

  • Memo field = customer X returned payment and bank fee due to insufficient funds

  • Attachments = add any return document that you have here

  • Click save and close

Using the check or expense form method gives you the ability to see the returned customer payment in the customer’s profile.

And, you can see the bank fee in the vendor profile to match what is reflected on your bank statement.

It also helps you know how much extra fee to charge the customer when you re-invoice them for the same product or service.

The transaction will reduce the original revenue account the funds were recorded to and increase your bank charges expense account. Don’t forget to contact the customer to collect a different payment method.


Are You On Pinterest?

Pin this post and share it with others.

Contact me - I am happy to help with QuickBooks Online or QuickBooks Desktop setup, training, or troubleshooting issues.

See this content in the original post

See this gallery in the original post