In this guide, I explain how I use Excel Power Query to automate bookkeeping tasks for QuickBooks Desktop. This method is not perfect but saves a lot of time. Below, I will share how I transform raw bank transaction data into a batch transaction data format that QuickBooks Desktop can import. I. When we have…
Organizing Stock Documents for Form 8949 Using Google Colab During income tax season, one of the most time-consuming tasks is organizing stock-related documents provided by clients. Some clients may have over five stock accounts for both spouses, and others may have a single account with a high volume of transactions. From these stock documents, the…
Splitting a Single Page into Three Pages Using Google Colab In January, many businesses file 1099 forms. The payroll program we use generates 1099 forms with three forms printed on a single page, like the image on the left below. However, when emailing these forms to individual contractors, each form must be separated into its…
In a CPA firm, one of the most repetitive monthly tasks is reaching out to clients to request sales information, share sales tax calculations, and inquire about payroll details. When done manually, these tasks can take up valuable time. With Bulk Texter Pro, you can automate all these processes and communicate effectively with your clients…
As we approach the 2024 income tax season, it’s essential to streamline communication with clients. To ensure all necessary information is collected in a timely manner, I’m planning to send personalized emails tailored to each client’s needs. Here’s how the process is set up: 1. Organize Client Data in Google Sheets The email will be…
As part of compliance with the Beneficial Ownership Information (BOI) reporting requirements, I recently sent out notification emails to our clients. Preparing the Email List The initial step was to organize the data in an Excel file. This file contained essential information, including names and email addresses associated with the 2023 income tax filings. Since…
This post includes the Google Sheets interface and Apps Script code discussed in the YouTube video. For detailed explanations on how to use Apps Script and other specifics, please refer to the YouTube video below. By setting up triggers, you can automate the execution of Apps Script code to update Google Sheets or send emails…
This post includes the Google Sheets interface and Apps Script code discussed in the YouTube video. For detailed explanations on how to use Apps Script and other specifics, please refer to the YouTube video below. Attachment files should be uploaded to Google Drive, and their shareable links must be obtained to use them in Apps…
This post includes the Google Sheets interface and Apps Script code discussed in the YouTube video. For detailed explanations on how to use Apps Script and other specifics, please refer to the YouTube video below. Attachment files should be uploaded to Google Drive, and their shareable links must be obtained to use them in Apps…
This post includes the Google Sheets interface and Apps Script code discussed in the YouTube video. For detailed explanations on how to use Apps Script and other specifics, please refer to the YouTube video below. You can create more visually engaging email content by using HTML. Google Sheet Create Columns. Each column will contain the…
This post includes the Google Sheets interface and Apps Script code discussed in the YouTube video. For detailed explanations on how to use Apps Script and other specifics, please refer to the YouTube video below. Google Sheet Each column will contain the information needed to send the emails. For example, you may have columns like…
