Share this content on Facebook!
26 Aug 2016
The way to Produce Management Accounts - Passport renewal expedited service

The following information is primarily aimed at fresh graduates, elementary job hires, professional students, and then any individual linked to the profession of accountancy (and management accountancy especially), who wants to experience a quick summary of what sort of list of management accounts can be achieved and what entails in their production, without needing to read a 200 page book. A lot of the knowledge lay out henceforth comes from the point of look at your service-based industry and assumes the various readers to possess a reasonable knowledge of the basic concepts of accounting.

accountants in glasgow



The scope of the guide is to give the readers a string of activities which i have followed, inside my own experience, to create a regular monthly reporting pack in my senior management team. This sequence of activities and the importance which i adhere to each activity can be very different to the line of business that you're in. With that said, I do expect that most of you will experience an even more vivid and succinct picture with the production process, which you'll want to then imitate and integrate into the own particular circumstances.

So, let's begin!

Exactly what are we attempting to produce?

In most organisations, the board or senior management demands the management accountant/chief accountant to make a monthly profit and loss account/income statement, in order that the organisation's performance against set budgets (mostly prepared at the beginning of each financial year) and expected forecasts (mostly updated at intervals of month end) could be gauged. A regular monthly management accounting reporting pack will not only add the monthly income statement, but a variety of other useful reports too. However, money statement does constitute the bulk of the reporting which is what we will try to generate in this guide.

In a nut shell, via a certain group of activities and for certain period (usually a month), we determine: the revenues generated by the business, the costs incurred from the manufacture of such revenues (often called 'cost of goods/services sold') as well as the costs incurred to deliver support to such revenue generation and goods/services production. This price is sometimes known as the central overheads' costs or support functions' costs or even the service-centre costs.

What you need to know before you start production?

Most businesses make use of a "Chart of Accounts" within their accounting systems (may it be: Sage, SAP, Oracle, SUN, Viztopia etc.) to classify and record various transactions involving differing types of assets, liabilities, capital, revenues, and expenses.

A Chart of Accounts or COA, when i love to refer to it as, is really a listing of all nominal ledger accounts that a business offers to use to record its transactions. This list of accounts could be in the shape of numbers, alphabets or alpha-numeric values. Due to my personal experience, I favor numbers.

So, to offer an illustration, our full COA might range between the numbers 0001 and 9999 and on this range, we could have multiple ranges, each representing an asset, liability, capital, revenue or costs type. As an example, the number 5000-5999 might only represent different varieties of revenue streams for any business and the range 1000-1999 might only refer to all fixed assets held through the business.

These are merely samples of the way the COA could be divided. You must know what range/s of nominal account codes with your business's COA constitutes the revenues, the expense of goods/services sold, the central overheads, the assets, the liabilities, along with the capital.

You won't be capable to view the income statement (that's what you really are essentially looking to produce), if you do not view the Chart of Accounts. The wages statement is basically reading all data held in the COA range/s concerning revenues and expenses for a given month/period.

Once you have understood the division from the COA, then you're able to truly comprehend the monthly income statement template that the organisation already has set up. If you are assigned the task to develop one on your own, then this guide just isn't for you. In this guide, we now have assumed that your organisation already features a certain monthly reporting template in position, which the wages statement could be the main one.

A large amount of organisations produce their monthly management accounts in Microsoft Excel. The wages statement, with regards to the business, will likely be split into multiple sections. For purpose of the following information, we will make use of the following sections that make up a normal income statement:

- Revenue
- Expense of Goods/Services Sold
- Gross Profit
- Selling Expenses
- Marketing Expenses
- Contribution To Central Overheads
- Central Overheads Recharge
- EBITDA

Each of the above parts of the income statement is going to be consisting of several nominal codes from the COA. For instance, the revenue area of the income statement in MS Excel could possibly be pulling together/summing the information from codes 5000-5999 add the main accounting software, for a given month. How can excel accomplish that? Well, most organisations apply kind of intermediary excel tool to drag data right out of the main accounting software (where a record of transactions sit) onto excel. That is why it's important to know your organization specific COA, so you know what makes up revenue as well as what makes up, let's imagine, cost of goods sold.

To recapture what we should have just said above:

