Bank Rec

SOLVED

I am having trouble reconciling last months bank statement due to an incorrect entry made early in the month.

We get cash from the sale of scrap metal once in a while and I tried entering it in the system a different way than I usually do thinking it would be better but it turns out its just causing me lots of headaches. First I created a vendor for the scrap metal company and went into post receipts, went to that vendor, clicked on cash, and distributed the cash to deposits. After doing this I realized that this isn't what I wanted to do and went to accounts receivable, apply deposits, and applied the amount of cash from scrap that I just entered into receipts to cancel out the transaction which seemed to work. I then entered the cash as I usually do in CM, bank transactions, and deposited the cash into a misc income account. 

Now when I try to reconcile the bank statement the deposit shows up twice and makes my outstanding balances more than they should be.

  • 0
    verified answer

    I found the answer in the BW forum Posted by "Victory" on March 22 2013:

    "Offset the deposit with a non-posting charge (assuming that your debit memo went to the GL cash account).

    CM, Enter Bank Transactions

    Transaction Type: Charge

    enter remaining info, uncheck the box to "post to GL"

    Clear the deposit and this transaction to wash from the bank rec"

  • 0

    As long as  your general ledger account is correct, you can go under "enter bank transactions" in the cash management module.   Enter a charge equal to the amount of the deposit you want to cancel out, and uncheck the "Post to G/L"  It will show up in your bank reconciliation, but won't show up in you G/L account.  But the most important part is that your G/L reflects that you canceled one of the deposits.