Previously imported transactions have withdrawal and deposit columns mixed up

This thread is now closed to new comments.
Some of the links and information provided in this thread may no longer be available or relevant.
If you have a question please start a new post.
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
1,925 Posts
Former Staff
Former Staff

1,925Posts

0Kudos

236Solutions

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