Delete old payroll in Prepare Bank Deposit

Question

There are old payrol transactions sitting in Prepare Bank Deposit. How do i remove these? I asked my book keeper and she recommended below;

"It depends how they were processed back then, and whether “undeposited funds” was classed as your payroll bank account. I think this one might be a MYOB question as I don’t want to impact your bank recon or payroll information back then… they may need access to your file to fix".

Please see pic for details.

Thanks Tanya

neil_m · Accepted Answer

Hi&nbsp;TSGTanya&nbsp;
&nbsp;
Theres only one way that those transactions can be removed from the Prepare Bank Deposits window. You would need to change the linked account for the Bank Account for Undeposited Funds.
&nbsp;
When the linked account for undeposited funds is changed it will clear out the entirety of the Prepare Bank Deposits window. The transactions assigned to the previously linked undeposited funds will still remain assigned to the account, however they will no longer be selectable through Prepare Bank Deposits.
&nbsp;
To remove the balance from the previously linked account you could use a journal entry to remove the balance. I’d recommend speaking with your accountant over how this journal entry should look

ianchait · Answer

Hi&nbsp;TSGTanya&nbsp;&nbsp;What happens if you try and process a Bank Deposit?&nbsp;

tsgtanya · Answer

I'm still yet to get around to this one. I've just checked and because these are so old i am unable to change the link account. Can i record the bank deposit and then reverse it somehow? I dont have a back up of this year either.

Thanks Tanya

tsgtanya · Answer

This is the get around from my book keeper. "Clear it out with an ABA file if you are able to. This will then bring a balance into your cheque account which I would then complete a General Journal to offset to Drawings or your Loan account. I would record a memo to say that it is - Adjustment to clear out Electronic Clearing balance from 2014. Make sure the payment date and the GJ are both the same date"

your thoughts?

tsgtanya · Answer

Hi Ian,&nbsp;If i process this bank deposit it goes into the bank but stays in the prepare bank deposit.&nbsp;See attahced after recording it.&nbsp;&nbsp;Tanya

cloverq · Answer

Hi&nbsp;TSGTanya&nbsp;
&nbsp;
It is strange that the 'Undeposited Funds' account was used in payroll transactions, as the 'Prepare Bank Deposit' function is for receiving&nbsp;money, not making payments. The equivalent&nbsp;option for making payments is Prepare Electronic Payments.&nbsp;
&nbsp;
So since the Undepsoited Funds account is not the correct account to pay wages, you can consider recording a journal entry/Spend Money/Transfer Money transaction, pay from the correct/actual bank account into the Undeposited Funds account. After that Prepare Bank Deposit will show negative amounts as well as positive amounts cancelling each other out. You can tick them all, and deposit the $0 to the actual bank account.&nbsp;
&nbsp;
The other option is as Neil mentioned, changing the current linked account for Prepare Bank Deposit. It's done via Setup &gt; Linked Accounts &gt; Accounts and Banking Accounts. The Prepare Bank Deposit window will only display transactions associated with the current linked account, so changing it to a new account will not display old history. Please note that after the change, the Undeposited Funds report will only report on the activities of the current linked account.&nbsp;
&nbsp;
If you are still having the problem of the amounts showing after ticking them and processing the bank deposit, could you please show us what's the current setup of linked accounts &gt; Accounts and Banking Accounts, as well as drill into the bank deposit transaction recorded, hit Ctrl + R to recap the transaction?

Forum Discussion

Delete old payroll in Prepare Bank Deposit

6 Replies

Related content

Prepare Bank Deposit - want to delete deposit lines listed

Prepare Bank Deposit Memo

Transactions not showing in Prepare Bank Deposit

Problem with linked account and prepare bank deposit

Undeposited Funds / Prepare Bank Deposits

Prepare Bank Deposit uncleared transactions

For partial deposit

Wrong Payroll Deposit Amount