MYOBCommunity
Partner Zone
|
|
Partner Zone

Payables Reconciliation out of balance

This thread is now closed to new comments.
Some of the links provided in this thread may no longer be available or relevant.
If you have a question please start a new post.
Highlighted
Experienced Cover User DiWallCT
23 Posts
Experienced Cover User
Australia
DiWallCT
Experienced Cover User

23Posts

5Kudos

0Solutions

Solved: Go to Solution

Payables Reconciliation out of balance

Hi

We have identified that our payables reconciliaton is out of balance at the EOFY by $793.18.  I have narrowed it down to 21st Sept 16 as the first day that it went out of balance and it has stayed out of balance by that same amount ever since.

I have run the Payables Reconciliation, an Account Transaction history report on the Trade Creditors Account, the Journal Security Audit to check for a date issue and have so far been able to find nothing. 

Can someone please advise how else I can go about finding this amount?

Thanks

Dianne

4 REPLIES 4
Ultimate User gavin12345
2,647 Posts
Ultimate User
Australia
gavin12345
Ultimate User

2647Posts

2029Kudos

383Solutions

Re: Payables Reconciliation out of balance

Hi @DiWallCT

 

Before spending too much time, I suggest you first check the discrepancy is not caused by a corruption to the file. To do this generate a Balance Sheet as at the end of the next financial year and see if Net Assets = Equity. If not, the discrepancy may be caused by a glitch and the file will need to be fixed by MYOB. 

 

If the accounts are balanced, I was going to say try the Support Note for identifying discrepancies. See here https://www.myob.com/au/support/accountright - however the search function does not seem to be working.

 

There is a Support Note that provides guidance for resolving Payables Reconciliation issues however I cannot locate it at present - perhaps another reader might know where to find it.

 

Regards

Gavin

Partner NikkiParsons
215 Posts
Partner
Australia
NikkiParsons

215Posts

193Kudos

16Solutions

Accepted Solution Solved Solution

Re: Payables Reconciliation out of balance

@DiWallCTFind the transaction/s which add up the the amount out of balance on the date the error occurs. Go into them and recap transaction to make sure everything is going to the right accounts, then go to their history and check the date the payment was applied. I'm guessing you might find that someone entered a payment on a future date.

 

To trouble shoot I usually run the report about 2 years ahead and see if it's resolved and work back from there to when it goes back to being out of balance. This isolates your key dates.

Experienced Cover User DiWallCT
23 Posts
Experienced Cover User
Australia
DiWallCT
Experienced Cover User

23Posts

5Kudos

0Solutions

Re: Payables Reconciliation out of balance

Thanks Gavin

I've found it now.

Experienced Cover User DiWallCT
23 Posts
Experienced Cover User
Australia
DiWallCT
Experienced Cover User

23Posts

5Kudos

0Solutions

Re: Payables Reconciliation out of balance

Thanks Nikki - this got me out of trouble - an invoice was posted in 2106 instead of 2016 so I had to go ahead a few more than 2 years but I found it eventually.  Thanks for the tip!

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