Batch Payables Selection

Many teams manage high-volume payables in a spreadsheet with custom logic around which vendors to pay, when, and how much. Batch Payables Selection lets you drive your payment runs from a spreadsheet where the data already lives.

How to Batch Import

1. Navigate to Action > Batch Payables Selection from the Accounts Payable tab.

   

2. Drag and drop (or select) your spreadsheet file.

   

3. Configure the column mapping to match your template - MakersHub will remember your configuration for future mappings and reconcile the spreadsheet against outstanding payables. Click Schedule Payment or Mark as Paid to batch create all records at once.

   1. Is Selected column (optional): Include and exclude specific rows from the batch. By default, exclusion of this column includes all the data in the file.

Things to Be Aware Of

• Vendor Names and Invoice Numbers must match MakersHub exactly - Discrepancies between your spreadsheet and MakersHub data will be flagged, but the record in MakersHub is the source of truth.

• Default Payment Amount - If no payment amount is specified, MakersHub defaults to the full outstanding balance.

• Partial Payments - Specify a payment amount less than the outstanding balance to record a partial payment without any post-import editing.

• Default Payment Date - If no payment date is specified, the system uses today’s date (for ASAP payments) or the bill’s Due Date.

• Discrepancy Highlighting - Rows that can’t be matched to an outstanding payable are flagged before you confirm, giving you a chance to correct or exclude them.