Spend Module Configuration Guide

  Restore Visibility                                                              Safeguard Compliance   

   Estimated Read Time: 10 minutes                       

 


 

Sections in this Article

Introduction

Getting Started

Enabling the Module

Choosing your Annual Calculation Period

Enabling Automatic Reconciliation

Enabling Project Spend

Customising your Spend Module

Amending Spend Labels

Adding Custom Data

Adding Spend

Manually Adding Spend

Bulk Adding Spend

Automating Spend

Add Spend Via Zapier

Adding Spend Via the API

Adding Spend Via our NetSuite Integration

FAQ

 


 

Quick Introduction - What is the Spend Module?

 

When using the "vanilla" Gatekeeper (i.e. without the Spend module), there are a few ways you can track Monetary Values of agreements & obligations...

The simplest way to do this is to populate the "Annual Contract Value" field for all your Contracts

With this single field populated, Gatekeeper can show you value summaries in Dashboards, Repository tables, within Contract records and you even get a nice summary within your Vendor records too, showing you totals of all agreements held

 

Pictured below: Some of the dashboards & views where Contract Values are displayed

However, these Annual Value calculations are not designed to be perfect indications of expenditure - they're more useful to give users an indication of approximate/expected value

Thus comes the question:

Can Gatekeeper be used to track expected contract expenditure, as well as actual current expenditure and can this be used to plan budgets, calculate operating costs etc?

 

➡️ This is where the Spend module comes in!

 

How does Spend do this?

At its core, the Spend module gives you an extra set of data you can link to your Vendors & Contracts to track individual payments

Not only does this give you visibility of those payments alongside your other key Gatekeeper data like Legal Obligations & Risk, but the Spend module provides you with insights & calculations which can help you planning budgets or assessing how "in-control" you are of expenditure.

 

What the Spend Module provides (simplified)

  • An additional customisable Data Set (Spend records) linked to your Vendors - which also comes with the ability to allocate Spend to specific Contracts too
  • Spend Calculation Summaries within each Vendor & Contract record
  • A Spend Dashboard (& other Spend Reporting Options)

 

To get a full summary of the reporting, analytics & insights available when using the Spend module, visit our dedicated article here:

Spend Module Reporting 📊

 

📘 Appendix: All Core Spend Fields

 

Field Definition Calculation details
Forecast: Contract Annual Value How much you are expected to spend on contracts each year Sum of all Pipeline/Live Contract "Annual Values"
Annual Direct Spend: All Entries How much you have spent with your vendors in the current reporting period  
Annual Direct Spend allocated to Contracts Same as above but only spend which has been linked to a Contract as well as a Vendor  
Direct Spend Expenditure in the current annual year

Sum of all direct Spend for the current vendor in the current annual period

Spend linked to archived contracts will be excluded

Annual Direct Spend All Entries less Forecast   The difference between actual spend entries vs the sum of Contract Annual Values
Indirect Spend

Spend which has been paid to another vendor but the current vendor is involved* in the provision of the goods/services

Sum of all Spend Entries within the current Spend period where the current vendor is listed as the Indirect Vendor
Annual Direct Spend allocated to Contracts less Forecast    
All Time Spend All Spend Entries, regardless of Contract links, Spend Period, past or future, Direct or Indirect  

 

*This should not be confused with the concept of Indirect Spend referring to costs not directly associated with your provision of Goods & Services

This refers to expenditure where your payment does not directly go to the listed Vendor

 

For Example, if buying laptops from an office-supply vendor, you could list "Apple" as the Indirect Vendor since they are ultimately providing the goods, but you are not directly paying them

 

 


 

 

Getting Started ✅

Enabling the Module

Once Spend has been added to your subscription, the module can be enabled/disabled by Configuration Admins here:

Step 1) Go to Modules > Spend

Step 2) Set Spend Module Configuration to  Enabled 

 

If you do not have this module and wish to discuss upgrading (or if you have recently purchased this module and cannot access this configuration screen) please reach out to your CSM or contact our Customer Success Team

 

Enabling Automatic Reconciliation

You may notice as you visit the various Reporting pages of the Spend module that one area it offers insights is based on the Contracts which are linked to the spend entries

