Financial Reporter

MSCertThe USL General Ledger for not-for-profits provides flexible, built-in report writers that help you easily create reports to meet the numerous requirements of funding sources, internal management, and your board. For informed management decisions, you also have access to the transaction details behind your numbers. USL allows users to “drill-down” and review the individual transactions that make up the balances. Gain understanding behind your numbers to help you make more informed decisions.

FRscreenr

Features

General
• Multiple report writers with Report Wizards.
• Designed by CPAs in conformance with GAAP and consistent with GASB & FASB.
• Consolidate information from multiple databases, platforms, and servers.
• Create virtual roll-up structures that do not exist in Chart of Accounts.
• Report on both posted and un-posted activity.
• Extensive drill-down capabilities from Financial Summary Information into account and transaction details.
• Give greater depth and visual appeal to your reports.

System Integration
The powerful, fully integrated reporting options allow for complete control of your most demanding financial statement needs.
Directly interfaced to all USL Financials modules include General Ledger, Ac-counts Payable, Accounts Receivable, Purchase Order, Purchase Requisitions, Bank Reconciliation, and Inventory Control.

Reports
SQL Server Reporting Services
• Web-based Reporting from your Browser, Drill-down/Drill-Thru,
• Supports Matrix (Pivot Table) type reports, as well as normal Tables, Lists, etc.
• Ability to add Graphics to Reports,
• Generate Reports to HTML, Excel, Word, CSV, XML,
• Schedule Report Generation (Subscriptions),
• Create Distribution Lists (Subscriptions),
• Create reports in Microsoft Business Development Studio (Visual Studio).
• Integrated with USL’s Quick Financials Report Writer for easy report creation.

Distributed Financials Report Writer
The Distributed Financials report writer is used to send custom reports via email, with any email client, to a list of recipients associated with a given ac-count segment (fund, department, etc.). This can be useful to those who need to run pre-defined reports by department, location, etc., where these entities are part of the account number.
• Reports are exported into PDF, Word, or Excel formats and attached to an email message to a user-defined list of recipients for each component.
• Recipients do NOT have to be USL Financials users.
• Emailing may be scheduled for a certain time of day to avoid peak Inter-net traffic.
• The user sending these reports will receive a copy of each report emailed.
• These same reports may be viewed dynamically on the Internet.

Download Financial Reporter Cut Sheet

Quick Financials Report Writer
With Quick Financials, users can quickly and easily write and run their own re-ports without time consuming specifications and formatting. Examples of quick reports include:
• Budget vs. Actual Expenditures.
• Departmental Analysis.
• Revenue Analysis.
• Ability to report by Ranges of Components or Ranges of Attributes
• Up to 9 levels of nested Grouping
• Output reports to: Text, Access, Excel, Crystal, or SQL Server Reporting Services
• When using SQL Server Reporting Services
• Ability to specify control Headers and Footers
• Font Control (Size, Type, Weight, Effects, Color, etc.)
• Group by either Component or At-tribute
• Sub-Totals by Group
• Create Distribution Lists
• Schedule Email Delivery Notifications of Reports

Crystal Reports
Many of the USL standard reports are written in Crystal, allowing full drill-down to detail transactions and document data. These include:
• Trial Balance Reports.
• General Ledger Detail Report.
• Budget Analysis Reports.
• Many Others.

Other Reports
USL offers hundreds of standard reports displaying everything from a Source Code list to the Statement of Financial Position. These reports are parameter driven allowing users to view just the data and date ranges in which they are interested.

Minimum System Requirements
SERVERS
• Dual Core, 2.3 GHz or better
• 4GB RAM (32-bit Windows Server) sized by need
• 8GB RAM (64-bit Windows Server) sized by need
• Windows Server 2008 – 2012 (R2 supported) (64-bit recommended)
SQL SERVER
• Microsoft SQL Server 2008 – 2014 (R2 supported) (64-bit recommended)
TERMINAL SERVER (if utilized):
• Dual Core, 2.3 GHz or better
• 4GB RAM (32-bit Windows Server) sized by user count
• 8GB RAM (64-bit Windows Server) sized by user count
• Windows Server 2008 – 2012 (R2 supported) (64-bit recommended)
CLIENT WORKSTATIONS
• Core 2 Processor, 2.3 GHz or better
• 2GB RAM or better
• Microsoft Windows 7 (SP1) – Windows 10 Pro
• Microsoft Office Professional 2007 – 2016 (32-bit only)

Online Help
USL Financials contains context-sensitive, online help for all features and functions of the system.

Security
Full USL Database, Module, Menu, Function, Action and Account Level security options relative to the system security.
• Full security by Delivery Location in PO and PQ.
• Departmental Security via Workgroups in A/P, A/R, GL, & PQ.
• Security by Project, Sub-Project, and Funding Source (Grant).

System Integration
The powerful, fully integrated reporting options allow for complete control of your most demanding financial statement needs.
Directly interfaced to all USL Financials modules include General Ledger, Ac-counts Payable, Accounts Receivable, Purchase Order, Purchase Requisitions, Bank Reconciliation, and Inventory Control.
GL accounts, accounting periods and budgets are verified through the Control System module.

Send this to friend