Check our BBB rating

Cash and Check Deposits

You can reconcile your bank statements more easily IF you group your cash & check payments into deposits the same way the bank groups them together.

When you enter Sales Receipts or Receive Payments on Invoices, be sure to enter the correct Payment Date and whether it was paid by C(ash) or Ch(eck).

Some QuickBooks users don’t realize when they receive Payment(s) on their Customer Invoices using QB 2004 or earlier, the payments received may be: 1) deposited directly into a bank account OR 2) deposited into “Undeposited Funds,” like sitting in your desk drawer waiting for you to take to the bank.  QB 2005-06 automatically place all monies received into “Undeposited Funds.”  This is a good thing and the best way to handle it.

You want to group your undeposited funds together exactly the way you take them to the bank.  Click on Banking, Make Deposit, and checkmark each & every Cash & Check payment you are ready to deposit into the bank.  Click OK, make sure that the checking acct is correct, the date is correct, & overwrite the word “Deposit” with “Ck & the number of  payments included in this deposit.  Make sure all payments from Undeposited Funds are listed.  Click “Save & Close” or “Save & New” to enter another deposit.  You may print a “deposit summary” to attach to your deposit slip.   Click on Print (at the top of the deposit window).  Print the deposit summary on plain paper OR print the deposit slip if you have printable blank deposit slips.

Sometimes, you will NOT deposit the cash in the bank.  Create a bank account named Petty Cash.  Deposit any cash you receive that you don’t deposit into your bank account into your Petty Cash account.  If you put some of the cash in the bank and some into Petty Cash, you may need some help setting it up.

When you reconcile your next bank statement, make sure that your QB deposits match those on your bank statement.  If they do match, congratulations.  If they do not match, re-examine how the grouping in QuickBooks differs from the bank statement, and make the proper adjustments.

3 comments to Cash and Check Deposits

  • Thank you for this information. Although I do not currently have QB, I will consider the advantages of having it to keep track of my accounts. The information you provide here thought is still helpful for me to keep track of what I am depositing for cash or checks! Thanks, Jamie

  • I use QuickBooksPro and love it. However, what I don’t love is the way they force you to upgrade in order to get updates.

    • QBQueen

      Intuit only requires you to upgrade once every three years. I think that is very reasonable especially since you can buy QuickBooks Pro for about $140 on Amazon. That comes to less than $50 per year for a great bookkeeping program. Hard to beat that.

Leave a Reply




You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>