← 1456 W 85th St, Cleveland, OH 44102 · All properties

Aligned Assetrail Dry Run - 1456 W 85th St - Monthly Reconciliation.csv

This page is a searchable text preview. Use the Dropbox link for the full original file.

Open full file in Dropbox

What This File Appears To Be

month,aligned_txn_count,aligned_cash_in,aligned_cash_out,aligned_net,assetrail_property_row_count,assetrail_property_net,assetrail_aligned_cash_count,assetrail_aligned_cash_net,delta_aligned_net_vs_assetrail_aligned_cash,reconciliation_role,dry_run_status 2024-01,4,5253.32,5253.32,0.00,0,0.00,0,0.00,0.00,import_aligned_detail_to_manual_clearing,manual_clearing_detail_no_cash_match_yet 2024-02,3,182.50,482.50,-300.00,0,0.00,0,0.00,-300.00,import_aligned_detail_to_manual_clearing,manual_clearing_d

Text Preview

month,aligned_txn_count,aligned_cash_in,aligned_cash_out,aligned_net,assetrail_property_row_count,assetrail_property_net,assetrail_aligned_cash_count,assetrail_aligned_cash_net,delta_aligned_net_vs_assetrail_aligned_cash,reconciliation_role,dry_run_status
2024-01,4,5253.32,5253.32,0.00,0,0.00,0,0.00,0.00,import_aligned_detail_to_manual_clearing,manual_clearing_detail_no_cash_match_yet
2024-02,3,182.50,482.50,-300.00,0,0.00,0,0.00,-300.00,import_aligned_detail_to_manual_clearing,manual_clearing_detail_no_cash_match_yet
2024-03,6,425.81,447.27,-21.46,0,0.00,0,0.00,-21.46,import_aligned_detail_to_manual_clearing,manual_clearing_detail_no_cash_match_yet
2024-04,13,445.00,2462.31,-2017.31,0,0.00,0,0.00,-2017.31,import_aligned_detail_to_manual_clearing,manual_clearing_detail_no_cash_match_yet
2024-05,1,300.00,0.00,300.00,0,0.00,0,0.00,300.00,import_aligned_detail_to_manual_clearing,manual_clearing_detail_no_cash_match_yet
2024-06,1,462.00,0.00,462.00,0,0.00,0,0.00,462.00,import_aligned_detail_to_manual_clearing,manual_clearing_detail_no_cash_match_yet
2024-07,9,2028.22,972.86,1055.36,0,0.00,0,0.00,1055.36,import_aligned_detail_to_manual_clearing,manual_clearing_detail_no_cash_match_yet
2024-08,6,2846.51,1165.80,1680.71,0,0.00,0,0.00,1680.71,import_aligned_detail_to_manual_clearing,manual_clearing_detail_no_cash_match_yet
2024-09,21,1939.20,1644.61,294.59,0,0.00,0,0.00,294.59,import_aligned_detail_to_manual_clearing,manual_clearing_detail_no_cash_match_yet
2024-11,3,825.00,1200.05,-375.05,0,0.00,0,0.00,-375.05,import_aligned_detail_to_manual_clearing,manual_clearing_detail_no_cash_match_yet
2025-01,1,0.00,121.06,-121.06,0,0.00,0,0.00,-121.06,import_aligned_detail_to_manual_clearing,manual_clearing_detail_no_cash_match_yet
2025-02,2,0.00,555.91,-555.91,0,0.00,0,0.00,-555.91,import_aligned_detail_to_manual_clearing,manual_clearing_detail_no_cash_match_yet
2025-03,2,0.00,1136.70,-1136.70,0,0.00,0,0.00,-1136.70,import_aligned_detail_to_manual_clearing,manual_clearing_detail_no_cash_match_yet
2025-05,8,1815.00,2325.79,-510.79,1,2016.29,1,2016.29,-2527.08,import_aligned_detail_and_reconcile_to_existing_cash,matched_to_existing_aligned_cash_settlement
2025-06,12,2665.99,1374.38,1291.61,0,0.00,0,0.00,1291.61,import_aligned_detail_to_manual_clearing,manual_clearing_detail_no_cash_match_yet
2025-07,20,1845.99,3049.04,-1203.05,1,92.56,1,92.56,-1295.61,import_aligned_detail_and_reconcile_to_existing_cash,matched_to_existing_aligned_cash_settlement
2025-08,14,3422.18,3041.56,380.62,2,701.89,2,701.89,-321.27,import_aligned_detail_and_reconcile_to_existing_cash,matched_to_existing_aligned_cash_settlement
2025-09,22,3544.28,2900.75,643.53,1,1055.00,1,1055.00,-411.47,import_aligned_detail_and_reconcile_to_existing_cash,matched_to_existing_aligned_cash_settlement
2025-10,17,3738.74,929.89,2808.85,1,2876.79,1,2876.79,-67.94,import_aligned_detail_and_reconcile_to_existing_cash,matched_to_existing_aligned_cash_settlement
2025-11,12,2791.97,1650.30,1141.67,3,252.88,1,1147.68,-6.01,import_aligned_detail_and_reconcile_to_existing_cash,matched_to_existing_aligned_cash_settlement
2025-12,15,4157.78,721.71,3436.07,3,1826.68,1,2114.58,1321.49,import_aligned_detail_and_reconcile_to_existing_cash,matched_to_existing_aligned_cash_settlement
2026-01,11,1473.63,778.81,694.82,5,-1226.26,0,0.00,694.82,import_aligned_detail_review_other_cash,manual_clearing_detail_with_other_assetrail_activity
2026-02,5,500.00,196.30,303.70,7,-8988.20,2,-14.66,318.36,import_aligned_detail_and_reconcile_to_existing_cash,matched_to_existing_aligned_cash_settlement
2026-03,0,0.00,0.00,0.00,6,4140.81,1,4990.18,-4990.18,import_aligned_detail_and_reconcile_to_existing_cash,matched_to_existing_aligned_cash_settlement
2026-04,2,495.00,143.70,351.30,5,753.26,1,1736.62,-1385.32,import_aligned_detail_and_reconcile_to_existing_cash,matched_to_existing_aligned_cash_settlement
2026-05,4,1794.93,49.50,1745.43,6,1158.39,1,2419.74,-674.31,import_aligned_detail_and_reconcile_to_existing_cash,matched_to_existing_aligned_cash_settlement
2026-06,0,0.00,0.00,0.00,1,1543.77,1,1543.77,-1543.77,import_aligned_detail_and_reconcile_to_existing_cash,matched_to_existing_aligned_cash_settlement