activha wrote: Following my latest post, I need urgently to know our total turnover for january and february including paid and pending baskets, and I need to have our accountants contact pending baskets with offline payments for requiring checks.
Now with cbsubs 4.0.2 how can I achieve this and have the total computed in HT and TTC ???
Paid Subscriptions -> Taxes -> Sales tax report
gives you a detailed tax report for
completed sales.
Per month and
per currency. Without and with taxes, with all those columns:
- Payments completed date
- Currency
- Invoices
- Tax-exempt invoices
- Taxed invoices
- Gross total invoiced and received
- Gross sub-total exempt from sales tax
- Gross sub-total containing sales tax
- Net total sales, excl. sales-taxes
- Net sub-total taxable sales
- Sales-taxes collected
- Tax rate
- Currency exchange rate
- Gross total invoiced and received (in main currency)
- Net Sub-Total taxable (in main currency)
- Sales-taxes collected (in main currency)
That's the information that we use for our own TVA (sales tax) quarterly reportings.
However for annual accounting and the final reconciliation annual VAT report, like most companies, we are using the information provided by the acquiring banks, as those are the ones that are the official binding numbers.
You even have links to view the payments and also to view the corresponding invoices that you can print (from backend).
In search tools, it is possible to narrow down a bit if needed.
CBSubs considers
Pending baskets as just being confirmed orders, with a proforma invoice and as not delivered, and as such, they are not subject to tax in Switzerland and EU to the best of my knowledge.
Now if you need in that tax report view a new search tools to also be able to search by baskets by state Completed/Pending/... with default staying Completed, it is something that can be done without too much effort. Such a filter would make sense only if you start delivering before the payment.
As this filtering feature has never been asked up to now, I have added this as a feature-request #5886 for CBSubs 4.1, due out later this year,
If I read properly all other VAT reporting help features requests are already available in the Tax Report as explained above.