Workflow · Reconcile · Opening soon
Vendor payment run
Turn your exported QuickBooks bill list into a vendor payment schedule. See unpaid bills due in the next 14 days, grouped by vendor and amount.
Someone typed
“list vendor bills due in the next 14 days by vendor with amounts, for this week's payment run”
The agent read it as
List Vendor bills due in the next 14 days by vendor with amounts, for this week's payment run, using the open balance.
What the agent built
1 step, each one an ordinary Mammoth step you can open and change.
File
Vendor bills
CSV export · 25 rows
Step
List upcoming unpaid bills
Step 1
Result
Upcoming Vendor Bills
19 rows
Schedule
Runs when you say
Proposed
- FileVendor billsCSV export · 25 rows
- StepList upcoming unpaid billsStep 1
- ResultUpcoming Vendor Bills19 rows
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 19 rows came out.
- Download Vendor bills sample (25 rows)QuickBooks: Expenses > Bills > Export
What you get back
The result of that run, the rows to look at first.
Upcoming Vendor BillsSample data19 rows
| Vendor | Open Balance | Bill No. | Due Date |
|---|---|---|---|
| Acme Packaging Co | 1,840 | AP-88102 | 2026-11-13 |
| Acme Packaging Co | 1,295.75 | AP-88119 | 2026-11-25 |
| Bramble Cleaning Supply | 214.30 | BC-44027 | 2026-11-12 |
| Bramble Cleaning Supply | 625.50 | BC-44018 | 2026-11-14 |
| Bramble Cleaning Supply | 336.90 | BC-44033 | 2026-11-17 |
| Copperline Freight | 480 | CF-77118 | 2026-11-15 |
| Copperline Freight | 2,590 | CF-77105 | 2026-11-16 |
| Dune Steel & Fabrication | 4,125 | DS-30911 | 2026-11-17 |
| Dune Steel & Fabrication | 980 | DS-30924 | 2026-11-22 |
| Evergreen IT Services | 845 | IT-55917 | 2026-11-14 |
| Evergreen IT Services | 975 | IT-55891 | 2026-11-18 |
| Evergreen IT Services | 1,320 | IT-55904 | 2026-11-24 |
How do you build a vendor payment schedule from exported bills?
Export your vendor bills from QuickBooks, then upload the file. Mammoth lists the unpaid bills due in the next 14 days, grouped by vendor, using the open balance.
How it works
How to use the Upcoming Vendor Bills workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.
Upcoming Vendor Bills: questions
What export should you use?
Use a bills or vendor bills export from QuickBooks. It should include due date, vendor, and open balance or amount due.
What happens to rows that do not match the rule?
Rows that do not match are left out of the result. In this workflow, that means bills that are not due in the next 14 days, or are not unpaid, do not appear.
How do you change the rule in words?
Change the due date window, the row type, or the fields you want to group by. For example, you can ask for bills due in the next 30 days, invoices, or totals by vendor.
Get early access to this workflow
It will open already built and checked on the sample files. Swap in your own exports and see your result.
Workflows like this
Match two sets of records line by line, and see what agrees, what differs and what is missing on either side.
- Bank reconciliationEvery line matched, flagged for a date check, or missing from one sideSee the workflow Template
- Payment reconciliationEach payout matched to its bank deposit, flagged for a date check, or missingSee the workflow Template
- Cash reconciliationEach day's takings matched to a bank deposit, or flagged as not bankedSee the workflow Template
- Payment processing fees by methodTrack payment processing fees by method each month, total sales and fees, and flag fee rates that are too high.See the workflow Built by the agent
- Three-way matchEach PO line: matched, partly received, billed more than received, or price differsSee the workflow Template
- Invoice reconciliationEach invoice paid in full, part-paid, overpaid or not paid, and payments with no invoiceSee the workflow Template