Designed for SL.png
Drill Down.png
Security.png
Reporting.png
 

Designed for Dynamics SL

  • Easy to install 

    • Shared Excel add-in

    • One SQL script

  • Easy to learn and use

    • Leverage your knowledge of Excel

    • Use Excel shortcuts to create financial reports in minutes

  • Modular Security model

    • Allows blocking transaction detail by the combination of user, company, and module

    • Uses Dynamics SL Access Rights control

  • Compartmental Security model

    • Prevents users from seeing any data they shouldn't

      • Use masks and/or lists to allow viewing balances and transactions by combinations of company, ledger, account, and subaccount.

      • Maintained using an Excel worksheet (copy/paste, search/replace, etc.)

    • Shared workbooks will have different information depending on who opens them

    • No need to schedule, generate, or distribute internal financial reports

  • Adds custom functions to Excel

    • PTDBAL(CpnyID,LedgerID,Acct,Sub,FiscYr,Pd)

    • YTDBAL(CpnyID,LedgerID,Acct,Sub,FiscYr,Pd)

    • PDEND(CpnyID,FiscYr,Pd)

    • and many more!

  • ​Balance functions (PTDBAL, YTDBAL) include sophisticated options

    • ​View only credits or debits

    • Include unposted transactions, even in future periods

    • ​Use Consol account and/or subaccount

  • Insert from SL form for easily importing entities like company ID, ledger ID, and subaccounts

    • Create drop down lists

      • Subaccount drop down list can be by segment(s)

    • ​Drop lists of entities into your Excel worksheeet

      • ​List of all accounts

    • Can create range (cell) names for entities

    • insert descriptions -- uses XLstatements functions like ACCTDESC(CpnyID,Acct)

  • Summarize by using masks, ranges, and/or lists

    • Companies in the same database

    • Accounts

    • Subaccounts

    • Periods

    • E.g., CpnyID can be "00??", Acct can be "101?;1030:1080;-1055", Sub can be "*"

    • Companies from different databases may be used in the same formula by using multiple functions, e.g., =PTDBAL("0060","10??","*",2016,10)+PTDBAL("0010","101??","*",2016,6)

Powerful Drill Down

  • Double-click on a PTDBAL cell to drill down

    • First level expands from any summary, e.g., accounts, subaccounts, periods

    • Second level shows transaction detail in the GL for an account/subaccount/period

    • Third level shows the entire batch of transactions in the subsidiary ledger

      • Saves hours when auditing

      • Can be blocked by using Modular Security

      • Includes Inter-company transactions

    • ​Fourth level available to show attachments

    • ​All levels are filtered by Compartmental Security

  • Drill down options

    • See entity ID and name (e.g., AP Vendor) at GL detail level (when posting in detail)

    • Notes on Batch, entity, document, and detail from Dynamics SL are Excel comments

    • Show transaction type descriptions

    • and more!

  • Add columns to drill down detail sheets

    • User fields

    • Any other columns from any screen level

    • Configurable for all users or specific users

Multiple Security Models

  • Modular Security model

    • Allows blocking transaction detail by the combination of user, company, and module

    • Uses Dynamics SL Access Rights control

  • Compartmental Security model

    • Prevents users from seeing any data they shouldn't

      • Use masks and/or lists to allow viewing balances and transactions by combinations of company, ledger, account, and subaccount.

      • Maintained using an Excel worksheet (copy/paste, search/replace, etc.)

    • Shared workbooks will have different information depending on who opens them

    • No need to schedule, generate, or distribute internal financial reports

"Distribute-less" Reporting

  • No need to schedule, generate, or distribute internal financial reports

  • Self-service reporting for internal management reports

  • Shared Excel reports will have different information depending on who opens them

  • Report users (e.g., department managers) can drill down to details of only their own transactions

  • Report users can view past (and even future) balances and transaction detail

Structured Reporting

  • Auto-generate reports by subaccount

    • Department reports - as workbooks or worksheets in the same workbook

    • Reports can be static (just numbers) or XLstatements workbooks

    • Can also create PDF files or send to printer

  • Budgeting option ($995)

    • Create budgets easily from "guide" basis data

    • Flexible formats - no predefined worksheet format is required

    • Maintain budgets by using themselves as bases

    • Supports multi-level budgeting

      • Any combination of subaccount segments

  • Project Option ($1295) - coming soon

    • New functions

      • JTDBAL(CpnyID,ProjectID,TaskID,AcctCategory, etc.)

      • and more

    • Drill down to Project batch detail

 
 
 

Copyright 2019 © XLstatements, LLC.
Microsoft Excel and Microsoft Dynamics SL are either registered trademarks or trademarks of Microsoft Corporation in the United States and other countries