Pre-Conference

There has been a lot of buzz recently about Adagio DocStore, which provides not only PDF storage for accounting documents, but also direct links to these PDFs from the associated transactions in Adagio. This workshop is designed to be an introduction for Adagio users to investigate the available features and plan for future implementation, and for early DocStore adopters to maximize their investment by ensuring that the available features are best being used.

The first half of the workshop will be a comprehensive demonstration of the features made available with Adagio DocStore and the compatible Adagio programs, showing what is possible and what to be aware of. The second half of the workshop will be interactive, as we go through each of the stages of planning for how DocStore will be set up and used in daily operations, preparing a plan of action for when DocStore will be used live.

Hands On. Laptop Required. 

Invoices arrive in your organization, require someone’s approval, expense coding, entry and payment. This workshop will follow an invoice through a typical organization, discuss various approval points and review entry of the invoice. With Adagio DocStore, invoices can be captured and approved electronically and automatically attached to the check’s remittance advice on payment. Find out how expense distributions can speed entry of invoices in Payables. See how to control Vendor Payments and use the System Check Run to automatically select and pay invoices that are due. Discover best practices for the issuance and control of manual checks. See how Adagio DocStore lets people instantly review the original invoice without making a trip to the filing cabinet. In fact, document filing may become a thing of the past!

Possible with ordinary formulas.  This session introduces users to this advanced functionality with simple array formulas that perform useful day-to-day accounting calculations. Don't miss this opportunity to understand how array formulas can improve your productivity.

Learning Objectives
Upon completing this session, you should be able to:

• Explain array formulas and how they differ from ordinary formulas.
• Identify an array formula from the Formula Bar.
• Compose array formulas from the keyboard.
• Describe common accounting situations where array formulas would be useful.

This workshop is designed to get you started designing your own Financial Statement, either from scratch or by modifying an existing statement. No previous experience in designing financial statement is assumed, but a basic understanding of Excel will be a benefit. The workshop begins with a review of the Financial Reporter Toolbar, and the basic elements of a well-constructed statement. A thorough review of account ranges and the structure of basic statement formulas (GLAMT() and GLDESC()) will get you well on the way to creating your own operational statements. You'll see different ways of drilling down to the account transactions and how to set up a basic Statement Group.

Finally, find out how to use the 60+ financial statement included with the Adagio sample data with your own organization's chart of accounts. Find out how to do a departmental comparative statement, and how to add additional departments to an existing comparative. Time will be spent reviewing the very useful SuperSpec90, an indispensable tool when creating your own statements. Find out how Statement Groups can be organized to automate the generation and distribution of month end statements. 

Hands On. Laptop Required. 

Invoices arrive in your organization, require someone’s approval, expense coding, entry and payment. This workshop will follow an invoice through a typical organization, discuss various approval points and review entry of the invoice. With Adagio DocStore, invoices can be captured and approved electronically and automatically attached to the check’s remittance advice on payment. Find out how expense distributions can speed entry of invoices in Payables. See how to control Vendor Payments and use the System Check Run to automatically select and pay invoices that are due. Discover best practices for the issuance and control of manual checks. See how Adagio DocStore lets people instantly review the original invoice without making a trip to the filing cabinet. In fact, document filing may become a thing of the past!

Excel remains the tool of choice for many professionals when building financial models, including forecasted financial statements and budgets. Yet many of these same professionals have never received any training on the best practices associated with generating financial modeling spreadsheets. Participate in this session to learn many amazing techniques that will not only help you save valuable time when building your Excel-based models but will also improve the accuracy and quality of your results.

Major Topics Covered

• Design considerations for Excel-based models
• Advanced options for analyzing your models
• Troubleshooting your models
• Formatting reports for improved readability

Learning Objectives
Upon completing this session, you should be able to:

• Identify ten best practices for creating financial models in Excel
• Utilize Excel features and add-in services for sensitivity, trend, and discounted cash-flow analyses
• Create optimization models using Excel's Solver tool
• Implement procedures for eliminating errors in Excel-based financial models
• Incorporate various formatting techniques to improve the usefulness of reports