Docstoc

Cashbook Excel 7.0

Document Sample
Cashbook Excel 7.0 Powered By Docstoc
					    WARR & Co
     CHARTERED ACCOUNTANTS




       Mynshull House
       78 Churchgate
         Stockport
         CHESHIRE
          SK1 1YJ

        Tel: 0161 477 6789
        Fax: 0161 477 6006

     E Mail: INFO@WARR.CO.UK
On The Web: http://www.warr.co.uk/
       OTHER SERVICES OFFERED BY WARR & CO.

1.   TAX AND FINANCIAL PLANNING

At Warr & Co. we very much believe that tax and financial planning
complement each other. We are regulated by the FSA and are able to
provide a comprehensive range of financial planning products. We
normally work on a commission basis, but for more substantial cases
are prepared to charge a fee and refund the commission. Please
telephone 0616 447 6789 for further information.

2.   CONTRACTORS INSURANCE SCHEMES

We have put together two insurance schemes especially designed for
computer contractors. The second scheme provides cover for
professional indemnity.

Both schemes are competitively priced and application forms are
available from any of our offices.

3.   INTEREST PAYING BANK CURRENT ACCOUNT

A common complaint contractors have is that they often find that they
carry large credit balances in their current accounts. The high street
banks all offer deposit account facilities but contractors often do not have
time to transfer money between a current account and a deposit account.

We are able to open interest paying current accounts for contractors.
The accounts offers competitive interest rates and there are no bank
charges for normal use.

Application forms are available from any of our offices.

4.   WARR ON THE WEB

For further up to date information on any of our services
why not visit our web site at - http://www.warr.co.uk/
where you will find many more items of particular interest to
computer contractors.
                                  END




                                     2 of 17
                                  INSTRUCTIONS

 BEFORE USING PLEASE MAKE COPY OF THIS DISK (or write to hard disk)
           TO ALLOW ITS USE FOR SUBSEQUENT YEARS

1.   COMPANY DETAILS
a)   Fill in your company details and financial year in the green sections

(VAT quarters are automatically calculated on the assumption that these are
                     co-terminous with your year end.)

2.   Sales 1st. - 4th. Quarters

          DO NOT MAKE ANY ENTRIES IN THE YELLOW SECTIONS
                      (these will be calculated automatically)
a) Invoices Raised
When an invoice is raised to an agency or a client the following details should be
recorded in these worksheets. :-

Date - the date of the invoice;
Details - the name of the agency or the client who has been invoiced;
Invoice number - the number assigned to the invoice;
Fees - the value of the invoice net of VAT;
VAT - the amount of VAT charged on the invoice (this is calculated automatically
     at 20% of Fees, but can be overwritten if necessary to take account of
     minor rounding differences encountered with agency or client self-billing.)
Gross - the total value of the invoice including VAT.(Automatically calculated)

2.   Payments 1st. - 4th. Quarters

(b) Payments made

When a payment is made by the company the following details should be
recorded in these worksheets. :-

Date - the date the payment is made;
Details - a brief description of the nature of the payment;
Invoice number - the number you assign to any invoice you receive in
respect of a payment;
Cash - record the total amount of the payment in this column ONLY IF it
has been paid by cash, credit card or by a personal cheque;
Bank - record the total amount of the payment in this column if, and ONLY IF it
has been paid by a cheque or other deduction from the company bank account;
VAT - enter in this column any reclaimable VAT element included in the
payment
Travelling - enter in this column any business travelling expenses incurred;
Stationery and postage - enter in this column business stationery and postage
together with technical books and journals;
Drawings - this column is used to record payments made by the company to
you, usually payments comprise salary, dividends and re-imbursments of
payments in the cash column; and
Sundries - this column is used to record items that do not readily analyse in the
other columns such as payments of VAT, payments of tax, accountancy fees
and purchase of computer hardware or software etc.

     Please start each new quarter on the corresponding worksheet.



                                         3 of 17
For examples please see sales and payment example pages at end of workbook




                                   CHECKLIST

Examples of Payments that can usually be made by the company

