Jump to content
Sign in to follow this  

Undeposited Funds Mess

Recommended Posts

Hi Guys, 

I've been freelancing for a few months now and need some help with a new client. I'm working on his 2017 write up to file taxes by September. However, I came across his UF account and it is a mess. Income is overstated because they are reporting to AR, UF and also to service income accounts. I would like some help clearing his Undeposited funds account, but have come into a road block as to how to go about it. His CPA never reconciled correctly, he just created year end JE lol. Now I must identify which payments were actually applied to the invoice and which are duplicates. This is difficult because I'm working on QBO and customer pay using Intuit Merchant Services, which should be easy because the payments are linked to the invoices. 

The way I was doing it [but questioned my process] is to open the Undeposited Fund report from the Balance Sheet and identify which deposit is split between the bank [checking account] to UF account. Open it and on the "Add funds" section apply the negative amount to AR. Is this correct? 

Do you have any tips on how to run through this process in an easy an efficient way? 

Share this post

Link to post
Share on other sites

Wow nothing worse than starting to do a client's bookkeeping that is messed up from the getgo. Hopefully you can get it all cleared up for them. Funny his CPA never reconciled correctly, you may want to bring this to the attention of your client so he can deal with that. Have you talked to your client about the mess you've found?

As for how to process all the Undeposited Funds, I'm not a bookkeeper myself so not quite sure what you would do. Hopefully someone with that skillset will chime in :)


Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Want to Become a VA?
    Invest in The VAC!
    How Do YOU Startup A

    Are You a VAinsider?
    Virtual Assistant Organization Association
    Upgrade Your FREE Account & Receive Today...
    * Access to Our Job Board *
    * VA Training Tracks*
    * Group Coaching *
    * Private Mastermind Area *
    * Business Templates *
    * Contracts & Forms*
    *Checklist & eBooks *
    * Seminar Archives *
    * Plus VAinsider Perks! *

    Virtual Assistant Organization Association

    HootSuite - Social Media Dashboard

    Affordable online backup for your small business

    Click to see your AD here!

    Cool Virtual Assistant of the month!


Important Information

By using this site, you agree to our Terms of Use.