The Classic Accounting Worksheet in Electronic Form

CompAcct Solutions Ltd. wishes to announce the release of Breeze Accountants Worksheet 2011 Version 1.0. The software was developed for use by Public Accountants and Accounting Managers to adjust General Ledger account balances in the process of preparing Financial Statements and closing an accounting cycle.

Breeze Accountants Worksheet is an electronic rendition of the classic manual Accounting Worksheet used by Accountants to adjust General Ledger account balances in the process of preparing Financial Statements and closing an accounting cycle. The program is designed to provide a software Accounting Worksheet system where the Accountant needs to formalize the process of identifying and documenting adjustments such as in Public Accounting engagements, often referred to as Trial Balance Software or Client Write-Up Software.

It is also designed to be a combination or consolidation software system, through the use of flexible balance importing, for multi entity groups that use a diverse range of accounting software. Balances can be imported from Excel Accounting Reports. After importing balances into the system, consolidation or combination calculations can be done and adjustments can be made on the consolidated or combined balances.

One of the key features offered by the program is General Ledger standardization through account mapping. What this means is that a single standard General Ledger template could be prepared and then a wide range of diverse General Ledger software systems can be mapped into the standard template.

The program includes Financial Statement Software in the form of an Excel Macro template that uses custom functions to retrieve program data for use in preparing Financial Statements and Analysis in Excel.

As the program is designed to be technically similar to the classic textbook Accounting Worksheet, the program may be of assistance to students of Accounting when learning worksheet operations.

Here is a list of some of the key features:

* Multi-Dimensional Numbering - The General Ledger Numbers are a unique combination of a Number, a Company ID and a Department ID.
* Account Mapping - General Ledger Accounts can be mapped to external Accounts to provide a standard General Ledger Account System for a diverse range of Accounting Software.
* Adjustments - Standard accounting adjusting entries are summarized in a calculated column in the Worksheet for the computation of the Adjusted Balance for the General Ledger Accounts.
* Reclassifieds - Reclassifieds are used to adjust General Ledger Accounts balances for reporting purposes only without formal posting to the accounts. Reclassifieds are summarized in a calculated column in the Worksheet for the computation of the Adjusted Balance for the General Ledger Accounts.
* Drill Down Capabilities - The Transactions List( Adjustments and Reclassifieds) for a General Ledger Account can be drilled into from the Worksheet.
* Working Paper Reference - Each account can be referenced to a Working Paper
Financial Statement Assembly Reference - Each account is related to a system Financial Statement Account that is a reference for Financial Statement Assembly.
* Comparative Balances - Each account can have as many as 12 Comparative Balances which can be aliased for reference such as Prior, Budget, etc.
* Hyperlink - Each account can have a Hyperlink to an external document.
* Memos - Each account has a memo field for retaining additional account information.
* Import Data - Accounts can be Inserted and Balances Updated using data Imported from an Excel Accounting Report file. Most modern day Accounting Software has an Excel Export Feature.
* Block Account Changes - A chart of accounts for a multi - department, multi-company entity can be rapidly developed and maintained using Block Account Changes for copying, deleting, cloning and merging accounts by block.
* Copy Account Assignments - Importing Data involves the use of default assignments for account types. Copy Account Assignments is a procedure for rapidly changing default account type assignments.
* Calculated Columns - Provide real time changes and can be posted if needed.
* Balance Differential Assignment - A Comparative Balance differential can be assigned to a Balance column.
* Balance Maintenance - Procedures for rolling over or clearing balances.
* Period Closing Procedures Macro - Step by Step closing procedures.
* Combine Departments - The Adjusted Balance for Each Department ID is combined into the UnAdjustedBalance in Department ID = 0 which can then have its own Adjustments and Reclassifieds to calculate Adjusted Balances. Comparative1-12 Balances can also be combined.
* Consolidate Companies - The Adjusted Balance for each account in each Company ID and Department ID is consolidated into the UnAdjustedBalance in the respective Department ID of the Consolidated Company ID = 0 which can then have its own Adjustments and Reclassifieds to calculate consolidated balances. Comparative1-12 Balances can also be combined.
* Draft Financial Statements - The Financial Statement Accounts are used to group, calculate and assemble the General Ledger Accounts for Financial Statement Purposes.
* Reports - Numerous Worksheet Reports.
* Export - The Data Grid can be Exported to an Excel 97 formatted file in database format using a range name that can be operated on with the Excel VLOOKUP function.

The program includes Financial Statement Software in the form of an Excel Macro template that uses custom functions to retrieve program data for use in preparing Financial Statements and Analysis in Excel.

The XL Template is a Visual Basic for Applications (VBA) macro programmed Microsoft Excel 2000 workbook with Custom Functions that are called directly on a Breeze Accountants Worksheet database file through an ActiveX Data Objects (referred to as ADO) connection to the database file. It provides two basic functions to retrieve data directly through the connection to prepare sophisticated Financial Statements and Financial Analysis such as ratio analysis.

BAW_Lookup
BAW_Sum

Printer Friendly

Email Page

Sponsor Message