All articles
Article

How to stop reconciliation headaches from cash and checks

Record every cash and check payment to an undeposited funds holding account and then group those receipts with a deposit slip before you hit the bank.

5 min readBy the Trade Books team

Record every cash and check payment to an undeposited funds holding account and then group those receipts with a deposit slip before you hit the bank. That produces a single deposit in the books that matches the bank statement line, so bank reconciliation matches deposits, not individual checks, and your reconciler stops guessing what belongs where.

Key takeaways

  • Post cash and check receipts to an undeposited funds account when you receive them, not to a bank account.
  • Create a deposit slip that groups the day’s receipts so the books show one deposit that matches the bank statement line.
  • Bank reconciliation should match statement lines to deposits, eliminating the need to chase individual checks on the statement.
  • Turning Trade Books’ deposit-slip workflow on only affects payments you receive after you enable it; prior banked history is left as-is.

What is the practical fix for multiple cash-and-check receipts that don’t match the bank?

Answer: stop recording each check as a separate bank deposit and instead hold receipts in an undeposited funds account until you create a single deposit slip that matches the bank’s deposit line. When your bookkeeping shows one deposit equal to the bank statement line, reconciliation becomes straightforward.

Detail: the usual problem is timing and grouping. Customers pay by check during the day; the cashier or tech posts each payment straight to the bank account in the books. The bank, however, records the physical deposit you make at the end of the day — a single line that totals several checks. If your books show several individual deposits while the bank shows one, the reconciler must add or subtract entries to find which items belong to that bank line. That’s slow and error-prone.

How do I implement a daily deposit workflow my bookkeeper can follow?

Answer: use a short, repeatable checklist every business day so receipts are grouped correctly and the bank reconciliation matches deposits to statement lines.

  1. Collect receipts: At the end of the day, gather every cash receipt and every paper check received by techs and the office.
  2. Record receipts to undeposited funds: Enter each cash and check payment into your accounting system to the undeposited funds holding account instead of a bank account.
  3. Create the deposit slip: Total the receipts and create a deposit slip in the system or on paper that lists the included receipts and produces one deposit total equal to what you’ll deposit at the bank.
  4. Make the bank deposit: Physically deposit the grouped funds at the bank so the bank statement shows a single deposit line for that total.
  5. Post the deposit in the books: Mark the deposit slip as deposited in the accounting system so the undeposited funds entries move into your bank account as one single deposit entry.
  6. Reconcile: When the bank statement arrives, match each bank statement line to the single deposit entry instead of matching many small receipts to a single bank line.

Do this every business day. Consistency is the point: the bank sees one deposit and your books show one deposit, so reconciliation is a line-to-line match.

How does Trade Books handle undeposited funds and deposit slips?

Answer: Trade Books records cash and check receipts to an undeposited funds holding account when they are received, and you group those receipts into a deposit slip so the books show a single deposit that matches the bank statement.

The specific behavior you get in Trade Books is: cash and check payments recorded in Trade Books post to an undeposited funds holding account when they are received, not straight to the bank account. When you create a deposit slip it groups several of those receipts into one bank deposit, so the books show a single deposit that matches the single line on the bank statement. Bank reconciliation then matches statement lines to deposits rather than to individual checks. Remember that turning the feature on only affects payments received from that point forward; already-banked history is never restated.

What manual work does this stop doing and what mistakes does it prevent?

Answer: it stops matching individual receipts to a single bank deposit by hand and prevents common reconciliation errors where amounts don’t line up and the bookkeeper has to guess which checks were included in a physical deposit.

More detail: with the undeposited funds plus deposit slip workflow the office no longer has to add or split bank statement lines to force-fit receipts. You stop making manual journal entries to re-group deposits, stop tracking down which tech submitted which check when totals don’t match, and reduce missed or duplicate deposits caused by posting receipts directly to a bank account. The workflow prevents the specific mistake of reconcilers matching the bank statement to individual checks instead of to the deposit the bank actually recorded.

Frequently asked questions

Will turning this on change deposits already reconciled in past months?

No. Turning the feature on only affects payments received from that point forward; already-banked history is never restated. You will not have past bank or deposit entries rewritten by the change.

Why does my bookkeeper want receipts in undeposited funds instead of the bank account?

Because undeposited funds holds each receipt until you group them into the deposit you actually take to the bank. That grouping produces one deposit entry that matches the bank statement, which makes bank reconciliation a line-to-line match rather than a series of assembled items.

What should I do when the bank charges a fee or short-deposits part of the total?

Treat the bank’s fee or short deposit as a separate bank transaction in the reconciliation. Match the bank statement line to the deposit total and post the fee as the bank recorded it so the books reflect the actual net deposit and any fee expense.

Can one deposit slip include receipts from more than one tech or job?

Yes. The whole point of a deposit slip is to group multiple receipts into a single deposit. Include all the day’s cash and checks regardless of who collected them so the deposit total equals what you take to the bank.

How does this affect my daily cash report or job costing?

Record receipts to undeposited funds as you normally would, and preserve job or payment details on each receipt entry. Grouping into a deposit slip only changes how deposits appear on the bank statement side; your job-level receipts still show which job or invoice they paid.

Where can I learn more about using deposit slips in Trade Books?

See the practical walkthrough in our post that shows a matching workflow and examples of deposit slips and reconciliation: Match your bank deposits to your books: use undeposited funds and deposit slips.

One thing to do this week

Create a single, one-page checklist and run it for the next five business days: collect receipts, record each cash and check to undeposited funds, make one physical deposit at the bank, and post the deposit as a single deposit entry so you can reconcile it to the bank statement. If you want to try the workflow in software first, Trade Books has a 30-day free trial, no credit card required, and no contracts.

See it on your own data

Trade Books runs field service and accounting from one database.

No setup fee. No credit card. Cancel anytime.

Start Free Trial