Adjusting the "Cash to be deposited" account

SOLVED

Hello,

I made a mistake with a deposit. I use the "cash to be deposited account" so that my transaction into the bank matches my bank statement. I followed the instructions to reverse the deposit slip and I re did another one with the corrected information.

But now I have  a negative balance in my "cash to be deposited" account and I can not adjust that account through with a journal entry.

How do I bring my cash to be deposited account back to zero?

  • 0
    SUGGESTED

    Hi FordMTL:

    To have a negative balance in the Cash to be deposited account can only occur by journal entry, a deposit slip entry or a posting through payables or receivables using the Cash to be deposited account. To adjust the cash to be deposited account just make a journal entry to clear the account. 

    Hope this helps!

  • 0 in reply to Agate

    HI Agate,

    I tried that, the 1020 account does not appear in the list of account in General journal. Like the account receivables account, seems to be locked.

    When I reversed the deposit slip by void all the payments, it reduced the Cash to be deposited account

  • +1 in reply to FordMTL
    verified answer

    FordMTL:

    Your issue has to do with your G/L account. Go to your chart of accounts in Company and open your 1020 account, then go to the Class Options tab and change the Account Class box to Bank. This should unlock the account.

    If you voided the payments, you will need to enter those payments again to restore your balances to the actual numbers.

    With Sage 50 Deposit slips generally you are basically just transferring your cash, cheques to be deposited items from the "Cash to be deposited" account to your " Bank account" to avoid having multiple lines in your "Bank account" because the deposit is generally one line on your bank statement.

    Hope this helps!

  • 0 in reply to Agate

    Hi again,

    Account class is already Bank. I thought maybe I should change it to Cash or Asset but it is a linked account and it would have removed all my saved deposit slips.

  • +1 in reply to FordMTL
    verified answer

    FordMTL:

    Eventhough the Cash to be deposited account is linked, entries can be made to this account. If a Deposit slip has been created, then it is saved and posted for eternity, unless it is cleared manually or by restrictions put into the product you are using. Deposit slips will not be removed if you change the account, they stay as they were posted.

    I hope I answered your question, if not let me know and explain with more details!

  • 0 in reply to Agate

    Thanks for your help. 

    I went into setting and changed the linked account for deposits temporarily to another account. I then was able to make my adjustment by journal entry and have since changed the linked account for deposits to my 1020

  • 0 in reply to FordMTL

    You are most welcome! Have a great day!

  • 0 in reply to FordMTL

    Hi FordMTL, if the above suggested answer helped, please do mark it as verified White check mark for the benefit of others in this forum :). Thank you!

    If you have a minute, tell us about your great experience on Sage City, take this short survey