How Grant Management Integrates with Other Lawson Applications

General Ledger

General Ledger is the financial repository for the overall organization. It is the basis for producing departmental financial statements and enterprise-wide financial reports. While the General Ledger (GL) application is used for a financial view of your organization, Project Accounting (AC) is used to provide an operational view of your organization. In GL, you will build financial structures and chart of accounts. While in AC, you will build grant and non-grant or internally funded projects.

Specifically, Grant Management Billing interfaces with GL as follows:

• You will use GL to establish Non-Grant Funding and make fund adjustments.

• You will use GL to establish your revenue recognition method for Grant Managment. Revenue methods are Accrual and modified Accrual.

• You will use GL to view/report on revenue journal entries and revenue account balances for projects and funding sources.

Accounts Receivable

Standard Accounts Receivable features let you process cash receipts and manage outstanding balances owed on a specific grant by sponsor, grant, amount, or days outstanding. You can also apply cash to outstanding grant draws by letter of credit.

For modified accrual revenue recognition, AR190/AR195 will create the GL and AC JEs required to reclassify deferred revenue to revenue when cash is received/applied for grants or other external funding.

Project Accounting

Project Accounting (AC) is the financial data repository for grants. In AC, you will build an activity structure that supports the reporting requirements and processing rules for projects and grants, including budgets and system-wide budget checking rules. You may use burdens or allocations functionality to generate fringe and F&A costs. Inquiries and reports are available to help you manage and review project and grant financial data.

You must set up Activity Groups, Activities, and Account Categories before setting up Grant Management Billing. See Project Accounting User Guide for more information.

Accounts Payable

In addition to standard Accounts Payable functionality for processing and paying invoices, you can create and maintain subcontractor vendors, charge invoices to projects, and track paid invoices for request for reimbursement and revenue recognition.

Lawson Add-ins for Microsoft Office

Excel Upload Wizard is useful for loading grant data from a pre-award system and can help streamline other data setup tasks. Use the Query Wizard to create custom Excel reports from live Lawson data. When you need to make batch changes to Lawson data, let the add-ins do some of the work for you. Use the Query Wizard to generate an Excel worksheet that contains the data records you need to change. Edit the data in Excel, and then use then use the Upload Wizard to change all the records in Lawson at one time. Data files to use with Lawson add-ins

Non-Lawson Applications

Project and grant-related data and transactions can be uploaded from non-Lawson applications, such as non-Lawson payroll systems or pre-award software. Batch import jobs are provided in Lawson for uploading transactions, employees, activities, and so on.