Explore Categories

 

 PDF

Create Vouchers for Sales and Sales Returns Under VAT in GCC

Selling goods or services is an important part of doing business and it is equally important to record such sales. As part of the business, you may also need to record any sales returns from your customer. In TallyPrime, you can record sales and sales returns through sales vouchers and credit notes, respectively. As a registered VAT dealer, you can sell goods or services to any other registered or unregistered dealers situated locally or in other GCC countries. 

When you sell goods or services locally to registered or unregistered dealers, you charge tax to the customers and pay the same to the government. At the same time, you can sell the goods or services to other GCC countries where you will not charge any tax as the customer pays the tax under the reverse charge mechanism. The reverse charge mechanism is defined in the GCC Unified VAT Agreement as the mechanism by which the taxable customer is obligated to pay the tax due on behalf of the supplier. You can record the sale of goods and services together in a single invoice, overseas tourist sales, supply on profit margin, transfer of rights to use, and subsequent sales after import and export sales.

Record sales in single invoice: While recording the sales invoice, you can combine accounting for both the sale of goods and services or a taxable and exempt sale together with additional expenses in a single invoice. For example, while selling a television, you also provide installation services. Instead of raising two separate invoices, you can combine the sale of goods and services in a single invoice. You can also add any additional expenses to the same invoice, such as delivery charges.

Export sales: When you sell to other countries outside GCC, the tax on such sales is paid by the customer based on a reverse charge mechanism.

Overseas tourist sale: In the case of an overseas tourist sale, the customer can claim the tax paid by him by showing the tax receipt.

Supply on Profit Margin; In the business of selling antiques or collector’s items, you can charge VAT on the profit margin and not on the entire amount.

Transfer of rights to use: In the case of transferring ownership rights of goods, the consideration you have paid will be taxable.

Print Sales Invoices in Bilingual: Once the sales vouchers are recorded, you can print the invoices in bilingual (English & Arabic) as per the FTA requirement.

In the case of subsequent sales after import to other GCC countries, or sometimes outside GCC countries, you will not be charged VAT. To increase the sale of your business you may decide to give discounts at the time of sale. You can record such discounted sales and print in the invoices the amount before the discount and the amount of the discount.

Once you have sold the goods or services, your customer may return the goods or services for various reasons. You need to record the sales return, including the tax.

In TallyPrime, you can override the tax details, and, in the process, you can change the nature of the transaction, taxable value, and tax rate.

Record Local Supply of Goods and Services

When you sell your goods or services locally to registered or unregistered dealers, such sales are referred to as domestic sales. In TallyPrime, you can record sales of goods or stock items using the Item Invoice mode and specify the stock item details, quantity, and rate. Similarly, the sale of services can be recorded using the accounting invoice mode. An accounting ledger is not required as there is no stock item to allocate.

  1. Open the Sales Voucher in Item Invoice mode.
    1. Press Alt+G (Go To) > Create Voucher > press F8 (Sales).
      Gateway of Tally > Vouchers > F8 (Sales).
    2. Press Ctrl+H (Change Mode) to select Item Invoice mode.
  2. Record the Sales Voucher.
    1. Select the party created as Regular or Unregistered in the Party A/c name depending on the Registration Type of the dealer.
    2. Select the sales ledger in the Sales ledger field.
    3. Select the required stock item including quantity and rate.
    4. Select the VAT ledger.
      Local-supply-goods-services
    5. Press Ctrl+A to accept the screen.
  3. Print the Sales Voucher.
    1. Press Page Up key to view the invoice in alteration mode.
    2. Press Alt+P (Print) > press Enter on Current
    3. In the Voucher Printing screen, press C (Configure).
      1. Type or select Print Type > and press Enter to select Single or Bilingual.
      2. If the Print Type is Single > press Enter on Print Language to select English or Arabic.
    4. Type or select Invoice Format > press Enter to select Invoice Format 2.
  4. Press I (Preview) to preview before printing or press P (Print) to print.

