Partner Zone

Previously imported transactions have withdrawal and deposit columns mixed up

nospi
1 Post
User
User

1Posts

0Kudos

0Solutions

Previously imported transactions have withdrawal and deposit columns mixed up

I have imported some previous records from by bank, regarding an account that is no longer accessible.

 

I have just discovered that the old data (2019-2020) has been imported with the credit/debit columns in the wrong order. I am unable to reconcile this data as it is.

 

Is it possible to adjust these entries manually, or via some sort of batch process in order to fix this?

 

I am unable to find the original data used to import, or to access it again from my bank.

 

Any help would be greatly appreciated, cheers!

1 REPLY 1
SamaraM
MYOB Moderator
983 Posts
MYOB Moderator
MYOB Moderator

983Posts

45Kudos

137Solutions

Re: Previously imported transactions have withdrawal and deposit columns mixed up

Hi @nospi 

 

Welcome to the Community Forum.

 

What you could do is export the bank transactions, then open it on Notepad or Excel and switch the data columns, so the credits and debits are in the correct columns then import it back, but chosing "If the data you are importing already exists in the company file: Update existing data", so it updates the transactions the correct way around.

 

Hope that helps.

 

If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.

Regards,
Samara

MYOB Community Support

Online Help| Forum Search| my.MYOB| Download Page

Didn't find your answer here?

Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post