{"id":5913,"date":"2014-09-09T22:40:51","date_gmt":"2014-09-09T22:40:51","guid":{"rendered":"http:\/\/tayosolagbade.com\/sdnuggets\/?p=5913"},"modified":"2014-09-13T12:43:43","modified_gmt":"2014-09-13T12:43:43","slug":"get-the-excel-vb-driven-cash-inflow-and-outflow-tracker-appfeaturing-screenshot-images-video-demonstration","status":"publish","type":"post","link":"http:\/\/tayosolagbade.com\/sdnuggets\/get-the-excel-vb-driven-cash-inflow-and-outflow-tracker-appfeaturing-screenshot-images-video-demonstration\/","title":{"rendered":"Get the Excel-VB driven Cash Inflow and Outflow Tracker app(Featuring Screenshot Images & Video Demonstration)"},"content":{"rendered":"

In yesterday's issue of my newsletter<\/a>, I mentioned that I would publish a blog featuring my Excel-VB driven Cash Inflow and Outflow Tracker (BCCT) app<\/strong>:<\/p>\n

THIS is IT. <\/em><\/p>\n

I built the BCCT app within 48 hours, in late 2007 during a dark period following a major setback. From late September through November that year, I sold it for just N2,500 via serious pavement pounding\/door to door cold calling.<\/strong><\/p>\n

That experience earned me street smart marketing wisdom, and improved negotiationg skills. And I later used them to win high profile\/profit client projects from January 2008. <\/em><\/p>\n

Below: A one page printable flyer I used back in 2008 to market my nifty Excel-VB Cash Inflow & Outflow Tracker app, to clients\/buyers.<\/h3>\n

\"A<\/a><\/p>\n

The app was originally built for small business centres, so I started out calling it \u201cBusiness Centre Cashflow Tracker(BCCT)\u201d.<\/p>\n

Then I noticed independent consultants were purchasing it for personal use, so I began calling it Income & Expense Manager. In 2008, I began using it to track MY OWN inflow and outflow of cash, to demonstrate to potential buyers. how it works.<\/p>\n

From 2007 TO 2009, I actively sold this app via door to door pavement pounding on CDROM for N2,500 (approx. $15 USD). Between 21st Sept. \u201807 to 28th Nov. \u201907 (approx. 42 working days, I sold N41,000 worth of this app. That effort eventually led me to meet clients who hired me to build other apps for fees ranging from N45k to N200k! <\/em><\/p>\n

See JPEG image versions of reports generated from my 2008 data (with charts) - below... <\/strong><\/p>\n

==
\nUPDATE SETTINGS<\/h3>\n

Below: This is the settings update table in the app. <\/em><\/p>\n

\"This<\/a><\/p>\n

The user will post his\/her preferred income and expense labels and descriptions, which will become available in the in-cell drop menu on the Raw Data Entry Table. These income and expense labels also become available in the drop menus on the floating data entry form used to post entries into the Raw Data Entry Table.<\/p>\n

TIPS FOR USE: <\/strong>Clicking \u201cUpdate Settings Table\u201d on the Main Navigation Menu form (see inset above) brings you to this interface. Under \u201cIncome Source\u201d you will type the short label for the income generating activity you wish to track. Under Detail, you will add a name\/label that further describes it \u2013 especially when it occurs in variants. For instance the above screenshot shows that Phone call and Photocopy are income sources for the business center featured.<\/p>\n

Under \u201cDetail\u201d the type of phone call and photocopy is specified, so that what appears in the drop menu for data entry in the Raw Data Entry Table is a combination of the specified \u201cIncome Source\u201d and the \u201cDetail\u201d \u2013 see the column labeled \u201cCategory\u201d above. The program uses these income category descriptions to assign income data entered for preparation of analysis, charts and reports.<\/em><\/strong><\/p>\n

For expenses, simply specify a name for the expense item you wish to track. It will be picked up in the Expense listing drop menu in the Raw Data Entry form.<\/p>\n

This app was originally built for small business centres, so I started out calling it \u201cBusiness Centre Cashflow Tracker(BCCT)\u201d.<\/h3>\n

Then I noticed independent consultants were purchasing it for personal use, so I began calling it Income & Expense Manager. In 2008, I began using it to track MY OWN inflow and outflow of cash, to demonstrate to potential buyers. how it works.<\/p>\n

This JPEG image is an example showing real life income and expense heads I used back in 2008 in the Update Settings Table<\/strong><\/p>\n

=====<\/p>\n

DATA ENTRY<\/h3>\n

Below:<\/strong> This is the Raw Data Entry Table.<\/p>\n

\"Excel-VB<\/a><\/p>\n

These income and expense labels also become available in the drop menus on this floating data entry form (see inset above) used to post entries into the Raw Data Entry Table.<\/em><\/p>\n

Clicking the \u201cMake Entries\u201d button at the top left of the worksheet will load the above \u201cMake New Entry\u201d floating form - which will auto-insert the current date into the next empty cell after the most recent posted entry on the worksheet.<\/p>\n

If you choose a different date using the \u201cDate\u201d drop menu to the right of the \u201cEntry Type\u201d drop menu, the form will insert that date instead (e.g when you want to post for an earlier date period).<\/p>\n

The Year and Month are extracted from the date posted and entered into the last 2 columns to the right of the table. All the fields in this data entry table have their data filter buttons enabled, allowing the user to quickly and easily query the table for previously posted data(a painless way to find information). You can drill down using 2 or more criteria till you narrow down to the information you want. <\/strong><\/p>\n

Clicking the check box next to \u201cEntry Type\u201d on the form will cause the app to cursor select the \u201cExpense Type\u201d column on the row for which it posted the date. The user will then select either \u201cSales Income\u201d or \u201cOperating Expense\u201d from the \u201cEntry Type\u201d drop menu(see inset image on top right). See video demonstration at www.tinyurl.com\/bcct-demo to watch a demonstration of how this interface is used to post data and generate reports.<\/p>\n

Monthly Automated Summaries Report<\/h3>\n

Below a JPEG image version of reports generated from my 2008 data (with charts). It is autogenerated as data is posted into the Raw Data Entry Table interface.<\/p>\n

\"JPEG<\/a><\/p>\n

Daily and Monthly Automated Summaries Query Interface<\/h3>\n

This is a JPEG image version of the automated query interface, which allows the user to generate dynamic, ready-to-print income and expense reports and charts using data posted in the \u201cRaw Data Entry Table\u201d.<\/p>\n

\"JPEG<\/a><\/p>\n

The user can generate summaries for a date or month chosen from a drop menu. <\/em><\/p>\n

Today, I no longer sell the app that way (obviously!), but I still offer it for sale as an unlimited use EXE version for N5,000 (approx. $30 USD).<\/h3>\n

Apart from cash to bank payment, you can pay by:<\/p>\n

(1) Sending me MTN airtime credit or<\/p>\n

(2) Ordering 3 physical copies of my latest paperback book \u201dKukuru Danger\u201d from www.lulu.com\/sdaproducts<\/a> for delivery as a gift, to an address I will supply.<\/p>\n

Click here<\/a> to contact me for details.<\/p>\n

Watch the 3 part video demonstration below. (Note: Due to connectivity problems, only part 1 of 3 has been uploaded to my Youtube channel<\/a> for now<\/h3>\n

UPDATE (13th Sept. 2014 @ 11.53a.m Lagos time. About a day ago, I succeeded in uploading parts 2 and 3 - which are now embedded below).<\/h3>\n