Manage your Cashflow with Google Sheet

I have been using Google Sheet to manage my freelancer cashflow from 2013, and I use to squeeze every year in one Google Sheet; every sheet represents a year until 2018. The amount of transaction is getting more and I going to start a new company, so I switch into 1 Google Sheet for every year.

The screenshot shows how I manage all the deals/invoices and transaction-related follow up actions. Each column represent data that I need to know for example

• Month: So that I can compare where the month that be quiet and what is the month I might need more resources.
• Company: Which client is this.
• Invoice: The invoice number.
• Project: What Project I m working on
• Sales: How much total amount of the project
• Upcoming: After the initial 50% how much more is pending
• Invoiced: The invoiced amount normally will invoice 50% before the project started
• Paid: How much does the client pay already.

On the most right-hand side, there is some summary column for me to check. How many sales did I meet, how far is it compare to my quarter target / annual target? Through the summary column, I can tell very fast how much more money are pending with clients, do I have any income next month etc.

Just thought of sharing this to fellows who start their freelance career.