Interfacing Applications with Sage Fund Accounting
Bringing data electronically into your accounting system can save valuable time, as well as help assure the accuracy of the information itself. This process typically falls into one of the two categories-
- Data Interface - recurring information imported into Sage Fund Accounting (formerly MIP) from another software program.
- Data Imports - one-time information being transferred from your existing accounting system or an electronic worksheet.
DWD has specialists that are available to help with either type of service.
Data Interface
Often times organizations strive to maintain all of their financial data in one accounting application. It can certainly simplify things. But what happens when the chosen application is very strong in one area, but leaves much to be desired in another? Do you limp along and make do with what you have, or do you find a way to benefit from a solution that builds upon the strengths of multiple applications?
Incorporating the capabilities of Sage Fund Accounting and the talents of the DWD staff, we are able to assist our clients in building a "best of breeds" solution. Using the Data Import/Export module we can "map" data from one application and then import it electronically into Sage Fund Accounting. Once created, these import programs can be accessed week-after-week, month-after-month - however frequently the information is needed in your accounting program. Several of our clients have made use of interfaces for-
- Third Party Payrolls - whether ADP, Paychex, or another vendor, payroll history is one of the most commonly imported pieces of financial information.
- Specialized Billing Applications - as an example, many of our healthcare clients use specialized billing packages to create and track customer bills. This information is then imported into Sage Fund Accounting (normally on a summary basis). The billing application serves as the subsidiary ledger, with the accounting system maintaining the control total.
- Microsoft Excel Worksheets - where accounting entries are driven by sophisticated spreadsheet formulas or based upon copying & pasting large amounts of data, these calculations can be done in Excel and easily imported to Sage Fund Accounting.
As can be seen from the following information, the above list is certainly not all-inclusive.
Information That Can Be Imported Into Sage Fund Accounting
|
Transaction Entry
Cash Disbursements
Cash Receipts
Journal Vouchers
Budget Entries
A/P Invoices
A/P Credit Memos
A/P Manual Checks
A/R Bills
A/R Credit Memos
A/R Receipts
Encumbrance
Encumbrance Liquidations
General Ledger
Chart of Accounts
Account Assignments
Closing Accounts
Offset Account Assignment
Distribution Codes
Check Spoilage
Accounts Payable
Vendor Information
1099 Adjustments
Accounts Receivable
Customer Information
Customer Ship Address Header
Accounts Receivable Billing
Charge Codes
One Time Charges Information
Bank Reconciliation
Reconciling Entries |
Fixed Assets
Asset Type
Designation
Acquisition, Location, Responsibility
& Valuation Codes
Assets
Depreciation Codes
Custom Depreciation Codes
Payroll
Distribution Codes
Processing Group Codes
Earnings Codes
Benefit Codes
Deduction Codes
Workers' Comp Codes
Leave Codes
State Tax Codes
Local Tax Codes
Employee Information
Timesheets
Balance Adjustments
Purchase Order
P.O. Item Codes
Bill of Materials Content
Inventory
Inventory Adjustments
Order Entry
Sales Order Entry
Multicurrency
Exchange Rates
|