Ordway's Bulk Transactions feature in Cash Application lets you upload lockbox files containing multiple checks and their remittance details. Ordway processes the uploaded file and displays it as a report containing the individual checks.
You can expand a report to review its itemized checks, inspect matching results and warnings, and apply or ignore each check independently. This allows you to process the checks within a lockbox deposit without treating the entire batch as a single payment.
Contents
- Overview
- Prerequisites
- Upload a Lockbox File
- Review an Uploaded Report
- Understand Parsing Results and Warnings
- Process Itemized Checks
- Understand Report Statuses
- Frequently Asked Questions
Overview
A lockbox is a payment collection method in which a bank receives customer checks and related remittance information. The bank makes the transaction details available so the payments can be matched and processed.
With Bulk Transactions, you can upload a lockbox file containing multiple checks. Ordway organizes the uploaded information into a report with an overall batch amount and a list of itemized checks.
The workflow allows you to:
- Upload supported lockbox files.
- Review the total amount and number of checks in an uploaded report.
- Expand a report to view its individual checks.
- Review customer and invoice matching results.
- Apply or ignore checks individually.
- Review warnings and resolve unmatched or flagged checks.
- Track the processing status of each report.
Prerequisites
Before using Bulk Transactions, ensure that:
- Cash Application is enabled for your company.
- The Enable Bulk Lockbox Transactions setting is enabled for your company.
- The lockbox file is in a supported format and does not exceed 15 MB.
Note: The Bulk Transactions tab is displayed only when Bulk Lockbox Transactions is enabled. If the tab is not available, contact your Ordway administrator or Ordway Support.
Upload a Lockbox File
You can upload a lockbox file from the Bulk Transactions tab.
- In Ordway, navigate to Ordway Payments > Cash Application. The Cash Application page is displayed.
- Click Bulk Transactions tab.
- Click UPLOAD FILE.
- Select the lockbox file from your computer.
- Upload the file. Ordway parses the file and adds it to the Imports list.
Supported file formats
You can upload files in the following formats:
| Format | Extension |
| Comma-separated values | .csv |
| Excel 97–2003 workbook | .xls |
| Excel workbook | .xlsx |
| Portable Document Format |
File size limit: Each uploaded file must not exceed 15 MB.
Ordway displays an error if you upload a file larger than the limit: File is too large (max 15 MB)
Prepare separate files when the source file exceeds the size limit. Each file must meet the upload requirements.
Duplicate and invalid files
Ordway validates uploaded files and displays an error when a file cannot be accepted.
| Condition | Behavior |
| Unsupported file format, such as .txt or .png | Ordway rejects the file and displays an error. |
| File exceeds 15 MB | Ordway rejects the file and displays the file-size error. |
| Previously uploaded file or duplicate file data | Ordway rejects the upload and displays This file has already been uploaded. |
| Empty file or file containing only headers | The report is marked as failed and displays a reason. |
Ordway can identify duplicate file data even when the file name is changed. Renaming a file does not make duplicate transaction data eligible for another upload.
Sample Screens with the errors
Review an Uploaded Report
After uploading a file, open the Imports list to review its processing status and transaction summary.
Each report displays information such as:
- File name: Name of the uploaded file.
- Date: Date associated with the uploaded report.
- Total: Number of checks in the report.
- Matched: Number of checks with matching results.
- Unmatched: Number of checks without matching results.
- Applied: Number of checks that have been applied.
- Unapplied: Number of checks that have not been applied.
- Ignored: Number of checks moved to Ignored.
- Amount: Aggregate amount displayed for the report.
- Status: Overall processing status of the report.
View itemized checks
To inspect the checks included in a report:
- Locate the uploaded report in the Imports list.
- Select the expand icon next to the report.
- Review the batch summary, including the number of checks and the aggregate amount.
- Review the individual check rows.
The expanded report displays check information such as:
| Column | Description |
| Date | Date associated with the check. |
| Description | Customer or transaction description from the uploaded data. |
| Amount | Amount associated with the check. |
| Status | Current matching or processing status of the check. |
| Match Criteria | Matching information identified by Ordway. |
| Action | Available actions for the check, such as Apply, Review, or Ignore. |
A single check can contain multiple invoice details. In this case, Ordway displays the invoice lines under the same check rather than treating each invoice line as a separate check.
Understand Parsing Results and Warnings
When Ordway parses a lockbox file, it reads transaction details such as amounts, dates, check numbers, customer information, and invoice numbers.
The parsed report displays these details for review. A file with a title row above the column headers can also be parsed.
Parsing warnings
Ordway may display warnings when the uploaded data contains incomplete or inconsistent information.
| Condition | Warning or behavior |
| A row is missing an amount | Ordway skips the row and displays an N row(s) skipped: missing amount warning. The skipped row is not created as a check. |
| A row does not contain a check number or reference | Ordway skips the row and displays an unidentified warning. |
| The file total does not equal the sum of the individual checks | Ordway displays a control-total mismatch warning. |
| The invoices associated with a check do not add up to the check amount | Ordway displays an overpayment or underpayment warning on that check. |
| The same customer and check number appear more than once | Ordway flags both entries as possible duplicates. |
Review these warnings before applying checks. They help you identify missing information, duplicate entries, and differences between check amounts and invoice amounts.
Process Itemized Checks
You can process each check independently within an expanded report. Applying or ignoring one check does not automatically apply or ignore the other checks in the batch.
Apply a Matched Check
When a check has a suitable match, you can apply it to create the corresponding payment.
- Expand the uploaded report.
- Locate the check you want to process.
- Review its amount, status, and matching information.
- Click Apply for the check.
- Verify that the check's status and report totals are updated.
Review a Check
Use Review when a check needs additional verification.
- Expand the uploaded report.
- Locate the check that requires review.
- Click Review or move the check to the review state.
- Review the available customer and invoice matching information.
- Complete the required review before applying or ignoring the check.
You can also move a check back from the review state when it is ready for further processing.
Ignore a Check
Use Ignore when you do not want to apply a check.
- Expand the uploaded report.
- Locate the check.
- Click Ignore.
Ordway moves the check to the Ignored status and updates the report totals.
Reverse or Unapply an Applied Check
If an applied check needs to be reversed, use the available reverse or unapply action.
- Expand the uploaded report.
- Locate the applied check.
- Select the available Reverse or Unapply action.
- Verify that the check returns to the Unapplied status.
Perform Actions on Multiple Checks
You can select multiple checks and perform supported bulk actions.
- Expand the report.
- Select the checkboxes for the required checks.
- Open the available bulk actions.
- Select Ignore Selected, Move to Review, or Delete Selected.
- Verify the updated check counts and statuses.
The report reflects the resulting changes.
Re-match Unmatched Transactions
Use Re-match to run matching again for unmatched transactions.
- Open the Bulk Transactions page.
- Locate the Re-match action.
- Click RE-MATCH.
- Review the updated matching results in the report.
Download the Uploaded File
To download the original file associated with a report, click the download icon for that report. Ordway downloads the original uploaded file.
Understand Report Statuses
The report status indicates the overall processing state of the uploaded file.
| Status | Description |
| In Progress | Ordway is parsing the uploaded file. |
| Rejected | The file failed processing or did not contain any usable checks. |
| Needs Review | One or more checks contain warnings or have been flagged for review. |
| Completed | All checks in the report have been applied or ignored. |
| Passed | The file was processed without warnings, but not all checks have been applied or ignored. |
The report totals and status update as you process the individual checks.
Sample Screen
Frequently Asked Questions
| Questions | Answer |
| Which file formats can I upload? | You can upload .csv, .xls, .xlsx, and .pdf files. |
| What is the maximum file size? | The maximum file size is 15 MB. Ordway rejects files larger than this limit. |
| Can I upload the same file more than once? | No. Ordway rejects a previously uploaded file or duplicate file data and displays an error. |
| Can one check contain multiple invoices? | Yes. Ordway displays multiple invoice lines under the same check when a check is associated with more than one invoice. |
| What happens if a check is missing an amount? | Ordway skips the affected row and displays a warning. The row is not created as a check. |
| Can I apply or ignore individual checks in a batch? | Yes. You can apply or ignore each check independently. You can also select multiple checks to perform supported bulk actions. |
| Can I process unmatched checks again? | Yes. Use Re-match to run matching again for unmatched transactions. |
| Can I download the uploaded lockbox file? | Yes. Use the download icon on the report to download the original uploaded file. |
Comments
0 comments
Please sign in to leave a comment.