System Manager
General Ledger
Accounts Receivable
Accounts Payable
Currency Manager
Sales Orders
Purchase Orders
Project/Job Costing
Bill of Materials
U.S. Payroll

Learn more
View Web Help

AdaptAccounts source code accounting software for Microsoft SQL Server


General Ledger and Financial Reporter

User-defined Account segments. AdaptAccounts for SQL Server 2012 supports up to four user-defined Account segments and is extensible to more. The true underlying field names are generic and are mapped to user-defined names in forms and reports. Standard Account views are locally modifiable to reflect user-defined names directly.

Chart of Accounts setup. The system provides easy-to-use facilities to generate valid Accounts based on combinations of selected segments. Accounts can be checked for display in Account lookup in Receivables and Payables tasks and equivalents. This helps to reduce the clutter than can otherwise occur when all Accounts are shown in a lookup.

Click here for a sample screen-shot for "Chart of Accounts maintenance".

Real-time maintained Account Balances. Balances are maintained and updated immediately when Journal Entries are posted.

Unlimited Bank accounts. You can set up as many different Bank accounts as you need.

Bank Reconciliation. This supports reconciling transactions affecting Bank accounts including bank deposits, bank charges, Payables checks and Payroll checks. Items are reconciled on a detail line item basis so that an individual Journal Entry affecting multiple Bank accounts is properly supported.

Click here for a sample screen-shot for "Bank Reconciliation".

Multiple Budgets. You can define multiple budgets such as standard, best case, worst case etc. All relevant Maintenance, Inquiry and Report tasks fully support multiple budgets.

Transaction entry. Lookup help for General Ledger Accounts is always available. You can specify a list of common General Ledger Accounts for each transaction Type. These Accounts are presented as you enter each transaction so you can just fill in the amounts as applicable. And you can just ignore any Accounts that aren't involved in that transaction. While entering transactions you can browse through all of them and make any corrections required. Pre-posting listings are available. Transactions are not Posted until your request. You can Post an individual transaction or you can Post a group of transactions.

Transaction importing. Transactions originating externally can be easily imported. All you need to do is insert them into the Import tables for General Ledger. This may be done by any SQL Server database-compliant process. The Import process first applies the business rules to validate the candidate transactions and identify any errors. Valid transactions are then posted to the General Ledger and removed from the Import tables. Invalid transactions remain in the Import tables with their errors identified so you can easily correct and resubmit them.

The entire import facility may be driven externally. The import tables can be loaded by an external process. Importing occurs using a database stored procedure that may be invoked externally. The procedure can be called to import just a single transaction or a group of transactions or all available transactions.

Flexible Account views. The system supports two optimized forms for viewing Accounts with their Balances and transaction details. View Accounts and Period Balances is optimized for a single period at a time. View Accounts and Balances supports viewing all periods for a year. The year, period and budget selection can be changed as you wish within the tasks. Transaction details and balances can also be displayed or not as you wish. 

Click here for a sample screen-shot for "View Accounts and Period Balances" with transaction details suppressed.

Expanded detail views. Viewing Account balances shows expanded details for all Journal Entries affecting a Balance. This displays the individual transactions that comprised a Journal Entry originating from another application such as Accounts Receivable or Accounts Payable. When viewing one of those transactions you can also drill-down further to see the full details of the transaction. When viewing one of those transactions that itself has further detail (such as viewing an Accounts Payable transaction derived from from a Purchase Order Receipt) you can drill-down further to see the full details of the originating transaction.

Click here for a sample screen-shot for "View Accounts and Balances" showing expanded transaction details.

Powerful multi-level drill-downs. When viewing Journal Entries that originated from another application such as Accounts Receivable or Accounts Payable you can drill-down and view all the individual transactions comprising that Journal Entry. When viewing one of those transactions that itself has further detail (such as viewing an Accounts Receivable transaction resulting from a Sales Invoice) you can drill-down further to see the full details of the originating transaction.

Unrestricted actual and budget history. You can maintain as many years of Actual and Budget summary history by Account as you want. You can use the full power of other database query programs for further analysis.

Accrual (auto reversing) journal entries. During transaction entry you can mark a Journal Entry as Auto Reverse so it automatically generates the reversing Journal Entry for the next period.

Recurring journal entries. Full support for maintenance and processing of recurring journal entries is built-in. It provides a flexible cycle-based approach with protection against transaction duplication.

Reversal journal entries. You can reverse a Journal Entry easily. Full audit trail details are preserved.

Budget encumbrance support. This enables tracking Purchase Order commitments in addition to actual expenses incurred.

Allocation support. You can generate allocation transactions using easily maintained allocation control tables.

12 or 13 accounting periods. AdaptAccounts supports both 12 and 13 period fiscal years. When multiple Companies are installed each Company may have a different fiscal year setup.

Table driven Financial Reporter. The Financial Reporter lets you specify titles and account groupings using a powerful, easy to use table-driven approach. Example layouts for Balance Sheet and Income Statement are included. You specify how you want your financial statements presented by filling in the control tables.

Click here for a sample screen-shot for "Financial Reporter Reports maintenance".

Multiple period Financials. Income Statements can span any range of periods within the year. For example, you can produce a quarterly or half-yearly Comparative Income Statement just as easily as for just one period.

Comparative Financials. Financial statements support comparisons with Budget; and to the same period, or range of periods, for Last Year; or to the Final Period of Last Year.

Relational account groupings for Financials. Many traditional systems can only summarize contiguous accounts together. Restricting summaries to just contiguous accounts can cause problems such as when additional accounts are added but there's no room where their related accounts are. Solving this problem with traditional systems often means having to completely renumber the entire chart of accounts. Since AdaptAccounts was designed from the ground up for the modern relational database environment it handles these requirements with ease. So your system isn't limited by the restrictions of the past.

Time independent Financials. You can produce financial statements for any year and period range you wish. You can produce preliminaries and run them again later to reflect subsequent transactions affecting that period.

Easy report changes. All reports are based on a visual report designer so they can be readily changed. Additional reports may also be readily created using any report designer tools for Microsoft SQL Server 2012.

Company   Products   Downloads   Support   Partners   Contact Us

Copyright 1995-2012 Adapta Software Inc. All rights reserved.  Legal Notices.