101 Bloggers Bookkeeping

Bloggers bookkeeping basics

One of the main foundations (pillars) of building a business is the finance, also known as bookkeeping. In our case Bloggers Bookkeeping.

Cruising around the online world I have met some friends who are dubious as to whether or not they can organize and control their own bookkeeping.

We Blogger’s are adept at learning, so why not take this one step further to enhance your blog business and keep track and trace, of your hard earned cash.

This really is not a big deal, so keep it simple (KISS).

A – Accept this is your Accounting System and it does not have to be onerous.
B – Banking, keep a Beady Eye out for all movements on your statement.
C – Carefully Clip Receipts to Bank Statements – Proof of Payments and Proof of Receipt of Payment.
D – Don’t pay out Money online before checking the safety factor.
E – Efficient and Easy Method to keep up to-date.
F – Finance, knowledge of your Income and Expenditure, the building blocks of Business.
G – Get an Easy System Setup.
H – Help is Always Available=F1.
I – Ignorance can Cost.
J – Jokers get burned
K – Killer Fraudsters are out; Keep Your System Updated against Spyware and Malware.
L – Learning and Discipline are essential.
M – Maintenance of Bank Accounts and Filing given structure to makes life easy.

Hey I’m not doing the ABC – it is the 123 that we need to get into! Bloggers Bookkeeping, many are saying how?

Where to start?  http://www.openoffice.org/  This is freeware if you don’t have Microsoft Office or Lotus Smart Suite.

Plan the Categories for your Tabs. I work with Microsoft Excel, I have worked in Lotus 1-2-3 and have found Spreadsheets work almost identical. Take one step at a time, and in no time at all you will be up and running.

Before doing anything open the Spreadsheet and give the file a name. Do a “Save As”, usually a default name such as “Book1.xxx” will open. Alter and name your Spreadsheet, then save it in a folder of your choice such as “Banking”. Please remember to hit the save button every couple of minutes, that way you won’t lose information.

OK back to Categories, We are creating a simple Spreadsheet with five columns. When we open a Spreadsheet, along the top of the table is ABC→ (LOL) – down the side cell lines numbered 123↓. We will build a Date, Description, Debit, Credit and Total as “Categories”.

On the Top – Cells (ABC)- hover your cursor over the cell “A” on the right hand side of the box, ↔ symbol shows “click and drag” this will expand the cells to make them larger or smaller.

Keep it simple to start, make a “Description” Tab in Cell “A” of about 25 – 35.
You can use the above method or Right Click in Cell “A”, a drop down menu will appear, go to “Column Width” and type in the size i.e. 35, and click the OK button.

For Cell “B” – “C” and “D” we will be using numbers, repeat the above, I have found the size for the Cell of 12 is sufficient (remember you can adjust at any time). So run your browser over B-C-D, right click, go to “Column Width” and put in the number 12 then click OK.

We want to add a Date field to our Categories before the Description (you can add or delete columns as you wish).  Right Click in “A” Column for the drop down menu, click on “Insert” and another cell “A” will pop up,  the previous “A” column, will become “B”.

Now in like manner we can edit the cells, “A” is going to be the date; right click in the box “A” for the drop down menu, select “Format Cells”  – the Tab Section is “Number” with a variety of choices, since we wish to have a date, select the style of date and click OK.

(While we are here, there a more tabs available to explore, Right Click in a Cell>Drop Down Menu>Format Cells> “Number” or  “Alignment” “Font” “Border” “Fill” and “Protection”.)

“B” = As above right click in the tab “B” select “Format Cells” then  “Number” and select “General”.

“C-D+E” Cells are all for currency. Drag your cursor over the three columns this will highlight them, right click for drop down menu “Format Cells” > “Number” > “Currency”. Choose how many decimal places you wish to use and the Currency of your choice. At this point you can also select a minus (-) for credits to reflect in red or black print. Making the Credit Column a minus helps with formulae further down.

You have a spreadsheet basically set up, in line 1 you can input your Headings – Date (A), Description (B), Debit (money coming in) (C); Credit (outgoing cash) (D) and your Balance/Total (E).

