cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
PaulAccountfully
Level 1

Undeposited Funds Reconciliation and Listing

Hi everyone,

Long time user of QBO

 

Looking for the best way to reconcile a Company's undeposited funds at a point in time.

The logic is simple (I just need to see all received payments that have not been attached to a deposit at a point in time), but can become a grueling excel exercised depending how well data is maintained.

QBO links these received payments/deposits together behind the scenes, so Im hopeful that theres a way that QBO can tell me all received payments that have not yet been deposited (at a point in time).

The deposit screen sort of does it, but not helpful if Im trying to backdate nor can I download/reconcile with the screen

2 Comments 2
JamesAndrewM
Moderator

Undeposited Funds Reconciliation and Listing

Thanks for posting here in the Community, Paul. I'd be happy to share the guidelines to help with your reconciliation.

 

Since we're unable to reconcile an Undeposited Funds account because it functions differently from other accounts we see on the reconciliation page. With that, I suggest you check it in your UF and deposit that transaction, you can then proceed to reconcile them. When we reconcile an account, we compare the bank statement (cleared and deposited) to what is in QuickBooks for a specific time period. 

 

To review and manually reconcile the Undeposited Funds account, we can follow these steps:

 

  1. Go to the Accounting menu.
  2. Select Chart of accounts.
  3. Find Undeposited Funds on the list.
  4. Select View register.

 

You can utilize these articles so you can deposit these payments to their corresponding bank accounts first. Next, you can reconcile the bank to which you deposited the funds. You can follow the workflow here:

 

 

You can visit this article to know the specific ways to customize your reports: Common custom reports in QuickBooks Online.

 

If you have any further concerns, don't hesitate to post them here. Have a great day!

PaulAccountfully
Level 1

Undeposited Funds Reconciliation and Listing

Thank you so much for your reply.

COA->Undeposited Funds -> View Register appears to be the best way to identify undeposited funds as of today.

The issue I am running into is trying to furnish this information historically for audit support.

Any ideas there? Thanks again!

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us