Update Bill Payment details
Use this worksheet to update your bill payment details.
Always download a new spreadsheet before you begin adding information because each sheet is populated with data from the database.
Formatting rules
- All information should be entered as text or dates.
- You can add sheets if needed, UtilityManagement only processes the sheet named DataEntry.
- Do not remove columns.
Download the update spreadsheet
On the Create menu, click Setup Spreadsheets.
- From the Setup Spreadsheets Log, click Download.
- Under Update Spreadsheets, choose Bill: Payment Details.
- Set the filters as needed to limit the data in the spreadsheet.
- Download the spreadsheet.
- The name format is yyyyddmm-UPDATE_BillPaymentDetails.xlsx.
- Add your information and save.
- Use Import to upload your spreadsheet.
- The Setup Spreadsheet Log reports the results and any errors. You can download the error (kickout) spreadsheet with the hyperlink, fix any errors, and upload the error sheet.
Available update columns are listed below.
| Column | Rules |
|
Bill ID |
Read only |
| Billing Period | Read only |
| Account Number | Read only |
| Vendor Code | Read only |
| Pay Status | Enter text for the pay status |
| Funds Withdrawn Date | Enter a date MM/DD/YYYY |
| Payment Sent Date | Enter a date MM/DD/YYYY |
| Payment Type | For example: VCard, ACH, Check or other information. |
| Payment Type Number | Character limit: 32 |
| Payment Cleared Date | Enter a date MM/DD/YYYY |
| Accounting Period | If your organization uses Accounting Periods, enter the year and month. YYYYMM |
| Payment Amount | Remember to include the decimal. For example, 12.34 |