Allocations Module

MSCertUSL Financials Allocation modules contain all of the necessary functions to perform data extraction, manipulation and posting. Any data stored in the General Ledger or Project Accounting modules can be used as a source or basis for allocations, and computed results can be reviewed before posting.

ALscreenr

The Allocations modules have features specifically designed for the non-profit and government markets. Allocations are integrated with the General Ledger and Project & Grant Accounting modules. Some of the various types of allocations provided include: Indirect Costs and Revenue Recognition; Fringe Benefits; Interest; and Costs such as Telephone or Postage.

MSCertUSL Financials Allocation modules contain all of the necessary functions to perform data extraction, manipulation and posting. Any data stored in the General Ledger or Project Accounting modules can be used as a source or basis for allocations, and computed results can be reviewed before posting.
ALscreenr2

The Allocations modules have features specifically designed for the non-profit and government markets. Allocations are integrated with the General Ledger and Project & Grant Accounting modules. Some of the various types of allocations provided include: Indirect Costs and Revenue Recognition; Fringe Benefits; Interest; and Costs such as Telephone or Postage.

Features

Allocate from one or more amounts
• Cost, expense, overhead charges.
• Income, earnings.
• Asset, liability, other dollar amounts.
• Any numerical value to two decimal point precision.

Allocate amounts to
• General ledger account numbers containing cost, revenue centers.
• Departments, operating divisions.
• Projects, events, campaigns.
• Managers, other personnel levels Products, services.
• Any entity or purpose.

General
• Review, approve and post allocated amounts in real-time.
• Preview entries prior to posting
• Fixed rates or calculated percentages based on posted transactions
• Fringe Benefits Allocations
• Fringe benefits may be calculated either using a fixed rate or based actual on actual costs.

Download Allocations Cut Sheet

Revenue Recognition And Sponsor Billing
Most Federal Grants or Contracts are paid out on a reimbursement basis. As grant or project related expenditures are made, the Allocations module allows the user to automatically create revenue recognition journal entries.
• Create invoice rules to generate revenue.
• Generate custom invoices to ensure compliance with each sponsor’s billing restrictions.
• Generate revenue and billing one project at a time or all at once.
• Release revenues from restriction for Temporarily Restricted Funds.

Interest Allocations (IA)
When grants and funds held in trust and invested the interest can be al-located back to the rightful owners.
• Interest earned on cash/investment accounts (CD’s, etc.) can be allocated based on the average daily balance.

Indirect Cost (IDC) Allocations
The Allocations module allows you to create an indirect cost (IDC) al-location (i.e. Facilities and Administration Costs) that can include an unlimited number of designated expense accounts. This easily allows you to recover overhead costs and charge them back to the appropriate project or grant.
• User-defined indirect cost pools.
• Option to allocate using Negotiated Rate or Year-to-date Actual Costs.
• Rate vs. Actual Comparison reports.
• Budget and cut-off limits enforced.
• Integrated direction into the Grants Management module.
• Generate allocations one project at a time or all at once.

Cost Allocations
Direct Costs can be allocated across various departments, divisions, and cost centers.
• Use any allocation factors (i.e. SQ Feet, Head Count, or FTE).
• Import rules from Excel.
• Unlimited individual allocations can be defined.
• Unlimited number of source and destination accounts.

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, and PQ.
• Security by Project, Sub-Project, and Funding Source (Grant).

Send this to friend