Remote bank deposits (#41)

In this podcast, we cover the process flow associated with using a remote bank deposit system. Key points made are noted below.

How Remote Bank Deposits Work

Today’s topic is remote bank deposits.  This is when you use a check scanner to extract information from incoming checks and send the information on the checks over the internet, to the bank.  There’s no need to send the physical checks to the bank at all. I just acquired a check scanner, and I’ve been tooling around with it for a couple of weeks, so I can give you some first-hand knowledge of how this nifty piece of technology works.  And by the way, what I’m about to tell you is based on the Key Bank remote deposit system, so systems used by other banks may vary a bit.

First, you order the check scanner from your bank.  Then, you arrange for about an hour of training time over the phone with a bank employee.  Of that hour, about half is used up while you download and install software to use with the scanner.  I don’t know why it takes this long, since we have a pretty massive T1 line, but it does take some time.

The rest of the training is a hands-on training session where you run actual checks through the scanner.

The Check Scanning Process

The basic scanning process is to separate all of your checks into different piles for each company being paid.  For most companies, their customers are just paying them, so all of the checks would go into a single stack.  In our case, we own four companies, so we end up with four piles of checks.  Then, we add up the dollar amounts of the checks in each pile, so that we have batch totals for each one.

After that, we log in, and click on the account number that corresponds to a company.  Then we enter the deposit total, and we’re ready to scan.  To do so, we sort the checks for a specific company by physical size, so the smallest checks are in front, and the largest in the back.  This usually means that those cheap little $5 rebate checks end up in front.  Then, we put them in the input tray of the scanner, and it scans the batch at the rate of about one check per second. While it does a scan, the scanner automatically prints a scanner endorsement on the back of each check.

If the scanner can’t read the amount of the payment shown in a check, then the software shows a scanned image of the check, and we enter in the correct amount.  We’ve found that the system can read typed checks quite well, but it has issues with handwritten ones, or checks printed in reverse, where the text is in white, on a black background.  Key Bank tells me that the system’s ability to correctly read the dollar amount on checks is about 65%, but I find that it’s way higher than that, as long as the checks are typed.  I’d say the rate is more like 98% for typed checks.

Then, the system adds up the checks that we’ve scanned into it, and creates a deposit total, which it compares to the expected deposit total that we originally entered.  If it’s correct, then we press a button to submit the deposit and print a receipt, which we file by date.  Key Bank also tells us to retain the originals of all checks for 15 business days, after which we can shred them.  The total time to submit a daily deposit is just a couple of minutes.

Now, a couple of extra items that you might be interested in.  First, what about bad scans?  Well, so far, we’ve never had one, which says something about the reliability of the scanner.  If we were to have one, we would delete the scanned image and run the check through again.  If the scanner has already printed a scanner endorsement on the back of a check that we need to scan again, then we put some white-out tape over the endorsement before doing another scan.

Exception Conditions

Another issue is, what about foreign checks?  So far, you can’t scan them, so you still have to send in the originals.  The problem is apparently not in the scanning system, but just that the laws have not been passed that allow the bank to process these types of checks.  If you happen to run a foreign check through the scanner, it’ll notify you, and not accept the scan.

Also, what if you mistakenly send the same check through twice?  The system keeps track of all checks scanned for the past ten days, and will notify you when a duplicate check goes through.  It shows you images of both the first and second checks, so you can see if there’s really a duplication.  Then, you just cancel the second check.

Scanner Maintenance

Also, the maintenance on the scanner is quite minimal.  We’re supposed to wipe down the scanning hardware with a Q-Tip about once every three months, and there’s also a Hewlett-Packard inkjet cartridge for printing the scanner endorsement, for which we keep a backup on hand.  Other than that, there’s really no maintenance to speak of.

System Pricing

The price of the system is about $100 a month.  We’re doing it mainly for the convenience, since no one wants to deliver checks to the bank, and mailing checks can sometimes result in checks that are lost in transit.  There’s also a one to two day reduction in check clearing time.  For us, the system is not really economical, but it sure is convenient.

Related Courses

Accounting Information Systems

Lean Accounting Guidebook

Optimal Accounting for Cash

Biometric Time Clocks (#40)

In this podcast, we discuss the advantages of using biometric time clocks, as well as how they function. Key points made are noted below.

Today’s topic is biometric timeclocks.  Before I get started on this topic, I’d like to point out that I receive no compensation to talk about the suppliers in this podcast.  I only mention specific manufacturers, because I think you might be interested in what they produce. So, getting back to the topic - The main questions are, what is a biometric timeclock, and why would you want to use one?

What is a Biometric Time Clock?

A biometric timeclock can theoretically use any unique feature on your body to verify that you’re the person who is entering time information.  Though this could involve a retina scan, your voice, or facial features, the timeclocks currently on the market that are cost-effective only use either fingerprint scans or the shape of your hand to verify who you are.

The only company putting out a biometric clock that measures the shape of your hand is Recognition Systems, which is a division of Ingersoll Rand.  For this clock, which is called the HandPunch, you have to initially record the geometry of your hand in the timeclock.  To do this, you place your hand on a template and hold it there for about 30 seconds.  The clock uses a built-in digital camera to take about 90 measurements of the length, width, thickness, and surface area of your hand and four fingers.  The measurements don’t include your fingerprints, which I’ll get back to in a minute.

Once someone is registered in the system, they then clock in and out by punching in their employee number and putting their hand on the template for verification.  The verification process takes about one second.

There are several versions of the Handpunch on the market.  The small business version is the HandPunch 1000, which has a capacity of 50 users.  You can buy a new one on eBay for $850.  You can also add memory capacity to bring the number of users up to 100.

A more advanced version is the HandPunch 4000, which has a capacity of several thousand employees, depending on the amount of memory you buy for it.  It retails for $3,600, but you can buy it on eBay for about $2,700.  This version presents up to 24 information fields for employees to view.  For example, they can view their work schedule, or total hours worked so far in the pay period, and unused vacation time.  It also includes a bar code reader, in case employees want to scan in their access codes instead of punching it in by hand.

Another variation on the biometric timeclock is the fingerprint scanner.  In this case, an employee places their finger on a template, which scans the fingerprint and matches it against a stored record.  Kronos sells the Kronos 4500 TouchID terminal, for which there’s a limited market on eBay.  The pricing I found for an essentially new terminal was $600.  InfoTronics also makes a couple of versions of a fingerprint scanning timeclock.  Your best bet with them is the IDpunch 5, which can be used by up to 250 employees.

Now, there are scenarios where fingerprint scanning may not work.  If you have a rugged industrial environment where people can get dirt or grease on their hands, this may obscure their fingerprints, and result in rejected scans.  In this type of environment, you may be better off using a hand measurement system, such as something in the HandPunch product line.

When to Use a Biometric Time Clock

So, to get back to the second question, why would you want to use a biometric timeclock?  There are two reasons.  First, it eliminates buddy punching.  This is when one employee punches in or out for another employee who isn’t actually on the premises.  The result is that a company pays an employee for work that was never performed.  With biometric technology, the actual employee really has to be present in order to punch in or out.

The second reason is that there’s no need for employees to swipe their employee badge into the machine.  This is a really neat feature, because lots of employees forget or lose their badges, and the company then has to go through the effort of issuing new badges.

So, in short, you use biometric timekeeping to save money by eliminating buddy punching, and by eliminating the administration of employee badges.

Related Courses

Optimal Accounting for Payroll

Payroll Management

Timekeeping by Telephone (#39)

In this podcast, we discuss the benefits of entering time data through employee phones. Key points made are:

  • Time cards, time clocks, and time entry through a website are the traditional time collection methods.

  • A telephone time clock allows employees to enter their time into a central system via any phone, including their cell phones.

  • A telephone time clock works well when employees are engaged in field service, construction, or agricultural activities, or when a business has many locations but few people in each one (which makes the investment in local time clocks too expensive).

  • Basic process is to call an 800 number, enter the employee ID, enter the clock code for the type of activity, and either enter a time stamp, start/stop time, or elapsed time. There is also a provision for answering a series of yes/no questions. The entire process takes 20-30 seconds.

  • Benefits of timekeeping by telephone include the elimination of time cards, no data entry work, immediate data validation, immediate visibility into the hours being worked on projects, and the immediate availability of hours worked for clients that can then be billed to those clients.

  • The underlying time database should be integrated into the company’s payroll processing system.

Related Courses

How to Audit Payroll

Optimal Accounting for Payroll

Payroll Management

Automatic Cash Application (#38)

In this podcast, we discuss the characteristics of an automatic cash application system, and the circumstances under which it works best. Key points made are:

  • There are four steps in the automatic cash application process, which are:

    • 1: Import data from the bank, or customers, or engage in manual data entry. Need to link up payment information from the bank with the invoice detail in the company’s accounting system.

    • 2: Make corrections for keying errors with rules engines; there may be an AI-based learning process incorporated into the system.

    • 3: Manually fix those issues that cannot be automatically corrected by the system; a good result is automatic application of 90% of all payments.

    • 4: Export the cleaned data to your ERP system.

  • Problems could be caused by underlying procedural issues.

  • The success rate usually begins quite low; use the Pareto principle to fix the 20% of problems causing 80% of the problems, which rapidly improves the situation.

  • Automatic cash application is a good solution when the transaction volume is high, or where cash receipts processing is prone to error, or when there are large spikes in cash receipts transaction volume, or when the system can be used to segregate cash receipt duties from other positions in the company.

Related Courses

Accounting Procedures Guidebook

Lean Accounting Guidebook

Forensic Accounting Investigations and Logistics Metrics (#37)

In this podcast, we discuss the nature of forensic accounting investigations, when they are needed, and who may be involved in investigations. In the second part of the podcast, we also discuss logistics metrics. Key points made in regard to forensic accounting investigations are:

  • The forensic accounting investigator is called in which a client suspects that fraud has occurred.

  • The investigator gathers documents, examines them, and reports findings to the client. This work involves looking for anomalies, checking on the existence of suppliers, investigating disbursement spend, reviewing contracts, and so forth.

  • The investigator follows the money in asset misappropriation cases. This includes the examination of records and emails.

  • Nonprofit entities tend to be quite trusting and have few employees, which places them at a higher risk of fraud.

  • The investigator may need to look into conflicts of interest (such as business dealings with friends and family), corruption, and bribery. This may involve reviewing the existence of any payments to government officials.

  • Insurers may pay for the fees of the investigator.

  • May end up talking to the SEC, FBI, and other regulators and law enforcement agencies.

  • Forensic investigation skills may not be present in every Big Four office; tends to be concentrated in offices located in larger population areas.

Key points relating to logistics metrics are:

  • Percentage of certified suppliers; focus is on production suppliers.

  • On-time inbound delivery percentage; there is a penalty for both early and late deliveries.

  • Raw materials inventory turnover

  • Cost of rush freight services; too high a number indicates excessively low raw materials inventory.

  • Picking accuracy; focus is on parts shortages.

  • Order fill rate; can depend on the number of line items in an order.

  • Percent of products damaged in transit; can help to calculate on a quarterly basis, to smooth out short-term anomalies.

Related Courses

Business Ratios Guidebook

Fraud Examination

Fraud Schemes

The Universal Payment Identification Code, and Sales Metrics (#36)

In this podcast, we discuss the advantages of using the universal payment identification code (UPIC) for payables transactions, as well as the best sales metrics to use. Key points made in the podcast are:

  • The Clearing House Payments Company does payment clearing; it is an alternative to the Fed.

  • UPIC is a pseudo account number, to which customers can send their ACH payments. The Clearing House Payments Company then looks up the linked account account, and forwards each ACH payment to it.

  • UPIC is portable, so it stays the same when you change bank accounts.

  • UPIC avoids the need to contact customers when the underlying bank account changes.

  • UPIC does not allow the use of ACH debits or demand drafts.

  • Can ask your bank if they offer UPIC.

Key points relating to sales metrics are:

  • Sales per salesperson; use it to measure nonrecurring sales.

  • Customer cancellation percentage; use it to monitor the loss of longer-term customers.

  • Sales productivity; can use it to measure productivity for individual salespeople, or the entire department.

  • Sales effectiveness ratio; want to maximize gross margin per hour of bottleneck time.

  • Quote to close ratio

  • Pull-through ratio; useful when have large initial group of prospects.

  • Days of backlog; only at a gross level, so it may hide constraint issues for individual products.

  • Customer turnover; need to factor in which customers need to be dropped.

Related Courses

Business Ratios Guidebook

Payables Management

Recovery Auditing and Accounting Metrics (#35)

In this podcast, we discuss the reasons why recovery auditing can improve profits, as well as the measurements to use in the accounting department. Key points made in the podcast are:

  • Profit leaks come from the accounts payable and purchasing streams.

  • There tends to be more leakage as headcount declines, since there are fewer people watching transactions.

  • Need staffing overcapacity to plug all profit leaks.

  • Hire a recovery auditor to do the analysis work for you. This will require a specialist in each area to be examined, such as payables, advertising, freight, sales and use taxes, and health care billings.

  • A recovery auditor can bill an hourly rate, or a percentage of the cost savings.

  • The hiring person can look bad if too many mistakes are found by the auditor.

  • The first recovery audit tends to find the most savings, with diminishing returns thereafter. Still makes sense to bring in recovery auditors on a regular basis.

  • Useful for isolating where the problem areas lie within a business.

  • Recovery auditing tends to work better with large to mid-sized companies, but can still make sense when sales are as low as $20 million.

  • A good recovery auditor will provide advice, as well as spot specific instances of waste.

Key points relating to accounting metrics are:

  • Error tracking is essential within the department.

  • Average expense report turnaround time; turnaround time can be delayed when supervisors do not forward expense reports to the payables staff in a timely manner.

  • The total number of transaction errors requiring a payroll adjustment.

  • The proportion of purchase discounts taken; should focus on those discounts that are the most economical to take.

  • Average time to issue invoices; should be as fast as possible.

  • The total payroll transaction fees charged by the payroll supplier.

  • The percentage of dates on which tax filing dates are missed.

  • The time required to produce financial statements.

  • Borrowing base usage; warns when the amount of available debt is getting close to zero.

Related Courses

Business Ratios Guidebook

Fraud deterrence (#34)

In this episode we discuss the issues relating to fraud deterrence, to keep instances of fraud from ever happening. Key points made in the podcast are:

  • Fraud deterrence involves conditions and procedures analysis to keep fraud from taking place.

  • Could include the use of detection systems to spot fraud before it worsens.

  • The cost of fraud deterrence is a fraction of the cost of the fraud being prevented.

  • It avoids the loss of business reputation by a business, which might otherwise impact its contracts and loans.

  • A robust, bottom-up budget is a good fraud deterrence control.

  • Just the act of reviewing accounts is a deterrent, since employees see that you are looking over their shoulders.

  • The worst frauds tend to go on for an extremely long time, building in size as they get older.

  • It is rare to see an excessive level of control in a business.

  • Focus on all aspects of the business when engaged in fraud deterrence.

  • Conduct an operational review to identify control issues and also increase the efficiency level. Requires lots of interviews.

  • Difficult to do an in-house fraud deterrence review, due to the fear of recrimination.

  • Should do deterrence reviews about every two to three years.

Related Courses

Accounting Controls Guidebook

Fraud Examination

Fraud Schemes

Acquiring a Public Shell Company (#33)

In this episode, we discuss the considerations involved in buying a public shell company. Key points made in the podcast are:

  • A public shell is a public company that has no business activity, and which is no longer filing periodic reports with the Securities and Exchange Commission (SEC).

  • A private company buys a public company in order to go public through a reverse merger transaction; this can be done in as little as three months.

  • A key risk is that the shell may have undocumented liabilities, which the new owner may have to pay.

  • Securities attorneys usually manage a group of shells, which they preserve for sale to others. This involves letting them lie fallow for several years, with no activity, while continuing to have their books audited. It costs about $25,000 per year to operate a shell in this manner.

  • Once a private company buys a shell, it swaps the shares of its own shareholders for those of the shell, and then has to register these shares with the SEC. The shares cannot be sold until they have been registered. A key problem is building trading volume, or it will be quite difficult to sell the shares.

  • The pre-existing shares of the shell are more likely to be sold at this point by their owners, since the share price will likely have increased.

  • The new owner has to issue a Form 8-K to the SEC as soon as the acquisition is completed, which is a time-consuming chore.

  • Estimate $15,000 per month to maintain a public company once the shell purchase has been completed.

Related Courses

Mergers and Acquisitions

Public Company Accounting and Finance

Metrics (ROI) and Accounting Run Charts (#32)

In this episode, we discuss how run charts can be used within an accounting operation, as well as the different types of metrics relating to the return on investment. Key points relating to accounting run charts are:

  • Accounting run charts are used to track transaction volume by activity. They can be assembled with Excel, or through an accounting system custom report.

  • Run charts can be used to justify changes in employee headcount.

  • Run charts can also be used to monitor employee performance, especially when processing volumes per person decline.

  • Run charts can be useful for deciding whether to use temps or hire full-time workers, depending on the transaction pattern observed over time.

  • Run charts can be used to monitor the seasonal elements of transaction volumes.

Key points relating to return on investment metrics are:

  • ROI metrics are needed for the analysis of investments.

  • Return on assets; includes all assets, to give a better picture of the total investment in assets.

  • Return on operating assets; only includes those assets actively being used to generate revenue.

  • Return on equity percentage; used by investors. Can be enhanced by using more debt to buy back shares, which can cause leverage problems.

  • Return on common equity; subtracts out the effects of preferred stock dividends.

  • Equity growth rate; shows how the equity balance is being impacted by inflows and outflows.

  • Economic value added; incremental rate of return in excess of the cost of capital.

Related Courses

Business Ratios

Lean Accounting Guidebook

Metrics: Operating Performance (#31)

In this episode, we discuss the most essential operating performance metrics for a business, with a emphasis on how to discern the performance of an organization’s core operations, how changes in fixed expenses will alter profits, and whether financial reporting fraud may be present. Key points are noted below.

Operating performance is all about the net results of your company.  Examples of operating performance are the gross margin and net profit measurements, which pretty much everyone uses.  The trouble is that no one uses anything else, and there are some other ways to look at operating performance.

Sales to Operating Income Ratio

A good alternative measurement is the sales to operating income ratio.  This is the same thing as the net profit measurement, but you strip out any income or expense that’s unrelated to your core operations.  This means removing gains or losses from asset sales, as well as any changes in reserves, and also take out any interest income or expense.

The intent of this measurement is to strip out all of these non-operational items that muddy the waters and keep you from seeing how the company is actually performing.  If you don’t have large amounts of these non-operational items cluttering up your income statement – then don’t bother with it.  But if you do, this really should be the preferred measurement to use instead of net income.  Obviously you can’t use it for external reporting, but it’s a good one for internal management reports.

Core Operating Earnings

Now, here’s a much more complicated version of the same concept, which is called core operating earnings.  Standard & Poor’s came up with this one.  They start with the income figure, and then modify it to arrive at the earnings of a company’s core operations.  Here’s how it works:

You begin with net income, then add back stock option expenses, and restructuring charges, and pension expenses, and purchased R&D expenses, and asset write-downs.  Then, you subtract out any goodwill impairment charges, and gains or losses from asset sales, and pension gains, and merger and acquisition expenses, and litigation expenses, and any gains from hedging activities.  That’s eleven different changes to the net income figure, which may seem like a lot.  On the other hand, as I go down that list, I can see that five of them would have applied to my company in just the last few months.  So you may want to try it, and see if you get a more realistic view of how your company is doing.

Sales Margin

Here’s a measurement you can use to replace the gross margin, and it’s called the sales margin.  This one is the gross margin, minus all sales expenses, divided by sales.  Basically, it dumps all of your sales expenses into the cost of goods sold, so the only expenses not included in the cost of goods sold are administrative.  This is a good measurement if you want to track margins by product line, and if your sales expenses are fairly easily traceable to those products.  It’s also useful if most of your sales expenses vary with sales volume – which can happen if the sales people are paid mostly on a commission basis.

The sales margin is really useful when you have a product line where customers require lots of intensive hand holding by the sales staff.  In this case, it makes a great deal of sense to charge the sales expense directly to that product line, just to see what your margins are really like.  And they could very well be negative.

Operating Leverage Ratio

Here’s another measure to consider – the operating leverage ratio.  This one compares the amount of fixed expenses to operating income.  It’s really useful when you’re considering getting rid of variable expenses and substituting fixed expenses instead, such as when you replace manufacturing workers with a robot.

The measurement is sales, minus variable expenses, divided by operating income.  If the ratio goes up, then you’re adding to your base of fixed expenses, which probably means that your breakeven point just went up, and that means you’re more likely to lose money if sales decline.

Quality of Earnings Ratio

And let’s do one last measurement, which is the quality of earnings ratio.  This one compares the reported earnings level to cash flow from operations.  If the two numbers are fairly close, then the reported earnings level is a fair reflection of how the company is actually doing.

To calculate the quality of earnings, subtract cash flow from operations from net income, and then divide by your average assets for the reporting period.  If the net income and cash flow numbers are about the same, then the result should be close to zero – which is good.  Any number higher than about 6% indicates a low quality of earnings.

On this measurement, keep in mind that there may be a good reason for a difference between net income and cash flow – but, that different should be a one-time event.  So if the ratio is fairly large for multiple reporting periods, there’s probably some accounting trickery going on.

Related Courses

Business Ratios Guidebook

Metrics (Asset Utilization) and New 2007 Accounting Standards (#30)

In this episode, we review upcoming new accounting standards, as well as some of the better metrics relating to asset utilization. Key points discussed concerning new accounting standards are:

  • Conceptual Framework Project; could be at the top of the GAAP Hierarchy

  • Business Combinations; acquisition method

  • Fair Value Option

  • Earnings per Share; to converge with IFRS standards

  • Income Taxes; to converge with IFRS standards

  • Nonprofit Accounting

  • Post-Retirement Benefits; implementation guidance

  • Subsequent Events; cleanup issues

  • Emerging Issues Task Force; changes to its approval process

  • Securities and Exchange Commission; Staff Accounting Bulletin 108

Key points relating to the metrics for asset utilization are:

  • Sales per person; can be adjusted by using outsourcing or part-time employees

  • Need to look at asset utilization on an individual basis to see impact on bottleneck operations

  • Repairs to fixed assets ratio; fixed assets are stated at gross, and intangible assets are excluded

  • Accumulated depreciation to fixed assets ratio; increasing trend shows preponderance of old assets; might also still have old assets on the books that have already been dispositioned

  • Breakeven point; useful for understanding maximum possible profitability, as well as the margin of safety; can be used to view the impact of new fixed asset purchases on the breakeven point

Related Courses

Business Ratios Guidebook

GAAP Guidebook

Metrics (Cash Flow) and Excel Risk Mitigation (#29)

In this episode, we review the ways in which Excel spreadsheets can fail and how to mitigate these risks, and also discuss the essential metrics relating to cash flow. Key points discussed concerning Excel risk mitigation are:

  • Excel is useful for rapid system construction.

  • It is possible to set up data validation in Excel, but this feature is rarely used.

  • A general failing is the high degree of company-wide access to Excel spreadsheets.

  • A user can have a false sense of security when using Excel, not realizing the ways in which it can issue false results.

  • The best risk mitigation approach is to identify the most critical spreadsheets in the business and focus on improving them; review for complicated formulas that are likely to fail.

  • There are spreadsheet problem detection products on the market that can be applied to Excel.

  • Use the Excel feature to view all formulas; makes it easier to peruse them.

  • Look for hard coded figures within a range of formulas; more prone to error.

  • Investigate cells containing high-dollar values.

  • Conduct data analyses for large data sets within a spreadsheet.

Key points relating to the metrics for cash flow are:

  • Always use a few cash flow measurements as a basis of comparison to other metrics.

  • Cash flow return on sales; shows the amount of cash generated as a percent of sales.

  • Cash flow return on assets; less subject to manipulation than return on investment metrics.

  • Fixed charge coverage; use it to see if most of a firm’s cash flow is used to pay for its fixed expenses.

  • Cash to current assets ratio; a high proportion of cash indicates a high level of liquidity.

  • Cash to current liabilities; provides a very conservative view of cash requirements.

  • Cash flow to debt ratio; see if there is sufficient cash flow available to pay down debt obligations.

Related Courses

Business Ratios Guidebook

Introduction to Excel

Excel Formulas and Functions

Metrics (Liquidity) and a Review of Accounting in 2006 (#28)

In this episode, we review the key accounting events during the past year, and also discuss the key metrics for liquidity. Key points discussed concerning accounting events are:

  • Enron and Worldcom jail terms were handed down.

  • There were a series of stock option manipulation frauds.

  • The SEC issued new compensation disclosure rules.

  • FIN 46 was issued, involving off-balance sheet reporting requirements.

  • Issues with the existing lease and pension accounting standards were discussed.

  • The industry dealt with ongoing complaints about the requirements of Sarbanes-Oxley section 404, pertaining to systems of control.

Key points relating to the metrics for liquidity are:

  • The current ratio is not a useful indicator of liquidity, since it includes inventory, which is not liquid.

  • The quick ratio is better, since it removes inventory from the calculation.

  • A comparison of sales to assets can be plotted on a trend line; the proportion should be about the same over time.

  • The days of working capital ratio indicates the amount of working capital needed to support one day of sales.

  • The accounts receivable collection period indicates the average number of days during which an invoice is outstanding, before it is collected.

  • A comparison of sales to inventory can be plotted on a trend line, to indicate the ongoing investment level of a business in inventory.

  • The accounts payable days measurement can be plotted on a trend line to highlight any changes in payables duration.

  • The risky assets conversion ratio shows the percentage of low-value assets on a company’s balance sheet.

Related Courses

Business Ratios Guidebook

Metrics (Inventory) and the Risk Assessment Suite, Part 2 (#27)

In this episode, we delve further into the risk assessment suite, and also describe the most useful metrics for inventory. Key points discussed relating to the risk assessment suite are:

  • It was created in response to high-profile audit failures.

  • It requires a more robust understanding of the client, its risk management practices, operating environment, strategy, and competitive factors.

  • The client will likely be required to complete a questionnaire pertaining to the preceding items.

  • There is a new focus on auditing the financial statement presentation and disclosures.

  • The auditor will need to ask more questions about a client’s internal controls.

  • It requires consideration of a client’s internal controls as part of an audit.

  • More attention must be paid to the risks of material misstatement of financial statements.

  • Link the audit program to an increased need to address the risks of material misstatement.

  • Work by the client to assist the auditor can reduce fees; it may also be possible to reschedule the audit to assist the auditor.

Key points discussed related to metrics for inventory are:

  • Inventory turnover is useful for seeing how much inventory is needed to support sales.

  • The proportion of old inventory on hand is needed to call attention to the need to eliminate inventory. The percentage of returnable inventory is a more specific variation.

  • Inventory accuracy is needed by the purchasing and picking staffs, and reflects inventory record accuracy.

  • Inventory availability is needed to see if there is a problem with delivering to customers on time.

  • The percentage of warehouse utilization is needed to plan for additional investments in warehouse space.

  • The cubic volume of warehouse space used is useful for adjusting the warehouse racking systems to accommodate more inventory.

Related Courses

Business Ratios Guidebook

How to Conduct an Audit Engagement

Inventory Management

Metrics (Payroll) and the Risk Assessment Suite, Part 1 (#26)

In this episode, we give an overview of the risk assessment suite, and also describe the most useful metrics for the payroll function. Key points discussed relating to the risk assessment suite are:

  • The cost of audits for a public company can be three times the cost of audits of privately-held companies.

  • There is a disparity between the need for higher levels of assurance arising from audits and the pressure on auditors to keep their prices down.

  • The risk assessment suite revises auditing standards to make audits more comprehensive.

  • As a result of the risk assessment suite, audit planning will likely start sooner, so audits will also start sooner, and auditors will be more inclined to finish all audit work while still in the field.

Key points discussed related to metrics for payroll are:

  • Use the number of manual paychecks cut per 1,000 payees

  • Use the number of W-2c forms issued per 1,000 payees

  • Use an error summarization system to self-report payroll errors, and then issue an aggregated report by error type.

  • Use payroll outsourcing costs by month, divided by the number of payees; track on a trend line.

  • Use the total payroll department cost divided by the total number of payees; track on a trend line.

  • Use the number of W-2 forms downloaded by employees, divided by the total number of payees; useful when posting W-2 forms on a central site, where employees can readily access them.

Related Courses

Business Ratios Guidebook

How to Conduct an Audit Engagement

Payroll Management

The Fast Close, Part 10 (#25)

In this episode, we cover improvements to the billing process, and make final comments about the fast close. Key points discussed concerning billing are noted below.

The Closing Issues with Billing

I’ve saved billing to be the last item I cover in these discussions on the fast close, because most people tend to leave it for last.  When you start a fast close project, billing is not usually considered a problem area, because it doesn’t really take that long to complete.  Instead, people like to focus their attention on the really massive issues, like improving inventory accuracy.  But once they get past all of those other problems, billing is still waiting there, totally unimproved and hogging a large chunk of the closing day.

The main issue with billing is that you really can’t eliminate it entirely on closing day.  More than likely, there’s been a fair amount of shipping right through the end of the preceding day, and that’s just going to take some time to process.  However, there are some ways to improve the situation.

Issue Invoices Early

First, issue invoices as early as possible.  This means completely flushing out every other invoice related to shipments made earlier in the month.  There’s absolutely no excuse for waiting until closing day to complete invoices that could have been handled a few days before.

Also, issuing invoices as early as possible also means having someone stay late on the last day of the close in order to create invoices based on any shipping documents sent in by the shipping department up to that point.

First thing the next morning, send someone down to the shipping dock to verify everything that was shipped the day before, and to bring back any remaining shipping documents.  Get someone working on these last invoices as soon as possible.

Put Resources on Invoice Issuance

However, even being organized like this is not enough.  There may be such a volume of invoices to be created that it still takes a bunch of hours.  If so, you should assign practically everyone to do invoicing during the morning of the close.  In addition, give each one of them their own laser printer, so they can more efficiently create invoices.  Not having them walk to a central printer can save a surprising amount of time.

Do Not Retype Information

Another time-saving trick is to not retype a lot of information from supporting documentation onto an invoice.  Instead, enter on the invoice something like, “See attached” or “As per the attachment,” and then staple the supporting documentation to the invoice.  Or, if you’re copying from an electronic document, try to cut and past the information into the invoice, rather than manually retyping it.

Use Special Invoice Templates

Also, we’ve all run across those painful customers who want invoices issued to them in a very specific format – or else they’ll reject the invoice.  The slow and painful approach is to manually create exactly what they want, no matter how much time it takes.  However, if the customer is going to be around for a while, consider creating a special customer invoice template for them, so that the special formatting becomes a routine billing issue.

Additional Comments

In addition, don’t keep waiting to create an invoice if there’s a chance that its contents may change in the near future.  If you wait around for more accurate information, it may not arrive for weeks.  A better alternative is to at least create the invoice, so the revenue is booked, and then modify it after the fact – if that’s even necessary.

And finally, if you send out month-end statements, don’t do it right in the middle of the close.  That’s something that can easily wait a day or two, so just schedule it for some other time.

So, some final comments on the fast close.   Your primary goal is to shift work out of the closing day, so the most effective change you can make is to shift closing work forward into the preceding month.  Another comment is that the fast close does not require much money – you don’t need fancy accounting or workflow management software.  In fact, you don’t really even need a consultant.  But if you do hire a consultant, get one with a good industrial engineering or process analysis background.  That kind of skill is useful, because the fast close is entirely about process improvement, and not at all about accounting.

Related Courses

Closing the Books

The Soft Close

The Year-end Close

The Fast Close, Part 9 (#24)

In this episode, we talk about the techniques that can be used to improve the closing process for payroll. Key points discussed are noted below.

Payroll involves a couple of closing activities that can really slow down the close, but you can get around one of them with a procedural change and the second one with a systems change.

Commission Calculations

The first item is commission calculations.  It tends to be one of the absolute last items to do in the close, because you have to wait until all invoices are completed before you can figure out which person has earned a commission.  And on top of that, your commission structure may be really complicated, perhaps with commission splits, overrides, bonuses, and so on.  Because of all the complexity, you do an initial calculation and then send it to the sales manager for a review, which may not come back for a day or two.

There are some ways to get around these problems.  First, the quick and dirty – and least accurate -- approach is to figure out the historical commission percentage of sales in each month, and just book an accrual for the commissions to be paid, based on your total sales.  This only works if the commission structure is really simple, because most of the time, the complexity of the commission system could result in a very different commission percentage every month.

A better approach, and the one that I use, is to calculate commissions the night before the end of the month, so I’ve included almost every invoice, and then tack on the few remaining invoices that have to be created once the month is over.  At that point, I book the commission accrual, even though no one has reviewed the calculations yet.  My reasoning here is that the commission I’ve booked is almost certainly going to be very close to the final corrected number.  Usually, the only changes I see after that point involve who gets the commission, not the amount of the commission.

In short, these changes allow me to finish off the commission accrual on closing day in less than an hour.

Unpaid Wages Accrual

Now, the second activity that can slow down the close is the accrual of unpaid wages.  This is mostly a problem for companies with lots of people who are being paid on an hourly basis.  In the worst case scenario, these employees fill out manual time cards, which require all kinds of reconciliation time, as well as time to track down missing timecards.  If you have a labor-intensive operation, this may even be the chief bottleneck that gets in the way of a fast close.

Here’s how you get around the problem.  As was the case with commissions, I’ll first bring up the idea of a quick and dirty – and less accurate -- solution, which is to assume that everyone works a standard number of hours per day, so you accrue this amount, and don’t even wait for the timesheets to arrive.  And, as was the case with commissions, this is not such a good idea for a lot of companies, because the hours per person may vary a lot.

The approach I use is to require everyone to enter their time in an internet-based timekeeping system, which automatically summarizes all of the accrual information for me.  A key part of this approach is to issue constant reminders to employees before the close, so they know they have to submit their hours.  In addition, we are very pushy about getting all employee hours entered every single week.  By making a big deal of this all the time, we’ve really trained employees to submit their hours on time, every time.  Of course, there will always be a few employees who haven’t recorded their hours for the last few days of the month, but at that point, I feel a lot more comfortable accruing for just a few hours of unrecorded time.

Now, what if your employees don’t have internet access?  You can set up computers on the company premises, so that they can enter their time.  Or, you can set up computerized time clocks that automatically upload all employee hours into a central database, and that basically gives you the same information that would have come from an internet-based system.

Related Courses

Closing the Books

The Soft Close

The Year-end Close

The Fast Close, Part 8 (#23)

In this episode, we discuss how to improve inventory record accuracy, which can have a massively positive impact on the speed of the close. However, the improving inventory record accuracy is a prolonged process that will undoubtedly take months, and consume the time of the best warehouse workers. Key points discussed are noted below.

Inventory closing is a monster problem for companies that don’t have good tracking systems, and it’s a complete non-event for those that do.  This is because the closing difficult almost always stems from tracking the physical quantity of goods on hand, not the cost of the inventory.  So, I’m going to focus on how to achieve really excellent inventory record accuracy.

But first, be aware that if you suffer from poor record accuracy right now, you’re doomed to keep on having a slow close for several months to come, because improving your accuracy is a slow process – as you’re about to see.  Just keep in mind, there is no magical way to suddenly have 98% accurate inventory records.  This is a slow and methodical process.

Let’s see how it works.

Install inventory Tracking Software

The first step is to install a good inventory tracking software package.  Most accounting packages already have one, so I won’t get into this part too much.  The main software feature you’re looking for is the ability to record a storage location for each item of inventory, and preferably multiple locations for a single inventory item.  If you don’t have this, then go look for different software.

Create Rack Locations

Next, you need to create unique rack locations.  This means that you designate the first aisle as A, then B, and so on.  Within each aisle, you need to number every rack.  A common system is to designate the first rack on the left as rack number one, then the first rack on the right as rack number two, then the second rack on the left as rack 3, and so on.  Within each of those racks, every level should be numbered.  So for example, the fourth bin up in the second rack of aisle C would be designated with the location C-2-D.  You need this level of very precise location codes in order to know where all of the inventory is located.

Lock the Warehouse

Next, you have to lock down the warehouse.  This may sound medieval, but you really have to do it.  I have never seen a warehouse with perfect accuracy that did not fence it off.  The trouble is not that employees walk off with inventory, but that they have a bad habit of taking it off the shelf to examine it, and then putting it back somewhere else, which makes it really hard to find.

Consolidate Parts

Next, consolidate parts.  The usual warehouse has the same part stored in several locations, which is OK is you have a good location tracking system.  But we’re not there yet, so keep each item in one place while you get things organized.

Assign Part Numbers

Now is the time to assign part numbers to every part in the warehouse.  A key point is to only use the most senior warehouse staff to do this, because anyone else is extremely likely to assign the wrong part numbers, which will cause all kinds of problems down the road.

Verify Units of Measure

Once those numbers are assigned, Make sure that the units of measure are correct.  Where possible, mark the correct unit of measure right on the inventory item, so there’s no mistaking what it is.  When someone uses the wrong unit of measure, it’s amazing how incorrect your quantities will be.

Pack the Parts

Next up, pack the parts.  This means that you should count loose parts, then seal them up in boxes or bags, and write the count quantity on the box or bag.  This makes it much faster to count inventory when you get to cycle counting, which I’ll talk about in a minute.

Count and Load the Inventory Data

Next up is the big weekend project, which is to count all the inventory items, and enter the numbers into the inventory tracking software.  And the key part is, you enter this information along with the location codes.  The data is not going to be completely correct, but cycle counting will take care of that over the next couple of months.

Cycle Count

The next step is cycle counting.  This means that the most experienced warehouse staff will count a small quantity of inventory every single day.  When they do a count, they don’t just correct any errors they find – they also spend some time tracking down why the error occurred, and then they fix the problem.  By going after the underlying problems, you’ll see a nice, steady rise in the inventory accuracy percentage over several months.

Audit the Inventory

And speaking of that inventory accuracy percentage, send someone from the accounting department down to the warehouse once a week to do a spot check of inventory accuracy.  The best way to report this information is to post it on a white board in the warehouse, and preferably by aisle.  When you assign specific warehouse staff to each aisle, and then measure accuracy by aisle, this is a really good way to find out who is good a t cycle counting.

However, be warned, a high level of accuracy can simply mean that an aisle contains lots of slow-moving inventory items, so whoever is doing the cycle counts actually has a really easy time of it.  Conversely, if you have an aisle with really high inventory turnover and the accuracy is still high, then you’ve got a fantastic cycle counter in charge of that aisle.

Issue Bonuses

Finally, reward the staff with bonuses as the accuracy levels gradually go up.  This shows them that accuracy really matters – at least, it really matters to you, since it’s pretty to close the books when you have no idea if the inventory number is even close!

My experience with improving inventory record accuracy is fairly extensive – I’ve taken the accuracy level to about 98% for four different companies.  Based on that experience, my key tip is persistence.  Accuracy will not be achieved overnight, and it can also drop really fast if you don’t pay attention to it.  So – do a few inventory audits yourself, and personally hand out bonuses to the warehouse staff – and keep doing it over and over again.

If you follow the approach I’ve just outlined, then you’ll eventually just print out the inventory reports at the end of the month and not even question their accuracy.  This area can truly become a non-event, but it takes time.

Related Courses

Closing the Books

The Soft Close

The Year-end Close

The Fast Close, Part 7 (#22)

In this episode, we discuss how the payables function can be streamlined, so that the time associated with it as part of the closing process is minimized. Key points discussed are noted below.

Payables is one of the larger logjams that gets in the way of a fast close.  A lot of controllers – whom I would call overly cautious -- prefer to wait several days – sometimes up to a week – for every last supplier invoice to come in before they continue with the close.  They do this because they’re afraid they’ll miss a large invoice and thereby report too small an amount of expenses in the income statement.

There are several ways to get around this problem, and which should allow you to close payables in just a few hours.  The solution revolves around your comfort level with not waiting for supplier invoices.

Record Accruals

Your first (and best) solution is to create an accrual based on what’s come in at the receiving dock, and for which you have purchase orders.  You can then merge this receiving and pricing information together to create an extremely accurate accrual.  It’s usually best to create a custom computer report that generates this accrual automatically, so you don’t make any mistakes.  And for that matter, a computer report also requires much less time to create.

OK, that was the easy accrual, since it was based on the receipt of hard goods.  What about other supplier invoices for which you don’t have hard evidence of receipt, like services?  There are a couple of solutions.  One is to create a contract summary file that itemizes all payments that the company is contractually supposed to make each month.  Then compare it to the invoices that have already come in, and accrue anything remaining.

Another option is to track supplier billings on a trend line, and simply accrue the average amount that is likely to arrive in the mail.  But -- use this one with great caution, because the actual amount may vary lot from the average.  In most cases, I choose not to use it at all, since larger invoices are your main area of concern – and those are almost always covered by contracts or purchase orders that will give you better accrual information.

Obviously, the solutions I’ve just mentioned involve lots of accruals, and that may not be something that you’re comfortable with, since accruals can be inaccurate.  If so, I suggest starting only with those accruals that are based on hard receipt information and supporting purchase orders, where your accrual is bound to be right – probably to within a few dollars.  Once you’re comfortable with that system, work your way down into other accruals that may be less accurate, until you reach a level of discomfort.

At that point, you’ll almost certainly have reduced your payables closing time by a fair amount.  If you ever want to address the accruals topic again, there’ll always be a few more accruals to investigate.

Minimize Invoice Approvals

Now, there are some other problems with the payables system that can delay the close.  One of the worst involves the approval of supplier invoices.  Some companies send out invoices for approval before they log the invoices into the payables system, so the close has to wait until the various managers fish the invoices out of their in boxes and approve them and send them back to the payable staff.  This can take weeks.  A much more streamlined approach is called negative approval – this involves logging in all invoices as soon as they arrive, and then sending a notification to the approving manager that the payable staff is going to pay it unless they hear otherwise.  Realistically, they almost never hear from the managers, and everyone is happy.  Best of all, payables can be processed a whole lot quicker.

If you want to push this concept a step further, consider reducing the number of approvals needed, so it’s only for items that are really large and which don’t already have an authorizing purchase order.

Pay Based on Purchase Orders

Another technique for streamlining payables is to pay based on the information in the purchase order, rather than the supplier invoice.  Under this approach, the computer system automatically sets up payments as soon as goods are received, so there’s no need for a supplier invoice at all.  This system is called evaluated receipts, and it’s not available on most smaller accounting packages, so it’s really only option if you have a large ERP system, like Oracle or SAP.

Use Procurement Cards

A completely different approach to streamlining the payables system is to not use it all!  Instead, bypass the whole thing for smaller purchases and use procurement cards to buy all of the low-cost items.  This involves a whole different set of procedures and forms and training, but on the other hand, it really reduces the payables workload, and so makes it easier to close the books.

Use a Web Portal

And speaking of completely different approaches, consider that the main problem with the payables close is waiting for supplier invoices to work their way through the postal system to get to your company.  So… how about skipping the postal system entirely?  You can set up a web page on your company’s Internet site, and have suppliers enter their invoices directly into your computer system.  This might seem a little demanding, but you could promise to pay them a few days early in exchange.

Parting Thoughts

Out of all the preceding suggestions, the main one is to use more accruals rather than waiting for supplier invoices to arrive.  If you do that, there’s no reason why you can’t close the payables function in a few hours.

Related Courses

Closing the Books

The Soft Close

The Year-end Close