The Report Writing Tutorial guides you through creating your own custom report using the MoneyWorks report generator. Most of the presupplied reports have been created as custom reports, allowing you to modify them if needed. If you wish to create your own reports, you should work through this tutorial and then read the Reports.
Creating Your Own Reports
MoneyWorks reports are kept as separate documents: the reports that are supplied with MoneyWorks are kept in the Reports folder in the Standard Plug-ins folder; any reports that you modify or create should be kept in the Reports folder in the Custom Plug-ins folder. This keeps them separate from the pre-supplied ones, allowing you to back them up easily and also to preserve them in future upgrades of MoneyWorks —see Managing Your Plug-ins. Only reports in the Reports folders in these two Plug-ins folders are displayed in the index to reports and the Reports menu.
Because MoneyWorks reports are stored as separate documents outside of your actual accounts, you can use the same report for different companies. You can even use reports created by other MoneyWorks users, and they can use your reports.
Although this tutorial is based on the tutorial file “Acme Widgets”, creating a report is not always document specific so you can use your own document if you wish—creating a report does not affect the MoneyWorks document itself. However remember that the sample reports shown will look different if you don’t use the Acme Widgets file.
In this tutorial we will create a simple gross margin report as shown at right. The report shows the current month’s sales and cost of sales with a percentage breakdown, then last months figures and the dollar difference.
- Choose File>New>New Report
An untitled Report window will open.
A MoneyWorks report consists of parts (or rows) and columns. When you create a new report, one part (the row labelled “Heading”) and one column (COL1) are created with it, as shown above.
In a profit report, the rows will contain details of our income accounts, then details of our expenses. The columns can contain whatever we feel is appropriate. For example we might want to have this period’s values, year to date figures, budgets and variances, or just the amount left in our budget.