travelling and accommodation expenses incurred in getting to, or staying near
the clients site for short term contracts;
travelling expenses incurred in connection with the administration of the company;
travelling to work away from the clients site;
postage for business correspondence;
stationery for use in the administration of the company;
technical books and journals;
the payment of a salary to yourself;
dividend payments to shareholders;
accountancy fees incurred by the company;
company tax and VAT payments;
professional subscriptions;
the purchase of a computer, other equipment and software used by the company;
business telephone calls made from your own telephone; and
the costs of a mobile phone if registered in the company's name.

Examples of Payments that cannot usually be made by the company

travelling and accommodation expenses incurred in getting to or staying near the
clients site for contracts which exceed 2 years duration.
stationery and postage for your personal use;
payments of your personal telephone bills;
payments for personal accountancy services;
payments for personal tax liabilities;
costs incurred in running your own car;
the cost of meals at your clients site.

Examples of Payments from which VAT can usually be deducted

stationery;
accountancy fees;
telephone charges;
purchases of computers, software and other equipment.

Examples of payments from which VAT cannot usually be deducted

any payment from which you have not received and retained a valid VAT invoice;
any payment which has not been incurred by the company;
postage;
technical books and journals;
travelling expenses;
entertaining expenses.



                                       END




                                        4 of 17
Company Name                  enter full company name           Limited


Accounting Year/Period from        1-Jan-11       to       31-Dec-11
                               enter date above         enter date above
                               in DD/MM/YYYY            in DD/MM/YYYY
                                    format                   format

Director

Registered Offfice




Daytime telephone:

email
                                                                          INVOICE




                                      Tel:

                                      email:

To : -                                         INVOICE No.

                                               Date / Tax Point:                      12-Sep-11

                                               Contract No.

 No.                    Description                                  Unit Price         Amount




                                      Sub Total                                   £          0.00
                                      VAT @ 20%                                              0.00
                                      TOTAL                                       £          0.00




     Company Reg. No.                                 VAT Reg. No.
           enter full company name               Limited

Sales and receipts for the quarter ended                    March 31, 2011

                                      SALES AND OTHER RECEIPTS
                                                    Inv.  Net Fees           others incl
  Date                     Details                                    VAT                  TOTAL
                                                    No.     /Sales            interest
                                                                        -                     -
                                                                        -                     -
                                                                        -                     -
                                                                        -                     -
                                                                        -                     -
                                                                        -                     -
                                                                        -                     -
                                                                        -                     -
                                                                        -                     -
                                                                        -                     -
                                                                        -                     -
                                                                        -                     -
                                                                        -                     -
                                                                        -                     -
                                                                        -                     -
                                                                        -                     -
                                                                        -                     -
                                                                        -                     -
                                                                        -                     -
                                                                        -                     -
                                                                        -                     -
                                                                        -                     -
                                                                        -                     -
                                                                        -                     -
                                                               -        -          -          -
          enter full company name              Limited

Purchases and Payments for the quarter ended             March 31, 2011             LINE ANALYSIS BALANCES

                                                 PURCHASES AND PAYMENTS
                                               Inv.   Cheque    CASH    BANK                        Postage &
  Date                    Details                                                 VAT     Travel                 Drawings   Sundry
                                               No.     No.     Payment Payment                      stationery
                                                                   0.00
                                                                   0.00
                                                                   0.00
                                                                   0.00
                                                                   0.00
                                                                   0.00
                                                                   0.00
                                                                   0.00
                                                                   0.00
                                                                   0.00
                                                                   0.00
                                                                   0.00
                                                                   0.00
                                                                   0.00
                                                                   0.00
                                                                   0.00
                                                                   0.00
                                                                   0.00
                                                                   0.00
                                                                   0.00
                                                                   0.00
                                                                   0.00
                                                                   0.00
                                                                   0.00
                                                                   0.00    0.00    0.00      0.00        0.00        0.00      0.00
               SHEET ANALYSIS BALANCES
           enter full company name               Limited

