cancel
Showing results for 
Search instead for 
Did you mean: 
shsreadingma
Level 2

Deposited cust check 522.00 in numeric portion of check and only 500.00 in the written amount. We were credited with 522.00 but Bank now debited 22.00. How to fix in QB

How do I fix this in QB? Bank has done a Withdrawal from our accout of $22.00 labeled an Adj-DEBIT, and rightfully so, I have no problem with what has been done, the Q is what steps do I need to take to reflect this in QB? I know that the customer needs to be debited the $22 in our QB and I assume that the customer would be credited $22 with their bank?  Also I know that we need to be debited the $22 in order to Reconcile monthly. I'm sure its easy but I cant figure out the steps. Thanks
Solved
Best answer December 31, 2019

Best Answers
JasroV
QuickBooks Team

Deposited cust check 522.00 in numeric portion of check and only 500.00 in the written amount. We were credited with 522.00 but Bank now debited 22.00. How to fix in QB

Thanks for the clarification, @shsreadingma.

 

As mention from the initial post, your bank has done a withdrawal amount of $22.00 labeled as an Adj-DEBIT. You can write a check for $22.00 under an Accounts Receivable A/R. Here's how.

 

In your QuickBooks Desktop (QBDT):

  1. Go to the Banking menu and select Write Checks.
  2. Select a bank account from the BANK ACCOUNT field.
  3. Choose the name of the customer the check is issued for in the PAY TO ORDER OF field.
  4. In the Expenses tab, select the A/R account under the ACCOUNT column.
  5. Once done, click Save and Close2.PNG

Here's an article you can read for more details: Create, modify, and print checks.

 

This will increase the customer's balance which is receivable from them. Once the deposit is posted, you can follow the steps provided by my colleague  above.

 

I'd also encourage contacting your accountant if you want more tips on how to better record this.

 

Also, you'll want to check this article to learn more about receiving invoice payment in your QuickBooks Dekstop (QBDT).

 

You can always get back to us if you have other questions with invoice payment. We're always here to help. Have a great day ahead!

View solution in original post

BigRedConsulting
Community Champion

Deposited cust check 522.00 in numeric portion of check and only 500.00 in the written amount. We were credited with 522.00 but Bank now debited 22.00. How to fix in QB

To fix this, write a "check" using the customer as the payee and the AR account as the expense account.

 

Doing so will decrease your bank balance and increase your AR balance - AR balance for the customer.

 

Then, if you need to show the customer this activity on paper, print a customer statement.

View solution in original post

8 Comments 8
Charies_M
Moderator

Deposited cust check 522.00 in numeric portion of check and only 500.00 in the written amount. We were credited with 522.00 but Bank now debited 22.00. How to fix in QB

You came into the right place, shsreadingma.

 

When you partially pay the $522 invoice with $500, you can just Receive Payment the remaining balance ($22). To do this, you can follow the instructions I've outlined below:

  1. Go to Customers and choose Customer Center.
  2. Click the customer name.
  3. Under Transactions tab, choose the invoice you've partially paid.
  4. Click Receive Payments.
  5. In the Customer Payment window, you can see the remaining balance from the Payment Amount field.
  6. Review the information and click Save & Close.

This will now zero out the balance of your invoice. To learn more about invoice payment, you can refer to this article: Record an invoice payment.

 

I'll be right here if you need with anything about QuickBooks. Wish you all the best.

shsreadingma
Level 2

Deposited cust check 522.00 in numeric portion of check and only 500.00 in the written amount. We were credited with 522.00 but Bank now debited 22.00. How to fix in QB

 

hello, thanks for the reply.
I think you totally missed my question.  Please re-read my question.
 
