Update Bill Payment details spreadsheet

Last updated June 24, 2026

What it's for

Use this spreadsheet to update bill payment details. It lets you make changes to key payment fields, such as:

  • Funds withdrawn date
  • Pay status

How to use it

  1. Always download a fresh spreadsheet
    This ensures that you have the latest data from the system.
  2. Make your edits
    Update the payment fields as needed.
    Enter all data as text or dates.
  3. Upload your updates
    Go to the Setup Spreadsheets Log.
    Use the Import button to upload your edited sheet.
  4. View results
    While viewing a bill, use the bill information card and select Payment Activity.

Formatting rules

  • Enter all the information as text or dates.
  • You may add extra sheets, but only the sheet named DataEntry will be processed.
  • Keep column headers and layout intact.
  • ❌ Do not remove or rearrange columns.

Download the update spreadsheet

On the Create dialog, click Setup Spreadsheets.

  1. From the Setup Spreadsheets Log, click Download.
  2. Under Update Spreadsheets, choose Bill: Payment Details.
  3. Set the filters as needed to limit the data in the spreadsheet.
  4. Download the spreadsheet.
  5. The file name format is yyyymmdd-UPDATE_BillPaymentDetails.xlsx.
  6. Add your information and save.
  7. Use Import to upload your spreadsheet.
  8. The Setup Spreadsheets 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
Funded Date Enter a date MM/DD/YYYY
Payment Initiated Date Enter a date MM/DD/YYYY
Payment Type For example: VCard, ACH, Check or other information.
Payment Type Number Character limit: 32
Paid 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