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
  • Great Idea Currently In The Works
  • Attach files
  • Guest commented
    19 Sep 12:14pm

    PLEASE!!!! Hurry up with this.

  • Guest commented
    6 Jun 04:34pm

    Unacceptable that this feature is still not implemented. This is rock-bottom basic for every other platform.

  • Guest commented
    25 May 12:55pm

    This is already done in Quick Entries, please add to Supplier invoices

  • Guest commented
    24 May 12:09pm

    How has this not been sorted yet?

  • Guest commented
    4 Apr 01:45pm

    3 years later and we are still waiting for this...

  • Guest commented
    2 Feb 12:46pm

    Disappointing to read comments are going back over a year and a half! Which means Sage arent really going to provide this for us users!!! Im new to cloud and Im used to working with Sage desktop. Providing a "calc net" (originally F9) option is very important.

  • Guest commented
    1 Jan 03:49pm

    Great idea. It would also be useful if there was a custom calculation for mileage expenses to split out the VAT and non-VAT elements.

  • Guest commented
    26 Nov, 2022 12:08pm

    I've just migrated over from Sage50 and this might just be the single most frustrating thing that will make me NOT continue to use cloud accounting. Having looked at all the comments which go back a couple of years...how is it still not possible?

  • Guest commented
    5 Oct, 2022 09:18am

    Really miss this feature

  • Guest commented
    5 Oct, 2022 08:22am

    Surely this is a simple fix ? I have used Sage accounts happily for years. I moved to cloud due to MTD legislation more than a year and a half ago and found this to be a problem , IT IS STILL NOT FIXED!!

  • Guest commented
    15 Sep, 2022 02:49pm

    calculate net button was a great function in sage 50 that is needed in 50c. There are work around as the comments below which do work but they are a major "faff"

  • Guest commented
    6 Sep, 2022 10:12am

    Miss this feature so bad


  • Guest commented
    5 Sep, 2022 11:52am

    Calculate net feature is needed ASAP


  • Guest commented
    20 Jul, 2022 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, 2022 04:55pm

    should I enter net or gross figures in sage

  • Guest commented
    22 Feb, 2022 02:19pm

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

  • Guest commented
    22 Feb, 2022 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, 2022 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, 2022 05:04pm

    EVERYONE SEE POST BELOW ME.


    WORKED PERFECTLY


    THANK YOU



  • Guest commented
    11 Feb, 2022 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.

  • Load older comments