{"id":12548,"date":"2017-08-14T10:19:05","date_gmt":"2017-08-14T10:19:05","guid":{"rendered":"http:\/\/tayosolagbade.com\/sdnuggets\/?p=12548"},"modified":"2017-08-14T10:19:05","modified_gmt":"2017-08-14T10:19:05","slug":"excel-heaven-video-part-5-how-i-built-my-automated-cash-bookbank-reconciliation-software-inserting-amount-total-formulas-to-add-cost-center-entries-in-expense-section-of-the-imprest-cash-book","status":"publish","type":"post","link":"http:\/\/tayosolagbade.com\/sdnuggets\/excel-heaven-video-part-5-how-i-built-my-automated-cash-bookbank-reconciliation-software-inserting-amount-total-formulas-to-add-cost-center-entries-in-expense-section-of-the-imprest-cash-book\/","title":{"rendered":"[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]"},"content":{"rendered":"
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!<\/em><\/div>\n

Below are excerpts from the email I just sent to club members. Click here<\/a>\u00a0to request\u00a0a copy of the step-by-step video and example workbook I used...<\/h3>\n
\n
\n
The following files are to be used for your review of this week's tutorial:<\/div>\n
<\/div>\n
[1[ Step by Step screenshot video tutorial -\u00a0this was emailed to you via pCloud Transfer BEFORE this broadcast. See your email inbox.<\/b><\/div>\n
<\/div>\n
Here's a brief transcript excerpt from the video.<\/div>\n<\/blockquote>\n

Let me know if you need any help replicating or putting the demonstrated concepts into use,<\/p><\/blockquote>\n

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.<\/p><\/blockquote>\n

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.<\/p><\/blockquote>\n

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.<\/p><\/blockquote>\n<\/div>\n

\n
\u00a0Watch the video to see how it's done.<\/div>\n<\/blockquote>\n
\n
\n
[2] Example workbook used in the video demonstration, complete with the new features\/functions added - attached to THIS email (See screenshot below)<\/b><\/div>\n<\/blockquote>\n
\"tut13thaugust2017\"<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

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 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1375,266,10],"tags":[3065,3067,3066],"class_list":["post-12548","post","type-post","status-publish","format-standard","hentry","category-excel-vb-solutions","category-my-dn-travel-news","category-self-development","tag-excel-heaven-tutorial","tag-inserting-amount-total-formulas-to-add-cost-center-entries-in-expense-section-of-the-imprest-cash-book","tag-part-5-how-i-built-my-automated-cash-bookbank-reconciliation-software"],"aioseo_notices":[],"views":1139,"jetpack_featured_media_url":"","_links":{"self":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts\/12548","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=12548"}],"version-history":[{"count":1,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts\/12548\/revisions"}],"predecessor-version":[{"id":12550,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts\/12548\/revisions\/12550"}],"wp:attachment":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/media?parent=12548"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/categories?post=12548"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/tags?post=12548"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}