�?� Even before you open up your business's monthly reporting pack, ones the wages statement template is the central, you must understand your Chart of Accounts.
�?� Most management accounts' packs/templates, are available in excel
�?� Transactions are recorded using accounting software, such as Sage, Sun, Sap etc.
�?� The monthly income statement template is divided into sections, such as Revenue, Tariff of Sales, Gross profit etc. Each section is reading a number of nominal codes in the main accounting software and summing them up for the given periodic month inside the ms excel reporting templates.
�?� This summing/collation of data into excel through the accounting software, using nominal codes, is often done with the aid of an excel Add-on tool.

Hopefully, to date, so excellent! Let's progress now.

The Production Process

Generally speaking, the finance department of nearly all companies, including medium and small to big publicly listed companies, might have the next sub-departments, either separately or combined, inside the main finance function:

- Sales Order Processing - SOP
- Sales Ledger
- Credit Control
- Purchase Ledger
- Management Accountancy
- Financial Accountancy

On a day by day basis, orders are processed for the sales ledger system. The sales ledger system can exist in a company's main accounting software or it could be a separate system altogether. Caused by sales order processing will be the manufacture of sales invoices.

These sales invoices are chased with the credit control department for number of the monies due. Once monies are receipted at the bank, such receipts are recorded from the sales ledger department on the main accounting system.

Alongside this, every day, the purchase ledger department is processing 'purchase invoices' i.e. bills that the business needs to pay. For many businesses, it of purchase invoices involves:

�?� Categorizing / classifying each bill to some cost type/s
�?� Assigning the charge to some specific product &/or department &/or business unit

E.g. In case a business has spent �5,000 on printing and binding of an magazine (assuming the sunday paper is a "product" / "revenue stream" to the business), the purchase ledger manager would record this cost like a direct cost (passing on a principal cost nominal ledger code through the Chart of Accounts) and assign the price incurred on the "Production Department" and also the "Print Publications" Business Unit of that organisation.

The check is settled in due course from the purchase ledger manager.

The end result is that over a everyday basis, sales invoices are now being raised and monies received, alongside bills being recorded and settled. At the conclusion of month after month or with a take off date right before get rid of monthly, you'll request all relevant departments to generate no further entries when for which management accounts should be prepared. Your management accounts start here!

MPL Media Plc

When it comes to this quick guide, we will build a fictional organisation, operating on tv industry producing monthly magazines. We shall call it MPL Media Plc.

MPL media has every one of the previously discussed finance functions plus the following in their organisational structure:

- Production Department
- Editorial Department
- Data and Marketing Department
- IT
- Facilities
- HR

MPL media derives revenue from selling advertising space on its magazines. All orders relating to a particular magazine are invoiced upon publication and distribution with the magazine. All design work and editorial content of the magazine is created in-house by the editorial and production departments, whereas the printing, binding, wrapping and distribution in the magazines are finished by selected outside suppliers.
MPL media uses an excel tool to pull data rid of its accounting software into excel. It can make this happen on a transactional level as well as mere summaries.

ACTIVITY 1 - Direct Cost Prepayments

Having instructed/stopped any additional entries to be made inside the month which is why the management accounts can be produced, the 1st from the report on sequential activities the management accountant does will be the prepayment in the direct costs.

As mentioned earlier, a number of the nominal codes within the COA will relate with the price of goods/services sold. In the case of MPL media, all nominal ledger codes concerning printing, wrapping, design, editorial content and distribution of the magazine are treated as "direct costs" of manufacturing this type of magazine. In addition, each magazine for sale through the business will have a publication date. Due to this publication date, we can ascertain how and what many magazines to recognize as revenue and costs inside the month, in which management accounts are increasingly being produced.

Any direct costs in relation to magazines whose publication dates fall at night last date of the month which is why the management accounts are prepared, should be taken out of the income statement and pushed on the balance sheet as a "Direct Cost Prepayment". The straightforward journal admission to do this is always to credit the appropriate direct costs nominal accounts and debit the total amount sheet prepayment account.

accountants in glasgow



Comments

There isn't any comment in this page yet!

Do you want to be the first commenter?


New Comment

Full Name:
E-Mail Address:
Your website (if exists):
Your Comment:
Security code: