cancel
Showing results for 
Search instead for 
Did you mean: 
Nicoferg
Level 1

Altered check deposit from bill payment

I wrote a check to a contractor for $150. She did a mobile deposit and for whatever reason, entered $180 as the check amount. Both her bank and my bank cleared the transaction. I called the bank to report the error and they requested the $30 difference from the contractor’s bank. Now in QBO I have a bill for $150, a $180 bank-roll withdrawal, and a $30 bank roll error credit. How do I report these 2 bank roll transactions to match them to the $150 “bill”? I could not get “vendor credit” or “bank deposit” to balance the bill payment amount.

1 Comment 1
JanbonN
QuickBooks Team

Altered check deposit from bill payment

Hello there, Nico. I'm here to help you successfully match your transactions in QuickBooks Online (QBO).

 

To match the bill for $150 with the $180 bank withdrawal and the $30 bank error credit, we'll need to first void or delete the previous check for $150. This will reopen the bill, allowing us to make the necessary adjustments. Here’s a step-by-step guide:

 

Let's first void or delete the $150 check transaction:

 

  1. Go to Expenses and select the Vendors tab.
  2. Open the vendor profile and navigate to the check for $150.
  3. In the ACTION column, click the dropdown and choose Delete or Void.VoidorDeleteCheck.jpg

 

Then, let's now create a $180 check transaction:

 

  1. Go to the +New and select Check.
  2. Choose the Payee and Bank Account in the dropdowns.
  3. In the Category details section, select Accounts Payable (A/P) in the CATEGORY column.
  4. Input $180 in the AMOUNT column.
  5. Click Save and close.CreateCheck.jpg

 

Let's now link the bill by creating a Pay bills transaction:

 

  1. Go to the +New and select Pay bills.
  2. Choose the Payment account and Payment date.
  3. Tick the bill for $150 and input $180 in the PAYMENT column.
  4. Click Save and close.LinkBill.jpg

 

Then, create a bank deposit:

 

  1. Go to the +New and select Bank deposit.
  2. Choose an Account in the dropdown.
  3. In the Add funds to this deposit section, choose the vendor in the RECEIVED FROM column, select A/P in the ACCOUNT column, and put $30 in the AMOUNT column.
  4. Click Save and close.BankDeposit30.jpg

 

Lastly, link the deposit by creating a Pay bills transaction:

 

  1. Go to the +New and select Pay bills.
  2. Choose the Payment account and Payment date.
  3. Tick the $30 and input $30 in the PAYMENT column.
  4. Click Save and close.LinkBill2.jpg

 

Moreover, I recommend collaborating with your accountant for other options for matching the transactions.

 

Additionally, ensure to reconcile your accounts to keep them accurate and up-to-date.

 

Let us know if you have other concerns with your checks, deposit, and matching in QBO. We're here to help you in any way we can.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us