Cash Transactions and Bank Deposits

Hello there, jghareeb777. 

We value your trust in QuickBooks and sincerely appreciate you. I'm here to provide a solution to your concern.

Just to make sure we're on the same page, did you manually record the $100? If so, we can create a refund or write a check to your customer worth the difference. This helps us match your cash to your deposits. Here's how:

1. Go to the Banking menu and select Write Checks.
2. Enter the required details. Then, make sure to add the correct amount.
3. Click Save &Close.

Once done, we can now match them from the bank feed.

1. Go to the Banking menu.
2. Select Bank Feeds and select Bank Feeds Center and review the transactions in each category.

Still, we can consult your accountant for other ways handling this one. This is to ensure your books won't mess up and remain accurate.

Feel free to use these articles for guides and more tips:

• Add and match Bank Feed transactions in QuickBooks Desktop.
• Reconcile an account in QuickBooks Desktop.

Visit again if you have more concerns about matching transactions in QuickBooks. Take care and stay safe always.

Hello,

That would be nearly impossible as we have many customers every day that pay in cash.  The kind of transaction that I speaking of would be like you walking into a store, paying in cash and the cashier giving you change.  For me the transaction starts in our DMS system (which integrates with QB), the customer could be paying for item they are buying off the shelf or a repair order.  My cashier clicks on the payment screen and see the total of 82.87, she types in 100 and click payment, the screen shows her the change and she clicks payment again to record the whole transaction.  I am holding a $100 bill to deposit in the bank but my UF says 82.87 that I am depositing in QB to that bank account.  
I want to know if there is something I can do in UF process to have the totals match.  

@jghareeb777 

If you have not been using invoices for these transactions, you need to. In your example, create an invoice for $82.87.  When you receive payment, enter $100 in 'Payment Amount' and QB will ask what you want to do with the overpayment.  Click the 'Refund the amount to the customer' option.  It will then ask you how you want the refund issued - cash, check, etc.  That will put $100 into undeposited funds and you dictate where the change came from - petty cash, etc.     

@jghareeb777 

How does your DMS import the transactions into QB?  As a sales receipt or journal entry or ???

As general journal entry.  Showing the date, my dms invoice # and the sales total. 

@jghareeb777 

We have retail businesses with a similar process (journal entries imported into QB for daily sales).  We deposit the exact amount of cash sales each day so there is no discrepancy between the journal entry and the bank deposit.  In your scenario, is there a reason you deposit $100 instead of $82.87?