Vatable Items Cashbook Instructions by bud19087

VIEWS: 0 PAGES: 10

									Registration Service April 2008

Vatable Items Cashbook Instructions

Contents

Introduction ............................................................................................................................................. 2
When opening the cashbook .................................................................................................................. 2
Using Tabs on the Cashbook ................................................................................................................. 3
Work to complete at the start of the month............................................................................................. 4
Entering Stock Amounts ......................................................................................................................... 4
Recording amount of stock used ............................................................................................................ 5
Spoils ...................................................................................................................................................... 6
Refunds and Transfers ........................................................................................................................... 7
Online Payments and PDQ Payments ................................................................................................... 8
Banking at the end of the week .............................................................................................................. 9




                                                                                    1
Registration Service April 2008


Introduction

Each District office has one shared Vatable Items Electronic Cashbook

This cashbook will be filled in by………………..

This Cashbook will be saved in the following location;

\\CCCS115\OCSData$\REGIST~1\Shared\Accounts

These cashbooks are linked to a Master Vatable Items Cashbook which auto calculates the totals for
all District offices and is monitored by the Finance Administrator.

At the start of each financial year the Finance Administrator will issue you with a blank cashbook.


When opening the cashbook


   When opening the Cashbook you
   will need to click on enable Macros




                                                         2
Registration Service April 2008

Using Tabs on the Cashbook

   By clicking on the relevant button on the Instructions page the relevant worksheet
   tab will appear at the bottom of the screen when you have opened the cashbook
   this will take you to the correct month. The tabs are labelled with the months of
   the year. Selecting the button again will make the same month worksheet Hide




                                                      3
      Registration Service April 2008


      Work to complete at the start of the month


      Entering Stock Amounts

     At the start of the year the amount of stock for each item should be
     recorded in the brought forward box in the additional stock added column
     for each Vatable Item in the April month worksheet. The totals will then be
     automatically brought forward to the consecutive months.




         To add additional stock during the
         month enter the stock number in
         column D ensuring that you have
         selected the correct stock item by
         clicking on the correct box e.g. this
         would mean that 23 PC Comm
                                       th
         Certs have been added on 6 April
         2007



      Please note:

To change the price of an item. This can be done at the start of any month inserting the new price into the
dark blue cell. You will have to remember though to alter the same dark blue cell on all subsequent months.




                                                            4
Registration Service April 2008

Recording amount of stock used

 The items you want to record sales for simply enter the total amount sold
 against the correct date line. The total price will be automatically
 calculated together the appropriate VAT amount. The day you are
 working on can be highlighted by use of the # sign in column C Selecting
 it again will return the cells to their original grey background.




                                                     5
Registration Service April 2008



Spoils

   Any spoils should be recorded as below




         You may also need to enter in
         the comments column the
         reason for the spoil




                                            6
Registration Service April 2008




Refunds and Transfers


 Please enter any Cash refunds and transfers in column
 IB
 Credit Card refunds can be entered at column IN




                                                   7
Registration Service April 2008




Online Payments and PDQ Payments


 Total online payments should be recorded in
 column IJ and total PDQ payments should
 be recorded in column IK. The cash and
 check amount running total is then populated
 automatically.




                                                8
Registration Service April 2008




Banking


   When the cash and cheques are banked at the
   end of each week the amount banked should be
   recorded on the appropriate day in column IG.
   The Bank receipt number should then be
   recorded in column IH. You should then check
   that the total amount of cash and cheques
   received matched the totals for the week.




                                                   9
Registration Service April 2008




Banking continued


           At the end of every day when cashing up you should initial column IQ
           If you wish to receive the automated message box which will give you the day totals for
           cash, pdq and spoils then simple double click the same cell. You will then enter your
           initials via an Input box and then receive the automated totals message box.




                                                                        At the end of the week after
                                                                        banking you should initial
                                                                        column IO to show that you
                                                                        have logged the information
                                                                        on e business suite




                                                    10

								
To top