Results 1 to 7 of 7

Thread: Quickbooks undeposited funds

  1. #1
    New Member
    Join Date
    Oct 2011
    Location
    Jhb
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Quickbooks undeposited funds

    Morning all,

    silly question, im usin QB pro 2012, when pulling a BS for the 2012 year in my current assets an accoount called undeposuted funds pops up.
    Ive gone to the make /recieve deposits window but there are no deposited to be deposited.
    Ive tried to change the account in my chart of accounts to move each individual entry to the bank account, but it says i must delete the payment from the deposit before i can change this. there are well over 250 entries, would i have to do this each one individually?
    Either way want to get rid of the undeposited funds account and avoid having this problem again next year.

    Please help

  2. #2
    Gold Member
    Join Date
    Mar 2012
    Location
    Vanderbijlpark
    Posts
    886
    Thanks
    83
    Thanked 381 Times in 298 Posts
    1) Do the funds actually exist? I ask because they are what they say......
    2) Undeposited funds in Quickbooks arise from:
    2.1) debtor receipts that are allocated to that account instead of bank or whatever. Check your Receive Payments screen and allocate the receipts to your bank account in future.
    2.2) Cash sales processed via Sales Receipts. If you look at the bottom of the screen you will see "Deposit to" which defaults to Undeposited Funds.
    3) There are two ways to sort this:
    3.1) Go Banking, Make Deposits and the list of entries to the undeposited funds account will immediately come up. Select the items that were deposited.
    3.2)You can process a journal entry, payment or whatever against the account to correct it. But the real question is of course "where is the money"?

    If the funds do not exist, someone has utilised them, or swiped them.

  3. #3
    Site Caretaker Dave A's Avatar
    Join Date
    May 2006
    Location
    Durban, South Africa
    Posts
    20,981
    Thanks
    3,056
    Thanked 2,463 Times in 2,068 Posts
    Blog Entries
    12
    Check the register for the undeposited funds account. What was the balance at the end of the day 29 Feb 2012?
    You might have received a payment or more, and only deposited the funds on 1st March or later.

    (In which case there's no problem to fix here)

    If the undeposited funds account is not being used properly and that's the problem, then fix the problem by using it the way you should. But I don't recommend you clear and delete the account - it is a special account in terms of Quickbooks functionality.
    The trouble with opportunity is it normally comes dressed up as work.

  4. #4
    New Member
    Join Date
    Oct 2011
    Location
    Jhb
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Yes Dave that seems to have been the problem that there were funds deposited after year end, so undeposited funds still at that point undeposited.
    As of today, my undeposited funds are the amounts that are in fact undeposited, so the account is being used right.
    My biggest problem comes now when requesting the BS as year-end Feb 2012 that whack load of undeposited funds sit under cash at hand, those were just deposited late but are in fact applicable to the 2012 year end. My customer balances are correct, it just seems the deposit dates were wrong.

    When doing financials how do I explain to the CA the undeposited funds at that point and where she should allocate them or add then to the accounts receivable?
    What confuses me more is that these undeposited funds are a negative amount, so with the balance of the cash at hand it changes my actual balance because this is in fact not correct.

    IM reading this and thinking heavens you are not making sense... sigh... I think I might have to revert to a QuickBooks software specialist to come fix these date errors, because I don’t know where to tell the CA the undeposited funds should go when she asks me what they are doing on the balance sheet..

  5. #5
    Site Caretaker Dave A's Avatar
    Join Date
    May 2006
    Location
    Durban, South Africa
    Posts
    20,981
    Thanks
    3,056
    Thanked 2,463 Times in 2,068 Posts
    Blog Entries
    12
    Quote Originally Posted by Tatia View Post
    Yes Dave that seems to have been the problem that there were funds deposited after year end, so undeposited funds still at that point undeposited.
    OK - let's try to get on the same page with this one - and to do so we'd better differentiate between payments and deposits.

    Were there payments received in the 2012 financial year that were only deposited into the bank account in the next financial year?
    The trouble with opportunity is it normally comes dressed up as work.

  6. #6
    New Member
    Join Date
    Oct 2011
    Location
    Jhb
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Yes Dave that Is correct, so the undeposited funds relate to the 2012 tax year. They now appear on the BS as undeposited funds instead of accounts receivable.

  7. #7
    Site Caretaker Dave A's Avatar
    Join Date
    May 2006
    Location
    Durban, South Africa
    Posts
    20,981
    Thanks
    3,056
    Thanked 2,463 Times in 2,068 Posts
    Blog Entries
    12
    Tatia, just present it to the CA as is. Effectively "cash on hand" is "cash and other receivables", and that is probably where it will be recorded when the financial statements are drawn up.
    The trouble with opportunity is it normally comes dressed up as work.

Similar Threads

  1. [Question] Are funds from abroad taxable?
    By cybersangoma in forum General Business Forum
    Replies: 5
    Last Post: 04-Apr-12, 01:11 PM
  2. [Question] Emmigration Funds (Business & Personal)
    By deetee in forum General Business Forum
    Replies: 2
    Last Post: 15-Jun-11, 08:15 AM
  3. Pension funds and investment advisors
    By Dave A in forum Business Finance Forum
    Replies: 0
    Last Post: 27-Jul-09, 09:57 PM
  4. [Opinion] Allan Gray Funds
    By anakin in forum General Business Forum
    Replies: 5
    Last Post: 17-Jul-08, 04:50 PM

Did you like this article? Share it with your favourite social network.

Did you like this article? Share it with your favourite social network.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •