General description #

The sales overview VAT report in Qbil-Trade offers you to get insight into the various details related to booking and VAT of all the sales and miscellaneous sales invoices created. The report gives you details about the VAT amount applied against each sales invoice. The report provides numerous details regarding invoices like date, product, quantity, pricing, etc and other details related to the vat applied. The report thus allows you to track the VAT amount generated against the sales invoices.

Columns #

• Invoice Date: This column shows the date on which the invoice was created. The data for this is fetched from the field “Invoice Date” of the related sales/Misc. Sales invoice. On hover, the column displays the info text “The invoice date”.
• Order number: Displays the order number related to the Sales invoice and misc.lines associated(if any) with these invoices. On hover, the column displays the short info text “Order number”.
• Our VAT registration number: The column shows the VAT number of the subsidiary retrieved from the field “ Our VAT registration” of the related invoice. On hover, the column displays the info text “Company’s VAT registration number”.
• Your VAT no.: The VAT number of the relation is displayed in this column. The data is fetched from the field “Their Vat Registration” of the related invoice. On hover, the column displays the info text “Vat number of the supplier/buyer”.
• Subsidiary: The ID of the subsidiary for which the invoice has been generated is displayed in this column. On hover, the column displays the info text “Subsidiary that owns the contract/lot”.
• Export status: This column displays whether the sales/miscellaneous sales invoice has been exported or not. On hover, the column displays the info text “Sales export status”.
• Print status: Whether the related sales/Misc. invoice has been printed or not is displayed in the column. On hover, the column displays the info text “Sales print status”.
• Invoice number: The invoice number generated in Qbil-Trade when a sales or miscellaneous sales invoice is created is shown in this field. On hover, the column displays the info text “The invoice number”.
• Relation: The buyer or the relation that receives the invoice is displayed in this column. The data for this column is retrieved from the field “Company” of the invoice. On hover, the column displays the info text “Relation”.
• Quantity: The invoiced quantity mentioned in the invoice is displayed in this field. The data is fetched from the field “Quantity” of the related Sales Invoice. On hover, the column displays the info text “Quantity per contract line”.
• Amount excluding VAT: The net amount of the invoice is displayed in this column. The data for the column is retrieved from the field “Net Amount” of the related invoice. On hover, the column displays the info text “Amount excluding VAT”.
• VAT: The amount of VAT applied on the invoice is displayed in this column. The data for this is fetched from the field “VAT Amount” of the related invoice. On hover, the column displays the info text “VAT Amount”.
• Amount including VAT: The total amount of the invoice including the VAT amount is mentioned in this column. The value for this column is fetched from the field “Total Amount” in the related invoice. On hover, the column displays the info text “Amount including VAT”.
• Price per ton: This column shows the price of the product per 1000 kg mentioned in the related contract of the invoice. On hover, the column displays the info text “Price per 1000 units”.
• VAT rate: The VAT selected for the invoice with code and percentage is displayed in the column. The data is fetched from the field “ VAT” of the invoice. On hover, the column displays the info text “Vat rate”.
• Intracommunautair: The intracommunautair status selected for the order of the related sales invoice is displayed in this column. On hover, the column displays the info text “Intra Community”.
• Country: The country of the address associated with the relation is displayed in the column. When a single address is added to the relation, the country of that address is displayed. If a relation has multiple addresses, the country of the invoicing/billing address will be displayed in the column. If no address is specified as the relation’s invoicing address, the country of the first address entered will be displayed. On hover, the column displays the short info text “The country selected for the address”.
• Packaging: Displays the packaging used for the product as per the orderline. On hover, the column displays the short info text “Packaging.”
• Unloading Address: The unloading address as per the orderline is displayed in this column. On hover, the column displays the short info text “Unloading address”.
• Product Code: Displays the code of the product used in the order line. On hover, the column displays the short info text “Short code of the product.”
• GN code: The GN-Code (if added) of the product is displayed in this product. On hover, the column displays the short info text “Gn code of the product”.
• Foreign Currency: The foreign currency column shows the currency selected in the invoice other than EURO. On hover, the column displays the info text “Foreign Currency”.
• Amount excluding VAT foreign currency: This column shows the amount excluding VAT in the currency selected in the invoice(other than Euro). On hover, the column displays the info text “Total amount excluding VAT in Foreign Currency”.
• Amount including VAT foreign currency: The total amount including VAT is displayed in this column in the currency selected for the invoice(other than Euro). On hover, the column displays the info text “Total amount including VAT in Foreign Currency”.