Running the Unpaid Company Payables Report

The Unpaid Company Payables report contains all invoices that have not been paid to the carrier. This report is run as part of paying your company payables.

The Unpaid Company Payables Report is used to calculate the amount due to each carrier, and can be filtered to summarize the total amount due to all carriers.

HawkSoft also provides additional Trust Accounting reports for Paid Payables and All Payables.

This task is typically performed by an Owner/Administrator, Manager, or Bookkeeper.

In order to complete this task, user permissions must be set to include:

Accounting Reporting > Access Trust Accounting Report
Accounting Reporting > Access Company/Agency Payables Reports and Workflows

Exporting payables transactions to QuickBooks requires additional permissions. See Selecting Company Payables to Pay for more information.

See User Permissions for more information.

To run an Unpaid Company Payables Report

  1. Click Accounting > Trust Accounting from the HawkSoft menu bar.

    OR

    1. Log into the HawkSoft Web app, accessed from any computer.

    2. Click the Accounting icon in the left column of the HawkSoft web start page to access Accounting Reporting and Processing

      For more information about logging into the HawkSoft web app, see Logging In and Out of HawkSoft.

    The End of Period Processing and Reporting window opens.

  2. Select Company Payables > Unpaid Company Payables.

    The Select Company Payable Accounts dialog opens.

  3. Select the Company Payable account(s) to be paid.

    Do not select non-carrier items such as Direct Bill Liabilities, Balance Waived, or Opening Balance.

    Additionally, HawkSoft recommends that you select and work on one payables account at a time.

  4. Optional: Select a Date to Filter and a Date Range, Start Date, and/or End Date.

    The Date to Filter can be the Invoice/Credit Memo Creation Date, the due date of invoices, or the item date listed on the invoice/credit memo.

    On a Paid report or All Company Payables report, the option for Company Payable Paid Date is available.

    On a Paid report or All Agency Revenue report, options for both Company Payable Paid Date and Agency Revenue Paid Date are available.

  5. Click the Generate Report button.

    The Unpaid Company Payables report opens.

Keep this report open, and continue onto the Selecting Company Payables to Pay article for steps on paying the company payables in this report.

Customizing columns

Click Edit Columns to add, remove, or reorder columns on the report. Re-order columns by clicking-and-draging the dots on the left-side of the column name.

Saving a layout for reuse

  1. Customize the columns the way you want them.

  2. Select Layout Options > Save as New Layout, and give it a name.

Using a saved layout

Open Customize Columns and select it from the Use Layout drop-down.

Managing existing layouts

Select Layout Options for an existing layout to set it as default, rename it, or delete it. You can also update your selected layout to match your current column settings.

You can set a default layout for each report.

You can change the sort order of the report by clicking on any of the column headers.

  • Click once to sort the report by the data in that column from A-Z or from smallest to largest. The column displays an up arrow to show it is sorted in Ascending order:

  • Click again on the same column to reverse the sort, arranging the data by the value in that column from Z-A, or from largest to smallest. The column displays a down arrow to show it is sorted in Descending order:

  • Click on the same column a third time to remove the custom sorting, returning the report to the default sort order (typically Customer ID, ascending).

For example, you may choose to Summarize a Trust Accounting report by Payee, and then sort by Name.

HawkSoft enables you to Summarize your report to quickly narrow down your results.

  1. Click Σ Summarize.

    The Summarize Report dialog opens.

  2. Click the Select Column drop-down, and then select the desired column.

  3. Click Summarize.

    The summary sorts all items in the report by the selected column, and groups all items with the same value in that column into a single row.

    Example: When a report is summarized by 'Last Name', the summary displays all last names present in the report, and groups all clients with the same last name into the same line.

  4. Click on the name of any item to see a sub-report of all the entries that contain that row's value.

Click the  Clear button next to the "Summary of [column name]" or "Report of [column name]" tag to return to your original report.

You can export report information from HawkSoft to a CSV spreadsheet file. You can then open the exported data in a spreadsheet program, such as Microsoft Excel.

  1. Click Export to CSV.

    The Enter Filename dialog opens.

    By default, the spreadsheet will be named "[mm/dd/yyyy][report name]".

  2. Optional: Re-name the exported file by typing a new name into the field dialog.

  3. Click Download.

    The CSV spreadsheet will be saved to your computer's local Downloads folder.

Related Topics Link IconRelated Topics