Paperback Version Available – The Little Book of Local Government Fraud Prevention

I am happy to say you can now purchase a paperback version of The Little Book of Local Government Fraud Prevention on Amazon. Click here to see the book on Amazon.

Is it possible for a city comptroller to steal over $53 million from a city of just 16,000 people? Would a bookkeeper take money from a health department while she herself is dying? Could a sweet-natured tax commissioner embezzle funds to feed her cocaine habit? In The Little Book of Local Government Fraud Prevention you will learn how and why fraudsters steal. You’ll also discover how to detect and prevent fraud. This book includes easy-to-use fraud prevention checklists, transaction cycle analysis, and fraud prevention tips. Whether you’re an auditor, a fraud prevention specialist, a government accountant, or an elected official, you’ll learn to protect your government’s assets.

I look forward to being with the good folks of middle Georgia on August 22, 2014. McNair, McLemore, Middlebrooks & Company is putting on its annual multi-topic CPE class. I will be presenting “Steal Like a Boss” — fraud from the perspective of those who steal.

Date:August 22, 2014
Event:McNair, McLemore, Middlebrooks & Co., LLC Multi-topic CPE
Topic:Steal Like a Boss
Sponsor: McNair, McLemore, Middlebrooks & Co. LLC
Venue: Idle Hour Country Club
Location:Macon, Georgia
Public:Private

Half the troubles of this life can be traced to saying yes too quickly and not saying no soon enough.

 

 

Essentialism: The Disciplined Pursuit of Less (Crown Business)

Learning To Use Pivot Tables in Less Than Five Minutes

Pivot tables are one of the more powerful ways to summarize data in Excel. You can create meaning from mounds of information by using this tool. Pivot tables sound daunting, but I’m betting you’ll understand them after watching this five minute video from Titan Tech Training. (The video takes about 10 seconds to start after you hit play.)

Using Basecamp To Manage Audits

This post provides information about using Basecamp to manage audits.

Most auditors do not plan. We repeat, using the same prior year procedures and processes.

The result: increased audit risk and lower engagement profit–just what we don’t want.

Using Basecamp to Management AuditsThe Problem

We make carbon copies of prior year work papers with updated numbers. By performing the same audit steps and not incorporating procedures responsive to current risks, we leave ourselves exposed, with the potential for issuing errant unmodified opinions. Also, our profit margins lessen as engagement time balloons–auditors tend to add audit steps and don’t prune away the old. It’s the worst of both worlds: increased risk and lower profit.

A Solution

Could project management help?

Yes.

When I use the phrase project management, I mean a formal method–might I even say discipline–in planning and executing procedures. Yes, I am using the “D” word: discipline. And why might we avoid project management? Let me use the “L” word: lazy. Right now you are probably thinking, “Charles, are you asking me to think more? Don’t you know how stressed I am?”

But would project management require more thinking? Project management requires us to think more early on and less overall. And, by doing so, you will have less stress. With appropriate discipline, we decrease the overall effort to complete the job.

A lazy auditor simply repeats without thinking (no planning). A disciplined auditor plans and then acts. Motion without thought is just wasted energy. It might look impressive but achieves nothing.

The Project Management Institute defines project management as a temporary group activity designed to produce a unique product, service or result. A project is temporary in that it has a defined beginning and end in time, and therefore defined scope and resources. And a project is unique in that it is not a routine operation, but a specific set of operations designed to accomplish a singular goal.

Project management for auditors includes:

  • Identifying project stakeholders, their needs, and their participation
  • Planning tasks to be performed (even if you’ve done the job a hundred times)
  • Creating a timeline
  • Creating and assigning tasks
  • Identifying potential bottlenecks
  • Identifying risks (during planning and fieldwork)
  • Monitoring task completion

Most electronic work paper files are used to manage projects. Visually you can see what is complete and what is not. Auditors scan the work paper sign-off list as one way to monitor the project. But what if you have four or five simultaneous audits? Or maybe you’re out of the office with just a cell phone. How do you see the status of your audits? How do you remember all that needs to be done?

Basecamp Project Management Software

What project management software do I use?

Basecamp.

I normally have about a dozen projects (e.g., audits, peer reviews, CPE classes I’m planning to teach) at any one time, so it’s challenging to keep everything moving in the right direction. Basecamp enables me to do just that.

Basecamp allows me to:

  • Carry on discussions with audit participants
  • Create to-do lists
  • Assign tasks to project participants with desired completion dates

Here’s a sample screen shot from Basecamp. (Notice I am not repeating my audit program here–just what is needed to manage the project.)

Basecamp

As a task date nears, the designee automatically receives an email reminder. For an audit project, that person might be a staff auditor, an in-charge, a client, or even yourself.

Many projects don’t get completed on time because we don’t early-identify potential bottlenecks (e.g., your in-charge is assigned to three engagements the week preceding the audit issuance date). And then when they occur, we blame the bottleneck rather than our lack of planning. We act surprised, as if projects never have hiccups. Project management enables you to plan early for problems. Then if problems occur (and they will), you can amend the project plan, and, if needed, change the scope or procedures, or add more resources.

Another nice feature in Basecamp is the ability to post messages. Since these messages are isolated by project, you can see the ongoing engagement conversation without digging around in your email archives. You can also attach documents (e.g., Excel spreadsheet) to a message.

If you have multiple projects going on at the same time, Basecamp enables you to move quickly from one project to another to see the status of each.

In Basecamp, you can categorize your to-do lists. My audit categories are:

  • Planning
  • Fieldwork
  • Review
  • Financial Statement Preparation
  • Exit

Then under each category, I add to-do tasks, assigning each to an individual–usually with completion dates (adding completion dates is optional in Basecamp).

As you complete a task, you check it off and it disappears (archived in the project, but no longer in your visible task list), leaving only those items that need to be completed. So you start out with this full audit project list, but as you move through the project, the list decreases in size.

You can access Basecamp from your cell phone, your computer, or a tablet. And so can all project team members, even your clients (if you add them to the project). Here’s a sample cell phone screen shot, reflecting a few projects I’m presently working on.

iPhone Basecamp

Additional Information

You can also create Basecamp templates (a sample project with a list of normal to-do items) which can be used to set up new projects.

The cost of Basecamp is $50 per month for forty simultaneous projects. Old projects can be archived and are not counted as one of your forty projects.

A cheaper alternative is Trello. I have not used Asana, but I have heard good things about the product. Both Trello and Asana have free basic products.

For you serious project management professionals, check out my twin brother’s project management website at projectriskcoach.com.