+ Post New Thread
Results 1 to 8 of 8
MIS Systems Thread, Record only VAT in Technical; Is it possible to post invoices on SIMS with Net and VAT, but the gross goes to the cost centre? ...
  1. #1

    Join Date
    Jul 2010
    Posts
    3
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Record only VAT

    Is it possible to post invoices on SIMS with Net and VAT, but the gross goes to the cost centre?

    We'd like to record the VAT but we cannot claim it back, as we are a new academy.

    Many thanks, Margaret

  2. #2

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28° 31' 48.89", +28° 25' 37.42" ... if only.
    Posts
    3,253
    Thank Post
    181
    Thanked 375 Times in 304 Posts
    Rep Power
    174
    Which module?

  3. #3

    Join Date
    Jul 2010
    Posts
    3
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Hi creese
    SIMS FMS 6.124

  4. #4

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28° 31' 48.89", +28° 25' 37.42" ... if only.
    Posts
    3,253
    Thank Post
    181
    Thanked 375 Times in 304 Posts
    Rep Power
    174
    Sorry no knowledge of FSM

  5. #5

    Join Date
    Jul 2010
    Posts
    3
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    thanks anyway - anyone else?

  6. #6
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    55
    Quote Originally Posted by MCollingwood View Post
    thanks anyway - anyone else?
    I have a working knowledge of FMS but I am not sure that you can change the setup to do what you want to do. However, we have to work within the remit of the LA and it may be that there is such a setup but we would be unaware of it, as it is outside our experience. It may well be that you can re-define the Ledger Codes to do what you want with the Ledger Code Definition Creation Wizard. You can set up your own VAT Codes and it may be possible to align them to your own definitions.
    Unfortunately my Financial colleague is now on holiday. She will probably be in school at some time and I will ask her if I do see her.
    Have you posted a case with Capita Support? You should get a quick response as to whether it is possible or not!
    Last edited by Sivadam; 26th July 2010 at 10:34 AM.

  7. #7
    Sarconia's Avatar
    Join Date
    Mar 2010
    Location
    London
    Posts
    315
    Thank Post
    15
    Thanked 34 Times in 31 Posts
    Rep Power
    15
    I'm with Sivadam on this one as my first thought was "hmm, I wonder if you could create a new ledger code for this?". Although I'm not really that great with FMS either.

  8. #8

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,326
    Thank Post
    36
    Thanked 353 Times in 238 Posts
    Rep Power
    79
    I recommend talking to our service desk as we have a briefing sheet on this. Below is an extract that should help:

    Creation of the Chart of Accounts
    Vat Input (VI) and Vat Output (VO) ledger codes will need to be defined with a rate of zero percent. These ledger codes will become the default Vat ledger codes for Expenditure (VI) and Income (VO) ledger codes.

    A possible solution that could be adopted to account for Non Recoverable VAT (NRV) is to create Expenditure (EX) ledger code(s) with the description of “Non Recoverable VAT” – one for standard rate at 17.5% and a reduced rate at 5.0% currently. These ledger codes could be linked to a specific Fund allowing the value of NRV to be indentified easily. These ledger codes will need to be linked to the cost centres appropriately.
    Allocation of budgets
    Budgets should be allocated allowing for NRV to be charged to the appropriate ledger code / cost centres.
    Accounting for Non Recoverable VAT (NRV)
    The following table provides guidance upon how existing functionality can be used in the following areas where the budgets have been allocated to include NRV:-
    a) The VAT Input (VI) and VAT Output (VO) ledger codes have been defined with zero percent.
    b) NRV is committed and recorded against ledger codes and cost centres at source
    c) An expenditure ledger code is used to record the NRV in the cost centre
    Functionality Guidance
    Purchase Orders Select the items as normal but add additional line(s) for each cost centre using the Expenditure ledger code defined for NRV entering an estimate for the NRV.
    Supplier Invoices and Credit Notes When the Invoice for the Purchase Order is entered, the actual value of the NRV can be recorded and posted on the expenditure ledger code defined on the Purchase Order for NRV.
    Cash Book Journals Select the appropriate ledger code / cost centre combination(s) entering the net value against each line. If NRV is applicable, enter journal lines using the expenditure ledger code defined for NRV for each cost centre.
    Reoccurring Payments Select the supplier and the appropriate ledger code / cost centre combination(s) entering the net value against each line. If NRV is applicable, enter journal lines using the expenditure ledger code defined for NRV for each cost centre.
    Normal Journal Select and the appropriate ledger code / cost centre combination(s) entering the appropriate net value against each line. The expenditure ledger code that has been defined for NRV could be included within a normal journal.
    Petty Cash Enter the value of the Petty Cash expenditure using the appropriate ledger code / cost centre combination(s). If NRV is applicable, enter a separate line for using the expenditure ledger code that has been defined for NRV for the appropriate cost centre.
    Income transactions These transactions should be entered as normal. In most circumstances, Academies are not allowed to charge VAT on their transactions.

  9. 2 Thanks to PhilNeal:

    MCollingwood (27th July 2010), teejay (26th July 2010)

SHARE:
+ Post New Thread

Similar Threads

  1. Record Tripping
    By mattx in forum General Chat
    Replies: 1
    Last Post: 8th February 2010, 11:48 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •