Farms - Enhanced Charts

In this Topic Hide

Farming Reports

Trading Profit and Loss Accounts

 


 

Client type

A farm client may be set up as either a Sole Trader, a Partnership, a Limited Company or a Limited Liability Partnership.

Accounts chart

The EPSF chart is based on the EPST chart and is used for Sole Trade, Partnerships and LLPs.

The ELTF chart is based on the ELTD chart and is used for Limited Companies.

Enterprises

Three types of enterprises can be setup under Edit | Enterprises under Arable, Livestock or Other. Any number of enterprises can be created under each category against the enterprises so that only current enterprises appear when making postings.

 

Farming Reports

Management Reports

5 year Management reports are available for Variance and Balance Sheet reports for Limited Companies and Partnerships/Sole Traders:

VAR

Variance

BL5

Balance sheet

MAN

Management reports.

 

Partnerships/Sole Traders

PSN/PSA - Complete set of farming reports for Sole traders and partnerships:

PSA

 

PSN

 

FLY

Fly Sheet

FLY

Fly Sheet

 

IND

Contents

IND

Contents

CIN

Company Information

CIN

Company Information

ACR

Accountants' Certificate (if applicable)

ACR

Accountants' Certificate (if applicable)

TPF

Trading and profit and loss account (see later for details and alternatives)

TPF

Trading and profit and loss account (see later for details and alternatives)

BL3

Balance Sheet

BL3

Balance Sheet

CUR

Capital and current accounts

NOP

Notes

IAX

Intangible fixed assets

 

 

FIX

Fixed asset schedule

 

 

HBA

Herd basis

 

 

 

Alternatively, PSI can be run:

FLY

Fly Sheet

IND

Contents

CIN

Company Information

ACR

Accountants' Certificate (if applicable)

IEA

Income and Expenditure Account

 

Limited Company

FLY

Fly Sheet

IND

Contents

CIN

Company Information

ACL

Accounts' Certificate or Audit Report

PL1

Statutory Profit and Loss Account

RGL

Statement of Recognised Gains and Losses

BL2

Balance Sheet

CFS

Cashflow Statement (if applicable)

NOT

Notes

AUX/
AUD

Audit Report (if applicable)

TPF

Trading Profit and Loss Account (see below for details and alternatives)

 

Back to top


 

Trading Profit and Loss Accounts

There are a number of different layouts possible for the profit and loss accounts. Details of TPF, TPG, TFS, TFF and PDF are given here.

TPF - Standard Trading Profit and Loss Account with enterprise accounts

Generates a Trading Profit and Loss Account similar to TPL but has the option to have separate enterprise accounts generated at the end of the report. This option is available via the data screens under Specialist Reporting Information | Options.

 

Where enterprise accounts are not required:

Income

(group 1 description)

 

 

Sales Accounts

(1 to 10 listed individually)

 

xxx

 

 

 

xxx

Opening Stock

(total of group 22)

 

xxx

 

 

 

xxx

Closing Stock

(total of group 34)

 

xxx

 

 

 

xxx

Cost of sales accounts

(27 to 71 listed individually)

xxx

 

 

 

 

xxx

 

 

 

xxx

Scheme income

(accounts 85 and 86 listed individually)

 

xxx

GROSS MARGIN

 

 

xxx

 

 

 

 

etc...(as standard profit and loss report TPL)

 

An example of the first enterprise account follows:

Enterprise gross margins

 

 

 

Cattle

Descriptions are picked up from the

 

xxx

Sheep

enterprises as entered under Edit |

 

xxx

Pigs

Enterprises

 

xxx

Barley

 

 

xxx

Wheat

 

 

xxx

 

 

 

xxx

TOTAL GROSS MARGIN

 

 

 

Variable costs

(group 25 descriptions)

 

xxx

List of accounts

(26, 44 to 71, 82 listed individually)

xxx

xxx

 

 

 

xxx

 

 

 

xxx

Accounts with no enterprise selected

xxx

 

GROSS PROFIT/LOSS

 

 

xxx

 

 

 

 

etc...(as standard profit and loss TPL)

 

The profit and loss account is then followed by the enterprise accounts, FM1, which are each given a separate page.

An example of the first enterprise account follows:

CATTLE

 

 

 

 

ENTERPRISE ACCOUNT

 

 

 

 

Income

(group 1 description)

 

 

Sales accounts

(1-10 listed individually)

 

xxx

 

 

 

xxx

Less

 

 

 

Purchases accounts

(27-36 listed individually)

xxx

 

 

 

 

xxx

 

 

 

xxx

Less

 

 

 

Opening stock

(total of group 22)

 

(xxx)

 

 

 

xxx

Add

 

 

 

Closing stock

(total of group 34)

 

xxx

GROSS OUTPUT

 

 

xxx

Variable costs

(group 25 description)

 

 

Variable costs

(26, 44-71, 82 listed individually)

xxx

 

 

 

 

xxx

GROSS MARGIN

 

 

xxx

 

 

 

 


TFS
- Trading profit and loss account with summary/income/expenditure

Generates a Trading Profit and Loss Account, made up of a Summary page, an Income report (TFI) and an Expenditure report (TFE). To use this report instead of the Standard Profit and Loss report (TPF) you will need to set the following alias; TPF = TFS.


The summary page will show the following:

Income

(Group 1 description)

 

 

 

 

Arable

 

xxx

Livestock

 

xxx

Other

(listed individually as entered under Edit |

xxx

 

Enterprises)

 

 

 

xxx

Scheme income

(accounts 85 and 86 listed individually)

xxx

 

 

xxx

Other income

(group 41)

xxx

 

 

xxx

 

 

 

Expenditure

(Group 91 description)

 

 

 

 

Variable costs

(group 25 description)

