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.
Setting Grouped Data by Supplier
With Grouped data switched on in the Accountancy Software Settings, the Group Line Data option will automatically be switched on for all Suppliers. If you have some suppliers that you wish to export detailed line data for, you can simply switch this setting off at the supplier level. This setting can be found in the Supplier Rules section.
Please note that similarly to when switching grouped data on at the account level, you must ensure that you have no documents from this supplier in your Signed Off tab before making any changes at the Supplier level.
Check out our
to stay up to date
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 ...Auto Publish to Accountancy Software
Auto-Publish is suitable where users would prefer that once Bills/Credit Notes have been mapped and coded, they are automatically exported to their Accountancy Software, bypassing the Approvals process. Please Note: This feature is currently only ...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 ...Approval by Value
Bill Workflow Setting Approval by Value at a Company Level Users can 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 to approve it. Please ...