To learn more about printing invoices as per FTA, click here. After recording the voucher, you can view the transaction under Local Supplies in VAT 201.

Sales Within GCC Countries

Sales made within VAT-implementing GCC countries to registered dealers are not taxable. The buyer will pay the tax on a reverse charge basis. However, if the buyer is an unregistered dealer, you can charge VAT during sales. For example, suppose you are a registered dealer located in UAE and supply goods or services to a registered dealer in Saudi Arabia or Bahrain. In that case, no tax will be applied in the sales transaction, but the buyer will have to pay tax on a reverse charge basis. However, if you are supplying to an unregistered dealer in Saudi Arabia or Bahrain, tax is applicable.

You can sell goods or services to registered or unregistered dealers in other GCC countries. Selecting a party from another GCC country automatically sets the Nature of transaction to intra-GCC Supplies.

  1. Ensure the Nature of transaction for the sales ledger is Not Applicable.
  2. Record the Sales Voucher.
    1. Select the registered or unregistered customer from another GCC country in the Party A/c name depending on the Registration Type.
    2. Select the sales ledger.
    3. Provide stock item details:
      • Select the required stock item.
      • Enter the Quantity and Rate.
        Sales-within-GCC
  3. Accept the screen. As always, you can press Ctrl+A to save the sales voucher.
  4. View the VAT – Tax Analysis screen.
    1. Press PgUp to view the voucher.
    2. Press Ctrl+O (Related Reports) > select VAT – Tax Analysis.
    3. Press Alt+F5 (Detailed) to view in detailed mode.
      The VAT – Tax Analysis screen appears, as shown below:
      Tax-analysis-sales-within-GCC

After recording the voucher, you can view the transaction under GCC Supplies in VAT 201.

Record Sales in a Single Invoice

If you are in the business of selling both goods and services, then you can record both in a single invoice. For example, if you are selling a refrigerator or television and along with that you are also providing installation service then you can record both the sale of goods and services in a single invoice. Additionally, if you are selling goods or services which are taxable and also exempt from tax then you can record both taxable and exempt supplies in a single invoice. For example, if you are selling financial services, then that is exempted from tax hence while creating the ledger select the Nature of transaction as Domestic Exempt Supplies.

  1. Open and record the Sales voucher.
    1. Press Alt+G (Go To) > Create Voucher > press F8 (Sales).
      Gateway of Tally > Vouchers > F8 (Sales).
    2. Select the Party A/c name and Sales ledger.
    3. Select the required stock item including quantity and rate.
    4. Select the required service ledger.
    5. Select the VAT ledger.
      Sales-in-single-invoice
    6. Accept the screen. As always, you can press Ctrl+A to save the sales voucher.
  2. View the VAT – Tax Analysis screen.
    1. Press PgUp to view the voucher.
    2. Press Ctrl+O (Related Reports) > select VAT – Tax Analysis.
    3. Press Alt+F5 (Detailed) to view in detailed mode.
      The VAT – Tax Analysis screen appears, as shown below:
      Tax-analysis-sales-in-single-invoice

Once you combine accounting both the sale of goods and services or a taxable and exempted sale together, you can share a single invoice to your customer. You can view the transaction under Local Supplies in VAT 201

Record Sales with Additional Expense

