Sample dataFranchisee settlement
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.
Section 1
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.
| # | Franchisee | Salons | Reports received | Totals tie | Attachments | Status |
|---|---|---|---|---|---|---|
| 01 | Bluegrass Tanning Group | 4 | 4/4 | ✓ | 5 | Sent |
| 02 | Harbor Sun Partners | 5 | 5/5 | ✓ | 7 | Sent |
| 03 | Cedar Ridge Salons | 1 | 1/1 | ✓ | 4 | Sent |
| 04 | Lakeshore Bronze Co | 8 | 8/8 | ✓ | 4 | Sent |
| 05 | Prairie Bronze Holdings | 4 | 4/4 | ✓ | 6 | Sent |
| 06 | Summit Sun Group | 1 | 1/1 | ✓ | 6 | Sent |
| 07 | Riverbend Tan LLC NSF report missing for 1 salon. Stopped before sending. | 3 | 2/3 | not run | 4 | Held |
| 08 | Magnolia Salon Partners | 2 | 2/2 | ✓ | 6 | Sent |
| 09 | Copper Canyon Sun | 5 | 5/5 | ✓ | 4 | Sent |
| 10 | Oak Hollow Wellness | 3 | 3/3 | ✓ | 4 | Sent |
| 11 | Maple Street Tanning | 8 | 8/8 | ✓ | 6 | Sent |
| 12 | Redwood Sun Group | 1 | 1/1 | ✓ | 8 | Sent |
| 13 | Coastal Bronze Partners | 2 | 2/2 | ✓ | 5 | Sent |
| 14 | Sandstone Salons | 1 | 1/1 | ✓ | 6 | Sent |
| 15 | Willow Creek Tan | 5 | 5/5 | ✓ | 4 | Sent |
| 16 | Northgate Sun Co | 3 | 3/3 | ✓ | 4 | Sent |
| 17 | Evergreen Tanning | 8 | 8/8 | ✓ | 8 | Sent |
| 18 | Silver Lake Salons | 2 | 2/2 | ✓ | 6 | Sent |
| 19 | Pinecrest Sun Group | 5 | 5/5 | ✓ | 5 | Sent |
| 20 | Timberline Tan Attachment count 5, expected 4. Stopped before sending. | 8 | 8/8 | held | 5 | Held |
| 21 | Golden Valley Partners | 3 | 3/3 | ✓ | 6 | Sent |
| 22 | Stonebridge Salons | 2 | 2/2 | ✓ | 4 | Sent |
| 23 | Meadowlark Sun | 3 | 3/3 | ✓ | 6 | Sent |
| 24 | Ironwood Tanning | 2 | 2/2 | ✓ | 6 | Sent |
| 25 | Sunrise Ridge Group | 2 | 2/2 | ✓ | 6 | Sent |
| 26 | Heron Bay Salons | 1 | 1/1 | ✓ | 6 | Sent |
| 27 | Alder Point Tan | 3 | 3/3 | ✓ | 6 | Sent |
| 28 | Foxglove Sun Co | 8 | 8/8 | ✓ | 6 | Sent |
| 29 | Juniper Hill Partners | 4 | 4/4 | ✓ | 6 | Sent |
The early draft runs after the final draft closes. It is built next month and is not part of this month's counts above.
| # | Franchisee | Salons | Scheduled | Status |
|---|---|---|---|---|
| 01 | Bluegrass Tanning Group | 4 | Nov 16 | Not sent yet |
| 02 | Harbor Sun Partners | 5 | Nov 16 | Not sent yet |
| 03 | Cedar Ridge Salons | 1 | Nov 16 | Not sent yet |
| 04 | Lakeshore Bronze Co | 8 | Nov 16 | Not sent yet |
| 05 | Prairie Bronze Holdings | 4 | Nov 16 | Not sent yet |
| 06 | Summit Sun Group | 1 | Nov 16 | Not sent yet |
| 07 | Riverbend Tan LLC | 3 | Nov 16 | Not sent yet |
| 08 | Magnolia Salon Partners | 2 | Nov 16 | Not sent yet |
| 09 | Copper Canyon Sun | 5 | Nov 16 | Not sent yet |
| 10 | Oak Hollow Wellness | 3 | Nov 16 | Not sent yet |
| 11 | Maple Street Tanning | 8 | Nov 16 | Not sent yet |
| 12 | Redwood Sun Group | 1 | Nov 16 | Not sent yet |
| 13 | Coastal Bronze Partners | 2 | Nov 16 | Not sent yet |
| 14 | Sandstone Salons | 1 | Nov 16 | Not sent yet |
| 15 | Willow Creek Tan | 5 | Nov 16 | Not sent yet |
| 16 | Northgate Sun Co | 3 | Nov 16 | Not sent yet |
| 17 | Evergreen Tanning | 8 | Nov 16 | Not sent yet |
| 18 | Silver Lake Salons | 2 | Nov 16 | Not sent yet |
| 19 | Pinecrest Sun Group | 5 | Nov 16 | Not sent yet |
| 20 | Timberline Tan | 8 | Nov 16 | Not sent yet |
| 21 | Golden Valley Partners | 3 | Nov 16 | Not sent yet |
| 22 | Stonebridge Salons | 2 | Nov 16 | Not sent yet |
| 23 | Meadowlark Sun | 3 | Nov 16 | Not sent yet |
| 24 | Ironwood Tanning | 2 | Nov 16 | Not sent yet |
| 25 | Sunrise Ridge Group | 2 | Nov 16 | Not sent yet |
| 26 | Heron Bay Salons | 1 | Nov 16 | Not sent yet |
| 27 | Alder Point Tan | 3 | Nov 16 | Not sent yet |
| 28 | Foxglove Sun Co | 8 | Nov 16 | Not sent yet |
| 29 | Juniper Hill Partners | 4 | Nov 16 | Not sent yet |
Section 2
Each check runs on every packet before it is sent. Any failure stops that packet and nothing else.
Section 3
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.
| Acct | Account | Documents pulled | File built | Status |
|---|---|---|---|---|
| 1010 | Operating Cash | 3 of 3 | ✓ | Built |
| 1020 | Payroll Cash | 2 of 2 | ✓ | Built |
| 1030 | Franchisee Deposit Cash | 3 of 3 | ✓ | Built |
| 1100 | Credit Card Clearing | 4 of 4 | ✓ | Built |
| 1200 | Accounts Receivable – Franchisees | 6 of 6 | ✓ | Built |
| 1250 | Other Receivables | 2 of 2 | ✓ | Built |
| 1300 | Prepaid Insurance | 2 of 2 | ✓ | Built |
| 1310 | Prepaid Software | 3 of 3 | ✓ | Built |
| 1400 | Inventory – Supplies | 2 of 2 | ✓ | Built |
| 1500 | Equipment Needs a document. 1 invoice not found by vendor + invoice number | 4 of 5 | waiting | Needs a document |
| 1510 | Accumulated Depreciation – Equipment | 1 of 1 | ✓ | Built |
| 1600 | Leasehold Improvements | 3 of 3 | ✓ | Built |
| 1700 | Security Deposits | 2 of 2 | ✓ | Built |
| 1800 | Intangible Assets | 2 of 2 | ✓ | Built |
| 1900 | Other Assets | 2 of 2 | ✓ | Built |
| 1950 | Employee Advances | 1 of 1 | ✓ | Built |
| 2000 | Accounts Payable | 8 of 8 | ✓ | Built |
| 2100 | Accrued Liabilities Needs a document. 1 invoice not found by vendor + invoice number | 4 of 5 | waiting | Needs a document |
| 2150 | Accrued Payroll | 2 of 2 | ✓ | Built |
| 2200 | Sales Tax Payable | 4 of 4 | ✓ | Built |
| 2250 | Gift Card Liability | 2 of 2 | ✓ | Built |
| 2300 | Deferred Franchise Fees | 3 of 3 | ✓ | Built |
| 2400 | Franchisee Deposits Held | 3 of 3 | ✓ | Built |
| 2500 | Line of Credit | 1 of 1 | ✓ | Built |
| 2600 | Long-Term Note Payable | 1 of 1 | ✓ | Built |
| 2700 | Deferred Rent | 1 of 1 | ✓ | Built |
| 2800 | Customer Deposits | 2 of 2 | ✓ | Built |
| 3000 | Owner Contributions | 1 of 1 | ✓ | Built |
| 3100 | Owner Distributions | 2 of 2 | ✓ | Built |
| 3200 | Retained Earnings | 1 of 1 | ✓ | Built |
Section 4