Selecting Company Payables to Pay
Company payables can be processed on a Paid Per Item basis (if you pay carriers one check/payment per invoice) or as a bulk check if you pay on Per Statement basis (one carrier check/payment made for multiple invoice items).
This procedure explains how to select company payables from the Unpaid Company Payables report, and then use the Create Check dialog to record the payables in the HawkSoft Trust Report to be exported to QuickBooks.
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
In addition, user permissions must be set to include one of the following:
Accounting Reporting > Access Transactions back 2 Days (including today)
OR
Accounting Reporting > Access Transactions with any date
In addition, user permissions must be set to include one of the following:
Accounting Reporting > Access Transactions created by user only
OR
Accounting Reporting > Access Transactions from all users
See User Permissions for more information.
To select company payables
- Generate the Unpaid Company Payables report for the carrier you are paying.
-
Check the box next to each invoice you are paying.
-
Determine if you are paying on a per-item or statement basis.
To pay per-item
Use this option when you are creating a separate check for each invoice.
-
Click the Create Check Per-Item button.
The Create Check Per-Item dialog opens.
-
Review each line item.
To see more information about a specific line item, click > Expand. To see more information about all line items, click Show Details at the bottom-left corner of the dialog.
Line item fields
Field Name Editable? Description Pay to the Order of Yes The name of whom the check will be written to. Date Yes The carrier statement date. Memo Yes These notes will appear on the line item in HawkSoft and Quickbooks.
When you create Company payables, agency revenue, direct bill disbursements, or customer refund checks, HawkSoft adds customer and transaction information to each line in the check. This information is included when you export the check to QuickBooks.
Amount No The amount paid on the invoice Retained Yes The amount you will retain from the customer payment, without sending it to the carrier.
The Retained amount is only editable for line items with retained commission.
Check Amount No The amount you will pay the carrier. Client Information No The client's name(s) and business name. Bank Account Yes The bank account you will be writing the check from.
Depending on your Trust Accounting Setup, some line items may not have an assigned bank account. These line items will automatically expand when you open the Create check Per-Item window. Assign bank accounts to these line items before creating a check.
Item # No The associated invoice number.
Click on the Item # to see that invoice.
Description No The description for this line item on the invoice. Item Name No The item name for this line item on the invoice. Do Not Transfer Yes Check the Do not transfer to QuickBooks box to prevent this transaction from being exported to QuickBooks. QuickBooks Transaction Type Yes Use this drop-down to determine if you want QuickBooks to queue a printed check, or if you will be using EFT (Electronic Funds Transfer).
You can set the transaction type for all line items at the same time by clicking Set All QB Transaction Types, and then selecting Set to Print (to print checks from QuickBooks) or EFT (To use Electronic Funds Transfer).
Class Code Yes If your agency uses class codes, you can set the QuickBooks class code for each transaction. Class codes are assigned based on the invoice. -
Click the Create Checks button.
To pay per statement
Use this option when you are paying multiple invoices on one carrier statement.
-
Click the Create Statement Check button.
The Create Statement Check dialog opens.
-
Verify the Bank Account is correct.
-
Optional: Add notes in the Memo column.
These notes will be exported to QuickBooks.
-
Ensure the Date matches the carrier statement.
-
Select the EFT or Set to Print radio button.
Set to Print - Use this option when you will print a check to the carrier from QuickBooks.
EFT - Use this option when you will pay the carrier using an Electronic Funds Transfer.
-
Conditional: Check the Do not transfer to QuickBooks box to prevent this transaction from being exported to QuickBooks.
-
Conditional: If your agency uses QuickBooks class codes, verify the Class Code.
-
For each line item, verify the following information:
-
Verify the Retained Amount and edit as needed.
-
Verify the Check Amount (Carrier Net).
Click on the Item # to see that invoice.
-
-
Click the Create Check button.
When you create Company payables, agency revenue, direct bill disbursements, or customer refund checks, HawkSoft adds customer and transaction information to each line in the check. This information is included when you export the check to QuickBooks.
-
-
Optional: Click Create Commission Statement to create a commission statement for any of the transactions you have just paid.
For more information, see Creating an Agency Bill Commission Statement.
-
Select Trust Accounting > To Be Exported.
-
Check the box next to each check you are exporting.
If a company payable check is created incorrectly, click the three dots, and then click Void Item. Once you have voided the check, the company payables invoices are returned to Unpaid status.
-
Click the Export button.
-
Close the End of Period Processing and Reporting window.
If you selected Set to Print, the checks are now ready for printing in QuickBooks under New > Print Checks.
Checks created in HawkSoft will have a memo containing the client name, client ID, and policy number.
If you selected EFT, the payments are posted to your bank register in QuickBooks.
If you have received a carrier premium refund check, or a carrier refund statement credit, see Refunds and Corrections Overview.
To modify or select a report layout
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
Customize the columns the way you want them.
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.
To sort by a column
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.
To summarize your report
HawkSoft enables you to Summarize your report to quickly narrow down your results.
- Click Σ Summarize.
The Summarize Report dialog opens.
Click the Select Column drop-down, and then select the desired column.
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.
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.
Click Export to CSV.
The Enter Filename dialog opens.
By default, the spreadsheet will be named "[mm/dd/yyyy][report name]".
Optional: Re-name the exported file by typing a new name into the field dialog.
Click Download.
The CSV spreadsheet will be saved to your computer's local Downloads folder.


