[EXCEL HEAVEN VIDEO] Part 5 – How I Built My Automated Cash Book/Bank Reconciliation Software” [Inserting AMOUNT TOTAL Formulas to Add Cost Center Entries In EXPENSE SECTION of the Imprest Cash Book]

I couldn’t broadcast this tutorial last week to Excel Heaven club members due to the crazy connectivity crisis I had to battle with…Even now, I am proceeding with caution in using the “alternative” platform I’ve adopted for doing my online work lol!

Below are excerpts from the email I just sent to club members. Click here to request a copy of the step-by-step video and example workbook I used…

The following files are to be used for your review of this week’s tutorial:
[1[ Step by Step screenshot video tutorial – this was emailed to you via pCloud Transfer BEFORE this broadcast. See your email inbox.
Here’s a brief transcript excerpt from the video.

Let me know if you need any help replicating or putting the demonstrated concepts into use,

So, this is the expense section of the cash book. Remember 2 weeks ago, we insert the columnn (cost center) headings from the settings table into the expense table header row using the TRANSPOSE function – you can see it in the formula bar, in an array formula of sorts.

Now we’re going to put in formulas into the (cells in then) AMOUNT column, then freeze it in a way that enables us post values under ANY of the expense heads, along the row to the right, while being able to view the totals adding up for that Payment (Or Petty Cash) Voucher entry for that row/date.

This will make it easy for the user to quickly compare the total on the source/raw paper document (e.g. ledger) being used to that generated by the app’s table, in the AMOUNT column, so that any differences can be instantly detected and/or reconciled.

 Watch the video to see how it’s done.
[2] Example workbook used in the video demonstration, complete with the new features/functions added – attached to THIS email (See screenshot below)
[IMPORTANT: This blog's contents are being updated following the transfer to www.tayosolagbade.com from my former domain - Spontaneousdevelopment.com. As a result, some parts of it may not work properly for now. Quick Tip: If a link contains "spontaneousdevelopment.com", simply change it to "tayosolagbade.com" - and it should work. This applies to article links as well as image links. Work continues to update the links(in over 500 articles). Tayo K. Solagbade.]

Practical Livestock Feed Formulation Handbook

Available as a PDF ebook, and also as a spiral bound print manual (from me). Click here for details.

You can also get it as an PDF ebook via my online store.

Screenshot of ebook in online store

$82.5 USD to buy it from my online store (PDF download)

N8,000.00 [Eight Thousand Naira] for persons who wish to send payment direct to my bank account.

Payment of N50,000.00 gets you the physical handbook and software on CD with videos etc, PLUS practical one-on-one, in person training with me at a feed mill in Lagos, Nigeria.

Click here to contact me about purchasing this product.

View Tayo Solagbade's video tutorials and demonstrations on Facebook Productivity Tips, Web Marketing, and for his Custom MS Excel-VB driven software applicationsJoin the SD Nuggets community on Facebook.comConnect with Tayo on Twitter.comConnect with Tayo on Google Plus

Your Gifts for Subscribing

When you signup, you'll receive:

Submit the form below to get a download link to the PDF version of my newly revised

Once you submit the form below, you will be taken directly to the downloads page, just as an auto-response message will be delivered to your inbox, with links to the promised gifts.

I look forward to meeting and/or working with you!

Signature image - Tayo K. Solagbade

Tayo K. Solagbade*
Performance Improvement Specialist & Multipreneur
*Best Practice Farm Business Support Specialist
& Founder of the MS Excel Heaven Visual Basic Automation Club & Competition(www.excelheaven.biz)



Excel-VB Driven Ration Formulator

Click to view larger screenshot

1. Click here to learn more about this app - watch demo videos etc

2. Click here to watch a 4 part video in which I demonstrate how to use this app to formulate rations using real life data sent to me by an Algerian PhD student.

Click here to contact me about purchasing this product.


Click here to download a detailed PDF user guide and watch 15 screen shot user guide tutorials of the Monthly Poultry Farm Manager that I now offer Farm CEOs.

Click here to watch a screenshot demonstration of the Excel-VB Driven Poultry Farm Manager I built for a client farm business in Ekiti state, South West Nigeria.

Click here to contact me about purchasing this product.

Powered by Optin Form Adder

Leave a Comment Here's Your Chance to Be Heard!

You must be logged in to post a comment.


Get the Facebook Likebox Slider Pro for WordPress