NSCC w/Accounting, HR and Payroll

Executive Capability Brief for CEO, Controller, Finance & Back Office Leadership

Organization: International Protective Services, Inc. (IPS) Product: NorthStar Courier Command (NSCC) — NSCC w/Accounting, HR and Payroll Document version: August 21, 2026 Audience: Executive leadership, finance leadership, HR, and back-office operations Live demo: https://nscc-beacon-demo.web.app/demo2/ Filename note: File stem remains NSCC_NATIVE_FINANCE_* for link stability; product name in prose is NSCC w/Accounting, HR and Payroll (do not call the stack “Native Finance” alone).

Living module map: see NSCC_FINANCE_HR_PAYROLL_BLUEPRINT.md (auto-updated from code). This executive brief is the narrative / charts companion. Customer walkthrough: NSCC_ACCT_HR_PAYROLL_CUSTOMER_PACK.md.

1. Executive summary

NorthStar Courier Command (NSCC) is IPS's operations and coordination platform for courier, patrol, and guard services. Beyond dispatch and field coordination, NSCC includes a production-grade back-office layer — NSCC w/Accounting, HR and Payroll — covering:

• - Accounting — Easy (Dashboard, Invoices, Pay field work, Statements, Recurring, Bills, Banking, COA, GL, Reports) plus Advanced ledger / close / tax / analytics (~26 modules)
• - Payroll — Easy (Pay runs, Employees, Reports, Year-End) plus Advanced tax setup, premiums, garnishments, ACH, certified payroll (~12 modules)
• - HR & Compliance — Easy (Overview, Employees, Leave, Documents, Reports) plus Advanced recruiting, I-9, WC, filings, multi-state regulations (~21 modules)

Today IPS runs in a dual-mode architecture:

This document describes the native platform — accounting, payroll, and HR — its supporting data, controls, and the strategic case for why it may represent a better long-term solution than extending Sage 300 CRE as the primary operational finance and HR interface.

Bottom line for leadership: NSCC closes the gap between what happens in the field and what finance and HR see in the books. Where Sage 300 CRE requires manual staging, promotion, and posting across disconnected modules, NSCC can draft invoices from delivered trips, pay field work into the books, run office payroll, track workers-comp from incident reports, and produce board packages — from the same console dispatchers already use. Staff stay in Easy mode (outcome language) or open Advanced when they need the full ledger.

2. The business problem

IPS operates three revenue lines — courier (CIT), patrol, and guard services — with complex job costing dimensions (customer, site, route, department). Finance staff face recurring friction:

1. 1. Operations-to-ledger latency — A delivered trip or completed shift does not automatically become a receivable. Staff must push staging rows, verify ODBC delivery, and promote/post in Sage 300 CRE.
2. 2. Disconnected workflows — AR, AP, bank reconciliation, job cost, and payroll live in separate Sage modules with separate close processes.
3. 3. Limited operational visibility — Sage knows posted transactions; it does not know dispatch status, custody chain, or real-time field completion.
4. 4. Reporting lag — Board and finance packages require Crystal Reports exports, Excel manipulation, and manual footnotes.
5. 5. Small-team SOD tension — Segregation of duties is difficult when one person handles billing, approval, and payment.
6. 6. Multi-state HR complexity — IPS field staff work across New England and expansion states; wage, leave, SUI, and new-hire rules differ by jurisdiction and are not in Sage dispatch.
7. 7. Incident-to-claim latency — Guard/patrol/courier incident reports do not automatically open a workers-comp claim in CRE.

NSCC w/Accounting, HR and Payroll addresses these by embedding accounting and people operations inside the operations platform — with audit trails, role gates, and automated drafting from field events.

3. Platform architecture

The native stack stores authoritative ledger data in Cloud Firestore (demo sandbox or live org collections), with a 21-account IPS chart of accounts and double-entry journal posting on every consequential action.

!NSCC w/Accounting, HR and Payroll architecture

