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 šŸ‘‡
nerdyurl.com/Google-Sheets

 


 

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!

READY FOR BLAST OFF?

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: