11 VAT Admin Workbook

The VAT Admin workbook allows planning administrators to enter the value added tax (VAT) rate by week.

The VAT Admin workbook contains one tab, VAT Setup.

VAT Admin Wizard

To build a new VAT Admin workbook, perform the following steps:

1. Select New from the File menu, or click the New button in the toolbar.

2. On the Planning Admin tab, select VAT Admin and click OK.

   Figure 11-1 Creating a New VAT Admin Workbook

   
   

3. The Product Selection step appears. Select the subclass you want to examine, and click Next.

   Figure 11-2 VAT Admin Wizard: Product Selection Step

   
   

4. The Location Selection step appears. Select the channels you want to examine and click Next.

   Figure 11-3 VAT Admin Wizard: Location Selection Step

   
   

5. The Calendar Selection step appears. Select the halves you want to examine and click Next.

   Figure 11-4 VAT Admin Wizard: Calendar Selection Step

   
   

The VAT Admin workbook is built and opens at the VAT Setup tab with the VAT Setup worksheet in view.

VAT Setup Tab

The VAT Setup tab has one worksheet, VAT Setup.

VAT Setup Worksheet

In this worksheet, enter the value added tax for each subclass in the Wp Vat R % measure. When planning sales retail, the VAT is decremented, and the result is shown in the Wp Sales Net Vat R measure. If no Wp Vat R % is planned, then the Wp Sales Net Vat R and the Wp Sales R are the same value.

Figure 11-5 VAT Setup Worksheet

The following table lists the measures available on this worksheet.

Table 11-1 VAT Setup Worksheet Measures

Measure	Description
Wp VAT %	The value added tax rate for the working plan.