∑Symbols may be used=Automatically Adds; Click in the Empty Cell at the bottom of a column, use this symbol and highlight the numbers above.

If you use a “running” total – For example: in line 2 “Total” in column “E”, you can input your bank balance. Line 3 will reflect your first payment out, so in line 3 column “E” write a simple formulae of =(E2+C3+D3) which will calculate the balance automatically. We did not use the (-) minus sign in the set up for column “D” – formulae will be =(E2+C3-D3).  Copy and paste (Ctrl-C on cell with formulae, then highlight column below and Ctrl-V) this saves time. Any hassles, check F1=Help, we may require a tweak =SUM(E2+C3+D3) or @SUM or we may be required to put “0.00” value in blank cells!

Congratulations you have set up a simple spreadsheet, have you enjoyed how to do simple bit of bloggers bookkeeping to keep your head above water.


Thought for  Today:   “The individual who know the score about life sees difficulties as opportunities.” Norman Vincent Peale

Please follow and like us:
Follow by Email2k

17 comments to 101 Bloggers Bookkeeping

  • beautiful monster lyrics

    Thanks for sharing, I found this story while surfing for free lyrics, thoughtful comments and good points made.

  • picture used in Blogger HTML layout (for Blog design purposes) PICTURES IN POSTS Uploaded pictures HAVE to be stored (hosted) somewhere.

    • Yes for blog purposes I use Hostgator. Spreadsheet and analysis, Microsoft Excel which I save to my own computer. Thanks for your input. BTW your site has a lot to offer, will keep it in mind.

  • Panda Internet Security

    howdy there, i just found your site via google, and i must comment that you express pretty well via your web portal. i am truly moved by the method that you express yourself, and the content is good. anyhow, i would also like to know whether you would like to exchange links with my blog? i will be more than willing to reciprocate and insert your link on in the blogroll. waiting for your response, thanks and enjoy your day!

    • Thanks for your kind words and invite to exchange links, I will respond in the near future once I have completed article writing.

  • seobpo

    Nice post and nice site.. well worth the read thanx!

  • conservation biology

    I don’t usually post but I enjoyed your blog a lot,Thanks alot for the great read

  • Realy nice post. I have found your blog about google and will visite it regulary.

  • e-cigarette

    Interesting take on this issue. I for one have seen many twists on this and can often spot the holes in the arguement however, on this occasion I belelive your writing is such that everyone should be in agreement with this. Thank you for sharing it with us.

  • Hi Eddie, Yes I have planned more on blog bookkeeping, this will roll out over the next couple of months, so stay tuned! Thanks for dropping a line, keep contact if you have questions.

  • Michael

    Hi Joan, It makes a change to see some information on bookkeeping that covers a good range of topics that are useful for a blogger. As you say, it is an area that tends to be ignored, and can cause significant problems down the road, if not taken care of.

    I look forward to reading your future posts.


    • Hi Mike, Love your site and yes I will be taking bookkeeping a few steps further to assist others online, brick and mortar of a business, we all love to overlook.

  • Tietjens

    Very informative post. I’ve found your blog via Bing and I’m really glad about the information you provide in your posts.

    • Thanks, glad to hear you are enjoying the posts and there will be more to come on this subject. Look forward to hearing your comments.

  • Grothen

    You you could edit the post subject title 101 Bloggers Bookkeeping — Blog Biz Buzz to more catching for your blog post you create. I liked the blog post still.

  • Hello Anjanette,

    I have worked on organic results from search engines and keep promoting what I feel will assist others to create useful blogs.

    At the moment I am concentrating on List Building and would love people to sign up for the free book that I have used to clear up some problems understanding the set up.

    In the near future I will return to my bookkeeping since it appears there I will be able to help people with basic bookkeeping online.

    Thank you for your kind comments and look forward to hearing from you again soon.

  • Hi Alida,

    Great to be able to share and thank you for leaving a message. Please if you have any questions or suggestions as to what content you would like to see more of let me know.

Leave a Reply




You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>