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.
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
A/P Credit Memos
A/P Manual Checks
A/R Credit Memos
Chart of Accounts
Offset Account Assignment
Customer Ship Address Header
Accounts Receivable Billing
One Time Charges Information
Acquisition, Location, Responsibility
& Valuation Codes
Custom Depreciation Codes
Processing Group Codes
Workers' Comp Codes
State Tax Codes
Local Tax Codes
P.O. Item Codes
Bill of Materials Content
Sales Order Entry