While recording the sale of goods or services, you may incur additional expenses such as delivery charges, installation charges, packing charges and so on. You can appropriate such expenses to the value of goods or services for calculating VAT. For example, you are selling television and also providing the installation services. Here the installation charges are an additional expense which you can appropriate to the value of the television and then calculate VAT. 

  1. Configure the additional expense ledger.
    1. In the additional expense ledger, for example, Installation Charges, configure the below options.
      1. Taxability is set to Not Vatable
      2. Include in assessable value calculation for is set to VAT
      3. Appropriate to is set to Goods.
      4. Method of calculation is set to Based on Quantity or Based on Value.
    2. As always, press Ctrl+A to save the purchase ledger.
  2. Open and record the Sales voucher in Item Invoice mode.
    1. Press Alt+G (Go To) > Create Voucher > press F8 (Sales).
      Alternatively, Gateway of Tally > Vouchers > press F8 (Sales).
    2. Press Ctrl+H (Change Mode) and select Item Invoice mode.
    3. Select the Party A/c name and Sales ledger.
    4. Select the required stock item including quantity and rate.
    5. Select the additional expense ledger configured and enter the amount.
    6. Select the VAT ledger.
      Sales-with-additional-expense
  3. View the VAT – Tax Analysis screen.
    1. Press Ctrl+O (Related Reports) > select VAT – Tax Analysis.
    2. Press Alt+F5 (Detailed) to view in detailed mode.
      The VAT – Tax Analysis screen appears, as shown below:
      Tax-analysis-sales-with-additional-expense
  4. Accept the screen. As always, you can press Ctrl+A to save the sales voucher.

Similarly, you can record sale of services by selecting the Method of Calculation as Based on Value. After recording the voucher, you can view the transaction under Local Supplies in VAT 201.

Sales with Discount

While selling the goods or services you can give dicounts to your customer and record the same in the sales voucher. Such discount can be a fixed percentage, an amount off or even buy-one-get-one-free offer. The tax is calculated on the discounted price. In TallyPrime, you need to create the Discount ledger under expense group and select the Type of Ledger as Discount.

  1. Configure discount ledger.
    1. In the Ledger Creation screen, create the Discount ledger under Indirect Expenses.
    2. Select the Type of Ledger as Discount.
    3. Press Ctrl+A to accept the Ledger Creation screen.
  2. Record the Sales voucher with Discount.
    1. Select the customer and sales ledger in the Party A/c name and Sales ledger fields.
    2. Select the required stock item, including quantity and rate.
    3. Select the discount ledger. The Discount amount appears after the sub-total in the bottom right corner of the invoice.
      sales-with-discount
    4. Press Ctrl+A to accept the screen.
  3. Print the invoice.
    1. Press Alt+P (Print) > press Enter on Current.
    2. Press C (Configure).
      • Type or select Print Type > and press Enter to select Single or Bilingual.
      • If the Print Type is Single > press Enter on Print Language to select English or Arabic.
      • Type or select Invoice Format > press Enter to select Invoice Format 2.
      • Type or select Show Before Discount & Invoice Discount > press Enter to enable it.
        Print-sales-with-discount

After recording the voucher, you can view the transaction under Local Supplies in VAT 201.

Sales to Overseas Tourists

Sales made to overseas tourists are taxable at the point of sale. However, the tourist can claim the tax amount by showing the tax receipt before leaving the country. You can record the sale to Overseas Tourist like regular sale entry and mark the transaction as sale to overseas tourist to differentiate it from regular sales. This can be done for POS invoices as well.

  1. In the sales invoice, set the option Provide VAT details to Yes.
  2. In the VAT Details screen, set the option Is Overseas Tourist to Yes.
    Enable-overseas-tourist
  3. Press Ctrl+A to accept.

You can mark a Point of Sale (POS) invoice as an overseas tourist sale.

  1. In the POS invoice, select Not applicable in the Party A/c name field.
  2. In the Party Details screen, set the option Is Overseas Tourist to Yes.
    If you do not see this option, press F12 (Configure) > set Skip Overseas Tourist field to Yes.
    POS-Overseas-Tourist
  3. Enter all the other details in the invoice.
  4. Accept the screen. As always, you can press Ctrl+A to save.

After recording the voucher, you can view the transaction under Local Supplies in VAT 201.

Export Sales

