Sumz ConsultingSample data
Sample data. Every name, count and time on this page is made up to show how a monthly run is tracked. No real franchisee or client is shown.

Franchisee settlement

Monthly Draft Run — October 2026 (sample data)

This page is built by the run itself, every month. It shows what was built, what was sent, what was stopped, and the checks behind each decision.

Franchisees in run
29
Final Draft, 1st–15th
Packets built
28/29
1 not built, see Held
Packets sent
27
All checks passed first
Held for review
2
Stopped before sending
Checks passed
289 of 291
2 failed, both held
Run finished
2:33 a.m.
Summary emailed 8:00 a.m.
Held means the system worked. It stops before anything wrong is sent. A held packet waits for a person to fix the cause, then goes out on the next pass.

Section 1

Final Draft (1st–15th)

One row per franchisee. Reports received counts the source reports collected for their salons. Totals tie means the packet's totals match the source reports. Attachments shows the number sent against that franchisee's preference.

#FranchiseeSalonsReports receivedTotals tieAttachmentsStatus
01Bluegrass Tanning Group44/4✓5Sent
02Harbor Sun Partners55/5✓7Sent
03Cedar Ridge Salons11/1✓4Sent
04Lakeshore Bronze Co88/8✓4Sent
05Prairie Bronze Holdings44/4✓6Sent
06Summit Sun Group11/1✓6Sent
07Riverbend Tan LLC
NSF report missing for 1 salon. Stopped before sending.
32/3not run4Held
08Magnolia Salon Partners22/2✓6Sent
09Copper Canyon Sun55/5✓4Sent
10Oak Hollow Wellness33/3✓4Sent
11Maple Street Tanning88/8✓6Sent
12Redwood Sun Group11/1✓8Sent
13Coastal Bronze Partners22/2✓5Sent
14Sandstone Salons11/1✓6Sent
15Willow Creek Tan55/5✓4Sent
16Northgate Sun Co33/3✓4Sent
17Evergreen Tanning88/8✓8Sent
18Silver Lake Salons22/2✓6Sent
19Pinecrest Sun Group55/5✓5Sent
20Timberline Tan
Attachment count 5, expected 4. Stopped before sending.
88/8held5Held
21Golden Valley Partners33/3✓6Sent
22Stonebridge Salons22/2✓4Sent
23Meadowlark Sun33/3✓6Sent
24Ironwood Tanning22/2✓6Sent
25Sunrise Ridge Group22/2✓6Sent
26Heron Bay Salons11/1✓6Sent
27Alder Point Tan33/3✓6Sent
28Foxglove Sun Co88/8✓6Sent
29Juniper Hill Partners44/4✓6Sent

Early Draft (16th–end, next month)

The early draft runs after the final draft closes. It is built next month and is not part of this month's counts above.

#FranchiseeSalonsScheduledStatus
01Bluegrass Tanning Group4Nov 16Not sent yet
02Harbor Sun Partners5Nov 16Not sent yet
03Cedar Ridge Salons1Nov 16Not sent yet
04Lakeshore Bronze Co8Nov 16Not sent yet
05Prairie Bronze Holdings4Nov 16Not sent yet
06Summit Sun Group1Nov 16Not sent yet
07Riverbend Tan LLC3Nov 16Not sent yet
08Magnolia Salon Partners2Nov 16Not sent yet
09Copper Canyon Sun5Nov 16Not sent yet
10Oak Hollow Wellness3Nov 16Not sent yet
11Maple Street Tanning8Nov 16Not sent yet
12Redwood Sun Group1Nov 16Not sent yet
13Coastal Bronze Partners2Nov 16Not sent yet
14Sandstone Salons1Nov 16Not sent yet
15Willow Creek Tan5Nov 16Not sent yet
16Northgate Sun Co3Nov 16Not sent yet
17Evergreen Tanning8Nov 16Not sent yet
18Silver Lake Salons2Nov 16Not sent yet
19Pinecrest Sun Group5Nov 16Not sent yet
20Timberline Tan8Nov 16Not sent yet
21Golden Valley Partners3Nov 16Not sent yet
22Stonebridge Salons2Nov 16Not sent yet
23Meadowlark Sun3Nov 16Not sent yet
24Ironwood Tanning2Nov 16Not sent yet
25Sunrise Ridge Group2Nov 16Not sent yet
26Heron Bay Salons1Nov 16Not sent yet
27Alder Point Tan3Nov 16Not sent yet
28Foxglove Sun Co8Nov 16Not sent yet
29Juniper Hill Partners4Nov 16Not sent yet

Section 2

Checks every run must pass

Each check runs on every packet before it is sent. Any failure stops that packet and nothing else.

!
All source reports presentEvery salon has its sales, tax, NSF and deposit reports
1 salon missing an NSF report. Franchisee 07 held.
149 of 150
✓
Early draft ties to actualEarly draft amount compared with the actual report totals
29 of 29
✓
Monthly detail grand total tiesSalon detail adds up to the monthly grand total
28 of 28
✓
Tax and tan tax tieTax and tan tax lines match the source reports
28 of 28
!
Right files for the right franchiseeFile count and names match that franchisee's preference
Franchisee 20 has 7 attachments, expects 6. Held.
27 of 28
✓
Recipient matches the distribution listSend-to address matches the current list
28 of 28
Two packets failed a check this run. Both were stopped before sending and are listed in Section 1.

Section 3

Balance sheet backup

For each balance sheet account, the supporting documents are pulled from the document system and the backup file is built. 77 of 79 documents found. 2 accounts need a document.

AcctAccountDocuments pulledFile builtStatus
1010Operating Cash3 of 3✓Built
1020Payroll Cash2 of 2✓Built
1030Franchisee Deposit Cash3 of 3✓Built
1100Credit Card Clearing4 of 4✓Built
1200Accounts Receivable – Franchisees6 of 6✓Built
1250Other Receivables2 of 2✓Built
1300Prepaid Insurance2 of 2✓Built
1310Prepaid Software3 of 3✓Built
1400Inventory – Supplies2 of 2✓Built
1500Equipment
Needs a document. 1 invoice not found by vendor + invoice number
4 of 5waitingNeeds a document
1510Accumulated Depreciation – Equipment1 of 1✓Built
1600Leasehold Improvements3 of 3✓Built
1700Security Deposits2 of 2✓Built
1800Intangible Assets2 of 2✓Built
1900Other Assets2 of 2✓Built
1950Employee Advances1 of 1✓Built
2000Accounts Payable8 of 8✓Built
2100Accrued Liabilities
Needs a document. 1 invoice not found by vendor + invoice number
4 of 5waitingNeeds a document
2150Accrued Payroll2 of 2✓Built
2200Sales Tax Payable4 of 4✓Built
2250Gift Card Liability2 of 2✓Built
2300Deferred Franchise Fees3 of 3✓Built
2400Franchisee Deposits Held3 of 3✓Built
2500Line of Credit1 of 1✓Built
2600Long-Term Note Payable1 of 1✓Built
2700Deferred Rent1 of 1✓Built
2800Customer Deposits2 of 2✓Built
3000Owner Contributions1 of 1✓Built
3100Owner Distributions2 of 2✓Built
3200Retained Earnings1 of 1✓Built

Section 4

Run log