Grouping Line Data

Grouping Line Data

Before Turning Grouping On

Before you turn Grouping Line Data on, please ensure your Signed Off tab has been cleared. As existing invoices in this tab won't have been grouped, and will cause errors if trying to export. 

How Grouping Works

If you would prefer invoices to be exported with data grouped per GL code/Tax Rate/Category, this feature is the one for you! Rather than exporting 100s of line items, coded to a couple different GL codes/Tax Rate/Category, you can now export these lines summarised across these GL codes/Tax Rate/Category
When turned on, ALL invoices will be exported using grouped lines.
Every Accountancy Software will have the option to turn this on. Simply head over to Accountancy > Accountancy Software Settings and turn Group Line Item Data to Yes.



With this turned on, in Approvals tab you will see an extra tab in Panel 2 called Grouped Data.



From this tab, you will see the normal 'header' information, such as the Supplier, Invoice Number, Issue Date, etc. In the line items, you will see a condensed version of your invoice, grouped by GL Code/Tax Rate/Category. This information will be pulled from the GL Codes used in the Edit Bill tab.

The description column is editable, meaning you can change the name from the GL Code to describe what the grouped items are. For example, if the GL Code is set as GL0100 - Food, you can overwrite this to simply say 'Food'.

Why isn't My Data Grouping?

If you're in the Grouped Data tab, but the data doesn't appear to be showing the correct summarised data, there are a couple things that may have happened. This will look similar to the below:


Go back to Edit Bill and make sure all lines have been assigned both a GL Code and Tax Code. If there are any lines missing these codes, it won't group correctly. After assigning the correct Codes, click Save and go to Grouped Data again. You will see your data grouping as expected.




      

    Check out release notes for Q3 2021

     June  July  August 


      • Related Articles

      • Approval Task Requests

        What is an Approval Task Request? By sending one to an internal or external user, you are requesting action from them on the sent document. For example: In our team we have Jack, Mark and Lisa. I want to have Lisa approve a particular bill. I send an ...
      • Approval by Value

        Bill Workflow Setting Approval by Value at a Company Level  Users now have the ability to set up conditional approval by amount i.e. if a bill is over a certain amount, User A needs to approve it. If a bill is over another amount, User A and B need ...
      • Choosing the right approvals workflow

        Choosing the right workflow is crucial to help you streamline your processes to maximise efficiencies. You can have Lightyear up and running to streamline the purchase to payables process to follow the outline below Before settling on a workflow, it ...