Accounting technology news and resources

TOPICS

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.

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