VAT Management

VAT Management

VAT in ERPLY Books

Managing VAT can be very easy and at the same time very flexible in ERPLY Books. It depends on the processes that the company has.

You can find VAT rates from settings -> tax rates. Every tax rate can have its own accounts and also percent. To read more about the VAT rates, read from the user manual.

Different VAT Processes in ERPLY Books

Here is the list of possible operations in ERPLY Books:

  • Ordinary VAT. There should be only one tax rate for ordinary sales and purchases. This is the tax rate that has “Main Tax” type in the tax rates module. By default with new sales and purchase document ERPLY Books chooses this tax rate.
  • Fixed assets VAT. If you are purchasing fixed assets then you should select fixed assets tax rate for the operation. If you use fixed assets purchasing module then ERPLY Books does it for you. Fixed assets tax rate is tax rate that has type as “fixed asset”. It is automatically added into correct section in the VAT report.
  • Reduced VAT. If you have transactions that can be taxed with reduced tax rates then you need to have a separate tax rate for this. The type for this tax rate should be “Reduced”. This tax rate is automatically assigned into reduced tax section in the VAT report.
  • Tax Free Calculations – there are many different tax free operations:
    • sales to or purchases from EU (goods and services both):
      • Tax rate types for EU sales and purchases. If you add corresponding type to the tax rate then in the VAT report ERPLY Books knows how to calculate amounts into total sales and input VAT and also shows amounts in corresponding fields.
      • Reduced vs ordinary VAT from EU sales and purchases. You can categorise EU VAT into main and reduced goods and services – this means if you have EU reduced goods tax rate then all purchases that have this tax rate then those amounts will be added into reduced sales not into ordinary sales VAT.
    • Non-EU sales and purchases – separate tax rate with the type of “export”.
    • Tax free sales and purchases – separate tax rate with the type of “tax free”.
    • Non-taxable purchases and sales – separate tax rate with the type of “other tax”. All tax rate that have type as “other tax” won’t be included into VAT report.
  • Customs VAT. If you have customs VAT then ERPLY Books assumes following process: you pay something in the border that can be claimed back. 100% of it. If there are other fees that are taxed with ordinary amounts then you can select ordinary VAT rate for that amount. To manage customs amount, you must follow those steps:
    • You need to add new tax rate for customs. The type of the tax rate should be “customs” and percent should be zero.
    • It is wise to have separate article for customs. Add this from incomes/purchases & expenses -> purchase and sales articles. The expense account should be input VAT account and tax rate customs tax rate.
    • When adding customs invoice then we want to claim back all the amount that we paid. Thus select the article and add the amount. That’s it.
    • If you have selected “customs” type for the tax rate then it is automatically included into input VAT in the VAT report.
  • Sales passenger VAT. The process is as follows:
    • Sales happen as they always do – with ordinary VAT.
    • When customer claims back VAT in the border then you cannot control this process – thus we claim this amount only if company that manages those transactions sends us an invoice for this.
    • For managing sales passenger VAT you must have separate tax rate for this. The type must be “Sales Passenger Tax” and percent should be zero.
    • It is wise to add new article for sales passenger VAT claims. Add this from incomes/purchases & expenses -> purchase and sales articles. The expense account should be input VAT account and tax rate should be sales passenger tax rate.
    • When adding customs invoice then we want to claim back all the amount that we paid. Thus select the article and add the amount. That’s it.
    • If you have selected “sales passenger tax” type for the tax rate then the amount with this tax rate is reduced from ordinary sales and shown in corresponding tax field.
    • NB: with this process we don’t connect actual sales invoices with the sales passenger VAT.

 

Managing VAT with ERPLY Integration

This tutorial is meant for backoffice (POS & Inventory module) users who have EU sales and purchases and other VAT related questions.

The rules hierarchy of syncing documents is as follows:

  • If there is a setting to sync all document rows it always takes information from rows and looks into details – whether there are service sales/purchases etc;
  • If there is no setting to sync document rows then it takes the summary given by ERPLY API without looking into the details;

The tax rate rules for ERPLY Books and ERPLY backoffice are quite the same – every invoice row can be connected with one tax rate. And all tax rates are synchronised automatically from backoffice.

Different use cases:

  • EU goods and services sales and purchases
    • ERPLY Books can sync automatically sales and purchases into EU goods and services tax rates. For this follow those steps:
      • You need to have tax rate in ERPLY Books for EU goods (type has to be “EU VAT (goods)”);
      • You need to have tax rate in ERPLY Books for EU services (type has to be “EU VAT (services)”);
      • You DON’T need separate EU rates into backoffice;
      • In backoffice you need to have separate 0% tax rate;
      • In ERPLY Books you have to have following settings enabled (settings -> ERPLY POS & Inventory Settings):
        • “Sync non-Stock Items Automatically” – this always synchronises new Non-stock product or service
        • “Sync Sales Invoice Rows for Custom non-Stock Item Revenue Mapping” – this always synchronises all invoice rows
    • If you have followed latter settings then ERPLY Books synchronises documents with following order:
      • Sales Invoice
        • IF invoice has a type of EU invoice AND tax percent is zero, THEN:
          • If item is stock item then EU Goods tax rate is selected;
          • If item is non-stock item then EU Services tax rate is selected;
      • Purchase Invoice
        • IF invoice row tax percent is zero AND if supplier is in EU country THEN:
          • If item is stock item then EU Goods tax rate is selected;
          • If item is non-stock item then EU Services tax rate is selected;
        • ELSE invoice row tax rate is selected. It is important to note here that when suppliers country is not defined then ERPLY Books uses the tax rate selected in the invoice. Supplier country is taken from suppliers main country not from address. And country must be iso 2.
  • VAT from Prepayments
    • By default ERPLY Books don’t calculate VAT from prepayments. If you need it to calculate, you must assign VAT rates for customer groups or customer type (domestic/EU/outside EU).
    • To assign customer tax rates you must go to dashboard and search for customer tax rate group.
  • Everything else:
    • All other transactions are taken straight from the invoice – if you need to assign exception to invoice in the backoffice.
    • By default when synchronising invoices then if new tax rate is in the invoice that doesn’t exist in ERPLY Books – then it will be synchronised. That is the reason why it is wise to synchronise tax rates during the first setup – in order to prevent duplicates.