IMPORTING DATA INTO ABILA MIP FUND ACCOUNTING

Bringing data electronically into your accounting system can save valuable time, as well as help assure accuracy of the information itself.  This process typically falls into one of two categories.

  1. Data Imports – one-time information being transferred from your existing accounting system or an electronic worksheet.
  2. Data Interface – recurring information imported into Abila MIP Fund Accounting™ from another software program.

DWD has specialists that are available to help with either type of service.

Data Imports

When setting up a new Abila MIP™ database or adding additional modules to an existing one, many of our clients choose to import information rather than re-key it.  Examples include –

  • Vendors & Customers – ID #’s, names, account #’s, addresses, phone numbers, terms, 1099 information, etc.
  • Transaction History – prior year(s) information (actual and/or budget) in either summary or detail, thus allowing comparative financials to be run immediately from the new software.
  • Payroll Data – ID #’s, names, addresses, SSN’s, pay rates, benefit codes, deduction codes, leave codes, tax information, etc.
  • Fixed Assets – tag numbers, descriptions, locations, acquisition costs, useful lives, depreciation methods, accumulated depreciation balances, warranty information, replacement costs, etc.
  • Chart of Accounts – general ledger codes, programs, grants, locations, departments, reporting units, projects, etc.

As can be seen from the following information, the above list is certainly not all-inclusive.

Information That Can Be Imported Into Abila MIP Fund Accounting:
 
Transaction Entry
Fixed Assets
Cash DisbursementsAsset Type
Cash ReceiptsDesignation
Journal VouchersAcquisition, Location, Responsibility & Valuation Codes
Budget EntriesAssets
A/P InvoicesDepreciation Codes
A/P Credit MemosCustom Depreciation Codes
A/P Manual ChecksPayroll
A/R BillsDistribution Codes
A/R Credit MemosProcessing Group Codes
A/R ReceiptsEarnings Codes
EncumbranceBenefit Codes
Encumbrance LiquidationsDeduction Codes
General LedgerWorkers’ Comp Codes
Chart of AccountsLeave Codes
Account AssignmentsState Tax Codes
Closing AccountsLocal Tax Codes
Offset Account AssignmentEmployee Information
Distribution CodesTimesheets
Check SpoilageBalance Adjustments
Accounts PayablePurchase Order
Vendor InformationP.O. Item Codes
1099 AdjustmentsBill of Materials Content
Accounts ReceivableInventory
Customer InformationInventory Adjustments
Customer Ship Address HeaderOrder Entry
Accounts Receivable BillingSales Order Entry
Charge CodesMulticurrency
One Time Charges InformationExchange Rates
Bank Reconciliation
Reconciling Entries
Abila and Abila MIP Fund Accounting™ are trademarks and registered trademarks of Abila, Inc. in the United States and other countries. They are used by permission.