No doubt, a year ago, there were days when Roger Shannon, assistant treasurer of Brown-Forman Corp., probably could have used a shot of Jack Daniel’s to help him through the day. Back then, the $2.4 billion distiller and distributor of wines and spirits, including the popular whiskey, was still using what Shannon described as “Stone Age” tools to manage working capital and make cash forecasts. All of Brown-Forman’s 16 separate subsidiaries were forced to re-key bank information into cumbersome spreadsheets for daily cash positions, manually reconcile accounts and post account-receivable receipts from paper bank statements.
“To establish our daily cash position, we would determine our cash balance either by polling the bank with dial-up software or by receiving a fax from the bank and then manually key in this information into an Excel spreadsheet,” Shannon recounts. “Recording cash movement between accounts in the general ledger also was made manually at month-end from the cash spreadsheet’s batch totals. This made monthly bank reconciliation more difficult because the detail on the bank statement had to be reconciled to the consolidated batch entries in the ledger. We would then re-key data into desktop banking systems whenever we needed to make a wire transfer or a foreign exchange payment. Re-keying always presents the opportunity to mis-key something or miss something. You get an account number wrong and send a wire to the wrong place. The entire process was time consuming and very inefficient.”
Sign In
Sign In
Copyright © 2024 ALM Global, LLC. All Rights Reserved.