A2E - Financial
Using A2E to extract financial data from Accredo®
.................................................................................................................................................................................
Using A2E to extract financial details from the Accredo® GL allows reports of any format to be created in Excel. In the example below, a simple
quarterly Financial Performance (Profit & Loss) shows how to link the formulae to key cells so that as soon as one cell is changed, the data
is instantly changed.

The formula in cell C8 uses the A2EGetGLBalance function to extract the balance of a General Ledger account. The formula needs to know the following information in order to get the required data -

- the Accredo company code (B2)
- the General Ledger account code (A8)
- the financial year (B3)
- the financial period (C6)
- the Branch code * (B4)
- the Department code * (B5)

If any of these values are changed, the data where the A2E formulae are (yellow shaded area) will instantly be updated.

.................................................................................................................................................................................



The formula in the cell (C8) is evaluated by Excel and the result is shown as a value in the spreadsheet.

A2EGetGLBalance

Formula Breakdown -

B2 - Accredo Company Name
A8 - Accredo GL Code
B3 - Accredo GL Year
C6 - Accredo GL Period
B4 - Accredo Branch
B5 - Accredo Department
2007 Bryant Software Ltd. All rights reserved.
Bryant Software Ltd
HOME     |      A2E         CASE STUDIES     |      SERVICES      |       CONTACTS