Problem with the Job Profitability Detail Report & Open Orders Report
First timer here ;)
I have run the job profitability report for one specific job and it is showing an amount of $134,789.28 at Act.Cost. It should be $269,578.55 which is the amount of the bills receipted for this job. It is only showing exactly half the amount. The strange thing is that the Sales Order for this same job is showing is showing an open balance of $157,482.34, but in reality it is only $120,822.84 that still needs to be invoiced.
Please help !
Adie
Best Answer
-
Hi @Adie
Welcome to the forum!
The job profitability reports are quite comprehensive.
The "Act Cost" for stock Items is determined by the Item's quantity, multiplied by the most recent (Bill) cost price, in relation to each sale (invoice) of it.
If we look at this one for instance:
The drill down shows this:
HOWEVER, although the cost column displays an invoice, this isn't actually the amount invoiced:
Instead, it's the value of that particular Item at the point it was sold:
In your company file Preferences, (accessed via the Edit dropdown menu along the top toolbar) you can specify if you want only on-hand or also qtys reserved for builds & on Sales Orders taken into account:
Your selection here will therefore also impact the qty considered for the "profitability" value.
Hope that makes sense ! π
Shaz Hughes Dip(Fin) ACQ NSW, MICB
*** Reckon Accredited Partner (AP) Bookkeeper - specialising EXCLUSIVELY in Reckon Accounts / Hosted ! ***
* Regd BAS Agent (No: 92314 015)* ICB-Certified Bookkeeper* Snr Seasonal Tax Consultant since 2003 *
Accounted 4 Bookkeeping Services
Ballajura, WA
(NB: Please give my post a Like or mark as Accepted Answer if I have been able to resolve your query as this helps others when seeking solutions!)
2
Answers
-
Thank you so much for responding to my query and going into such a detailed explanation. Explains everything.
0 -
Good to hear Adie βΊοΈ
Shaz Hughes Dip(Fin) ACQ NSW, MICB
*** Reckon Accredited Partner (AP) Bookkeeper - specialising EXCLUSIVELY in Reckon Accounts / Hosted ! ***
* Regd BAS Agent (No: 92314 015)* ICB-Certified Bookkeeper* Snr Seasonal Tax Consultant since 2003 *
Accounted 4 Bookkeeping Services
Ballajura, WA
(NB: Please give my post a Like or mark as Accepted Answer if I have been able to resolve your query as this helps others when seeking solutions!)
1
Categories
- All Categories
- 6.7K Accounts Hosted
- 16 π’ Reckon Accounts Hosted - Announcements
- 6K Reckon Accounts (Desktop)
- 7 π’ Reckon Accounts Desktop - Announcements
- 1.4K Reckon Payroll
- 34 π’ Reckon Payroll - Announcements
- 15 Reckon Payroll Help Videos π₯
- 25 Reckon Mate App
- 2.6K Reckon One
- 10 π’ Reckon One - Announcements
- 12 Reckon Invoices App
- 15 Reckon Insights
- 99 Reckon API
- 308 Point of Sale
- 1.9K Personal Plus and Home & Business
- 74 About Reckon Community