Data flow (native mode):

1. 1. Field / dispatch — Trip delivered, patrol shift complete, guard post hours logged, incident reported
2. 2. Create today's invoices — Staff draft AR from delivered trips / completed shifts for a service date (Accounting → Invoices). Per-job auto-draft is not the live path.
3. 3. Approval — Approver reviews; approval posts balanced JE to GL (revenue + sales tax split)
4. 4. Payroll — Company sets weekly or bi-weekly → Preview hours → Run payroll → GL (5000 / 2010 / 2020)
5. 5. HR — Incident → WC claim; background / discipline / state filings in the same Back Office
6. 6. Payment — Customer payment → Undeposited Funds (1050) → bank deposit → reconciliation
7. 7. Close — Checklist, readiness gate, period lock, board package export

Contrast with Sage 300 CRE path:

1. 1. Operations complete → Back Office → Sage Connect → Push to NSCC_JC_Staging / NSCC_PR_Staging
2. 2. Python ODBC middleware on IPS server writes staging tables
3. 3. Finance promotes staging in CRE → posts AR / payroll
4. 4. NSCC verifies receipt (clearback) — but does not own posted GL

4. Accounting workspace — Easy + Advanced

The Accounting view provides a single shell for finance. Easy mode mirrors a QBO-style curated set; Advanced unlocks the full catalog (~26 modules). Living ids/labels: NSCC_FINANCE_HR_PAYROLL_BLUEPRINT.md.

Easy (day-to-day)

Advanced (selected highlights)

!Accounting capability coverage by tier

5. Capability tiers (production roadmap)

The native stack was delivered in five incremental accounting tiers, then Payroll and HR shells — each adding production controls:

Tier 1 — Foundation controls

• - Immutable audit trail (FINANCE_AUDIT_EVENTS)
• - AR aging buckets (current, 30, 60, 90+ days) with credit limit checks
• - Budget vs actual reporting
• - Bank reconciliation match suggestions

Tier 2 — Close & liquidity

• - Recurring journal accrual templates
• - Fixed asset register with depreciation posting
• - 10-task month-end close checklist
• - Collections workflow with write-off capability
• - 13-week cash flow forecast

Tier 3 — Tax, AP workflow & planning

• - Sales tax on AR approval (liability acct 2030)
• - Deferred revenue schedules and monthly recognition (acct 2300)
• - AP payment run: Draft → Approve → Execute
• - Budget planning UI with line-level entry
• - Bank categorization rules (pattern → GL account)
• - Financial close package export

Tier 4 — Consolidation & compliance

• - Division consolidated P&L by department dimension
• - Variance commentary on budget exceptions
• - Manual JE draft → approve → post (maker-checker)
• - Close readiness gate (≥80% checklist + bank recon threshold)
• - 1099 CSV export from AP vendor master
• - Payroll tax reconciliation panel
• - Audit trail CSV export

Tier 5 — Board & analytics

• - Comparative P&L (month-over-month)
• - GL anomaly detection (large entries, duplicate patterns, unusual credits)
• - Year-end close automation (net income → retained earnings)
• - Financial statement footnotes (period disclosures)
• - Intercompany balance tracking
• - Integration health score (0–100)
• - Enhanced board package workbook (20 sheets)

6. Financial performance — demo supporting data

The demo2 environment seeds six months of synthetic GL activity (March–August 2026) designed to populate executive dashboards and trend charts. These figures illustrate the reporting depth available without waiting for month-end Sage exports.

!Revenue and expense trend

Six-month totals: Revenue $781,650 | Expenses $603,500 | Net income $178,150 | Avg margin 22.8%

!Net income trend

Budget vs actual (sample period)

Variance commentary is captured in-system (e.g., "Fuel over budget — Gulf Fleet rate increase +2 extra route days").

AR aging (sample)

!AR aging distribution

Credit limits are enforced at AR approval — invoices exceeding customer limits are flagged before GL posting.

