QuickBooks Receive Payment

by Mark
(U.S.)

This is the message you ignored when making your bank deposit for the customer payment received.

This is the message you ignored when making your bank deposit for the customer payment received.


Adjusting Accounts Receivable For Deposited But "Unreceived" Payments. BEST Solution ... Follow The QuickBooks Process.


Hi,

I have a bad habit of just depositing funds and recording it in QuickBooks 2009 without going through the "Receive Payments" process.

Therefore, later, I need to make an adjusting entry to make sure that A/R is accurate and shows receipt of payment, but without increasing my bank balance by the same amount a second time.

Could you please help me with this?

Thx,

Mark



image of fancy scroll lines



Hi Mark,

QuickBooks is a great program but if you don't use it the way the program is designed, you create all kinds of trouble for yourself ... and get inaccurate reporting. Who is going to rely on inaccurate information to run their business?

I'm curious ... you haven't told me if you have been booking your income twice ... once when you create the invoice or sales receipt ... and again when you booked your deposit. If you haven't been booking your income twice, where have you been booking your deposits?

I'm going to walk you through an example using a customer named Matthew Downs. He made a $1200 payment on November 30, 2012.

I want you to run your Customer Balance Detail report. My guess is under "Type" you will see Invoice or Deposit but not Payment.

When you receive a payment through accounts receivable, "payment" type would show up here. "Deposit" type shows up here when you use Make Deposits for a customer payment.

If you are using QuickBooks properly, there should be no "deposit" types here. If there is, you need to fix it.

Now I want you to open up your Customer Center and go to one of your customers. I'm guessing that when you look at the customer's account, the payment you deposited does not show. This is the big downfall for you. If a customer calls, you can't just look in the account and see how much is owing anymore. Your sub-ledger does not match your general ledger control total.

You could run the Accounts Receivable Aging Summary and get a balance ... but you need to tidy it up. I'm going to run through two ways to correct your problem. I suggest you take a backup before you start. That way if you muck up, you get a do-over.

The first way does a quick fix ... meaning you will apply the payment to the customer's balance ... but it won't show up in the customer sub-ledger (Customer Center).

Find your Make Deposit entry. Change the "from account" field to "Accounts Receivable". The customer's name must be correct in the "received from" field. Save your entry. See picture two above for an illustration.

By the way, if you had more than one customer payment in your deposit ... and you lumped it into one line on your deposit slip, you are going to have to split it out. You need to enter each customer payment on a separate line within the deposit slip.

Next, go to Receive Payment and select your customer name. You should see a message on the left hand side that says, "This customer has credits available. to apply credits click Discounts & Credits...". Go ahead and click the "Discounts & Credits" button. Picture three above shows this screen for you and what it should look like.

Now, click on one of the unpaid invoice lines (see picture four). The credit amount available shows, along with the amount you are going to apply. If this payment is for numerous outstanding invoices, you will have to repeat this step until your credit is used up.

Again this method is a quick fix but is not a long term solution because it doesn't correct your customer sub-ledger.

The second option is to fix your error and do the entry properly, the way it should have done. You can see that using this method means you didn't save any time taking a short cut. In fact, you created more work for yourself.

First, void the deposit (do not delete it - voiding keeps the audit trail) but record the information you need BEFORE you void it.

Next record the payment through the customer payment screen ... I told you there was no time savings using this method. (Oops I didn't mean to say "I told you so!" :0))

What makes this the better option of the two methods ... it fixes your customer sub-ledger.


Mark, a smarter shortcut would be to use "receive payment" and change the "Deposit to" field to chequing from undeposited funds. I've outlined the field in picture three above.

However, the downside to this shortcut is you will make your bank reconciliation tougher if you deposit multiple payments in a bank deposit ... and you reduce your internal controls.

So I'm sorry to say that no matter what option you choose, you are going to have to roll up your sleeves because it is going to take work to fix this error.

Maybe this will make you feel a bit better ... you are not alone in trying to take this shortcut.









P.S. I would like to remind you there is a difference between information and advice. The general information provided in this post or on my site should not be construed as advice. You should not act or rely on this information without engaging professional advice specific to your situation prior to using this site content for any reason whatsoever.

Comments for QuickBooks Receive Payment

Average Rating starstarstarstarstar

Click here to add your own comments

Mar 19, 2013
Rating
starstarstarstarstar
OFFSETTING ACCOUNT RECEIVABLE AGAINST ACCOUNT PAYABLE
by: Mary M.

Hi, I am Mary and I thank you for this wonderful site.

I have a problem while trying to enter journal entries to offset an amount owed by a debtor who is also my creditor.

I wish there was a way I could offset these to amounts as I am expected to reduce the amount I owe by the amount the debtor owes.



section divider



Hi Mary,

Try this:

1. Deposit the customer payment to your cash account (or a barter clearing account) after "receiving payment" in the A/R module.

2. Pay your vendor bill using the same cash account.

3. Process any remaining amounts/balances in A/R or A/P as normal.

If you've done it correctly, your amount owing to the debtor will be reduced and the amount your debtor owes you will also show an equal payment. The amounts should clear / nil each other out.

Apr 29, 2015
Rating
starstarstarstarstar
Delete Duplicate Payment
by: Sandra, Seattle

How do I delete a duplicate payment on an invoice?

Apr 29, 2015
Rating
starstarstarstarstar
Sandra
by: Lake

Check the forum post above and it should help. Also check out how to decide when to delete vs void a transaction here:

https://www.bookkeeping-essentials.com/month-end.html#voids

Click here to add your own comments

Join in and write your own page! It's easy to do. How? Simply click here to return to Learning QuickBooks.

Share this page:
Enjoy this page? Please pay it forward. Here's how...

Would you prefer to share this page with others by linking to it?

  1. Click on the HTML link code below.
  2. Copy and paste it, adding a note of your own, into your blog, a Web page, forums, a blog comment, your Facebook account, or anywhere that someone would find this page valuable.

Enjoy A Tea Break With
Me Today. Let's Chat!

Use the search feature to quickly find the
information you're looking for.



SHORTEN
Your Learning Curve!

 



Warm up your tea cup and check out these chats ...

Click on image above to read the chat.








Join Me On Facebook

Help support this site by "liking" me! Here's where I post current information.

Listed Under Websites NOT Local Business.
This website is NOT associated with the business operating in Bonnyville AB.


A Handy Reference