Auto-pilot · this week, Mon 12 Oct to Thu 15 Oct
Automations
Each rule is a WHEN and a THEN in plain English. 16 of 16 rules are on. This week they read 83 orders, priced and checked 1,398 lines and posted 155 invoices to Xero, about 80 h 35 min of work nobody had to do.
Between the fax machine and Xero, this week
Every order passes these rules in turn. Nobody re-types it on the way. Tap a rule to see what it did; switch it off below and its box goes grey.
80 h 35 min
handed back this week, from 4,791 runs
1Landsfax, email, PDF, phone, portal
2Priced and checkedas each line lands
Customer’s own price1,398 lines priced54 contract, 1,309 band, 35 promotionOff: back to a personMargin floor1 old price stopped1,398 lines checked against cost plus 12%Off: back to a personStock check as it is entered1,398 lines checked7 short, each handled by the account's ruleOff: back to a personCredit check161 orders credit-checked2 held, none lostOff: back to a person
3Out the doorruns, picking, customers
Build tomorrow’s runs159 orders put on runs26 drops on Friday's runs so farOff: back to a personRelease pick lists by route20 pick lists releasedone per route, sorted by locationOff: back to a personAnswer "where is my delivery?"1 delivery question answeredwith the van's drop and ETAOff: back to a personPortal confirmations39 portal confirmationseach with a tracking linkOff: back to a person
4Money and stockXero, payments, buying
Invoices to Xero155 invoices posted to Xero£72,022 inc VAT, nothing re-keyedOff: back to a personMatch remittances66 payments matched£36,009 marked paid here and in XeroOff: back to a personChase overdue invoices59 reminders and statementsSue gets the calls at 21 daysOff: back to a personReorder rule3 POs drafted3 lines under the reorder point nowOff: back to a personBack-orders first0 runs yet5 back-ordered lines wait for PO-2230Off: back to a person
New rule
Pick a WHEN, pick a THEN, give it a name
When
Then
WHEN … THEN …
On
WhenThen
Read every order once
WhenA fax, email or PDF lands in the order inbox
ThenRead each line, match it to a product (their codes or their words), and put the order on the board
17last 10:31
83orders read
8 h 18 min
What it did this week
- Today 10:31Fax from The Laurels, Ashdene Care Group read in 46 s: 8 lines on the board
- Today 10:18PDF from Primrose View Care Home read in 22 s: 11 lines on the board
- Today 09:47Email from The Old Tankard read in 22 s: 9 lines on the board
- Today 09:35Email from Lark Coffee Co read in 16 s: 4 lines on the board
- Today 09:19Email from Wharf Offices read in 17 s: 6 lines on the board
- Today 09:12PDF from Trentside Academy, Trentside Academy Trust read in 31 s: 9 lines on the board
Showing 6 of 83 this week. Order inbox →
Time it handed back
8 h 18 min
83 runs this week × about 6 min each by hand
On. It runs without anyone clicking.
Unsure reads go to a person
WhenA line is read with less than 90% confidence or matches two products
ThenHold just that line, show the person the original next to the guess
2last 10:31
2unsure reads
8 min
What it did this week
Time it handed back
8 min
2 runs this week × about 4 min each by hand
On. It runs without anyone clicking.
Customer’s own price
WhenA line is entered or read
ThenPrice it at the contract price, promotion or band for that account
212last 10:31
1,398lines priced
11 h 39 min
What it did this week
- Today 10:31SO-48395 for Ashdene Care Group: 7 lines at their own contract and Band A prices
- Today 10:18SO-48394 for Primrose View Care Home: 11 lines at their own Band B prices
- Today 09:47SO-48393 for The Old Tankard: 8 lines at their own Band C prices
- Today 09:40SO-48392 for Golden Fry: 11 lines at their own Band C prices
- Today 09:37SO-48391 for Moonlight Fried Chicken: 5 lines at their own list prices
- Today 09:35SO-48390 for Lark Coffee Co: 4 lines at their own Band C prices
Showing 6 of 1,398 this week.
Time it handed back
11 h 39 min
1,398 runs this week × about 30 s each by hand
On. It runs without anyone clicking.
Margin floor
WhenA line would sell below cost plus 12%
ThenStop the price, use the account’s rate, and note the price it carried
212last 09:12
1old price stopped
4 h 40 min
What it did this week
- Today 09:12Trentside Academy Trust: Microwave container with lid, 650ml came in at £18.40, under the £19.10 cost. Priced at £24.02, £67.44 kept
- Tue 07:56Crown Fish Bar: Microwave container with lid, 500ml came in at £16.40, under the £17.20 cost. Priced at £21.60, £26.00 kept (before this week)
- Mon 09:41Seaview Pizza: Microwave container with lid, 650ml came in at £18.20, under the £19.10 cost. Priced at £27.30, £54.60 kept (before this week)
Time it handed back
4 h 40 min
1,398 lines checked this week × about 12 s each by hand
On. It runs without anyone clicking.
Stock check as it is entered
WhenA line is priced
ThenKeep the stock for this order; if short, follow the account’s rule: swap, part-ship or ask
212last 10:31
1,398lines checked
11 h 39 min
What it did this week
- Wed 11:22Station Tearoom: Nitrile gloves, blue, unpowdered, M, 1 back-ordered on PO-2230
- Wed 11:32Riverside Restaurant: Nitrile gloves, blue, unpowdered, M, 3 back-ordered on PO-2230
- Wed 14:30Hazelnut Bakehouse: blue nitrile short, swapped to the agreed black nitrile
- Today 06:06Ridgeway Inn and Rooms: Nitrile gloves, blue, unpowdered, M, 1 back-ordered on PO-2230
- Today 07:09The Drovers, Brindle Inns: Nitrile gloves, blue, unpowdered, L, 1 back-ordered on PO-2230
- Today 08:52The Golden Fleece, Brindle Inns: Nitrile gloves, blue, unpowdered, L, 2 back-ordered on PO-2230
- Today 10:18Primrose View Care Home: Nitrile gloves, blue, unpowdered, M short; they asked to be rung first
Showing 7 of 1,398 this week. Short stock →
Time it handed back
11 h 39 min
1,398 runs this week × about 30 s each by hand
On. It runs without anyone clicking.
Credit check
WhenAn order is priced
ThenHold it (not lose it) if it takes the account over its limit or the account is on stop; give Sue the task
25last 10:31
161orders credit-checked
5 h 22 min
What it did this week
- Today 08:52SO-48386 from Brindle Inns held: over the credit limit. Sue has the task
- Today 09:40SO-48392 from Golden Fry held: account on stop. Sue has the task
- Today 10:18SO-48394 from Primrose View Care Home: within the £15,250 limit
- Today 09:37SO-48391 from Moonlight Fried Chicken: within the £3,750 limit
- Today 09:35SO-48390 from Lark Coffee Co: within the £24,250 limit
Showing 5 of 161 this week. Held orders →
Time it handed back
5 h 22 min
161 runs this week × about 2 min each by hand
On. It runs without anyone clicking.
Duplicate catch
WhenThe same order arrives twice
ThenLink the copy to the first order and enter nothing twice
1last 07:44
1duplicate caught
10 min
What it did this week
Time it handed back
10 min
1 runs this week × about 10 min each by hand
On. It runs without anyone clicking.
Build tomorrow’s runs
WhenAn order passes its checks
ThenPut it on its route and day, in drop order, until the 15:00 cut-off
31last 10:31
159orders put on runs
5 h 18 min
What it did this week
- FridayNottingham city: 12 drops, 177 of 450 cases, 2 not checked yet
- FridayDerby and west: 7 drops, 99 of 300 cases, 1 not checked yet
- FridayMansfield and north: 4 drops, 47 of 300 cases, 1 not checked yet
- FridayLeicester and south: 1 drops, 25 of 300 cases
- FridayNewark and east: 2 drops, 24 of 280 cases, 1 not checked yet
Showing 5 of 159 this week. Friday's runs →
Time it handed back
5 h 18 min
159 runs this week × about 2 min each by hand
On. It runs without anyone clicking.
Release pick lists by route
WhenA route’s release time comes round
ThenGroup its orders into one list sorted by location, short lines flagged
2last 10:15
20pick lists released
8 h 20 min
What it did this week
- Next 11:30PL-1016-R1, Nottingham city: 12 orders, 61 lines, releases to Liam
- Today 09:30PL-1016-R2, Derby and west: 6 orders, 33 lines, Ryan has picked 21
- Next 13:00PL-1016-R3, Mansfield and north: 4 orders, 26 lines, releases to Ryan
- Next 13:00PL-1016-R4, Leicester and south: 1 orders, 13 lines, releases to Jade
- Today 10:15PL-1016-R5, Newark and east: 2 orders, 18 lines, Jade has picked 6
Showing 5 of 20 this week. Picking →
Time it handed back
8 h 20 min
20 runs this week × about 25 min each by hand
On. It runs without anyone clicking.
Reorder rule
WhenA line falls under its reorder point (sales during the lead time plus a week)
ThenDraft a purchase order sized to four weeks of sales and ask for an OK
1last 09:30
3POs drafted
1 h
What it did this week
Time it handed back
1 h
3 runs this week × about 20 min each by hand
On. It runs without anyone clicking.
Invoices to Xero
WhenIt is 18:00
ThenPost every signed-for delivery as an invoice in Xero, at the prices on the order
0Yesterday 18:00
155invoices posted to Xero
4 h 30 min
What it did this week
- Today 18:00Next: 32 invoices from today's deliveries, £16,168 inc VAT
- Wed 18:0056 invoices posted from Wed's deliveries, £26,817 inc VAT
- Tue 18:0052 invoices posted from Tue's deliveries, £24,003 inc VAT
- Mon 18:0047 invoices posted from Mon's deliveries, £21,202 inc VAT
Showing 4 of 155 this week. Invoicing →
Time it handed back
4 h 30 min
3 nightly runs this week × about 90 min each by hand
On. It runs without anyone clicking.
Chase overdue invoices
WhenAn invoice is 7, 14 or 45 days overdue
ThenEmail a reminder, a statement or a final letter; give Sue a call at 21 days
1last 07:00
59reminders and statements
4 h 55 min
What it did this week
- Today 07:00Happy Pizza: statement emailed showing everything overdue
- Wed 07:00Rowan View Care Home: statement emailed showing everything overdue
- Wed 07:00Brindle Inns: statement emailed showing everything overdue
- Wed 07:00Foxglove Bakehouse: statement emailed showing everything overdue
- Wed 07:00Acorn Tree Day Nursery: statement emailed showing everything overdue
- Wed 07:00Meadowbrook Infant School: statement emailed showing everything overdue
Showing 6 of 59 this week. Credit control →
Time it handed back
4 h 55 min
59 runs this week × about 5 min each by hand
On. It runs without anyone clicking.
Match remittances
WhenA remittance email arrives
ThenMatch the payment to its invoices and mark them paid
1last 08:05
66payments matched
13 h 12 min
What it did this week
- Today 08:05Rowan Lodge Hotel paid £492.06 by BACS, matched to 2 invoices
- Wed 16:40Hazelnut Coffee Co paid £406.41 by BACS, matched to 1 invoice
- Wed 15:27Sterling Cleaning Services paid £381.87 by BACS, matched to 1 invoice
- Wed 14:50The Three Plough paid £276.27 by BACS, matched to 1 invoice
- Wed 14:33Foxglove Coffee House paid £669.54 by BACS, matched to 1 invoice
- Wed 13:47Trentside Academy Trust paid £936.20 by BACS, matched to 2 invoices
Showing 6 of 66 this week. Payments in →
Time it handed back
13 h 12 min
66 runs this week × about 12 min each by hand
On. It runs without anyone clicking.
Answer "where is my delivery?"
WhenA customer asks when their drop is
ThenReply with the van’s drop number and ETA
1last 09:27
1delivery question answered
6 min
What it did this week
Time it handed back
6 min
1 runs this week × about 6 min each by hand
On. It runs without anyone clicking.
Portal confirmations
WhenA portal order is placed
ThenEmail the confirmation and a tracking link
4last 06:48
39portal confirmations
1 h 18 min
What it did this week
- Today 09:34Stone Oven Trattoria: 13 lines confirmed by email
- Today 08:00Toast Coffee Co: 6 lines confirmed by email
- Today 06:48Copperleaf Hockley, Copperleaf Cafés: "my usual", 12 lines confirmed by email
- Today 06:19The Red Fleece: 8 lines confirmed by email
- Wed 21:14Copperleaf Beeston, Copperleaf Cafés: 11 lines confirmed by email
- Wed 19:29Lark Café: 12 lines confirmed by email
Showing 6 of 39 this week. Portal orders →
Time it handed back
1 h 18 min
39 runs this week × about 2 min each by hand
On. It runs without anyone clicking.
Back-orders first
WhenA purchase order is booked in
ThenFill back-ordered lines before anything else and tell each customer
0Waiting for PO-2230
0runs yet
0 min
What it did this week
- Due Thu 22 OctStation Tearoom: 1 case of Nitrile gloves, blue, unpowdered, M fill first when PO-2230 lands
- Due Thu 22 OctRiverside Restaurant: 3 cases of Nitrile gloves, blue, unpowdered, M fill first when PO-2230 lands
- Due Thu 22 OctRidgeway Inn and Rooms: 1 case of Nitrile gloves, blue, unpowdered, M fill first when PO-2230 lands
- Due Thu 22 OctThe Drovers, Brindle Inns: 1 case of Nitrile gloves, blue, unpowdered, L fill first when PO-2230 lands
- Due Thu 22 OctThe Golden Fleece, Brindle Inns: 2 cases of Nitrile gloves, blue, unpowdered, L fill first when PO-2230 lands
Time it handed back
0 min
0 runs this week × about 15 min each by hand
On. It runs without anyone clicking.
When
Then
0not run yet
0
0 min
What it did this week
Nothing yet. It runs the next time .
Added by you in this demo.
State
On. It runs without anyone clicking.