Invoice reporting for an end-of-year report has four methods that you can do in sequence:
Use the End of Day Totals report
Use the Invoice Revenue By Group report
Use the Invoice Lines report
Use the Taxable Sales report
1. Use the End of Day Totals report
The End of Day Totals report output gives a good initial source for you to do checks with after you use other recommended reports during end-of-year reporting.
Make sure that you set the report date range to the applicable year.
The report output gives:
Totals for invoices that are not approved
Totals for approved invoices
Totals owed at the start and end of the year
Total payments received
Payments received for each payment method
2. Use the Invoice Revenue By Group report
The output of the Invoice Revenue By Group report includes:
Approved invoices that are paid
Approved invoices that are not paid
Thus, the report tells you about the total possible revenue of all approved invoices. The total possible revenue includes approved invoices that clients did not make payment for in the report date range that you select.
Make sure that you:
Set the report date range to the applicable year
Set Group By to Date (month)
Figure 1. The Group By setting
3. Use the Invoice Lines report
Use the Invoice Lines report to do a check of discounts for products and services. The report output:
Shows the discount for each product
Shows price adjustment reasons for each product
Shows the price of each product before and after a discount
Note: If you have many invoices, set the report date range to a period that is less than one year. Then do the report again and again until you complete the full year.
4. Use the Taxable Sales report
The output of the Taxable Sales report gives:
The invoice totals for products and services
The total tax quantity for each of ezyVet's configured tax rate
Make sure that you set the report date range to the applicable year.
