Accounting Ideas

Calculate net from gross

I'd like to enter gross (tax inclusive) values, and have Accounting work out the net value automatically, in invoicing and quick entries. Sage 50 has this feature when posting in the sales and purchase ledger.

  • Guest
  • Nov 23 2019
  • Love This Idea Likely To Be Coming Your Way
  • Attach files
  • Guest commented
    20 Jul 02:30pm

    Oh no! We've just recently changed from SAP to Sage Business Cloud Accounting. There was a feature in the settings on SAP that allowed you to choose whether you wanted to input transactions Gross to Net or Net to Gross. I'm concerned that this was first muted in June 2021 and yet this feature has not yet been added a year later. It is so time consuming having to calculate the net on an invoice where the breakdown isn't available on the invoice/document received. Please please please change this and let us know a) if you will be changing it b) a timeframe we can expect a change to take place as I can see this becoming very frustrating. We have only started using this product. I have only migrated some of our clients over at the minute but this is something that would really grate on me so much that it would put me off using the software completely and not migrate the rest of our clients. Please give some feedback on this at your earliest convenience. Thank you.


  • Guest commented
    27 Apr 04:55pm

    should I enter net or gross figures in sage

  • Guest commented
    22 Feb 02:19pm

    yes this is definitely needed, commonly available in quickbooks and big red cloud. should be an easy fix

  • Guest commented
    22 Feb 08:04am

    This can be done but only when processing Other Payments or Receipts in Sage Business Cloud Accounting - not for Invoices

    Simply select your VAT rate and then pop your total on the line and the net and VAT amounts will be calculated.


    Just be sure to also pop the total transaction value in the top right of your transaction window or you will be unable to save it.

  • Guest commented
    20 Feb 06:56pm

    Tried to do this but will not let me enter a figure in the end column. It stays blue.


  • Guest commented
    15 Feb 05:04pm

    EVERYONE SEE POST BELOW ME.


    WORKED PERFECTLY


    THANK YOU



  • Guest commented
    11 Feb 01:07pm

    HI all, I have discovered that if you set the VAT rate you want and leave the Net at zero. Input your gross figure in the end total box and it will then calc the net and Vat back for you.

  • Guest commented
    11 Feb 12:59pm

    GET A CALC NET BUTTON ASAP!!!!

  • Guest commented
    9 Feb 09:24pm

    Also I agree calculate net button is needed of a short cut to calculate the net on sage business online. I miss it from Sage 50.

  • Guest commented
    31 Jan 02:17pm

    I’ve just joined Sage from QB. I cannot believe I’m going to have to work out the net vat for every single invoice! Not ideal when I’ve joined 9 months into the financial year and have to put all invoices on here! How can this not be a feature???

  • Guest commented
    5 Jan 03:30pm

    Not normal to have to calculate manually when we pay for a software that should do such a basic feature for us. Please add this ASAP.

  • Guest commented
    22 Nov, 2021 04:28pm

    Please make a calc net button. Makes no sense not to have this.... pain pain pain.

  • Guest commented
    28 Sep, 2021 09:45am

    The sooner the better, its a shame this was not considered when the software was upgraded previously.

  • Guest commented
    27 Sep, 2021 09:11pm
    Excellent idea, I've always thought of how inconvenient this is but never thought to suggest as an idea. Great!
  • Guest commented
    27 Sep, 2021 08:16pm

    Great idea and will speed things up.

  • Guest commented
    8 Sep, 2021 10:17am

    Having migrated from Sage 50 I am bewildered why something as basic as calculating the net amount from the gross is not a function! A huge step backwards in my opinion! Having to manually calculate this before I can do entries is very time consuming and not at all what I expected to have to do when I thought I was updating my Sage package. Please look to resolve this.

  • Guest commented
    5 Aug, 2021 03:19pm

    Being a retail company our prices are always displayed as gross and it's a massive issue for a small business like us to have to manually calculate this on all invoices. We have used Sage for years and have always had this facility. Why has this option now been taken away - doesn't make sense at all. Also need calculate net on banking (other payments). Please let us have this feature back as a matter of urgency.

  • Guest commented
    16 Jul, 2021 11:41am

    Yes id like this too, I have to do the calc when I pay for software to do to for me.

  • Guest commented
    13 Jul, 2021 02:55pm

    I cannot believe this is not a function in sageone. Sage tell me that people don't enter the invoices like this. I pointed out that most retail business work out the sales this way.

  • Guest commented
    1 Jul, 2021 11:18am

    Really need the Calc nett - T9 button back!

  • Load older comments