Purchases missing from Profit and Loss Report

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.
Experienced Cover User
24 Posts
Experienced Cover User
Experienced Cover User




Purchases missing from Profit and Loss Report

We use AccountRight Enterprise on Server 2012.  Australia Version Release 19.13.0. We use Categories - compulsory on all Transactions.  Each State is a Category (eg QLD, NSW, VIC, WA).  We use Accrual basis.


I have been working through our monthly P&L report and I have an anomaly in July 2016.


Our purchases (cost of sales) are fairly consistent each month (eg $500-600k), but for the month of July on the P&L Report, Purchases are nearly half what they normally are ($270k).  I have run a Separate purchases (cost of sales) report and it shows that Cost of Sales should be around the usual $600k.  I ran the Category Profit and Loss Report and it is the QLD Category Sales which are significantly down (ie $68000 when they should be at least $380k) to be consistent with other months.  Is there a glitch in the software??  All other months are consistent for the 12 months prior to July 2016 and for Aug & Sep 2016. I cannot figure out what is wrong! Please help as I'm very worried about our data integrity.  It is skewing the BAS for that month as well (normally we have approx $15-20k more Tax Collected than Tax Paid - which we remit to the Aust Tax Office...but July shows nearly the same amount of Tax Collected as Tax Paid due to this Purchases anomaly.

MYOB Moderator
12,768 Posts
MYOB Moderator
MYOB Moderator




Re: Purchases missing from Profit and Loss Report

Hi @Bucket_Girl


That is very unusual, my initial thoughts would be that as this is a category report, that the transactions hadn’t been tagged with a category, which would prevent the transaction from showing under the category based reports but would show under the general reports.


Are you able to run the Profit & Loss [Accrual} report, for the month in question as well as for previous months and ensure that these reports appear consistent. As the Profit & Loss accrual report is designed to pick up every single transaction in the period, regardless of whether or not the transactions had a category assigned to it.


If you are concerned about the integrity of your data file, then I recommend running a verify and an optimise on your file. The verify company file tool is designed to check your company file for errors based off a number of tests, while the optimise company file is designed to rebuild your company file and compact it down to the smallest size it can be without deleting any information.


Do let us know how you get on with this,


MYOB Community Support

Online Help| Forum Search| my.MYOB| Download Page

Did my answer help?

Mark it as a SolutionHelpful? Leave a to tell others

Didn't find your answer here?

Try using advanced search to find a post more easily Advanced Search
Get the conversation started and make a new post Start a Post