Memorial Day Sale 90% OFF QuickBooks for 3 months.* Limited time only

Buy now & save
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
kogawa
Level 1

When you apply check payments to open AR invoices, how do you enable QB to batch the total for that day's total check deposits to match the bank statement line?

 
1 Comment 1
KiazzymaeC
QuickBooks Team

When you apply check payments to open AR invoices, how do you enable QB to batch the total for that day's total check deposits to match the bank statement line?

Hello, Kogawa. To make sure your bank statement matches your total check deposits, you need to record the payments you've received against those Accounts Receivable invoices, and then group them into a single deposit under Undeposited Funds. I’ll help you throughout this process.
 

First, let's record the payments you've received. Here’s what to do:

 

  1. Go to + New.
  2. Under the Customers section, click Receive Payment.
  3. Choose a customer in the Customer field, and put in the Payment Date.
  4. For the Payment Method, select Check, and for the Deposit to option choose Undeposited Funds.
  5. Check the box next to the invoice you are paying in the Outstanding Transaction section.
  6. Click Save and New when finished.
     

 

Repeat these steps for all check payments received that day.

 

Next, let’s group these check payments into a single deposit. Here’s how:
 

  1.  Go to + New again.
  2. Under the Other column, click the Bank Deposit.
  3. Select the account where the money will go in the Account dropdown.
  4. Enter the date.
  5. In the section Show payments for this location, choose either All Locations, Unspecified Location, or Select Location.
  6. Tick the boxes for the payments you want to group under Select the payments included in this deposit.
  7. Check that the total matches your deposit slip. Use the slip as a reference
  8. Once done, click Save and Close.

 

 

For additional details, check out this guide: Record and make bank deposits in QuickBooks Online.

 

Once finished, you can reconcile your accounts to keep accurate financial records and ensure they match your bank and credit card statements.
 

Lastly, I'd like to recommend our QuickBooks Live Expert Assisted. Our expert bookkeepers ensure your books are accurate and up to date, allowing you to focus on running your business while we handle the financial details.

 

If you need more help matching your bank statement to the total check deposit, feel free to click the Reply button. I'm here to help you every step of the way. Have a great day! 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us