Do you ever find yourself adding up numbers on a calculator to derive a correct figure to then enter into a Xero invoice or manual journal?
When entering numerical data to specific fields in Xero, it recognises the key arithmetic functions of addition, subtraction, multiplication and addition. It even recognises brackets to allow for more complicated calculations concerning the order of operations.
In transactions such as invoices, you can enter a basic arithmetic operation into the fields Quantity, Unit Price and Discount. Xero calculates the result when you press Enter or Tab.
Use the inbuilt calculator in manual journals:
You can also use the inbuilt calculator in the debit and credit fields in manual journals.
If you make a typo, a red box will appear around the field, giving you a chance to fix things up or, if you try and tab out again, the value that was in the field previously will be returned.
You can use brackets and *, /, + or -, and your formula can be as complex as you like.
Remember, Xero uses BODMAS principles: this is the same order in which Excel performs calculations.
See all the Xero features that can help you run your business beautifully at Xero.com/features
February 2017 – Customise The Dashboard In Xero
January 2017 – Customisable New Reports In Xero
December 2016 – Email Templates In Xero
November 2016 – Bank Rules In Xero
October 2016 – Smart Lists In Xero
September 2016 – Files in Xero
August 2016 – Direct Bank Feeds In Xero
July 2016 – Managing Bills and Purchases in Xero
June 2016 – Shortcuts In Xero
May 2016 – Email Integration
April 2016 – Recurring Sales Invoices
March 2016 – Two Step Authentication
February 2016 – Xero Search
January 2016 – File Storage in Xero
December 2015 – Invoice Reminders
November 2015 – Xero on the go, with Xero Touch
October 2015 – Invoice Payment Terms
September 2015 – Sales Invoice Customisation
August 2015 – Business Performance Review
July 2015 – Cash Coding In Xero
June 2015 – Xero to Xero Billing
May 2015 – Find and Recode
April 2015 – Online Invoicing