How to automatically round variances in your bill data

How to automatically round variances in your bill data

Automatic Rounding

From time to time, Rounding variances can exist between how Lightyear calculates unit prices and tax on product Bills (4 decimal places, calculate unit price and tax on the rows and then total these) and how suppliers may have calculated their tax or may have rounded to a different number of decimals.  Annoying, hey ?!

Luckily Lightyear can automatically resolve any tax or total variances with ONE CLICK!  Watch the video or read more to learn how....




Warning Flags

Lightyear extracts the values from a bills footer and also calculates values in panel 2 based on lightyears rounding logic.  If there is a variance is detected we will flag this to you , via the below icons:


You then have a couple of options:
  1. Ignore the warning flag by clicking the Grey 'Bell' Icon. This will simply cancel the warning flag.  Note - The grey icon will still be visible to show that someone at some point has elected to ignore the warning flag. 
  2. Automatically Add a rounding Row by clicking the red 'Bell' Icon: 
    1. For 'Total' this will add a row tax free to adjust the overall bill total to match the total which was extracted from the footer of the Bill. 
    2. For 'Tax' this will add 2 rows, one taxable and one tax free, to adjust the tax component of the total without adjusting the actual total of the bill
  3. Lightyear uses the default Rounding GL code and the default tax and tax free rates from your Accounting Supplier Settings. 




And that's it!  With one click, your rounding adjustment are automatically calculated and adjusted.  

IMPORTANT!  Setting up Default Rounding GL/Nominal Code

For rounding to work correctly, Lightyear requires a default rounding GL Code to apply to the rounding rows inserted in Panel 2.  This is set one time only from the Accountancy Software settings section and is found beneath the GL code Table. 


Enjoy!  


      

    Check out release notes for 2020



      • Related Articles

      • How does Lightyear Data Extraction work?

        Data Extraction Explained Lightyear uses world class data extraction technology to minimise your workload. We strip all of the data, line by line, from your bills, credit notes and statements so you no longer have to spend long hours manually ...
      • Why is the invoice red?

        Do you have an invoice in your Approval Tab or Review Tab which is in red? Why is the invoice line red? This is because you have returned it from either the Signed Off tab to the Review Tab or from the Review tab to the Approval. Once you approve it ...
      • Is my data secure ?

        Lightyear holds data security to the highest industry standards. We do so with our design of infrastructure, data encryption, ISO certification and additional security features within the Lightyear app. Read on below for more details.  Lightyear is a ...
      • Gateway Liquor Bill Format

        Lightyear isn't extracting my quantities correctly, why is this? This supplier is quite unique in how it displays quantities: Cartons = Have their own column and are a whole, round number. Units = Are displayed as ‘Unit / Carton Size’, within their ...
      • How do I delete a document?

        From the Processing/Approvals/Review tabs use the trash-can icon beside the More button ​ In the Processing tab, if your document has more than one attachment, you can either delete the entire email, or delete the attachment you're currently viewing ...