Linking Contracts while adding Spend can increase the complexity of the import process - especially if using Bulk Import via CSV or Automatic Import via API - therefore you can use a setting that will allow Gatekeeper to link Spend entries to some Contract records to for you

 

With this setting enabled, whenever you import (via bulk import/API) new Spend for Vendors with only 1 Live Contract, Gatekeeper will assume the Spend must be part of that contract and automatically link it for you

 

Pictured Example - A Spend record being added via bulk import which automatically links to the Vendor's only Contract record after the import is completed

 

Step 1) Go to Modules > Spend

Step 2) Set Reconciliation from Manual to  Auto 

 

Enabling Project Spend

If you are using Projects to track sets of Contracts/Vendors relationships, you can leverage Spend to include a budget for the Project

Once you enable this setting below, a new "Spend Status" summary will show on the Project dashboard to give you visibility of available budget

Step 1) Go to Modules > Spend

Step 2) Set Spend Module Configuration to  Enabled 

 

 


 

Customising Your Spend Module 🛠️

 

Changing your Annual Calculation Period

When adding Spend Entries to your repository, you will see that assigning the Date that the Spend occurred is mandatory

This date plays a key role in the insights Gatekeeper provides to assist you in tracking & planning your budgets

As such, you also need to decide which dates should be included in the various calculations & summaries provided by Gatekeeper

Step 1) Go to Modules > Spend

Step 2) Below, Annual Calculation, hit "Change"

Step 3) Select your desired period, then hit ✅ Save

Calculation Period Options 📆

12-Month Rolling

This works exactly as you would expect. Any Spend records dated within the last 365 days will be included in the calculations for any Spend dashboards/summaries

Calendar Year

With this setting, any Spend records occurring from January 1st of the current year until the current date will be included in the calculations for any Spend dashboards/summaries

Custom - Pro-Rata

This works much like "Calendar Year" but allows you to choose when your year begins.

For instance, you may prefer to start your year on April 5th to coincide with the Financial Year if this is how you to plan your budgets

After you have set your Custom Start/End date for the year, this option will include any Spend entries which land between the date you set and the current date

Custom - Full Year

Similar to above, this allows you to change the date at which your financial year starts/ends

Unlike above, this option will only include spend calculations from the last complete year

 

Amending Spend Core Field Labels

👋 ensure you understand the calculations & summaries affected by these labels before making changes

There may be some Spend Calculations which does not match how you organisation already classifies Spend. If so, you can amend the labels of the Core Spend fields to make them easier to understand for you & your users

Step 1) Go to Modules > Spend

Step 2) At the bottom of the page, find the field label you wish to amend

Step 3) Click the menu icon & hit Edit

Step 4) Enter the revised label "Translation" & hit ✅ Save

 

Adding Custom Spend Fields

We advise you to look at the Spend data model to get an understanding of the fields which come prebuilt for your Spend entries.

Once you have done this, if you notice that there are fields you need to capture in Gatekeeper which do not exist in the standard data model, you can follow the below steps to add extra fields

 

Step 1) Go to Settings > Configuration > Custom Data

Step 2) Hit Add > Custom Group to add a new data group

Or you can select an existing Custom Spend Group & skip to Step 5

Step 3) Name this Group & select Allocated to: Spend

Step 4) Hit ✅ Save

Step 5) Hit ➕ Add New Custom Field

Step 6) Populate the field Label & Type, then hit ✅ Save

Repeat Steps 5 - 6 until all your new fields have been added to the data model

 

💡 Some examples of some new fields you may want to add could be:

  • Payment Requested Date - Date
  • Expected/Budgeted Expenditure - Yes/No
  • Payment Type - Dropdown List:
    • Invoice
    • Expense
    • Fine/Penalty
    • Tax/VAT
  • Expenditure Category - Dropdown List:
    • Operational
    • Financial Services/Expenses
    • Legal and Regulatory
    • Capital
    • Other
  • Payment Source Account - Dropdown List:
    • Main TXN Execution Account
    • Main Current Account
    • Expense Account
    • Creditors - UK
    • Creditors - EU
    • Creditors - APAC
    • Creditors - US
    • Other

 

 

Adding Spend ➕

This section refers to ways you can add Spend yourself as a Gatekeeper user

These methods are recommended as steps to follow when first setting up your Spend module...

