Skip to content
American ExpressAmerican ExpressAmerican ExpressAmerican ExpressAmerican Express
  • Card Accounts

    • Your Account
    • Activate a New Card
    • Register for Online Services
    • Amex Mobile App Features
    • Add Someone to Your Account
    • Moving Abroad? Transfer Your Card

    Business Owners

    • Your Account
    • Activate a New Card
    • Register for Online Services
    • Membership Rewards & Travel
    • Add Someone to Your Account

    Other Accounts

    • American Express @Work
    • Online Merchant Services
    • International Payments for Businesses

    Contact Us

    • Support 24/7
    AustraliaChange Country
  • Personal Cards

    • View All Personal Cards
    • Learn About Credit Cards

    Popular Personal Cards

    • The Platinum Card
    • The Qantas Ultimate Card
    • The Explorer Card

    Cards for Business Owners

    • View all Business Cards
    • Popular Business Cards
    • Manage Your Business

    Corporate Cards

    • View All Corporate Cards
    • Corporate Payment Solutions
    • Corporate Purchasing Card
    AustraliaChange Country
  • Online Travel

    • Book Travel Online
    • Book Fine Hotels & Resorts
    • Book The Hotel Collection

    Travel Resources

    • Destination Guides
    • Travel Insurance
    • Using Your Card Overseas
    • Card Member Benefits
    • Find a Travel Service Office

    Business Travel

    • Global Business Travel Solutions
    • Small Business Travel
    • Foreign Exchange Services

    Travel Money

    • Travelers Cheques
    • Qantas Credit Cards
    • Travel Rewards Credit Cards
    AustraliaChange Country
  • All Insurance Services

    • Insurance Home Page
    • Insurance with your card
    • Other Insurance

    Travel Insurance

    • Travel Insurance
    • Multi-Trip/Annual Policy
    • Single Trip Policy
    AustraliaChange Country
  • Membership Rewards

    • Use Points for Gift Cards
    • Use Points for Travel
    • Rewards Changes

    Rewards Programs

    • Membership Rewards Cards
    • Qantas Frequent Flyer

    Card Member Offers & Benefits

    • Explore Card Benefits
    • Amex Experiences
    • Refer Friends. Earn Rewards
    AustraliaChange Country
  • Merchants

    • Merchant Home
    • Accept the Card
    • Manage Merchant Account
    • Contact Us and FAQs

    Corporations

    • Corporate Cards
    • Purchasing Solutions
    • Customer Centre
    • Global Business Travel Solutions
    • Meetings & Events
    • International Payments for Businesses

    Business Owners

    • Popular Small Business Cards
    • View All Small Business Cards
    • Manage Your Business
    • Business Credit vs Charge
    • How to Apply for a Business Card

    Global Network

    • Home
    • Issuers
    • Acquirers
    • Service Providers
    • Developers
    AustraliaChange Country
  • Contact Us
  • Log In
      • Your Account
      • Activate a New Card
      • Register for Online Services
      • Amex Mobile App Features
      • Add Someone to Your Account
      • Moving Abroad? Transfer Your Card
      • Your Account
      • Activate a New Card
      • Register for Online Services
      • Membership Rewards & Travel
      • Add Someone to Your Account
      • American Express @Work
      • Online Merchant Services
      • International Payments for Businesses
      • Support 24/7
      • View All Personal Cards
      • Learn About Credit Cards
      • The Platinum Card
      • The Qantas Ultimate Card
      • The Explorer Card
      • View all Business Cards
      • Popular Business Cards
      • Manage Your Business
      • View All Corporate Cards
      • Corporate Payment Solutions
      • Corporate Purchasing Card
      • Book Travel Online
      • Book Fine Hotels & Resorts
      • Book The Hotel Collection
      • Destination Guides
      • Travel Insurance
      • Using Your Card Overseas
      • Card Member Benefits
      • Find a Travel Service Office
      • Global Business Travel Solutions
      • Small Business Travel
      • Foreign Exchange Services
      • Travelers Cheques
      • Qantas Credit Cards
      • Travel Rewards Credit Cards
      • Insurance Home Page
      • Insurance with your card
      • Other Insurance
      • Travel Insurance
      • Multi-Trip/Annual Policy
      • Single Trip Policy
      • Use Points for Gift Cards
      • Use Points for Travel
      • Rewards Changes
      • Membership Rewards Cards
      • Qantas Frequent Flyer
      • Explore Card Benefits
      • Amex Experiences
      • Refer Friends. Earn Rewards
      • Merchant Home
      • Accept the Card
      • Manage Merchant Account
      • Contact Us and FAQs
      • Corporate Cards
      • Purchasing Solutions
      • Customer Centre
      • Global Business Travel Solutions
      • Meetings & Events
      • International Payments for Businesses
      • Popular Small Business Cards
      • View All Small Business Cards
      • Manage Your Business
      • Business Credit vs Charge
      • How to Apply for a Business Card
      • Home
      • Issuers
      • Acquirers
      • Service Providers
      • Developers
  • Contact Us
