How You Can Make $100,000 This Month

Get the template here (Click File then Make a Copy or Download As):

How You Can Make $100,000 This Month Demo

Approached from the perspective of a true accounting nerd. You make $100,000 by selling a product for a specific value in sufficient quantity to generate the sales you need to make $100,000 this month.

Before you run away thinking “tell me something I don’t know” because THAT is the whole problem!

You know it.

But you don’t do anything about it.

So here’s what you can do about it.

You create a plan.

The plan is where you take a look at what you offer and what you charge. And STOP just thinking about it. Set it down on paper or in a spreadsheet (like I am going to show you in the video above).

You have to have a concrete plan.

Abstract thoughts do not convert to dollars. Concrete plans do.

If you want to make $100,000 per month the first thing you have to do is think you can.

Everyone commenting in this thread is a dear friend but their comments all suggest that they are thinking they can’t. Even when my good friend Laura says, “with the right…” That’s a qualifier. Now she is closed off to the idea of success “until” she can get that. How many memes do we need to see before we get that we can’t spend our lives waiting for something to happen to us?

It’s simpler than that. Just say, “I can!” Let it it make you feel uncomfortable. It should.

If you want to push past new limits then you will need to get out of your comfort zone.

You will need to learn new things.

In order to know what new things to learn, you will need a plan.

Watch my video to see what this looks like.

Then if you want to see another video on how you can begin to build a strategy for getting the traffic you need, to generate those sales, check my last post called, “100 Clicks Per Day.”

Interested in one of the products I mentioned in the video?

Become a Content Creation Machine
The Accounting Mosaic – A Complete Picture of the Skills and Apps You Need (Pre-sell coupon code is PREMOSAIC)
5 Hour Support Plan
97 & Up (Try for $1 for 7 days right now)

Import csv Files Directly Into Google Sheets

You may know by now that one area we specialize in at Nerd Enterprises, Inc. is eCommerce. Our systems are built around extreme error free efficiency. This means importing a csv file containing all of the sales and fees into a spreadsheet. We have all of our processes in the cloud. Accordingly, we wanted to move away from Microsoft Excel and into Google Sheets. This meant we would need to import csv files directly into Google Sheets.

Amazon is the most popular place on the planet to sell online.

So we’ve created systems around getting the biweekly Amazon settlement reports to reconcile from gross sales to the net deposit. And we wanted it done fast. Like in minutes. The problem with import or sync tools is they tend to generate errors that can take lots of time with support and otherwise to fix. I want a system that works always. Mine does.

I’ve created a template the lets us drop the biweekly Amazon settlement report, and it instantly breaks it down from the gross sales to the net deposit with all of the fees and holds categorized in between.

If you are just going by the summary that Amazon gives you without using the download, you are missing a ton of important details.

Once I figured out how to import csv files directly into Google Sheets, it meant I could finally manage this entire process in Google Drive. No more Microsoft Excel!

This also makes it much easier to collaborate with Erica (my Chief Operating Nerd), because Google Sheets is much easier to collaborate in vs Excel.

Watch the video to see a demonstration of the process for how to import csv files directly into Google Sheets. See how this helps us turn hours into minutes, with everything done the right way – including all of the details.

How to Create a Cash Flow Forecast and Map

Cash Flow Forecast

Everyone needs a cash flow forecast.

I don’t think I’ve ever worked with a client who didn’t, at some point if not right away tell me they needed a better idea of their cash flows.

I’ve had these struggles myself. That’s why I developed my Nerd’s Cash Flow Projections model and product.

Many clients have asked me for something more immediate. My cash flow projections give you a monthly overview of everything.

What if you need a closer look at what is happening this week?

I realized people need a cash flow map.

This is something that lays it out daily. Seem like overkill? It isn’t. The trick was to build something dynamic, so that most of the work is done for you.

I was recently blind sided myself, when I thought I knew exactly what we coming in and out, and then something I overlooked came out, and spun me for a loop. It comes out every month, but I had completely overlooked it. Now where I thought I had exactly enough money, I was overdrawn, and I had to go pull money to cover it. I don’t like pulling money, so I asked myself,

“How can I make sure this never happens again?”

A cash flow map was my answer.

I started by listing the numbers 1-31 across in a Spreadsheet (Google Sheets).

Most of my income comes in monthly on a schedule, so I started plotting out my daily inflows. The I have things like one to one training revenues. That isn’t as predictable, but I was able to run a report to get a sense of my average monthly revenues in this area, as well as a view of how it rolled it throughout the month. Then I decided to plot that in specifically, because I know whom I’ve been talking to about those services.

The bottom line on this is that you may have to come up with some assumptions about what comes in and when, but most of us have a pretty good idea of how our inflows run.

Expenses are easy. Generally you know exactly what comes in and when. To be sure I didn’t miss anything I went into QuickBooks Online, and ran a P&L for last month. Then I grouped it by week. Then I clicked on the totals to see and then plot out what comes out and when.

In about 20 minutes, I had it all plotted out.

Then I went to work to make the spreadsheet dynamic:

  • I wanted to see the weekdays.
  • I wanted today to light up.
  • I wanted to be able to put in my bank balance as of today, and have the model calculate my cash flow and ending balance each day from today until the end of the month.

I did it. Then I saved it as a template, which you can now purchase in my online store.

Watch the video above to see how it works.

Get the template:


Accounting for Startups – Creating Reports in Google Sheets

Over the past few weeks, I’ve been showing you how, as a startup, you can develop a system for keeping track of your accounting, that costs you absolutely nothing. Every good accounting system provides for you to input data, for one ultimate purpose – to get data out of the system. Simply put, this is your “reports” area.

In this video I took a bunch of sample data from a sample QuickBooks desktop company file, and populated it into my template. Now we’re going to see how we can run some reports in Google Sheets, using Pivot Tables. Don’t let the pivot tables scare you. I am going to show you how easy, they actually are, to create and manage!

Think about the columns in the “register.” Now imagine being able to decide, which columns you want as your rows, and which, as your columns, so you can analyze the data. You want to see your expenses, as the rows, and the months as the columns? We can do that. Then we can further sub-divide the columns by year. Next we can add the names as a row underneath each expense, so we can see expenses by vendor in the report. You can’t get reporting this powerful in any accounting system I’ve used, and I’ve used many!

Watch the video to see what this looks like.

After you are comfortable with how Google Sheets can be set up, you may want to consider a 1:1 session with me to help get you set up.

Then, when you think you have the budget to spring for the accounting software, we’ll take a look next an Accounting for Startups, using QuickBooks Online.

Want this template? Get it here: