cancel
Showing results for 
Search instead for 
Did you mean: 
graphicsetc
Level 1

How do I locate how a transaction was entered by the dollar amount?

On December 1, 2021 I received an ACH Deposit for a SBA Targeted EIDL Advance of $7,000. I'm sure at the time I wasn't sure how to post this in Quickbooks online and reached out for help in doin so. Here is my problem. I was reconciling my bank statement from 12/2021 and the deposit of $7,000 doesn't show up in my check register anywhere that I can find it, but my checking account balance in Quickbooks online matches what I have in the bank. Which would mean that I entered this transaction somewhere but can't find it and can't finish reconciling. I could make 2 journal entries that would cancel each other out, but thought it best to actually know what I did at the time. Can anyone help me with this problem?
3 Comments 3
JessT
Moderator

How do I locate how a transaction was entered by the dollar amount?

Hi graphicsetc,

 

You can search the transaction by amount. QBO has an Advanced search option where you can just search transactions by the amount.

 

 

Please note that if a transaction is already showing an R (reconciled) mark in the bank register, it will no longer appear in any future reconciliations. Please check it in your bank register to find out.

 

You can go back to this thread if you need more help.

graphicsetc
Level 1

How do I locate how a transaction was entered by the dollar amount?

I have already used the advanced search and looked in my bank account and journal entries for that dollar amount and nothing comes up when I search. Is there any other way to find that amount within QBO? If it had not been entered somehow within QBO then my balance at the bank would show $7000 more than my balance in QBO, but it doesn't. The two balances are the same which means that $7000 was entered into QBO, correct? If I can't find where it is or how it was entered, can I create a Journal Entry which will allow me to reconcile my 12/2022 bank statement?

GlinetteC
Moderator

How do I locate how a transaction was entered by the dollar amount?

I've got other options to locate the transaction, graphicsetc.

 

You can use the Audit log feature to find the transaction. Using the option, you can keep track of added, deleted, and modified transactions, as well as user entries. Here are the steps:

 

  1. Go to Settings.
  2. Select Audit Log.
  3. From the Filter ▼ dropdown menu, select the appropriate user, date, and event(s).
  4. Select Apply.

 

Another way is to run a specific report and customize it to the data needed. 

 

Get back to this thread if you have follow-up questions. The Community is here to help.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us