AustraliaChange Country
  • Card Accounts

    • Your Account
    • Activate a New Card
    • Register for Online Services
    • Amex Mobile App Features
    • Add Someone to Your Account
    • Moving Abroad? Transfer Your Card

    Business Owners

    • Your Account
    • Activate a New Card
    • Register for Online Services
    • Membership Rewards & Travel
    • Add Someone to Your Account

    Other Accounts

    • American Express @Work
    • Online Merchant Services
    • International Payments for Businesses

    Contact Us

    • Support 24/7
  • Personal Cards

    • View All Personal Cards
    • Learn About Credit Cards

    Popular Personal Cards

    • The Platinum Card
    • The Qantas Ultimate Card
    • The Explorer Card

    Cards for Business Owners

    • View all Business Cards
    • Popular Business Cards
    • Manage Your Business

    Corporate Cards

    • View All Corporate Cards
    • Corporate Payment Solutions
    • Corporate Purchasing Card
  • Online Travel

    • Book Travel Online
    • Book Fine Hotels & Resorts
    • Book The Hotel Collection

    Travel Resources

    • Destination Guides
    • Travel Insurance
    • Using Your Card Overseas
    • Card Member Benefits
    • Find a Travel Service Office

    Business Travel

    • Global Business Travel Solutions
    • Small Business Travel
    • Foreign Exchange Services

    Travel Money

    • Travelers Cheques
    • Qantas Credit Cards
    • Travel Rewards Credit Cards
  • All Insurance Services

    • Insurance Home Page
    • Insurance with your card
    • Other Insurance

    Travel Insurance

    • Travel Insurance
    • Multi-Trip/Annual Policy
    • Single Trip Policy
  • Membership Rewards

    • Use Points for Gift Cards
    • Use Points for Travel
    • Rewards Changes

    Rewards Programs

    • Membership Rewards Cards
    • Qantas Frequent Flyer

    Card Member Offers & Benefits

    • Explore Card Benefits
    • Amex Experiences
    • Refer Friends. Earn Rewards
  • Merchants

    • Merchant Home
    • Accept the Card
    • Manage Merchant Account
    • Contact Us and FAQs

    Corporations

    • Corporate Cards
    • Purchasing Solutions
    • Customer Centre
    • Global Business Travel Solutions
    • Meetings & Events
    • International Payments for Businesses

    Business Owners

    • Popular Small Business Cards
    • View All Small Business Cards
    • Manage Your Business
    • Business Credit vs Charge
    • How to Apply for a Business Card

    Global Network

    • Home
    • Issuers
    • Acquirers
    • Service Providers
    • Developers

