Profit and Loss Expenditure Template

BUSINESS NAME Profit and loss acount - year ended DATE Expenses £ Turnover Sales Other income Cost of sales Opening stocks Purchases Closing stocks Profit before tax Allowable expenses Employee costs Premises costs Repairs General administration Motor expenses Travel/subsistence Bad debts Legal/professional Other finance charges Depreciation Other Operating profit Balancing charges Profit/loss before tax Taxation Profit/loss after tax Income £ 100,000.00 - 250.00 3,500.00 75.00 3,675.00 96,325.00 1. Click "File, Save as" and save to your chosen folde 2. Clear out the dummy figures using "clear contents 3. Enter negative numbers with brackets or a minus s 4. All calculations are automatic 5. Do not include VAT in your figures 6. Delete these instructions using "clear contents" 34.00 266.00 44.00 45.00 1,122.00 456.00 77.00 234.00 66.00 122.00 6,544.00 9,010.00 87,315.00 595.00 87,910.00 8,300.00 79,610.00 - e, Save as" and save to your chosen folder the dummy figures using "clear contents" gative numbers with brackets or a minus sign. ations are automatic clude VAT in your figures ese instructions using "clear contents" BUSINESS NAME Income from DATE to DATE ALLOCATION / ANALYSIS Invoice No. 001 002 003 004 005 006 007 008 009 010 011 012 013 014 015 016 017 018 019 Client Ref. Date Client Description Article on Deaf Children Motor Advertisement Instruction Booklet Date Paid 3/5/2003 3/8/2003 3/3/2003 Gross £354.99 £44.59 £172.06 £727.03 VAT £52.87 £6.64 £25.63 £108.28 Net £302.12 £37.95 £146.44 £618.75 tba tba tba 2/7/2003 A.Smith 2/8/2003 R.Brown 2/10/2003 P.Black 5/14/2002 ######## Refund of expenses Calculations are automatic 020 021 022 023 024 025 026 027 028 029 030 You can add as many columns as you wish for allocation of expenses. Well Said Accounts 3 8/12/2008 Total £1,298.68 £193.42 £1,105.26 Well Said Accounts 4 8/12/2008 Well Said Accounts 5 8/12/2008 Well Said Accounts 6 8/12/2008 Well Said Accounts 7 8/12/2008 Well Said Accounts 8 8/12/2008 Well Said Accounts 9 8/12/2008 Well Said Accounts 10 8/12/2008 TION / ANALYSIS Refunded Expenses £35.00 Well Said Accounts 11 8/12/2008 £35.00 Well Said Accounts 12 8/12/2008 Well Said Accounts 13 8/12/2008 Well Said Accounts 14 8/12/2008 Well Said Accounts 15 8/12/2008 Well Said Accounts 16 8/12/2008 Well Said Accounts 17 8/12/2008 Well Said Accounts 18 8/12/2008 BUSINESS NAME Expense Invoice No. 001 002 003 004 005 006 007 008 009 010 011 012 013 Client Ref. Date Supplier Description Article on Deaf Children Motor Advertisement Instruction Booklet Gross £344.13 £44.59 £172.06 VAT £51.25 £6.64 £25.63 Net £292.88 £37.95 £146.44 Date Paid 3/5/2003 3/8/2003 3/3/2003 Employees 2/7/2003 A.Smith 2/8/2003 R.Brown 2/10/2003 P.Black £678.56 £101.06 £577.50 014 015 016 017 018 019 020 021 022 023 024 025 026 027 028 Simply delete any expense columns that are not relevant to your business. Well Said Accounts 19 8/12/2008 029 030 Total £1,239.35 £184.58 £1,054.76 Well Said Accounts 20 8/12/2008 Well Said Accounts 21 8/12/2008 Well Said Accounts 22 8/12/2008 Well Said Accounts 23 8/12/2008 Well Said Accounts 24 8/12/2008 Well Said Accounts 25 8/12/2008 Well Said Accounts 26 8/12/2008 BUSINESS NAME Expenses from DATE to DATE ALLOCATION / ANALYSIS Premises Repairs Gen. Admin Motor Exp. Travel/ Subsistence Bad Debts Legal/ professional Other Finance Charges Depreciation Well Said Accounts 27 8/12/2008 Well Said Accounts 28 8/12/2008 Well Said Accounts 29 8/12/2008 Well Said Accounts 30 8/12/2008 Well Said Accounts 31 8/12/2008 Well Said Accounts 32 8/12/2008 Well Said Accounts 33 8/12/2008 Well Said Accounts 34 8/12/2008 Other Well Said Accounts 35 8/12/2008 Well Said Accounts 36 8/12/2008 Well Said Accounts 37 8/12/2008 Well Said Accounts 38 8/12/2008 Well Said Accounts 39 8/12/2008 Well Said Accounts 40 8/12/2008 Well Said Accounts 41 8/12/2008 Well Said Accounts 42 8/12/2008 Invoice No. 001 002 003 004 005 006 007 008 009 010 011 012 013 014 015 Client Ref. Date Client 2/7/2003 A.Smith 2/8/2003 R.Brown 2/10/2003 P.Black 5/14/2002 BUSINESS NAME Income from DATE to DATE ALLOCATION / ANALYSIS Refunded Description Date Paid Amount tba tba tba Expenses Article on Deaf Children 3/5/2003 £355.00 Motor Advertisement 3/8/2003 £46.00 Instruction Booklet 3/3/2003 £177.50 £750.00 12/12/2003 refund of expenses £35.00 016 017 018 019 020 021 022 023 024 025 026 027 028 029 030 Calculations are automatic You can add as many columns as you wish for allocation of expenses. Well Said Accounts 43 8/12/2008 Total £1,328.50 £35.00 Well Said Accounts 44 8/12/2008 Well Said Accounts 45 8/12/2008 Well Said Accounts 46 8/12/2008 Well Said Accounts 47 8/12/2008 Well Said Accounts 48 8/12/2008 Well Said Accounts 49 8/12/2008 Well Said Accounts 50 8/12/2008 Well Said Accounts 51 8/12/2008 BUSINESS NAME Expenses from DATE t Invoice No. 001 002 003 004 005 006 007 008 009 010 011 012 013 014 Client Ref. Date Supplier Description Article on Deaf Children Motor Advertisement Instruction Booklet Amount £355.00 £46.00 £177.50 Date Paid 3/5/2003 3/8/2003 3/3/2003 Employees Premises Repairs 2/7/2003 A.Smith 2/8/2003 R.Brown 2/10/2003 P.Black £700.00 Calculations are automatic. Simply delete any expense columns that are not relevant to your business. 015 016 017 018 019 020 021 022 023 024 025 026 027 028 Well Said Accounts 52 8/12/2008 029 030 Total £1,278.50 Well Said Accounts 53 8/12/2008 Well Said Accounts 54 8/12/2008 Well Said Accounts 55 8/12/2008 Well Said Accounts 56 8/12/2008 Well Said Accounts 57 8/12/2008 Well Said Accounts 58 8/12/2008 Well Said Accounts 59 8/12/2008 INESS NAME Expenses from DATE to DATE ALLOCATION / ANALYSIS Gen. Admin Motor Exp. Travel/ Subsistence Bad Debts Legal/ professional Other Finance Charges Depreciation Other Well Said Accounts 60 8/12/2008 Well Said Accounts 61 8/12/2008 Well Said Accounts 62 8/12/2008 Well Said Accounts 63 8/12/2008 Well Said Accounts 64 8/12/2008 Well Said Accounts 65 8/12/2008 Well Said Accounts 66 8/12/2008 Well Said Accounts 67 8/12/2008