7. Report catalog — 16 financial reports

All reports support on-screen preview, Excel export, CSV export, and print. A full finance workbook exports all 16 sheets; the board package adds comparative P&L, anomaly summary, footnotes, and integration health.

Editable round-trip: AR open items, AP open items, and journal import templates can be exported to Excel, edited offline, and re-imported — reducing manual re-keying.

8. Controls, audit & period close

Role-based access

Segregation of duties (maker-checker)

A small-team override (admin-only) relaxes SOD when one person handles all accounting — documented with an active banner.

Period close workflow

!Close readiness and integration health

1. 1. Close checklist — 10 tasks (bank recon, AR review, AP accruals, depreciation, tax, etc.)
2. 2. Readiness gate — Requires ≥80% checklist completion and ≤5 uncleared bank transactions
3. 3. Period lock — Closed periods block all GL posting (AR, AP, payments, payroll, manual JE)
4. 4. Year-end — Automated roll of net income to retained earnings (acct 3000)
5. 5. Footnotes — Period disclosure narratives included in board package
6. 6. Audit trail — Every consequential action logged append-only; CSV export for auditors

Integration health score

A composite 0–100 score evaluates close readiness:

9. Operations integration — why this matters

NSCC's strategic advantage is native coupling between field events and financial records.

Job costing dimensions are stamped on every GL line: customer, site, route, department, class, and job reference. This enables P&L by any dimension without CRE report writer customization.

!Operations-to-ledger workflow comparison

10. Payroll

In /demo2, Payroll (and HR & Compliance) replace Sage Connect in the left nav for the native SKU. Easy mode shows Pay runs / Employees / Reports / Year-End; Advanced unlocks the full ~12-module payroll catalog (tax setup, premiums, garnishments, ACH, certified payroll, etc.). Pay field work lives under Accounting (ops-driven hours/trips), not under Payroll → Pay runs.

Payroll tabs

Company pay frequency

Payroll admin sets one pay frequency for the company (not per employee). Field and office staff on the same roster are paid on the same cadence. Changing frequency applies to the next preview / pay run; already-posted runs stay in history.

Overtime still follows the FLSA weekly 40-hour test. IPS (or any tenant) picks weekly or bi-weekly in Payroll next to the provider control. Demo seed defaults to bi-weekly so the three posted sample runs match a 26-pay-year calendar.

Payroll posting & providers

• - GL preview is required before posting; post_payroll is an approver/admin permission.
• - Provider adapter: Check, Gusto, or Sandbox (no API key) — outbound sync requests, not a replacement for a certified payroll bureau today.
• - Demo seed: 3 posted payroll runs (bi-weekly default) with GL entries; pay profiles for the demo roster.

11. HR & Compliance

Payroll's companion shell is HR & Compliance — people operations that Sage 300 CRE does not host next to dispatch. Easy mode covers Overview / Employees / Leave / Documents / Reports; Advanced adds recruiting, I-9, WC, filings, regulations, and more (~21 modules).

Org scale (demo2)

Why this belongs next to finance

Workers-comp reserves, payroll tax payable, and 1099 accruals are GL events. Incident reports already exist in NSCC field apps. HR & Compliance turns those operational records into claims, filings, and year-end forms without a second HRIS login.

12. NSCC native platform vs Sage 300 CRE — detailed comparison

!Feature comparison: NSCC native vs Sage 300 CRE

13. Why NSCC may be a better solution

For the CEO

1. 1. Single platform narrative — Operations, billing, and finance visibility in one console. No "swivel chair" between dispatch and Sage.
2. 2. Faster billing cycle — Draft a day of customer invoices from delivered work in one click; approve posts to GL.
3. 3. Real-time KPIs — Executive dashboard links to live AR, cash, and net income without waiting for month-end close.
4. 4. Reduced key-person risk — Documented workflows, role gates, and audit trail reduce dependence on one Sage power user.
5. 5. Modern delivery — Cloud-hosted, SSO-authenticated, mobile-aware. No terminal server or CRE client licensing for read access.

