Forum Discussion

nospi's avatar
nospi
3 years ago

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!

  • SamaraM's avatar
    SamaraM
    Former Staff
    3 years ago

    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.

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.

 

Related content