These instructions are only for Sage 50 Canadian Edition

In this article, we will explore what XLGL worksheet functions are and how they can simplify your reporting efforts.

What are XLGL Worksheet Functions?

XLGL worksheet functions are a set of functions that can be used in Excel to fetch and summarize data directly from your Sage 50 company file. These functions work in a similar way to formulas and worksheet functions you may already be familiar with, such as "SUM" or "VLOOKUP".

How do XLGL Worksheet Functions Work?

XLGL functions are used to retrieve specific data from your Sage 50 company file and display it in your Excel worksheet. For example, the "XCompany" function can be used to request the name of the company from the Sage 50 data, and the "XGL" function can be used to report the balance of an account or a group of accounts at a given date.

These functions can be used in the same way as other Excel functions. You can enter them directly into a cell, or use the function argument window to specify the required arguments and get more help on the function.

Examples of XLGL Worksheet Functions

Let's look at some examples of how XLGL worksheet functions can be used:

• The "XCompany" function can be used to populate the company name in a cell.
• The "XGLDesc" function can be used to get the account description given its number.
• The "XGL" function can be used to get the current balance of an account.

By changing the values in the cells referenced by these functions, such as the account number or the date, the functions will automatically update and recalculate the results.

XLGL Worksheet Functions are a powerful tool for fetching and summarizing data from your Sage 50 company file directly into your Excel worksheets. By using these functions, you can simplify your reporting efforts and ensure that your data is always up to date.