Tuesday, September 29, 2015

Maths Idiot X No Worries: Simple Accounting for a Freelancer

apparently as a person who

totally sucks at Mathematics

keeping a simple account is still a must


as a freelancer

you gonna manage everything

and that of course including your finance


1. Project Summary Sheets

which I updated whenever I obtained a task

the most basic yet important of all


to keep track of everything from

amount, date of project, payment status

basically everything is under control


I have one sheet for each and every major clients

since for the major clients

I have to send monthly invoice

therefore it’s better to split them 

and a sheet named OTHERS for the rest

which goes this way


Project Description

P.O. No
(if any)

Word Count


Invoice Status




the table is updated from time to time

based on availability of information

eg: some clients send their purchase order

from their sides much later

after the project is confirmed


approaching the end of the month

when it comes to issuing an invoice

will refer to this sheet for keywords

and search it in my mailbox to

to reconfirm the details such as

date, P.O. number

before the invoice is sent out


this project summary sheet is

definitely so important as

some clients actually

do not issue a P.O. from their side

so it’s basically

all up to you to keep track


at times

whenever I need to refer to

previously completed project

this would be my guide too

just to track back

when was it completed


2. Sales Performance sheet

from the project summary

I generate a simple sales performance sheet

which I just did


to keep track of monthly sales

the performance trend etc


it goes this way

everything in [] is basically auto-generated

from the SUM function available in Excel

and the additional AVERAGE function at the bottom


Client 01

Client 02

Client 03



Jan         [Monthly Total]
Feb         [Monthly Total]
Mar         [Monthly Total]
Apr         [Monthly Total]
Total [Total/
[Annual Total]


3. ……

still figuring out

probably a balance sheet of

income vs expenditure



thanks to my 6-month part-time job as

an admin with a noodle wholesaler

updating accounts for respective customers

were part and parcel of my daily routine

pay was definitely meager


but the skill picked up

stick for the rest of my life


No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...