1. Home
  2. Accounting Spreadsheet
  3. Monthly Data Input – PFS Document

Monthly Data Input – PFS Document

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.

Monthly Summary

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.

Income Section

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.

Expenses

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.

Updated on June 30, 2019

Was this article helpful?

Related Articles

Leave a Comment