A common question that I see asked by many clients is where do I go to find information about a new accounting system and who will implement the new system? 

An interesting but disturbing trend that I see is smaller audit firms recommending and implementing accounting software for their audit clients.  This brings up an interesting question of independance by the audit firm.  The potential conflict lies in the fact that the audit firm is in essence auditing their own work.  The revenue generated from selling accounting software and the related audit fee's frequently exceed the fee's generated for the Independant financial audit.

For those of you that do not have a short memory, many of you can remember the Enron debacle.  This is an example of an audit firm generating large consulting engagements and also performing the financial audit.  

Here is what the AICPA says about conflicts of interest.

GAO Yellow Book: Auditor Independence

In 2003, the GAO enacted significant changes to the auditor independence requirements under Government Auditing Standards . Commonly referred to as the Yellow Book, this guide covers federal entities and those organizations receiving federal funds. Various laws require compliance with the comptroller general's auditing standards in connection with audits of federal entities and funds. Furthermore, many states, local governments, and other entities, both domestically and internationally, have voluntarily adopted these standards.

Although the standard deals with a range of auditor independence issues, the most significant change relates to the rules associated with nonaudit, or consulting, services. Auditors have the capability of performing a range of services for their clients. However, in some circumstances, it is not appropriate for them to perform both audit and certain nonaudit services for the same client. In these circumstances, the auditor, their client, or both will have to make a choice about which of these services they will provide.

The focus of the changes to the auditor independence standard is to better serve the public interest and to maintain a high degree of integrity, objectivity, and independence for audits of government entities. The standard includes a principle-based approach to addressing this issue, supplemented with certain safeguards. The new independence standard for nonaudit services is based on two overarching principles:

1. Auditors should not perform management functions or make management decisions.
   
2. Auditors should not audit their own work or provide nonaudit services in situations where the amounts or services involved are significant or material to the subject matter of the audit.

For nonaudit services that do not violate these above principles, certain supplemental safeguards have to be met, for example: (1) personnel who perform nonaudit services are precluded from performing any related audit work, (2) the auditor's work cannot be reduced beyond the level that would be appropriate if the nonaudit work was performed by another unrelated party; and (3) certain documentation and quality assurance requirements must be met.

The standard includes an express prohibition regarding auditors providing certain bookkeeping and recordkeeping services, and limits payroll processing and certain other services, all of which are presently permitted under AICPA auditing standards. At the same time, the standard recognizes that auditors can provide routine advice and answer technical questions without violating these two principles or having to comply with the supplemental safeguards. The standard also provides examples of how certain services are treated under the rules.

Here is a link to there site.  http://www.aicpa.org/audcommctr/toolkitsnpo/Independence_and_Related_Topics.htm

Here is what the Journal of Accountancy says about GAO standards.

Essential Compliance Precepts
Two overarching principles are critical to understanding the new nonaudit services rules:

Audit organizations (referred to in this article as “firms”) should not provide nonaudit services that involve performing management functions or making management decisions.
Firms should neither audit their own work nor provide nonaudit services in situations where the nonaudit services are significant or material to the subject matter of audits.

Here is a link to there site. 
http://www.journalofaccountancy.com/Issues/2002/Nov/TheNewGaoIndependenceStandardWhatAuditorsNeedToKnow.htm

 

We are frequently asked the question on what should we do to make sure that we are properly backing up our FundWare or Financial Edge data?  It is important to make sure that you backup solution takes into account the ability to properly backup your SQL tables.  Many third party backup software solutions sell an add-on product to achieve this task.  For example,  Symantec Backup Exec sells an additional software module called Symantec Backup Exec 2010 Agent for Microsoft SQL License.  It allows you to have point in time restores.  It allows you to make backups of SQL while the database is running.  Also, restoring data is made quite a bit easier with the agent. 

It is also important to make sure that you are backing up all of the required components for FundWare.  If you do not have the additional FW proprietary databases backed up, you will not be able to restore your data. 

Last of all, many people setup their backup system but not review their logs for errors, skipped files, etc.  It can be a costly assumption to make that if the tape is popped out of the tape drive that it must contain all of your required data.  I think that the most important step that is rarely ever completed is to test your restore procedures.  If you had a catastrophic event, do you have all of the pieces required to get back up and running?  Some things to consider are:

Do you know where you software CD's are located?
Do you know where the license key's are located?
Do you have an inventory of all other applications that are residing on the server?
Do you have all of the data required to restore?
Do you know where you would get replacement hardware and how long it would take to procure?

At the end of the day, how do you know it will work until you test out your process?

I recently had a chance to view a presentation of a Budgeting system that integrates with both Blackbaud Financial Edge and FundWare.  This budgeting module has some significant features that many of our clients have been looking for over the years.  The product is called City Vision and it was written by PowerPlan Corporation.  This product allows the chart of accounts and actual accounting data to be uploaded into the software.  From there, it can be manipulated and run through several different scenario's to ascertain your final budget.  Once the budget is finalized a file is then uploaded into the accounting application.  Once the final budget has been loaded it is available for your normal actual vs. budget reporting.  Examples of some its advanced features include:

- FTE budgeting.  Employee's can be budgeted based on hire or termination dates.  
    -Allocation of benefits to budget line items
    -Budgeting of seasonal employee's
    -Payroll computations such as FICA, etc.
    -Map payroll periods to budget periods
    -Allocate employees to multiple departments or projects
    -Allow mass changes by job classification

Capital Budgets
    -Define supporting details for the requests, including cost details, and sustaining notes
    -Accomodate asset depreciation
    
Also, all of the standard functionality that you would expect in a budgeting system exist such as:

    -Typical operating budget what if scenario's
    -Viewing line item budget details and notes
    -Publishing budget guidelines and assumptions
    -Review multiple years information

Overall, it was a very impressive presentation.  The level of detail that can be utilized is better than anything that we have seen to date.  

If you would like some additional information about this product, please let us know and fill out the sales contact form located under "Contact" on the main navigation bar.   

For those FundWare clients that wish to take advantage of some of the functionality with the Blackbaud Financial Edge product, there is currently an upgrade credit available for the entire amount that you paid for FundWare.  In essence, you would get the corresponding Financial Edge module at $0.00 cost.  If you are looking at adding additional modules or users then applicable pricing would apply.

Please contact us for specific information about differences in functionality between the two products.