Breeze Accountants Worksheet Features

Breeze Accountants Worksheet - Features

General Ledger Worksheet

The General Ledger Worksheet is the heart of the system. It is an electronic rendition of the classic manual Accounting Worksheet used by Accountants to adjust General Ledger balances in the process of preparing Financial Statements and closing an accounting cycle. Often referred to as Trial Balance Software.

The General Ledger Worksheet has many powerful 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.

XL 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.

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

The following are required in order to use the XL Template.

An installed version of Microsoft Excel capable of working with Excel 2000 format files.
Microsoft ActiveX Data Objects 2.8 Library. (Download At Microsoft.com)
You must enable macros or enable content as applicable.