Welcome back
Cash Application
Uploads in progressFiles dropped in by hand and not finished. Emails — remittances to fix included — are in AR Inbox.
Column Mapping
Correct column assignments, then re-parse
Review
Lines: 0
Matched: 0
Flagged: 0
Pending: 0
Remit Total: 0.00 Total derived from line items — no stated total in remittance
ⓘ This remittance parks itself under Remittances Received — waiting on deposit as soon as every line has settled, and posts to McLeod once a matching deposit appears on the daily bank report. Nothing to click. If a line is flagged or still looking up it waits for you — resolve or delete that line and it holds itself. To post before the deposit lands, use Post anyway on its row in the waiting list.
| Invoice # | Invoice Amt | Remit Amt | Diff | Status | Note | Delete |
|---|
Reply Preview
In-progress check deposit
Check Deposit
Cash Account: 1000-00-00
Checks: 0
Deposit Total: $0.00
Checks in this Deposit
No checks added yet
Click "+ Add Check" to start building your deposit.
Processing PDF…
Looking up invoices in McLeod…
Add Check
Wrong data? Re-parse this check
📂
Drop remittance file here or click to browse
PDF · Excel · CSV
Parsing…
📋
Multi-page PDF detected
Detecting scan format…
Invoice Lines
Lines: 0
·
Remit Total: $0.00
| Invoice # | Remit Amt | Invoice Amt | Status |
|---|
Deposit Summary
0 checks · $0.00
Posting…
0
0
Connect Outlook in Configuration to load remittance emails directly from your inbox.
All AR emails
— every email the inbox filters let through
Inbox
Last 24 hours
Scanning inbox…
No emails addressed to the AR DL found for this date range.
Why are you dismissing these emails?
Multiple attachments — choose one to load:
Uploaded files
— dropped in by hand and waiting on you. Emailed remittances stay on their email above. Click one to finish it.
Payment Type:
▶
Remittance source — click to expand
📂
Drop a file here, or click to browse
PDF · Excel · CSV · TXT · Multiple files accepted
Drag from File Explorer · or copy an attachment in Outlook and Ctrl+V here
Nothing has been read out of it yet — press Process.
🔗 Link to inbox email for auto-reply?
Reads the invoice numbers and amounts out of what is above.
Apply deposit to invoices
Deposit
Selected
Needs a human eye
— variance or an ambiguous payer.
Deposits in Bank — waiting on remittance
— money we cannot apply yet.
Bank report settings & manual upload
The daily Regions file is pulled automatically. Every parsed remittance — EFT, ACH, wire or check deposit — is parked under Remittances Received — waiting on deposit rather than posting, and posts only when a deposit matches it to the penny: same payer, same amount. Anything a penny out, or covering several invoices at once that don't sum exactly, goes to Needs a human eye instead. This is not a setting — nothing posts to McLeod until the bank report shows the money landed. To override one batch, use Post anyway on that remittance.
Remittances Received — waiting on deposit
— paperwork with no money against it yet.
Posts itself when a matching deposit lands.
Matched — remittance paired with its deposit
Both sides of every pairing, and whether it reached McLeod.
Pending Execution
Open McLeod Cash Receipts Processing to execute these batches.
Transaction History
Last checked:
Deposits dealt with — already posted, or not a payment. Put one back if it was a mistake.
Bank files from Regions
One row per day for the past week, saying whether a file came in \u2014 click a day to
see what was on it, every line including the ones deliberately ignored. Earlier days
are collapsed below. Search finds a payment across all thirty.
CASS AR
No exceptions in the latest run.
Loading exceptions…
Exception
Card Payments
Every card transaction the processor took, checked against what McLeod did with it. Finds payments no receipt ever arrived for, and loads carrying more than they are worth. Reads only — nothing is posted.
Aged AR
Customer payment-status replies
Preview shows what would land on each load. Nothing is written.
No past-due orders in the latest run.
Loading past-due orders…
Past-due order
Reports
to
Accounts
Collections
What is owed · on the last day of the range, and the change since its first day
Collection efforts · comments on past-due loads, and what it took to get them paid
Work waiting right now · not dated and every account, the same as Home
AR Inbox
0
Indexing Review
Open review queue ↗
Unbilled Orders
No unbilled delivered orders in the latest run. 🎉
Loading unbilled orders…
Unbilled order
Connection Status
McLeod TMS
Not tested
Microsoft Graph
Not signed in
Configuration
McLeod TMS API
Microsoft Graph API
MSAL popup auth (no client secret). Enter Azure Client ID.
An email reaches the inbox when one of these is in its To or Cc. Separate several with commas. The first one is also the address auto-replies are sent to.
Sent at 8 AM and 4 PM with posted batches + pending execution list
Outlook Categories
One-time setup — creates AR color categories in your Outlook mailbox so posted emails are tagged automatically.
Permission Diagnostics
Tests Mail.Read, attachment access, and send permissions against your mailbox.
McLeod cash_batch inspector (diagnostic)
Reads a single batch from McLeod's
cash_batch table. Used to compare a Pending batch against an Executed one so we can figure out which field flips on Exec. Read-only — never modifies anything in McLeod.
Invoice Normalization
Invoice numbers are padded to 7 digits using padStart(7,'0'). Examples: 56301 → 0056301
Learned Exclusions
Auto-excluded after 2+ dismissals as "Not a remittance"
Loading…
Portal Senders
Senders that deliver via secure portal — remittance must be downloaded manually, then linked here
Loading…
Duplicate Remittance Rules
Customers known to send duplicate remittances — second email is auto-dismissed with a reply
Loading…
Posting Rules
0–1 (default 0.95) — Short pays where McLeod confirms both invoice balance and customer are auto-posted at this confidence level or higher
Daily Summary Emails
Sent at 8 AM and 4 PM on weekdays via /me/sendMail
8 AM
Never sent
4 PM
Never sent
Customer Profiles
▼
Saved remittance formats for repeat customers. Profiles apply automatically on future uploads.
No profiles saved yet
Process your first remittance and save the format to get started. Future files from the same customer will parse automatically.
| Customer | McLeod ID | Files | Last Used | Actions |
|---|
Format Templates
Built-in detection rules for known remittance formats. Applied automatically before AI parsing — no setup required.
UTZ Charges — bot activity
| When | Order | Charge | Amount | Outcome | Detail |
|---|---|---|---|---|---|
| Loading… | |||||
Credit
Loads on credit hold, new customers and prepay requests, from the CRM. Soonest pickup first.
Loading requests…
New prepay request
Load number first. One link can cover several loads — list them all.
| Load | Customer (bill-to) | McLeod rate | Amount for the link |
|---|
Send the decision
BTF Fuel Recovery
Daily Breakthrough Fuel rates applied to McLeod orders as FSF charges. Runs automatically each morning after the 7:40am report email.
No BTF run recorded yet.
Loading BTF run…
UTZ Fuel — review queue
A row here means a person must look at this load, and the bot did not touch McLeod: e2open and McLeod disagree on its fuel by $100 or more or 100 miles or more,
or the McLeod order carries two fuel lines (fuel would bill twice), or the invoice is already out with the wrong fuel (stage After billing).
Loads not yet billed are e-mailed to the UTZ escalation contacts; billed ones to AR.
Decide, then close the row: Applied = you fixed McLeod (or credited and rebilled) · Reviewed = looked at, nothing to do · Dismissed = e2open is the one that is wrong.
The bot closes a row itself once McLeod matches e2open again (Handled automatically). McLeod's fuel table owns the fuel line: the bot locks the miles to e2open's and never writes a line (decision B, 2026-10-14), so a row can also mean the table's rate differs from UTZ's (update the table), the order has no fuel line yet (open it in McLeod and save/rate it), or a flat line the table would double at billing (remove it). Source of truth is e2open — up for review by AR.
| Order / TMS | Stage | McLeod | e2open | Gap | Last seen | Status | Action |
|---|---|---|---|---|---|---|---|
| Loading… | |||||||
Bot activity log — every load the bot looked at (click to open)
| When | Order / TMS | Stage | McLeod | e2open | Gap | Outcome | Detail |
|---|---|---|---|---|---|---|---|
| Open this section to load the log. | |||||||