Skip to main content
Jun 27, 2022 10:03 PM UTC
Solved

Cash box

Hello Everyone,

 

I have a little issue with my client's cash box. All transactions made in cash are entered as sales receipt, 'cash' selected, put in the 'undeposited funds' account.

Every month I pull out a report of those transactions to see the details and make sure that the total corresponds to the cash they have. This month it was not correct, there was less cash than what was entered in QBO.

I checked with the agent responsible and did not find the mistake.

How do I enter that when the deposit appears in the bank feed? Some cash transactions will not be matched..

 

Thank you, 

Rainflurry
Jun 28, 2022 6:32 PM UTC

@Mebs1 

 

When you have cash discrepancies, use a cash over/short expense account.  Create one if you don't have one.  Then, post discrepancies to that account to track them.

5 replies

Jun 28, 2022 12:23 AM UTC

Thank you for reaching out to us here in the Community, @Mebs1.

 

I'll help you find and match bank feed transactions with QuickBooks Online(QBO).

 

QBO has an Audit Log feature that records all the changes made on a specific transaction. It lists each accounting transaction and any additions, deletions, or modifications that affect that transaction and who made such changes.

 

I recommend checking for deleted transactions. Compare it with your bank feed.

 

Here's how:

 

  1. To access the audit log, sign in as an administrator. If you can't find it, ask your primary admin.
  2. Click Settings, then choose Audit Log.
  3. Select Filter.
  4. To limit the results, select the appropriate User, Date, or Events filter using the options on the Filter screen.
  5. Choose Apply.

 

If you can't find one, you can follow the steps to add a transaction that would match your bank feed.

 

You can also undo or unmatch a transaction if you need to alter it or move it to another account. Before your monthly reconciliations, make all necessary revisions.

 

Let me know if you have additional questions about matching your bank transactions with your QBO account. I'm always here to help.

Mebs1Author
Jun 29, 2022 7:51 PM UTC

thank you for your help, I will take a look!

Rainflurry
Jun 28, 2022 6:32 PM UTC

@Mebs1 

 

When you have cash discrepancies, use a cash over/short expense account.  Create one if you don't have one.  Then, post discrepancies to that account to track them.

Mebs1Author
Jun 29, 2022 7:52 PM UTC

Thank you for you help, I remember seeing an article about that. Your comment reassures me into taking this step.

JoesemM
Jun 29, 2022 8:12 PM UTC

You're welcome, @Mebs1.

 

If you have any other concerns, please let us know. We're always here to help. Have a great day.