Entering negative adjustments on an invoice

Amy MartellAmy Martell Member Posts: 1
edited August 15 in Reckon One
In Reckon One, is there a facility to enter an expense in an invoice to show a reduced amount of the invoice?  For example, the sale of livestock is the gross amount of the sale, then the selling agent deducts selling costs, marketing, freight etc before remitting the net amount to the client.  There doesn't seem to be a way to enter an expense onto an invoice to show a reduced amount of the invoice that would be expected on the bank feed.

Comments

  • Kwikbooks (Professional Partner)Kwikbooks (Professional Partner) Member Posts: 876
    edited August 15
    Hi Amy 

    Yes there is, on the invoice enter sale as usual with item number, then next line use the "account" not the "item" , chose the account i.e agent costs  or freight etc, type description i.e less agent costs and in the amount enter minus figure i.e -25.00 ... go to next line and repeat for freight etc.

    Kim:  0429 305300  e: [email protected]
  • SpillySpilly Member Posts: 212
    edited August 15
    stock agent would be supplying an tax invoice for their services? So the correct way to account for this would be a tax invoice to them, a bill from them and allow AR & AP accounts to track their balance.

    If your dealing with GST on the services, I think that is the only way to deal with it however money not changing hands will make bank transactions not match up.

    Another work around would be Invoice the full amount not less their fees (eg $2500), 'Receive Payment' on Invoice (eg $2500 - $500 for services) select 'use balance of selected items' > tick Debtors/Creditors & Cash Receipt in the Cash Receipts section select Expense Account enter the amount -$500.00

    That should give you a rough idea.
  • SpillySpilly Member Posts: 212
    edited July 2015
    Kim, negatives cannot be entered on invoices. I guess that's an oversight like many other things.
  • Kwikbooks (Professional Partner)Kwikbooks (Professional Partner) Member Posts: 876
    edited December 2016
    Mmmm just did it, it came up with a -25.00 on the invoice total
  • Kwikbooks (Professional Partner)Kwikbooks (Professional Partner) Member Posts: 876
    edited April 11
    Even thought I just did a -invoice, what about using a credit adjustment, invoice the full amount then raise a credit for agent fees to the agent exp account and freight etc. then apply the credit adj.
  • SpillySpilly Member Posts: 212
    edited July 2015
    lol, your right, i accidentally logged into the silverlight version in which you can not enter negative numbers on invoices.
  • SpillySpilly Member Posts: 212
    edited August 15
    credit adjustment will not align the expense to an expense account.
  • SpillySpilly Member Posts: 212
    edited July 2015
    I guess the OP must of done the same.
  • Kwikbooks (Professional Partner)Kwikbooks (Professional Partner) Member Posts: 876
    edited April 11
    I just did a credit adjustment using bank charges, I called up the credit adjustment, used an existing customer, used account bank charges, description agent fees $100 and it saved the credit adjustment to bank charges.  It should do the same for all expense accounts set up.
  • Kwikbooks (Professional Partner)Kwikbooks (Professional Partner) Member Posts: 876
    edited April 11
    Hi Amy

    Hang in there we will get this sorted for you :)
  • Robyn Kelly (Partner)Robyn Kelly (Partner) Accredited Partner Posts: 430 ✭✭
    edited April 11
    What tax code are you using for the expense as this is where I think the problem is? It is not possible at the moment to do this transaction properly to appear on the BAS correctly. I have reported this to Reckon. Regards Robyn Kelly
  • Kwikbooks (Professional Partner)Kwikbooks (Professional Partner) Member Posts: 876
    edited December 2016
    Invoices will never take NCG the work around is GST as I told Amy, reports at 1A on bas as a credit, but still has same effect of reducing the amount owed to ATO
  • JodieJodie Member Posts: 42
    edited April 1
    Hi I have tried putting negative in invoice but it will not let me says amount must be greater than 0, using reckon one Thanks
Sign In or Register to comment.