Sales and receipts for the quarter ended            June 30, 2011

                                      SALES AND OTHER RECEIPTS
                                                    Inv.  Net Fees            others incl
  Date                      Details                                     VAT                 TOTAL
                                                    No.     /Sales             interest
                                                                          -                    -
                                                                          -                    -
                                                                          -                    -
                                                                          -                    -
                                                                          -                    -
                                                                          -                    -
                                                                          -                    -
                                                                          -                    -
                                                                          -                    -
                                                                          -                    -
                                                                          -                    -
                                                                          -                    -
                                                                          -                    -
                                                                          -                    -
                                                                          -                    -
                                                                          -                    -
                                                                          -                    -
                                                                          -                    -
                                                                          -                    -
                                                                          -                    -
                                                                          -                    -
                                                                          -                    -
                                                                          -                    -
                                                                          -                    -
                                                                    -     -          -         -
          enter full company name              Limited

Purchases and Payments for the quarter ended          June 30, 2011                   LINE ANALYSIS BALANCES


                                                 PURCHASES AND PAYMENTS
                                               Inv.    Cheque    CASH    BANK                         Postage &
  Date                    Details                                                   VAT     Travel                 Drawings   Sundry
                                               No.      No.     Payment Payment                       stationery




                                                                      0.00   0.00    0.00      0.00        0.00        0.00      0.00
               SHEET ANALYSIS BALANCES
           enter full company name               Limited

Sales and receipts for the quarter ended          September 30, 2011

                                      SALES AND OTHER RECEIPTS
                                                    Inv.  Net Fees           others incl
  Date                      Details                                    VAT                 TOTAL
                                                    No.     /Sales            interest
                                                                         -                    -
                                                                         -                    -
                                                                         -                    -
                                                                         -                    -
                                                                         -                    -
                                                                         -                    -
                                                                         -                    -
                                                                         -                    -
                                                                         -                    -
                                                                         -                    -
                                                                         -                    -
                                                                         -                    -
                                                                         -                    -
                                                                         -                    -
                                                                         -                    -
                                                                         -                    -
                                                                         -                    -
                                                                         -                    -
                                                                         -                    -
                                                                         -                    -
                                                                         -                    -
                                                                         -                    -
                                                                         -                    -
                                                                         -                    -
                                                                 -       -          -         -
          enter full company name              Limited

Purchases and Payments for the quarter ended     September 30, 2011                 LINE ANALYSIS BALANCES


                                                 PURCHASES AND PAYMENTS
                                               Inv.   Cheque    CASH    BANK                        Postage &
  Date                    Details                                                 VAT     Travel                 Drawings   Sundry
                                               No.     No.     Payment Payment                      stationery




                                                                  0.00     0.00    0.00      0.00        0.00        0.00      0.00
               SHEET ANALYSIS BALANCES
           enter full company name               Limited

Sales and receipts for the quarter ended          December 31, 2011

                                      SALES AND OTHER RECEIPTS
                                                    Inv.  Net Fees          others incl
  Date                      Details                                   VAT                 TOTAL
                                                    No.     /Sales           interest
                                                                        -                    -
                                                                        -                    -
                                                                        -                    -
                                                                        -                    -
                                                                        -                    -
                                                                        -                    -
                                                                        -                    -
                                                                        -                    -
                                                                        -                    -
                                                                        -                    -
                                                                        -                    -
                                                                        -                    -
                                                                        -                    -
                                                                        -                    -
                                                                        -                    -
                                                                        -                    -
                                                                        -                    -
                                                                        -                    -
                                                                        -                    -
                                                                        -                    -
                                                                        -                    -
                                                                        -                    -
                                                                        -                    -
                                                                        -                    -
                                                                -       -          -         -
          enter full company name              Limited

Purchases and Payments for the quarter ended     December 31, 2011                  LINE ANALYSIS BALANCES


                                                 PURCHASES AND PAYMENTS
                                               Inv.   Cheque    CASH    BANK                        Postage &
  Date                    Details                                                 VAT     Travel                 Drawings   Sundry
                                               No.     No.     Payment Payment                      stationery




                                                                  0.00     0.00    0.00      0.00        0.00        0.00      0.00
               SHEET ANALYSIS BALANCES
           enter full company name                 Limited

