Match Combined ACH + Card Payments in QuickBooks Online (QBO)

If Docket syncs ACH and card payments into QuickBooks Online (QBO) as separate transactions, but your bank deposits them as a single lump sum, you may have trouble matching them during reconciliation. The best way to handle this is with Undeposited Funds in QBO.

Before You Start

• In Docket, confirm that payments are set to deposit into Undeposited Funds, not directly into your bank account.
• Have your bank feed connected in QBO.

Step 1: Group Payments into a Deposit

1. In QBO, go to + New > Bank Deposit.
2. Select the bank account where the real deposit landed.
3. Set the Deposit Date to match your bank feed.
4. Check all ACH and card payments that made up the deposit.
5. Confirm the total equals the deposit amount in your bank feed.
6. Click Save and Close.

Step 2: Match the Deposit to Bank Feed

1. Go to the Banking tab in QBO.
2. Locate the deposit in your bank feed.
3. QBO should auto-match it to the grouped deposit you created.
4. Click Match.

If no match appears:

• Confirm the total is correct.
• Confirm the deposit date matches.
• Re-check that the correct payments were selected.

If Payments Sync Directly to Bank

• You won’t be able to group them in QBO.
• The deposit may not match your bank feed.
• Fix: Update Docket settings to send payments to Undeposited Funds.

Use Docket’s Payments Report

If you’re unsure which payments were included in a lump-sum deposit:

1. Open the Payments Report in Docket.
2. Filter by deposit date.
3. Tally ACH and card payments until they equal the deposit total.
4. Use customer names, invoice numbers, and payment methods to confirm.

This gives you a clear list to check off in QBO’s Bank Deposit screen.

Summary

• Use Undeposited Funds to group payments before depositing.
• Match grouped deposits in QBO to your bank feed.
• Use the Payments Report in Docket to identify which payments belong in each deposit.