xxx

Fixed costs

(group 953 description)

xxx

 

 

xxx

Interest receivable

(Group 81 description)

xxx

 

 

 

NET PROFIT/LOSS

 

xxx

 

The Income report TFI will then be generated. This report provides the information concerning the livestock and arable enterprises and any other income (other than interest received).

The layout is as follows:

ARABLE INCOME

 

 

 

 

 

 

 

Wheat

(as entered under Edit | Enterprises)

 

 

 

 

 

 

 

 

 

 

Opening stock  

(accounts 17-25 listed individually)

(xxx)

 

 

Purchases accounts

(27-36 listed individually)

(xxx)  

 

 

Closing stock

(accounts 73-81 listed individually)

xxx

 

Sales

(accounts 1-6 listed individually)

xxx

 

 

 

 

 xxx  

 

 

Produce sales

(accounts 7-9 and sub accounts of 10 listed individually)

xxx  

 

 

 

 

 

xxx

 

 

 

 

continues as above for all arable enterprises

 

 

 

 

 

xxx

 

LIVESTOCK INCOME

 

 

 

 

 

 

Cattle

(as entered under Edit | Enterprises)

 

 

 

 

 

 

 

 

 

 

Sales

(accounts 1-6 listed individually)

xxx

 

Opening Stock

(accounts 17-25 listed individually)

xxx

 

Purchases

(accounts 27-36 listed individually)

xxx

 

Closing stock

(accounts 73 - 81 listed individually)

xxx

 

 

 

xxx

 

Produce sales

(accounts 7-9 and sub accounts of 10 listed individually)

 

xxx

 

 

 

 

xxx

 

 

 

 

continues as above for all livestock enterprises

 

 

 

 

 

xxx

 

OTHER INCOME

 

 

 

 

 

 

 

Cottage Lets

(as entered under Edit | Enterprise)

 

 

 

 

 

 

Sales

(accounts 1-9 listed individually)

 

 

Opening Stock

(accounts 17-25 listed individually)

xxx

 

Purchases

(accounts 27-36 listed individually)

xxx

 

Closing Stock

(accounts 73-81 listed individually)

xxx

 

Sales

(accounts 1-6 listed individually)

xxx

 

 

 

xxx

 

Produce Sales

(accounts 7-9 and sub accounts of 10 listed individually)

 

xxx

 

 

 

 

xxx

 

SCHEME INCOME

(group 952 description)

 

 

 

 

 

 

Accounts 85 and the sub accounts of 86 listed individually

xxx

 

 

 

xxx

 

 

 

 

 

OTHER INCOME

 

 

 

 

 

 

 

 

 

 

 

Accounts 1-10(sub accounts) and 88-123 listed individually

xxx

 

 

 

 

xxx

 

 

 

 

 

 

The last part of the report TFE details the variable expenses and the overhead expenses:

VARIABLE COSTS

(group 25 description)

 

 

 

 

 

 

variable costs listed individually (accounts 26, 44 to 71, 82)

xxx

 

 

 

 

 

FIXED COSTS

(Group 853 description)

 

 

Fixed costs listed individually (accounts 152 to 407)

xxx

 

 

 

 

 

xxx

 

 

 

xxx

 

TFF - Trading profit and loss account with livestock/arable trading accounts

Generates a Trading profit and loss account followed by Livestock trading account (TFL) and then an Arable trading account (TFA).

To use this report instead of the standard profit and loss report (TPF) you will need to set the following alias under Edit | Report Aliases; TPF = TFF

 

The layout of the trading profit and loss account is as follows:

Livestock trading surplus

 

 

xxx

Arable trading surplus

 

 

xxx

Accounts 42-51 listed individually

 

xxx

 

 

 

xxx

 

 

 

 

Direct Costs:

(group 921 description)

 

 

Accounts 104-125 listed individually

xxx

 

 

 

 

xxx

Gross Profit

 

 xxx

 

 

 

 

etc...(as standard profit and loss report TP2)

 

 

 

The Livestock trading account TFL is then produced as follows:

Livestock: Cattle

 

 

 

 

 

 

 

 

 

 

 

Opening valuation

 

xxx

 

Purchases listed individually

 

xxx

 

Livestock sales listed individually

 

xxx

 

Closing valuation

 

xxx

 

 

 

xxx

 

Produce sales listed individually

xxx

 

 

 

 

xxx

 

 

 

 

Livestock: Sheep

 

 

 

continues as above for all seven livestock enterprise accounts

 

 

 

GROSS OUTPUT

 

 

xxx

 

 

 

 

 

 

 

 

Variable costs:

 

 

 

 

 

 

 

Opening stock accounts listed individually

xxx

 

Variable costs accounts listed individually

xxx

 

 

 

xxx

 

Closing stock accounts listed individually

xxx

 

 

 

 

xxx

Surplus

 

 

xxx

 

 

 

 

 

 

 

 

And finally the Arable trading account TFA

 

 

 

 

 

 

 

 

 

 

Arable enterprise 1

 

 

 

 

 

 

 

Opening valuation

 

xxx

 

Sales accounts listed individually

 

xxx

 

Closing valuation

 

xxx

 

 

 

 

xxx

 

 

 

 

 

 

 

 

Arable enterprise 2

 

 

 

 

 

 

 

continues as above for all ten arable enterprise accounts

 

 

 

 

 

 

 

 

 

 

GROSS OUTPUT

 

 

xxx

 

 

 

 

Variable costs:

 

 

 

 

 

 

 

 

 

 

 

Opening stock

(account 69)

xxx

 

Variable costs listed individually

 

xxx

 

 

 

xxx

 

Closing stock

(account 134)

xxx

 

 

 

 

xxx

Surplus

 

 

xxx

 

Back to top