Sales and receipts for the quarter ended            December 31, 2011
                                                                         EXAMPLE SHEET ONLY
                                      SALES AND OTHER RECEIPTS
                                                    Inv.  Net Fees                  others incl
  Date                      Details                                        VAT                     TOTAL
                                                    No.     /Sales                   interest
  31-Oct   Computex Pesonnel Ltd                 001       4,500.00        900.00                  5,400.00
  30-Nov   Computex Pesonnel Ltd                 002       3,950.00        790.00                  4,740.00
  19-Dec   Computex Pesonnel Ltd                 003       4,300.00        860.00                  5,160.00
  30-Dec   Bank Interest                                                      -         32.14         32.14
                                                                              -                         -
                                                                              -                         -
                                                                              -                         -
                                                                              -                         -
                                                                              -                         -
                                                                              -                         -
                                                                              -                         -
                                                                              -                         -
                                                                              -                         -
                                                                              -                         -
                                                                              -                         -
                                                                              -                         -
                                                                              -                         -
                                                                              -                         -
                                                                              -                         -
                                                                              -                         -
                                                                              -                         -
                                                                              -                         -
                                                                              -                         -
                                                                              -                         -
                                                                              -                         -
                                                             12,750.00   2,550.00       32.14     15,332.14
                                                                 ^          ^
                                           VAT RETURN >       Box 6       Box 1
           enter full company name                     Limited

Purchases and Payments for the quarter ended              December 31, 2011                            LINE ANALYSIS BALANCES
                                                                                                          EXAMPLE SHEET ONLY
                                                          PURCHASES AND PAYMENTS
                                                       Inv. Cheque   CASH     BANK                                     Postage &
  Date                      Details                                                               VAT        Travel                 Drawings    Sundry
                                                       No.   No.    Payment Payment                                    stationery
  10-Oct   Microsoft office (software)                    1            120.00                       20.00                                         100.00
  11-Oct   Pentium CPU                                    2          1,800.00                      300.00                                       1,500.00
  28-Oct   Vat payment for qtr to September 30, 2011            124           2,075.65                                                          2,075.65
  31-Oct   Salary                                               125           1,000.00                                              1,000.00
   3-Nov   Anylife Insurance Co (Company Pension)                                50.00                                                 50.00
   7-Nov   Mileage Claim (142mls @ .40p)                        126              56.80                         56.80
  10-Nov   Salary                                               127           1,000.00                                              1,000.00
  14-Nov   Internet Subscription                          3     128              60.00              10.00                                          50.00
  23-Nov   Self (re-imburse own cash Re: Inv 1&2)               129           1,292.50                                              1,292.50
  29-Nov   Dividend (self)                                      130           2,000.00                                              2,000.00
  29-Nov   Dividend (partner)                                   131             500.00                                                500.00
   5-Dec   Stamps etc.                                                   3.60                                               3.60
  12-Dec   Warr & Co                                      4     132             180.00              30.00                                         150.00
  30-Dec   Salary                                               133           1,000.00                                              1,000.00




                                                                          1,923.60    9,214.95    360.00       56.80        3.60    6,842.50    3,875.65
                SHEET ANALYSIS BALANCES                                                            ^           ^          ^                        ^
                                                                        VAT RETURN >             Box 4       Box 7      Box 7                    Box 7
                     NOTES                                                                                                                     see note
                     1.         There should always be an entry in either cash or bank column but never one in each on the same row
                     2.         Under drawings, enter your monthly salary, dividends, any private expenditure, life assurance, pension
                                payments etc. THESE ARE TO BE IGNORED FOR VAT PURPOSES.
3.   The analysed items should always add up to the total payment


                         TO COMPLETE VAT RETURN
                                                                       £
         Box 1   VAT DUE - From Sales Worksheet                      2550.00
         Box 4   VAT RECLAIMED - From Payments Worksheet              360.00
         Box 5   VAT due to Customs & Excise                         2190.00
         Box 6   TOTAL SALES - From Sales Worksheet                 12750.00
         Box 7   TOTAL PURCHASES - From Payments Worksheet           3936.05
             *   - VAT Payment                                       2075.65
         Box 7                                                       1860.40

              * NOTE: WHEN COMPLETING VAT RETURN YOU SHOULD DEDUCT
                ANY VAT OR TAX PAYMENTS WHICH HAVE BEEN ENTERED IN
                THE SUNDRIES COLUMN TO ARRIVE AT YOUR BOX 7 TOTAL.

				
DOCUMENT INFO