To fill in the tables SIGN UP or LOG IN with your credentials. Your input data will not be visible to other users.
Fill in the table using:
- +New Entry
- Edit after clicking on the row you want to modify
- Delete
For % fields, enter the percentage figure without the symbol. Some fields allow for one or two decimal places. For example, for the VAT field, if the rate is 22% enter 22.00
Trade sales and purchases
Note on the sale price: if you sell to businesses enter it without VAT, if you sell to final consumers enter it inclusive of VAT, if applicable
| wdt_ID | userid | Product name | Enter 1 if you sell to the final consumer, otherwise leave blank | VAT % on sales if applicable | VAT % on purchases if applicable | Sale price YEAR1 | Unit cost YEAR1 | Quantities sold YEAR1 | Stock quantities end of YEAR1 | Sale price YEAR2 | Unit cost YEAR2 | Quantities sold YEAR2 | Stock quantities end of YEAR2 | Sale price YEAR3 | Unit cost YEAR3 | Quantities sold YEAR3 | Stock quantities end of YEAR3 | Sale price YEAR4 | Unit cost YEAR4 | Quantities sold YEAR4 | Stock quantities end of YEAR4 | Sale price YEAR5 | Unit cost YEAR5 | Quantities sold YEAR5 | Stock quantities end of YEAR5 | Distribution fee % on sales | Discount % of sale price | Average discounted quantities per year | Returned quantities per year | Royalty due on sales, enter % if applicable | Fee due per unit sold, enter amount if applicable |
|---|
***
