Accounting technology news and resources

TOPICS

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.

December 1, 2022

Using Power BI for advanced QuickBooks data analytics

Try these two ways of analyzing and reporting QuickBooks Online data using Microsoft’s Power BI Desktop Version.

November 30, 2022

Audit committee disclosures increase, right along with workload

A Center for Audit Quality report reveals an increase in public company audit committee disclosures, particularly related to cybersecurity, while an accompanying report aims to help audit committees manage their growing list of responsibilities.

November 1, 2022

Using Advanced Filter in Excel

Learn how to filter data using wild cards and other complex criteria using Advanced Filter in Excel.

November 1, 2022

How to compare documents

Learn how to find changes to a Word document when Track Changes wasn’t turned on.

October 27, 2022

Q&A: The 2 most prevalent cyberthreats for CPA firms

The co-author of the JofA’s Professional Liability Spotlight column discusses common strategies used by cybercriminals and how they can be mitigated.

October 1, 2022

What CPAs need to know about NFTs

NFTs are unique, immutable, and auditable records of the ownership of both physical and digital assets.

October 1, 2022

Using COUNTIF and COUNTIFS in Excel

COUNTIF is used to count items based on one criterion, while COUNTIFS is used to count items based on multiple criteria.

September 1, 2022

Efficient ways to open Microsoft Excel

There are a couple of ways to have Excel open most conveniently for you.

September 1, 2022

Using Benford’s Law to reveal journal entry irregularities

Benford’s Law can help uncover indicators of fraud — and anomalies that arise from legitimate business practices.

September 1, 2022

Cybersecurity risk: Constant vigilance required

These tips can help diminish the likelihood and
impact of a cyberattack.

September 1, 2022

Smart Lookup in Microsoft Excel

You can quickly look up text from your Excel spreadsheets from several online sources.

September 1, 2022

Increase time increments by minutes in Excel

You can incrementally increase times for your agenda by a certain number of minutes.

August 30, 2022

Advice from an expert on cyber insurance coverage

Cybersecurity specialist Mike Foster shares common questions that insurance companies might ask when your company is applying for cyber insurance coverage and advice on how to address them.

August 25, 2022

The payoffs of RPA for one accounting firm

How can organizations and firms evaluate whether robotic process automation (RPA) is right for a project? First, they must know what RPA is and isn’t, and the pain points they are trying to address. An expert shares knowledge on the topic in this podcast episode with transcript.

August 23, 2022

The heavier lifting that technology can accomplish for CPAs

Podcast guest and technology expert David Cieslak shares why automation should be embraced by finance professionals and explains how he became known as “Inspector Gadget.”

FROM THIS MONTH'S ISSUE

Start in high school to strengthen the accounting profession

A practitioner-led outreach program, born of a university, accounting professionals, and local community collaboration, shows how to successfully engage high school students with the modern accounting profession.