{"id":11062,"date":"2016-12-18T22:35:20","date_gmt":"2016-12-18T22:35:20","guid":{"rendered":"http:\/\/tayosolagbade.com\/sdnuggets\/?p=11062"},"modified":"2016-12-18T22:46:34","modified_gmt":"2016-12-18T22:46:34","slug":"coming-tomorrow-you-need-this-custom-spreadsheet-app-to-accurately-analyze-your-bank-statement","status":"publish","type":"post","link":"http:\/\/tayosolagbade.com\/sdnuggets\/coming-tomorrow-you-need-this-custom-spreadsheet-app-to-accurately-analyze-your-bank-statement\/","title":{"rendered":"[Coming Tomorrow] You Need this Custom Spreadsheet App to Accurately Analyze Your Bank Statement"},"content":{"rendered":"

On the 31st day of this month (December 2016), it will be exactly 14 years since I quit my high paying job as Technical Training and Development Manager with Guinness Nigeria, to (among other goals), pursue my dream of developing custom automated spreadsheet software for a living.<\/em><\/p>\n

I've since made MAJOR progress, establishing my own unique range of custom spreadsheet apps used by high profile clients within and outside Africa<\/a>. So much so that today I earn passive income selling my apps remotely via the web, without needing to meet face to face with clients.<\/p>\n

Each time a New Year approaches, I always work hard to hit the ground running with a new and different concept, product or soliution.<\/strong><\/p>\n

This time around what I've come up with happened really by accident. A problem I had making sense of the MS Excel based bank statement I downloaded from the online banking interface for one of my accounts.<\/p>\n

Below: Screenshot of online banking interface, with download of MS Excel statement in progress.<\/strong><\/p>\n

\u00a0<\/p>\n

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

The data was in too basic a format for me to find the information I needed, and trend it to arrive at useful deductions.<\/p>\n

Below: Screenshot of downloaded copy of January to December MS Excel based statement I generated from my online banking interface on 15th December 2016.\u00a0<\/strong><\/p>\n

\"webbasedstatement4\"<\/p>\n

Today I generated one covering 1st January 2012 till date, which I successfully used to test the new app I built. It worked superbly. Details, including screenshot of generated table and chart based summaries in tomorrow's issue of my PII newsletter.<\/em><\/p>\n

It was while I was crawling around in confusion in the downloaded spreadsheet version of my statement for 2016, that I remembered I possessed MS Excel-VB automation skills.<\/p>\n

And that meant I could do something about the problem I had with the data I was looking at!<\/em><\/p>\n

My desire to use the data for my planned purposes drove me to build an app to do what I want with the statement.<\/strong><\/p>\n

Then when I began using the finished app, it occurred to me that others who also use online banking interfaces to generate their bank statements would probably find this app useful.<\/p>\n

So, I decided I would use it as my new \"product\" going into the new year.<\/p>\n

Below is the description of the app, that I've put in its about window.<\/strong><\/p>\n

This Custom Automated Excel VB Driven Entreprise Information System(EIS) was built by Tayo K. Solagbade, for SDAc's Creative Business Solutions(CB Solutions) arm, using MS Excel\u00ae Visual Basic. It allows even a PC novice quickly and effortlessly import bank statement data from an MS Excel based workbook downloaded from his\/her bank's Internet Banking platform. Using in-built cystom automation tools the user is then able to generate tabulated and charted reports.<\/p><\/blockquote>\n

Tomorrow, the Monday issue of my weekly Performance Improvement Ideas (PII) newsletter, will go out.<\/strong><\/p>\n

In it, I will provide detailed descriptions and screenshots, as well as a step-by-step video demonstration of how the app works.<\/em><\/p>\n

Then I will end with an introductory promotional offer of the app. Members of my Excel Visual Basic Automation Club<\/a> will get a heftier discount.<\/p>\n

Stay tuned - in a few hours, the details will be LIVE.<\/p>\n

\u00a0<\/p>\n

Below: Screenshot of the data auto-imported from the MS Excel-based bank statement downloaded from my online banking interface<\/strong><\/p>\n

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

[PS:\u00a0<\/strong>This post is a precursor to tomorrow's special issue of my Performance Improvement Ideas (PII) newsletter, which will feature full details of this new product to be announced via a special promo offer]<\/span><\/em><\/p>\n","protected":false},"excerpt":{"rendered":"

On the 31st day of this month (December 2016), it will be exactly 14 years since I quit my high paying job as Technical Training and Development Manager with Guinness Nigeria, to (among other goals), pursue my dream of developing custom automated spreadsheet software for a living. I've since made MAJOR progress, establishing my own […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,8,1375,133,1,266,814,10,1753],"tags":[2635,2636],"class_list":["post-11062","post","type-post","status-publish","format-standard","hentry","category-employeescareer-persons","category-entrepreneurs","category-excel-vb-solutions","category-farm-biz","category-general-2","category-my-dn-travel-news","category-my-ideas-for-making-nigeria-better","category-self-development","category-the-farm-ceo","tag-coming-tomorrow","tag-you-need-this-custom-spreadsheet-app-to-accurately-analyze-your-bank-statement"],"aioseo_notices":[],"views":880,"jetpack_featured_media_url":"","_links":{"self":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts\/11062","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/comments?post=11062"}],"version-history":[{"count":3,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts\/11062\/revisions"}],"predecessor-version":[{"id":11069,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts\/11062\/revisions\/11069"}],"wp:attachment":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/media?parent=11062"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/categories?post=11062"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/tags?post=11062"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}