VAT

SUGGESTED

Hi 

Can you advise me please

I started using Sage Jan 2023 and didn't realise that there was a Pay option on filed Vat Returns.    I instead, entered journals for both the Jan/Feb (refund) Mar/Apr (payment).    This mistake now suggests that the bank balance is less than the actual Bank Statement balance.   

Can you suggest how I might fix this problem bearing in mind that all transactions have been reconciled to date.

Best regards

Philip 

  • 0

    Hi Philip,

    Thanks for using Community Hub. 

    We'd recommend deleting the journals you entered, then using the Pay option on the VAT Return instead. The transactions will appear again on the Bank Reconciliation but you can tick them again and the Reconciliation will balance again.

    If this helps, please click Verify answer.

    Regards,

    Andy
    Sage UKI

  • 0 in reply to Andy Rickeard

    Hi Andy

    No this didn't work.  I cannot delete journals that have been reconciled.   These journals relate to 2023 and we tried numerous times to correct it, with multiply journals.   What if I delete all reconciled bank statements.   Would that work.   Or is there a quicker way.   

    Many thanks

    Philip

  • 0 in reply to Philip Monaghan
    SUGGESTED

    Hi Philip,

    Thanks for coming back. You'll need to reverse the journals, but there may be more bank transactions to consider, so at this stage I'd suggest contacting Sage Support by webchat or phone, both options are available here: Contact Sage Support >

    Regards,

    Andy
    Sage UKI

  • Been using Sage Accounting for years so I would:

    reverse / delete the journals.

    go into the VAT returns & use the 'mark as paid' (or whatever it is) & put in the date it left the bank from your statement. 

    Re-reconcile yor bank account to the last date you know it was right - it won't be right now cos of those changes but you can get it back to the balance say end June or whenever you last did it. Run the 'unreconciled bank transactions' report at the date of ast reconciliation & make sure it has nothing on it.

    That should work! Bit of a faff but it's a one-off cos now you know you can match from the bank feed.