DEMOE · E01 · WORKSTATION QBO ✓ 2026-07-06 · POS ✓ — DEMO:TJ Kim · Preparer
Home›Portfolio›Ember & Oak Bistro LLC (FICTIONAL)

Ember & Oak Bistro LLC (FICTIONAL)

DEMOE · CA sales & use
2026-07-08
2026-Q3 · PRRecords
2026-07-01 → 2026-09-30 · Due 2026-11-02 · DEMO:TJ Kim → DEMO:Eli Remba → DEMO:Gil Pocker○ Pre-review○ Jurisdiction○ Evidence✔ Exceptions○ Locked IN_PREP
SCHEDULE
Payroll tie-out — liability vs deposits
✓ ties
StepGroupDescriptionAmountTie
SOURCEG941FIT + FICA_SS + FICA_MED liability accrued (PAYX-DEMOE-2026Q3-001)$6,603.30—
TIEP100deposits via EFTPS$6,603.30TIES
SOURCEG_CA_PITSDICA_PIT + CA_SDI liability accrued (PAYX-DEMOE-2026Q3-001)$1,331.10—
TIEP100deposits via EDD$1,331.10TIES
SOURCEG_CA_SUIETTCA_SUI + CA_ETT liability accrued (PAYX-DEMOE-2026Q3-001)$913.50—
TIEP100deposits via EDD$913.50TIES
SOURCEG_FUTAFUTA liability accrued (PAYX-DEMOE-2026Q3-001)$156.60—
TIEP100deposits via EFTPS$156.60TIES
LEAD941/DE9Period wages $26,100.00 · withheld (evidence) $5,500.00$26,100.00—
FILED—Not yet filed — filing is a human-only step——

Red row = start here · ↳ = the blocking exception.

SOURCE
PAYX-DEMOE-2026Q3-001Payroll provider export
ingested
FieldValueNote
pulled2026-07-08payx · by agent:import-payroll
rows282 run(s) · 6 check(s) · 16 liability line(s) · 6 deposit(s)
snapshotpayroll-source/raw/PAYX-DEMOE-2026Q3-001.csvsha256 b27d3c063b44…

