This article relates to the 2018 Malgra Accounting Spreadsheet
Using the monthly tabs
At the bottom of the spreadsheet, you’ll find a tab for each month. Using each section, you can add data to the system to allow for automated calculations.
This section provides an overview of your month, automatically calculating your income and expenses. Additionally, a profit/loss section is added so you can see how profitable your month has been.
Following user requests, we’ve added a ‘notes section’ at the top, to allow you to add any comments you may need, or reminders for where you’ve stored receipts.
PFS Document Figures
This section allows automatic calculation of your income and loss from your group fees. You should load up your PFS Monthly Document to find details of your monthly accounting details.
The final column of your PFS Document is where you’re looking, and these figures should be transposed to the spreadsheet. In the example below, the last column contains the figures you need.
The system will auto-calculate the amount for you.
If you have SWOR (Slimming World On Referral) or Gift Vouchers during the month, you cannot use the figure provided in the total sundries box as it may correct out the XPW Insurance Fee with the amount you receive in credit for SWOR or Gift Vouchers. If so, you will need to check your manual weekly group summary to work this figure out.
From the example above, these have been added to the relevant section on the spreadsheet in the image below
This will then auto-populate sections of the sheet for this month.
The income section will automatically populate some figures from your PFS Document figures. From the example we’ve used in this guide, the system has calculated that total income from group fees is £1402.00 and the commission as an agent (selling Slimming World Magazine and HiFi Bars) is £50.20.
There are also additional sections for you to add any supplementary business income you may have for this month. For example, did you sell something to another consultant, or did you sell something to a third party and earnt an income? (e.g. when closing your business). This should be logged here. You can add details, and any figures in the relevant white boxes.
Similar to the Income section, this part will have some details pre-populated from your PFS Document. These include your rent (paid in full by the consultant) and also any franchise fees to Slimming World. Your XPW Insurance fee will also display (remember that if your sundries include any SWOR or Gift Voucher payments, you’ll need to calculate these separately).
You can then add details of any allowable expenses in the table below.