Job Costing discrepancy

Mandy_9965513
Mandy_9965513 Member Posts: 11
edited April 2020 in Accounts Hosted
Help please for a novice.  When I am running a"transaction detail by account" report it is showing all items invoiced to the customer, however it is also showing a debit for one of the items which doesn't make any sens to me.

The job is entered as an estimate, then a purchase order.  When products arrive they are entered as a bill against the purchase order which is done numerous times a month however on this job it is showing this discrepancy.  I hope I am explaining myself ok as I don't really understand what is going on.  Hopefully someone can shed some light for me please.

image


Comments

  • Michelle_9656470
    Michelle_9656470 Member Posts: 31
    edited March 2019
    Drill down into that invoice (18595) and perhaps when you open the invoice and look at it properly you will see what is going on.
  • Mandy_9965513
    Mandy_9965513 Member Posts: 11
    edited March 2019
    Thanks Michelle, that is what I thought too, however it is not shedding any light on the problem, looks the same as all of my other invoices :(
  • Michelle_9656470
    Michelle_9656470 Member Posts: 31
    edited March 2019
    But there must be a description next to the line with the "debit"?  Was it perhaps a discount given?  Or an error when the invoice was prepared which created the "debit"?  Do you have a quote of something to refer back to from your sales team/the installer of the job?
  • Mandy_9965513
    Mandy_9965513 Member Posts: 11
    edited March 2019
    You would think so.  I am attaching the estimate, purchase order, invoice and bill, maybe you can see something that I can't?  I haven't experienced this before so I am at a loss.

    image
    image
    image
    image

  • Michelle_9656470
    Michelle_9656470 Member Posts: 31
    edited March 2019
    They aren't coming through clear enough for me to read when I enlarge.  You can send as attachments to my email if you like finance@rcsaustralia.com.au
  • Mandy_9965513
    Mandy_9965513 Member Posts: 11
    edited March 2019
    Will do , thanks for your help :)
  • Mandy_9965513
    Mandy_9965513 Member Posts: 11
    edited March 2019
    email has been sent from baysunrise2014@gmail.com just in case it goes to trash.
  • Adrian_6974554
    Adrian_6974554 Member Posts: 191 ✭✭
    edited March 2019
    When you are in the invoice, click on Journal. To see where Reckon is posting the components of the invoice to.

    It appears it could be something to do with the Profit Item, as all other figures equal what is on the invoice.

    Adrian
  • Graham Boast
    Graham Boast Accredited Partner Posts: 331 Accredited Partner Accredited Partner
    edited April 2020
    Hi Mandy

    I think Dorian Crete is set up as an Inventory Item, and in the Item setup the COGS/Purchase Account has been set up as "Sales" rather than "COGS".  When you sell the carpet, the Debit that should be going to the COGS Account of $644 is incorrectly going to Sales.  

    If you correct the COGS account in the item setup, upon saving it will ask you if you wish to update existing transactions. Say Yes, and the transaction should repost to the correct account.

    Graham 0409317366
    graham@reckonhelp.com.au


    Graham Boast | 0409 317366 | graham@reckonhelp.com.au

  • Kwikbooks (Professional Partner)
    Kwikbooks (Professional Partner) Member Posts: 824 ✭✭✭
    edited April 2020
    Hi Mandy

    I would check out how your items are set up, if they are set up properly for buy and sell all in the one item, and if a sale is going to an expense acct.  Also the Profit is not on your transaction report $672.40, unless you have this going to something other than sales.
  • Kwikbooks (Professional Partner)
    Kwikbooks (Professional Partner) Member Posts: 824 ✭✭✭
    edited March 2019
    Sorry Graham, we were typing at the same time, your post wasn't up when I opened the reply.
  • Mandy_9965513
    Mandy_9965513 Member Posts: 11
    edited March 2019
    Thanks everyone, will check it out when I am back in the office tomorrow.
  • Mandy_9965513
    Mandy_9965513 Member Posts: 11
    edited March 2019
    Thanks guys, problem solved, you were spot on Graham & Kwikbooks. Silly typo that I didn't notice.  Thanks for all of the help.