Bank statements

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.
The_Doc
Ultimate Partner
1,537 Posts
Ultimate Partner
Australia
Ultimate Partner

1,537Posts

236Kudos

162Solutions

Solved: Go to Solution

Bank statements

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

2 REPLIES 2
Haydes
MYOB Product Team
6,317 Posts
MYOB Product Team
Australia
MYOB Product Team

6,317Posts

1,107Kudos

903Solutions

Accepted Solution Solved

Re: Bank statements

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:

temp.png

Select from the list of uncleared transactions

 

You can see this in action by trying the following:

  1. Import a Bank File
  2. Click Match and then pick 1 Transaction and close down the match window.
  3. Open Reconcile Accounts and set the Statement Date & account
  4. 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.

 


Cheers,
Hayden
MYOB Product Team

Currently Working On:
Supplier Feeds | E-invoicing
In Tray
Previously Worked On:
MYOB Capture App | MYOB Invoices app
MYOB Support (2015-2019)


The_Doc
Ultimate Partner
1,537 Posts
Ultimate Partner
Australia
Ultimate Partner

1,537Posts

236Kudos

162Solutions

Re: Bank statements

Thanks Hayden - yes they had been selected as reconciled - whereas the auto generated ones - I left unticked.

 

Small things - thanks.

 

The Doc

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