My batch deposit amount doesn't match what I collected on sales reciept.

Boatrepair01 · ‎June 25, 2020

On June 22nd, I processed 3 credit card transactions, an invoice for $1,518.16, an invoice for $108.25, and a sales reciept for $27.05. They were all paid with a debit card. The total of the three transactions is $1,653.46. When I tried to match it up from my bank feed, I noticed a $0.01 difference. When I checked the deposit screen, I saw that the batch for that day was $1,653.45. The sales reciept in the batch was $27.04 instead of $27.05. I also tried reducing the sales reciept by $0.01, but it will not let me. How can I resolve this?

ReyJohn_D · ‎July 03, 2020

You're welcome and thanks for the details, @Boatrepair01.

Yes, it will. However, we'll need to do more steps to fix the sales receipt amount. I have two other options you can consider performing.

First, we'll have to edit your bank deposit and add -$0.01 to match the sales receipt amount. Here's how:

Go to the Accounting menu, and then choose the Chart of Accounts tab.
Look for the bank, and then pick View Register.
Click the transaction, and then tap Edit.
Go to the Add funds to this deposit section, and then enter the needed info in the Received From, Account, Description, Amount, etc.
Make sure to put -$0.01 as the amount. This will reduce the deposited sales receipt amount of $27.05 to $27.04.
Click Save and close once done.

Second, if you don't want to create an adjustment, you can contact our Merchant Support team. This way, they can delete the payment for you. Then, you can manually record the correct amount using cash as the payment method.

Please refer to the QuickBooks Online with Payments and Merchant Service Center section of this article to get in touch with our support: Contact Merchant support.

Then, you're all good reconciling your account to ensure your books are accurate. Check out this article for the details: Reconcile an account.

Please let me know if there's anything I can help you with managing your bank transactions or other QuickBooks-related concerns. Take care and stay safe always.

View solution in original post

Adrian_A · ‎June 25, 2020

Thanks for the details, Boatrepair01.

The transactions downloaded in QuickBooks depends on your bank.

If the sales receipt shows as $27.05 in the bank statement yet, it reflected as $27.04 in QuickBooks, we can modify it through the Chart of Accounts page. I'll show you how:

From the Accounting tab, select Chart of Accounts.
Locate the bank account and click View register.
Click the sales receipt transaction.
Modify the DEPOSIT amount.
Click Save.

You can also use these screenshots as your visual guide:

Once done, you're good to reconcile the account. Here's an article for the steps of the process: Reconcile an account.

I'm just a post away if you need some help. Take care!

Boatrepair01 · ‎July 03, 2020

Hello Adrian,

Thank you for responding :) So the customer was charged $27.05 via a debit card through the sales reciept, which is the correct amount. When Quickbooks sent the batch to my bank, it was shorted by $0.01. Therefore, the amount deposited to my bank from Quickbooks was less than the amount collected by Quickbooks from the customer. Will your suggestion work in this instance? I actually just deposited a penny into my account to make up the difference, but it will not let me match that deposit with the deposit Quickbooks shorted. Thank you so much for your help!

Edited to add:

The only place I see this sales reciept showing as $27.04 is in the deposit list in invoicing > deposits. This is where it shows what is in each batch sent to the bank. So somewhere between processing the sales reciept and Quickbooks making a batch to send to the bank it lost a penny.

ReyJohn_D · ‎July 03, 2020

You're welcome and thanks for the details, @Boatrepair01.

Yes, it will. However, we'll need to do more steps to fix the sales receipt amount. I have two other options you can consider performing.

First, we'll have to edit your bank deposit and add -$0.01 to match the sales receipt amount. Here's how:

Go to the Accounting menu, and then choose the Chart of Accounts tab.
Look for the bank, and then pick View Register.
Click the transaction, and then tap Edit.
Go to the Add funds to this deposit section, and then enter the needed info in the Received From, Account, Description, Amount, etc.
Make sure to put -$0.01 as the amount. This will reduce the deposited sales receipt amount of $27.05 to $27.04.
Click Save and close once done.

Second, if you don't want to create an adjustment, you can contact our Merchant Support team. This way, they can delete the payment for you. Then, you can manually record the correct amount using cash as the payment method.

Please refer to the QuickBooks Online with Payments and Merchant Service Center section of this article to get in touch with our support: Contact Merchant support.

Then, you're all good reconciling your account to ensure your books are accurate. Check out this article for the details: Reconcile an account.

Please let me know if there's anything I can help you with managing your bank transactions or other QuickBooks-related concerns. Take care and stay safe always.

Topics

Training

Community

Resources

My batch deposit amount doesn't match what I collected on sales reciept.