Skip to content
logo Knowledgebase

Changing VAT schemes in Sage 50 Accounts - Ireland only

Created on  | Last modified on 

Summary

This guide helps you switch between VAT schemes when using Sage 50 Accounts in the Republic of Ireland.

Description

VAT-registered companies must reconcile and submit a VAT Return every two months, unless the Revenue agrees a different period.

In Sage 50 Accounts, you can choose either of the following VAT schemes for your company:

  • Standard VAT
  • VAT Cash Accounting
You may need to change VAT schemes if you reach a turnover threshold, or another scheme is a better fit for your business.

NOTE:

If you require further information about VAT schemes, or when you can make a change, refer to the Revenue.

Resolution

 

Skip to:

Standard VAT to VAT Cash Accounting

On the Standard VAT scheme, you pay and reclaim VAT on invoices and credits. However, when you change to VAT Cash Accounting, VAT calculates on monies received or paid.

Complete this procedure after reconciling your Standard VAT return and before entering any VAT Cash Accounting transactions.

 

Before you start

Before changing VAT schemes, back up your data and reconcile your Standard VAT Return.

  1. Select VAT then press VAT Return.
  2. Calculate and reconcile the VAT Return for your final Standard VAT scheme period.

You're now ready to change from the Standard VAT scheme to the VAT Cash Accounting scheme.

 

Change your VAT scheme

NOTE:

Ensure you've reconciled your VAT Return before changing your VAT scheme. Don't continue until you've completed the previous section.

 

  1. Select Settings then select Company Preferences and press VAT.
  2. Select the VAT Scheme dropdown and choose VAT Cash Accounting (Ireland).

    The following message appears: 'Changing to the Standard VAT Scheme may affect Payments on Account within Recurring Entries. Ensure these recurring entries are set up correctly before processing.'

  3. Press OK then OK.

You've now changed to the VAT Cash Accounting scheme. 

 

Create and amend the tax codes

Change the tax codes so you don't reconcile the same VAT twice when switching from Standard VAT to VAT Cash Accounting.
T51 and above Look through the tax codes T0 to T50 and make a note of the ones you use. Then recreate these in the range above T51 applying the same settings.
T0 to T50 Edit the tax code and clear the Include in VAT Return checkbox.

NOTE:

Clearing Include in VAT Return prevents you viewing saved VAT Returns that use that tax code.
  1. Select Settings then Configuration and press Tax Codes.
  2. From the list of tax codes, select the tax code you want to amend then press Edit.
  3. Complete the Edit Tax Code window as required. Read more >
  4. To save any changes made to the tax code, press OK.
  5. Repeat steps 2 to 4 for each tax code you want to amend.
  6. Select OK.

You've now created and amended the tax codes.

 

Prepare your data before processing on the VAT Cash Accounting scheme

Before you enter any transactions under the VAT Cash Accounting scheme, you must prepare your data as follows:

TIP:

To save you time, you can update multiple records at the same time using the Batch Changes option. Read more >

 
  • Update the Default Tax Code on customer, supplier, product and delivery address records to the relevant new tax code.
  • Amend the tax code on unposted invoices to the relevant new code. For example, change T2 to the equivalent tax code in the T51+ range.
  • Amend tax codes on unposted invoices to the relevant new codes. For example, change T2 to its equivalent code in the T51+ range.
  • Delete or reverse any outstanding T9 payments on account, then repost them with the tax code that matches the invoice.
  • Update the Cash Register default tax code (Settings > Bank Defaults > Cash Register Settings) to the relevant new T51+ tax code.
  • Sage 50 Accounts Professional only - Amend the tax code on all incomplete sales orders and purchase orders to the relevant new tax code. For example, if the tax code on the product item line was T0, under the new VAT scheme you should amend this to the new code you've created for T0 in the range of T51 and above.
  • Amend the tax code on all of your memorised batch data entry files and any skeleton journals that you have saved. For example, if the tax code was T1, under the new VAT scheme you should amend this to the new code you've created for T1 in the range of T51 and above.
  • Amend the Tax Code boxes in the Customer Defaults, Supplier Defaults and Product Defaults windows. For example, if the tax code was T1, under the new VAT scheme you should the new code you've created for T1 in the range of T51 and above. To amend the default tax codes > Settings > choose either Customer Defaults, Supplier Defaults or Product Defaults > amend the tax codes as required.
  • Amend the tax codes on special item lines. Settings > Invoice and Order Defaults > Options > Special Items.

You've now prepared your data, and are ready to use the VAT Cash Accounting scheme.

For further information about reconciling your VAT Return using this scheme, please refer to our guide.

VAT Cash Accounting to Standard VAT

On the VAT Cash Accounting scheme, you pay and reclaim VAT on the monies you receive or pay. However, on the Standard Vat scheme, VAT calculates on the invoices and credits received or issued.

You should carry out the following procedure after reconciling the VAT on the VAT Cash Accounting scheme and before entering any transactions under the Standard VAT scheme.

NOTE:

If you have any future dated invoices and credits, you should delete these before you switch VAT schemes and re-enter them after you complete the switch. This ensures that the VAT on these transactions calculates correctly.

 

Before you start

