Skip to content
logo Knowledgebase

A guide to VAT reconciliation - Standard VAT - Ireland only

Created on  | Last modified on 

Summary

This article explains how to reconcile your VAT Return when using the Standard VAT scheme in Sage 50cloud Accounts.

Description

Using Sage Accounts you can prepare the return, reconcile the values and to save time, create a file you can upload to Revenue Online Service (ROS).

For more information about VAT, visit http://www.revenue.ie/en/tax/vat´╗┐

Resolution

 

How is the VAT Return calculated?

When using the Standard VAT scheme, the input and output tax is calculated one the VAT Return from the VAT element of the following:

  • Sales and purchase invoices.
  • Sales and purchase credits.
  • Bank, cash and visa receipts.
  • Bank, cash and visa payments.
  • The value of journal entries posted to the Sales and Purchse Tax Control Accounts using a tax code that's flagged to be included in the VAT Return.

Tax codes

Sage Accounts uses tax codes to calculate VAT. Each tax code has its own rate and VAT is calculated using this rate. 


Prepare the VAT Return

  1. Click VAT, then click VAT Return.
  2. To create a backup of your data, click Back up then follow the on-screen instructions.
  3. Enter the date range for your VAT period.
  4. To include transactions within the specified period that you've already reconciled, select the Include reconciled transactions check box.
  5. To change the verification checks that run when calculating the VAT Return, click VAT Verification, then click Settings.
  6. Click Calculate VAT Return.
  7. If there are any transactions dated before the date range which aren't reconciled yet, the Earlier unreconciled transactions window appears.
    To include these transactions, click Include.

You can now follow the steps below to reconcile the VAT Return.


Reconcile the VAT Return

It's important to check your VAT values are correct before you submit them to Revenue. Thankfully it's easy to check in Sage 50cloud Accounts. To do this follow the steps below.

NOTE: In line with Revenue guidance, all the values on the VAT Return are rounded to the nearest euro.


Verification results

  • To view results of the verification checks, click View results.

Make adjustments

  1. If you need to adjust any of the values on the return, click Make adjustments.
  2. Select the relevant Adjustment box, then enter the description of the change and the value.
  3. Click Save then click Close.

Reports - To confirm the VAT Return values are correct

To view a breakdown of the values on your return, once you calculate your VAT Return, click the breakdown button beside the relevant value.

From the VAT Breakdown window you can double-click a value to see a list of transactions that are included in that total. You can then use your reports to confirm the values in each of the boxes on the VAT Return.

Click the relevant box below to see which reports you need to run to confirm the values are correct. To view the reports, click Reconciliation reports, then click Reconciliation reports and click Standard VAT.


Reports - Print the VAT reports

  1. Click Reports then click Print VAT Return.
  2. In VAT Return Type, select one of the following options:
    VAT Return To view information from the VAT Return window, select this option.
    Summary To view a summary of each VAT Return box by tax code and transaction type, select this option.
    Detailed To view a detailed report of the individual transactions that make up the total for each box on the VAT Return, select this option.
    Adjustments To view a summary of any manual adjustments made to the VAT Return, select this option.
    Earlier unreconciled transactions To view a list of any transactions dated before the VAT Return period which you haven't previously reconciled, select this option.
  3. Select the required output and click Run.
  4. Complete the Print, Save As or email window as required.

Flag transactions as reconciled

Once you confirm that all the values on your VAT Return are correct, you must mark the included transactions as reconciled so they don't appear on any future returns.

  • Click Reconcile VAT Return then click Yes.

NOTE: Once you mark transactions as reconciled, you can't reverse this action. The only way to undo the process is to restore a backup.

Complete your VAT Return

If you want to complete these steps later, you can close the VAT Return. To return to this window > VAT > double-click the required VAT Return.


The reconciled VAT Return

The reconciled VAT Return appears on the left. As you've already reconciled this, you can't change the values but you can see the information in more detail if you need to.

To see a breakdown of the values by tax code, click the breakdown button beside the relevant value. To view a list of the individual transactions, double-click a value within the VAT Breakdown window.

You can also print the VAT Return and view the verification results and any manual VAT adjustments you've made.


Transfer the VAT Return values to your nominal accounts

  1. Click VAT Transfer and enter the required date for the journal.
  2. If required, amend the sales tax amount and the purchase tax amount.
  3. Click Post Journal.

You've successfully transferred the values to your nominal accounts. If you owe money to the Revenue, it appears as a liability. If you can reclaim the VAT, it appears as an asset.


Generate the VAT Return file for upload to ROS

  1. To locate the XML file on your computer click Submit to the Revenue Commissioners and click Open Folder.
  2. Upload the XML file to ROS. If you need assistance with doing this, please contact Revenue:
    • By phone - 1890 201 106, if you're calling from outside Ireland, dial +353 1 702 3021.
    • By email - [email protected]
  3. Once you've submitted the file, select the Mark as submitted check box.

Record payment or Record receipt

You can use this section to record the payment to or receipt from the Revenue. This clears the value of the VAT journal transfer on the VAT liability nominal code.

  1. Complete the following information:
    Bank Select the bank account you want to pay the Revenue from or receive a refund to.
    Date Enter the date of the payment or refund.
    Reference Enter the required reference for the payment or refund.
    Details Enter the required details for the payment or refund.
    Amount Enter the amount you're paying or receiving.
  2. If you use e-Banking click Pay via e-Banking.
  3. To post the payment or receipt, click either Post Bank Payment or Post Bank Receipt.
  4. If you've already posted the payment or receipt, select either the Mark as paid or Mark as received check box and click Close.


 Still got an accounts question?

Chat online now with one of our Sage experts, to help you find the right solution for you. Join a live chat >