Bill Pay

This article describes at a high level how to configure Bill Pay. The entire configuration is completed with the help of our services team.

Bill Pay is an automated nightly process that exports utility bills from the application for payment. Using custom bill lists and reports you can track the payment status of each bill.

Bill Pay is paired with Export to AP to keep your accounting system in sync with your payments.

Bill export folders

After the application is configured for Bill Pay, the Bill Export section displays the Waiting to Export for Payment folder.

During your implementation, your organization will decide when bills are exported. It is recommended to export bills after the batch is closed and the bills are approved.

Daily automation

Any bills in the Waiting to Export for Payment folder are sent to our processing partner daily on weekdays to initiate payment.

At the same time the bills are sent for payment, the bills in the Waiting for Export to AP are sent to your organization's SFTP folder to be processed by your accounting system to document that payment was made.

Notifications

A notification is sent if the Bill Pay process encounters an error. The notification includes bills that were successful and those that were unsuccessful.

Note: The AP exporter sends notifications for all exports regardless of status.

Remember to turn on the notifications you want to receive in Notification Settings.

Bill export history

You can review the bills that were exported for each day in the bill export log.  

  • View exported bills in a bill list.
  • Download a list of bills to an Excel file to help you validate the export.

Bill lists

Two special bill lists are configured for your organization when you use Bill Pay.

  • Paid Last 30 days
  • Pay Status of Exported Bills

If needed, you can also create other bill lists to help you review bills in the payment process.

Ready for Payment list

The Ready for Payment list provides an unfiltered view of all payable bills. The following bills will not appear on the Ready for Payment list:

  • Bills with Pay Status = Do Not Pay
  • Bills where the Account Custom Field "Exclude from Payment" is set to Yes
  • Bills with zero or negative total cost
  • Bills failing an audit set to Flag & Hold (excluded until the hold is released)
  • Bills with an End Date on or before the go-live (cut over) date per SystemData setting

Notes:

  • The list does not exclude bills solely on batch code (for example, Maint_, Hist_): older maintenance/historical bills are excluded by the cutover date filter instead.
  • Bills that are flagged but not on hold will still appear and be eligible for payment.
  • This list helps prevent incomplete or incorrect payments.
  • It does not include filters or topmost permissions.
  • There are no actions or check boxes available except to download the bill list to Excel.

Payment details on a bill

While viewing a bill, you can find additional payment information on the Payment Activity tab of the bill information card. 

Reporting

Report-48 is an Excel report containing accounts that are missing payment account information. This report is configured for a daily distribution and is only sent when the report contains data. For example a new account is added to the application after the initial configuration.

Account custom fields

During your initial configuration, spreadsheets are used to configure the custom fields on accounts.

The following custom fields are populated for Bill Pay accounts:

  • Payment Account - this is the bank account used for payment, often a friendly nickname is used here, for example, PNC Bank.
  • Exclude from Payments - Yes/No
  • Export to AP after Payment - Yes/No

Vendor custom field and configuration

The vendor custom field  named Default Payment Account, is the default bank account to use if the payment account information is not entered for the individual account.

In addition to populating the custom fields, the vendor remit address and phone number must be populated. If an account has a different remit address it can be entered at the account level.