www.ExcelDataPro.com
                                            UK VAT Sales Register Excel Template
                          Month          :         JAN                  Year          :           2020                 VAT No           :     IX0XXIXX0XI0XX
                      S.N.    Invoice  Invoice Date           Customer Name               Customer's VAT  Taxable Amount                   VAT            Invoice Amount
                                No.                                                              No.                                 %         Amt.
                  JAN 1       EDP/001     05-01-2020            Roger Traders             IX0XXIXX0XI0XX  £            50,000.00   5.0%  £       2,500.00  £            52,500.00 
                  FEB 2       EDP/002     11-01-2020          Falcon Furnitures           IX0XXIXX0XI0XX  £          110,000.00  20.0%  £     22,000.00  £          132,000.00 
                  MA 3        EDP/003     19-01-2020           Happy Antiques             IX0XXIXX0XI0XX  £            25,434.00   0.0%     £                 -     £            25,434.00 
                  AP    4                                                                                                                                           
                  MA 5                                                                                                                                              
                  JUN 6                                                                                                                                             
                  JUL   7                                                                                                                                           
                  AU    8                                                                                                                                           
                  SEP   9                                                                                                                                           
                  OC 10                                                                                                                                             
                  NO 11                                                                                                                                             
                  DE   12                                                                                                                                           
                       13                                                                                                                                           
                       14                                                                                                                                           
                       15                                                                                                                                           
                       16                                                                                                                                           
                       17                                                                                                                                           
                       18                                                                                                                                           
                       19                                                                                                                                           
                       20                                                                                                                                           
                       21                                                                                                                                           
                       22                                                                                                                                           
                       23                                                                                                                                           
                       24                                                                                                                                           
                       25                                                                                                                                           
                       26                                                                                                                                           
                       27                                                                                                                                           
                       28                                                                                                                                           
                       29                                                                                                                                           
                       30                                                                                                                                           
           31                                                              
           32                                                              
           33                                                              
           34                                                              
           35                                                              
           36                                                              
           37                                                              
           38                                                              
           39                                                              
           40                                                              
           41                                                              
           42                                                              
           43                                                              
           44                                                              
           45                                                              
           46                                                              
           47                                                              
           48                                                              
           49                                                              
           50                                                              
           51                                                              
           52                                                              
           53                                                              
           54                                                              
           55                                                              
           56                                                              
           57                                                              
           58                                                              
           59                                                              
           60                                                              
                           61                                                                                                                                                                
                           62                                                                                                                                                                
                           63                                                                                                                                                                
                           64                                                                                                                                                                
                           65                                                                                                                                                                
                           66                                                                                                                                                                
                           67                                                                                                                                                                
                           68                                                                                                                                                                
                           69                                                                                                                                                                
                           70                                                                                                                                                                
                           71                                                                                                                                                                
                           72                                                                                                                                                                
                           73                                                                                                                                                                
                           74                                                                                                                                                                
                           75                                                                                                                                                                
                           76                                                                                                                                                                
                           77                                                                                                                                                                
                           78                                                                                                                                                                
                           79                                                                                                                                                                
                           80                                                                                                                                                                
                           81                                                                                                                                                                
                           82                                                                                                                                                                
                           83                                                                                                                                                                
                           84                                                                                                                                                                
                           85                                                                                                                                                                
                           86                                                                                                                                                                
                           87                                                                                                                                                                
                           88                                                                                                                                                                
                           89                                                                                                                                                                
                           90                                                                                                                                                                
                           91                                                                                                                                                                
                           92                                                                                                                                                                
                           93                                                                                                                                                                
                           94                                                                                                                                                                
                                                                                                                                                             VAT Output Tax       VAT Inclusive 
                           95                                                                                                                                                                
                                                                                                                                                             Amount               Total Sales
                           96                                                                                                      Taxable                                                   
                                                                                                                                   Value
                           97                                                                                                                                                                
                           98                                                                                                                                                                
                           99                                                                                                                                                                
                          100                                                                                                                                                                
                                                                                                                                                             VAT Output Tax       VAT Inclusive 
                                                                                                                                                             Amount               Total Sales
                                                                                                                                   Taxable 
                                                                                                                                   Value
                                                                                                                                £          185,434.00            £     24,500.00  £          209,934.00