AustraliaChange Country
Small Business Cards
Cards
American Express® Platinum Business Card
American Express® Qantas Business Rewards Card
American Express Business Explorer® Credit Card
View All Cards
Compare Cards
International Payments
International Payments
American Express AccessLine™
View All International Payments
Manage Your Business
Business Benefits
Why Amex for your Business?
Business Credit vs Charge
Business Rewards
Business Cash Flow Management
Business Travel Rewards
Existing Customers
Order Cards for Employees
Corporate Card Programs
Cards
American Express® Corporate Platinum Card
American Express® Qantas Corporate Platinum Card
American Express® Corporate Gold Card
View All Corporate Cards
Compare Corporate Cards
Payment Solutions
Buyer Initiated Payments
American Express vPayment™
View All Supplier Payments
International Payments
American Express AccessLine™
View All International Payments
Trend & Insights
Business Trends & Insights
Products & Solutions
Service & Expertise
Existing Customers
Trends & Insights
Trends & Insights
Insights and Inspiration to Help Grow Your Business
Security
Managing Supply Chain
Managing Data and Trends
Managing Risks
Growth
Expanding
Adapting to Change
Future Proofing
Funding
Managing Cash Flow
Financing
Becoming More Efficient
People
Leading My Team
Managing Talent
Collaborating
  • Trends and Insights
  • Growth
  • Adapting to Change
Business Class

22 April 2019

Will CFOs ever experience life without spreadsheets?

Will CFOs ever experience life without spreadsheets?

Twitter Icon
Facebook Icon
LinkedIn Icon
Alexandra Cain

Writer, Cain Creativity, Inc.

Summary

Spreadsheets have been used for decades with millions of finance professionals continuing to rely on them to store and model data. While it may be impossible to perceive a time when they will no longer be used, there are technology innovations surrounding them that CFOs should be aware of.

Twitter Icon
Facebook Icon
LinkedIn Icon

Most finance professionals have been accustomed to regular use of spreadsheets throughout their career – but as technology advances rapidly, the question has been raised: will finance chiefs ever experience life without spreadsheets?

Spreadsheets are pervasive digital tools, bundled together with millions of computers around the world, and provide solutions for a wide range of issues, from visualising results, to designing questionnaires and managing large data sets. Their flexibility and ease of use are just two reasons why we are likely to see spreadsheets continue to be an essential business tool. 

The first spreadsheet was a program called LANPAR which ran on mainframe computers in 1969, and by 1979 a spreadsheet called VisiCalc (short for “visual calculator”) was developed for Apple computers. Four decades on, spreadsheets remain a very useful business tool.

The way spreadsheets are used will vary with the size of a business, the industry it operates within and the needs of the company's operational leaders. New digital tools are available to enhance the effectiveness of spreadsheets, and the utility and popularity of spreadsheets in the finance function is set to continue into the future. 

How are spreadsheets still useful?

CPA Lynda James runs Valo Financial. She says spreadsheets come into their own when a business has highly complex operations. Such firms generally have many channels of income and many avenues in which a product or service is sold. They also have varying levels of margins and prices, and different product variations.

“In this instance, it can be difficult and expensive to have a database pull all this information together because the environment is so dynamic and the source information comes from many different programs,” she says. “If CFOs want the information grouped together, one system usually can't cope. However, spreadsheets can as they are able to collate internal source documents and external reports to provide a holistic perspective around the health of a business.” This flexibility is a key reason why spreadsheets will continue to be used.

Another important and ongoing use for spreadsheets involves forecasting. Many management accountants and business analysts use retrospective data reports that are manipulated in spreadsheets to produce forecast and scenario analysis for particular variables a business may be considering.

“Whether these variables include increasing sales via different channels or introducing a new product or offer, accountants can easily use spreadsheets to project a possible outcome and adjust pricing or volume accordingly to work out the best way to reach a financial goal or sales target,” James says.

Medium-sized businesses, where larger volumes of data are not as common, tend to rely on spreadsheets to help CFOs gain an understanding of the health of their business.

“Finance chiefs can easily download reports in CSV format from bookkeeping packages and change variables to work out how to enhance profits or sell more products,” James says.

