NSITES CAPITALMODULE 07RECONCILIATIONSESSION ID A4F7-21B9
MODULE 06 · RECONCILIATION
Payment Reconciliation Engine
EXPECTED = Σ(Usage × Contract% × Rate) compared against statements, deposits, and wires. Variance, timing, missing, and split-allocation handling.
EXPECTED Σ
$26.23M
ALL STATEMENTS
RECEIVED Σ
$24.02M
CASH BASIS
MATCH RATE+1.4 pp
7.5%
VARIANCE OPEN
16
MISSING
9
EXPECTED vs RECEIVED · BY ARTIST
WATERFALLSTATEMENT LEDGER
30 ROWS| STMT | PERIOD | SOURCE | ARTIST | EXPECTED | RECEIVED | Δ | DATE | STATUS | ACT |
|---|---|---|---|---|---|---|---|---|---|
| STM-50001 | 2025-Q3 | APPLE MUSIC | NOVA RHYTHM | $216.5K | $203.8K | -$12.7K (-5.9%) | 2025-05-09 | UNDER REVIEW | |
| STM-50002 | 2025-Q3 | HORIZON RECORDS | NOVA RHYTHM | $114.5K | $114.1K | -$414 (-0.4%) | 2025-07-27 | RECONCILED | |
| STM-50003 | 2025-Q3 | APPLE MUSIC | NOVA RHYTHM | $210.6K | $194.9K | -$15.7K (-7.4%) | 2025-03-12 | UNDER REVIEW | |
| STM-50004 | 2025-Q2 | TUNECORE | NOVA RHYTHM | $260.5K | $296.9K | $36.3K (14.0%) | 2025-08-07 | UNDER REVIEW | |
| STM-50005 | 2025-Q2 | TUNECORE | NOVA RHYTHM | $222.5K | $233.8K | $11.3K (5.1%) | 2025-08-19 | UNDER REVIEW | |
| STM-50006 | 2025-Q2 | BMI | NOVA RHYTHM | $223.1K | $236.3K | $13.2K (5.9%) | 2025-07-04 | UNDER REVIEW | |
| STM-50007 | 2025-Q1 | SONY | NOVA RHYTHM | $389.2K | $375.4K | -$13.8K (-3.5%) | 2025-06-24 | UNDER REVIEW | |
| STM-50008 | 2025-Q1 | BMI | NOVA RHYTHM | $87.2K | $75.7K | -$11.6K (-13.2%) | 2025-07-26 | VARIANCE | |
| STM-50009 | 2025-Q1 | YOUTUBE | NOVA RHYTHM | $261.2K | $255.8K | -$5.4K (-2.1%) | 2025-04-02 | UNDER REVIEW | |
| STM-50010 | 2024-Q4 | HORIZON RECORDS | NOVA RHYTHM | $273.0K | $246.3K | -$26.7K (-9.8%) | 2025-06-07 | UNDER REVIEW | |
| STM-50011 | 2024-Q4 | ASCAP | NOVA RHYTHM | $365.7K | $386.0K | $20.3K (5.5%) | 2025-07-25 | UNDER REVIEW | |
| STM-50012 | 2024-Q4 | SONY | NOVA RHYTHM | $286.0K | $268.7K | -$17.3K (-6.1%) | 2025-01-09 | UNDER REVIEW | |
| STM-50013 | 2024-Q3 | YOUTUBE | NOVA RHYTHM | $160.6K | $0 | -$160.6K (-100.0%) | 2025-09-23 | MISSING | |
| STM-50014 | 2024-Q3 | TUNECORE | NOVA RHYTHM | $116.1K | $104.4K | -$11.8K (-10.1%) | 2025-06-18 | VARIANCE | |
| STM-50015 | 2024-Q3 | HORIZON RECORDS | NOVA RHYTHM | $158.1K | $164.2K | $6.1K (3.9%) | 2025-05-16 | UNDER REVIEW | |
| STM-50016 | 2025-Q3 | ASCAP | ECHO SKYLINE | $293.6K | $332.2K | $38.6K (13.1%) | 2025-02-03 | UNDER REVIEW | |
| STM-50017 | 2025-Q3 | YOUTUBE | ECHO SKYLINE | $172.3K | $170.2K | -$2.1K (-1.2%) | 2025-06-20 | RECONCILED | |
| STM-50018 | 2025-Q3 | ASCAP | ECHO SKYLINE | $257.5K | $271.9K | $14.4K (5.6%) | 2025-08-18 | UNDER REVIEW | |
| STM-50019 | 2025-Q2 | SPOTIFY | ECHO SKYLINE | $266.9K | $228.1K | -$38.8K (-14.5%) | 2025-05-12 | VARIANCE | |
| STM-50020 | 2025-Q2 | APPLE MUSIC | ECHO SKYLINE | $114.6K | $122.3K | $7.7K (6.7%) | 2025-06-24 | UNDER REVIEW | |
| STM-50021 | 2025-Q2 | SONY | ECHO SKYLINE | $121.1K | $0 | -$121.1K (-100.0%) | 2025-04-11 | MISSING | |
| STM-50022 | 2025-Q1 | HORIZON RECORDS | ECHO SKYLINE | $208.5K | $215.8K | $7.3K (3.5%) | 2025-09-10 | UNDER REVIEW | |
| STM-50023 | 2025-Q1 | APPLE MUSIC | ECHO SKYLINE | $123.6K | $106.8K | -$16.7K (-13.5%) | 2025-09-20 | VARIANCE | |
| STM-50024 | 2025-Q1 | SPOTIFY | ECHO SKYLINE | $327.1K | $364.0K | $36.9K (11.3%) | 2025-02-03 | UNDER REVIEW | |
| STM-50025 | 2024-Q4 | TUNECORE | ECHO SKYLINE | $274.4K | $294.5K | $20.2K (7.4%) | 2025-05-09 | UNDER REVIEW | |
| STM-50026 | 2024-Q4 | APPLE MUSIC | ECHO SKYLINE | $91.5K | $82.2K | -$9.3K (-10.2%) | 2025-03-02 | VARIANCE | |
| STM-50027 | 2024-Q4 | HORIZON RECORDS | ECHO SKYLINE | $130.7K | $136.4K | $5.7K (4.3%) | 2025-05-09 | UNDER REVIEW | |
| STM-50028 | 2024-Q3 | HORIZON RECORDS | ECHO SKYLINE | $184.1K | $182.9K | -$1.2K (-0.6%) | 2025-09-11 | RECONCILED | |
| STM-50029 | 2024-Q3 | SOUNDEXCHANGE | ECHO SKYLINE | $263.7K | $0 | -$263.7K (-100.0%) | 2025-01-13 | MISSING | |
| STM-50030 | 2024-Q3 | APPLE MUSIC | ECHO SKYLINE | $293.1K | $275.4K | -$17.6K (-6.0%) | 2025-09-26 | UNDER REVIEW |