audit and work paper mistakes
Apr 23

Forty Audit and Work Paper Mistakes

By Charles Hall | Auditing

Today, I offer you a list of forty audit and work paper mistakes.

audit and work paper mistakes

The list is based on my observations from over over thirty years of audit reviews (and not on any type of formal study).

You will, however, shake your head in agreement as you read these. I know you’ve seen them as well. The list is not comprehensive. So, you can add others in the comments section of this post.

Here’s the list.

  1. No preparer sign-off on a work paper
  2. No evidence of work paper reviews
  3. Placing documents in the file with no purpose (the work paper provides no evidential matter for the audit)
  4. Signing off on unperformed audit program steps
  5. No references to supporting documentation in the audit program
  6. Using canned audit programs that aren’t based on risk assessments for the particular entity
  7. Not documenting expectations for planning analytics
  8. Inadequate explanations for variances in planning analytics (“revenue went up because sales increased”)
  9. Planning analytics with obvious risk of material misstatement indicators, but no change in the audit plan to address the risk (sometimes referred to as linking)
  10. Not documenting who inquiries were made of
  11. Not documenting when inquiries were made
  12. Significant deficiencies or material weaknesses that are not communicated in written form
  13. Verbally communicating control deficiencies (those not significant deficiencies or material weaknesses) without documenting the conversation
  14. Performing needed substantive tests with no related audit program steps (i.e., the audit program was not amended to include the necessary procedures)
  15. Assessing control risk below high without testing controls
  16. Assessing the risk of material misstatement at low without a basis (reason) for doing so
  17. Documenting significant risks (e.g., allowance for uncollectible receivable estimates in healthcare entities) but no high inherent risks (when inherent risk are separately documented)
  18. Not documenting the predecessor auditor communication in a first-year engagement
  19. Not documenting the qualifications and objectivity of a specialist
  20. Not documenting all nonattest services provided
  21. Not documenting independence
  22. Not documenting the continuance decision before an audit is started
  23. Performing walkthroughs at the end of an engagement rather than the beginning
  24. Not performing walkthroughs or any other risk assessment procedures
  25. Not performing risk assessment procedures for all significant transaction areas (e.g., risk assessment procedures performed for billing and collections but not for payroll which was significant)
  26. Not retaining the support for opinion wording in the file (especially for modifications)
  27. Specific items tested are not identified (e.g., “tested 25 disbursements, comparing amounts in the check register to cleared checks” — we don’t know which particular payments were tested)
  28. Making general statements that can’t be re-performed based on the information provided (e.g., “inquired of three employees about potential fraud” — we don’t know who was interviewed or what was asked or their responses)
  29. Retrospective reviews of estimates are not performed (as a risk assessment procedure)
  30. Going concern indicators are present but no documentation regarding substantial doubt
  31. IT controls are not documented
  32. The representation letter is dated prior to final file reviews by the engagement partner or a quality control partner
  33. Consultations with external or internal experts are not documented
  34. No purpose or conclusion statement on key work papers
  35. Tickmarks are not defined (at all)
  36. Inadequately defining tickmarks (e.g., ## Tested) — we don’t know what was done
  37. No group audit documentation though a subsidiary is included in the consolidated financial statements
  38. No elements of unpredictability were performed
  39. Not inquiring of those charged with governance about fraud
  40. Not locking the file down after 60 days 

That’s my list. What would you add?

supplementary information
Apr 11

Supplementary Information, Other Information and Required Supplementary Information

By Charles Hall | Auditing

What’s the difference in supplementary information, additional information, and required supplementary information? What language should be included in the audit opinion when such information is included in the financial statements?  What audit procedures must be performed? Below I provide the answers.

supplementary information

1. Supplementary Information

Supplementary information is defined as information presented outside the basic financial statements, excluding required supplementary information (see below), that is not considered necessary for financial statements to be fairly-presented in accordance with the applicable financial reporting framework (e.g. FASB).  (See AU-C 725 for more guidance about supplementary information.)

Supplementary information may include:

  • Accounting information and
  • Nonaccounting information

Supplementary information examples include:

  • Detail of “Other Income” as shown in the statement of operations*
  • Detail of “General and Administrative” expenses as shown in the statement of operations*
  • Number of employees in a given payroll period**

* Derived from financial statements

** Not derived from the financial statements

Procedures to Perform

Procedures to be performed include:

  • Determine whether the information is fairly stated, in all material respects, in relation to the financial statements as a whole

Sample Opinion Language

Example auditor’s report paragraph:

The [identify accompanying supplementary information] is presented for purposes of additional analysis and is not a required part of the financial statements. Such information is the responsibility of management and was derived from and relates directly to the underlying accounting and other records used to prepare the financial statements. The information has been subjected to the auditing procedures applied in the audit of the financial statements and certain additional procedures, including comparing and reconciling such information directly to the underlying accounting and other records used to prepare the financial statements or to the financial statements themselves, and other additional procedures in accordance with auditing standards generally accepted in the United States of America. In our opinion, the information is fairly stated in all material respects in relation to the financial statements as a whole.

For examples of presenting the supplementary language (1) in the standard opinion or (2) separately, click here.

Notice that an opinion is rendered on supplementary information. No opinion is given in regard to other information.

2. Other Information

Other information is financial and nonfinancial information (other than the financial statements and the audit report) that is included in a document containing audited financial statements and the audit report (e.g., an annual report), excluding required supplementary information. An auditor can use this option when he or she is not engaged to render an opinion on such information. (See AU-C 720 for more guidance about other information.)

Other information examples include:

  • Financial summaries
  • Employment data
  • Planned capital expenditures
  • Names of officers and directors

Procedures to Perform

Procedure to be performed:

  • Reading the other information in order to identify any material inconsistencies with audited financial statements

Sample Opinion Language

The auditor can use an other-matter paragraph to disclaim an opinion regarding other information. Sample language follows:

Our audit was conducted for the purpose of forming an opinion on the basic financial statements as a whole. The [identify the other information] is presented for purposes of additional analysis and is not a required part of the basic financial statements. Such information has not been subjected to the auditing procedures applied in the audit of the basic financial statements, and accordingly, we do not express an opinion or provide any assurance on it.

3. Required Supplementary Information

Required supplementary information (RSI) is information that a designated accounting standard-setter (e.g., FASB, GASB) requires to accompany the basic financial statements. RSI is not part of the basic financial statements. However, the designated accounting standard-setter has determined that the information is an essential part of financial reporting. (See AU-C 730 for more guidance about required supplementary information.)

Required supplementary information examples include:

  • Management discussion and analysis (MD&A) for governments
  • Estimates of current or future costs of future major repairs and replacements for common interest realty associations

Procedures to Perform

Procedures to be performed include:

  • Inquiry of management about methods used to create information
  • Comparing the information for consistency with management responses and the financial statements
  • Obtaining written representations from management

Sample Opinion Language

Example auditor’s report paragraph:

Accounting principles generally accepted in the United States of America require that the [identify the required supplementary information] on page XX be presented to supplement the basic financial statements. Such information, although not a part of the basic financial statements, is required by the Financial Accounting Standards Board who considers it to be an essential part of financial reporting for placing the basic financial statements in an appropriate operational, economic, or historical context. We have applied certain limited procedures to the required supplementary information in accordance with auditing standards generally accepted in the United States of America, which consisted of inquiries of management about the methods of preparing the information and comparing the information for consistency with management’s responses to our inquiries, the basic financial statements, and other knowledge we obtained during our audit of the basic financial statements. We do not express an opinion or provide any assurance on the information because the limited procedures do not provide us with sufficient evidence to express an opinion or provide any assurance.

Some governments exclude the MD&A. Here is sample opinion wording when the MD&A is omitted.

Supplementary Information in Compilations and Review Engagements

You can see information about supplementary information wording for compilation or review reports here. Also, see my post about presenting supplementary information in compilation and preparation engagements.

receipt fraud test for auditors
Apr 03

Three Powerful Receipt-Fraud Tests (for Auditors)

By Charles Hall | Asset Misappropriation

Today I provide three receipt-fraud tests for auditors. 

The audit standards require that we introduce elements of unpredictability. Additionally, it’s wise to perform fraud tests. But I find that auditors struggle with brainstorming (required by AU-C 240, Consideration of Fraud in a Financial Statement Audit) and developing fraud tests. That’s why I wrote Five Disbursement Fraud TestsIt’s also why I am providing this post.

So, let’s jump in. Here are three receipt-fraud tests.

receipt-fraud tests for auditors

Three Receipt-Fraud Tests

1. Test adjustments made to receivables

Why test?

Receipt clerks sometimes steal collected monies and write off (or write down) the related receivable. Why does the clerk adjust the receivable? So the customer doesn’t receive a second bill for the funds stolen. 

How to test?

Obtain a download of receivable adjustments for a period (e.g., two weeks) and see if they were duly authorized. Review the activity with someone outside the receivables area (e.g., CFO) who is familiar with procedures but who has no access to cash collections.

If there are multiple persons with the ability to adjust receivable accounts (quite common in hospitals), compare weekly or monthly adjustments made by each employee.

Agree receipts with bank deposits.

2. Confirm rebate (or similar type) checks

Why test?

When rebate checks are not sent to a central location (e.g., receipting department), the risk of theft increases. Rebate checks are often not recorded as a receivable, so the company may not be aware of the amounts to be received. Stealing unaccrued receivable checks is easy.

How to test?

Determine which vendors provide rebate checks (or similar non-sales payments). Send confirmations to the vendors and compare the confirmed amounts with activity in the general ledger.

Theft of rebate checks is more common in larger organizations (e.g., hospitals) where checks are sometimes received by various executives. The executive receives a check in the mail and keeps it for a while (in his desk drawer – in case someone asks for it). Once he sees that no one is paying attention, he steals and converts the check to cash.

3. Search for off-the-book thefts of receipts

Why test?

The fraudster may bill for services through the company accounting system or an alternative set of accounting records and personally collect the payments.

How to test?

Compare revenues with prior years and investigate significant variances. Alternatively, start with source documents and walk a sample of transactions to revenue recognition, billing, and collection.

Here are a few examples of actual off-the-book thefts:

Police Chief Steals Cash

An auditor detected a decrease in police-fine revenue in a small city while performing audit planning analytics. Upon digging deeper, he discovered the police chief had two receipt books, one for checks that were appropriately deposited and a second for cash going into his pocket. Sometimes, even Andy Griffith steals.

Hospital CFO Steals Cash

hospital CFO, while performing reorganization procedures, set up a new bank account specifically for deposit of electronic Medicaid remittances. He established himself as the authorized bank account check-signer.

The CFO never set up the bank account in the general ledger. As the Medicaid money was electronically deposited, the CFO transferred the funds to himself.  What was the money used for? A beautiful home on Mobile Bay, new cars, and gambling trips.

Another Receipt Fraud to Consider

Sometimes it’s not the front-desk receipt clerk that steals. Surprisingly, your receipt supervisor can be on the take. So, consider that receipt theft takes place up-front and in the back-office.

governmental internal controls
Apr 02

Useful Governmental Internal Controls that You Need Know

By Charles Hall | Fraud , Local Governments

Below I provide useful governmental internal controls that you need to know.

Why am I providing this list of useful controls? Most small governments struggle with establishing sound internal controls. So, the list provides a foundation for preventing theft in your government. While not a comprehensive list, I thought I would share it.

Many of the internal controls listed below are also pertinent to nonprofits and small businesses as well. You will find this same checklist in The Little Book of Local Government Fraud Prevention (available on Amazon) which provides many more fraud prevention ideas.

I am providing general fraud prevention controls and then transaction-level controls for:

  • Cash receipts and billing
  • Cash payments and purchasing
  • Payroll

governmental internal controls

Useful Governmental Internal Controls

General Internal Controls

  1. Have bank statements mailed directly to someone outside of accounting; recipient should peruse bank statement activity before providing it to accounting
  2. Perform surprise audits (use outside CPA if possible)
  3. Elected officials and management should review the monthly budget to actual reports (and other pertinent financial reports)
  4. Map internal control processes by transaction cycle (preferably done by a seasoned CPA); once complete, provide the map to all employees involved in the cycle; when control weaknesses exist, institute additional controls (see 11. below)
  5. Use a whistleblower program (preferably use an outside whistleblower company)
  6. Reconcile bank statements monthly (have a second person review and initial the reconciliation)
  7. Purchase fidelity bond coverage (based on risk exposure)
  8. Periodically request from the government’s bank a list of all bank accounts in the name of the government or with the government’s federal tax I.D. number; compare the list to bank accounts set up in the general ledger
  9. Secure computer access physically (e.g., locked doors) and electronically (e.g., passwords)
  10. Do not allow the electronic transmission (e.g., email) of sensitive data (e.g., social security numbers) without the use of protected transmission technology (e.g. Sharefile); create policy and train staff
  11. Where possible, segregate who (1) authorizes transactions, (2) records transactions, (3) reconciles records, and (4) has custody of assets; when segregation of duties is not possible, require documented second-person review and/or surprise audits

Transaction Level Controls

Cash Receipts and Billing Controls

  1. Use a centralized receipting location (when possible)
  2. Assign each cash drawer to a separate person; require daily reconciliation to receipts; require second person review
  3. Deposit cash timely (preferably daily); require the composition of cash and checks to be listed on each deposit ticket (to help prevent check-for-cash substitution)
  4. Immediately issue a receipt for each payment received; a duplicate of the receipt or electronic record of the receipt is to be retained by the government
  5. A supervisor should review receipting-personnel adjustments made to accounts receivable
  6. Do not allow the cashing of personal checks (e.g., from cash drawers)

Cash Payments and Purchasing Controls

  1. Guard all check stock (as though it were cash)
  2. Do not allow hand-drawn checks; only issue checks through the computerized system; if hand-drawn checks are issued, have a second person create and post the related journal entry
  3. Do not allow the signing of blank checks
  4. Limit check signing authorization to as few people as possible
  5. Require two employees to effectuate each wire transfer
  6. Persons who authorize wire transfers should not make related accounting entries
  7. Require a documented bidding process for larger purchases (and sealed bids for significant purchases or contracts); specify procedures for evaluating and awarding contracts.
  8. Limit the number of credit cards and the chargeable maximum amount on each card
  9. Allow only one person to use an individual credit card; require receipts for all purchases
  10. Require a street address and social security or tax I.D. numbers for each vendor added to accounts payable vendor list (P.O. box numbers without a street address should not be accepted)
  11. Signed vendor checks should not be returned to those who authorized the payment; mail checks directly to vendors
  12. Compare payroll addresses with vendor addresses for potential fictitious vendors (usually done with electronic audit tools such as IDEA or ACL)

Payroll Controls

  1. Provide a departmental overtime budget/expense report to governing body or relevant committee
  2. Use direct deposit for payroll checks
  3. Payroll rates keyed into the payroll system must be supported by proper authorization in the employee personnel file
  4. Immediately remove terminated employees from the payroll system
  5. Use biometric time clocks to eliminate buddy-punching
  6. Check for duplicate direct-deposit bank account numbers
  7. A department head should provide written authorization for overtime prior to payment

Your Recommendations

What additional controls do you recommend? Share your thoughts below.

How to create energy that sustains you
Mar 06

How to Create Energy that Sustains You

By Charles Hall | Accounting and Auditing

So you are in the middle of your busy season and you are wondering how you will get it all done. Right?

One thing is for sure: Without energy, nothing happens. As Jim Loehr and Tony Swartz say in The Power of Full Engagement: Energy, not time, is the fundamental currency of high performance.

How to create energy that sustains you

I started my career in 1984. It was a time when CPA firm partners would demand that you put your head down and never look up (and if you did, you might get whacked). The thought was that young staff were inexhaustible. After all, we had our youth.

But after being in public accounting for over thirty years, I have found that such an outlook is not only unwise, it is counterproductive. Sometimes squeezing out “just one more job” causes us to implode.

So should we work hard? Absolutely. But we should also recover if we are to perform at our highest levels.

When Do You Need Recovery?

Here are a few signs that you worked too long, and you need recovery:

  • You stare at a financial statement page for several minutes before you realize you are in a daze (not reading, just staring)
  • You can’t stay focused (your mind keeps wondering)
  • You are working with a sense of dread rather than joy
  • You are too stressed to sleep at night
  • You find yourself increasingly rude to your spouse, friends, coworkers
  • You reach for too much caffeine, or worse, alcohol, to get you through the day
  • You feel like a robot
  • You are often short of breath
  • You have a sense of drowning

The body needs balance, and when it doesn’t get it, strange things start to happen. And when this work style–working without recovery–becomes habitual, we lose our vitality and health. Our production begins to decline rather than increase.

How Do You Recover?

Picture is courtesy of DollarPhoto.com

Picture is courtesy of DollarPhoto.com

Here are disciplines that will enable you to excel during your busy season.

  1. Take breaks – Working ten to twelve hours a day (and eating at your desk)–without breaks–is a sure way to deplete yourself. You need to work and recover, work and recover, work and recover — not work, work, work. The recovery can be as simple as taking five minutes to stand and stretch, but you need to move periodically away from your desk. If possible, go outside and walk for five to ten minutes (a couple of times a day). Recovery can be a simple phone call to a family member to tell her (or him) that you love them. Some professionals use the Pomodoro technique to move in and out of their work. There’s even an app for that. It may seem counterproductive to take breaks, but it’s not — as long as we don’t abuse the break time. Remember the purpose of the short break is to recover. For those of you that are runners, you know that Jeff Galloway teaches the same art in running: run and mix in walks (recovery). And many who use Jeff’s technique have found they can run farther and faster.
  2. ExercisingRun, walk, or do some exercise on a consistent basis. I was a smoker in college and–as a way to help me kick the habit–I started running. That was thirty-seven years ago. Today I am fifty-seven, and I still either run or walk at least three times a week. I find that running helps me the most. When I consistently run, I think more clearly and don’t drag late in the day. When I don’t run, I notice my thinking becomes cloudy, and I become moody. When I’m on my routine (run three times a week, at least, two miles a run), I even notice that I have bursts of energy in the middle of the afternoon, something that never happens when I am not exercising.
  3. Drink water – Staying hydrated throughout the day will keep you humming late in the day. I have put a water dispenser in my office, so I don’t have to worry about going to the store to buy bottled water. The cost of the water container (and water that they bring to my office) is about $25 per month — worth every penny.
  4. Sleep – I have read a great deal about how much sleep I need each night. And it seems the consensus is a minimum of 7.5 to 8.0 hours per night. I know this: when I get consistent sleep, I perform better. I have a routine each evening of winding things down about 9:30 and being in bed about 10:00 p.m. so I can rise at 6:00 a.m. (so I can write blog posts like this one). Going back to exercising for a moment, if you work your body hard, you will sleep better. I have noticed the farther I run, the harder I sleep. Also, if I am in bed for more than fifteen to twenty minutes without going to sleep, I get up and take melatonin — this helps me fall asleep.
  5. Eating well – Another method of recovery is eating. Not too much, but enough to provide energy. I eat a healthy breakfast each morning, a light lunch, and dinner. Then about mid-morning and mid-afternoon, I snack (usually nuts or fruit). If you’ve ever watched Tiger Woods play golf, you’ve seen him munching on a banana or energy bar during the middle of a round — he’s feeding his body to maintain energy. Eating too much at one time will throw your body’s metabolism out of balance, so a steady intake (balance) is what we need.
  6. Coffee – Coffee in moderation can stimulate your thinking and mood, at least, it does for me. I drink a cup first thing in the morning. Then I have another cup just after lunch. Too much coffee will drain you of energy. Rather than reaching for another cup, take a short walk, drink more water.
  7. Music – If possible listen to good music while you work. I find that I am more productive with music playing quietly in the background.

Call to Action

Try one or all of these and stay at it. Habit is the key. You may find in the initial days of change that you’ll desire to revert to your old habits, but as you continue, your new ways will become normal. Then you’ll find new energy for the tasks at hand.

Have a great day!

how to extract pages from a PDF
Mar 05

How to Extract Pages from a PDF

By Charles Hall | Technology

Your PDF has 116 pages, but you desire to send ​a single page ​to a client. So, you're wondering how to extract a page from a PDF. Below, I show you how. Then I  demonstrate how you can email the information. It only takes seconds. (I am using Adobe Acrobt DC in this demonstration.)

​More Adobe Acrobat How-To Videos

Feb 27

Preparing Financial Statements: Which Standards Apply?

By Charles Hall | SSARS

SSARS 21 added a new section to the compilation and review standards called Preparation of Financial Statements. Since then, I’ve received several questions about which standards apply when financial statements are prepared–especially if you concurrently provide another service such as a compilation, review, or audit.

Those questions include:

  • Can an accountant perform a compilation and not prepare the financial statements?
  • Are the preparation of financial statements and the performance of a compilation engagement two separate services?
  • If an auditor prepares financial statements and audits a company, what is the relevant standard for preparing the financial statements?
  • Is the preparation of financial statements a nonattest service, though the audit is an attest service?
Picture is courtesy of Dollarphoto.com

Picture is courtesy of Dollarphoto.com

Below I provide: (1) a summary of how compilations changed with the issuance of SSARS 21 and (2) a summary of how the preparation of financial statements service interplays with compilations, reviews, and audits.

The Old Compilation Standard 

Using SSARS 19, the performance of a compilation involved one service which encompassed:

  • Preparing financial statements,
  • Performing compilation procedures (e.g., reading the financials), and
  • Issuing a report

How Compilation Engagements Changed 

So, how did SSARS 21 change compilations?

If an accountant prepares the financial statements and performs a compilation engagement using SSARS 21, she is performing two services (not one). In this case, the performance of the preparation of financial statements is not subject to any formal standard (including SSARS 21).

When an accountant performs both the preparation of financial statements and a related compilation engagement, is AR-C 70, Preparation of Financial Statements, applicable?

No.

“Wait…you’re saying that a new standard called Preparation of Financial Statements was added with SSARS 21, but when the accountant prepares financial statements and performs a compilation engagement, the (SSARS 21) preparation standard is not applicable?”

Yes.

AR-C 70, Preparation of Financial Statements, states that the standard is not applicable “when an accountant prepares financial statements and is engaged to perform an audit, review, or compilation of those financial statements.” So if an accountant prepares financial statements as a part of a compilation engagement, AR-C 70 does not apply.

Why?

If AR-C 70, Preparation of Financial Statements, and AR-C 80, Compilation Engagements, were both in play, they would conflict. AR-C 70 requires the accountant to state on each financial statement page that “no assurance is provided” or to issue a disclaimer. AR-C 80 requires the issuance of a compilation report and does not allow the accountant to state that “no assurance is provided” on each financial statement page or for the accountant to issue a disclaimer.

Meaning?

When the accountant prepares financial statements and performs a related compilation, the creation of the financial statements is a nonattest service with no particular guidance–not even from SSARS 21. (Of course, the AICPA Code of Professional Conduct applies to all services.)

When a compilation engagement (an attest service) is performed and financial statements are prepared (a nonattest service), two separate services are being performed by the same accounting firm.

The Interplay of Financial Statement Preparation and Other Services

The table summarizes which standard is applicable when:
1. A preparation engagement is performed (alone)
2. Preparation and compilation engagements are performed for the same time period
3. Preparation and review engagements are performed for the same time period
4. Preparation and audit engagements are performed for the same time period

Preparation of Financial StatementsCompilation EngagementReview EngagementAudit EngagementStandard to Follow
YesAR-C 70 Preparation
YesYesAR-C 80 Compilation
YesYesAR-C 90 Review
YesYesAU-C Audit Sections

AR-C 70, Preparation of Financial Statements, applies only in the first example above. When the accountant performs a preparation service and a compilation, review, or audit service for the same time period, AR-C 70 is not applicable–that is, no formal standard applies to the preparation service.

In all the examples listed above, the preparation of financial statements is a nonattest service.

In examples 2, 3 and 4 (where a preparation service and an attest service are provided), your engagement letter should include language about performing nonattest services and how the client will assign someone with suitable skill, knowledge, and experience to oversee the preparation of financial statements service. Such language is only required when a nonattest and an attest service is provided.

SSARS 22 and 23

Since the above information deals with SSARS 21, you may be wondering what additional SSARS have been issued–and how those newer standards affect compilations. 

SSARS 22, Compilation of Pro Forma Financial Information was effective for compilation reports dated on or after May 1, 2017. So, what is pro forma information? It is a presentation that shows what the significant effects on historical financial information might have been had a consummated or proposed transaction (or event) occurred at an earlier date.

SSARS 23, Omnibus Statement on Standards for Accounting and Review Services, was issued in late October 2016. That standard changed supplementary information wording in compilation and review reports

The primary impact of SSARS 23 is to provide standards for the preparation and compilation of prospective financial information.

While portions of SSARS 23 were effective upon issuance (the supplementary language change), the remainder of the standard was effective for prospective financial information prepared on or after May 1, 2017, and for compilation reports dated on or after May 1, 2017, respectively.

comparing financial statement numbers in a PDF
Feb 21

How to Compare Financial Statements Numbers within a PDF

By Charles Hall | Technology

Sometimes you need to compare financial statement numbers within a PDF–even though the numbers are pages apart. How can you do this without printing the PDF? Below I show you how.

Of course, a second way to compare financial statement numbers is to open a second instance of the PFD on an adjacent monitor. I do both, depending on the numbers I am trying to compare. I might use the first method (in the video) to compare rows of numbers (e.g., equity totals) and the second method to compare financial statement numbers to disclosures.

If your financial statements are in Word, you can easily convert them to a PDF.

measurement of inventory
Feb 19

Simplifying the Measurement of Inventory (ASU 2015-11)

By Charles Hall | Accounting

Are you up to speed on ASU 2015-11 Simplifying the Measurement of Inventory? This post assists in understanding the new accounting measurement for inventory.

measurement of inventory

Accounting Measurement for Inventory

ASU 2015-11 requires that entities measure inventory at the lower of cost or net realizable value (LCNRV), provided they don’t use the last-in-last-out method (LIFO) or the retail inventory method. Entities using LIFO or the retail inventory method will continue to use the lower of cost or market (where market is replacement cost). Entities using the first-in-first-out (FIFO), average cost, or any other cost flow methods (other than LIFO and the retail inventory methods) should use the lower of cost or net realizable value approach.

So, where applicable, market is being replaced by net realizable value.

The Financial Accounting Standards Board’s glossary defines net realizable value as follows:

Estimated selling prices in the ordinary course of business, less reasonably predictable costs of completion, disposal, and transportation.

Why the change? FASB is working to simplify some accounting standards. FASB had received comments from stakeholders that the requirement to subsequently measure inventory was “unnecessarily complex because there are several potential outcomes.”

Why did FASB not require the LCNRV method for all entities? The summary section of ASU 2015-11 says,  “The Board received feedback from stakeholders that the proposed amendments would reduce costs and increase comparability for inventory measured using FIFO or average cost but potentially could result in significant transition costs that would not be justified by the benefits for inventory measured using LIFO or the retail inventory method…Therefore, the Board decided to limit the scope of the simplification to exclude inventory measured using LIFO or the retail inventory method.”

What Disclosure is Required for the Change in Accounting Principle?

BC16 of ASU 2015-11 states the following:

The Board decided that the only disclosures required at transition should be the nature of and reason for the change in accounting principle. The Board concluded that the costs of a quantitative disclosure about the change from the lower of cost or market to the lower of cost and net realizable value would not justify the benefits because a reporting entity would be required in the year of adoption to measure inventory using both existing requirements and the amendments in this Update, and because the change would not be significant for some entities.

An entity is required only to disclose the nature and reason for the change in accounting principle in the first interim and annual period of adoption.

Sample ASU 2015-11 Disclosures

Here is a sample disclosure from Mercer International Inc.’s 10-K:

Accounting Pronouncements Implemented

In July 2015, the FASB issued Accounting Standards Update 2015-11, Simplifying the Measurement of Inventory (“ASU 201511”) which requires that inventory within the scope of this update, including inventory stated at average cost, be measured at the lower of cost and net realizable value. This update is effective for financial statements issued for fiscal years beginning after December 15, 2016. The adoption of ASU 201511 did not impact the Company’s financial position.

Here is a sample disclosure from Delta Apparel, Inc.’s 10-K:

Recently Issued Accounting Pronouncements Not Yet Adopted

In July 2015, the FASB issued ASU No. 2015-11, Simplifying the Measurement of Inventory, (“ASU 201511“).  This new guidance requires an entity to measure inventory at the lower of cost and net realizable value. Currently, entities measure inventory at the lower of cost or market. ASU 201511 replaces market with net realizable value. Net realizable value is the estimated selling price in the ordinary course of business, less reasonably predictable costs of completion, disposal, and transportation. Subsequent measurement is unchanged for inventory measured under last-in, first-out or the retail inventory method.  ASU 201511 requires prospective adoption for inventory measurements for fiscal years beginning after December 15, 2016, and interim periods within those years for public business entities.  Early application is permitted.  ASU 201511 will, therefore, be effective in our fiscal year beginning October 1, 2017. We are evaluating the effect that ASU 201511 will have on our Consolidated Financial Statements and related disclosures, but do not believe it will have a material impact.

Here is a sample disclosure from Dr. Pepper Snapple Group, Inc.’s 10-K:

Recently Adopted Provisions of U.S. GAAP
 
As of January 1, 2017, the Company adopted ASU 201511, Inventory (Topic 330): Simplifying the Measurement of Inventory (“ASU 201511“). ASU 201511 requires inventories measured under any methods other than last-in, first-out (“LIFO”) or the retail inventory method to be subsequently measured at the lower of cost or net realizable value, rather than at the lower of cost or market. Subsequent measurement of inventory using LIFO or the retail inventory method is unchanged by ASU 201511. The adoption of ASU201511 did not have a material impact on the Company’s consolidated financial statements.

Effective Dates for ASU 2015-11

For public business entities, the amendments are effective for fiscal years beginning after December 15, 2016, including interim periods within those fiscal years. For all other entities, the amendments are effective for fiscal years beginning after December 15, 2016, and interim periods within fiscal years beginning after December 15, 2017. The amendments should be applied prospectively with earlier application permitted as of the beginning of an interim or annual reporting period.

Mistakes CPAs Make
Feb 17

Twenty Mistakes that CPAs Make

By Charles Hall | Accounting and Auditing

Here are twenty mistakes that CPAs make:

  1. We hire people without sufficient knowledge and temperament
  2. We accept more work than we can possibly perform
  3. We don’t cull our bad clients (which contributes to #2.)
  4. We work without taking breaks
  5. We don’t exercise
  6. We try to be experts in too many industries
  7. We use outdated computers and software (e.g., we are not paperless)
  8. We don’t plan our continuing education (and take anything we can find at the end of the year)
  9. We have no strategy, moving from one engagement to another because it’s pressing
  10. We work sitting down all day (when standup desks are available)
  11. We bill our clients months after the service is provided (rather than a couple of weeks)
  12. We allow email to drive our day (we are reactive)
  13. We don’t express sincere appreciation to our peers and employees (those fully deserving of “thank you!”)
  14. We don’t use engagement letters to define our work
  15. We have no exit strategy, hoping someone will knock on our door and offer to buy the practice
  16. We ignore those we love (because we are overworked and irritable)
  17. We don’t stay current on evolving standards
  18. We don’t fire unproductive or difficult employees
  19. We don’t deal with problems (bad clients or employees) because doing so is awkward
  20. We never pause to evaluate our lives

Mistakes CPAs Make

Since  1984, I have worked in public accounting, a profession I dearly love. One thing I’ve noticed about CPAs is we are too immersed in our work–to a point of blindness. We don’t step back and evaluate what or how we do things. Would we be better off if we intentionally removed certain responsibilities? Might we not be even more profitable and happier? 

Two things–more than anything else–will sap your energy and productivity: (1) difficult clients and (2) unproductive or difficult employees.

The 80/20 rule is applicable in our profession. We make 80% of our money from 20% of our work. And 80% of our headaches come from 20% of our clients and employees. (Were you awake last night thinking about one of these?) While the exact percentages may not be true for you, the concept is highly relevant. 

I’ve given you twenty mistakes that CPAs make. Are there others you would add?

If you found this article of interest, see my post What Keeps CPAs Awake at Night. Also, here are Forty Mistakes Auditors Make.

1 2 3 25
>