Forum

Ask, reply and learn. Join the community of Akaunting.

New Discussion

Report: Taxable Sales (absolute must have)

Van Stokes   ( User )

Commented 6 years ago

A absolute must have. Need to have a report that shows the taxable sales for a given date range. This is critical so people can correctly report and pay their taxes. Without this feature the whole system is not very useful for retail sales. The report needs to report all taxable items:


Example DML:


SELECT
  rqu_taxes.name,
  SUM( rqu_invoice_items.total ) AS `Taxable Amount`
FROM
  rqu_invoices,
  rqu_invoice_items,
  rqu_taxes
WHERE rqu_invoices.invoiced_at
BETWEEN '2017-12-01 00:00:00' AND '2017-12-31 23:59:59'
AND rqu_invoices.invoice_status_code != 'draft'
AND rqu_invoices.deleted_at IS NULL
AND rqu_invoices.company_id = 2
AND rqu_invoice_items.company_id = rqu_invoices.company_id
AND rqu_invoice_items.deleted_at IS NULL
AND rqu_taxes.id = rqu_invoice_items.tax_id
GROUP BY
  rqu_taxes.name
;


 

Denis Dulici   ( Admin )

Commented 6 years ago

Tax Summary and more reports are coming in the next versions.

Please login or register to leave a response.

Showing 1 to 2 of 2 discussions