tag:blogger.com,1999:blog-6344863680752971842024-03-14T02:34:12.748+00:00Domestic Well-Being (DWB) AccountingHave you ever thought about personal accounting?<br><br> All about a new accounting model focussed on managing the finances of an individual or a household/home situation.Nilgaihttp://www.blogger.com/profile/14912670556905736362noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-634486368075297184.post-69764677154166142912015-09-20T11:20:00.002+01:002015-09-20T23:14:30.374+01:00Find Your Dream Home - Polygon Searches<b><u>Find Your Dream House</u></b><br />
<b><u>Polygon Searches</u></b><br />
<strong><u>Swanage to the Solent</u></strong><br />
<strong><u>Highcliffe - of Selfridge Fame</u></strong><br />
<br />
<br />
Having recently put my home on the market, I started to think from the point of view of a purchaser about how my home could be more easily found?<br />
<br />
It is pretty well known that there are a multitude of websites around that specialise in making available information about houses for sale and many offer various means to create (and save) search criteria.<br />
<br />
Many estate agents have arrangements to provide details of the houses ‘on their books’ to one or more of these websites; for example, my estate agent, a branch of Winkworth, makes information available to Rightmove and Zoopla, amongst others.<br />
<br />
By going to one of these sites on the internet, you can simply base a search on a location (village, city, postcode) and a radius (Immediate area, ¼ , ½, 1, 3, 5, 10, 15, 20, 30 or 40 miles) to create a search-circle. Additional criteria may include type of property, min &/or max price, min &/or max bedrooms, etc. as well as sort-style – lowest or highest price first. <br />
<br />
Also, the choice of the initial display format - such as a (long) list of all properties meeting the criteria, a grid of properties with many more properties being shown per page for an easy, quick scan, or a display of the location of the property hits, on a zoom-able map.<br />
<br />
The circle-search is fine for certain self-evident search requirements but for some situations, a more flexible kind of search may be more appropriate.<br />
<br />
For instance, my home would be particularly of interest to firstly, those looking for a retirement home on the South coast, with the additional offering of extensive accommodation that might suite professional people requiring a consulting room with private entrance, or accommodation for an extended family.<br />
<br />
A search that would help finding such a property is called a polygon search or Drawn Area (by<i> Rightmove</i>). This simply means that an area is drawn on a map by marking down points that result in a set of straight lines to eventually create a closed loop – termed in geometry, as a polygon. Once created, the points can be individually dragged to fine-tune the resulting search area.<br />
<br />
Polygons can easily be created for unusual shapes such as coastal areas or strips, mountain valleys, parts of the Lake District or road corridors, like Salford or the M4, etc. All the other criteria, in this case 6 or more bedrooms, are simply applied to the polygon, rather than a circle, to produce the required hits. Finally, the search may optionally be saved with a descriptive name.<br />
<br />
Here is an example below of a search to find 5+ bedroomed properties on the stretch of the South Coast between Swanage and the Solent. The fact that Highcliffe Castle is of Selfridge fame is not a valid criteria!<br />
<br />
To do this using the more well-known circle search would either mean one very large circle with far too many unwanted hits away from the coast line, or a large series of small circles which would be time-consuming and very tedious to work with.<br />
<br />
<br />
John Passmore, Rothesay Drive, Highcliffe, Dorset September 2015<br />
<br />
<br />
<br />
Map View Results:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiRuhevHpXZ_ZUqNLdJv7fPnMMzTzIX6Q_mM_bd2eQkbqx0kCzTXjGV9U6RZbKaHihJdyo9JO2KfKqKWIpcls9bIyt6u_gU_AFAbwsd1lN4DFjX8Tei5usRXmP5UVdwKtPH_XsxmwTwVD8/s1600/Screenshot_Solent-mapview.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="250" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiRuhevHpXZ_ZUqNLdJv7fPnMMzTzIX6Q_mM_bd2eQkbqx0kCzTXjGV9U6RZbKaHihJdyo9JO2KfKqKWIpcls9bIyt6u_gU_AFAbwsd1lN4DFjX8Tei5usRXmP5UVdwKtPH_XsxmwTwVD8/s400/Screenshot_Solent-mapview.png" width="400" /></a></div>
<br />
<br />
<br />
Grid View Results:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEghuhLqRq-uTWQx9bFCkEplrlv6QaSHTKsV60UmnWhV22UPmkOOgu2TIRBfMLUR7iTZup-R7Ape-yy21Hk28-QNzz4H4txDEud4mFOmvGTF-ili8v0fxopuHshrryZR_0VETNS52XeYMfk/s1600/Screenshot_Solent-gridview.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="250" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEghuhLqRq-uTWQx9bFCkEplrlv6QaSHTKsV60UmnWhV22UPmkOOgu2TIRBfMLUR7iTZup-R7Ape-yy21Hk28-QNzz4H4txDEud4mFOmvGTF-ili8v0fxopuHshrryZR_0VETNS52XeYMfk/s400/Screenshot_Solent-gridview.png" width="400" /></a></div>
<br />
<br />
List View Results:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhQQz0fRuYesHtuDIyygcjudaOyZ3NrAW0kZRAGgCJiANLiJ53eAnBMsq7m-NzpxZf2WFHcs8AhNmoxrV67mQ-EUCYjRHgmClH2OiZ68mQJLNWTTqJXNsnb_Tz0kpsD0KY0bMCi0IVaRjY/s1600/Screenshot_Solent-listview.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="250" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhQQz0fRuYesHtuDIyygcjudaOyZ3NrAW0kZRAGgCJiANLiJ53eAnBMsq7m-NzpxZf2WFHcs8AhNmoxrV67mQ-EUCYjRHgmClH2OiZ68mQJLNWTTqJXNsnb_Tz0kpsD0KY0bMCi0IVaRjY/s400/Screenshot_Solent-listview.png" width="400" /></a></div>
<br />
<br />
<br />
Panorama Views:<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgVxl-hsllphu7AlBDzJFNivoTE8s-58Y9VbVFqLU6dRbJsqmIh7oyK_LqpEHvaIeFmkA2sdZzEV7L5ktal2x1o6Ht1ae-ZLxMCvQXKwXnG8Oq1qbBHOcSwyVrUNjhL733H2pFgfbFsv14/s1600/36rothesay-panaromaSeaside02.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="225" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgVxl-hsllphu7AlBDzJFNivoTE8s-58Y9VbVFqLU6dRbJsqmIh7oyK_LqpEHvaIeFmkA2sdZzEV7L5ktal2x1o6Ht1ae-ZLxMCvQXKwXnG8Oq1qbBHOcSwyVrUNjhL733H2pFgfbFsv14/s400/36rothesay-panaromaSeaside02.jpg" width="400" /></a></div>
<br />
<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiL8Mk62JjZPCvq1Boq8jYmPQE9CKX3WQ8DItgML0bm3KAZ43cMTfvcMrbUN-8uDYrvS-Z01lIVBzdsaGIjCQ0pWGQRKw4B8uQNLkdEm8fML_23MB711I0__CQ-6V_M8AsZxVSdjdqzSI0/s1600/36rothesay-panaroma01large.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="225" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiL8Mk62JjZPCvq1Boq8jYmPQE9CKX3WQ8DItgML0bm3KAZ43cMTfvcMrbUN-8uDYrvS-Z01lIVBzdsaGIjCQ0pWGQRKw4B8uQNLkdEm8fML_23MB711I0__CQ-6V_M8AsZxVSdjdqzSI0/s400/36rothesay-panaroma01large.jpg" width="400" /></a></div>
<br />
<br />
<br />
To view a search example in an internet browser, Link (Copy /Paste into browser or try Control/Click on this link):<br />
<br />
http://www.rightmove.co.uk/property-for-sale/map.html?locationIdentifier=USERDEFINEDAREA%5E%7B%22id%22%3A3085445%7D&minPrice=900000&maxPrice=1250000&minBedrooms=5&displayPropertyType=houses&oldDisplayPropertyType=houses<br />
<br />
<br />Nilgaihttp://www.blogger.com/profile/14912670556905736362noreply@blogger.com0tag:blogger.com,1999:blog-634486368075297184.post-69821292870146157212009-07-10T16:47:00.001+01:002009-07-10T16:47:49.109+01:00THE CONTROL OF PERSONAL AND HOUSEHOLD FINANCES:<p><b>BALANCING THE DWBA STRUCTURE FOR BUDGETS AND MONITORING</b></p> <p><b>INTRODUCTION</b></p> <p align="justify">This blog continues the sequence of an on-going series of articles which is intended to provide summarised information about Domestic Well-Being (DWB) accounting.</p> <p align="justify">The whole reason for implementing an accounting system is so that its user(s) can establish and achieve control of the underlying financial system being modelled. In this context, we are interested in the management and control of the finances of an individual or a domestic, household situation.</p> <p align="justify">Prior to the previous blog which looked at the way-ahead for domestic accounting and which introduced the need for system providers to migrate from off-the-shelf personal accounting software packages to modern, <i>Software as a Service</i> (SaaS) server-based programs, I discussed the subject of DWBA reports.</p> <p align="justify">This blog addresses the control of personal finances with an introduction to prototypes of some innovative new tools for dynamically creating budgets and monitoring financial activity against those budgets.</p> <p align="justify">In more detail, these tools are intended to help obtain an optimum balance across the structure at the heart of the new DWB accounting model, develop corresponding budgets and to then monitor performance against those budgets. When required if things are not proceeding to plan, it would be necessary to simply repeat the budget cycle as often as needed but typically, at 3-monthly quarters.</p> <p align="justify"><b>REPORTS</b></p> <p align="justify">The main report for control purposes is the Domestic Well-Being Statement (DWBS). This report, replacing the business-style Trading and Profit & Loss reports, details <i>the changes</i> that may have occurred over the previous financial period, typically 1, 3, 6, 9 or 12 months – but the longer the better.</p> <p align="justify">You will recall from earlier blogs that this report represents the hierarchical DWB structure with categories and levels of sub-categories for both the Increases and Decreases to the finances that may have occurred over some period.</p> <p align="justify">Another report, the Domestic Balance Sheet (DBS) gave us the static information about our various assets and liabilities of different types on a particular day, usually the last day of the period. The changes over a period obtained from the DWBS, equate to the overall change in the static financial position occurring between the beginning and the end of that period under consideration.</p> <p align="justify">Let’s now look at some views of the DWBS where we are looking at the changes that were recorded from transactions in a sample, year’s worth of financial data used as the example set of accounts for my book ‘Accounting for a Better life’.</p> <p></p> <div style="border-bottom: 0px solid; text-align: left; border-left: 0px solid; background-color: #a0ffff; padding-left: 4px; width: 404px; padding-right: 4px; font-family: arial; height: 343px; color: #000000; font-size: 12px; overflow: auto; border-top: 0px solid; border-right: 0px solid; padding-top: 4px"><a href="http://lh6.ggpht.com/_qUu3JnHZeXU/SldiCiikmMI/AAAAAAAAAQY/BPerxmaM628/s1600-h/acz%20bal01%5B14%5D.jpg"><img style="border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" title="acz bal01" border="0" alt="acz bal01" src="http://lh3.ggpht.com/_qUu3JnHZeXU/SldiD3g0sBI/AAAAAAAAAQc/skZe8e2TT2I/acz%20bal01_thumb%5B10%5D.jpg?imgmax=800" width="751" height="311" /></a></div> <p></p> <p align="justify">The images you see are from an implementation of the DWB accounting model in an off-the-shelf accounting package called Personal Accountz<b><sub>©</sub></b>. This first view shows the top level of the changes that have occurred over the year:</p> <p align="justify">The first six rows are about the static elements of our financial situation – our assets and personal liabilities or debts – plus some so-called temporary working accounts used to mediate certain financial activity.</p> <p align="justify">Next, we have the <i>projected</i> value of our estate, made up of our <i>Domestic Wealth</i> as at the last time we recorded it – at the beginning of the current period - plus the accumulated changes during the current period. You can see that the <i>Total Domestic Change</i> (TDC) is £25,900 made up of two groups, for Increases (LQ Domestic Increases) and Decreases (AQ Domestic Decreases); the + signs indicate that there is more detail available at lower sub-category levels.</p> <p align="justify">The prefixes LQ and AQ stand for <i>quasi-liabilities</i> and <i>quasi-assets</i>, respectively; where these account name prefixes are discussed in a previous blog on ‘DWBA Accounting – Some Theory’.</p> <p align="justify">The totals of the increases and decreases are not visible here because their values of £88,200 and £62,300 respectively have already been moved to the TDC account giving us the difference, being a surplus value of £25,900. I call this a Domestic Surplus (<i>Domplus</i>), in contrast to a Domestic Deficit (<i>Domicit</i>) when the decreases would have exceeded the increases over some period. This is the domestic or household equivalent of business profit or loss.</p> <p align="justify">If we click on the two + tabs against Increases and Decreases, we see the next lower levels of the DWB structure with the sub-totals for the Basic, Discretionary and Other (non-Discretionary) categories for each of them.</p> <p></p> <div style="border-bottom: 0px solid; text-align: left; border-left: 0px solid; background-color: #a0ffff; padding-left: 4px; width: 396px; padding-right: 4px; font-family: arial; height: 377px; color: #000000; font-size: 12px; overflow: auto; border-top: 0px solid; border-right: 0px solid; padding-top: 4px"><a href="http://lh4.ggpht.com/_qUu3JnHZeXU/SldiEzMJnaI/AAAAAAAAAQg/FZsTvxFjRns/s1600-h/acz%20bal02%5B9%5D.jpg"><img style="border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" title="acz bal02" border="0" alt="acz bal02" src="http://lh4.ggpht.com/_qUu3JnHZeXU/SldiF0P5yyI/AAAAAAAAAQk/5DrajzOGeZw/acz%20bal02_thumb%5B7%5D.jpg?imgmax=800" width="645" height="346" /></a></div> <p></p> <p align="justify">Now we can begin to see the high-level balance, or perhaps lack of balance, in the structure of a year’s worth of personal or household financial activity – a high value for ‘Other’ Increases and relatively low ‘Discretionary’ Decreases.</p> <p align="justify"><b>A BALANCING TOOL</b></p> <p align="justify">Once the figures for a past complete or part-period have been examined, what was needed was an easy and visually appealing way to undertake the balancing process for the next period. A prototype balancing and budget creation tool has now been added to the DWB accounting model repertoire that does just that.</p> <p align="justify">The way the new tool works is by overlaying a series of adjustable bars, on top of bar charts for the figures accumulated for the previous or current period. The required Balance amongst the categories for a new budget can be achieved by simply adjusting the length of the various bars in an iterative way, compared to those of the previous period.</p> <p align="justify">Without knowing too much yet about the significance of <i>Basics</i>, <i>Discretionary</i> and <i>Others</i>, separately for both the Increases and Decreases, we have the first indication of what the current balance at the end of the last period looks like. Having said <i>looks like</i>, a picture will give us a better <i>view</i> so here is a <i>bar chart</i> view of what we have seen and know so far from the DWBS report:</p> <p></p> <div style="border-bottom: 0px solid; text-align: left; border-left: 0px solid; background-color: #a0ffff; padding-left: 4px; width: 404px; padding-right: 4px; font-family: arial; height: 509px; color: #000000; font-size: 12px; overflow: auto; border-top: 0px solid; border-right: 0px solid; padding-top: 4px"><a href="http://lh4.ggpht.com/_qUu3JnHZeXU/SldiG88NzSI/AAAAAAAAAQo/a-fxR1MViQM/s1600-h/Bal%20Top%5B5%5D.jpg"><img style="border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" title="Bal Top" border="0" alt="Bal Top" src="http://lh3.ggpht.com/_qUu3JnHZeXU/SldiIf_KZ0I/AAAAAAAAAQs/8xac9kVLNak/Bal%20Top_thumb%5B3%5D.jpg?imgmax=800" width="806" height="476" /></a></div> <p></p> <p align="justify">This overview-level view shows how the totals for the Increases (blue) and Decreases (red) for an accounting period are made up and what the relative distribution looks like amongst those top-level DWB Categories. The green bars are for our new planned budget arrangement, hopefully adjusted to achieve the best possible DWB balance.</p> <p align="justify">The heading shows us that we are looking at values for the past 12 months for our ‘Last Period’ so we are looking at the situation at the end of a 12-month period where we might be developing a budget for the next 12 months. </p> <p align="justify">All the values associated with each of the bars are shown at the end of each bar as both an actual value (the first figure – in whatever currency - £ here), as well as this value in a normalised format, as the second figure.</p> <p align="justify">For the normalised values, the higher of the totals for the Increases or Decreases amounts are associated with 1.0 and all the other displayed values are therefore shown as a proportion of 1.0; so for these DWB example figures, the Increases were higher than the Decreases so the Increases total of £88,200 is equated to 1.0 and the Decreases of £62,300 therefore can be seen to have a normalised value of 0.71 and all the other normalised bar values are displayed accordingly.</p> <p align="justify">Normalisation gives us a quick way to see relative differences between the values – if you prefer percentages, just mentally multiply the normalised values by 100. What we see here is that the Decreases were about 70% (0.71) of the Increases during the last period.</p> <p align="justify">At this point at the end of one period, we would probably be interested in deciding what changes we might we wish to see by the end of the next period, in a years time. Let’s look further at the tools at our disposal. </p> <p></p> <div style="border-bottom: 0px solid; text-align: left; border-left: 0px solid; background-color: #a0ffff; padding-left: 4px; width: 397px; padding-right: 4px; font-family: arial; height: 651px; color: #000000; font-size: 12px; overflow: auto; border-top: 0px solid; border-right: 0px solid; padding-top: 4px"><a href="http://lh5.ggpht.com/_qUu3JnHZeXU/SldiJcTcYzI/AAAAAAAAAQw/7edk0bOlxCQ/s1600-h/Bal%20Top%2002%5B6%5D.jpg"><img style="border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" title="Bal Top 02" border="0" alt="Bal Top 02" src="http://lh6.ggpht.com/_qUu3JnHZeXU/SldiK9srtpI/AAAAAAAAAQ0/nLrRXT8Pzug/Bal%20Top%2002_thumb%5B4%5D.jpg?imgmax=800" width="754" height="616" /></a></div> <p align="justify">The new objects are a series of ‘sliders’ associated with some new bars shown in green in these views. The sliders can be grabbed and moved with a mouse or clicked on the arrow-heads at either end of the slider to achieve more controlled incremental changes in the amount and length of each of their linked bars.</p> <p align="justify">Some of the green bars representing totals for subordinate groups of bars are not associated with sliders themselves but move to show the accumulated effect of moving sliders in the subordinate bars that are contained in their represented totals.</p> <p align="justify">There are movable bars for the main DWB Categories for both the Increases and the Decreases where the purpose at this overview-level is to make changes for the future desired amounts of the particular quantities associated with each bar.</p> <p align="justify">For example for Increases, there may be a known salary increase expected so this can be factored into the <i>Basic Increases</i> for next year or for the remainder of the current period if we are re-balancing some way into a period.</p> <p align="justify">With knowledge of the details of what happened last year, you would know that the relatively high amount of <i>Other Increases</i> last year was due to an inheritance from Uncle Jo and so the projected amount for <i>Others</i> for next year can be correspondingly reduced with little likelihood of another inheritance.</p> <p align="justify">As changes are made to the lower, more detailed levels for <i>Basic</i>, <i>Discretionary</i> and <i>Others</i>, the corresponding Totals bars will also change in amount and length, dynamically.</p> <p align="justify">At this overview-level, the issues will be about the relative balance or proportions of the desired amounts for the three DWB Categories making up Decreases – Basics, Discretionary and Others (non-Discretionary). These will be viewed in relation to last year’s amounts, the likely Increases for next year and the resulting <i>Domplus</i> or <i>Domicit</i> that can be accepted or is desired for next year.</p> <p align="justify">In contrast to maximising profits in business, our domestic life seeks only a modest and steady increase in Domestic Wealth but from the DWB perspective, we look for a better balanced set of financial decreases to ensure that the best possible ‘life’ is being experienced within the applicable constraints.</p> <p align="justify">The predicted wealth based on our developing budget can be seen from the moving, Total Domestic Change (TDC) bar, included at the top and bottom of the complete chart. Here, the projected figures for the TDC for next year is highlighted; this is shown in comparison to the static bar/figure for last year, and where the TDC for next year can be seen to change as the projections are being made with the sliders for the Increases and Decreases for next year.</p> <p align="justify">Other overview-level inputs that maybe appropriate, result from decisions made in respect of reducing any existing debt over the coming year and the need for any new, short to medium-term savings, over and above regular provisions for the future, hopefully managed under the Investment for the Future (IFF) sub-category.</p> <p align="justify">From the static data in the DBS, also visible on the main Accountz screen, the level of personal current debt accumulated might be considered unacceptably high and a decision made to reduce it by some achievable amount, over the forthcoming period.</p> <p align="justify">The planned re-payments to do this over the coming period will have to be balanced alongside all the other decreases earmarked for the next period and the selected future target reduction in personal debt should therefore be entered using one of the two bars, under <i>Discretionary Balancing</i>.</p> <p align="justify">Any need for a particular accumulation of funds as short to medium-term savings, to replace an old car for example, should be entered with the second bar at this level, under <i>Discretionary Balancing</i>.</p> <p align="justify">As you progress down to the lower levels of the balancing process, difficulties discovered in achieving a workable balance at the lower levels may well require a return to either or both the intermediate and top levels to alter some previously chosen values. The very nature of the hierarchical description of the characteristics of financial behaviour behind the DWB structure implies that an iterative process will be required to achieving an optimal balance.</p> <p align="justify">Each adjustable bar used for planning future financial activity is identified with characters relating to its sub-category identity e.g. ‘D’ for debt; ‘S’ for savings and ‘1F’ for Car1 Fuel. There is also an additional pair of numbers at the end of some of the planning bars; these represent the annual and monthly future change compared to the previous period, required for this sub-category in order to achieve the new amount of increase or decrease represented by the length of the particular bar. This number changes dynamically as the length of each bar is adjusted and similar changes are reflected in the figures of associated higher-level Totals.</p> <p align="justify">Colour as mentioned earlier is also used to help distinguish particular types of bar – blue for previous period increases, red for previous level decreases, green for selected budget values for the next period and blue for values previously selected/budgeted at higher levels of the iterative budget creation process.</p> <p align="justify">The target to be met by balancing lower level sub-categories at any particular level of balancing is therefore the blue bar amount shown at this level, established by previous balancing at the next higher level.</p> <p align="justify">Returning to the DWBS, we need to expose some lower levels of detail so here is another view with the next lower level of sub-categories for the Increases, opened up:</p> <p></p> <div style="border-bottom: 0px solid; text-align: left; border-left: 0px solid; background-color: #a0ffff; padding-left: 4px; width: 397px; padding-right: 4px; font-family: arial; height: 502px; color: #000000; font-size: 12px; overflow: auto; border-top: 0px solid; border-right: 0px solid; padding-top: 4px"><a href="http://lh3.ggpht.com/_qUu3JnHZeXU/SldiL_SolEI/AAAAAAAAAQ4/ChyXaAmVRrs/s1600-h/clip_image002%5B4%5D.jpg"><img style="border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" title="clip_image002" border="0" alt="clip_image002" src="http://lh5.ggpht.com/_qUu3JnHZeXU/SldiNY9sVII/AAAAAAAAAQ8/m0oZW5RiFRQ/clip_image002_thumb%5B1%5D.jpg?imgmax=800" width="655" height="466" /></a></div> <p></p> <p>Now let’s look at more detail for the Decreases for the current period – already with some of the intermediate levels of the DWB structure visible:</p> <p></p> <div style="border-bottom: 0px solid; text-align: left; border-left: 0px solid; background-color: #a0ffff; padding-left: 4px; width: 394px; padding-right: 4px; font-family: arial; height: 538px; color: #000000; font-size: 12px; overflow: auto; border-top: 0px solid; border-right: 0px solid; padding-top: 4px"><a href="http://lh4.ggpht.com/_qUu3JnHZeXU/SldiOXQXNrI/AAAAAAAAARA/6c7Hh-KC5I0/s1600-h/clip_image002%5B5%5D%5B5%5D.jpg"><img style="border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" title="clip_image002[5]" border="0" alt="clip_image002[5]" src="http://lh5.ggpht.com/_qUu3JnHZeXU/SldiP7yudII/AAAAAAAAARE/PplhtnexC5c/clip_image002%5B5%5D_thumb%5B3%5D.jpg?imgmax=800" width="642" height="504" /></a></div> <p></p> <p align="justify">Here we can see the two main sub-categories of <i>Basic Decreases</i>, the <i>Essentials</i> and <i>Responsibilities</i> with their next, lower-level sub-categories.</p> <p align="justify">We can of course keep on drilling down to see more and more detail, right down to individual financial transactions.</p> <p align="justify">The power of this structure and the resulting figures for some reporting period mean that we now have a basis for quite detailed decision-making for the future.</p> <p align="justify">The whole concept behind DWB accounting is towards achieving the best possible balance of personal or household finances and hence, achieving a better life within the prevailing constraints.</p> <p align="justify">By this, we want to get a proper balance across all the categories of expenses. We want to avoid spending excessively in some areas to the detriment of spending in other areas.</p> <p align="justify">By ensuring that we spend proportionately in all areas, the implication is that we should experience a better overall life since we should be obtaining the benefits and rewards of all the many categories of purchased produce, items and activities that make up the typical, day-to-day lifetime experience.</p> <p align="justify">The DWBS figures enable us to search for balance and as we are seeing, dynamically alter how we want this balance to look for the future.</p> <p align="justify">This will always be in order to obtain the best possible balance within the prevailing constraints. These constraints as we have seen are essentially the increases, as income, together with any existing debt that needs to be reduced and any new requirement to accumulate particular amounts as savings for short to medium-term financial priorities – e.g. that car replacement.</p> <p align="justify">After that, the priorities are first, to make sure that for the Decreases, care is taken of the <i>Basics</i> in terms of both the <i>Essentials</i> (food, clothing, accommodation, utilities, etc.) and the <i>Responsibilities</i> that we all experience - such as taxes, household obligations, professional expenses, garden maintenance, etc.</p> <p align="justify">Next, at the Discretionary category of Decreases we should ensure that we have equitable and balanced expenditure across the <i>Nice-to-Have’s</i> of <i>Holidays</i>, <i>Leisure and Entertainment</i>, and <i>Hobbies</i>; as well as the all-important, <i>Investment for the Future</i> (IFF).</p> <p align="justify">With the likelihood of an ever-inadequate future pension, it is even more important that everyone makes their own adequate additional provision for the future. This means ensuring that appropriate amounts are stored away or invested on a regular basis and it is common knowledge that the earlier the start is made, the easier the process and the greater the future pension or provision for the future is likely to be.</p> <p align="justify">DWB addresses amounts to save but specialist advice would be required on the choice of investments and how best to benefit from such investment in practise.</p> <p align="justify">As ‘balancing’ decisions are made at the higher levels of the structure, it will then be necessary to go to the lower-level sub-categories to determine what more detailed changes need to be made at these lower levels and below, by balancing in more detail, in order to achieve the balance envisaged by the top-level decisions.</p> <p align="justify">As we have begun to see, it turns out to be an iterative process where difficulties might be discovered in achieving the required balance at the lowest levels. This usually implies a return to the intermediate or top levels for possible further redistribution across the sub-categories, or even to go back to the overview-level to accept and to readjust those amounts accordingly. This is because these first-cut high-level targets might now appear unachievable in practice when balancing at all levels has been attempted.</p> <p align="justify">Understandably, you cannot try to achieve the impossible. Your desired balance within all the levels have to match the likely Increases. Of course you might well conclude that you need more qualifications and a better job to achieve the lifestyle to which you aspire! This is just another feature of the visibility on your finances provided by the DWB accounting model.</p> <p align="justify"><b>BUDGETS </b></p> <p align="justify">In general, what we are trying to do is to work out what we would like the future figures at the end of some period, to look like. Budgets are lists of figures or targets for financial activity, most often for expenditure, and will be most useful if these figures can estimate target amounts at varying future points – say 3-months, 6-months, 9-months and on to the end-of-year, 12 months ahead.</p> <p align="justify">The main by-product of the new structured, dynamic balancing tool is a set of budget amounts for every sub-category of the DWB structure, at all of the required, future 3-month quarterly points.</p> <p align="justify">Obviously for a home or domestic situation, we do not want to overdo things by trying to control everything in too much detail so it will be important for users to select for actual control purposes, just the figures for the sub-categories for budgetary control that have the most impact. By this, we need to concentrate on making decisions on trying to reign-in spending in areas that we find are in most need of cutbacks or for re-balance.</p> <p align="justify">We also need to try to control areas where there is an element of flexibility or choice to make it possible to actually achieve the implied future changes through corresponding changes in spending patterns (with appropriate self-control and discipline!). This might involve deliberate decisions to cut back on some utilities, car usage, food costs, luxuries and so on.</p> <p align="justify">Let’s now look at some of the lower levels of the balancing process. There are four levels of balancing available with DWB to be used as needed and not every sub-category of Decreases will be expanded to be balanced in detail at the level in which it lies:</p> <p align="justify">Overview level</p> <p align="justify">Top level</p> <p align="justify">Intermediate level</p> <p align="justify">and Low or Bottom level</p> <p align="justify">We have so far looked at the Overview level where those general decisions were made in regard to likely future Increases and the desired distribution and amounts of future Decreases at the major category level.</p> <p align="justify">The next three levels only address Decreases as there is very little more to be said or controlled at the lower level, DWB sub-categories for Increases.</p> <p align="justify">Here is the balancing tool being used at the Top level, for Decreases:</p> <p></p> <div style="border-bottom: 0px solid; text-align: left; border-left: 0px solid; background-color: #a0ffff; padding-left: 4px; width: 393px; padding-right: 4px; font-family: arial; height: 661px; color: #000000; font-size: 12px; overflow: auto; border-top: 0px solid; border-right: 0px solid; padding-top: 4px"><a href="http://lh5.ggpht.com/_qUu3JnHZeXU/SldiQ97qzwI/AAAAAAAAARI/sjjg8YEOLe4/s1600-h/clip_image004%5B6%5D.jpg"><img style="border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" title="clip_image004" border="0" alt="clip_image004" src="http://lh5.ggpht.com/_qUu3JnHZeXU/SldiSLQFBrI/AAAAAAAAARM/Ovu-zHisXmg/clip_image004_thumb%5B3%5D.jpg?imgmax=800" width="877" height="625" /></a></div> <p align="justify">The new objects are a series of ‘sliders’ associated with some new bars shown in green in these views. The sliders can be grabbed and moved with a mouse or clicked on the arrow-heads at either end of the slider to achieve more controlled incremental changes in the amount and length of each of their linked bars.</p> <p align="justify">Some of the green bars representing totals for subordinate groups of bars are not associated with sliders themselves but move to show the accumulated effect of moving sliders in the subordinate bars that are contained in their represented totals.</p> <p align="justify">There are movable bars for the main DWB Categories for both the Increases and the Decreases where the purpose at this overview-level is to make changes for the future desired amounts of the particular quantities associated with each bar.</p> <p align="justify">For example for Increases, there may be a known salary increase expected so this can be factored into the <i>Basic Increases</i> for next year or for the remainder of the current period if we are re-balancing some way into a period. With knowledge of the details of what happened last year, you would know that the relatively high amount of <i>Other Increases</i> last year was due to an inheritance from Uncle Jo and so the projected amount for <i>Others</i> for next year can be correspondingly reduced with little likelihood of another inheritance.</p> <p align="justify">As changes are made to the lower, more detailed levels for <i>Basic</i>, <i>Discretionary</i> and <i>Others</i>, the corresponding Totals bars will also change in amount and length, dynamically.</p> <p align="justify">At this overview-level, the issues will be about the relative balance or proportions of the desired amounts for the three DWB Categories making up Decreases – Basics, Discretionary and Others (non-Discretionary). These will be viewed in relation to last year’s amounts, the likely Increases for next year and the resulting <i>Domplus</i> or <i>Domicit</i> that can be accepted or is desired for next year.</p> <p align="justify">In contrast to maximising profits in business, our domestic life seeks only a modest and steady increase in Domestic Wealth but from the DWB perspective, we look for a better balanced set of financial decreases to ensure that the best possible ‘life’ is being experienced within the applicable constraints.</p> <p align="justify">The predicted wealth based on our developing budget can be seen from the moving, Total Domestic Change (TDC) bar, included at the top and bottom of the complete chart. Here, the projected figures for the TDC for next year is highlighted; this is shown in comparison to the static bar/figure for last year, and where the TDC for next year can be seen to change as the projections are being made with the sliders for the Increases and Decreases for next year.</p> <p align="justify">Other overview-level inputs that maybe appropriate, result from decisions made in respect of reducing any existing debt over the coming year and the need for any new, short to medium-term savings, over and above regular provisions for the future, hopefully managed under the Investment for the Future (IFF) sub-category.</p> <p align="justify">From the static data in the DBS, also visible on the main Accountz screen, the level of personal current debt accumulated might be considered unacceptably high and a decision made to reduce it by some achievable amount, over the forthcoming period.</p> <p align="justify">The planned re-payments to do this over the coming period will have to be balanced alongside all the other decreases earmarked for the next period and the selected future target reduction in personal debt should therefore be entered using one of the two bars, under <i>Discretionary Balancing</i>.</p> <p align="justify">Any need for a particular accumulation of funds as short to medium-term savings, to replace an old car for example, should be entered with the second bar at this level, under <i>Discretionary Balancing</i>.</p> <p align="justify">As you progress down to the lower levels of the balancing process, difficulties discovered in achieving a workable balance at the lower levels may well require a return to either or both the intermediate and top levels to alter some previously chosen values. The very nature of the hierarchical description of the characteristics of financial behaviour behind the DWB structure implies that an iterative process will be required to achieving an optimal balance.</p> <p align="justify">Each adjustable bar used for planning future financial activity is identified with characters relating to its sub-category identity e.g. ‘D’ for debt; ‘S’ for savings and ‘1F’ for Car1 Fuel. There is also an additional pair of numbers at the end of some of the planning bars; these represent the annual and monthly future change compared to the previous period, required for this sub-category in order to achieve the new amount of increase or decrease represented by the length of the particular bar. This number changes dynamically as the length of each bar is adjusted and similar changes are reflected in the figures of associated higher-level Totals.</p> <p align="justify">Colour as mentioned earlier is also used to help distinguish particular types of bar – blue for previous period increases, red for previous level decreases, green for selected budget values for the next period and blue for values previously selected/budgeted at higher levels of the iterative budget creation process.</p> <p align="justify">The target to be met by balancing lower level sub-categories at any particular level of balancing is therefore the blue bar amount shown at this level, established by previous balancing at the next higher level.</p> <p align="justify">Returning to the DWBS, we need to expose some lower levels of detail so here is another view with the next lower level of sub-categories for the Increases, opened up:</p> <p></p> <div style="border-bottom: 0px solid; text-align: left; border-left: 0px solid; background-color: #a0ffff; padding-left: 4px; width: 397px; padding-right: 4px; font-family: arial; height: 515px; color: #000000; font-size: 12px; overflow: auto; border-top: 0px solid; border-right: 0px solid; padding-top: 4px"><a href="http://lh3.ggpht.com/_qUu3JnHZeXU/SldiTZ1KROI/AAAAAAAAARQ/Dof6jzlDNR4/s1600-h/clip_image002%5B7%5D%5B3%5D.jpg"><img style="border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" title="" border="0" alt="" src="http://lh6.ggpht.com/_qUu3JnHZeXU/SldiUiL0XjI/AAAAAAAAARU/WwE7k3CoZrE/clip_image002%5B7%5D_thumb%5B1%5D.jpg?imgmax=800" width="667" height="475" /></a></div> <p></p> <p>Now let’s look at more detail for the Decreases for the current period – already with some of the intermediate levels of the DWB structure visible:</p> <p></p> <div style="border-bottom: 0px solid; text-align: left; border-left: 0px solid; background-color: #a0ffff; padding-left: 4px; width: 392px; padding-right: 4px; font-family: arial; height: 560px; color: #000000; font-size: 12px; overflow: auto; border-top: 0px solid; border-right: 0px solid; padding-top: 4px"><a href="http://lh4.ggpht.com/_qUu3JnHZeXU/SldiVxU95BI/AAAAAAAAARY/jdrj4exrzZ4/s1600-h/clip_image004%5B7%5D%5B5%5D.jpg"><img style="border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" title="" border="0" alt="" src="http://lh3.ggpht.com/_qUu3JnHZeXU/SldiXEL3XLI/AAAAAAAAARc/B8g_m2VPqmQ/clip_image004%5B7%5D_thumb%5B3%5D.jpg?imgmax=800" width="674" height="525" /></a></div> <p></p> <p align="justify">Here we can see the two main sub-categories of <i>Basic Decreases</i>, the <i>Essentials</i> and <i>Responsibilities</i> with their next, lower-level sub-categories.</p> <p align="justify">We can of course keep on drilling down to see more and more detail, right down to individual financial transactions.</p> <p align="justify">The power of this structure and the resulting figures for some reporting period mean that we now have a basis for quite detailed decision-making for the future.</p> <p align="justify">The whole concept behind DWB accounting is towards achieving the best possible balance of personal or household finances and hence, achieving a better life within the prevailing constraints.</p> <p align="justify">By this, we want to get a proper balance across all the categories of expenses. We want to avoid spending excessively in some areas to the detriment of spending in other areas. By ensuring that we spend proportionately in all areas, the implication is that we should experience a better overall life since we should be obtaining the benefits and rewards of all the many categories of purchased produce, items and activities that make up the typical, day-to-day lifetime experience.</p> <p align="justify">The DWBS figures enable us to search for balance and as we are seeing, dynamically alter how we want this balance to look for the future.</p> <p align="justify">This will always be in order to obtain the best possible balance within the prevailing constraints. These constraints as we have seen are essentially the increases, as income, together with any existing debt that needs to be reduced and any new requirement to accumulate particular amounts as savings for short to medium-term financial priorities – e.g. that car replacement.</p> <p align="justify">After that, the priorities are first, to make sure that for the Decreases, care is taken of the <i>Basics</i> in terms of both the <i>Essentials</i> (food, clothing, accommodation, utilities, etc.) and the <i>Responsibilities</i> that we all experience - such as taxes, household obligations, professional expenses, garden maintenance, etc.</p> <p align="justify">Next, at the Discretionary category of Decreases we should ensure that we have equitable and balanced expenditure across the <i>Nice-to-Have’s</i> of <i>Holidays</i>, <i>Leisure and Entertainment</i>, and <i>Hobbies</i>; as well as the all-important, <i>Investment for the Future</i> (IFF).</p> <p align="justify">With the likelihood of an ever-inadequate future pension, it is even more important that everyone makes their own adequate additional provision for the future. This means ensuring that appropriate amounts are stored away or invested on a regular basis and it is common knowledge that the earlier the start is made, the easier the process and the greater the future pension or provision for the future is likely to be.</p> <p align="justify">DWB addresses amounts to save but specialist advice would be required on the choice of investments and how best to benefit from such investment in practise.</p> <p align="justify">As ‘balancing’ decisions are made at the higher levels of the structure, it will then be necessary to go to the lower-level sub-categories to determine what more detailed changes need to be made at these lower levels and below, by balancing in more detail, in order to achieve the balance envisaged by the top-level decisions.</p> <p align="justify">As we have begun to see, it turns out to be an iterative process where difficulties might be discovered in achieving the required balance at the lowest levels. This usually implies a return to the intermediate or top levels for possible further redistribution across the sub-categories, or even to go back to the overview-level to accept and to readjust those amounts accordingly. This is because these first-cut high-level targets might now appear unachievable in practice when balancing at all levels has been attempted.</p> <p align="justify">Understandably, you cannot try to achieve the impossible. Your desired balance within all the levels have to match the likely Increases. Of course you might well conclude that you need more qualifications and a better job to achieve the lifestyle to which you aspire! This is just another feature of the visibility on your finances provided by the DWB accounting model.</p> <p align="justify"><b>BUDGETS </b></p> <p align="justify">In general, what we are trying to do is to work out what we would like the future figures at the end of some period, to look like. Budgets are lists of figures or targets for financial activity, most often for expenditure, and will be most useful if these figures can estimate target amounts at varying future points – say 3-months, 6-months, 9-months and on to the end-of-year, 12 months ahead.</p> <p align="justify">The main by-product of the new structured, dynamic balancing tool is a set of budget amounts for every sub-category of the DWB structure, at all of the required, future 3-month quarterly points.</p> <p align="justify">Obviously for a home or domestic situation, we do not want to overdo things by trying to control everything in too much detail so it will be important for users to select for actual control purposes, just the figures for the sub-categories for budgetary control that have the most impact. By this, we need to concentrate on making decisions on trying to reign-in spending in areas that we find are in most need of cutbacks or for re-balance.</p> <p align="justify">We also need to try to control areas where there is an element of flexibility or choice to make it possible to actually achieve the implied future changes through corresponding changes in spending patterns (with appropriate self-control and discipline!). This might involve deliberate decisions to cut back on some utilities, car usage, food costs, luxuries and so on.</p> <p align="justify">Let’s now look at some of the lower levels of the balancing process. There are four levels of balancing available with DWB to be used as needed and not every sub-category of Decreases will be expanded to be balanced in detail at the level in which it lies:</p> <p align="justify">Overview level</p> <p align="justify">Top level</p> <p align="justify">Intermediate level</p> <p align="justify">and Low or Bottom level</p> <p align="justify">We have so far looked at the Overview level where those general decisions were made in regard to likely future Increases and the desired distribution and amounts of future Decreases at the major category level.</p> <p align="justify">The next three levels only address Decreases as there is very little more to be said or controlled at the lower level, DWB sub-categories for Increases.</p> <p align="justify">Here is the balancing tool being used at the Top level, for Decreases:</p> <p align="justify">At this Top level below the Overview-level, we examine the past amounts spent and the distributions across the <i>Basic</i> sub-categories of <i>Essentials</i> and <i>Responsibilities</i>, and the <i>Discretionary</i> sub-categories of <i>Nice-to-Have</i>, <i>Investment for the Future</i> (IFF), <i>Luxuries</i> and a catch-all of <i>Miscellaneous Disposals</i>; for example we may have decided next year that a major gift is to be made, perhaps for a forthcoming wedding.</p> <p align="justify">Here is an example of the results of Intermediate-level balancing:</p> <p></p> <div style="border-bottom: 0px solid; text-align: left; border-left: 0px solid; background-color: #a0ffff; padding-left: 4px; width: 396px; padding-right: 4px; font-family: arial; height: 661px; color: #000000; font-size: 12px; overflow: auto; border-top: 0px solid; border-right: 0px solid; padding-top: 4px"><a href="http://lh3.ggpht.com/_qUu3JnHZeXU/SldiXyRAptI/AAAAAAAAARg/B4Wc1S7sbeM/s1600-h/DWB%20Bal%20Interm%2001%5B4%5D.jpg"><img style="border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" title="" border="0" alt="" src="http://lh6.ggpht.com/_qUu3JnHZeXU/SldiZpHYxmI/AAAAAAAAARk/1FNn1WevuAI/DWB%20Bal%20Interm%2001_thumb%5B2%5D.jpg?imgmax=800" width="877" height="625" /></a></div> <p></p> <p align="justify">At the Intermediate level, we begin to try to achieve a balance within certain of the sub-categories that we balanced at the Top level. For example, for the Essentials category, we try to achieve a balanced spread of planned decreases for the sub-categories comprising Essentials (Utilities, Food & Drink, Clothing & Shoes, Personal Transport expenses and Health) that equals the value selected for Essentials at the higher (Top) level.</p> <p align="justify">At the lower levels, only a few and appropriate sub-categories would be subject to detailed balancing. These could include Utilities and Transport from Basic/ Essentials, and Leisure and Entertainment, and Hobbies from Discretionary/ Nice-to-Have, because these are areas which are more amenable to detailed control over the coming period, through active expenditure control.</p> <p align="justify">This screen shot illustrates the sliders used to balance the <i>Utilities</i> and <i>Transport</i> expenses sub-categories of the <i>Essentials</i> sub-category of the <i>Basic</i> decreases:</p> <p></p> <div style="border-bottom: 0px solid; text-align: left; border-left: 0px solid; background-color: #a0ffff; padding-left: 4px; width: 396px; padding-right: 4px; font-family: arial; height: 603px; color: #000000; font-size: 12px; overflow: auto; border-top: 0px solid; border-right: 0px solid; padding-top: 4px"><a href="http://lh3.ggpht.com/_qUu3JnHZeXU/SldiakHF8wI/AAAAAAAAARo/1pOpdy_CvNs/s1600-h/clip_image002%5B9%5D%5B4%5D.jpg"><img style="border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" title="clip_image002[9]" border="0" alt="clip_image002[9]" src="http://lh4.ggpht.com/_qUu3JnHZeXU/Sldib82JSTI/AAAAAAAAARs/U2__A6rFXsA/clip_image002%5B9%5D_thumb%5B2%5D.jpg?imgmax=800" width="679" height="566" /></a></div> <p></p> <p align="justify">The starting points for decision-making and hence budget preparation regarding future financial activity vary from a start-up position where no previous figures are held, right through to the start of a new period (financial or calendar year perhaps) where all the figures for the previous period have been retained. This is the situation we have been looking at above.</p> <p align="justify">Intermediate between these two extremes will be the situation where some figures for the previous quarter(s) perhaps or where a particular number of days have elapsed since data accumulation first started.</p> <p align="justify">Where part-period figures are held, they can be scaled-up by the tool to the end of the current period. In this way although not completely accurate, we can see how, based on figures to-date, we might be likely to ‘do’ by the end-of-period if nothing changed.</p> <p align="justify">A budget produced from these figures will be more meaningful than one produced from a complete guess. Obviously as time goes by and more figures are accumulated, a new budget creation exercise will benefit from less scaling-up and therefore more accurate, likely target figures for the remaining time to the end of the current period.</p> <p align="justify">The balancing process can be extremely quick to complete and considering that it would only need to be undertaken periodically, at say 3-monthly intervals, it is hardly a demanding overhead.</p> <p align="justify">Here are the budget results obtained after balancing has been completed. It shows sample budget figures available for whatever purpose the user wishes:</p> <p></p> <p></p> <div style="border-bottom: 0px solid; text-align: left; border-left: 0px solid; background-color: #a0ffff; padding-left: 4px; width: 393px; padding-right: 4px; font-family: arial; height: 867px; color: #000000; font-size: 12px; overflow: auto; border-top: 0px solid; border-right: 0px solid; padding-top: 4px"><a href="http://lh5.ggpht.com/_qUu3JnHZeXU/Sldicqk3cXI/AAAAAAAAARw/ph_XLEtXGSY/s1600-h/DWB%20Bal%20Results%5B4%5D.jpg"><img style="border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" title="DWB Bal Results" border="0" alt="DWB Bal Results" src="http://lh6.ggpht.com/_qUu3JnHZeXU/SldiefB9qlI/AAAAAAAAAR0/1CVdHu-9Tfs/DWB%20Bal%20Results_thumb%5B2%5D.jpg?imgmax=800" width="592" height="833" /></a></div> <p></p> <p align="justify">Typically, selected values would be inserted into the user’s accounting package so that as time progresses, the actual figures accumulated could be compared to the pre-set budget quantities so that alarms would be triggered where deviations from the desired expenditure amounts were detected.</p> <p align="justify">Budgets could be set not only for categories of expenses, as decreases, but also for credit card balances to warn against exceeding pre-set debt limits. It would be pointless to save in order to cut down existing debt levels whilst incurring additional debt with over zealous credit card usage.</p> <p align="justify">By saving sets of planned budget settings based on this slider-based balancing process, comparisons can be undertaken in the future with this tool through monitoring. This is done by overlaying the budget figures with the actual recorded expenditure figures. If appropriate, a new budget can be created to provide new projected figures whenever needed. </p> <p align="justify"><b>MONITORING PROGRESS</b></p> <p align="justify">As we progress through the next financial period it will be helpful once budget figures are set, if we can see how we are doing in relation to those target figures. How you accomplish this will depend on the details of your accounting package but most good systems allow you to enter pre-set budget figures.</p> <p align="justify">By establishing intermediate check-points at those 3-monthly intervals perhaps, we will be able to determine if we are on-track, need to do better, or perhaps have done rather better than expected in some areas and hence have an opportunity to re-adjust our budget figures for the next interval by revising the budget creation exercise. In this way, areas that were proving difficult to keep to budget might be given more leeway from surpluses found in other areas so that the overall target might still be achieved with focussed re-planning along the way.</p> <p align="justify">Another version of the balancing tool can be used to assist the monitoring process and is not associated with any budgeting controls that may be available as part of the accounting package used. The two overlaid sets of bars in this monitoring chart enable comparison of a saved set of budget amounts with the actual state of real increases and decreases as accumulated in the accounts.</p> <p align="justify">Areas where attention will be needed will be obvious, either with the need for stricter adherence to the existing plan, or possibly a re-planning exercise leading to a modified set of budget figures for the remainder of the period.</p> <p align="justify">The next screenshots show the monitoring with budget figures including the quarter points (1, 2, 3 and 4) in blue with the corresponding actual figures below each blue bar, in green. Sliders are interspersed amongst the bars to facilitate dynamically changing the scales of the bars in groups, to make interpretation as easy as possible with the varied range of values to be displayed. The actual figures in these images are as-at the end of the First quarter so we would be looking for correspondence between budget and ‘Actuals’ at the ‘1’ in the blue budget bars.</p> <p></p> <div style="border-bottom: 0px solid; text-align: left; border-left: 0px solid; background-color: #a0ffff; padding-left: 4px; width: 390px; padding-right: 4px; font-family: arial; height: 1358px; color: #000000; font-size: 12px; overflow: auto; border-top: 0px solid; border-right: 0px solid; padding-top: 4px"><a href="http://lh5.ggpht.com/_qUu3JnHZeXU/SldifBMhfSI/AAAAAAAAAR4/31YCWgL0_z0/s1600-h/DWB%20Monitoring%2001%5B6%5D.jpg"><img style="border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" title="DWB Monitoring 01" border="0" alt="DWB Monitoring 01" src="http://lh6.ggpht.com/_qUu3JnHZeXU/SldihJZWN_I/AAAAAAAAAR8/2WLM8eISKA4/DWB%20Monitoring%2001_thumb%5B4%5D.jpg?imgmax=800" width="620" height="1321" /></a></div> <p align="justify">The only real concerns in this example which would require further investigation would be the high value for car maintenance in Personal Transport expenses which puts the Basic/Essentials, over-budget. Knowing about the finances, we would be aware that this was due to an unexpectedly high bill for car repairs!</p> <p align="justify">Another display not shown here is the Dashboard used to select the figures – previously saved results from the accounts, with or without scaling, for budget preparation; as well as the budgets and actual figures to be used for monitoring. </p> <p align="justify"><b>DEBT ADVICE</b></p> <p align="justify">Apart from its use for private individuals or for accountants responsible for the personal financial affairs of some of their clients, it is believed that these balancing and monitoring tools could also be extremely helpful for debt advisors.</p> <p align="justify">With knowledge of a client’s financial affairs, a client-budget could be relatively easily established by an advisor using the Balancing tool and readily available statistics about the typical distribution of household expenses.</p> <p align="justify">Particular emphasis would have to be given to putting aside appropriate amounts over a period for reducing the existing debt and balancing this with a plan for tailored, barebones living expenses. The situation could then be monitored by use of DWB accounting and the budget adjusted periodically, as needed by the advisor with client involvement, as time unfolds.</p> <p align="justify">Hopefully the client would see the benefits of this form of financial management so as to be able to continue using it for themselves to achieve a continuing and improved lifestyle once the debt had been cleared.</p> <p align="justify"><b>CONCLUDING THOUGHTS</b></p> <p align="justify">There is a real need for the eventual availability of integrated toolsets for personal and household financial management (aka accounting) including the concepts of the budgetary and monitoring support described here. They would preferably be available as online SaaS implementations, for the reasons given in my previous blog. With this, private individuals together with other finance professionals including accountants and debt advisors could be given the means, perhaps for the first time, to really have a chance to relatively easily and effectively gain and maintain control of the personal and household finances for themselves or their clients.</p> Nilgaihttp://www.blogger.com/profile/14912670556905736362noreply@blogger.com0tag:blogger.com,1999:blog-634486368075297184.post-39959467027172071462009-04-20T13:16:00.002+01:002009-04-20T14:19:27.398+01:00THE WAY-AHEAD FOR THE MANAGEMENT AND CONTROL OF PERSONAL FINANCES<div align="justify">This blog breaks the sequence of my on-going series of articles which is intended to provide summarised information about the material contained in my book ‘Accounting for a Better Life’, published by Troubador in 2007 – see <a href="http://www.dwba.co.uk/">www.dwba.co.uk</a> for further information.<br /><br />With the second anniversary of the book coming up in August 2009, I thought it might be of interest to put down some of my own ideas about the way-ahead for managing home and personal finances.<br /><br />By managing and controlling home finances, I am concentrating on the idea of the background activity of knowing all about the state of the finances of a household situation.<br /><br />From the early days when I started delving into managing my own personal finances, I always believed that this aspect of management was crucial to everything else that followed. The control aspect followed on from the basics of knowing what was going on in the present and how it might have changed from the past – so that there was a starting point for deciding if anything needed to be changed for the future. From this, it was a question of what needed to be changed, by how much and how to do it – and that is where the idea of maintaining the best possible balance came from in relation to a new focus to replace business profits.<br /><br />I also recognise that there is another very important aspect of financial management which is all about financial products needed by a household – mortgages, loans, insurance, investments and so on - which is what most personal finance websites throughout the world seem to concentrate on.<br /><br />I would say that management and control of home finances should be the pre-cursor to the selection and purchase of financial products so that affordability and that balance I mentioned can be best brought together.<br /><br />It will also be vital that proper, appropriate and continuing advice be sought about the type and the choice of particular financial products throughout life; but that is not the concern of this slant on financial management and control.<br /><br />Historically, most attempts at managing home finances have essentially been fairly <em>ad-</em><em>hoc</em> – say over the last ten years - until quite recently. Prior to the arrival of personal computing, virtually no one would consider keeping manual accounts for a home or personal domestic situation. At best, hand-written notes would be all that people might attempts in conjunction with bank statements relating to their account at the local bank, indeed if they had one.<br /><br />With the arrival of home computing, two products made a major (?) difference to the situation – spreadsheets and off-the-shelf personal accounting packages.<br /><br />Spreadsheets probably made the most impact as they were and are, relatively easy for the homesteader to understand and use. The main sorts of uses would have been bank account reconciliation and simple budgeting as well as for example, analysis of utilities (gas, electricity, water, telephone, etc.) consumption and expenditure.<br /><br />The accounting packages opened up more possibilities for those with some knowledge of accounting or for those with the necessary sense of responsibility to find out sufficient about accounting to ‘have a go’; and I suppose I fell into both of theses categories!<br /><br />These accounting packages (and there were and are a number of them still available) were what I think if as bare-bones packages. They arrived ‘empty’ and you could start creating individual accounts as you needed. They were essentially, single entry systems as opposed to business double entry systems and some tried to provide a move towards home accounting with some pre-set categories available for associating transactions with different forms of income or expenses - salary, food, car, holiday etc.<br /><br />Appreciating that business accounting must have much to offer for personal finances since it had evolved as ‘best of breed’ as the only and legally required way to manage business finances, I decided to follow this route and eventually came up with my new domestic accounting model with a new focus on what I called Domestic Well-Being (DWB). As a model it consisted of a structure for the transactions and associated reports that characterise domestic life – and more information about this can be found in my other blogs and at my website at <a href="http://www.dwba.co.uk/">www.dwba.co.uk</a> .<br /><br />In the years prior to publishing my book, I had quite by chance, chosen the Microsoft Money product on which to develop and first implement the new accounting model. As a bare bones package, this required that I get down to the intricacies of accounting in order to make it all work.<br /><br />It was because I found this quite complex that I decided that another approach was needed to address the aspects of accounting that I found difficult and that was going to make it possible for me and others in the future to have any chance of making personal accounting viable. This turned out to be the new naming convention for accounts that I created and associated with an extended version of the accounting equation. By putting more emphasis for transactions on the ‘From’ and ‘To’ an account in order to keep the accounting equation balanced, I was able to get away further away from debit and credit.<br /><br />Apart from their association with a bank account, I always found debit and credit extraordinarily difficult to visualise, especially for some of the more disparate accounts that might exist in a typical chart of accounts. I appreciate that accountants (like my son) have little difficulty with such concepts because they live and breathe debit and credit for over four years of their professional training; but that is not the same for <em>amateur</em> accountants who might be tempted to try to gain control of their own personal finances.<br /><br />The problem for these amateur accountants today is that they cannot avoid having to know something about accounting. For a start, they have to purchase an empty personal accounting package and then have to set it all up, creating the necessary accounts, categories, reports and so on. At least with the techniques associated with the new accounting model, understanding of the bookkeeping – entering of transactions – is now relatively easy to understand. [Those who chose to get hold of my book avoid all of this as the attached CD provides everything they need for the particular product that I used so that they can be up and running from day 1 – the details of the starting position can even be added later].<br /><br />There is an issue with the possible architectures for accounting packages which I discuss more fully on my website. Essentially, the association between the transactions and the components of the Domestic Well-Being structure is achieved by categorisation e.g. in Microsoft Money and by making a single entry system double-up as a double entry system, or by the more business oriented, nominal accounts approach, whereby a separate account is created for each category of income or expense. Two alternative approaches are therefore available but the single new model can be implemented on either of them. This shouldn't be an issue for the users but because the users have to become involved in implementation issues, some packages from this generation of accounting packages are distinctly, user unfriendly.<br /><br />Again, as described in more detail on my website, I discovered ‘Personal Accountz’ since publishing the book which is an example of a personal accounting package based on the use of double entry and nominal accounts. It is fantastically easy to create and move accounts around in the structure and with ‘grouping’, means that the DWB accounting model can be easily implemented, such that the Domestic Balance Sheet and the Domestic Well-Being Statement (DWBS) that replaces the business Trading and Profit & Loss accounts, is always as up-to-date as the last transaction entered.<br /><br />However both these solutions, with good graphics and the required reports are still <em>accounting systems</em> and users cannot avoid having to get to know a bare minimum about accounting. The advantage though is the tremendous visibility that is provided about the state of the financial affairs of a household or domestic situation; not only the current situation but with all the past records as a basis for on-going analysis in order to make decisions about how best to improve the situation. For this, budgets assume importance and some systems provide integrated budget capabilities with the ability to set warnings based on chosen levels of spending in selected categories with alarm bells as the limits are approached.<br /><br />Another feature of the new model is a set of new ratios or factors to replace the over 30 rations used in business accounting. These will be of little use to begin with, apart from internal comparison on a period-by period basis, as it will require the accumulation of a base of statistics so that householders can begin to compare their figures with those of others in a similar situation, rather similar to business <em>norms</em> for different business areas.<br /><br />What about the future? Well in the last few years, business accounting has and continues to experience a dramatic change towards online accounting. What does this mean? Well instead of buying an accounting package and having to set it all up and periodically update it as a new release is made available, the service is provided as <em>Software as a Service</em> (SaaS).<br /><br />The software is centrally managed, setup, backed up and recovered, and updated by the vendor as users subscribe to the available services. They can log-on from anywhere and access the various modules needed to conduct their business. Accounting is only one such service and a whole host of other business functions are typically provided such as stock, payroll, invoicing, Customer Relations Management (CRM), Enterprise Risk Management (ERM) and so on.<br /><br />Security is an important issue since business data is held centrally and requires absolute and guaranteed protection from unauthorised access as well as guaranteed online availability. Private individuals are likely to be even more wary of putting their personal financial data into the ether, or cloud as it is now known!<br /><br />At the time of writing there are some 30 vendors worldwide providing these SaaS business accounting services. Some of them as new start-ups’ have concentrated on removing or at least hiding some of the mystique of accounting so that non-accountant sole traders, consultants and small business owners can concentrate on managing the business rather than worry about the accounting itself. Others have tended to move existing standalone systems to the online environment and have not perhaps utilised the potential power of modern software to take advantage of online interactivity.<br /><br />Online SaaS has to be the next move for home and personal accounting!<br /><br />I am aware of only one online personal finance system today, called Mint. It is a US site and is currently only available in the USA. Its emphasis appears to be the making available of individuals’ financial data so that third party vendors can offer financial products to users – not for me!<br /><br />The debt crisis in the UK with trillions owed by households and the credit crunch whereby life generally has become extremely difficult for many people, has important implications if its resolution or easing is ever to be possible.<br /><br />It all comes down to personal responsibility. Those who already have a sense of responsibility have no doubt tried to do something about avoiding or at least keeping debt to manageable amounts. This must involve doing whatever is possible to know about the state of personal finances. If easier ways of gaining control of personal finances became available, then it is most likely that responsible people would start to try to use them in increasing numbers.<br /><br />How many responsible people are there in the world? I don’t know but surely it is far more than one might imagine – hundreds of thousands, millions – but most likely, a very large number.<br /><br />There is a niche out there, waiting to be exploited!<br /><br />For the vendors of online accounting, it would appear to be a relatively simple exercise to produce online versions of their business systems tailored for home and personal use. It would mostly be an exercise of cutting back existing features such as those for sales and purchasing (the heart of business accounting) with a new emphasis on income and expenses. Focus has to move from nominal account numbers to account names and some name changes for the reports. Graphics together with <em>drill-down</em> would assume more importance since the nature of a structure, such as the DWB structure, cries out for this form of summarisation.<br /><br />For ease of use and with no auditing responsibility, data entry has to childishly simple with emphasis on re-use of previously entered information. Online access to bank statements means that statements from many UK banks can now be downloaded in well recognised formats. I still choose a semi-automated approach in order that I can remain in control of the data in my system and be aware of all the changes that have occurred; it is still necessary for me to associate some of the transactions to categories in the DWB structure but for many of them, the software can make the association so I simply click on ‘accept’ for each one. Bookkeeping is a relatively quick and easy process and might take up to a couple of hours a month – trivial compared to the visibility achieved on the state of home finances.<br /><br />A first evolution of online accounting for domestic use would probably still look quite like an accounting system but could and should be very workable for the end-user subscriber. Publicity and advertising will be an important area here in order to attract people to this powerful new capability as an online service. Bookkeeping could be done on the way, to and from work.<br /><br />A next generation service should evolve to a home financial management system. Accounts <em>per se</em> would be well hidden and the user would only have to relate to concepts such as assignment of expenses to categories and decisions on quantities of appreciation or depreciation on certain assets, perhaps once a year.<br /><br />The focus would be on the results in terms of the reports, comparisons and graphical interpretations from the underlying data. The results of the decision making process would imply support for budgeting which is in need of improvements and could perhaps be linked to some independent systems now already available.<br /><br />In time, it would be appropriate to see domestic accounting recognised by the accounting authorities as a branch of accounting in its own right, alongside business accounting.<br /><br />The management of personal finance is so important today in the light of the debt crisis that there ought to be some degree of national, social responsibility alongside personal responsibility, to help people minimise their exposure to debt as well as assist with its management and reduction where it has already occurred.<br /><br />The users of online personal accounting would not only be the end-user homesteader, but accountants looking after the private finances of their clients. Links to Income tax filing would also be a useful adjunct.<br /><br />People, both voluntary and from business concerns, responsible for analysis and advice on financial hardship, particularly debt recovery would represent a further group of potential users.<br /><br />There would be new opportunities in education, both at the school and college levels, as well as for adult education.<br /><br />In conclusion, I believe that the time has arrived for personal accounting to be brought out in the open in comparison to its somewhat chequered and hidden past where it has been the province of the enthusiastic and dedicated amateur – witness the forums associated with the various personal accounting software packages.<br /><br />Families throughout the world should be the beneficiaries with hopefully, better and more contented lives based on the income available to them. </div>Nilgaihttp://www.blogger.com/profile/14912670556905736362noreply@blogger.com0tag:blogger.com,1999:blog-634486368075297184.post-67501147880875930552009-02-03T09:28:00.057+00:002009-04-15T15:34:03.224+01:00DWB ACCOUNTING - SOME THEORY<div class="nobrtable"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8dofQQGfzgTeqaC3AVVgGF0S8hPvFIzdV24RBixVjPmeNmz_BVvUJfYQDnf8z0NDlHFCexu817u22T-rJ4S3YoyOUciDaX8Reg1IjnwYxCM9Ni4UExeNOOC07SWn5oEk0XMIgPid56e0/s1600-h/DWBAlogo03.jpg"><img style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; FLOAT: left; HEIGHT: 140px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5324905272863091442" border="0" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8dofQQGfzgTeqaC3AVVgGF0S8hPvFIzdV24RBixVjPmeNmz_BVvUJfYQDnf8z0NDlHFCexu817u22T-rJ4S3YoyOUciDaX8Reg1IjnwYxCM9Ni4UExeNOOC07SWn5oEk0XMIgPid56e0/s320/DWBAlogo03.jpg" /></a><br /></div><br /><div align="justify"><br /><br /><br /><br /><br /><br /><br /> </div><div align="justify"><br>We had a first look at Reports in my last blog so it is now appropriate to take a step back and talk a little bit about some accounting theory in the context of the Domestic Well-Being (DWB) accounting model.<br /><br />You might find the theory a little intimidating at first but it is here for those who wish to really understand what is going on and to make it easier to atually do. I will summarise the important parts at the end and all you will actually need in order to start doing this sort of accounting is to be able to look at and interpret some fun, memory joggers which tie the theory together!<br /><br /><br />In developing the DWB accounting model, my overriding aims were focus and simplicity. My earlier attempts to use business accounting methods for personal accounting had proven very unsatisfactory because I realised that the business accounting model had the wrong focus for home use and it was all too difficult to understand and to do, on a day-to-day basis.<br /><br /><br />Since I wanted to run my accounts in a continuing way, year after year, and I wanted to capture the complete household financial picture, I decided that business style double-entry techniques were important (more about that in a moment) and had to be a part of the new accounting model. Because of this, I needed to find an easy way to remember which accounts to use whenever transactions were entered into the accounting system and which side of an individual account did each entry go; and was it an addition, or a subtraction?<br /><br />So the DWBA model includes not only the new focus and methods to make it all work, but a set of corresponding supporting techniques including some new terminology, naming-conventions and some memory joggers. In this blog, space and time permits only an overview of the theory but the intention is to provide sufficient to convince you that there might really be some mileage in further investigating DWB accounting.<br /><br />Business accounting is plagued with words that only accountants probably ever feel really comfortable with. Words like capital, equity, asset, liability, debit, credit, income, expense and many more, are not easy to take on board. Partly because we hear some of them in everyday life, particularly debit and credit, in contexts which we may not truly understand, we can end up with an incorrect idea of what some of these concepts really mean. In fact we cannot avoid all the words but with some targeted theory, I have found that it can be made to make a little more sense and with some aide-memoires, it becomes quite ease to understand what is going on behind the scenes in accounting.<br /><br />The adapted background theory which I think is sufficient to meet that first aim, of simplifying accounting, covers the following features:<br /></div><br /><br /><div align="justify"><br /><ul><br /><br /><li>1. Accounts and overarching <em>types</em> – Asset and Liability </li><br /><br /><ul><br /><br /><li>a. An Account</li><br /><br /><li>b. Asset Accounts</li><br /><br /><li>c. Liability Accounts</li><br /></ul><br /><br /><li>2. Scope of Accounts </li><br /><br /><li>3. Double Entry concepts</li><br /><br /><li>4. Domestic Accounting Equation (DAE)</li><br /><br /><li>5. Working Accounts</li><br /><br /><li>6. Categorising Changes</li><br /><br /><li>7. Account Naming Conventions</li><br /><br /><li>8. Making Use of the Account Types</li><br /><br /><li>9. Keeping the Accounting Balance</li><br /><br /><li>10. Conquer From/To, Debit/Credit and Income/Expense Relationships</li><br /><br /><li>11. Bookkeeping and Categorising Information</li><br /><br /><li>12. Summary</li><br /></ul></div><br /><br /><div align="justify"><br /><br /><strong>1. Overarching Account <em>Types</em></strong><br /><br /><strong>a. An Account</strong><br /><br />Starting at the beginning, we should realise that a single account is simply a time-sequenced list of changes to some particular area of financial activity going on in the background. An account will normally have an account title for the area of interest, such as cash, current bank, savings, car loan, main residence and so on. It is important to realise that an account is always associated with some sort of value.<br /><br />This value may be for money as ‘liquid’ cash or for amounts stored in current or different bank savings accounts. An account may also be created to provide a record of the changing value of the home, car or a holiday, where the monetary value of the designated object might change over time, perhaps with gains, losses or appreciation and depreciation.<br /><br />The transactions making up or entered into an account will address changes to the amount of its balance and each typically includes a date, a description and/or a reference to the activity causing the change, as well as the actual value in a separate column according to whether it is an increase or decrease of any amount held in the account. Computerised accounts will often include a running total to show the changing balance of the account after each transaction is applied.<br /><br />Printed account extracts will usually also include the opening and closing dates and balances; these can be made obvious in the accounts by including zero-balance transactions at the start and end dates of a period with descriptions such as Opening Bal b/f (brought forward) or Closing Bal c/f (carried forward).<br /><br />This simplified account in our accounts for a current account at a bank with a minimum number of column headings, shows just a few entries before the end of the UK financial year on the 5th of April.<br /><br /><br /><br /><a href="http://picasaweb.google.com/lh/photo/FVlbQmH8ullsFG_9tXyQwQ?authkey=ARYFTm1bZ14&feat=embedwebsite"><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjX6s91ld-crCmycz5JUl_GvMJUOwysBcaVv_lhNxmRUhnI-Hr70xC4-uYvKYvvvldcD6BuLBjFPC9ODavxR5UctEi-mAhDA81WbCuUdQPYjM5az5y9qM5gMYrpxpo0KLWkQfb6Nk8o9xU/s400/current%20ac1c.jpg" /></a><br /><br /><br />It is important to distinguish between increasing and decreasing amounts of change to an account compared to the corresponding changing value in the account because these will not always be the same, as we will see shortly.<br /><br /><strong>b. Asset Accounts</strong><br /><br />The balance of an asset <em>type</em> account where positive amounts represents positive value is typically used to accumulate financial information about cash deposits, a house, a car or an investment. We will see later that asset accounts can also be used for some special information in so-called Working and Quasi-asset accounts. That salary increase above of £2,300 is known as a debit or income entry because debit always means increasing value whilst in contrast, a decrease in value –for the gas or mortgage payments above – is known as a credit or expense entry.<br /><br />The words income and expense here are types of entry related to value (like debit and credit) and should not be confused with salary as a particular form of income or the purchase of food as a particular sort of expense. Quite obviously, you will enter income received into one of your bank accounts into an appropriate asset <em>type</em> account in your own accounts, with a debit or income type entry. This is because it represents increasing value from the point of view of the entity which your set of accounts represent, which is you as an individual person or your household, if that is your situation.<br /><br />To summarise our first rule; debit or income in an account represents increased or positive value whilst credit or expense represents decreased or negative value.<br /><br /><strong>c. Liability Accounts</strong><br /><br />Another example of an account shows some entries for one of our credit cards. All the entries look basically similar to the last account except for one essential fact:<br /><br /><a href="http://picasaweb.google.com/lh/photo/5SDSA2gAvdDFnQvR2iNafg?authkey=ARYFTm1bZ14&feat=embedwebsite"><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhT9kvSe56wRDttrmQ0MDnlA4jSH9Y44kBKES-InZwpK1hWG8xdavcLys0ZSR5zm6-gG4ljiQCzHI7ARE5-N14JjHepOGIy9TTzjbcOE3UiqfMSXI_11_j6vGuqlpfA7urInrRACcBfPoE/s400/liability%20ac1c.jpg" /></a><br />The essential difference is that this account represents financial activity relating to things purchased ‘on credit’ so it is all about value owed to someone or some organisation - a liability.<br /><br />The Opening Balance of (+) £2,500 in this credit card account shows that we had already obtained credit of this amount relating to objects that we had purchased previously, less any payments we had already made to reduce our debt or amount owed. We have an outstanding charge of £2,500 by being given credit of this amount by the credit card company. We are in indebted to that organisation with a debt of £2,500 and we are one of its creditors who owe the card company this same amount.<br /><br />As we make more payments ‘on credit’ we can see that in this <em>type</em> of account they are increasing positive numbers representing amounts of charge, more liability and therefore less overall value in our account. These additions go to increase the amount that we will have to pay back to the card company at some future time. Each of these transactions representing increases in liability implies less value and by the accounting rule, is therefore a credit or expense entry into that account.<br /><br />A payment from our bank (a credit or expense entry from an asset type account) as one of those repayments is shown as a decrease in this Credit Card liability <em>type</em> account because the amount that we owe to the credit card company is reduced by this (positive) amount. Our liability is in effect, reduced by £2,300 and so this entry is a debit or income entry in a liability <em>type</em> account, signifying an increase of value because it reduced a liability – a double negative in mathematics! This is an example of a proper credit and debit entry pairing which as we will see, characterises double entry and maintains value in the whole collection of our accounts.<br /><br />This account is an example of a liability account. A liability account is used to store amounts of value that are owed to someone or some entity and even to another account in our so-called, book of accounts and so they use positive numbers to represent negative value. Their positive balance and any increases (credit/expenses) represent negative value since more of a liability means that more is owed to whatever the account represents. Likewise, decreases or reductions in its positive balance imply less liability and therefore more value (debits/income). I refer back to that comment that I made about distinguishing between increasing amounts and values. In liability <em>type</em> accounts, more implies less! More of an amount in this account (an increase) represents less value (a credit or expense) whilst reduced amounts imply less liability and therefore more value.<br /><br />Having introduced these two examples of different <em>types</em> of account, it is very important to distinguish between what I call overarching <em>types</em> of account versus the use to which these two <em>types</em> of account may be put, usually indicated in the account name.<br /><br />So we have two overarching <em>types</em> of account or tools in our accounting toolbox. An asset <em>type</em> account is simply an account where a positive balance means positive value whilst in contrast, a liability <em>type</em> account is one where a positive balance implies a negative value. I shall come back to this distinction shortly when we begin to see what <em>types</em> of accounts are used for what purpose in an accounting system.<br /><br /><strong>2. Scope of Accounts</strong><br /><br />We use accounting and accounts to model financial activity. In business where large organisations may have multiple departments or divisions, we can recognise that accounting may be applied to company-wide financial activity or separately, for the different sub-divisions. An accounting system therefore has a concept of scope or a boundary which determines the extent of financial activity to which it applies.<br /><br />Similarly for a home, personal or domestic household situation, we can envisage that the financial activity could be considered from different levels of scale. Typically, a user of a home accounting software package might limit its scope to cheque reconciliation where the extent of the activity would be restricted to just that of the current account at a bank. For this, a single account would suffice and could be achieved with a personal accounting package or even a simple spreadsheet table. Where a family might have a current account as well as one or more savings accounts and some credit card accounts, they may wish to extend their accounting activities to include all these aspects of their home finances but still not address their complete financial picture.<br /><br />We therefore have a concept of an accounting system which addresses differing scopes of all the financial activity within some specified scope or boundary.<br /><br />In business, be it for a sub-division or subject area such as human resources – wages, salaries, taxes, national insurance, pensions, etc. accounting legally has to cover all aspects of financial activity within the specified scope; and all activity has to be covered, even it is subdivided into separate compartments with corresponding scopes and separate accounting systems.<br /><br />Back to the domestic situation, financial activity obviously includes the bank and credit card arrangements we have already discussed, including all the increases and decreases being applied to them. However we mostly have some household assets (not thinking of asset accounts yet) such as a home, one or more cars, furnishings, appliances, maybe a caravan or time-share or even a boat as well as financial investments such as assurances, stocks, bonds and so on. We think of an asset, as opposed to expendables, as something having some residual value which maybe realisable so that we can get some money back in exchange for its disposal. We may never know that value until we achieve a sale but at least we can estimate its value as it changes over time, either up or down, in order to know the estimated and changing value of all our assets.<br /><br />Another side of personal financial life relates to mortgages and loans, as well as those credit charges we already looked at. These are our personal liabilities or debts of different types.<br /><br />Our day-to-day outgoings on food, utilities, health, transport, education, holidays, pensions, etc. actually represent the largest and most influential part of our household financial activity. This represents the bulk of the dynamics or changing part of this activity in contrast to the slow-to-change, relatively static personal assets and liabilities.<br /><br />To really manage and control our personal or household financial activity we need to look at the complete financial picture. This means that we need to understand and know about both the static and dynamic parts of our domestic financial activity. This is because proper control of our finances has to consider all its aspects, our assets, our personal liabilities and the constant changes made up of the monies we receive and the constant stream of outgoings or decreases which characterise our domestic life.<br /><br />The scope of our interest should be total and likewise the scope of the accounting system we build to model it should be all-embracing. Instead of just a few accounts to model our banks and credit cards, we should try to model all our changing assets, our obligations to others as mortgage debts, loans and charges, as well as our day-to-day increases and decreases required to stay alive.<br /><br />By doing this in a way that is tailored to the characteristics of our household financial activity – such as by use of the DWB accounting model – we can obtain the visibility on it all to effectively gain and achieve the control we seek.<br /><br /><strong>3. Double Entry Concepts</strong><br /><br />Double entry accounting is a simple concept having two implications:<br />It represents a total view of the financial activity within some designated scope or boundary that defines our accounting system.<br /><br />It utilises two postings or entries in our accounts for each financial transaction to ensure that the complete set of accounts remain in financial and mathematical balance.<br /><br />The total view requires that an extra account is created and maintained to store the total worth of the financial system or area of interest within the designated scope.<br /><br />Double entries in bookkeeping where transactions are entered into the accounts require that value is ‘conserved’ by matching pairs of debit (Dr. gain) and credit (Cr. loss) postings. An increase in value must always be matched in the accounts by a corresponding decrease in value. We will see in a moment how this pairing of postings or entries is achieved where I emphasis 'From' and 'To' rather than Dr/Cr.<br /><br /><strong>4. Domestic Accounting Equation (DAE)</strong><br /><br />I find that double entry accounting can best be explained by the use of the ‘accounting equation’ which I have adapted for domestic use.<br /><br />Hopefully, accepting that the balances of all the accounts representing the finances of an entity must somehow be related, schooldays remind us that related numbers is what equations are all about! Where perhaps 20 numbers represent the 20 balances of these required accounts, we should be able to relate these 20 numbers meaningfully in an equation in some way.<br /><br />The traditional Accounting Equation shows the financial relationship as:<br /><br />Assets - Liabilities = Capital value or Shareholders or Owners equity.<br /><br />The basic version of the Domestic Accounting Equation (DAE) is:<br /><br />Assets - Liabilities = Domestic Wealth<br /><br />In order to manage our finances with double entry accounts, we will need to create accounts for all our assets using those asset <em>type</em> accounts as well as sufficient accounts of the liability <em>type</em> for all our different personal debts or liabilities, plus at least one more account for our Domestic Wealth. So in terms of the Domestic Accounting Equation (DAE), we can say where a/c stands for account:<br /><br />All personal Asset a/c balances (of the asset type) - All personal Liability a/c balances (of the debt type) = Domestic Wealth a/c balance<br /><br />Thinking about it, the value of domestic wealth represented by the value of the assets less the value of all the personal debts is owed to the eventual beneficiaries of the household or individual’s estate. After death, the executors have to pay off the debts from the assets and what is left, the Domestic Wealth, will be shared out amongst the beneficiaries - so the domestic wealth is a sort of liability from the viewpoint of the entity represented by the set or book of accounts, an individual or a householder.<br /><br />The domestic wealth is owed to the beneficiaries and therefore should logically reside in a liability <em>type</em> account. I decided that I needed to distinguish between personal liabilities and liabilities of the estate so that is why I defined ‘quasi’ liability accounts of the liability <em>type</em> to be used to hold the Domestic Wealth and some other associated accounts to handle changes to Domestic Wealth. Compared to true or personal liabilities held in current and long-term liability accounts which can be considered as 'bad' liabilities, Domestic Wealth can be considered a 'good' liability and so the set of quasi-liability accounts in DWBA distinguishes or highlights these good liabilities - the greater the positive amounts or the less of the corresponding value in them, the better!<br /><br />Considering changes over some period, increases from salary or growth imply more wealth so logically; those increases should also be stored in some sort of liability <em>type</em> account, alongside the Domestic Wealth account. So we also need one of these quasi-liability accounts for accumulating domestic increases.<br /><br />Conversely, decreasing amounts resulting from expenses such as on food, drink, hobbies and holidays, as well as depreciation and losses, should also logically be stored in a separate account. They mostly come from decreases in either one or other of our asset <em>type</em> bank accounts or one of our credit card liability <em>type</em> accounts. To store decreases of positive amounts of assets or positive amounts of credit, we need an account to accumulate these positive numbers and an asset <em>type</em> account is the appropriate sort of account to use. Remember that a decrease in a bank current asset account (credit) can be matched by an increase in another asset account (debit) or a decrease in a liability account (also a debit – creating more value).<br /><br />If we choose a liability <em>type</em> account for accumulating these decreases, the two sorts of credit entries from bank or credit card accounts would have to matched with debit entries in our new account; this implies minus entries so we would end up with an increasingly large negative balance. This of course makes sense because a positive balance in a liability type account implies negative value so a negative balance actually represents positive value, which is what we are trying to accumulate! Of the two types of account, it makes more sense to use an account where a positive balance relates to what we are trying to capture so we will use a special asset <em>type</em> account for these domestic decreases.<br /><br />These accumulating decreases in amounts and value are a sort of '<em>bad</em>' asset because they detract from assets available to fund true debts to be passed on to the eventual beneficiaries. Similarly to '<em>good</em>' liabilities, they should therefore most appropriately be stored in a new style, what I call quasi-asset account, just for accumulating decreases to domestic wealth.<br /><br />Having now justified the need for two new accounts for holding domestic increases and decreases over a period, one quasi-liability and one quasi-asset account, it makes sense to have a Domestic Changes account where the balances of these Increases and Decreases accounts can be transferred at the end of each period and accumulated to show us over time, for each period, whether we have an overall increase or decrease as our Total Domestic Change (TDC).<br /><br />Compared to the profit or losses of business accounting, I needed new words to signify a Domestic Surplus or a Domestic Deficit in the TDC. So at the end of an accounting period in a domestic scenario, we would hope to find in our Domestic Changes account, a ‘Domplus’ but sometimes, we maybe be left with a ‘Domicit’.<br /><br />Adding accounts for accumulating changes over a period, putting asset <em>type</em> accounts on the left and liability <em>type</em> accounts on the right, the DAE is now:<br /><br />All Asset a/c bals + Decr a/c bal = All Debt a/c bals + Incr a/c bal + DW a/c bal<br /><br />By keeping the increases and decreases together on one side of the equation, we can see how the changes are derived – note Increases as an asset <em>type</em> a/c is now temporarily on the liabilities side but correctly shown as negative:<br /><br />All Asset a/c bals = All Debt a/c bals + (Incr a/c bal - Decr a/c bal) + DW a/c bal<br /><br />Combining the Increases less the Decreases as Change, we have:<br /><br />All Asset a/c bals = All Debt a/c bals + Changes a/c bal + DW a/c bal<br /><br />In fact we will have accounts present at all times for increases, decreases and changes but we will accumulate changes only as increases or decreases during an accounting period and at the end of period, transfer balances from these two to the Changes account.<br /><br />The Increases and Decreases accounts will now have zero balances for the start of the next period and then change as increases and decreases are made during the next period; similarly the balance in the Domestic Changes account is zero throughout the period whilst all the changes are being accumulated and will receive the balances of the Increase and Decreases accounts at the end-of-period when they will then revert to zero ready for the start of the next period.<br /><br />The balance of the Domestic Changes account will eventually be transferred to the Domestic Wealth account at the end of a period as an increase (for a Domplus) or a decrease (for a Domicit), leaving the balance of the Changes account at zero, also ready for the start of the next period. This summarizes most of the end-of-period accounting activities even though we are looking at theory!<br /><br />By passing the balances of the Increase and Decreases accounts through the Changes account and on to the Domestic Wealth account, we will accumulate a continuous record of the TDC over the years. This will be of use in our on-going analysis processes for comparisons with past figures.<br /><br />Now that we see why the domestic Increases, Decrease, Changes and Wealth accounts need to co-exist to facilitate these transfer of amounts amongst them all, let’s have a look at the DAE with all the new asset and liability <em>type</em> accounts returned back to the left and right hand sides, respectively:<br /><br />All Asset a/c bals + Decreases a/c bal = All Debt a/c bals + Increases a/c bal + Changes a/c bal + DW a/c bal<br /><br />You will appreciate that if we start off with a balanced equation meaning a balanced set of account balances across the whole equation, any single entry made to any account must disturb the balance. It will only be with balanced pairs of entries into two accounts for each single transaction that balance can be retained.<br /><br />For example, if we start off setting up the domestic accounts for someone with £40,000 in their bank and a personal loan of £7,000 towards a car purchase with no other assets or liabilities, we would need just four accounts where the two pairs of double entries in the first two rows of the four accounts establish the opening balance:<br /><br /><br /><div style="BORDER-BOTTOM: 0px solid; TEXT-ALIGN: left; BORDER-LEFT: 0px solid; PADDING-BOTTOM: 4px; BACKGROUND-COLOR: #a0ffff; PADDING-LEFT: 4px; WIDTH: 400px; PADDING-RIGHT: 4px; FONT-FAMILY: arial; HEIGHT: 320px; COLOR: #000000; FONT-SIZE: 12px; OVERFLOW: auto; BORDER-TOP: 0px solid; BORDER-RIGHT: 0px solid; PADDING-TOP: 4px"><br /><a href="http://picasaweb.google.com/lh/photo/YLOtm0s7nAx2RhbKd3QJRQ?authkey=ARYFTm1bZ14&feat=embedwebsite"><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkZimtHjqgvv9HKWBbAQ1xuIl_vFZQTTysKVLVDoAddZoc0D0KCZ6vTWvVuNfsSO3IzqmIXrPBwTHwZwmFIpH5QegEf-ISEeQ2NOOCFgyWdjTs11BC2hJedCtCwVaQo6TBz3IX3RdAxVc/s800/startup1c.jpg" /></a><br /></div><br />Double entries of £40,000 in cash balanced by the same amount in Domestic Wealth in the first entry below, with a liability established in the Loan account of £7,000 also balanced by the same amount in the bank account in the second entry, illustrate the idea of maintaining balance by ensuring that a debit posting is always matched by a credit posting in each transaction entered.<br /><br />Remember that an increase in an asset <em>type</em> account (AC Bank) as a debit entry (more value) is matched by an increase in a liability <em>type</em> account (LQ Domestic Wealth) which is a credit entry of less value.<br /><br />The headings ‘Increase’ and ‘Decrease’ above the two columns in each account refer to increasing or decreasing amounts in the account. This of course is not always the same as the increasing or decreasing value involved. The total of the asset account balances after the first two rows is £47,000 and the total of the two liability accounts for these same two rows is also £47,000 so balance is established. The entries with balances carried forward (c/f) and the associated totals below them are the way used to summarise the situation in an account at any point in order to derive the new balance, shown as balance brought forward (b/f).<br /><br />The car purchase in the third row using the loan of £7,000 and £3,000 of owner’s cash results in an exchange of value of £10,000 between two asset accounts – the Bank and Car accounts - with no change in Domestic Wealth. The credit entry in the Bank account of a reduced amount and value is matched by the debit entry of increased amount and value in the Car account which happens to be another asset <em>type</em> account (see later for more information of debit, credit and the account name pre-fixes).<br /><br />The concept of ‘From’ and ‘To’ in relation to entries or postings in accounts for transactions is associated with value and not amounts. This car purchase transaction in the third row illustrates a flow from the Bank account to the Car account since value is transferred From and To these accounts, respectively.<br /><br />The second row involving liability accounts is not quite so easy to visualise. Here, the Bank receives increased value whilst our account for the Loan company shows a charge or debt that we owe to that company and so the positive amount of £7,000 added to this liability account represents a decrease in value in that account. So the complete transaction represents a transfer of value ‘From’ the loan company (the credit entry) ‘To’ our bank (the debit entry), both as viewed in our accounts from our point of view. It is of interest that in each of the Bank’s and the Loan Company’s accounts, these views would be reversed but we are not actually interested in that!<br /><br />Also note that in the account at the ‘From’ side, the amount entered has to be under the Increases column because this is a liability <em>type</em> account with a credit entry where an increase in amount means a decrease in value.<br /><br />Where we have two entries that both involve liability accounts we need to be really clear about what is going on in order to be sure in which direction the flow is going and the relationship in the accounts of the ‘From’ and ‘To’; always remember that the change in value provides the clue and the flow is always from a Credit entry (less value) to a Debit entry (more value). For example (and you will see more about this shortly), accumulated increases from salary will be accumulated over a period in a liability <em>type</em> account called the LQ Domestic Increases account (we are not considering categorisation yet in this example).<br /><br />Here it is in the accounts:<br /><br /><p></p><br /><div style="BORDER-BOTTOM: 0px solid; TEXT-ALIGN: left; BORDER-LEFT: 0px solid; BACKGROUND-COLOR: #a0ffff; PADDING-LEFT: 4px; WIDTH: 400px; PADDING-RIGHT: 4px; FONT-FAMILY: arial; HEIGHT: 320px; COLOR: #000000; FONT-SIZE: 12px; OVERFLOW: auto; BORDER-TOP: 0px solid; BORDER-RIGHT: 0px solid; PADDING-TOP: 4px"><br /><a href="http://picasaweb.google.com/lh/photo/Yauw-IaePyQ8hPQV8GgoTw?authkey=ARYFTm1bZ14&feat=embedwebsite"><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgI4F1Dxtz7enwJFZM7s9TvOyd2MzpF8gZMK49THoqYzNHdGxxGCQ12A170wYmnkUFSGZD1vMLwnRP7A7z95M48_tzj-XEeiksg3jJk6dq9I1OELMXQeiuNA6-pxGpSeHPlduqQU85rm0M/s800/2liabilities1c.jpg" /></a></div><br /><br />At the end of a period, the balance in the LQ Domestic Increases account will have to be transferred into another liability <em>type</em> account called the LQ Domestic Changes account. So the implied negative value of the positive balance in the Increases account has to be moved with a decrease, equal to that balance amount (a debit), ‘To’ the Changes account to increase its balance accordingly. Because these accounts are both liability <em>type</em> accounts, we do not really want to move a negative amount so the transaction flow ought to be a positive amount ‘From’ the Changes account (with a credit entry in the Increases column) ‘To’ the Increases account (with a debit entry in the Decreases column). It appears to be the reverse of what we intended but it’s all because liability type accounts hold implied negative amounts. If we did move a negative quantity ‘From’ the Increases account (a debit – negative in the Increases column is less liability so more value) ‘To’ the Changes account (a credit – negative in the Decreases column is more liability so less value) everything would be mathematically correct but it wouldn’t look so good in the accounts with negative quantities being transferred!<br /><br />To summarise, if we tried to transfer directly from the Increases account to the Changes account we would find that we needed to transfer a negative amount to make it come out right.<br /><br />Doing it the ‘correct’ way which is not so intuitive, the flow will be entered as an amount under the Increases column as more liability, less value and therefore a credit or expense entry on the ‘From’ side of the transaction in the LQ Domestic Changes account.<br /><br />Conversely, the actual amount of the balance in the LQ Domestic Increases account on the ‘To’ side of the transaction will have to be entered under the Decreases Column in this account as less liability and therefore more value, reducing the balance to zero – a debit or income entry.<br /><br /><strong>5. Working Accounts</strong><br /><br />In that last transaction for purchasing a car for £1,000 it is not actually obvious that this amount was made up of both the proceeds of a loan and some cash. By splitting the transaction into parts and introducing another sort of account to mediate the activity, we can make it quite clear in the accounts how it all fits together.<br /><br />We will introduce what I call a Working Account of the asset <em>type</em> for Asset Acquisitions. Our three transactions involving cash are a receipt of the loan amount of £700, a payment for the car of £300 and an increase in value of the car account from zero to £1,000.<br /><br /><br /><div style="BORDER-BOTTOM: 0px solid; TEXT-ALIGN: left; BORDER-LEFT: 0px solid; BACKGROUND-COLOR: #a0ffff; PADDING-LEFT: 4px; WIDTH: 400px; PADDING-RIGHT: 4px; FONT-FAMILY: arial; HEIGHT: 370px; COLOR: #000000; FONT-SIZE: 12px; OVERFLOW: auto; BORDER-TOP: 0px solid; BORDER-RIGHT: 0px solid; PADDING-TOP: 4px" authkey="'ARYFTm1bZ14&feat="><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjCoKHQ6eWuOT10GE7GTmLMUvCacaUi5UMOiSZ6MUgQLD4KyzNjskYPS7owr88vbVdOhpndkdWuh3vd0LVG7GeOQye2eSf4liC0x_f22skLqJTQJIeVMFLH8D0zZJ9LvG6Xd2JEW7Et9ZY/s800/AssetAcqu1c.jpg" /><br /></div><br /><br /><br />In this Asset Acquisitions account we have accumulated in just one place, all the financial facts about this car purchase. We will be able to go back at any later time and be able to see that we needed a loan of £7,000 and cash of £3,000 in order to buy that car for £10,000.<br /><br />If at a later time, we managed to sell the car for £8,000 let’s look at how we can use another sort of Working Account to mediate the necessary transactions. This time we will introduce an Asset Disposals account and we will make it a liability <em>type</em> Working Account.<br /><br />The book value of the car is £10,000. This means that the value of the car in our (account) books is £10,000. Its value might have been reduced somewhat in our accounts if we had realised that its value had probably depreciated over the couple of years since we bought it and we had adjusted the books accordingly.<br /><br />The fact that we have only obtained £8,000 for the car means that we have effectively lost £2,000 and so we must take care to ensure that our Domestic Wealth is adjusted in our accounts to reflect this fact.<br /><br />If we think about what has happened, we have received an amount of £8,000 and we have disposed of a car which had a value of £10,000 in our accounts. We therefore need to show these facts in our Asset Disposals account. We need to move £8,000 from our Bank account to the Asset Disposals account and we also need to cancel the value of the car by a similar move of £10,000 from our car account to the Asset Disposal account. Let’s do this and see what the situation looks like:<br /><br /><br /><div style="BORDER-BOTTOM: 0px solid; TEXT-ALIGN: left; BORDER-LEFT: 0px solid; BACKGROUND-COLOR: #a0ffff; PADDING-LEFT: 4px; WIDTH: 400px; PADDING-RIGHT: 4px; FONT-FAMILY: arial; HEIGHT: 340px; COLOR: #000000; FONT-SIZE: 12px; OVERFLOW: auto; BORDER-TOP: 0px solid; BORDER-RIGHT: 0px solid; PADDING-TOP: 4px"><a href="http://picasaweb.google.com/lh/photo/Pz7gl__bNLU3GW36VeXaBQ?authkey=ARYFTm1bZ14&feat=embedwebsite"><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhXlZyEe0jcZFfcPhG4PMZlOAV83fsjRhXQm94OuMWv0Fu57h63o-6AU1S2W8nTbxolBqyemHi5vNhVx1yAAWYHLMykFWMYdxqS7bEqdtRM5hqBXihRCgDbW-SVMollC-KzZm2vR0O_VkY/s800/AssetDisp1c.jpg" /></a><br /></div><br /><br />After these first two entries, we can see that there is a balance of £2,000 in the Asset Disposals account which represents the loss on the disposal. The third and last transaction is therefore a double entry to pass this balance as a loss to the Domestic Decreases account for later transfer to reduce the Domestic Wealth account balance by a similar amount.<br /><br />Give a thought at this point to the ‘To’ and ‘From’ relationship – Is the £2,000 being transferred From the LW Asset Disposal account To the LQ Domestic Decreases account, or vice versa?<br /><br />Well the liability of £2,000 in the LW Asset Disposal account is to be reduced to zero. A reduction in a liability implies increased value so we will need a debit entry in this LW Asset Disposal account. An increase of £2,000 in the LQ Asset Disposal liability <em>type</em> account means even less value over and above what may have already been there so that implies a credit entry. We have said that the From/To direction of value is ‘From’ credit ‘To’ debit so this transaction will be From LQ Domestic Decreases To LW Asset Disposals. Again, this does not seem intuitive but it is all because of the fact that we are transferring negative value around!<br /><br />The actual entries will be £2,000 under the Increases column in the LQ Domestic Decreases account for the ‘From’ credit/expense entry and a corresponding entry of £2,000 under the Decreases column for the ‘To’ entry in the LW Asset Disposals debit/income account.<br /><br />We need to summarise these liability-to-liability transfers by saying that the transfer direction of ‘From’ and ‘To’ is the opposite direction to the perceived movement of positive amounts!<br /><br />There is also the outstanding loan to be repaid back to the Loan Company although we will not complete that here.<br /><br />To summarise at this point, Working accounts are those temporary accounts of both asset and liability <em>types</em> for mediating certain transactions and their balances will be cleared to zero either after each batch of mediation work, or finally at the end of each accounting period. This is done by transferring their balances to other non-working accounts, as appropriate. There are a fair number of uses for working accounts, particularly for keeping track of gains, losses, appreciation and depreciation.<br /><br /><strong>6. Categorizing Changes</strong><br /><br />Controlling finances also requires that we categorize those changes, the increases and decreases, in order to keep track of them all in accordance with the DWB structure. At this point, we come to some differences in approach for implementation of this categorization, depending to the architecture of the accounting package on which we might choose to use to implement our accounts.<br /><br />Microsoft Money has a categorization capability in-built which is ready-made to implement such a task and is fully described in the book ‘Accounting for a Better Life’. In summary, we can categorize each first half posting of a double entry in accordance with the DWB structure and at the end of a period, determine through a query, the separate totals of all the accumulated categorized increases and decreases. We do not complete the second half of these categorized entries at this time so the accounts are temporarily, unbalanced. We then have to make one final entry with each of these totals, into each of the Domestic Categorized Increases and Domestic Categorized Decreases accounts, respectively. These two entries of these two totals thus complete the double entry process to re-establish financial and mathematical balance throughout the accounts. There could also be some un-categorized increases and decreases so there will be separate accounts for these changes. As before, all the balances from the various sorts of changes accounts end up as a Domplus or Domicit, to be transferred to the Domestic Wealth account.<br /><br />Personal Accountz uses an architecture more similar to business accounting packages whereby so-called nominal accounts can be established to achieve the necessary categorization. It uses a journal concept for entering transactions whereby the ‘From’ and ‘To’ accounts have to be identified at entry time. With this method, if it were appropriate to keep separate track of income received by the husband and wife of the household for example, accounts such as ‘His Income’ and ‘Her Income’ would be setup and debit entries for money received into the Bank account would have to be matched with credit entries in the His or Her accounts, as appropriate. Now the question is what type of account would be appropriate for such nominal accounts – Asset or Liability?<br /><br />Well we have already identified a quasi style liability account <em>type</em> for Domestic Increases so it would seem appropriate that we would need further quasi-liability account <em>types</em> for His and Her income categorization together with all the other income categories that make up part of the DWB structure. These are given the account name prefix of LI for Liability (nominal) Increases in DWB accounting. Similarly for the categorization of decreases, asset <em>type</em> nominal accounts will be required and will receive account name prefixes of AD for Asset (nominal) Decreases.<br /><br />Because categorization and the DWB structure is at the core of DWB accounting, I decided to separately distinguish the two sorts of nominal accounts that I needed for categorizing increases and decreases as Asset Decreases and Liability Increases accounts, respectively. This provides a way to separately identify them with those account name prefixes which we shall look at soon. Any balances accumulated in these nominal accounts during an accounting period have to be transferred to those single Domestic Decreases and Domestic Increases accounts at the end of the period as we discussed previously.<br /><br />So to complete the picture, here is a more complete view of the DAE for packages such as Personal Acountz using nominal accounts:<br /><br />All Asset a/c bals + Asset Working a/c bals + Nominal Decreases a/c bals + Decreases a/c bal = All Debt a/c bals + Liability Working a/c bals + Nominal Increases a/c bals + Increases a/c bal + Changes a/c bal + DW a/c bal<br /><br />For packages such a Microsoft Money based on categorization tags, here is the typical DAE:<br /><br />All Asset a/c bals + Asset Working a/c bals + Categorized Decreases a/c bals + Decreases a/c bal = All Debt a/c bals + Liability Working a/c bals + Caategorized Increases a/c bals + Increases a/c bal + Changes a/c bal + DW a/c bal<br /><br /><br /><strong>7. Account naming conventions</strong><br /><br />You will appreciate now that with all these different sorts of accounts making use of the two fundamental overarching account <em>types</em>, it may not always be obvious from an account’s name what it represents in terms of asset or liability <em>type</em> and its actual use – personal asset or liability, good, bad, nominal or working; or where it lies in the DAE.<br /><br />I resolved this challenge by designating a two-character prefix to be added to every account name.<br /><br />All DWBA account names therefore are pre-fixed with a two-character group.<br /><br /><br /><ul><br /><br /><li>The first character is either A or L to signify Asset or Liability <em>type</em>.</li><br /><br /><li>The second character qualifies the first character to indicate usage, as follows:</li></ul><br /><br /><br /><style type="text/css">.nobrtable br { display: none }</style><br /><br /><br /><br /><div class="nobrtable"><br /><br /><table style="TEXT-ALIGN: left "border="1"><br /><br /><colgroup width="50%"> </colgroup><br /><br /><colgroup width="50%"> </colgroup><br /><br /><caption><br /><p><strong><span style="font-size:130%;">For Asset <em>Type</em> Accounts (A)</span></strong></p><br /><p><strong><span style="font-size:130%;"><br /></span></strong></p></caption><span style="font-size:130%;"><br /></span><br /><tbody><span style="font-size:130%;"><br /></span><br /><tr><span style="font-size:130%;"><br /></span><br /><td><strong><span style="font-size:130%;">Account Usage</span></strong></td><br /><td><strong><span style="font-size:130%;">Account Name Pre-fix</span></strong></td><br /></tr><br /><br /><tr><br /><br /><td><span style="font-size:130%;">C - Current Asset </span></td><br /><td><span style="font-size:130%;">AC</span></td></tr><br /><br /><span style="font-size:130%;"></span><br /><br /><tr><br /><span style="font-size:130%;"></span><br /><br /><td><span style="font-size:130%;">F - Fixed Asset </span></td><br /><span style="font-size:130%;"></span><br /><br /><td><span style="font-size:130%;">AF</span></td><br /><span style="font-size:130%;"></span></tr><br /><br /><tr><br /><td><span style="font-size:130%;">I - Investment Asset </span></td><br /><span style="font-size:130%;"></span><br /><br /><td><span style="font-size:130%;">AI</span></td><br /><span style="font-size:130%;"></span></tr><br /><br /><span style="font-size:130%;"><br /></span><br /><tr><span style="font-size:130%;"><br /></span><br /><td><span style="font-size:130%;">E – Nominal Expenses </span></td><span style="font-size:130%;"><br /></span><br /><td><span style="font-size:130%;">AE</span></td><span style="font-size:130%;"><br /></span></tr><span style="font-size:130%;"><br /></span><br /><tr><span style="font-size:130%;"><br /></span><br /><td><span style="font-size:130%;">W - Working Asset </span></td><span style="font-size:130%;"><br /></span><br /><td><span style="font-size:130%;">AW</span></td><span style="font-size:130%;"><br /></span></tr><span style="font-size:130%;"><br /></span><br /><tr><span style="font-size:130%;"><br /></span><br /><td><span style="font-size:130%;">Q - Quasi Asset </span></td><span style="font-size:130%;"><br /></span><br /><td><span style="font-size:130%;">AQ</span></td></tr><span style="font-size:130%;"><br /></span><br /><br /><tr><br /><td></td><br /><td></td></tr><br /></tbody><span style="font-size:130%;"><br /></span><br /></table><br /></div><br /><br /><div class="nobrtable"><br /><br /><table style="TEXT-ALIGN: left" border="1"><br /><br /><colgroup width="50%"> </colgroup><br /><br /><colgroup width="50%"> </colgroup><br /><caption><br /><p><strong><span style="font-size:130%;">For Liability <em>Type</em> Accounts (L)</span></strong></p><br /><p><strong><span style="font-size:130%;"><br /></span></strong></p></caption><span style="font-size:130%;"><br /></span><br /><tbody><span style="font-size:130%;"><br /></span><br /><tr><span style="font-size:130%;"><br /></span><br /><td><strong><span style="font-size:130%;">Account Usage</span></strong></td><br /><td><strong><span style="font-size:130%;">Account Name Pre-fix</span></strong></td><br /></tr><br /><br /><tr><br /><br /><td><span style="font-size:130%;">C - Current Liability</span></td><span style="font-size:130%;"><br /></span><br /><td><span style="font-size:130%;">LC</span></td><span style="font-size:130%;"><br /></span></tr><span style="font-size:130%;"><br /></span><br /><tr><span style="font-size:130%;"><br /></span><br /><td><span style="font-size:130%;">L - Long-term Liability </span></td><span style="font-size:130%;"><br /></span><br /><td><span style="font-size:130%;">LL</span></td><span style="font-size:130%;"><br /></span></tr><span style="font-size:130%;"><br /></span><br /><tr><span style="font-size:130%;"><br /></span><br /><td><span style="font-size:130%;">I – Nominal Increases </span></td><span style="font-size:130%;"><br /></span><br /><td><span style="font-size:130%;">LI</span></td><span style="font-size:130%;"><br /></span></tr><span style="font-size:130%;"><br /></span><br /><tr><span style="font-size:130%;"><br /></span><br /><td><span style="font-size:130%;">W - Working Liability </span></td><span style="font-size:130%;"><br /></span><br /><td><span style="font-size:130%;">LW</span></td><span style="font-size:130%;"><br /></span></tr><span style="font-size:130%;"><br /></span><br /><tr><span style="font-size:130%;"><br /></span><br /><td><span style="font-size:130%;">Q - Quasi Liability </span></td><span style="font-size:130%;"><br /></span><br /><td><span style="font-size:130%;">LQ</span></td></tr><br /><br /><tr><br /><td></td><br /><td></td></tr><br /></tbody><br /></table><br /></div><br /><br />The result of adding all these other accounts and with their prefixes to the DAE is:<br /><br />Asset <em>type</em> a/c bals (AC, AF, AI, AE, AW & AQ) = Liability <em>type</em> a/c bals (LC, LL, LI, LW & LQ)<br /><br />Just by looking at any individual account name, its prefix will tell us where it lies in the DAE in relation to all the other individual accounts in our accounts book. [I used to use AD for nominal asset decreases but now prefer AE - asset expenses - as <em>bad</em> assets that are eventually transferred to AQ (also <em>bad</em>) asset accounts].<br /><br />This will be very helpful when transactions have to be entered during bookkeeping since it will now be very easy to work out allowed pairings of accounts to achieve total balance and to determine which are the ‘FROM’ and ‘TO’ associations. I found it impossible to visualise debit and credit for strange account names which are not easily associated with true assets and liabilities.<br /><br />It is quite informative at this point to look at a Trial Balance for a book of accounts. A Trial Balance simply lists all the balances of all the accounts in the accounting system on some particular date. Based on the sample accounts we looked at in the previous blog on Reports, here is a Trial Balance (for two years to show changes) from a set of accounts maintained in Microsoft Money.<br /><br /><br /><div style="BORDER-BOTTOM: 0px solid; TEXT-ALIGN: left; BORDER-LEFT: 0px solid; BACKGROUND-COLOR: #a0ffff; PADDING-LEFT: 4px; WIDTH: 400px; PADDING-RIGHT: 4px; FONT-FAMILY: arial; HEIGHT: 600px; COLOR: #000000; FONT-SIZE: 12px; OVERFLOW: auto; BORDER-TOP: 0px solid; BORDER-RIGHT: 0px solid; PADDING-TOP: 4px"><a href="http://picasaweb.google.com/lh/photo/Nr8BF_0steskIt8T3FjKig?authkey=ARYFTm1bZ14&feat=embedwebsite"><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEifXClxKh8i_bXA4B2DchS20diMXQSLpqLHvAgrG0AzmTkE3M8fc1JK90jh4OZtaDpV9ZpRrHf7vEBQpoeIC0NLRkfEBkr6dcxrSGl3wdvCz9aXqob1-DsnMVr5hHJbp4MYcRcONLO2KbE/s800/TBassets1c.jpg" /></a></div><br /><br /><br /><br /><div style="BORDER-BOTTOM: 0px solid; TEXT-ALIGN: left; BORDER-LEFT: 0px solid; BACKGROUND-COLOR: #a0ffff; PADDING-LEFT: 4px; WIDTH: 400px; PADDING-RIGHT: 4px; FONT-FAMILY: arial; HEIGHT: 400px; COLOR: #000000; FONT-SIZE: 12px; OVERFLOW: auto; BORDER-TOP: 0px solid; BORDER-RIGHT: 0px solid; PADDING-TOP: 4px" authkey="'ARYFTm1bZ14&feat="><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg21EorFNL7mDTJn-8_y1pQMBko3o3bhexICbfQ2fYU3QWdFgq8p_F983p7b0HtSgmgRRm8mQ2bMszv9cMsb1C9ud_zqoPz3djmLXSh0XRz-knPLfS8JtKXp9sPpSUk3KXnZte5dtkPBTQ/s800/TBLiab1c.jpg" /><br /></div><br /><br />You will see how the prefixes enable you to visualize the groupings of accounts as depicted in the last version of the DAE, above. At the time when this trial balance was taken for a set of accounts implemented in Microsoft Money, the Categorized increases and decreases had already been transferred into the LQ Domestic Changes account where you see that value of £25,900 for Total Domestic Change that we saw in the discussion on the Domestic Balance Sheet (DBS) and the Domestic Well-Being Statement (DWBS).<br /><br />In fact with a little mental agility, you can fairly easily picture from this Trial Balance how the DAE, the DBS and the DWBS are inter-related and how they complement each other.<br /><br />Of course what does not stand out in this architecture is the categorization of the increases and decreases because they are stored in the category tags associated with individual entries made in the accounts and can only be exposed using a Microsoft query.<br /><br />In contrast, a list of the account balances in Personal Accountz displays all the same balances we see in a MSMoney Trial Balance less the Categorized Increases and Decreases accounts, as well as the DWB structure of all the changes as exposed by the balances of all the nominal accounts.<br /><br /><br /><br /><div style="BORDER-BOTTOM: 0px solid; TEXT-ALIGN: left; BORDER-LEFT: 0px solid; BACKGROUND-COLOR: #a0ffff; PADDING-LEFT: 4px; WIDTH: 400px; PADDING-RIGHT: 4px; FONT-FAMILY: arial; HEIGHT: 460px; COLOR: #000000; FONT-SIZE: 12px; OVERFLOW: auto; BORDER-TOP: 0px solid; BORDER-RIGHT: 0px solid; PADDING-TOP: 4px" authkey="'ARYFTm1bZ14&feat="><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgUw0bU-xMxfRmL4pE1biMvikwluv2n8lPn4clA_CWqNtUfoYWkQ0WDHoToBlsExksA6S1jXY-1vdjkV31Kjz-rIBRoES_G77whxE462TFOgduvh-1OU8KFXcZSTjIBKV0kKJ3CSBw8u7A/s800/Raw%20accz%203ac.jpg" /><br /></div><br /><br /><br /><strong>8. Making Use of the Account Types</strong><br /><br />In our discussion on account name prefixes, you became aware of the various groupings of accounts that are available and may have to be created in a household accounting system, according to a particular household’s needs.<br /><br />Another powerful capability in Personal Accountz is the ability to define hierarchical groupings of accounts whereby special Group accounts are able to subsume the contents of lower-level accounts defined in the overall account structure.<br /><br />For those using Personal Accountz, as we add accounts to match the DWB structure, they can be grouped in a similar ‘structure of accounts’ within this accounting package and you saw some of this structure in a previous blog on Reports.<br /><br />Using Microsoft Money, many fewer accounts will be required as the categorization of increases and decreases is achieved using those category tags that will be created and used to match entries to the DWB structure.<br /><br /><strong>9. Keeping the Accounting Balance</strong><br /><br />The next important issue is to be able to relate transactions to pairs of accounts.<br /><br />In Personal Accountz this will be done with the ‘From’ and ‘To’ associations whilst in MSMoney, it will be done by ensuring that entry amounts are entered into the correct account columns for each of the two participating double-entry account entries. Having said this, the majority of the entries will actually only require the first-half of each double entry but this must still be entered in the correct column; and it is the income or expense association to columns that makes this easy, in conjunction with an appropriate memory jogger!<br /><br />In order to assist the understanding of double entry postings, mathematics state that an equation must be kept in balance by having any addition or reduction in an account on one side of the equation, balanced by an equal addition or reduction in an account on the other side of the equation, respectively. Alternatively, any increase in an account on one side must be balanced by an equal decrease in some other account on the same side of the equation.<br /><br />In this context, we are talking about increases and decreases in value which you will remember will not always be identical with the increases or decreases in the amounts entered into the accounts, especially for any liability type accounts involved in the pairings.<br /><br />The accounting rule states that in order to maintain value, a credit entry must always be balanced by a debit entry and so with a little pencil and paper doodling, it is easy to see that when these two rules are combined, for two entries on the asset side of the equation, a debit (increase in an asset) must be matched by a credit (decrease in an asset) or, for two entries on the liabilities side, a debit (decrease in a liability) must be matched by a credit (increase in a liability). Similarly, an increase on the asset side requiring a compensating increase on the liability side must equate to a debit entry (increase in an asset amount) and a credit entry (increase in a liability amount). Conversely, a decrease in value on the asset side as a credit entry (decrease in an asset amount) must be matched with a debit entry on the liability side (decrease in a liability amount).<br /><br />Portraying this in relation to the DAE, we can easily visualize the four allowable combinations:<br /><br /><br /><br /><div style="BORDER-BOTTOM: 0px solid; TEXT-ALIGN: left; BORDER-LEFT: 0px solid; BACKGROUND-COLOR: #a0ffff; PADDING-LEFT: 4px; WIDTH: 400px; PADDING-RIGHT: 4px; FONT-FAMILY: arial; HEIGHT: 430px; COLOR: #000000; FONT-SIZE: 12px; OVERFLOW: auto; BORDER-TOP: 0px solid; BORDER-RIGHT: 0px solid; PADDING-TOP: 4px"><br /><a href="http://picasaweb.google.com/lh/photo/bfdDHf_QQu8MMcvqwXRZwQ?authkey=ARYFTm1bZ14&feat=embedwebsite"><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjYPNwBY_2TTUvclTF4hQjcgYRvk-1_FRaMHoPnOvLTEjOR20391_KSCHlGzXV0rfc2-0Ie-LzqBpCtyiCKyMGdjW7h-h0uyZNg_AiM_T7dm996Ey6OCvaxsQFIbVPdy1NhDIkGOtpFP1o/s800/Allowed%20FROM%20TOc.jpg" /></a><br /></div><br /><br />Now let’s look at some examples of each type of transaction where we include the effect on the individual account, in terms of:<br /><br /><br /><ul><br /><br /><li>‘To’ or ‘From’ (an account)</li><br /><br /><li>Debit or Credit posting</li><br /><br /><li>Increase (Plus) or Decrease (Minus) – the amount entered in the appropriate account column</li><br /><br /><li>Income or Expense category (Microsoft Money style)</li><br /></ul><br /><br /><dl><br /><br /><dt><strong>1. a. Buy a car – Asset increase and Asset decrease:</strong><br /><br /><br /><dd>AC Bank (From/Cr/Decrease/Expense) AF Car (To/Dr/Increase/Income)<br /><br /><dd><br /><br /><br /><dt><strong>1. b. Buy Food with cash – Asset decrease and Asset decrease:</strong><br /><br /><br /><dd>AC Bank (From/Cr/Decrease/Expense) AE Food & Drink (To/Dr/Increase/Income<br /><br /><dd><br /><br /><dd>[AE Food is a <em>bad</em> asset type ‘nominal’ account used for categorization of expenses. At the end of a period its balance will be transferred to the AQ Decreases account and then onwards to the LQ DC and LQ DW accounts]<br /><br /><dd><br /><br /><dt><strong>2. a. Receive a Loan - Asset increase and Liability Increase:</strong><br /><br /><br /><dd>AC Bank (To/Dr/Increase/Income) LL Loan Co (From/Cr/Increase/Expense)<br /><br /><dd><br /><br /><dt><strong>2. b. Receive salary – Asset increase and Liability Increase:</strong><br /><br /><dd>AC Bank (To/Dr/Increase/Income) LI Salary (From/Cr/Increase/Expense)<br /><br /><dd><br /><br /><dd>[LI Salary is a <em>good</em> liability <em>type</em> ‘nominal’ account used for categorization of increases. At the end of a period its balance will be transferred to the LQ Increases account and then onwards to the LQ DC and LQ DW accounts]<br /><br /><dd><br /><br /><dt><strong>2. c. Buy Food with a credit card – Asset increase and Liability increase:)</strong><br /><br /><br /><dd>AE Food & Drink (To/Dr/Increase/Income) LC Visa CC (From/Cr/Increase/Expense)<br /><br /><dd><br /><br /><dt><strong>3. Make Payment to Credit Card Company – Asset decrease and Liability decrease:</strong><br /><br /><br /><dd>AC Bank (From/Cr/Decrease/Expense) LC Visa (To/Dr/Decrease/Income)<br /><br /><dd><br /><br /><dt><strong>4. Transfer Domestic Changes to Domestic Wealth – Liability increase and Liability decrease:</strong><br /><br /><br /><dd>LQ Dom Wealth (From/Cr/Increase/Expense ) LQ Dom Changes (To/Dr/Decrease/Income<br /><br /><dd><br /><br /><dd><br /></dd><br /></dl><br /><br /><strong>10. Conquer From/To, Debit/Credit, Income/Expense Relationships</strong><br /><br />I have a notoriously bad memory and I have always found that I need memory joggers to help me recall disparate facts such as those summarized in the examples above.<br /><br />For each of the combinations above, we have four components:<br /><br />From/To<br /><br />Dr/Cr<br /><br />Increase/Decrease of amounts<br /><br />Income/Expense<br /><br />Now depending upon the accounting package you use, not all of these will be relevant at the same time.<br /><br />For example if you use Microsoft Money with the DWB categorization method, you will be concerned with From/To and Income/Expense.<br /><br />Personal Accountz will likewise draw your attention to ‘From’/’To’and Increase and Decrease whilst Expense and Income will relate to the Left and Right columns of each account report.<br /><br />Dr/Cr is not really pertinent to either of these accounting packages but for those familiar with business accounting, Dr/Cr will be all important!<br /><br />Appreciating that not everyone may like my style of memory joggers, I submit them for your interest and as I find they work for me, I trust that they can help you too.<br /><br />They are made up of short phrases with an associated image to try to help recall them from memory (to begin with, put them on a sticker on your computer monitor!).<br /><br />Note that I use Plus in these memory joggers to represent increases of amounts and Minus for decreases of amounts in the appropriate account columns.<br /><br />So here are my four memory joggers in sequence:<br /><br /><dl></dl><br /><dl>From an Asset Account: <span style="font-size:130%;"><strong>Face Cream in Mexico</strong></span><br /><br /><a href="http://picasaweb.google.com/lh/photo/9ykBkp7EgAt_yY7ziu2IKw?authkey=ARYFTm1bZ14&feat=embedwebsite"><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiz08Otg6M5tByU10M0fErGELkjn0iPXAbEZX1SzBXYDAk0gO2yvnVYqwSpAI3Tfk_fGB1CDaYY90QTzTvRLCc2UkYZmMbrN_-jd6TSPGctcL69TxApH0GGz-Hmrzbq1gGfvMcjdIFzURA/s400/FaceCream1c.jpg" /></a><br /><br /><br /><span style="color:#ff6600;">F</span><span style="color:#33cc00;">A</span>ce <span style="color:#3366ff;">Cr</span>eam in <span style="color:#cc33cc;">M</span><span style="color:#ff0000;">Ex</span>ico<br /><br /><span style="color:#ff6600;">F</span><span style="color:#ff6600;">rom</span>/To <span style="color:#33cc00;">Asset</span>/Liab Dr/<span style="color:#3366ff;">Cr</span> Plus/<span style="color:#cc33cc;">Minus</span> Income/<span style="color:#ff0000;">Expens</span><span style="color:#ff0000;">e</span><br /><br /><br /><br /><br />To an Asset account: <span style="font-size:130%;"><strong>Toad plunking</strong></span> (along a road perhaps)</dl><br /><dl><br /><a href="http://picasaweb.google.com/lh/photo/dLV9z3Is774SMDOC7w8o0A?authkey=ARYFTm1bZ14&feat=embedwebsite"><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgM477E8yHvkTVkTQKLuY7OcroSmc7_jW6ok_7RgN3M9_LXePlJnRtV8_SC2Og-CNldceyHjeP0jKPkktV9y3TG_AJjouIUw7V6SuqE2kIaTtUvWs7xYzacNuYNkhK9A5qc4OD4q_V4D2c/s400/toad2c.jpg" /></a><br /><span style="color:#ff6600;">TO</span><span style="color:#33cc00;">A</span><span style="color:#33ccff;">D</span> <span style="color:#cc33cc;">PLU</span>nk<span style="color:#ff0000;">IN</span>g<br /><br />From/<span style="color:#ff6600;">TO</span> <span style="color:#33cc00;">Asset</span>/Liab <span style="color:#33ccff;">Dr</span>/Cr <span style="color:#cc33cc;">Plus</span>/Minus <span style="color:#ff0000;">Income</span>/Expense<br /><br /><br /><br /></dl><br /><dl></dl><br /><dl></dl><br /><dl></dl><br /><dl>From a Liability Account: <span style="font-size:130%;"><strong>From A Lily Complex</strong></span><br /><br /><br /><a href="http://picasaweb.google.com/lh/photo/qhg6JQp0g7KECd49Ng-j9A?authkey=ARYFTm1bZ14&feat=embedwebsite"><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgynJGlIJU3zOV1hqKYR6fpvusknhzpP1ivyCSL3oFK1CA08tj0YesnfHEiTx8UoFZ3eXqdTUWvxARwheQDYXtNMNhmcXZcCZy1DOplwPjoW8KyqdNmd5EW2ssULStc3vwg0wV1lB1tS1s/s400/lily3c.jpg" /></a><br /><br /><span style="color:#ff6600;">Fr</span>om a <span style="color:#33cc00;">LI</span>LY <span style="color:#33ccff;">C</span>om<span style="color:#cc33cc;">PL</span><span style="color:#ff0000;">Ex</span><br /><br /><span style="color:#ff6600;">From</span>/To Asset/<span style="color:#33cc00;">Liab</span> Dr/<span style="color:#33ccff;">Cr</span> <span style="color:#cc33cc;">Plus</span>/Minus Income/<span style="color:#ff0000;">Expense</span></dl><br /><dl><span style="color:#ff0000;"></span></dl><br /><dl><span style="color:#ff0000;"><br /></span></dl><br /><dl></dl><br /><dl></dl><br /><dl></dl><br /><dl></dl><br /><dl></dl><br /><dl></dl><br /><dl><br />To a Liability Account: <span style="font-size:130%;"><strong>Tilted Mink</strong></span><br /><br /><br /><a href="http://picasaweb.google.com/lh/photo/rLbhFwBqaMMKcMXAbbjJIw?authkey=ARYFTm1bZ14&feat=embedwebsite"><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgtc0Tu0OE-08kRfmLtmCreLU34yGoxx6q7Y0olWLWU9eVRz4s_B8SpQhR06ntsRFSn-HliI-lPam-7kAwRvWMS5Sv-Ld3iJPJD9i9PlCpkoDpxuBiAHbvm1vaBjuU2Tb0k_hQ7YUNQ1d8/s800/TiltedMink2c.jpg" /></a><br /><br /><br /><span style="color:#ff6600;">T</span>i<span style="color:#33cc00;">Lt</span>e<span style="color:#3366ff;">D</span> <span style="color:#cc33cc;">M</span><span style="color:#ff0000;">IN</span>k<br /><br />From/<span style="color:#ff6600;">TO</span> Asset/<span style="color:#33cc00;">Liab</span> <span style="color:#3366ff;">Dr</span>/Cr Plus/<span style="color:#cc33cc;">Minus</span> <span style="color:#ff0000;">Income</span>/Expense<br /><br /></dl><br /><dl><br /><br />In order to make use of these aides, we need to remember the four images and their associated mnemonic phrases and be able to derive the five embedded keywords from each of them.<br /><br />As always, practice makes perfect and once you start using them along with some accounts, it will very quickly become second nature.<br /><br />With most accounting, once you get going the great majority of the transactions to be entered will be repeats of ones that you have entered previously with just changes to the dates and amounts so you will hardly even have to remember all these details each time. Most accounting packages have some form of mechanism to recall previously entered transactions as a model for the next entry. Often it will be based on the payee or description text and regularly entered transactions, such as weekly, monthly, bi-monthly or annually payments can usually be stored ready for immediate recall and re-entry after editing.<br /><br />To begin with, you may well need reminding of the correct ‘From’ and To’ usage as well as which column of an account to use for the entry and whether it is supposed to be an increase or a decrease. This is where these memory joggers are invaluable.<br /><br />Another useful memory fact is that the two animals – the toad and the mink – are both associated with destination accounts, the To’s.<br /><br />I will mention again another memory jogger that I find useful which relates to both the Microsoft Money and the Personal Accountz layout of account columns in the order, Expense on the left and Income on the right. E and I go nicely with that favorite old song, Old MacDonald Had a Farm, <strong>E</strong>e-<strong>I</strong>ye, <strong>E</strong>e-<strong>I</strong>ye, Oh!<br /><br />Now let’s rearrange these images in a useful grid and talk about their typical use:<br /><br /><div style="BORDER-BOTTOM: 0px solid; TEXT-ALIGN: left; BORDER-LEFT: 0px solid; BACKGROUND-COLOR: #a0ffff; PADDING-LEFT: 4px; WIDTH: 400px; PADDING-RIGHT: 4px; FONT-FAMILY: arial; HEIGHT: 640px; COLOR: #000000; FONT-SIZE: 12px; OVERFLOW: auto; BORDER-TOP: 0px solid; BORDER-RIGHT: 0px solid; PADDING-TOP: 4px"><a href="http://picasaweb.google.com/lh/photo/NQUHiz9UJprphDdNlYiGCg?authkey=ARYFTm1bZ14&feat=embedwebsite"><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgGK123Ta1IkgULqF2dHc4zmdcn4ljmjmwgAUYMC3P0CJFBtuAWmKx1kxC8u1uQkkjUCsQ8qxDwPewBfOxhNotpvMTE3zeEzsp-8IBVHzmLiGazUUAPdFrW2kzrR81upyL4FXjuzPycbUI/s800/MemJogTab1c.jpg" /></a></div><br /><br /><br /><br />If we are going to enter a straightforward payment from a bank to a fixed asset account, we can see that we will be interested in the two images in the left hand column:<br /><br />For the Bank account entry, Face Cream in Mexico reminds us that we are concerned with From an Asset account in the Credit or Expense column and the amount to be entered is a minus/decrease with a single positive amount - not a negative amount with a minus sign!<br /><br />Likewise, a Toad Plunking along tell us that the other entry will be To an asset account in the Debit or Income column and it will be an increase/plus amount.<br /><br />There are only two From’s, each with two possible To’s so there are not all that many possible ways or combinations of entries available. In fact all entry combinations have been covered in the different examples that have been discussed previously in this blog so it might be worthwhile re-visiting them in conjunction with these memory joggers.<br /><br />A last memory jogger that I find helpful is to remember the traditional order in which columns are set out in accounts, which is debit on the left and credit on the right – DC. I just think of a DC battery with its + and – terminals so for an asset account, we have D and + on the left for Debit entries and positive value whilst in the right hand column we have C and – (minus) for Credit entries and negative value.<br /><br /><a href="http://picasaweb.google.com/lh/photo/U8GSqyY1BnKboXPmM3gXDA?authkey=ARYFTm1bZ14&feat=embedwebsite"><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhMqapo-pdAJCuqgH8QU6pj-ZSQ4CwcnEGsyp1rAJcgaqdeA84hA5V1uKsU5u0WYsGfHbyC0P4FF7jC2x4QusTT_oB2zG8m75pcnOskN3afclTTzqVjCBf0JG6d4MU03kVefNl81CaEsB8/s400/battery1c.jpg" /></a><br /><br />On the liabilities side, we still have D and C but their polarities are reversed – minus and plus for negative and positive values, respectively. in the Debit and Credit columns.<br /><br /><strong>11. Bookkeeping and Categorising Information</strong><br /><br />Bookkeeping is concerned with initially setting up the appropriate accounts and subsequently making entries into the accounts in line with the actual financial transactions taking place from day-to-day. Bookkeeping also has to take care of the end-of-period administration involving re-setting the Working, Nominal, Increases and Decreases accounts to derive the new value for Total Domestic Change and transferring its balance to the Domestic Wealth account.<br /><br />For setting up the accounts, there are two distinct ways of capturing DWB structure data depending upon the architecture of the particular accounting software package used – support for categories or for the nominal accounts used in business style packages for storing income and expenses.<br /><br />The last main area of potential difficulty for non-accountants relates to usage of the two main columns in each individual account. There is normally one column for Increases/Plus and a second column for Decreases/Minus.<br /><br />Traditionally in business, debits (Dr.) were always stored in the left hand column of an account and credits (Cr.), in the right hand. The implication here is that positive increases in asset type accounts will be entered in the left column whilst for liability type accounts, regardless of their actual usage, positive entries being credits will be entered in the right column.<br /><br />With personal accounting software packages these conventions are rarely adhered to and in Microsoft Money for example, the column headings vary according to context so you will see Decrease and Increase, Payment and Deposit as well as Charge and Credit. This product also uses the concept of Expense and Income for the left hand and right hand columns, respectively, in association with the categorization of postings. For this, I have already mentioned the E – I sequence from the song, Old MacDonald had a Farm, Ee-Iye, Ee-Iye, Oh, which is a good reminder!<br /><br />In Personal Accountz the choice is between account headings of ‘From and To’ or ‘Credit and Debit’. Although not strictly theory, it is relevant to note in this context that Microsoft Money requires two postings for each transaction whereas Personal Accountz uses the business style journal for entries where the two affected accounts for each transaction are identified in a single entry using the From/To concept.<br /><br /><strong>12. Summary</strong><br /><br />Accounting for domestic finances is accomplished by the use of a personal accounting software package which enables the creation and updating of a collection of accounts created to match the characteristics of a personal or household situation. These include accounts for personal assets (fixed, investment and current), personal debts (current and long-term) as well as all increases and decreases occurring over a period tending to change the amount of household Domestic Wealth.<br /><br />There are two overarching <em>types</em> of account used in accounting – asset <em>type</em> accounts where positive increases implies more positive value and liability <em>type</em> accounts where positive increases represent charge of debt implying negative value.<br /><br />For a complete accounting solution, it will be necessary to implement a double entry system which includes a minimum of one extra account in which to store Domestic Wealth. Other associated accounts may be useful to keep separate records of domestic increases, decreases and the resulting Total Domestic Changes (TDC) over any period.<br /><br />Double entry accounting involves maintaining the balance of an established set of accounts by ensuring that every transaction includes two postings to match any increase of value by a corresponding decrease of value, appropriately in the accounts.<br /><br />The basic domestic accounting equation states that total personal assets less personal liabilities equals domestic wealth. Domestic Wealth is a ‘good’ liability representing the value of the household owed to its eventual beneficiaries.<br /><br />The structure of changes highlighted in the Domestic Well-Being structure requires detailed visibility which is achieved either by the use of nominal accounts or categorization of transactions according to the architecture of the accounting package employed.<br /><br />The inter-relationship between all the different individual accounts is depicted in the Domestic Accounting Equation (DAE), together with the allowed transaction double entry pairings:<br /><br /><br /><div style="BORDER-BOTTOM: 0px solid; TEXT-ALIGN: left; BORDER-LEFT: 0px solid; BACKGROUND-COLOR: #a0ffff; PADDING-LEFT: 4px; WIDTH: 400px; PADDING-RIGHT: 4px; FONT-FAMILY: arial; HEIGHT: 430px; COLOR: #000000; FONT-SIZE: 12px; OVERFLOW: auto; BORDER-TOP: 0px solid; BORDER-RIGHT: 0px solid; PADDING-TOP: 4px"><br /><a href="http://picasaweb.google.com/lh/photo/bfdDHf_QQu8MMcvqwXRZwQ?authkey=ARYFTm1bZ14&feat=embedwebsite"><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjYPNwBY_2TTUvclTF4hQjcgYRvk-1_FRaMHoPnOvLTEjOR20391_KSCHlGzXV0rfc2-0Ie-LzqBpCtyiCKyMGdjW7h-h0uyZNg_AiM_T7dm996Ey6OCvaxsQFIbVPdy1NhDIkGOtpFP1o/s800/Allowed%20FROM%20TOc.jpg" /></a><br /></div><br /><br />Please rememer that the balance I have been concentrating on in this blog is the balance that has to be maintained in the Domestic Accounting Equation to help with the bookkeeping and the correct entering or posting of transactions in double entry accounting.<br /><br />This must be distinguished from the balance we will seek across the overall set of domestic accounts for a household with DWBA. Here the focus is on maximising Domestic Well-Being which is finding the best possible balance across the decreases (expenses) based on the available increases (income).<br /><br />Finally, we have a series of memory joggers to tie all these different facts together:<br /><br /><strong>Face Cream in Mexico</strong><br />From Asset Credit Minus Expense<br /><br /><br /><a href="http://picasaweb.google.com/lh/photo/9ykBkp7EgAt_yY7ziu2IKw?authkey=ARYFTm1bZ14&feat=embedwebsite"><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiz08Otg6M5tByU10M0fErGELkjn0iPXAbEZX1SzBXYDAk0gO2yvnVYqwSpAI3Tfk_fGB1CDaYY90QTzTvRLCc2UkYZmMbrN_-jd6TSPGctcL69TxApH0GGz-Hmrzbq1gGfvMcjdIFzURA/s400/FaceCream1c.jpg" /></a><br /><br /><br /><br /><strong>From Lily Complex</strong><br />From Liability Credit Plus Expense<br /><br /><br /><a href="http://picasaweb.google.com/lh/photo/qhg6JQp0g7KECd49Ng-j9A?authkey=ARYFTm1bZ14&feat=embedwebsite"><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgynJGlIJU3zOV1hqKYR6fpvusknhzpP1ivyCSL3oFK1CA08tj0YesnfHEiTx8UoFZ3eXqdTUWvxARwheQDYXtNMNhmcXZcCZy1DOplwPjoW8KyqdNmd5EW2ssULStc3vwg0wV1lB1tS1s/s400/lily3c.jpg" /></a><br /><br /><br /><br /><strong>Toad Plunking</strong><br />To Asset Debit Plus Income<br /><br /><br /><a href="http://picasaweb.google.com/lh/photo/dLV9z3Is774SMDOC7w8o0A?authkey=ARYFTm1bZ14&feat=embedwebsite"><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgM477E8yHvkTVkTQKLuY7OcroSmc7_jW6ok_7RgN3M9_LXePlJnRtV8_SC2Og-CNldceyHjeP0jKPkktV9y3TG_AJjouIUw7V6SuqE2kIaTtUvWs7xYzacNuYNkhK9A5qc4OD4q_V4D2c/s400/toad2c.jpg" /></a><br /><br /><br /><br /><br /><strong>Tilted Mink</strong><br />To Liability Debit Minus Increase<br /><br /><br /><a href="http://picasaweb.google.com/lh/photo/rLbhFwBqaMMKcMXAbbjJIw?authkey=ARYFTm1bZ14&feat=embedwebsite"><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgtc0Tu0OE-08kRfmLtmCreLU34yGoxx6q7Y0olWLWU9eVRz4s_B8SpQhR06ntsRFSn-HliI-lPam-7kAwRvWMS5Sv-Ld3iJPJD9i9PlCpkoDpxuBiAHbvm1vaBjuU2Tb0k_hQ7YUNQ1d8/s400/TiltedMink2c.jpg" /></a><br /><br /><br /><span style="font-size:130%;"><strong><br />For the Expense/Income column relationship in Microsoft Money and Personal Accountz:<br /></strong></span><br /><br /><span style="font-size:130%;">Old MacDonald had a farm, <strong>E</strong>e-<strong>I</strong>ye, <strong>E</strong>e-<strong>I</strong>ye, Oh!</span><br /><br /><br /><span style="font-size:130%;"><strong>Debit and Credit (Traditional Column layout):</strong></span><br /><br /><style type="text/css">.nobrtable br { display: none }</style><br /><br /><br /><div class="nobrtable"><br /><table style="TEXT-ALIGN: left" border="1"><br /><colgroup width="5%"></colgroup><br /><colgroup width="45%"></colgroup><br /><colgroup width="5%"></colgroup><br /><colgroup width="45%"></colgroup><br /><tbody><tr><br /><td></td><br /><td><span style="font-size:130%;"><strong>Asset Account</strong></span></td><br /><td></td><br /><td><span style="font-size:130%;"><strong>Liability Account</strong></span></td><br /></tr><br /><tr><br /><td></td><br /><td>Dr. Cr.</td><br /><td></td><br /><td>Dr. Cr.</td><br /></tr><br /><br /><tr><br /><td></td><br /><td>+ -</td><br /><td></td><br /><td>- +</td><br /></tr><br /></tbody><br /></table><br /></div><br /><br /><a href="http://picasaweb.google.com/lh/photo/U8GSqyY1BnKboXPmM3gXDA?authkey=ARYFTm1bZ14&feat=embedwebsite"><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhMqapo-pdAJCuqgH8QU6pj-ZSQ4CwcnEGsyp1rAJcgaqdeA84hA5V1uKsU5u0WYsGfHbyC0P4FF7jC2x4QusTT_oB2zG8m75pcnOskN3afclTTzqVjCBf0JG6d4MU03kVefNl81CaEsB8/s288/battery1c.jpg" /></a><br /><br /><br />copyright © 2006 John M Passmore<br /></dl></div>Nilgaihttp://www.blogger.com/profile/14912670556905736362noreply@blogger.com0tag:blogger.com,1999:blog-634486368075297184.post-54706450589046055122009-01-21T12:52:00.048+00:002009-02-06T10:10:13.233+00:00DOMESTIC WELL-BEING ACCOUNTING – REPORTS 1<div align="justify"><br />In my last blog, I went back to basics and discussed Domestic Accounting in perspective. We saw how domestic financial activity continues on a day-to-day basis in any domestic situation regardless or not of whether accounting is undertaken. Now it is time to start thinking about how we can capture and make use of information about that activity, through modelling it by the use of accounting.<br /><br />The alternatives are to capture it on a one-time basis, perhaps to help make some financial decision that is looming, such as house purchase. Alternatively, we can make a proper job of it and start accounting for it on a full-time, continuous basis. The advantages of this are that the overheads can be tackled just once and that you will then be in a position to really start to plan and control all your financial activity and hence your lifestyle, on a continuing basis throughout your lifetime.<br /><br />The way I will approach the subject is to start with reports. If you think about it, the whole purpose of accounting is to obtain information that will enable us to achieve our objective – successful management and control of our personal finances.<br /><br />Accounting has five main activities shown in logical sequence, below:<br /><br /> the setting up of an accounting system with the necessary individual accounts and reports – a one-time exercise<br /><br /> bookkeeping, being the periodic entering of basic financial activity data as transactions, into the appropriate accounts<br /><br /> the production of summarised information from the accumulated transactions in the form of reports and associated charts, whenever needed<br /><br /> the analysis and decision making to influence future financial activity in order to improve the financial situation<br /><br /> setting up, monitoring and adjusting future financial activity as needed, through budgeting, discipline and monitoring, in order to start achieving the desired results in the subsequent periods<br /><br />You will notice that the creation of reports and charts is at the end of the three production activities. These reports are used as the starting point for the last two activities, analysis and decision-making followed by the execution stage, to start to achieve the desired results in the next accounting period.<br /><br />I mentioned that DWB Accounting is introduced as a model which can be implemented on off-the-shelf software accounting packages run on a PC. Consequently, there will be differences in detail about how certain activities are accomplished depending on the architectural and implementation details of each particular software package.<br /><br />However, the basic concepts in terms of the information collected and the reports obtained and the analysis and decision making should be identical, as called for by the new domestic accounting model.<br /><br />We can consider reports from two perspectives. First, the raw data as produced by the individual software packages and second, tidied up or formatted reports based on the content of the raw data reports. I say raw data because this will be in the style and format of the data obtained from a software package in its own query and reporting tools.<br /><br />Although it will mostly be very usable as it is produced by the appropriate queries and presentation programs of the accounting software, we sometimes need prettier and better formatted versions of some of the reports to assist our analysis (and perhaps for any printed records we may choose to keep). We can do this easily by transferring the raw report data to a spreadsheet program such as Microsoft Excel© or Open Office Calc© (free but contribution invited) for further editing.<br /><br />The software packages often have on-screen interfaces for their displayed reports whereby using mouse-clicks; more detail can quickly and easily be obtained by ‘drilling down’. Printed reports whether formatted or not, obviously lose this dynamic capability to quickly hone in on more detail but we can always retain as many different versions of the reported detail of the data as we wish in printed format.<br /><br />We always want to make things as easy as possible for ourselves so most of the queries, reports and spreadsheet programs will be saved as prototypes or ‘pre-stored‘ queries for repeated, future use.<br /><br />The sort of accounting we should do is designed to run continuously, year after year. This is a feature of double entry accounting which business uses and that I have adapted for home use.<br /><br />Time is divided up into periods where the main period is usually a year, with smaller sub-divisions as needed, such as three-monthly, quarters and individual months. Most of our report programs will be used repeatedly for each of the different time periods with changes made via parameters, to the beginning and end dates as required. This does not mean to say that a report cannot be run at any time during the current period as needed, just to peek at some aspect of the current situation or look back on previous situations.<br /><br />There are two fundamental reports that the new accounting model defines with some optional extra reports for those who wish to go into more detail.<br /><br />In accounting, we always talk about our financial situation as at some particular instant of time – usually the end of a period such as the last day of a particular month, quarter or year. This sort of report provides our so-called, Domestic Wealth which represents our total value, or what we are worth on that day. We can obtain the value for our Domestic Wealth if we total up the values of all our assets and subtract from this total, what we owe to others which are our liabilities or personal debts. This report is called a Domestic Balance Sheet (DBS) and is quite similar in concept to a business Balance Sheet - for those knowing something about business accounting.<br /><br />As time progresses during some period, we will receive increases in our Domestic Wealth from wages or salary, proceeds from the sale of a car perhaps and maybe windfalls from investments, as an inheritance, or even prize winnings. Similarly we will see reductions in this value as decreases, as a result of payments for food, utilities, health, hobbies and holidays, perhaps the purchase of a replacement car and maybe, as a result of depreciation on the value of our home.<br /><br />Another type of report is used to capture all the details of these financial changes over some period and it is called a Domestic Well-Being Statement (DWBS). It is the most useful of the reports as it is the main source for the analysis leading to decisions we may need to make in order to achieve some improvements in our situation. The analogy with business accounting here is that the DWBS is most equivalent to the Trading Statement and Profit & Loss account.<br /><br />The information captured in the accounts during some period and used in order to give us a DWBS also needs to be modified in some way at the end of each period in order to give us a new, up-to-date DBS showing our latest Domestic Wealth. This new Domestic Wealth will always be derived from the latest total values of our assets less our liabilities; these will have taken into account (there’s an appropriate phrase!) all the changes - those increases and decreases - occurring during the period since our last DBS.<br /><br />In a later blog I will talk a little bit about the theory behind domestic accounting and introduce you to what I call the domestic accounting equation. This will make it easy to understand the relationship between these key ideas of Assets, Liabilities, Domestic Change and Domestic Wealth, together with a new way to associate these concepts with all the individual accounts we will need to keep and the various transactions corresponding to our on-going, domestic financial activity.<br /><br />It is time now to look at some reports so first of all here are formatted versions of the DBS and DWBS covering a whole year, together with the previous year’s figures alongside for comparison. Note that figures in parentheses in red represent negative values.<br /><br />These formatted reports will be followed by some examples of the corresponding raw reports from two different software packages, Personal Accountz© and Microsoft Money©:<br /><div style="BORDER-BOTTOM: 0px solid; TEXT-ALIGN: left; BORDER-LEFT: 0px solid; BACKGROUND-COLOR: #a0ffff; PADDING-LEFT: 4px; WIDTH: 400px; PADDING-RIGHT: 4px; FONT-FAMILY: arial; HEIGHT: 780px; COLOR: #000000; FONT-SIZE: 12px; OVERFLOW: auto; BORDER-TOP: 0px solid; BORDER-RIGHT: 0px solid; PADDING-TOP: 4px" ><a href="http://picasaweb.google.com/lh/photo/SGMz-YUw--_jbdiq_6M4NQ?authkey=ARYFTm1bZ14&feat=embedwebsite"><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgmjUByZOSZb_yooUq3hnTYDY5nYA_n-pzWKsj5628qXUDqVyWSHQjoEX35gtTwt7seXP4YAJKitsCdk1DvvgQIvmY-UjuNLB3d6JcCvnZtiGXOgJQdGX2x3DEYBJOnpEG9wEs2Tr5meYI/s800/DWBA_DBS.jpg" /></a><br /></div><br /><br /><br />I should explain that the accounts used in these examples are from the book ‘Accounting for a Better Life’ where I used a sample set of accounts covering the financial activity of a family over a whole year – 6 April 2004 to 5 April 2005. The book was based on the use of Microsoft Money© but as already said, I have since started using a second package, Personal Accountz©, as an example and comparison of the use of a slightly different software package accounting architecture on which to implement the new DWB accounting model.<br /><br />The DBS simply derives the Domestic Wealth based on a structured list of the assets less the liabilities or debts, held in the accounts on a specified day. This version of the DBS breaks down all these assets and liabilities into appropriate categories, together with some explanatory notes.<br /><br />You will notice that the structure of the report distinguishes between the assets and the liabilities and also, that the assets and the liabilities are separately categorised into successively greater levels of detail. This is an issue of convenience and if the detail is of little interest, it can simply be omitted; a useful option is to create both summary and detailed versions of the DBS.<br /><br />Looking at the Assets Section, you can see that the first distinction or split is into Fixed, Investment and Current assets. You will see later that we will have separate accounts or ‘containers’ for all these different categories of wealth and by using account name prefixes, we can associate any account with its purpose AF, AI or AC for Fixed Assets, Investment Assets or Current Assets, respectively. Current Assets represent all our quantities of cash which are usually held in different types of current or savings accounts in one or more banks.<br /><br />In the Liabilities Section, the breakdown is simply into Long-term Liabilities and Current Liabilities. Long-term is for mortgages and loans whilst the Current Liabilities are for credit card or store-card accounts, for example. We will have similar account name prefixes for the liabilities of LL and LC for Long-term and Current Liabilities, respectively.<br /><br />At the bottom of the DBS report, you can see the derivation of Net Worth or Domestic Wealth, being the difference between the totals of the assets and the liabilities. For the end of the current year, the value for Domestic Wealth is £514,200. It is interesting to notice that by showing the previous year’s value, we can see that the difference between the Domestic Wealth at the end of the previous year (£488,300) and the end of the current year is £25,900.<br /><br />This value represents the result of all the increases and decreases that have occurred during this year-long period. It is called the Total Domestic Change (TDC) and if it is positive, it is called a Domestic Surplus or ‘Domplus’ and if the decreases exceed the increases, we have a Domestic Deficit or ‘Domicit’. By analogy, these are equivalent to the business concepts of net profit or loss.<br /><br />The interesting thing will be to see how the TDC is made up, in terms of the different categories and sub-categories of increases and decreases that have taken place over a period. The reason for this again, is because it will have a major influence on how we might be able to change our financial activity in the future, if we discover that the financial aims and priorities for our household are not currently being met.<br /><br />The two main uses of the DBS are to track the value of Domestic Wealth over the years and to be reminded of the distribution of our assets and liabilities for whenever it might be appropriate to change that distribution in some way.<br /><br />In contrast to business where the focus is on maximising capital - owner's or shareholder's value - we would wish to see a steadily increasing value in domestic wealth to account for both normal inflation and our expectations in terms of an increase in general well-being as we progress through life.<br /><br />Most people would like to progress through life with promotions at work or other advancements so that their living standards might steadily improve. With this, they might be able to perhaps provide more for their children in terms of education and opportunities than they experienced and that they might be able to afford more spacious homes for themselves and their expanding families during their lifetime.<br /><br />The Domestic Well-Being Statement in contrast is the report that exposed the increases and decreases as change over any period and we would expect to find that its value is equal to that derived from comparing the Domestic Wealth at the beginning and the end of the same period in the DBS.<br /><br />This version of the DWBS below, with full detail, is illustrated in three parts making up a single, continuous report. As before, this version shows values for both the previous and current periods, of the financial year 2004/05.<br /><br /><div style="BORDER-BOTTOM: 0px solid; TEXT-ALIGN: left; BORDER-LEFT: 0px solid; BACKGROUND-COLOR: #a0ffff; PADDING-LEFT: 4px; WIDTH: 400px; PADDING-RIGHT: 4px; FONT-FAMILY: arial; HEIGHT: 680px; COLOR: #000000; FONT-SIZE: 12px; OVERFLOW: auto; BORDER-TOP: 0px solid; BORDER-RIGHT: 0px solid; PADDING-TOP: 4px" ><br /><a href="http://picasaweb.google.com/lh/photo/LG3Q6SlnoS9AISKGnRUO2w?authkey=ARYFTm1bZ14&feat=embedwebsite"><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEihUm-lexLAaJ4jtNRFtU1lo7p3dT4fDilcbUlJXHRbaqHa9JiMGdp8uBKDhTteNMe4lecvc8FcBX6R2utWaa1GVl0DKFa8PNtFr5lcZWQhhnpZEG7An2VXAcXTBZ5lZlQqCsGA1052SGI/s800/dwbs1.jpg" /></a></div><br /><br /><div style="BORDER-BOTTOM: 0px solid; TEXT-ALIGN: left; BORDER-LEFT: 0px solid; BACKGROUND-COLOR: #a0ffff; PADDING-LEFT: 4px; WIDTH: 400px; PADDING-RIGHT: 4px; FONT-FAMILY: arial; HEIGHT: 700px; COLOR: #000000; FONT-SIZE: 12px; OVERFLOW: auto; BORDER-TOP: 0px solid; BORDER-RIGHT: 0px solid; PADDING-TOP: 4px" ><br /><a href="http://picasaweb.google.com/lh/photo/z-kS79ky6LrEywKb2DkiCw?authkey=ARYFTm1bZ14&feat=embedwebsite"><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhreTqJQXUJSmr8TjFyG6SvUxsr-avFlBNhrNDPXpsQSmeQU6318kEZil-hJBqaX3xLPugUxdpnGDw-Vb7dc-AP8obIBdXvlzxiXhIjbkTSJ8EGAVOokbZDv-WwDeD2PIn-4hfifBYuhxI/s800/dwbs2.jpg" /></a><br /></div><br /><br /><div style="BORDER-BOTTOM: 0px solid; TEXT-ALIGN: left; BORDER-LEFT: 0px solid; BACKGROUND-COLOR: #a0ffff; PADDING-LEFT: 4px; WIDTH: 400px; PADDING-RIGHT: 4px; FONT-FAMILY: arial; HEIGHT: 850px; COLOR: #000000; FONT-SIZE: 12px; OVERFLOW: auto; BORDER-TOP: 0px solid; BORDER-RIGHT: 0px solid; PADDING-TOP: 4px" ><br /><a href="http://picasaweb.google.com/lh/photo/e2rakDXbAy-i_eJCF1kDDA?authkey=ARYFTm1bZ14&feat=embedwebsite"><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi2_THN_g9xfbeKtNCNLp1hr-wlx6JSmQL_RaY4VGF2jnkmsjlBcPp6vboMZMdFFlkGcG8ZQ0Ipy4rumJGA42Ue8ixpLozI9yzzJdLdReHomjLhY1soZNztQL7i7tz2cbpUp2-htvPkc_U/s800/dwbs3ac.jpg" /></a><br /></div><br /><br />In this formatted version of the DWBS, explanatory headings have been added to make it easier to find our way around and to know what section we are looking at; you will also notice that much use is made of abbreviations (e.g. Basic Domestic Decreases – BDD) for the various category and subcategory totals and sub-totals. We will not make use of these abbreviations in these introductory articles but they do help full-time users to simplify relatively long phrases, particularly with the new Domestic Financial Factors that I will discuss in a later blog.<br /><br />The DWBS displays all the increases and decreases occurring over a period. The important thing to notice is that the results are presented in a hierarchical structure which is in fact, the Domestic Well-Being structure.<br /><br />This structure which covers both increases and decreases has three main, top-level categories – Basic, Discretionary and Others (non-Discretionary). Beneath each of these top-levels there are a series of lower-level categories which are different for increases and decreases and which continue down the hierarchy into successively lower and more detailed levels, ending if we went far enough, with the individual financial transactions themselves. These individual transactions are not shown in the reports of course but can easily be exposed on the screen to assist in the decision-making activities when needed.<br /><br />It will take a little time initially to get used to the layout but as you study the ordered structure you will begin to see and be able to find important information. As an example, for the decreases, out of the total domestic decreases of £83,200 the amounts for the Basic, Discretionary and Other decreases were £43,500, £11,500 and £2,300 respectively.<br /><br />Delving into the next lower level we can discover that the sub-totals for Essentials, Responsibilities and Family circumstances as proportions of the Basic total of £43,500 were £23,800 £18,900 and £600 respectively; and we can go on down the hierarchy to expand increasing detail in terms of further sub-categories.<br /><br />Similarly, Essentials expands into Utilities, Food and Drink, Clothing, Health and Transport; whilst Responsibilities includes Income Tax, Council Tax, Mortgage Repayments, Home Maintenance, Household, Insurance, Professional Contributions, Garden and Miscellaneous; and Family Circumstances here, only has Presents. Similar patterns exist for the Discretionary Category and the Others (non-Discretionary) category.<br /><br />Understandably, the individual figures do not mean much is isolation but when examined for balance and compared with previous values, much useful information begins to emerge. When I say balance, I mean the balance across the categories; that reasonable proportions of our increases are being spent equitably on the Basics, the Discretionary and Others.<br /><br />In contrast to business where accounting exposes for the changes, the contributors to profits (sales and discount received) and losses (cost of stock, advertising, transportation, etc.) so that profit cam be maximised for the owner's benefit, the focus of the new accounting model on Domestic Well-Being ensures that the stored data and the associated reports are structured in a way that exposes the elements that can assist in maximising DWB.<br /><br />In a household we do not wish to increase Domestic Wealth at all costs. We want to find a way to deliberately spend money on the appropriate items that will give us the best possible life in relation to the income at our disposal, as well as hopefully providing us with an ever-improving standard of living and overall wealth.<br /><br />For example, if there are insufficient increases to cover the Basics then there is a potentially very serious problem and no form of accounting is likely to be of any help. Next,that within each of these top-level categories, there is a reasonable balance across each of the next lower level categories and that none of them is being unacceptably ignored or given inappropriate, too much/high or too little/low attention.<br /><br />Domestic Well-Being is all about providing sufficient for the Basics and the Responsibilities but also trying to ensure that the Discretionaries, particularly the Nice-to-Haves, such as hobbies, holidays, lunches and dinners out, entertainment and so on are provided-for, in appropriate measure. It is all about the right balance - a little bit of everything, without excesses and also taking care of the short-term (the replacement car, the next holiday, a bigger house) and the long-term future (retirement).<br /><br />The key to achieving all of this is the visibility that DWB accounting provides on all of the elements, on which decreases as expenses are expected, as well as all the increases and the background layer of the different types of assets and liabilities.<br /><br />In a later blog I will discuss implementation issues and in particular, highlight the differences in approach of using a categorisation architecture as used in Microsoft Money© versus a so-called nominal accounts approach more typical of business accounting, as adopted in Personal Accountz©.<br /><br />The next series of examples are of screen shots of raw data reports from Personal Accountz© where some of these differences will be discernible.<br /><div style="BORDER-BOTTOM: 0px solid; TEXT-ALIGN: left; BORDER-LEFT: 0px solid; BACKGROUND-COLOR: #a0ffff; PADDING-LEFT: 4px; WIDTH: 400px; PADDING-RIGHT: 4px; FONT-FAMILY: arial; HEIGHT: 400px; COLOR: #000000; FONT-SIZE: 12px; OVERFLOW: auto; BORDER-TOP: 0px solid; BORDER-RIGHT: 0px solid; PADDING-TOP: 4px" ><br /><a href="http://picasaweb.google.com/lh/photo/-yAbb_Akc7_VGyPKwmb9xQ?authkey=ARYFTm1bZ14&feat=embedwebsite"><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj0Qafpvgy5PRMltXg0KD6DFy7atYuyEWycKhY7oAOjVc-0k6iOL7vFU_1jfiSiwSwhoukTgC88QJ-i9YD5TURUlwDNt_uUrKZRl85eK9qfgL5Nt-40w6UkkO8ueXrGDI75Np0F8IkJXnA/s800/Raw%20accz%201bc.jpg" /></a><br /></div><br /><br />Although it will require further explanation once the idea of individual accounts has been accepted, this first report actually shows the values contained in both the DBS, as well as the DWBS. Most of the sub-categories have not been expanded in this first view so we see summary values for each high-level category of increases and decreases. In Personal Accountz, separate accounts are established for each level of detail (category and sub-categories) down to the lowest level and there is a powerful concept of grouped accounts which can bring together totals for the subordinate accounts of a particular group, including lower-level groups of accounts.<br /><br />In fact using Personal Accountz in conjunction with this new domestic accounting model means that your Balance Sheet and Changes report is as up-to-date as the last transaction entered!<br /><br />Ignoring any differences in values in the three columns, this first raw report view above includes in the upper half, the DBS values for the assets of £637,300; the liabilities of £123,000; and the estimated/consolidated domestic wealth of £514,200 being the previous domestic wealth of £488,300 plus the Total Domestic Changes of £25,900 appearing further down.<br /><br />In the lower half, you can see the DWBS amounts for the Basic, Discretionary and Other increases and decreases. The little + signs next to each heading indicate that there is more detail that can be exposed or drilled-down by clicking on one of the + signs when looking at the report on a computer screen.<br /><br />In the next view, below, you can see different levels of the expansion of a number of entries for various Basic increases and decreases. As before, new + signs appear indicating that there is more detail at further, lower level sub-categories that are available to be examined from the screen, if needed:<br /><div style="BORDER-BOTTOM: 0px solid; TEXT-ALIGN: left; BORDER-LEFT: 0px solid; BACKGROUND-COLOR: #a0ffff; PADDING-LEFT: 4px; WIDTH: 400px; PADDING-RIGHT: 4px; FONT-FAMILY: arial; HEIGHT: 600px; COLOR: #000000; FONT-SIZE: 12px; OVERFLOW: auto; BORDER-TOP: 0px solid; BORDER-RIGHT: 0px solid; PADDING-TOP: 4px" ><br /><a href="http://picasaweb.google.com/lh/photo/gXfhaAm3w6b-wgm3-3oKzg?authkey=ARYFTm1bZ14&feat=embedwebsite"><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhGyg52kjeG3x4K4bZghghLhxDSbSak9tvj778HNnQZlJtUzxmjZljVVzEG9zg_b7zCffzUX8_-l9umu4rJNIuALpfYRzPDwkD5XxDVxjkHdIq-8RcAAGxW9sPyY0hRZ9Vdn-0BZuGcbUM/s800/Raw%20accz%202c.jpg" /></a><br /></div><br /><br />Below, you can see more dynamic detail after different + signs have been clicked.<br /><div style="BORDER-BOTTOM: 0px solid; TEXT-ALIGN: left; BORDER-LEFT: 0px solid; BACKGROUND-COLOR: #a0ffff; PADDING-LEFT: 4px; WIDTH: 400px; PADDING-RIGHT: 4px; FONT-FAMILY: arial; HEIGHT: 500px; COLOR: #000000; FONT-SIZE: 12px; OVERFLOW: auto; BORDER-TOP: 0px solid; BORDER-RIGHT: 0px solid; PADDING-TOP: 4px" ><br /><a href="http://picasaweb.google.com/lh/photo/QYddVnRR7rHlkMsOBmvePg?authkey=ARYFTm1bZ14&feat=embedwebsite"><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgUw0bU-xMxfRmL4pE1biMvikwluv2n8lPn4clA_CWqNtUfoYWkQ0WDHoToBlsExksA6S1jXY-1vdjkV31Kjz-rIBRoES_G77whxE462TFOgduvh-1OU8KFXcZSTjIBKV0kKJ3CSBw8u7A/s800/Raw%20accz%203ac.jpg" /></a><br /></div><br /><br /><br />What is important to note is that the values are the same as those summarised in the formatted version of the report produced from a different accounting software package. In the next two examples, you will see a different type of layout, still from Personal Accountz .<br /><div style="BORDER-BOTTOM: 0px solid; TEXT-ALIGN: left; BORDER-LEFT: 0px solid; BACKGROUND-COLOR: #a0ffff; PADDING-LEFT: 4px; WIDTH: 400px; PADDING-RIGHT: 4px; FONT-FAMILY: arial; HEIGHT: 560px; COLOR: #000000; FONT-SIZE: 12px; OVERFLOW: auto; BORDER-TOP: 0px solid; BORDER-RIGHT: 0px solid; PADDING-TOP: 4px" ><br /><a href="http://picasaweb.google.com/lh/photo/iu9ikcUX3GIzRoQQivPu2Q?authkey=ARYFTm1bZ14&feat=embedwebsite"><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjs6ms4gXxvT267GB7UONvN3oDS2so8hp2bpOWy33PaAL20ty60Gu4iATJP1Ge-74ADFgF63gcpBZaWflo7mq27OaelYx9oVD_2Wsjxmew9rGuwbitn4dl-8t0v2PbGahO_vaNQrRDjyLA/s800/Raw%20accz%205ac.jpg" /></a><br /></div><br /><br />Here, the results for two particular queries, all of the Domestic Decreases (above) and just the Basic Decreases (below) include all the individual transactions contributing to each group of decreases, together with a breakdown of their sub-totals, by month. In these screen shots we can only see the last few of the transactions before the monthly summaries are displayed but on the screen, all the individual transactions can examined on-line by use of the vertical sliders.<br /><div style="BORDER-BOTTOM: 0px solid; TEXT-ALIGN: left; BORDER-LEFT: 0px solid; BACKGROUND-COLOR: #a0ffff; PADDING-LEFT: 4px; WIDTH: 400px; PADDING-RIGHT: 4px; FONT-FAMILY: arial; HEIGHT: 510px; COLOR: #000000; FONT-SIZE: 12px; OVERFLOW: auto; BORDER-TOP: 0px solid; BORDER-RIGHT: 0px solid; PADDING-TOP: 4px" ><br /><a href="http://picasaweb.google.com/lh/photo/zf533NpS0rZEfYcZoWV0Rg?authkey=ARYFTm1bZ14&feat=embedwebsite"><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjQKZYGlUkW9Oq3Xdn3UqczhnN_kmhMOIXndmg8HlTeI6zv1TbEjTj1yYtbS-w9GtOLid9YySPdJPCtVbULRz2IlvpthuFC265BPWh3AjKq9ovIPQY3c3s11UNzQ692FZpA2OkEYM3haOs/s800/Raw%20accz%207ac.jpg" /></a><br /></div><br />It is useful here to look for significant, out of the norm, changes in values over the months and where they are noted, further examination of the transactions will lead to the reasons which may well have valid explanations. Alternatively, these may represent the first signs of some excessive decreases that might be the target for some action to achieve a better balance.<br /><br />In the next example, we have a display of the monthly totals of a sub-category of the Basic decreases, for Personal Transport:<br /><div style="BORDER-BOTTOM: 0px solid; TEXT-ALIGN: left; BORDER-LEFT: 0px solid; BACKGROUND-COLOR: #a0ffff; PADDING-LEFT: 4px; WIDTH: 400px; PADDING-RIGHT: 4px; FONT-FAMILY: arial; HEIGHT: 540px; COLOR: #000000; FONT-SIZE: 12px; OVERFLOW: auto; BORDER-TOP: 0px solid; BORDER-RIGHT: 0px solid; PADDING-TOP: 4px" ><br /><a href="http://picasaweb.google.com/lh/photo/ZZw7-17Vs5DN6KO5I1bD_w?authkey=ARYFTm1bZ14&feat=embedwebsite"><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgpE5elkWNV_5OMfg0D0jplMpEZ9gBcz4eHZRJrOLM58HS7QN6HP5zoxEOuBcwz6bWKuoBPWFekrDwiuh-1YxTu6eVsV4OZOT-Cc2fIm9oMkWiTgTb01OBaxOV-kayGfG98pr3hwZ3MitE/s800/Raw%20accz%207bc.jpg" /></a><br /></div><br /><br />A quick glance shows an uncharacteristically high value for May which we can quickly be reminded by looking into the transactions was due to some rather expensive repairs that took place in that month.<br /><br />Now I want to show you a raw report of similar data from another software package, Microsoft Money©.<br /><br />The first report shows the section for the decreases sorted here in reverse alphabetic order, by categories. If you were to cross check, you would note that the values are the same as those produced with the other software accounting package (Personal Accountz). The differences are that Microsoft Money uses pre-set category indexes which are flagged in the transactions to provide associations to the appropriate DWB categories and sub-categories. With this, we can distinguish between the elements of the DWB structure by queries related to category indexes, in contrast to Personal Accountz which uses individual accounts for each of these category and sub-category elements of the DWB structure.<br /><div style="BORDER-BOTTOM: 0px solid; TEXT-ALIGN: left; BORDER-LEFT: 0px solid; BACKGROUND-COLOR: #a0ffff; PADDING-LEFT: 4px; WIDTH: 400px; PADDING-RIGHT: 4px; FONT-FAMILY: arial; HEIGHT: 570px; COLOR: #000000; FONT-SIZE: 12px; OVERFLOW: auto; BORDER-TOP: 0px solid; BORDER-RIGHT: 0px solid; PADDING-TOP: 4px" ><br /><a href="http://picasaweb.google.com/lh/photo/IglDQaWzOlIwlKz5sFifjQ?authkey=ARYFTm1bZ14&feat=embedwebsite"><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgrw3FFETajXk8vX8w8z-RgFETBdChtyvEPqj-eaMYYvV_Omh9JIYVoIe_67tnk_yI_jy_MyMhTJqpod7PIgaNts480juzSIaDg2WFPz3vIJZpLHNZzeIxQneAQjBa-BSMboN2P9nsaA4o/s800/Raw%20msm%208ac.jpg" /></a><br /></div><br />The next report shows a formatted portion of the DWBS extracted from Microsoft Money. This time, you see a spreadsheet version of the Basic increases and decreases; this shows the layout in Microsoft Excel from which the printed version was obtained which you saw in three sections in the second example report, further above. The data for this report was transferred with a couple of key-clicks, from the Microsoft Money report by sub-categories immediately above (you can see the option ‘Export to Microsoft Excel’ in the left margin of the screen image). Some editing was done based on a pre-stored spreadsheet report layout which is used over and over again for the DWBS reports.<br /><div style="BORDER-BOTTOM: 0px solid; TEXT-ALIGN: left; BORDER-LEFT: 0px solid; BACKGROUND-COLOR: #a0ffff; PADDING-LEFT: 4px; WIDTH: 400px; PADDING-RIGHT: 4px; FONT-FAMILY: arial; HEIGHT: 800px; COLOR: #000000; FONT-SIZE: 12px; OVERFLOW: auto; BORDER-TOP: 0px solid; BORDER-RIGHT: 0px solid; PADDING-TOP: 4px" ><br /><a href="http://picasaweb.google.com/lh/photo/3T866qQRctuVln_HbHdxtw?authkey=ARYFTm1bZ14&feat=embedwebsite"><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEidtLCK3JwnkHP_F3XFq4FexO13_bMZ6jiAhGowXzpvYeiJ3QCFXH62Yrl8Jo8uG82g7rmCxDvAD1l16FSx_22vL43cJYFse8PIvL9dGBszzEWh8et0uy5YWd54C0AFV52uLKssBGEzgSw/s800/Raw%20msm%209ac.jpg" /></a><br /></div><br /><br />Another aspect or variant of reporting is graphic summaries. These will be examined in a later blog and so I will conclude here by remarking that we have only just touched upon some of the sorts of information that can be obtained from these reports as a basis for decision-making.<br /><br />Decision-making is at the core of financial management, including planning and control and I will devote considerable attention to this in later blogs.<br /><br />For those becoming interested and impatient to see more blogs in this series, I also have more information about DWB Accounting and my book 'Accounting for a Better Life' at my web site <a href="http://www.dwba.co.uk/">Domestic Well-Being (DWB) Accounting !</a><br /><br /></div><br /><br /><br />copyright © 2006 John M PassmoreNilgaihttp://www.blogger.com/profile/14912670556905736362noreply@blogger.com0tag:blogger.com,1999:blog-634486368075297184.post-24381137563369867562009-01-12T16:52:00.002+00:002009-01-12T17:07:11.218+00:00Domestic Accounting in PerspectiveIn my first, welcome blog, I gave you a very brief overview of some of the ideas behind Domestic Well-Being (DWB) accounting. In this continuing series of Blogs, I would like to delve into more detail about it all in the hope of getting you interested so that you might like to find out more about just how easy it is to gain and exercise control of your personal or home finances.<br /><br />Before getting into the practicalities, I thought it would be appropriate to set the scene by giving you a few of my thoughts in regard to how accounting fits into the scenario of home or personal domestic life.<br /><br />Essentially, accounting has evolved over a long time as a set of tools to help manage and control financial activity. Accounting is a way to model financial activity to make its effects more visible so as to be able to understand what is going on behind the scenes as a basis for trying to measure it and where appropriate, change its behaviour in some way.<br /><br />It is appropriate to realise that financial activity is going on all the time in our daily lives, regardless of whether or not we undertake or do accounting. This happens as we receive money as wages, salary, gifts or whatever; and also as we buy produce or services like food, clothing, utilities, holidays, houses, cars, insurance or stocks and shares. We may also be involved in financial contracts such as for a home mortgage or car purchase loan.<br /><br />We are actually participants in some form of accounting if we have a bank or credit card account for example. This is because banks and other financial organisations, as with all businesses, are legally required to formally account for all their financial activity. We see evidence of this as we are sent or access on-line, our statements of account for the current or savings accounts that we may have opened with a bank. Remember that these statements are products of the accounting systems run by the banks and therefore give us the bank’s view of the financial activity that they may have been involved in, with us, as their customers. This has some ramifications in respect of terminology, particularly the words debit and credit, but more on that later!<br /><br />For most people, there are only a few situations in a lifetime where they may become involved with accounting concerning their own financial affairs. The most significant of these and which they will not know anything about, is the winding-up of their affairs after death! Death obviously marks a transition and in civilised society where the state has a great interest in financial matters, mainly because of tax, the transfer of the wealth of the departed to their legal beneficiaries of the estate has to be accomplished in an ordered and formal manner, with legally approved executors to administer these affairs.<br /><br />Of course, individuals can play an important part in making these procedures as easy as possible for their executors by ensuring that they have drawn up a will and making available as much information as possible for them in appropriate documentation in the records they leave behind. A set of domestic accounts would be perfect!<br /><br />Interestingly, it is the fact that it is the value of the estate of the deceased that has to be passed on to the beneficiaries of the estate that has an important implication for us if we decide to do proper accounting of our household finances. The implication is that it is the value of the estate which I call the Domestic Wealth that is in effect, owed to the eventual beneficiaries; it is therefore a form of liability of the household to the beneficiaries, without needing to know who they actually might be. We will come back to this point in a later blog when I discuss domestic accounting theory and the so-called, domestic accounting equation.<br /><br />Other life-time events where accounting may become important is when applying for a home mortgage or other large loan. Usually, quite detailed information about current income, regular outgoings and other liabilities will have to be provided along with credit checks, in order to justify our future ability to be able to afford the repayments on the mortgage or the loan.<br /><br />When trouble occurs with our finances and debt becomes a serious problem, formal assistance with debt recovery and the various options potentially available such as Individual Voluntary Arrangements (IVA), Debt Management Plans (DMP) or even bankruptcy, may necessitate detailed evaluation of the individual’s financial situation. This could take the form of accounting extracts to build up something similar perhaps to a Statement of Affairs (Debtor’s Petition) which requires very detailed financial information.<br /><br />Separation or Divorce may also involve aspects of accounting, particularly where ancillary relief proceedings or Financial Dispute Resolution are required in order to resolve any financial issues.<br /><br />Trusting that most of us will not be too concerned with serious debt or separation, we are mostly not likely to be involved too much with accounting – unless perhaps we act as an executor for someone in regard to the administration of their affairs after death.<br /><br />Having said that, most of us will dabble on the edges of accounting from time to time at different stages of life, particularly when important decisions have to be made that have cost implications. Most obvious is house purchase and car purchase but even exotic family holidays and Christmas expenses may require some form of financial analysis to determine levels of affordability and budgetary constraints.<br /><br />Those deciding to tackle financial management a little more seriously may perhaps undertake bank statement reconciliation, some form of budget creation and often these days, utilise spreadsheet programs to try to make more sense of their finances. Income tax obligations require us to gather and bring together financial information once a year to meet our legal commitment to filing proper submissions. This of course is to establish our responsibility regarding how much we have to pay back towards this ever-present demand.<br /> <br />The problem with ad-hoc accounting in order to respond to the need for relatively infrequent financial decision-making is that there will be considerable overheads involved in order to gather, find out and record the necessary information. This may require searching through past records, bank and credit card statements and receipts, assuming that they have been saved and can be found. Then, once it is done, the decision made and the house or whatever purchased, the value of the gathered information will quickly deteriorate over time. Thus when the next decision scenario comes along, the process will effectively have to be repeated all over again, perhaps from scratch.<br /><br />Furthermore, the information gathered tends to be of the static type, of the value of assets and liabilities. Information about the dynamics of change, the day-to-day increases and decreases, is more difficult to re-establish and will usually again be limited to what can be discovered from individual pay slips, receipts, debit and credit card vouchers and account statements.<br /><br />At the time of New Year resolutions or other moments of desperation where it is decided to draw up budgets and to start trying to track spending, perhaps using spreadsheets, it is almost impossible without considerable overheads, to categorise and record such spending in a meaningful way. Furthermore, there will usually be no past information (because it hasn’t been collected, collated and saved) against which the new figures can be compared. So often, these initiatives quickly get forgotten and life soon continues on in just the same old way with any financial management being left to instinct and hope, or perhaps plain old intuition.<br /><br />Credit card balance manipulation may also be very important in the early years when the increases seem way too little to fund the decreases being experienced. Discipline, discipline, discipline!<br /><br />Yes, the majority of us get by with these methods but what do we really know in detail about our finances? Are we in as good a position as we ought to be? Are we affording the right proportion of our expenditure on the future, compared to the nice-to-have's, now?<br /><br />The advantages of starting proper domestic accounting are that a routine can quickly be established with very acceptable overheads in terms of cost and time.<br /><br />With this, information can constantly be collected so that for those major and not so large financial decisions, all the required information is always immediately to hand and past records still available as a base for comparisons.<br /><br />Furthermore, control of the type attempted by those periodic desperation initiatives can now be undertaken continuously – or even stopped and started as needed – provided the basic bookkeeping is methodically and regularly undertaken.<br /><br />Even more important, new forms of financial control can be started, addressed by the new concepts embodied in Domestic Well-Being (DWB) Accounting. These are the ideas about achieving the best possible financial balance to ensure that there is an equitable distribution across all the different financial responsibilities facing a household as they constantly change, throughout a lifetime; and also so that debt can be minimised or its recovery managed if it has already occurred.<br /><br />Next, I want to start telling you about some of the features of DWB accounting – the products, the theory, starting it up and the practicalities of using it on a day-to-day basis.Nilgaihttp://www.blogger.com/profile/14912670556905736362noreply@blogger.com0tag:blogger.com,1999:blog-634486368075297184.post-12494357880412047262008-12-28T16:03:00.004+00:002008-12-28T17:34:08.277+00:00WELCOMEThis is me - on a fantastic trip to Antarctica a couple of years ago!<br /><br /> I have always believed that accounting was the only way to ever really get control of my own finances. I tried to do it using the only methods that I could find at the time; and the trouble was that the available methods were all based on business accounting.<br /><br />It proved to be quite difficult and once I discovered how to do it, I found that it really didn't help too much! It all had the wrong focus. By this, I mean that business accounting was all about producing results (particularly the reports, graphs and ratios) to help business people maximise their profits to increase the business owners' value. That of course is quite understandable when you think that accounting has evolved over a very long time, essentially to meet the needs of businesses.<br /><br />I decided I needed an accounting system with a new focus that matched the personal needs of a single person or a family situation so that their finances could be controlled.<br /><br />I eventually came up with a solution which I describe as a new accounting model. As such, it defines a new set of reports, graphs and ratios, together with the sort of accounts needed to hold the necessary information to produce these reports and the methods required to make it all work together. The name of the new focus is 'Domestic Well-Being' and so the purpose of Domestic Well-Being (DWB) accounting is to enable people to maximise it, in contrast to maximising profits with business accounting.<br /><br />It is not a software package but as a model, it is possible to set it up to run on off-the shelf personal accounting software packages that are available for running accounts on a home PC or laptop. Having set it all up, the overheads are the order of an hour and a half a month in order to do the bookkeeping (entering the transaction data) - trivial compared to the potential benefits available!<br /><br />I am not going to say too much about the model in this first, introductory article but I should tell you that I wrote a book about my methods, called 'Accounting for a Better Life' and there is a web site at <a href="http://dwba.co.uk/">http://dwba.co.uk</a> where you can find out more about this subject.<br /><br />I will just say a little about what it might mean to manage or control personal finances to try to give you a feel for what it is that personal accounting might try to solve and how it might relate to maximising DWB.<br /><br />If you think about financial activity in a personal or household setting, it is all about spending money to live, based on incomings (the increases) - from wages, salary, windfalls or whatever. Spending money on living results in decreases which have to be allocated to things such as food and drink, accomodation, furnishings, taxes, health, transportation, insurance, hobbies, social activities, vacation and maybe, even a few luxuries.<br /><br />Our so-called worth or Domestic Wealth consists of our assets (house, car, cash, investments, etc.) less our liabilities or what we owe (mortgage, car loan, credit card balances, etc.) plus over any period, our increases less the decreases.<br /><br />Managing and controlling our finances is essentially all about knowing about our domestic wealth to make sure that it is healthy - that we are living within our means, and that we can take care of all our financial responsibilities to both ourselves and our family. Many of these responsibilities concern payments now into some form of savings or investments to ensure that we can take care of future needs - education, improved living conditions, better holidays and most important of all, retirement. It is retirement which with increased longevity, will occupy an increasingly greater portion of our overall lifetime.<br /><br />Since accounting is all about keeping track of assets, liabilities, income and expenses, it could be of enormous help if we could find a way to relate it to the characteristics of personal or household finances. That is what DWB is all about; it is a structure that characterises domestic wealth, particularly the increases and decreases, based on the pattern of day-to-day household financial activity.<br /><br />With this, we will obtain the fantastic visibility on our affairs to be able to ensure that we can best balance our commitments in relation to our income, through prioritisation related to our personal ambitions and responsibility. Control implies decision making to make changes based on the current situation in order to achieve the desired results. DWB accounting will expose the current situation in a way to facilitate this decision making, on a continuing basis, so that the resulting effects can be monitored, compared and adjusted if necessary.<br /><br />The implications for success are a sense of responsibility to oneself and the family situation, awareness that accounting in itself will not result in any improvements but that it can point the way to a better life and finally, that discipline will be needed to make the changes exposed by use of this new form of home and personal accounting.<br /><br />Future articles will expand upon the ideas behind Domestic Well-Being accounting.Nilgaihttp://www.blogger.com/profile/14912670556905736362noreply@blogger.com0