Skip to main content

Automate bill processing with maps, supplier rules and product defaults

Find out how Lightyear applies maps, supplier defaults and product GL codes for you, so your bills reach the Approvals tab ready to approve.

J
Written by Jessica Callaly

Lightyear can speed up your approval process by applying rules automatically when a bill moves to the Approvals tab. You set up maps, supplier rules and product defaults once, and Lightyear applies them to every future bill from that supplier. This article explains what Lightyear automates, where you set each rule, and how to keep your automation accurate.


Understand what Lightyear automates

Lightyear automates four things. Each one is set up in a different place:

Automation

Where you set it

What Lightyear does

Mapping

Processing tab

Remembers the email address a bill came from and the map you used, then applies the same map to future bills from that email address.

Extraction rules

Supplier details, Extraction Rules tab

Controls which map Lightyear tries first, and lets you default a supplier to line items.

Supplier rules

Supplier details, Profile tab

Applies a default GL code, tax code, category, due date and approver to bills as they arrive in the Approvals tab.

Product defaults

Supplier details, Products/Rules Automation tab

Applies a default GL code to individual product lines on line-item bills.

When more than one rule could apply, Lightyear uses them in this order:

  • A default GL code on a product overrides the supplier's Default GL Code for that line only. Other lines use the supplier's Default GL Code, if one is set.

  • Supplier-specific settings take precedence over company-wide defaults.

  • Number of Days Credit only applies if Lightyear can't extract a due date from the bill.


Understand how automatic mapping works

When you receive a bill from a supplier for the first time, you search for and apply a map. After that, Lightyear remembers the email address the bill came from and the map ID you used. It then applies the same map automatically to any future bills sent from the same email address. For more information, see What is a map? And how do I find and use a map?

The following rules affect how maps are applied:

  • Invoice maps are tied to the supplier, not to individual accounts. If a supplier's invoice layouts are identical across accounts, you can use a single map.

  • When you map a supplier to an invoice, Lightyear may ask whether you want to apply the same map to other bills from the same email domain. If you select Yes, Lightyear tries to apply the map to every other bill in the Processing tab from that domain. Bills that the map fits move to the Approvals tab automatically. If you select No, Lightyear doesn't apply the map to other bills.

  • Maps made for invoices can't be used for statements. If a supplier sends both invoices and statements, request a separate map for each document type.

  • If a supplier uses multiple account codes as unique identifiers, you can request a separate map for each account code. Lightyear then identifies the account code on the invoice and routes it to the right supplier card.

🤓Tip: If a supplier issues invoices for several branches in identical formats, Lightyear can't reliably tell the branches apart by account number alone. Create a separate supplier entry for each branch, then manually assign each invoice to the correct supplier.


View and manage a supplier's maps

You can see which maps are saved for each supplier, change which map Lightyear tries first, and remove maps you no longer need. You manage these in the supplier's Extraction Rules tab.

  1. Click Suppliers in the left-hand menu. The Manage Suppliers page lists all your active suppliers.

  2. Find the supplier by using the search box at the top right, or by scrolling.

  3. Click the green pencil icon to open the supplier's details. Three tabs appear along the top: Profile, Extraction Rules and Products/Rules Automation.

  4. Click the Extraction Rules tab to view the supplier's maps.

From the Extraction Rules tab, you can:

  • Reorder the maps using the arrows on the left. This decides which map Lightyear tries first.

  • Delete a map using the delete button on the right.

  • Set the supplier to default to line items for future invoices.

Default a supplier to line items

  1. Open the supplier's Extraction Rules tab.

  2. In the dropdown menu, select Lines.

Choose the extraction level with Smart Extract

The Smart Extract feature lets you select the extraction level directly in the Supplier Details section. This gives you more control over supplier-specific settings. For more information, see Choose the right Extraction Method in Lightyear.

⚠️Important: Don't use Smart Extract for invoices with multiple distinct account codes. Use the specific maps you've created for each account code instead.


Set default rules for a supplier

When you set up or edit a supplier, you can set defaults that Lightyear applies to bills as they arrive in the Approvals tab.

  1. Click Suppliers in the left-hand menu, then find the supplier.

  2. Click the green pencil icon to open the supplier's details.

  3. Click the Profile tab.

  4. Set the defaults you need. The main ones are:

    • Default GL Code: Applies the selected GL code to all lines on the bill. Any Default GL Code set in the product details overrides this.

    • Default Tax/Tax Free Code: Applies the selected tax code to all lines on the bill.

    • Category: Applies the selected tracking category to all lines on the bill.

    • Number of Days Credit: Fills in a due date on the bill, counted from the bill date or from the end of the month. This only applies if Lightyear can't extract a due date from the bill.

📌Note: The options you see depend on your accounting software.

Set an automated approver

In the same Profile tab, you can set a specific approver for a supplier. For example, if you want one person to be the only approver for everything from a supplier, select that person in the approver box.

Once you've set the defaults, any bill from a previously mapped supplier goes straight to the Approvals tab with those defaults applied. For more information, see Manage supplier approvers.


Set a default GL code for a product

You can assign a default GL code to individual products. When a line-item bill includes that product, Lightyear applies the GL code to that line only, and it overrides the supplier's Default GL Code. Lightyear applies the GL code when the bill moves to the Approvals tab. Any lines without a product default use the supplier's Default GL Code, if one is set.

  1. Click Suppliers in the left-hand menu, then find the supplier.

  2. Click the green pencil icon to open the supplier's details.

  3. Click the Products/Rules Automation tab. The supplier's products are listed, including any you've imported by CSV.

  4. Click the green pencil icon next to the product. The options you can set for that product code appear.

  5. Set the Default GL Code, then save your changes.


Keep your automation accurate

Maps and supplier rules work best when you keep them up to date. These practices help bills route to the right tab automatically:

  • Ask suppliers to put line amounts next to line descriptions, so Lightyear can extract them accurately.

  • Review your maps regularly, and update them when a supplier changes their invoice format.

  • After you change a supplier's maps, test the extraction with sample invoices to confirm it's accurate.

  • Request separate maps for invoices, statements and account codes. Each document type needs its own map.

  • If a supplier sends documents in several formats, keep all the relevant maps.

  • Remove incorrect maps and apply the correct ones. This prevents future mapping errors.

  • Give product line (line-item) maps priority over service line maps, to avoid conflicts.


Troubleshoot automation

Fix common problems with automated processes in Lightyear with the steps below.

A document went to the wrong tab

If Lightyear misclassifies a document, for example by sending it to the Statements tab, you can correct it. This also makes sure future documents route properly.

  1. Move the document back to the Processing tab.

  2. Apply the correct map.

  3. Send the document to the Approvals tab.

Product codes are missing from invoices

Check that the supplier has a Line-Item map selected. Service-type maps can leave out product codes, which disrupts your workflow.

An invoice shows summary totals but I want line items

If a supplier's invoices only show summary totals and you want to extract detailed line items, change the order of the maps:

  1. Open the supplier's Extraction Rules tab.

  2. Delete or demote the Service map.

  3. Move the LineItems map to the top of the priority list.

I changed a setting but existing bills didn't update

Changes to supplier settings, such as defaulting to line items, only affect future invoices and invoices still in the Processing tab. Invoices that have already left the Processing tab aren't updated, so your historical data stays consistent. Changes to company-level default settings don't affect documents already in the Approvals or Review stages. If you need these documents to change, update them manually.

Did this answer your question?