Bank statements

Question

Hi Folks

My daughter is doing diploma accounting and she has chosen MYOB vs XERO to do her accounting on a software package - and because her dad has been doing it a while - anyway she hit a problem with the provided MYOB AccountRight 2018 data and bank statements .qif files.

She entered the data correctly and 2 entries both bank deposits (entered correctly through - receive money) when she imported the bank statement - they would not match up with these 2 entries in MYOB?

Not having much experience in bank statements - I was stumped - however by clicking the match button and letting MYOB create these 2 deposits automatically from the unmatched entries - and then deleting the 2 manual entries entered - it all worked! - daughter happy.

I was not - WHY didn't the bank statement see the 2 existing manually entered entries (the automatically created ones were identical) - ??

The Doc

Haydes · Accepted Answer

Hi @The_Doc

With Bank File imports, the general things to check are:

* The Allocation account of the transaction you want to match to.
* The Date of the transaction (Transactions dated after the latest one in the file won't show)
* If the transaction is already cleared in Reconcile Accounts

Going by your description of it being identical we can ignore the first 2 points as I'd imagine those were the first things checked.

What I would think it is would be that the transaction was cleared in Reconcile Accounts (Not reconciled, only marked). This indicates to the software that the specific transaction is "cleared" which the Window states it does not check:

Select from the list of uncleared transactions

You can see this in action by trying the following:

* Import a Bank File
* Click Match and then pick 1 Transaction and close down the match window.
* Open Reconcile Accounts and set the Statement Date & account
* Tick the transaction here and then click Cancel.

This will then disappear from the Match window when you try again.

Hope this helps answer this situation.