cancel
Showing results for 
Search instead for 
Did you mean: 
Loftatsea
Level 3

Finding to which account a check was deposited

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?

5 Comments 5
ReymondO
Moderator

Finding to which account a check was deposited

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.

account.PNG

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.

Loftatsea
Level 3

Finding to which account a check was deposited

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. 

RoseJillB
QuickBooks Team

Finding to which account a check was deposited

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!

Loftatsea
Level 3

Finding to which account a check was deposited

I did follow the audit trail report. It showed it went into the undeposited funds account but it does not show where it went from there. Yet, it is marked cleared in the undeposited funds ledger. 

Kurt_M
QuickBooks Team

Finding to which account a check was deposited

I appreciate you for getting back here in the thread, @Loftatsea. I'll share some insights about your concern to help you get through this situation.

 

A possible reason why it never showed where it went after posting it in your Undeposited Funds account is that you haven't made any payment yet to the transaction, or it got deleted. If this is the case, you'll want to locate the transaction and ensure it is marked as paid. You'll then proceed to deposit it, so it'll reflect in the correct account. Here's how:

 

  1. Access your QuickBooks Desktop company.
  2. Go to the Banking menu, and then select Make Deposits.
  3. Select the correct payment. You can refer on the Amount column to ensure it's the right one.
  4. Once done, click Save & Close.

 

You can also customize your audit trail report and add the name in your filters to make it easier to locate transactions that you've made with that specific customer. See this article for more information: Customize Reports.

 

In addition, I've got you this article in case you'd like to memorize a report in QBDT: Create, access and modify memorized reports.

 

You can also check this page to learn more about scheduled reports: Set up and modify Scheduled Reports.

 

We'll be more than happy to have you here again if you have any additional QuickBooks-related concerns. Take care, and have a good one!

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

Need to get in touch?

Contact us