When you sell to parties outside GCC or to countries within GCC where VAT is not implemented such as Kuwait and Qatar, such sale is called Export Sales. In both cases, once you select the party, TallyPrime automatically categories them as exports and does not calculate tax. The customer pays the tax on a reverse charge basis. You can record the export of goods using a sales voucher. Selecting a party from outside GCC country automatically sets the Nature of transaction to Export sale.

  1. Ensure the Nature of transaction for the sales ledger is Not Applicable.
  2. Record the Sales Voucher.
    1. Select the registered or unregistered customer from another GCC country in the Party A/c name depending on the Registration Type.
    2. Select the sales ledger.
    3. Provide stock item details:
      • Select the required stock item.
      • Enter the Quantity and Rate.
        Export-sales
  3. Accept the screen. As always, you can press Ctrl+A to save.

After recording the voucher, you can view the transaction under Outside GCC Supplies in VAT 201.

Supply on Profit Margin

The profit margin scheme of tax applies to second-hand goods, antiques, and collector’s items, where tax is applied on the profit margin achieved on the supply rather than the full value. Therefore, the tax liability is applicable only on the profit margin. In TallyPrime, since tax is not charged on the entire amount, the tax liability for the profit margin is recorded using an adjustment journal voucher.

To ensure that there is no tax applicability on the purchase and the sale of the same stock item, but only on the profit margin on sale the purchase of used goods for sale on profit margin should be recorded by selecting Domestic Purchase – Profit Margin as the Nature of transaction.

  1. Configure the Nature of transaction for the sales ledger.
    1. In the sales ledger, select Domestic Supplies – Profit Margin as the Nature of transaction.
    2. As always, press Ctrl+A to save the sales ledger.
  2. Record the Sales ledger.
    1. Select the customer in Party A/c name.
    2. Select the sales ledger.
    3. Select the used stock item purchased for sale on profit margin.
    4. Enter the Quantity and Rate. Press Enter in the Amount field to display Profit Margin Details screen.
    5. Enter the details with respect to the vendor from whom the goods were purchased, as shown below:
      Additional-details-profit-margin
      • Other details: Here you can provide a brief description of the goods.
      • Marginal valueThis displays the sales value after deducting the purchase amount.
      • Consideration: This value refers to the profit or revenue generated in this sales transaction.
      • VAT liability: This value refers to the tax amount calculated on the Consideration.
  3. Press Enter to return to voucher.
    Sale-on-Profit-Margin
  4. Accept the screen. As always, you can press Ctrl+A to save.

You can now record a journal voucher to book the tax liability on profit margin. You need to select the Nature of Adjustment as Increase in Tax Liability and Additional Details as Sale on Profit Margin. To know more about recording tax liability, click here.

After recording the voucher, you can view the transaction under VAT on Marginal Scheme in VAT 201.

Transfer of Right to Use

When the ownership of goods is transferred to another business for a certain period, the amount paid for the right to use the goods is taxable. The transactions are recorded only for the consideration amount, and the actual value of the goods is not included in the transaction.

  1. Configure the Nature of transaction for the sales ledger.
    1. In the sales ledger, select Domestic Supplies – Transfer of Right to Use as the Nature of transaction.
    2. As always, press Ctrl+A to save the sales ledger.
  2. Record the Sales ledger.
    1. Press Ctrl+H (Change Mode) to select Accounting Invoice mode.
    2. Select the customer in Party A/c name.
    3. Select the sales ledger.
    4. Select the VAT ledger.
      Sales-for-transfer-of-right
  3. Accept the screen. As always, you can press Ctrl+A to save.

After recording the voucher, you can view the transaction under Local Supplies in VAT 201.

Subsequent Sales

When you import goods for subsequent sale, you will be paying tax on the import of goods. The subsequent sale to other GCC countries, or sometimes outside GCC countries, will not be taxable. While recording subsequent sales to Intra GCC customers, select the sales ledger with the Nature of transaction selected as Not Applicable for the system to decide the Nature of transaction depending on the location of your party.

