List of functions in Excel Integrated Reporting

Returns the number of bank accounts.

A drop-down list of all bank accounts belonging to the company.

Returns the balance of a bank account.

Returns the name of a bank account.

The full name of the company.

Returns the name of the currency identified by a currency code.

The exchange rate used by the company for the supplied currency.

A drop-down list of nominal account categories.

A drop-down list of nominal account types.

Returns the total balance for a nominal ledger category account, such as Product Sales.

Returns the total balance for a nominal ledger category type, such as Sales.

Returns the nominal ledger account number as a string.

Returns the actual value for the selected nominal account in the year, period and currency.

The budget value for the selected nominal account in the year, period and currency.

The value of debits for the selected nominal account and cost centre in the year, period and currency.

The value of credits for the selected nominal account in the year, period and currency.

The value of debits for the selected nominal account in the year, period and currency.

A drop-down list of nominal codes.

The name of the nominal account.

The current balance for a nominal ledger account.

The nominal ledger balance for the current financial year.

Returns the number of nominal accounts.

The number of nominal transactions for the nominal account.

The customer's address for the line requested.

The aged balance for a customer.

Returns the sales balance for a customer in a given year, and accounting period.

The customer's contact name.

The customer's credit limit.

The customer's trading currency code.

The customer's delivery address line for the given address name.

The postcode of a customer's delivery address line for the given address name.

The customer's department.

The customer's email address.

The customer's fax number.

A drop-down list of customers linked to the company.

The customer's name.

The net sales value for a customer in the given year and accounting period.

The nominal account code for a customer.

The number of orders taken from a customer in the selected year and month.

The value of orders taken from a customer in the selected year and month.

The number of days available to a customer before payment is due.

The customer's telephone number.

The customer's postcode.

The price a customer will normally pay for a stock item, including any discount, in the customer's currency.

The number of days within which a customer must pay to get a settlement discount.

The customer's default tax code.

Returns the number of customers.

Returns the number of stock items.

Returns the standard cost price for a product. This information is taken from Product Record > Details tab > Ordering section > Last Cost Price.

Returns free stock - the quantity in stock minus quantity allocated - for a product.

The total quantity of the item sold in a selected year and month.

The total value of the item sold in a selected year and month.

The Intrastat commodity code for a stock item, taken from the product record.

The nominal code used to post cost of sales transactions for the stock item.

The description of the stock item.

A drop-down list of all stock codes for the company.

A drop-down list of locations taken from the product records.

The markup percentage for all sales of the stock item in the selected currency during the year and accounting period.

The profit percentage for all sales for the stock item in the selected currency during the year and period.

The quantity of stock currently allocated.

The quantity of stock currently on order.

The sales price for the item and price band.

The code of the preferred or default supplier of the stock item.

The current quantity in stock.

The stock item type.

Returns a stock item's stocking unit.

A drop down list of units configured for a stock item.

The value of the stock item currently in stock.

The weight or mass of a stock item.

Returns the number of suppliers.

The supplier's address for the line requested.

The aged balance for a supplier.

The purchases balance for a supplier in a given year and accounting period.

The supplier's contact name.

The credit limit for a supplier.

The supplier's currency.

The supplier's department.

The supplier's e-mail address.

The supplier's fax number.

A drop-down list of all suppliers.

The supplier's name.

The nominal account code for a supplier.

The number of orders made to a supplier in the selected year and month.

The value of orders made to a supplier in the selected year and month.

Returns the number of days before payment to a supplier is due.

The supplier's telephone number.

The supplier's postcode.

The number of days within which a payment to a supplier must be made in order to gain settlement discount.