Report: Invoice Query: Cancellation Invoices

Related Pages

Report: Invoice Query Training 6: Accounting Training 7: Management

Related Categories

Reports Invoiced Premium Invoice Query

Overview

This report will provide a listing of Cancelled Invoices, and display the Invoice Amount, Agency Commission, and Producer Commission.

The original amount column will indicate the invoice amount, agency commission, and producer commission. (For Broker Clients, the Producer Commission will show in the Paid Amount column.)

Process

See Report: Invoice Query for additional information.

1. Select Reports -> Invoice Query.
2. Press CTRL + A to access the Advanced Query. Select Perform an advanced query and Next.

   

3. Select Query by Invoice, then Next.

   

4. Enter a Start Date and End Date for the range of invoices. Leave the Cut-off Date at 12/31/2099 and select Next.

   

5. Check all options on the client paid screen, then select Next.

   

6. Check all options on the paid to company screen, then select Next.

   

7. Check all options on the paid by company screen, then select Next.

   

8. Check all options on the producer paid screen, then select Next.

   

9. Enter the Cancellation transaction code in the Transaction field, then select Next.

   

10. Leave the defaults for Additional Filters screen, and select Next. (Include On-Account and Use GL Date should be defaults.)

    

11. Leave the department code blank, and select Next.
12. Select Low Detail and Include Agency Commission. Select Next.

    

13. Select the desired sort option, and select Next.
14. Select the Preview or Print.