To recover your expenses incurred by paying VAT on imports, you can add the tax value to the value of the goods or include it as an additional expense in the sales transaction.

  1. Ensure the Nature of transaction for the sales ledger as Not Applicable.
  2. Record the Sales Voucher.
    1. Select the customer from the GCC country in the Party A/c name.
    2. Select the sales ledger.
    3. Select the required stock items, including quantity and rate.
      Subsequent-sales
  3. Accept the screen. As always, you can press Ctrl+A to save.

Similarly, you can record the subsequent sales to customers outside GCC countries. You need to select a customer outside the GCC country for the system to decide the Nature of transaction as Exports. After recording the voucher, you can view the transaction under GCC Supplies in VAT 201.

Record Sales with Excise and VAT

When you apply excise to an item, the excise amount should be included in the item value to calculate VAT. For example, if the item cost is 500 AED and excise is 50 AED, then the VAT is calculated on 550 AED. In TallyPrime, you can account for excise and calculate VAT by including the excise amount.

You have to enable excise for stock items and ledgers to be able to calculate excise in transactions. To account for excise, a separate ledger has to be created by selecting Excise as the Type of ledger.

  1. Enable excise for stock items.
    1. Press Alt+G (Go To) > Create Master > Stock Item > and press Enter.
      Alternatively, Gateway of Tally > Create > type or select Stock Item > and press Enter.
    2. Create the stock item.
    3. Set the option Is Excise Applicable to Yes.
      If you do not see this option, press F12 (Configure) and set Use Excise to Yes.
      Enable-excise
    4. Accept the screen. As always, you can press Ctrl+A to save.
  2. Configure the excise ledger.
    1. Record transactions to calculate excise and VAT.
    2. In the Sales voucher, press F12 (Configure).
    3. Set Calculate Excise Duty to Yes and press Ctrl+A to save.
    4. Select the Party A/c name and Sales ledger.
    5. Select the excise applicable item under Name of Item and enter the quantity and rate.
    6. In the Excise Value field, enter the excise rate or excise amount.
      When you enter the rate, the excise amount appears next to the rate.
    7. Select the excise duty ledger created.
      The excise amount appears automatically.
    8. Select VAT ledger. VAT is calculated based on the value of the item plus excise.
      Sales-with-Excise-and-VAT
  3. Accept the screen. As always, you can press Ctrl+A to save.

After recording the voucher, you can view the transaction under Local Supplies in VAT 201.

Change Tax Details in Invoice

While recording sales, you may require changing the taxable value or the Nature of transaction depending on the transaction recorded. The Nature of transaction is selected as Not Applicable, for the sales ledger so that the system can automatically select the Nature of transaction depending on the location of your customer. However, for a particular transaction, you may require selecting a Nature of transaction overriding the selected Nature of transaction. In TallyPrime, you can override the tax details in transactions by enabling modify tax rate in the sales invoice. You can change the nature of transaction, taxable value, and tax rate, as required.

  1. Open the Sales voucher and enable modify tax rate.
    1. Press Alt+G (Go To) > Create Voucher > press F8 (Sales).
    2. Press F12 (Configure) > set Modify Tax Rate details for VAT to Yes.
  2. Record the Sales voucher.
    1. Select the Party A/c name and Sales ledger.
    2. Select the stock items and enter the quantities and rates.
    3. Press Enter from the Amount field.
      The Tax details screen appears, as shown below:
      VAT-details-screen
    4. Press F12 (Configure) to alter the taxable value and tax rate.
      Tax-details-override
    5. Select the VAT ledger.
      override-taxable-value
  3. Press O to override the default tax details.

After recording the voucher, you can view the transaction under Local Supplies in VAT 201.

Print Sales Invoices

After recording the sales voucher, you need to print the sales invoices to share it with the customer. You can print the invoices immediately after recording the voucher or you can choose to print them later. If your company is located in UAE, then you need to print the sales invoices as per the FTA guidelines. You can print the invoices in English, Arabic or in both languages and also select the invoice format.

