Joining Separate Worlds
General Ledger is the heart of Concert Series™, NGS' comprehensive financial management system. It provides an easy-to-use, full-function, high-performance and low-support solution that exploits the best of today's IBM System i (AS/400) and Windows desktop software environments.
However, if you're an accountant, you probably prefer a Windows point-and-click, drag-and-drop work environment for financial reporting and detailed data analysis.
Now, ConcertPro provides the bridge you need. With ConcertPro, you can download your Concert Series General Ledger (G/L) data to Microsoft® Excel worksheets and also upload budgets and transactions to your Concert Series G/L files. Teamed together, ConcertPro, Concert Series G/L, and Excel provide you with the benefits of both the System i and Windows.
ConcertPro Bridge
ConcertPro's ability to download your Concert Series G/L data from the System i provides a dynamic link to quickly and accurately update your Excel spreadsheets automatically with the latest G/L data. Once your data is downloaded, you can use Excel to filter, produce automatic subtotals, or create other custom worksheet views. You can use Excel's extensive formatting and graphing capabilities to create presentation-quality reports, such as pie charts, graphs, tables, and 3-D charts.
With the results downloaded into your favorite spreadsheet, duplicate data entry is eliminated.
In addition, ConcertPro allows you to take a general journal entry from an Excel worksheet and upload it through the outside system interface to automatically create a posting batch.
Easy Financial Statements
Excel's drill-through capability allows you to pull totals and subtotals from a single "download sheet" into one or many master report sheets, such as a Statement of Income or Balance Sheet. There's no need to recreate your standard reports each month—just update automatically from your System i database.
Down to the Detail
Specify an account and let ConcertPro download detail to posted journal history. Detail can include G/L effective date, transaction amount, description of activities, journal code, source code and more!
Budgeting Asset
ConcertPro can simplify budget planning by importing your Concert Series G/L budget and actual expenditures into Excel from your G/L database.
Within Excel, you can set up a budget planning sheet that shows, account by account, the variance, percentage of increase or decrease, future year projected budget amounts, and explanatory comments. When you finish setting the new budget amounts, you can automatically and systematically transfer those results to your G/L accounts on the System i.
Freeze and Thaw
Before you disconnect from your System i, ConcertPro allows you to "freeze" formulas. When you resume your work, ConcertPro "thaws" the formulas, ensuring your most recent calculations, etc. are ready to use.
The "freeze/thaw" feature is especially beneficial for your traveling and remote users. They can connect to your System i to download the data they need and "freeze" formulas before disconnecting. Then, working offline, they can create presentations and reports, change formatting, and more. When they reconnect to the server, the "thaw" function recalculates formulas, and the most recent data and balances download into ConcertPro.
Streamlined, Secure Access
ConcertPro streamlines and simplifies the entire data analysis process for you and your end users by providing ease of use, accuracy, and access to your most recent accounting data. Since we understand that security is of primary concern when users are accessing your financial data, ConcertPro performs in strict compliance with i5/OS security.
The product allows you to make the most of both the midrange and Windows worlds:
- From Your IBM System i: Data integrity, processing power, reliability, and security.
- From Your PC: Familiar Excel application, customized reporting, and upload capabilities.
Concert Series and ConcertPro are trademarks of New Generation Software, Inc. All other trademarks are the property of their respective owners. |
