Problem with the Job Profitability Detail Report & Open Orders Report

Adie
Adie Member Posts: 2 Novice Member Novice Member

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

  • Acctd4
    Acctd4 Accredited Partner Posts: 3,731 Reckon Accounts Hosted Elite Expert Reckon Accounts Hosted Expert
    edited October 1 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

    shaz@accounted4.com.au

    https://accounted4.com.au

    (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!)

Answers

  • Adie
    Adie Member Posts: 2 Novice Member Novice Member

    Thank you so much for responding to my query and going into such a detailed explanation. Explains everything.

  • Acctd4
    Acctd4 Accredited Partner Posts: 3,731 Reckon Accounts Hosted Elite Expert Reckon Accounts Hosted Expert

    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

    shaz@accounted4.com.au

    https://accounted4.com.au

    (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!)