You can configure your print settings as per your requirement by including the fields you want to view in the invoice. For example, if you have recorded a sale with rate inclusive of VAT, you can configure the print setting to show a separate column as Rate (Incl VAT). TallyPrime also optimises the print area for the selected paper size to print maximum information on a single page. 

The margins on top and left for the header and the columns in the printed invoice are pre-configured. If you reduce these header margin measurements, the alignment of the fields in the printed invoice will be affected. It is suggested that you should avoid altering the default margins in the invoice. In unavoidable circumstances, you can make small changes to the measurement. However, if additional columns and fields are added using F12 (Configure), the alignment will be affected due to the altered margins.

In this section

Print sales invoice in bilingual

Depending on your requirements, you can include the relevant details in your invoice.

  1. In the Voucher Printing screen of the sales invoice, press C (Configure).
    1. Type or select Show Rate (Incl. VAT) > and press Enter to enable it. This will print the rate of each item inclusive of tax.
    2. Type or select Print Type > and press Enter to select Single or Bilingual.
    3. If the Print Type is Single > press Enter on Print Language to select English or Arabic.
    4. Type or select Invoice Format > press Enter to select Invoice Format 2 to print as per FTA.
      Print-type
  2. You can also print the invoice in simple invoice format by setting the option Use Simple Invoice format to Yes in the Print Configuration screen.
    simple-invoice-format 
    The printed invoice appears, as shown:
    Print-sales-with-discount

Once the invoice is printed in bilingual format, you can view the invoice both in English and Arabic.

Print sales invoice with rate inclusive of VAT

After the sale of goods or services, if you need to print the invoice with a rate inclusive of tax, you can do that in TallyPrime. You have the flexibility to manually enter the rate inclusive of VAT in the invoice and print or configure TallyPrime to auto-calculate the same. To enter manually you need to set Provide Rate Inclusive of Tax for Stock Items to Yes in the F12 (Configure) and to auto calculate the rate inclusive of VAT, disable Provide Rate Inclusive of Tax for Stock Items.

  1. Create Sales Voucher with rate inclusive of VAT.
  2. Print the invoice with rate inclusive of VAT.
    1. Press Ctrl+P (Print) to print the invoice.
    2. In the Voucher Printing screen of the invoice, press C (Configure) > type or select Show Rate (Incl. VAT) > and press Enter to enable it. Press Esc to save the configuration screen.
    3. Print the invoice. The invoice printed in Bilingual using Invoice Format 1appears as shown:
      Print-invoice-including-VAT

With the configuration, you can view a separate column displaying the rate of the stock item including VAT.

Sales Returns

After you have sold goods or services to your customers, they may return such goods or services for a variety of reasons. Your customer may return the goods due to low-quality products, damaged product, late delivery, surplus delivery, and more. In TallyPrime, you can record the sales returns in partial or full against the sales invoice using Credit Notes.

  1. Press Alt+G (Go To) > Create Voucher > press F10 (Other Vouchers) > type or select Credit Note > and press Enter.
    Alternatively, Gateway of Tally > Vouchers > press F10 (Other Vouchers) > type or select Credit Note > and press Enter.
  2. In Party A/c name, select the party to whom the original sales were made.
    Receipt Details and Original Invoice Details screen appears.
  3. In the Original Invoice Details screen, enter the invoice number of the original sales transaction against which you are recording the current sales return and the Date.
  4. Select the items to be returned, enter the quantity being returned, and press Enter.
    The Provide Original Invoice Details screen appears.
  5. Enter the taxable amount and tax amount from the sales transaction against which the returns are recorded in the Original Taxable Amount and Original Tax Amount fields respectively.
    Original-tax-details
  6. Select the VAT ledger.
  7. Set the option Provide VAT details to Yes and select the Reason for Returns.
    Credit-note
  8. Accept the screen. As always, you can press Ctrl+A to save.

When a credit note is recorded for the return of goods, only nett value is displayed in the returns and not the gross value.

Post a Comment

Is this information useful?
YesNo
Helpful?