Jobs [Budget Analysis]
This report still has a number of errors or bugs
Back Ground – How we use this report
When we price a house we have 120 Purchase Orders, the collective value of which makes up the Build Cost of the House.
The Purchase Order number incorporates the same number as the respective Cost of Sale code within the Chart of accounts within the 5000 series but prefixed by the Job number also generated thru MYOB.
For example – Roof, which has a code is 5-0134 within our Cost of Sale Chart of Accounts looks like this on our PO Order 8020/0134. (JobNo / CostCentre)
This amount then becomes our cost (budget) and is entered into MYOB Jobs / Budgets.
When the invoices arrive and are entered thru Purchases the collective value of all the invoices using the MYOB Code 5-0134 makes up the cost price of the roof (Actual).
The Jobs [Budget Analysis] report then shows the variance (Budget v Actual) and this Variance is the important information to us. We want 0% variance. We will generally allow a 1.25% variance but if the variance is greater we need to investigate to ensure that the Trade / Supplier is not tucking us or that we have not made an error in our calculations.
This is our Back Costing process and is an extremely important tool for us. This is where we look to see if we are on track and are making or losing money.
Problems with the Report
Even after the recent upgrade bugs still exists.
- If no budget amount is entered into respective cost code but an invoice is subsequently entered against the code – the cost code will not appear in the report.
- To correct this we go back into the budget and enter .01c. The report then shows as
Cost Centre Budget Actual Variance %Var
Concrete Paths $0.01 $11,974.96 $11,974.95 119,749,500.0%
- If we then go back into Budgets and remove that .01 c the report corrects itself and looks like this
Cost Centre Budget Actual Variance %Var
Concrete Paths $0.00 $11,974.96 $11,974.95 NA
What we presently have to do is enter .01c into every Cost centre that does not have a budget amount allocated to it to ensure that it appears in the report. This is important because if an invoice is entered via Purchases and it is unbudgeted this report has to show the amount and variance.
Have attached 2 pdf showing the examples of the issues above.
Here from you soon.
Garry
- Nic-acc-addons12 years agoSuper Partner
Hi Garry,
It sounds by the looks of it that you are using MYOB AccountRight Live 2013. If you are using AccountRight 19.9 or lower, our product should be able to produce the report you require using the data from MYOB.
If you are on AccountRight Live 2013, i suggest you give our product a try or keep it on the back of your mind as we should be able to produce your report very shortly (the job API has recently been added to MYOB).
While this may mean additional costs, we can actually tailor a report to suit your exact requirements (formats, display, columns, etc.).
Feel free to contact us to discuss further.
Best of luck.
Nic
Lead Developer at Accounting Addons
Visit us at http://accountingaddons.com.au
Phone us on 1300 ADDONS (1300 233667) - CompassHomes12 years agoCover User
Nic
Thans for your response
Yes we are using MYOB AccountRight Live 2013. We have 6 Licenses, 3 of which are actually building Companies requiring this report.
Have you any idea of the time frame, to have this report available. You mentioned additional costs, is that a cost we have to pay ... and two how or who do we contact to have this report actually tailoured to suit our needs. Can I have email address as a contact.
Thanks
Garry
- Nic-acc-addons11 years agoSuper Partner
Hi Garry,
You can email me at nic@accountingaddons.com.au.
There could be costs you would have to pay for the customisation/consulting to build and tailor your report. There may also be costs to purchase the product but it is possible this would fall under functionality available in the free platform.
The first step would be to have a more thorough discussion of what you need so we can clarify the costs side of things.
Nic
- Mark_Smith11 years agoFormer StaffStatus changed:NewtoOpenThanks SummitHomes - sorry you're doing workarounds to get an awkward figure out in variance. Folks - please vote this up if you would like to see it. Thanks Nic for sending through the details of your addon. Great to hear you're looking at the new jobs API.
- Dacroconst11 years agoCover User
I have been emailing MYOB regarding the same issue as "Compass" above, for over 12mths trying to get a fix. The response I get from MYOB is that this issue is not important & basically will not become important until such time as there is enough votes, in this forum, to warrant them doing something. I also wonder how many companies are useing the budget reporst without knowing of the error. Unless you actually analise the report you wouldn't realise the issue. A cursorary glance would see it
Please vote to get this fixed
Regards
Darren
Related Content
- 4 years ago
- 2 years ago
- 4 years ago
- 5 years ago
- 2 years ago