Employee identity is masked at the door (E-#### refs only) — richer detail stays external per the PII policy.

WORKPAPER
P100Payroll tax tie-out (liability vs deposits by group)unprepared
DRAFTtie-out

Payroll tax tie-out: liability accrued vs deposits made, by deposit group — the payroll B110.

LineAmountSource refTickmark
G941 liability$6,603.30PAYX-DEMOE-2026Q3-001sd
G941 deposited$6,603.30PAYX-DEMOE-2026Q3-001bk
G941 difference$0.00r
G CA PITSDI liability$1,331.10PAYX-DEMOE-2026Q3-001sd
G CA PITSDI deposited$1,331.10PAYX-DEMOE-2026Q3-001bk
G CA PITSDI difference$0.00r
G CA SUIETT liability$913.50PAYX-DEMOE-2026Q3-001sd
G CA SUIETT deposited$913.50PAYX-DEMOE-2026Q3-001bk
G CA SUIETT difference$0.00r
G FUTA liability$156.60PAYX-DEMOE-2026Q3-001sd
G FUTA deposited$156.60PAYX-DEMOE-2026Q3-001bk
G FUTA difference$0.00r
totals gross$26,100.00PAYX-DEMOE-2026Q3-001sd
totals net$20,600.00PAYX-DEMOE-2026Q3-001sd
totals withheld$5,500.00r
G941 confirmed$6,603.30EFT-270018001+EFT-270018002bk
G CA PITSDI confirmed$1,331.10EDD-C-88001+EDD-C-88002bk
G CA SUIETT confirmed$913.50EDD-C-88003bk
G FUTA confirmed$156.60EFT-270018003bk

Workpaper face — DEMOE-E01_2026-Q3_FED-PR_P100-payroll-tax-tieout_v01.md

P100 — DEMOE-E01_2026-Q3_FED-PR

DRAFT — agent-prepared, not yet verified

G941 (FIT+FICA_SS+FICA_MED → EFTPS): liability 6603.30 [sd→PAYX-DEMOE-2026Q3-001] vs deposited 6603.30 [bk] → difference 0.00 [r]

G_CA_PITSDI (CA_PIT+CA_SDI → EDD): liability 1331.10 [sd→PAYX-DEMOE-2026Q3-001] vs deposited 1331.10 [bk] → difference 0.00 [r]

G_CA_SUIETT (CA_SUI+CA_ETT → EDD): liability 913.50 [sd→PAYX-DEMOE-2026Q3-001] vs deposited 913.50 [bk] → difference 0.00 [r]

G_FUTA (FUTA → EFTPS): liability 156.60 [sd→PAYX-DEMOE-2026Q3-001] vs deposited 156.60 [bk] → difference 0.00 [r]

Totals: gross 26100.00 · net 20600.00 · withheld 5500.00

Deposit trace: 6/6 confirmed · 0 ambiguous · 0 unconfirmed · 0 unmatched confirmation(s) (payroll-confirmations/trace.yaml)

REPORT
REGPayroll registerpulls: PAYX-DEMOE-2026Q3-001
derived
RunPay periodEmployeeGrossNet
2026-07-152026-07-01 → 2026-07-15E-0001$5,200.00$4,056.00
2026-07-152026-07-01 → 2026-07-15E-0002$4,300.00$3,397.00
2026-07-152026-07-01 → 2026-07-15E-0003$3,500.00$2,807.00
2026-07-312026-07-16 → 2026-07-31E-0001$5,200.00$4,056.00
2026-07-312026-07-16 → 2026-07-31E-0002$4,300.00$3,397.00
2026-07-312026-07-16 → 2026-07-31E-0003$3,600.00$2,887.00

Masked employee refs by design — detail stays external (PII policy).

REPORT
SUMSummary by pay periodpulls: PAYX-DEMOE-2026Q3-001
derived
Run datePay periodEmployeesGrossNetWithheld
2026-07-152026-07-01 → 2026-07-153$13,000.00$10,260.00$2,740.00
2026-07-312026-07-16 → 2026-07-313$13,100.00$10,340.00$2,760.00
Total3$26,100.00$20,600.00$5,500.00
REPORT
LIATax liabilitiespulls: PAYX-DEMOE-2026Q3-001
derived
Tax typeAccrued
FIT$2,610.00
FICA_SS$3,236.40
FICA_MED$756.90
CA_PIT$1,044.00
CA_SDI$287.10
CA_SUI$887.40
CA_ETT$26.10
FUTA$156.60

By deposit group

GroupTaxesAgencyLiability
G941FIT, FICA_SS, FICA_MEDEFTPS$6,603.30
G_CA_PITSDICA_PIT, CA_SDIEDD$1,331.10
G_CA_SUIETTCA_SUI, CA_ETTEDD$913.50
G_FUTAFUTAEFTPS$156.60
REPORT
DEPDeposits vs liabilitiespulls: PAYX-DEMOE-2026Q3-001
derived
DateGroupAgencyAmountConfirmation
2026-07-18G941EFTPS$3,289.00confirmed ✓ EFT-270018001
2026-08-03G941EFTPS$3,314.30confirmed ✓ EFT-270018002
2026-07-18G_CA_PITSDIEDD$663.00confirmed ✓ EDD-C-88001
2026-08-03G_CA_PITSDIEDD$668.10confirmed ✓ EDD-C-88002
2026-09-30G_CA_SUIETTEDD$913.50confirmed ✓ EDD-C-88003
2026-09-30G_FUTAEFTPS$156.60confirmed ✓ EFT-270018003

Tie by group

GroupLiabilityDepositedConfirmedDifferenceTie
G941$6,603.30$6,603.30$6,603.30$0.00TIES
G_CA_PITSDI$1,331.10$1,331.10$1,331.10$0.00TIES
G_CA_SUIETT$913.50$913.50$913.50$0.00TIES
G_FUTA$156.60$156.60$156.60$0.00TIES

Trace: 6/6 confirmed (EDDC-DEMOE-2026Q3-001, EFTPS-DEMOE-2026Q3-001)

REPORT
QTDQTD / YTD summarypulls: PAYX-DEMOE-2026Q3-001
derived
ScopeGrossNetPeriods
Quarter (this period)$26,100.00$20,600.002026-Q3
Year to date$26,100.00$20,600.002026-Q3
OUTPUT
Filing evidence / FINAL package
pending

Not locked yet.

LEDGER
Review & exceptions
clear

Exceptions (0)

RefCategorySeverityStatusDetail / resolution
none
Client records — approval chain and generated filing calendar
RECORD
Approval log hash-chained · append-only
CHAIN VALID

approvals\demo\2026-Q3.yaml CHAIN VALID · 2 entries

2026-07-06 14:00DEMO:Gil Pocker approve_filing → DEMO-E01_2026-Q2_CA-SALES
first-cycle partner rule (DEMO) #1 3388daa862…
2026-07-06 16:00DEMO:Eli Remba lock → DEMO-E01_2026-Q2_CA-SALES
FINAL/ built, hashes recorded, prerequisites verified #2 d4373c8ff6…
RECORD
Filing calendar generated — never hand-edited
DuePeriodStatusLocked
2026-11-02DEMOE-E01_2026-Q3_FED-PRNOT_STARTED