“Using a spreadsheet for these types of scenarios is affordable and easy. It also becomes to some degree a living document for the business owner, unlike standardised reporting from software,” she adds.

There's an opportunity to improve the financial literacy levels of people in the finance team, especially new hires, with spreadsheets.

“I've found customised financial spreadsheets are a great way to show people information at a level they understand,” she says. “I then slowly increase the complexity or change the key performance indicators as their knowledge grows so they can make better business financial decisions.”

Spreadsheets are improving but require good financial understanding

Standardised financial reporting has improved as bookkeeping systems advance. But without a good financial understanding it can be difficult for finance teams to fully appreciate what they're seeing in a spreadsheet.

Having an experienced accountant build a customised spreadsheet, which includes key performance indicators, is invaluable, says James. She adds that these performance indicators could include a monthly summary that highlights the key numbers to watch and track, and which also act as a “red flag” for when KPIs move in an unexpected way.

“The ability to compare KPIs, such as the average cost of goods sold or the average sales revenue of goods sold, are not typically available with standardised reports,” she says. “Also, there is some sales data that is never entered into bookkeeping software, such as when your e-commerce website or store 'cash register' is not linked to your bookkeeping software.”

James says without knowing this information it's difficult to compare what the business sells per item, sales revenue per item and direct and operational costs per item.

“These calculations tell a good story of what is happening in your business each month,” she says.

When should other technology be used?

While spreadsheets are great at showing the numbers, add-ons to bookkeeping packages and other reporting tools such as Power BI may provide a better visual representation of figures.

James says they also offer automation features that can extract data, feed it into customised reporting outputs and send the information to stakeholders.

“If you have good source data this can be a big time-saver, although you generally need a good analyst to set this up,” she says. “In Excel or another program, you would need to build the graphs and charts yourself.”

The growing use of technology within bookkeeping systems and accounting packages is helping CFOs obtain more clear, accurate and timely information about their business. James says these innovations have been fantastic for finance teams.

“The industry is changing for the better as technology evolves,” she says. “Digital tools are leading to the more routine tasks such as data inputting and compliance becoming redundant. This means accountants can focus more on providing strategic advice.”

James adds a report can tell CFOs how and when money has been earned, and eventually how much tax is needed to be paid.

“Accountants can help finance chiefs to not only expand and grow their business, but to create a sustainable income,” James says. “And spreadsheets are one tool that continues to help all firms future-proof their business.”

 

Twitter Icon
Facebook Icon
LinkedIn Icon
Want to Dig Deeper?

Get an American Express Card

  • Personal Cards
  • Credit Cards
  • Small Business Cards
  • Corporate Cards
  • Add Someone to Your Account

More Products & Services

  • Insurance
  • Accept the Card
  • Online Services
  • Book Travel
  • Business International Payments
  • Refer a Friend

Important Links

  • Frequently Asked Questions
  • Chip & PIN
  • ATM Locator
  • Accessibility
  • Safe and Secure

Company Information

  • About American Express
  • About American Express Australia
  • Careers
  • Contact Us
  • Site Map
  • Facebook
    • Personal Cards
    • Credit Cards
    • Small Business Cards
    • Corporate Cards
    • Add Someone to Your Account
    • Insurance
    • Accept the Card
    • Online Services
    • Book Travel
    • Business International Payments
    • Refer a Friend
    • Frequently Asked Questions
    • Chip & PIN
    • ATM Locator
    • Accessibility
    • Safe and Secure
    • About American Express
    • About American Express Australia
    • Careers
    • Contact Us
    • Site Map
    • Facebook

American Express
AustraliaChange Country
  • Connect with Amex on Facebook
  • Connect with Amex on Instagram
  • Tweet your questions to @AskAmex
  • Connect with Amex on LinkedIn
  • YouTube

  • Website Rules and Regulations
  • Trademarks
  • Privacy Statement
  • Security Alerts

Copyright © 2021 American Express Company