Skip to main content
June 27, 2022
Solved

Cash box

  • June 27, 2022
  • 2 replies
  • 0 views

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, 

Best answer by Rainflurry

@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.

2 replies

June 28, 2022

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 UserDate, 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
June 29, 2022

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

Rainflurry
June 28, 2022

@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
June 29, 2022

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

JoesemM
June 29, 2022

You're welcome, @Mebs1.

 

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