Welcome To Our Official Blog:

Nerd's Guide to the Galaxy

 
A KPI YOU CAN REALLY USE bulletproof cfo google sheets kpis Feb 24, 2023

If you LOVE this then you will definitely want to look at my Google Sheets Deep Dive!

Bring in more sales and control expenses. That’s what most KPIs that most people look at will translate into when you analyze them. And the reason for that is that most businesses who are seeking help...

Continue Reading...
 
QuickBooks Online and Returned Customer Payments clearing accounts nsf quickbooks online returned deposited items Feb 20, 2023

Let’s say you invoice a customer for services and, even though it’s 2023 and there are much faster and more secure ways to pay, your customer pays you with a good old fashioned check!



This means you deposited the check and the funds were credited to your account, and some time later...

Continue Reading...
 
The Difference Between What I Can and Can’t Control nntap Feb 17, 2023

Nerd's Notes To Accounting Professionals



So you’re working on a client. You’ve set aside the time and the client promised you they would upload all of the statements and documents you need. You counted on that when you scheduled the time to work
for this client. 

 

But the...

Continue Reading...
 
Ask Nerd - Volume 1 ask nerd Feb 14, 2023

Get the sexiest notes in the Galaxy

for all of the resources mentioned:
Ask Nerd Vol 1. Show Notes

 

 

Continue Reading...
 
Genius Sheets - How Fast Is Your Business Going? dashboard genius sheets google sheets kpi tools quickbooks online Feb 06, 2023

And how much gas is in the tank?

 

Overdrive

 

You know I have never been a fan of any of the so-called “KPI” (Key Performance Indicator) or “Dashboard” tools out there. They are either very limited or very difficult to use. 

 

But when Trevor Lee...

Continue Reading...
 
The Curious Uses of Clearing Accounts With QuickBooks Online clearing accounts ecommerce quickbooks online webinar Jan 28, 2023

It’s a good day for a clearing account! Or so the expression goes!

 

Or doesn’t it?

 

I created this video many moons ago to make it easy for me when I had to explain The Undeposited Funds account. 

 

But the undeposited funds account was always a bit limiting....

Continue Reading...
 
Back Up Client History From QuickBooks Online To Airtable airtable quickbooks online Jan 27, 2023

It comes up a lot. A client wants to upgrade from QuickBooks Desktop to QBO. My suggestion is always to start a new, clean company and NOT migrate the data. Some clients like the idea, but the ones who hesitate are usually most hesitant because they want a way to access customer history. 

...

Continue Reading...
 
Should You Stay or Should You Go Re LastPass? Jan 25, 2023

Last year as I was planning on putting together this Guide To The Galaxy resource, I was thinking about what would make this resource really valuable. 

 

As someone who LOVES playing with a myriad of productivity apps, I thought it would be useful to write some content that showed you a...

Continue Reading...
 
How To Create Your Own AI Based Accounting System with ChatGPT accounting technology chatgpt Jan 23, 2023

At the end of 2022 OpenAI released ChatGPT, the latest iteration of AI software and one that has now taken the internet by storm. Some are going as far as to say this (or something like it) will replace or become Google.

 

Check out my Guide To The Galaxy Podcast Episode:

Is ChatGPT the...

Continue Reading...
 
If You Mix Up Personal And Business Expenses In QuickBooks Online accounting and bookkeeping expense reimbursements personal expenses quickbooks online Dec 31, 2022

If You Mix Up Personal And Business Expenses In QuickBooks Online

This can go two ways:

  • Pay for a business expense with personal means (better)
  • Pay for a personal expense with business means (commingling)

The bottom line is that it's bad to commingle personal and business funds.

I hope it never...

Continue Reading...
 
Discord vs Slack - Why I am Switching to Discord Dec 12, 2022

Slack was purchased by Sales Force on July 21, 2021. I remember being in some Facebook groups at the time, and people worrying about how this would impact them, since they were using it (many at my suggestion) for all of their clients.

The question as always after an Acquisition like this is what...

Continue Reading...
 
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...

Continue Reading...

Check Out  Our Flagship Mastermind Group and Trainings...