Where Did The Money Go? Try Where Did The Money Go?TM  FREE For 30 Days... What Are You Waiting for? Testimonial “When I first saw this, I would have happily paid $1,000 - simply because Where Did The Money Go would save my bookkeeper 2 days per month - and give me better information about my business.” Brett Gilbertson, Major IT
Tips & Tricks On Using Where Did The Money Go?TM Success Is Often All In How You Hold Your Tongue... Don’t you hate it when things sometimes work really well and sometimes don’t? And you can’t tell why? Well, software is no different to anything else in life. Until you have played with software for a while, some things are not readily obvious, which is why we have created this “Tips and Tricks” section. 1. Some numbers do not calculate in the final reports The Profit Drivers report will not calculate a sales conversion ratio if you do not put any data into the “Monthly Actual Enquiries (#)” fields on the “Constants For Next Run” tab in the software. Similarly, Break Even Points will not calculate if you do not put any data into the “Monthly Actual Trading Days (days)” fields on the same tab. What this means is that the spreadsheet will render with zeros (see below), and that everything that relies on that data will either render as zeros or as #DIV/0! errors. BUT as the net result of the reporting process is an Excel spreadsheet, you will find that both of these pieces of data can be entered AFTER the spreadsheet is created, as has been done above. As you can see, once the data has been entered, any cells with formulae relying on the data will then calculate. 2. All data that can be entered into the “Constants for Next Run” Tab is rendered as a light yellow background in the created spreadsheet. So whether you choose to enter the data into Where Did The Money Go?TM and then have it transferred into the created spreadsheet, or enter it directly into the created spreadsheet itself, you will always know where those data entry points are. Enter it anywhere else in the spreadsheet i.e. any cell that is not light yellow coloured, and you will stuff the spreadsheet formulas. But relax...each time you run Where Did The Money Go?TM, a new spreadsheet is created - and the formulas will be fixed. 3. Each time I run WDTMGO, does it overwrite my spreadsheet? No it does not. But even so, we recommend saving your created spreadsheet file as a separate file each time you run the reports e.g. 20100331 Mgmt Reports, for March reports, and 20100228 Mgmt Reports for February reports. This way, if you add any data or additional reports into the February reports that you want to appear in the March reports, you can easily copy and paste them from one file to another. 4. Using named ranges in calculations If you are creating formulas that drive off report data, and you want to be able to copy and paste them into each month’s reports, we suggest that you use the named ranges created in the reports file as the basis for your formulas instead of cell addresses. This allows your cutting and pasting to still be relevant in the new file if the details have changed. For example, if a new account has been added into the Balance Sheet during the month, then all of your totals below that account in the new file will not correspond to the cell addresses referring to those totals in the previous month’s reports. If you do not know how to find the named ranges, click on the drop down box just above the A column (see above and to the right). This is called the Name Box, and when you select a cell or group of cells, it tells you what the name of that cell or group of cells is e.g. E3. Click on a name, and see what range of cells is highlighted. If it is the correct range of cells for your formula, use the named range in your formula instead of the cell addresses. An example of a formula that we have used is: =VLOOKUP("TOTAL OTHER CURRENT LIABILITIES", WD_8_Other_Current_Liabilities_Totals, 25, 0) This formula tells the spreadsheet to look for the term “TOTAL OTHER CURRENT LIABILITIES” in the range of cells covered by named range WD_8_Other_Current_Liabilities_Totals, and return the value at column 25 within the range. 5. Why are there #DIV/0! errors in the spreadsheet reports? We could have created the reports to put zeros into these cells instead of these error messages. BUT we decided that the data that is missing which is creating these errors really needs to be added into the reports. So we left these error messages in the final product to act as a visual cue to alert the user that critical data is missing from the reports. We know it is not pretty, and we could have made the cell say something like “Missing Data Critical to Calculations” or something like that. But it would not fit into the cell, and you would only get a partial “Missin” appearing - which might just fade into the background. Leaving the #DIV/0! error messages ensures that this does not happen - which means that the user is forced to enter the info to ensure that they get better information about their business. Want to see some screen  shots? Made with Xara Web Designer