Skip to main content
L
Loftatsea
December 17, 2022
Question

Finding to which account a check was deposited

  • December 17, 2022
  • 1 reply
  • 0 views

I am reconciling my checking account. There is a deposit on my account statement that is different from what I have recorded in QB desktop. The difference is one check that I do have a record of receiving and it is credited to the correct customer. However I do not see this check in the make deposits window. It initially went to undeposited funds account. From there I do not know where it went. How do I find out to which account this check was deposited?

1 reply

R
ReymondO
December 18, 2022

Let me help you locate where you check was deposited to, @Loftatsea.

 

You can run an Audit Trail report to review all of your transactions made inside QuickBooks Desktop (QBDT).

 

Here's how:

 

  1. Click Reports at the top menu bar and choose Account & Taxes.
  2. Select Audit Trail.
  3. On the report screen, look for the check transaction.
  4. You should see the account where it was deposited under the Account column.
  5. Double-click the amount to view its details.

We can also utilize the customization feature in the program to easily locate the check. For additional guide and related resources, please check out these articles: 

 

 

As always, you can add a reply to this thread if you have any follow up questions. You can also share us an update about the result of the steps above. Take care.

L
LoftatseaAuthor
December 18, 2022

Your suggestion shows me it went from to undeposited funds account from the customer payment window. I need to know to which account it went from the undeposited funds account. 

R
RoseJillB
December 18, 2022

Thanks for getting back, @Loftatsea.

 

My colleague above is correct about utilizing the Audit Trail report. This report posts all the activity and changes in your company file. It includes the Deposit made and the account where it is posted. 

 

With that, you can follow the steps outlined by ReymondO and check the posting account under the Account column of the report.


Additionally, when creating a sale or money in transactions, the default account will be Account Receivable (A/R). That said, when you create the transaction, it will be automatically posted on the A/R account. When you enter the payments into your company file, the payment will be posted to the Undeposited Funds. Then, move to your preferred account after Deposited.

 

Otherwise, you can pull up another report specific to the deposits made to your account. You'll want to customize this according to the information you want to show. Here's how:

 

  1. Go to the Reports menu. 
  2. Select the Banking tab.
  3. Choose the Deposit Detail report.
  4. Click Customize Report.
  5. On the Display tab, select the columns you'd like to see on the report.
  6. Click the Filter tab to choose the customers and date you'd like to see.
  7. Once done, click on OK.

 

To know more on how to personalize reports in QuickBooks Desktop, please see this article: Customize Reports.

 

You can also check out this article to learn what you can do about your deposits: Record and Make Bank Deposits.

 

Additionally, I've added an article that'll help you save the current customized setting of the report. This allows you to access them in the future quickly: Memorized Reports.

 

Feel free to drop by if you have more questions about posting an account of your transactions. I'm just a few clicks away. Have a good one!

Terms & ConditionsAccessibility statement