SOP
  • Standard Operating Procedure
  • Introduction
  • Notes & Todos
  • Changelog
  • The Company
    • Culture
      • Management
      • Mäd Friday
      • Core Values
      • Principles
      • The Mäd Flywheel
      • Team Handbook
      • Blogs & Websites Worth Reading
      • Required & Recommended Reading
      • Recommended Videos
    • The Mäd Brand
      • Our Golden Circle
      • Brand Assets
      • Mäd.com
      • why.workwithmad.com
      • Writing Case Studies
    • Transparency
  • Project Work
    • General Working Practices
      • The Project Brief
      • AAR - After Action Review
      • New Client Onboarding
      • Status Updates
      • Files & Backups
    • Design Working Practices
      • Website Go-Live Checklist
      • Resources.
      • Brand and Web Design Sprint Agenda
      • Key Design Team Roles
      • Ideation and Brainstorming
      • Design Thinking
      • Questions for Flows
      • Webflow Hosting
      • Corporate Website Go-Live Checklist
      • Setting Up an App Store Account
      • Domain Pointing and IP Addresses
      • Writing Specifications
      • Bug Reporting Template
    • Tools
  • Operations
    • People Operations
      • Open Positions
      • Employment Contract
      • Key Documents
      • Hiring
      • Hiring Process
      • Hiring FAQ
      • On-boarding
      • Probation
      • Health and Accident Insurance
      • One to Ones
      • Off-boarding
      • Resignations
      • Salary Scale
      • Salary Increases
      • Holidays
      • Benefits
      • Business Visas
      • Reviews and Performance
      • Parental Leave
    • Finance
      • Procurement Onboarding
      • New Client Financial Details
      • Reports
      • Using Company Money (Expenses)
      • Bank Accounts
      • Free Cash Flow
    • Legal
      • Our Law Firm
      • Legal Entities
      • Document Templates
      • Non-Disclosure Agreement (NDA)
      • Service Level Agreement (SLA)
      • Engagement Agreement
    • Sales
      • Newsletter Format
      • Scope of Work
      • Minimum Project Price
      • Non-Negotiable Contractual Points
      • Credentials Deck
      • Proposal Format
      • Qualifying Prospects
      • CRM
Powered by GitBook
On this page
  • Reports
  • 1. Accrual Basis P&L Report
  • 2. Free Cash Flow Report
  • 3. Free Cash Flow Projection Report
  1. Operations
  2. Finance

Reports

Reports

We have two key reporting tools that we use:

  • Wave, a cloud-based accounting system that we use to keep track of sales and related costs, and view our P/L on an accrual and basis and run various reports.

  • A Google Sheet called “Free Cash Flow Financial Projections” where we track FCF (Free Cash Flow) by doing cash basis accounting.

1. Accrual Basis P&L Report

In Wave, we do our accounting on an accrual basis. Under the accrual basis of accounting, expenses are matched with the related revenues and/or are reported when the expense occurs, not when the cash is paid. The result of accrual accounting is an income statement that better measures the profitability of Mäd during a specific time period.

This is fully updated every two weeks.

2. Free Cash Flow Report

Free Cash Flow (FCF) is one way to measure a company’s financial performance.

It is calculated by taking Operating Cash Flow (Income – All Costs) and removing Capital Expenditures as they happen (not with depreciation).

FCF represents the cash that Mäd is able to generate after spending the money required to maintain or expand our assets. The interesting thing about FCF is that it actually grow even if we have months/quarters that show a negative P/L, as it measures the overall effectiveness of our business model vs our sales cycle.

A high FCF is important because it allows Mäd to pursue opportunities that enhance shareholder value. This means aggressively and proactively reinvesting future known profits back into the company to bolster future growth. For Mäd, this will especially mean a large investment in branding, employee training and development, and the highest quality equipment possible.

However, because we cannot grow Mäd with profit, but we need actual cold hard cash (who doesn’t!), we then use Google Sheets to track the amount of cash that we actually generate from our operations during a given time frame. Unlike in accrual accounting, on this sheet, we also track capital expenditure to ensure that we understand the implications of making large hardware orders as we scale.

Our calculation for FCF is the following:

(Invoices Paid + Other Income) – (Cost of Goods Sold + Operating Costs + Capital Expenditure) = Net Free Cash Flow

For tracking sales, we have one line for each customer, and the total cash received by the customer that month is entered as a sale. If there are multiple invoices, add the total of the invoices as the amount, and add a comment to the cell, giving a breakdown of the invoice details.

The final results will be the tracking of the following:

  • Monthly Income

  • Total Historical Income

  • Monthly Expenses

  • Total Historical Expenses

  • Net Monthly Free Cash Flow

  • Total Historical Free Cash Flow

  • Free Cash Flow Margin

This is updated in real time as soon as new information (sales, costs) come in. There is a level of approximation for variable costs such as servers, where we don’t know the precise amount upfront, these can be estimated.

3. Free Cash Flow Projection Report

This is done by cloning report #2 (Free Cash Flow Report) and adding the projected payment date for potential sales, and the requirements for hiring, hardware purchased, and any additional project costs.

Updated every two weeks.

Last updated 4 years ago