How To Upload Payment Remittance
-
From the dashboard, select "Batch Management"
-
Select "Upload Payment Remittance"
-
Enter the date range of the invoices you are paying.
-
Tip! The system will only search for invoices created within the date range you enter. Extend your date range for better results and fewer errors.
-
-
Any spreadsheet can be used for the upload but it must have columns labeled to reflect:
- Invoice Number
- Claim Number
- Vendor Name
- Check Date
- Check Number
- Check Amount - Alert! The system will not except dollar signs or commas in the check amount column.
(Tip! Columns do not have to be labeled exactly as listed on the screen. You will have a chance to map the columns on your spreadsheet to the required columns.)
- Select "Choose File", select the file you want to upload. Click "Upload File" to begin the upload.
-
If needed, Map the column titles of your spreadsheet to the required fields.
-
Click "Save"
-
If there are any errors, they will be listed in the red message. Errors can be handled by removing the invoice or editing it.
-
Hover over the error warning next to the invoice to see details about the error.
-
To correct errors, click on the field and change the information or change the information on the spreadsheet and reupload.
-
After corrections are made, click "Validate" to check if any errors remain. When you are ready to submit the batch, click "Validate and Submit".
-
Supplemental invoices included in the batch. Will need to be run separately. Process the batch again by choosing the same file and clicking the Supplemental Invoice check box. Click "Upload File". Tip! To make it easier, you can separate supplement and normal invoices into two spreadsheets to run as two different uploads. Click "Validate and Submit" to process the upload.