Welcome To Our Official Blog -

Nerd's Guide to the Galaxy

Google Sheets Checkboxes - Create Useful Accounting Workpapers

accounting and bookkeeping google sheets workpapers Nov 26, 2022

If you love this tip,

👇 you're going to love my Google Sheets Deep Dive 👇



One thing I am promising for 2023 is more content on how to keep really good workpapers to support your calculations that are ultimately used in preparing the bookkeeping for your clients. 


Google Sheets Checkboxes are a really slick way to illustrate what is or isn't included in a calculation, especially when you configure them so that checking the checkbox includes a number in that calculation while unchecking it excludes it. 

This is practical while you are preparing the workpaper, and then practical by way of memorializing how you arrived at the calculation.


ProTip: Lock up your sheet once you are done so on one can alter the checkboxes and resulting calculation!


Hop On 'Nerd's Guide to the Galaxy' and Experience the Ultimate in FREE Coaching, Resources and Training...


  • Live workshops, trainings and recordings
  • An intimate community of like-minded people
  • A FREE course (and you choose your interest)
  • Preferred access to my inner circle
  • A Free subscription to my newsletter "Nerd's Words"
  • Blog Post Notifications
  • And MUCH MORE!

We hate SPAM. We will never sell your information, for any reason.

Check Out Some of Our Best Selling Training Courses Below: