Keyword Rule Automation

Keyword Rule Automation

Keyword Rules Automation allows you to set custom rules up at a supplier level to determine how bills are coded (GL, Categories...) and even route bills to certain approvers based on a keyword. This keyword can be anything, an account number, an address, a PO reference or any unique string of characters.

As an example, picture a restaurant group of 3 locations running all their bills through 1 Lightyear account, ordering stock through one supplier.  The addresses of the restaurants are as follows:
  1. Holbrook Parish
  2. New Road
  3. Persimmon Homes
Keyword rules automation will allow them to have their bills automatically coded with unique GL Codes, Tracking Categories and/or assigned to a specific approver by simply adding the above addresses as the keywords, looking like this:

The above configuration overrides the defaults setup at supplier level based on the address that Lightyear detects and automatically generates an Approval Task to the relevant Manager within 1 second of the bill hitting the mail server. Simple.

Setting up Keyword Rules Automation

Before you can start setting your rules, you need to enable Keyword Rule Automation in Company Settings

Once on, head into edit any Supplier, and you'll see the Keyword Rules automation table at the bottom of the "Profile" tab. This is where you can start setting your rules.

The set up is simple. Under "Doc Keyword(s)", enter a string of text found on bills from that supplier that's unique to that site. This would typically be an address or a post code, but you can enter anything that's unique to that specific location. The system will try to find anything that is close to matching the Keyword(s) , ignoring punctuation, capital letters and spacing, but an exact match would be preferred.

Once that's done, set the GL,  Tracking Category or Approver you'd like to see automatically populated for that unique identifier. 

Note - you do not have to set all the drop downs.  You can choose to just automate the Approver for example, and leave the other options blank.  in this scenario, the default Supplier level bookkeeping rules will activated if the Keyword drop down is blank.

WARNING - If you want your Line by Line Rules to apply at product level , then do not set Keyword automation for that supplier.  The Keyword rule will over-ride your product level automation rules settings. 

Please note, that under the "PROJECTS" Header, you can update and customs each to the relevant project name. Here, for tutorial purposes, we have used numbers. 

That's all there is to it! Once a bill from that supplier is mapped and sent to your approvals tab, we'll scan the document for the keyword and automatically apply your chosen GL and Tracking Category defaults to each line on the bill. This will override any defaults set at the supplier level, and in the Product List.

Copy Keyword Rules

If all Keyword Rules within one Lightyear account will apply to the same GL Code, Category and Approver, you can copy these from one supplier to another easily.

Select the Rules you want to copy across, then click the Copy Rules button.

In the popup modal, select the suppliers you want to copy the rules across to, this can be as many or little as you want.

After you've made your selection, click Save. The keywords will then appear in the other Suppliers, ready to be applied to documents in your Approvals Workflow.

Bulk Delete

If you need to delete multiple Keyword Rules within a Supplier, you can do so by selecting the Rules you want to delete and clicking the delete rules button.

Once you have deleted the rules you don't need anymore, click Update on the Supplier to save your changes.
Warning: There is no undo button for deleting Keyword Rules. Once you click Update, you cannot reverse these changes.


    Check out our
    to stay up to date

      • Related Articles

      • Step 5: Customise your settings

        After you've connected to your Accounting Software, you'll need to visit Company Settings and customise your Lightyear account. Simply select Settings > Company Settings from the options on the left of your Lightyear user interface. The options that ...
      • Step 1: Connect your accounting software

        Lightyear is an award winning automation application, but ultimately you will want to get your payables data into your accounting software. In order to sync with your accounting software's suppliers, tax rates etc, and send your purchase data to your ...
      • Step 3: Send a document into Lightyear

        Here, we'll take you through how to get your first bills into Lightyear and then what to do with them. Use the table of contents above to skip ahead to the section you need. Alternatively, you can watch this video: Get your first bill in from ...
      • START: Registering your first company

        Signing up for Lightyear Congratulations and thank you for deciding to check out Lightyear! Getting started with a new software can be daunting, so we've composed this guide to help you find your feet. This article will walk you through giving us the ...