Before changing your VAT scheme, you should take a backup of your data and reconcile your VAT Return up to the end of your Standard VAT scheme period.

  1. Select VAT then press VAT Return.
  2. Calculate and reconcile the VAT Return for your final VAT Cash Accounting scheme period.

You're now ready to change from the VAT Cash Accounting scheme to the Standard VAT scheme.

Change your VAT scheme

TIP:

In certain circumstances it may be possible to defer the payment of VAT after switching schemes. For more information, please refer to the Revenue or your accountant.

 

  1. Select Settings then select Company Preferences and press VAT.
  2. Select the VAT Scheme drop-down and choose Standard VAT.

    The following message appears: 'Changing to the Standard VAT Scheme may affect Payments on Account within Recurring Entries. You must ensure these recurring entries are set up correctly before processing.'

  3. Press OK then OK.

You've now changed your Sage Accounts to the Standard VAT scheme.

NOTE:

There may be balances on your Sales Tax Control Account and Purchase Tax Control Account after posting your VAT transfer journals. You should clear these balances when you account for the outstanding invoices on your next VAT Return. For further information about this, please refer to the following section.

 

Run reports to identify outstanding invoices and duplicate values

You now need to account for any outstanding invoices and avoid including values twice on future VAT Returns

If you've any outstanding invoices at the point of switching VAT schemes, you should include these invoices on your next VAT Return.

Payments on account reconciled under the VAT Cash Accounting scheme may be subsequently allocated to an invoice under the Standard VAT scheme. If this occurs the VAT is calculated twice, once on the payment on account on VAT Cash Accounting and once on the invoice on Standard VAT.

To avoid the above situations, we've created four reports that show you any outstanding invoices and the net and VAT split, and list the outstanding payments on account. To download the reports, click Sage Accounts v21 and above - Additional Reports Backup then download and restore the backup. For further information, please refer to this guide >

NOTE:

You must run these reports at the point of switching VAT schemes before you enter any transactions on the new scheme. You should then keep a copy of the reports. Once you start entering transactions on the Standard VAT scheme, you can't use these reports as any new transactions entered in the same date range are also included.

 

Report Location What the report shows
Vat Cash to Standard - Reconcile Sales VAT Control - SL_VCA.report Customers > Reports > VCA TO STANDARD This report shows the VAT element on the outstanding amount of your sales invoices less the VAT element of the outstanding amount sales credits. You should run this report from 01/01/1980 up to the date you switched to the Standard VAT scheme.
Vat Cash to Standard - Reconcile Sales VAT Control - SA_VCA.report Bank > Reports > VCA TO STANDARD This report shows the Net and VAT element on the outstanding amount of your sales on account. You should run this report from 01/01/1980 up to the last date of your VAT period. You should print this report and use it for every VAT period until you've allocated all payments on account in full.

Correct any future VAT Returns if the reports produce any values

If you have any outstanding invoices which you entered on the VAT Cash Accounting scheme, you should adjust the values in boxes 1 and 6 to include the values from the reports in the previous section. If an invoice is allocated to a payment on account that you entered on the VAT Cash Accounting scheme, you should adjust the values in boxes 1 and 6 to include the invoice value that is allocated to the payment on account.

  1. Select VAT then select VAT Return.
  2. Enter the relevant dates then press Calculate VAT Return.
  3. Select Make adjustments and enter the following adjustments in the relevant VAT Return box:
    Box number Adjustment
    1 Add the total VAT value from the SL_VCA.report minus the total VAT value of any invoices allocated to the payments on account shown on the SA_VCA.report.
    6 Add the total Net value from the SL_VCA.report minus the total Net value of any invoices allocated to the payments on account shown on the SA_VCA.report.
  4. Reconcile the VAT Return as normal.

You must now post a journal to move values entered above from the VAT adjustments nominal code to the VAT liability nominal code.

NOTE:

When you run the VAT transfer, you must include the adjustment values.

 

  1. Select Nominal codes then press Journal entry.
  2. Post the relevant journal values.

If the value on the VAT adjustments nominal code is a credit balance, post the following journal values:

Nominal code Name Details Tax code Debit Credit
2204 Manual Adjustments Switching VAT schemes T9 Difference between total adjustment value from box 1.  
2202 VAT Liability Switching VAT schemes T9   Difference between total adjustment value from box 1.

If the value on the VAT adjustments nominal code is a debit balance, post the following journal values:

Nominal code Name Details Tax code Debit Credit
2204 Manual Adjustments Switching VAT schemes T9   Difference between total adjustment value from box 1.
2202 VAT Liability Switching VAT schemes T9 Difference between total adjustment value from box 1.  

Why the VAT reconciliation reports may not agree with the Tax Control Accounts

There may be differences between the VAT reconciliation reports and the balance on the VAT control accounts for the following reasons:

  • The Write Off, Refunds and Returns Wizard marks invoices as fully paid but doesn't remove the VAT from the relevant VAT control account. As a result, the invoices don't appear on VAT reconciliation reports.
  • If you've posted sales or purchase transactions with a T9 tax code and entered a VAT amount.
  • If you've not correctly posted your VAT journals to clear the VAT liability for previous VAT periods.

TIP:

If you're registering for VAT for the first time, there are some settings you need to enter in Sage 50 Accounts. If you've de-registered for VAT, refer to our guide to ensure your transactions don't include VAT.