Home› For everyone› Chat and off-topic discussion
Current updates regarding coronavirus (Covid-19) and the precautions AAT are taking will be continually updated on the below page.

Please check this link for the latest updates:
We hope you are all safe and well and if you need us we will be here. 💚


Sage????

A-VicA-Vic Expertise GuaranteedRegistered Posts: 6,970
in Chat and off-topic discussion
Am having a grr of a moment just doing a tesco bag vat last min job now the problem i have some invoices that were put in as cash sales when they were ment to be cash purchases.

So ive taken them off and re-entered them as purchases however the vat liability has gone up has anyone come across this before ? and what did they do to fix it?

Comments

  • DiannewDiannew Font Of All Knowledge Registered Posts: 2,814
    Hi,

    Have you definatly taken them off and have you used the correct date's
  • A-VicA-Vic Expertise Guaranteed Registered Posts: 6,970
    Diannew wrote: »
    Hi,

    Have you definatly taken them off and have you used the correct date's

    Yep and re-done it 3 times its got me baffled for the sake of the Return ive done it manually but need to adjust sage to complete the year for the accounts
  • DiannewDiannew Font Of All Knowledge Registered Posts: 2,814
    I don't know what version of sage you are on.....but can you not check what has gone on,in the Nominal Code for VAT?
  • PGMPGM Font Of All Knowledge Registered Posts: 1,954
    Are they due a vat refund in that quarter? Only thing that would make sense if the value has increased.
  • A-VicA-Vic Expertise Guaranteed Registered Posts: 6,970
    PGM wrote: »
    Are they due a vat refund in that quarter? Only thing that would make sense if the value has increased.

    Nope i did think that id put it in wrong but the liability was 4401 and the correction was 801 but now shows 5201

    I think am gonna have to get in contact with sage, weve had so many problems since updating v15 instant accounts
  • DiannewDiannew Font Of All Knowledge Registered Posts: 2,814
    Well 801 is the difference between the two figures.....if you take roundings into account.....so it does look likely to be something to do with the correction. Walk away...have a coffee then re check the correction that you have done. Was the 4401 the liability with the invoices in as
    sales? if so it should be 4401-801 =3600 or am I going toodle pip!
  • A-VicA-Vic Expertise Guaranteed Registered Posts: 6,970
    Diannew wrote: »
    Well 801 is the difference between the two figures.....if you take roundings into account.....so it does look likely to be something to do with the correction. Walk away...have a coffee then re check the correction that you have done. Was the 4401 the liability with the invoices in as
    sales? if so it shpuld now be 3600.00 or am I wrong?

    Yep exactly they way i did it manually - am off for a coffee and a slice of something loaded with calories bbs
  • DiannewDiannew Font Of All Knowledge Registered Posts: 2,814
    A-Vic wrote: »
    Yep exactly they way i did it manually - am off for a coffee and a slice of something loaded with calories bbs

    How did you do the correction:001_wub: in the first place
  • A-VicA-Vic Expertise Guaranteed Registered Posts: 6,970
    Diannew wrote: »
    How did you do the correction:001_wub: in the first place

    Because its a rush one were only puting in sales, purchases expenses and bank charges so used the correction tab removed the entries and re put them in as purchases
  • jow774jow774 Trusted Regular Registered Posts: 465
    Could it be to do with the 15% - 17.5% thing if your using the standard T1 VAT code?

    Probably not, just a thought.
  • jow774jow774 Trusted Regular Registered Posts: 465
    Just another thought,

    4401 - 801 = 3600
    3600 + 801= 4401
    4401 + 801 = 5202 rounding could be 5201

    Could it be that in sorting it you entered it twice as a sale and once as a purchase?

    I say this as this something Ive done in the past.
  • A-VicA-Vic Expertise Guaranteed Registered Posts: 6,970
    Jow you were on the right lines but am baffled why it did it

    on v15 instant accounts there is a corrections tab and for some reason when using this to delet the entries it did delet them but also re-entered them at the bottom of the page?????
  • mark130273mark130273 Font Of All Knowledge Registered Posts: 4,234
    isnt sage wonderful !!!!anyone tried doing a cashflow using sage.......it awful ?
  • KecakKecak Feels At Home Registered Posts: 50
    A-Vic wrote: »
    Jow you were on the right lines but am baffled why it did it

    on v15 instant accounts there is a corrections tab and for some reason when using this to delet the entries it did delet them but also re-entered them at the bottom of the page?????

    How did you delete the transaction? it sounds like you've either reversed a transaction, or edited it rather than deleted it.

    Does it say 'deleted - see transaction #'?
  • PGMPGM Font Of All Knowledge Registered Posts: 1,954
    I think you need to look at Financial and the Vat accounts, work out exactly what transactions male up the balance.
  • PGMPGM Font Of All Knowledge Registered Posts: 1,954
    Did you get anywhere with this A Vic?
  • A-VicA-Vic Expertise Guaranteed Registered Posts: 6,970
    we know what happened but not sure why
  • CJCCJC Font Of All Knowledge Registered Posts: 1,657
    A-Vic wrote: »
    we know what happened but not sure why
    Story of my life :001_unsure:
  • A-VicA-Vic Expertise Guaranteed Registered Posts: 6,970
    CJC wrote: »
    Story of my life :001_unsure:

    when delet was pressed it just re-entered it at the bottom of the sheet ????? totally baffled
  • AK002AK002 Font Of All Knowledge Registered Posts: 2,492
    A-Vic wrote: »
    when delet was pressed it just re-entered it at the bottom of the sheet ????? totally baffled

    Just re-entered as the same transaction? Or reversed out?

    Sounds odd..
  • A-VicA-Vic Expertise Guaranteed Registered Posts: 6,970
    AK002 wrote: »
    Just re-entered as the same transaction? Or reversed out?

    Sounds odd..

    Nope just re-entered it that what has us baffled
  • BluewednesdayBluewednesday Font Of All Knowledge Registered Posts: 1,624
    I think it deletes the previous transaction then records the deletion in the audit trail.

    It doesn't come out of the expense twice does it?
Sign In or Register to comment.