MoneyWorks Gold has a departmentalized GL. meaning that you can create departments, assign them to a department group(s). The Department Group is assigned to the various, income and expense accounts that you want to track by department. You can then produce individualized income statements/P&Ls for each department, groups of departments or combined departments in a classified/combined income statement.
The Departments window, opens click New Icon [Red Arrow] and in the new Department window, assign a Code [Blue Arrow. The code is limited to 5 alphanumeric character. Then assign a description [Green Arrow] presumably the unit no. or some other descriptive ID. Click Next to create another Department (Rental Unit in this case) until you have entered all the units. Then Click OK.
Note about Departments: In this example we now have three departments/rental units, although you could enter as many as required. However in MoneyWorks Departments can be used to individually track the revenue and related costs to any measurable business unit. e.g. multiple branch offices, tracking individual or grouped P&Ls or a fleet of vehicles where you are just tracking the leasing, maintenance , repairs, and fuel costs for each vehicle and this producing individualized cost centre reports by vehicle.
Click the + icon next to Department Groups in the Chart of Accounts Navigator above [Blue Arrow].
A Department Group will window open. Assign Code ( 5 chars) [Blue Arrow] , a Description, the building name in this case [Green Arrow] and click the Add button [Red Arrow].
The Add to Group window will open where all departments will be shown, highlight the ones that belong to this building [Purple Arrow]. Click Add [Orange Arrow]. We now a Department Group for the Building in this example, made up of in this example three rental units or departments.
Note About Departments Groups: Department Groups are used to organize departments and the Group of departments is then assigned to the accounts you want departmentalize. So in the future if you added more departments, say more rental units to this building or new branch ot vehicle to the fleet, all you would have to do is create a new department and then add it to the Group which MoneyWorks then automatically assigns to all the different departmentalized accounts.
Since in this example we not only require individual P&Ls per rental unit, but also a separate combined P&L for the Building, this is accomplished in MoneyWorks by creating a Classification and assigning the departments that make up that Classification. Click the + icon next to the Classifications icon [Orange Arrow] in the Chart of Accounts window at the top of this post.
The Classifications window will open, Click New Icon [Red], the new Classification window opens [Green], assign a unique 5 chars code [Blue Arrow], a description for the Building could be the same as the Department Group Name, Click OK. Note: you could use the same Code & Description as the Department Group, since it might be more recognizable, but for this example e will keep the IDs different.
So we now have 3 rental units/departments, 1 Department Group the Building and 1 Classification for a separate by Building.
Departmentalizing the Accounts
We now need to assign the Department Group to the various income and expense accounts that we want to track by rental unit for our building. Open the Accounts list in the Chart of Accounts window above you can’t miss it, as appropriately every is pointing at it or use the hot key Cmd key + 1 (Mac) or CNTRL key + 1 (Windows).
Entering Departmentalized Transactions
When entering income or expenses to a departmentalized account you choose the department that you are entering the details to.
e.g a receipt for January rent from Unit 1 tenant. Enter the account by typing Rent and choose the Rental Income account 5300 [Green Arrow] and the Account Choices window will open where you must specify which department you are recording the income to [Blue Arrow], double click Unit 1 or highlight and select choose and it will be recorded in the detail line.
For our example we have entered rent received and expenses for the three rental units and want to produce individualized reports. The MoneyWorks Balance Sheet and Income Statements /P&ls provide a multitude options when using departmentalization.
In this example we will various P&L reports for the month of January when our transactions took place. Click the “Profit for this Month” report at the bottom of the Chart of Accounts Navigator or use the Reports menu at the top of the screen > Profit & Loss for Month”. The report’s Setting Window will open and set the settings as below. Click Preview and you will get the standard P&L report on the right, just listing the accounts (not departmentalized sub-accounts).
If you chose Show Department in the settings [Red Arrow]…
To report individualized Departmental reports which is what the initial intent was, click the More Options in the Settings [Green Arrow below], which changes to lists the various options to print individual reports by department. Choose “Departments” [Blue Arrow] in the list as shown below.
By highlighting the departments you want to report on, you can print a report for one department, a selection of departments or all departments. There will automatically be a page break after each departmental P&l chosen.
In order to get a single report combining all the monthly activity (transactions) for the building, Choose the Classification option, choosing the Classification that was created above and the resulting report will be a summary of the three departments/units in this case.
Note: Existing reports in MoneyWorks Gold are easily modified so the Rental P&L in this example could relabeled with headings such as Rental Income and Rental Operating Costs etc, and unnecessary rows or headings could removed.
Bottom line MoneyWorks Gold allows you to easily setup, manage or add new departments and create unique, individual or combined reports on your departments.
For more information about MoneyWorks Support in Canada, in the USA, or in the UK contact www.moneyworkssupport.wordpress.com