Invoice Status Report

The Invoice Status Report provides a way to review the due and paid amounts and the posted statuses of invoices. The report lists the due amount, paid amount, and paid/received date for the customer, the provider, and the commission. The report also indicates if the item has posted to the general ledger, and if so, the date it posted.

The report is subtotaled by either customer or provider account ID. The detail is sorted by invoice number then customer or provider due date.

Running the report

To run the report:

  1. On the Invoice submenu, click Invoice Status Report.

    The Invoice Status Report dialog box appears.

    The following table describes the fields on the Invoice Status Report dialog box.

    Field Description

    Account Type

    Select which type of account to subtotal by.

    Account ID

    Enter the customer or provider account ID to limit the report to invoices for that customer or provider only.

    Settle Type

    Use this option to run the report for specific types. To run for only one type, click the drop-down box and double-click the type. To run for multiple types, click the drop-down box and press Ctrl while using the left mouse button to click each type you want on the report. Selecting all four settlement types is the same as leaving the field blank (the report runs for all settlement types).

    From (for date range)

    Beginning date of a range of invoice dates. Invoices within the specified range of dates will be included on the report. You must use this date in conjunction with the To date to define a range.

    To (for date range)

    Ending date of a range of invoice dates. Invoices within the specified range of dates will be included on the report. You must use this date in conjunction with the From date to define a range.

    Posted Status

    Select one of the following options from the drop-down list:

    • ALL – All items, regardless of posted status
    • Posted – Posted items only
    • Un-Posted – Unposted items only

    Open Items Only

    Indicates whether to include only open (unpaid) items. The report considers an invoice open if any part of it (the customer’s payment, your payment to the provider, or the provider's commission check to you) is unpaid or partially paid.

  2. Complete the fields as appropriate.

    Note: The date fields for Date Range are required.

  3. Choose one of the following print options:

    • To print the report immediately, click PRINT.

      The Send to dialog box appears. Select a report destination. For more information, see Printing Overview.

    • To store the report as part of a batch for printing later, click BATCH.

      The Choose a Batch dialog box appears. For more information, see Batch Printing.

Report example

Invoice Status Report example

Report notes