Home > Sample Financial Statements > Function Examples

Function Examples

Click a particular statement to view. To view all of the examples, click here. If you need a viewer, click here.

You can download this group of statements for your own use with Adagio FX or Adagio Ledger by clicking here. The downloaded statements are stored in a ZIP file and should be unzipped into a directory for use. In Adagio FX, statements being with AF!, while Adagio Ledger statements begin GL!. In the Financial Reporter, you can use File | Import to retrieve statements between programs. In the file names below, the file prefix has been eliminated.

Financial Statements with Common Ratios

File: BalanceandIncome WithCommonRatios.SAM

Notes: Basic Balance Sheet and Income Statement that generate a third page of all the common financial ratios that can be calculated from the financial statements: Acid test, Debt to equity, etc.
Right Button Insert Options

File: RightMouseFormulas.SAM

Notes: A page describing all the formulas that may be inserted by selection from the right mouse button "Useful Formulas" choice.
RngMerge Example

File: FunctionExamples.SAM

Notes: Demonstrates how the =RngMerge() function works to create account-department ranges. Demonstrates the codes available to insert text in a financial statement header and footer.
Row Formatting Example

File: RowFormat.SAM

Notes: Schedule of Expenses where accounts over budget are automatically highlighted in yellow, and accounts under budget are bolded.
Financial Reporter Fields

File: SuperSpec.SAM

Notes: Contains every specification code that can be used in conjunction with "gldata" in creating an =ADGET() function.
Currency Conversion Examples

File: CurrencyCvtExample.SAM

Notes: Two column income statement stating amounts in Canadian and US dollars. Exchange rate entered once and amounts are all re-calculated automatically.
Revenue & Expenses (Consolidated Departments)

File: Video-1.SAM

Notes: The sample income statement generated during the Adagio FX demonstration video, part 1. Three columns, actual, budget and budget variance.
Revenue & Expenses

File: Video-2.SAM

Notes: The sample income statement generated during the Adagio FX demonstration video, part 2. Six columns, actual YTD, last year YTD, % variance, current YTD, budget YTD and budget variance.
Balance Sheet -- Assets

File: BankLOC.SAM

Notes: A simple balance sheet that demonstrates how to automatically move a bank account from the asset to liability section of the balance sheet depending on its balance.
Date Function Example

File: DateFunctionExamples.SAM

Notes: =DATESTRING() allows unlimited formatting of a date. This sheet demonstrates all the various formatting codes, with examples of their use.
Verify Balance Sheet 1

File: VerifyBalanceSheet.SAM

Notes: A basic single column balance sheet that can be viewed expanded or collapsed to verify the chart of accounts.

home | view examples | watch video | step by step | download demo | visit softrak.com | purchase now | contact us

© Copyright Softrak Systems Inc.