The ENTIRE INVOICE was paid, she wrote a check for $522 but b/c the WRITTEN TEXT part of the check was only "five hundred dollars", the bank ended up un-crediting the deposit by $22.00 by doing an adjustment which showed up in my monthly statement in the Withdrawal column of my statement (as well as mailing me the details on what they did). And so now the customer owes me $22 which they have actually already paid me (though I haven't deposited it yet, no rush on that as part of a larger check for the next invoice).  All of the aforementioned interaction has already been recorded as a deposit in QB along with other checks that I deposited at the same time.
 
So as I mentioned, this all needs to be cleaned up, CLEANLY in QB, that's what I need help with. What you told me how to do is something that I have done many times, that's easy, there NO MISTAKE made in that scenario and it is very easy and straightforward to do, that's a completely different issue (if you can even call it an issue) than what I have presented in my post, please re-read what I wrote.
 
Thanks

 

dd
JasroV
QuickBooks Team

Deposited cust check 522.00 in numeric portion of check and only 500.00 in the written amount. We were credited with 522.00 but Bank now debited 22.00. How to fix in QB

Thanks for the clarification, @shsreadingma.

 

As mention from the initial post, your bank has done a withdrawal amount of $22.00 labeled as an Adj-DEBIT. You can write a check for $22.00 under an Accounts Receivable A/R. Here's how.

 

In your QuickBooks Desktop (QBDT):

  1. Go to the Banking menu and select Write Checks.
  2. Select a bank account from the BANK ACCOUNT field.
  3. Choose the name of the customer the check is issued for in the PAY TO ORDER OF field.
  4. In the Expenses tab, select the A/R account under the ACCOUNT column.
  5. Once done, click Save and Close2.PNG

Here's an article you can read for more details: Create, modify, and print checks.

 

This will increase the customer's balance which is receivable from them. Once the deposit is posted, you can follow the steps provided by my colleague  above.

 

I'd also encourage contacting your accountant if you want more tips on how to better record this.

 

Also, you'll want to check this article to learn more about receiving invoice payment in your QuickBooks Dekstop (QBDT).

 

You can always get back to us if you have other questions with invoice payment. We're always here to help. Have a great day ahead!

shsreadingma
Level 2

Deposited cust check 522.00 in numeric portion of check and only 500.00 in the written amount. We were credited with 522.00 but Bank now debited 22.00. How to fix in QB

JasroV, it would be helpful if you could provide more info on step 3. "Fill in the needed information."  I mean, who am I writing the check to and what account would it be written out of, my bank account for which this issue stemmed from ("Eastern Checking Account")?

thanks

dd

BigRedConsulting
Community Champion

Deposited cust check 522.00 in numeric portion of check and only 500.00 in the written amount. We were credited with 522.00 but Bank now debited 22.00. How to fix in QB

To fix this, write a "check" using the customer as the payee and the AR account as the expense account.

 

Doing so will decrease your bank balance and increase your AR balance - AR balance for the customer.

 

Then, if you need to show the customer this activity on paper, print a customer statement.

shsreadingma
Level 2

Deposited cust check 522.00 in numeric portion of check and only 500.00 in the written amount. We were credited with 522.00 but Bank now debited 22.00. How to fix in QB

ok ok, now there is a column in Write Checks called "CUSTOMER:JOB", while I already am writing the check to the customer, should I ALSO put in that customer into this field or should I just leave it blank? Finally there is a field called "BILLABLE?", should that be left blank?

thanks

dd

RenjolynC
QuickBooks Team

Deposited cust check 522.00 in numeric portion of check and only 500.00 in the written amount. We were credited with 522.00 but Bank now debited 22.00. How to fix in QB

I'd like to clear up some information, shsreadingma.

 

If you haven't selected a customer from the PAY TO THE ORDER OF section, you will be required to add it under the CUSTOMERJOB column. This is to associate the check to the customer, so the amount is added to the total balance.  

 

In the BILLABLE field, this will be set as blank once you choose an Accounts Receivable account.

 

I've got this article for more details: Create, modify, and print checks.

 

I'll be around if you have any additional questions related to write checks in QuickBooks. Thanks.

shsreadingma
Level 2

Deposited cust check 522.00 in numeric portion of check and only 500.00 in the written amount. We were credited with 522.00 but Bank now debited 22.00. How to fix in QB

Thanks for working with me on this endeavor, I would literally have never figured out how to do it, BUT, I did say up front when opening this, that the solution was easy, I was sure of it, I just had absolutely no idea how to do it, the key is this A/R account that I literally have never needed to touch in 10 years, can you believe it, processing over a million bucks in revenues and lots of payroll to match that, but it's been there behind the scenes all this time.

Need to get in touch?

Contact us