Microsoft Dynamics GP
Financial Management for Microsoft Dynamics GP
Business Intelligence Module
Microsoft Dynamics GP 2016 ERP Business Intelligence (BI) software offers real-time visibility to track and analyze performance. Gain greater control over financials, better manage operations and make informed decisions that drive business success.
Microsoft Dynamics GP BI solution has the power to support growth ambition with company-wide coordination, improved operational efficiency, and time-saving automation of manual processes as required for specific departments. Reduce losses, gain flexibility, and boost profitability. An SQL Server database and SQL Server Analysis Services (SSAS) provide powerful data storage and analysis capabilities, which helps foster quick and effective decision-making.
Features incorporated into Microsoft Dynamics GP Business Intelligence stack include the following:
- Optimized for Windows 8.1/RT, iOS, and Android platforms, Business Analyzer enhances mobility options to collaborate with others. Perform tasks and view SQL Reporting Services Reports and Microsoft Excel charts from one central location.
- Microsoft Excel Reports offer over 200 built-in reports that connect directly with Microsoft Dynamics GP. Create refreshable Excel reports with quick and easy access to the latest data.
- Microsoft Dynamics GP Workspace, an Office-365 application that enables users to share executive dashboards showing sales, financials, purchasing, and supply stats. Dashboards also allow users to drill back to specific transactions in MS Dynamics GP for analysis.
- Microsoft SQL Reporting Services Reports offer over 300 graphs, charts, and reports, which can be modified to meet specific needs. New reports can be created without the need for a developer.
- Management Reporter Designer and Viewer User creates, analyzes, and distributes financial statements.
- Microsoft Forecaster forecasts accurate budgets to help obtain control of the complete budgeting and planning process.
- SmartList Designer Excel Refreshable Reports enables users to create refreshable reports that can be published to the Excel report library and opened with Excel, where data will always be current.
Financial Management Module
Microsoft Dynamics GP ERP software provides detailed financial management options designed to help manage cash, assets, and banking with functions that allow for flexibility while reducing time spent on routine tasks.
Tight integration between Microsoft Dynamics GP modules enables one-time data entry and provides accurate, real-time information throughout financial functions. With access to real-time, mission-critical data, financial operations become powerful, competitive tools that enhance decision-making.
Automated transaction processing and payment adjustments improve efficiencies. Easily organize financial information with modifiable accounting structures using Microsoft Excel-based budget templates. Perform dimensional analysis of financial, sales, and purchase transactions.
Microsoft Dynamics GP 2016 ERP solution capabilities include the following modules:
- eExpense completely automates the expense management process with expense report preparation (in both online and offline formats), approvals, electronic receipt management, reimbursements, and analysis.
- Account Level Security allows users to view, enter, and edit information based on access granted for General Ledger accounts on an individual basis.
- Analytical Accounting analyzes financial data according to selected criteria. Track data by different particulars such as profit center or region.
- Budgeting leverages the ease of Microsoft Excel functionality to update, maintain, and track multiple budgets for multiple fiscal years.
- Cash Flow Management offers forecasting tools and customizable views to predict, monitor, and control inflows and outflows for tracking liquidity in an easily interpreted calendar format.
- Customer/Vendor Consolidations transfer information between Payables Management and Receivables Management to create a customer record using an existing vendor file (and vice versa) that presents a consolidated view of vendor and customer relationships.
- Encumbrance Management locates and tracks budgets, queries current and historical encumbrances, and streamlines year-end and period-end reporting procedures.
- Fixed Asset Management tracks and analyzes company assets such as buildings, equipment, and machinery. Track asset depreciation by calendar or fiscal year for tax liabilities.
- General Ledger maintains all financial journal entries with a double-entry accounting ledger that integrates seamlessly with Microsoft Excel.
- Grant Management automates grant management processes to track funds, show accountability, and help plan for future funding.
- Intercompany creates and maintains relationships between companies and tracks revenues and expenses between companies.
- Lockbox Processing supplies reliable receivables information, improved funds availability, and greater fraud protection by automatically importing and applying customer payment information from a lockbox transaction file provided by your financial institution.
- Multicurrency Management manages currency transactions of multinational operations smoothly with powerful multicurrency capabilities.
- Payables Management automates both regular and complex accounts payable tasks with easy reconciliation, payment scheduling, check printing, and real-time statistical history.
- Receivables Management manages accounts receivable with automated procedures for handling invoices, statements, finance charges, and receipts. Analyze customer activities such as credit limits and balances due.
- Revenue/Expense Deferrals allow for deferring revenues and expenses by making entries for future periods within General Ledger, Invoicing, Receivables Management, Payables Management, and Sales Order Processing.
Multicurrency Module
Microsoft Dynamics GP 2016 (formerly Great Plains) ERP solution offers robust multi-currency support for international businesses. Work with international clients and vendors, conduct financial transactions in multiple currencies, and maintain compliance with international currency standards. Manage multinational financial operations effortlessly with a simplified approach to the management of financial statistics and accounting operations when dealing with multiple currencies and fluctuating exchange rates.
The Multicurrency Management Module offers improved flexibility and control with the ability to use and maintain current exchange rates or define new ones for specific contracts or customers as needed. Set up unlimited rate types, currency IDs, and exchange rate tables. Enter multi-currency transactions by either using the originating amounts for the transaction or the equivalent of the amounts.
Microsoft Dynamics GP offers one integrated solution by extending Multicurrency Management capabilities across other Microsoft Dynamics GP modules offering the ability to revalue General Ledger accounts and Sales and Purchasing transactions based on current or estimated exchange rates.
Microsoft Dynamics GP Multicurrency Management module provides the following business processes capabilities:
- Currency Rate Definition defines an unlimited number of currencies and exchange rates and sets specific rates as needed for individual contracts or transactions.
- Customer-specific Default permits the selection of a default currency rate, a different rate, or the entry of a new rate during transaction entry to handle exceptions as needed.
- Exchange Rate Tracking tracks the time and date of exchange rates used in multi-currency transactions to facilitate audits and allow for post-transaction entries in a changing currency market.
- Extensible Multicurrency Solutions integrate with the following modules in Microsoft Dynamics GP: Bank Reconciliation, General Ledger, Intracompany Transactions, Payables Management, Project Accounting, Purchase Order, Receivables Management, and Sales Order.
- Multicurrency Inquiry provides instant access to multi-currency transactions displaying both originating and functional currencies.
- Multicurrency Reporting shows multi-currency activity in financial reports and translates existing reports into multiple currencies.
- Realized Gains and Losses automatically records and tracks realized gains and losses on sales and purchases reflecting currency rate changes.
- Standards Support aligns multi-currency transactions with international standards for reporting and accounting.
Online Reports Module
With the Microsoft Dynamics GP ERP system, the Online Reports feature moves routine accounting tasks online with the eBanking and eExpense modules. Tight integration between modules within Microsoft Dynamics GP permits one-time data entry to provide accurate, real-time information throughout your financial solution. Reduce paper waste and repetitive manual data entry. Manage financials more effectively and reduce errors via automation of vital banking and reporting activities.
eBanking
The comprehensive tools in Microsoft Dynamics GP eBanking feature aid in improving cash management in a security-enhanced environment by automating critical banking activities. Increase productivity and reduce administrative expenses by streamlining accounting processes with easy-to-use electronic reconciliations, line-item level control, improved funds availability, and intelligent adaptation to individualized banking procedures. Access transaction information online and apply transactions to accounts as they occur. Automatically apply banking transactions directly to customer accounts.
Microsoft Dynamics GP eBanking module includes the following features:
- Electronic Bank Management allows for easy setup, entry, and maintenance of all bank statement transactions, including bank charges, payments to creditors, and cash receipts from debtors. Automatically reconcile the General Ledger account with the bank statement balance.
- Electronic Bank Reconciliation automates the reconciliation of transactions and adjustments of downloaded bank data.
- Electronic Funds Transfer for Payables Management conforms to U.S. bank-industry electronic funds transfer (EFT) standards to transfer payments to the bank securely.
- Electronic Funds Transfer for Receivables Management transfers sales batches with corresponding payments and automatically generates an electronic file for bank transfers.
- Lockbox Processing processes and matches transactions from the lockbox file provided by the bank. Automatically import and export customer payment information between the bank and open accounts.
- Safe Pay adds Positive Pay functionality and exports checks daily for comparison with the bank when presented for payment.
eExpense Module
Microsoft Dynamics GP eExpense capabilities streamline expense management processes, enhance productivity, and eliminate the need for paper receipts. Employees can create and submit reports from any location, anytime. Expense data is integrated with General Ledger and Payables Management modules making it available across the system and providing a centralized view of data and trends.
Quickly and easily submit expense reports in a browser-based environment with templates and pre-populated data. Ensure accuracy, speed reimbursements, and eliminate the need for traditional spreadsheets.
Microsoft Dynamics GP eExpense module includes the following features:
- Online Expense Reporting permits the automatic submission of expenses against pre-configured or custom cost centers synced with General Ledger accounts, ensures accurate reporting with customized email-based approval procedures, and instantly captures out-of-pocket expenses with palm operating-based devices that integrate smoothly with eExpense.
- Payable/General Ledger allows for custom configuration of a wide range of best practices reports and the ability to view and filter vendor statistics.
- eExpense Offline enables complex itemization of expenses while offline, including calculating foreign exchange rates, and ensures efficient processing and reimbursements with seamless transactions to eExpense.
- eExpense Receipt Imaging stores expense receipts electronically, eliminating the need for paper and significantly reducing expenses associated with managing paper receipts.
Microsoft Dynamics GP Modules