Accounting technology news and resources

TOPICS

March 16, 2023

Cultivating tech talent: A CPA firm leader’s elementary approach

The CEO of a top 100 CPA firm shares more about her unconventional journey to becoming a CPA and why she seeks out unconventional talent in this podcast episode with transcript.

March 15, 2023

SEC proposals target cybersecurity

Proposals would expand who must report on cybersecurity and data breaches, as well as what they must report.

March 15, 2023

3 trends that will reshape accounting and finance in 2023

The chief accounting officer of Workday shares on technology and talent strategy, zero-day close, and accounting’s role in driving value creation.

March 8, 2023

How to increase your students’ digital acumen

Prepare students to make a bigger impact through technology.

March 1, 2023

Improve audit sampling efficiency with Excel’s Solver tool

Artificial intelligence capability can significantly reduce the time and effort auditors devote to sampling estimation tasks.

March 1, 2023

Quick Excel tips for accountants

This article offers a few quick Excel tips for varying levels of proficiency.

March 1, 2023

Outlook flags and rules

This article discusses two simple tools available in Outlook desktop and Outlook online.

February 3, 2023

Digital assets in danger: How to guard against hackers

An expert on cybersecurity details the current threat landscape related to digital assets and shares advice on protecting digital assets in this podcast episode with transcript.

February 1, 2023

Convert dates using Arabic numerals to dates with Roman numerals

If you have several dates written with Arabic numerals, there are steps to convert them all to Roman numerals.

February 1, 2023

From numbers to narrative: How CPAs can tell stories with data

Become a better adviser to colleagues and clients by strengthening your data storytelling skills.

February 1, 2023

Update AutoRecover setting in Microsoft Excel

By default, AutoRecover is set to save every 10 minutes, but you can set it to save more often.

January 30, 2023

Using ChatGPT with Excel

This month’s column explains how the new AI tool known as ChatGPT can help with challenging Excel tasks such as creating PivotTables and writing macros.

January 11, 2023

How COVID-19 changed the way we teach

The COVID-19 pandemic forced colleges and universities to embrace the digital age. Accounting faculty members reflect on adapting to the changes, both positive and negative.

January 1, 2023

Calculating double-declining balance depreciation for tax purposes in Excel

Variable-declining balance uses the double-declining factor but also initiates the automatic switch to straight-line depreciation once that is greater than double-declining.

January 1, 2023

Aliases and shared mailboxes

Having second email addresses and shared emails can be useful tools to manage the flow of emails.

December 20, 2022

5 ways firms can use technology to transform audits

Technology has been transforming audits for years, and that trend will only accelerate with the Statement on Auditing Standards (SAS) No. 142, Audit Evidence, which took effect on Dec. 15, 2022.

December 8, 2022

The CPA’s guide to technology (and tech gifts)

Inspector Gadget, aka David Cieslak, is the guest on this podcast episode, which focuses on cybersecurity and CPA-centric holiday gifts.

December 1, 2022

Use Mail Merge to send bulk emails

Mail Merge can be an option for sending bulk emails to a small, specific group or for those who need a simpler tool than bulk email software.

December 1, 2022

Automatically create subtotals in Excel

There are several reasons to use SUBTOTAL instead of SUM when inserting subtotals in your spreadsheet.

December 1, 2022

Automatically color-code cells in Microsoft Excel

You can automatically have cells turn certain
colors based on the text within those cells. This
is easily done using one of the many types of
conditional formatting.

FROM THIS MONTH'S ISSUE

AI risks CPAs should know

Are you ready for the AI revolution in accounting? This JofA Technology Q&A article explores the top risks CPAs face—from hallucinations to deepfakes—and ways to mitigate them.