Skip to main content

Best practice for preparing your accounting data to sync

How to improve data quality in your financial accounting platform for a more accurate carbon footprint

Introduction

Sage Earth Carbon Accounting works best when it syncs with your financial accounting software. The platform analyses your spend data and matches each transaction to an Emissions Intensity Factor (EIF) to calculate your carbon footprint.

By taking a few simple preparatory steps in your financial accounting software, you can help the AI accurately match spend transactions to the correct EIF. This reduces manual work and improves the accuracy of your results.

Enter detailed transactions

Avoid grouping costs of different categories together. Instead, break down expenses into individual items. For example instead of entering “Travel expenses” as a single line item, separately enter:

  • Hotel accommodation

  • Food

  • Drinks

It's fine to have multiple entries of different types on the same invoice but grouping them together in a single line will reduce accuracy. Each category has a different emissions factor, so detailed entries improve accuracy.

Use clear, specific descriptions

Our AI model categorises transactions based on their descriptions. Use precise terms:

Too general

More specific

Fuel

Petrol
Diesel

Travel

Train travel
Short-haul air travel

Office supplies

Printer paper
Ink cartridges

Stationery

Cost of sales

Raw materials: Metal
Packaging

If you use internal codes such as SKUs (Stock Keeping Units), Stock codes or Manufacturer part numbers our AI may not categorise transactions accurately based on these alone. To improve results, include a clear, human-readable description of the item alongside these codes. This helps the AI understand what the item is, while keeping your internal references intact.

If you frequently purchase certain items and have them set up as products in your accounting platform, make sure each product record includes a descriptive name. This should automatically populate the description field on supplier invoices or payment records.

Ensure the correct description field is used

Your accounting software may contain multiple description fields. Sage Earth Carbon Accounting reads the ‘description’ field on supplier invoices and on payments not linked to a supplier (e.g. bank payments).

After transactions are imported into Carbon Accounting, check the Description field in the Transactions screen. This field - along with the supplier name and nominal code (your internal account/category code) - is used by the AI to categorise spend.

Include supplier details

Accurate supplier information supports better transaction sorting and categorisation. Make sure supplier records have a legible name and where possible try to sanitise records to keep the name field free from typos and avoid having multiple similarly named records that represent a single real-world supplier.

Nominal codes

A nominal code or nominal account in an accounting platform acts as the bucket into which transactions sit, which determine where in your chart of accounts, P&L and balance sheet these transactions sit. Depending on your accounting platform, these might be called a ledger account, general account or similar.

Accounts platforms usually come with a number of preset nominal accounts, and users can also create custom ones. Categorisation within Carbon Accounting isn't impacted by the numeric code of the nominal account or where it sits within your chart of accounts, but it is impacted by the nominal code name.

Use descriptive names

Where possible, use a human-readable descriptive name for nominal accounts for categories of similar purchases, such as 'Vehicle fuel', 'Office supplies', 'Building maintenance', 'Raw materials', 'Packaging' etc.

Avoid generic accounts

Often an accounting platform is pre-set to use a generic code like 'Cost of sales' for many purchases. These accounts don't have a name that aids in categorisation, and having many different types of purchase linked to them will reduce categorisation accuracy.

Try to find a balance between efficiency of processing items in your accounts package, and not funnelling too many different types of purchase through a generic 'Costs' or 'Miscellaneous expenses' nominal account.

Review data regularly

Conduct routine checks to ensure transactions are correctly categorised and described. This keeps your footprint data accurate and up to date. Establishing a routine for data review not only keeps your records up-to-date but also ensures that any changes in your business operations are reflected in your carbon accounting.

Utilise automation tools

Leverage automation tools to streamline data entry and ensure consistency. Tools such as AI Capture for Sage Accounting allow you to scan invoices or snap pictures, automatically entering the data for you. This not only saves time but also minimises errors in data entry, further enhancing the accuracy of your carbon footprint measurement.

Conclusion

By following these guidelines, users can significantly enhance the accuracy of their carbon footprint measurement when syncing financial data with Sage Earth Carbon Accounting.

Detailed data breakdowns, clear descriptions, the use of automation tools and regular data reviews are all essential practices for achieving precise and reliable carbon accounting. Implementing these practices will not only improve your sustainability reporting but also support your long-term environmental goals.

Did this answer your question?