...Once you have all your historical spend imported via these means, we recommend setting up a more automted method for having Spend added to Gatekeeper via one of the below options ⬇️

 

Manually Adding Spend

Step 1) Open a Vendor record from within your Vendor repository

Step 2) Hit Add > Spend

Step 3) Populate the Spend metadata & hit ✅ Save

Mandatory Values: Date, Currency, Amount

💡 After you hit ✅ Save, Gatekeeper will automatically load up a new line for you to continue adding Spend entries for the Vendor, but you do not need to populate any more

 

Bulk Adding Spend

Step 1) Go to your Vendor repository

Step 2) Hit Add > Import Spend

Step 3) Hit Download Template ⬇️ to get a CSV file with all your Spend fields as columns

Step 4) Populate this template using Excel/Google Sheets, mapping your existing Spend data to the Gatekeeper template's format

Step 5) Download your populated template as a new CSV file

Step 6) Return to the Gatekeeper import page & upload this populated CSV file

 

Currently, bulk exporting & re-importing Spend (for the purposes of updating existing Spend records) is not possible

To get notified when this is developed, please upvote this idea 💡

 


 

Automating Spend Imports ⚙️

Once you have set up & imported all your current & historical Spend data to Gatekeeper, we recommend creating a failsafe process to ensure Gatekeeper is kept up to date so you can rely on the insights & intelligence it provides

If you do not have the resources to automate this, you can  perform a bulk import on a regular schedule (e.g. once per month/quarter)

However, we recommend the below methods which require less manual effort as well as fewer delays/periods of inconsistency between your systems!

💡 You will notice this is different to how we recommend managing your Vendor/Contracts - which we suggest you do in Gatekeeper

This is because the majority of our clients will have separate Finance/ERP software tools which they use for payments & budgets but don't want to force you to upheave those in favour of Gatekeeper

 

Adding Spend Via Zapier

Zapier is a web-based "Do it yourself" API tool

You can use Zapier to create "Zaps" - these are rules which you can give to Zapier which it will use to take data from your Financial tool and push this data into Gatekeeper

You can search to see whether your other solution has a Zapier integration here:

🔍 Zapier Apps

 

Adding Spend Via the Gatekeeper API

If your other financial solution does not have a Zapier integration, or if your organisation have an Integrations/BA team who usually handles the connections between software tools in your tech stack, you can leverage our open API to push data into Gatekeeper (or pull data from Gatekeeper)

👋 Gatekeeper's openAPI access is only included in Enterprise plans

If you wish to discuss upgrading or adding this as a "bolt-on" to your plan, please reach out to your CSM or contact our Customer Success Team here

 

Adding Spend Via our NetSuite Integration

When you have connected our native NetSuite integration, we allow you to automatically push Paid invoices back to Gatekeeper as "Spend"

This forms the final piece of the Gatekeeper-NetSuite Integration

See our 📖 NetSuite Integration Configuration Guide for more information

 

 


 

 

FAQs 💬

 

Q: What happens if we add Spend entries with a Date in the future

A: This is valid and fine to do.

However, Gatekeeper will not include these entries in any of the summaries / dashboards / calculations / reporting until the date is passed

...except for  the "All Time Spend" field

 

Q: How frequently is data updated via the Gatekeeper Suiteapp connection?

A: Data is updated hourly.

 

Q: Do Spend records need to be linked to Contract records?

A: No. Spend only needs to be linked to Vendors. However, many insights provided by the Spend dashboards & calculations are greatly improved by linking them to Contracts (where possible)

 

Pictured below: the Spend dashboard & Vendor Record calculations which are directly influenced by Spend entries which are linked Contract records

 

 

 

 

Q: Can we view/add spend during Workflows?

A: Not yet. If this is an important feature for you, please upvote this Ideas Forum post:

Create Spend from Workflow

 

 


 

 

Additional Reading 📚

 

📖 The Spend Dashboard

Get more insights into the reports & KPIs visible within the Spend Dashboard

 

📖 Gatekeeper on Zapier

Discover more about our Zapier integration & how you can use this to automate your data synchronisation between you systems

 

📖 Configuring Saved Views

Learn more about how to create customisable data summary views to easily review (and export) your contract & vendor data - including associated Spend values!