Import Payment Dates

Select Excel File

Upload the exported spreadsheet with payment dates filled in

Import Payment Dates

How to use:

1. First, export the invoice data
2. Open the exported Excel file
3. Add payment dates in the "Pmt Date" column
4. Save the Excel file
5. Upload the file using the form on this page

Important Notes:

• Payment dates should be in MM/DD/YYYY format
• Only the latest invoice per unit is shown in exports
• The system matches invoices by unit, due date, and amount
• Leave payment date blank for unpaid invoices

Required Columns:

The spreadsheet must contain these columns:

• Unit
• Due Date
• Pmt Date
• Total Invoice