For the controller and finance department

1. 1. Close compression — Checklist, readiness gate, recurring accruals, and depreciation runs reduce close from weeks to days.
2. 2. Board-ready output — One-click 20-sheet workbook with comparative P&L, footnotes, and health score.
3. 3. Variance discipline — Budget vs actual with mandatory commentary on exceptions.
4. 4. Compliance tooling — 1099 export, payroll tax recon, audit CSV — without Crystal Reports customization.
5. 5. Liquidity visibility — 13-week cash forecast from live AR/AP pipeline.

For back-office staff

1. 1. Fewer handoffs — AR, AP, bank, and GL in one tabbed interface.
2. 2. Excel round-trip — Export AR/AP/journals to Excel, edit, re-import.
3. 3. Bank rules — Auto-suggest GL accounts from transaction descriptions.
4. 4. Collections workflow — Aging buckets, cases, and write-off in the AR tab.
5. 5. Clear role boundaries — Clerk / approver / admin with visible SOD blocks.
6. 6. HR next to the roster — Background, WC, discipline, and state filings without leaving Back Office.
7. 7. Pay cadence the company picks — Weekly or bi-weekly for the whole roster; change it in Payroll without a Sage cycle rebuild.

For HR / people operations

1. 1. One roster — Pay profiles, discipline, and background checks use the same personnel master as dispatch.
2. 2. Incident → claim — Field Incident Reports become WC claims without re-keying.
3. 3. State rules in the console — 17-state wage / leave / SUI / new-hire knowledge base instead of a binder or wiki.
4. 4. Year-end in one place — W-2 from payroll runs and 1099 from AP vendors.

14. Honest assessment — when Sage 300 CRE still wins

NSCC w/Accounting, HR and Payroll is a production prototype for workflows and controls — not a certified tax/ACH replacement for Sage 300 CRE today. Sage remains appropriate when:

Recommended path: Continue Sage 300 CRE as system of record for live IPS while using Demo 2 (NSCC w/Accounting, HR and Payroll) to prove workflows, train staff, and evaluate a phased migration. The Sage bridge path remains available — NSCC does not force a choice. Honest gaps (certified tax tables, bureau ACH, week-batch invoices, etc.): NSCC_ENTERPRISE_READINESS_PREP.md.

15. Implementation paths

Path A — Status quo (Sage bridge)

• - NSCC stages billing/payroll facts → Sage 300 CRE posts
• - Lowest risk; current production model
• - NSCC provides verify/clearback and executive visibility

Path B — Hybrid

• - Native NSCC stack for AR drafting, job costing, field pay, and reporting
• - Sage bridge for final GL post and payroll tax remittance
• - Requires reconciliation between systems

Path C — Full native SoR (phased cutover)

• - Production org on native finance mode (NSCC_FINANCE_MODE=native or equivalent SKU)
• - Full GL in Firestore; Payroll and HR shells replace Sage Connect for day-to-day people/money workflows
• - **Already demonstrated in /demo2** for Accounting + Payroll + HR UX; production cutover still requires CPA review, parallel run, data migration, and (for payroll tax remittance) a certified bureau or continued CRE PR
• - Feature modules / vendors / law packs: NSCC_SYSTEM_CONFIGURATION.md

16. Appendix A — Firestore finance & HR collections

17. Appendix B — Chart of accounts (IPS standard)

18. Appendix C — Related documentation

This brief tracks NSCC w/Accounting, HR and Payroll as of August 21, 2026 (Accounting Easy/Advanced + Payroll + HR shells). Living module tables come from code via the blueprint generator. Demo figures are synthetic seed data for illustration. Production IPS financials remain in Sage 300 CRE unless and until a native migration is approved. OAuth client secrets, service-account keys, and Sage ODBC passwords are intentionally omitted.