System
Unified timeline of data changes (saves, imports, deletes) and backend errors. Filter by type, area, severity, or search.
303,393 results · Page 5971 of 6068
{"action":"schedule_update_workflow","source":"setmore","source_key":"48acd131-1bb9-468d-9364-a44c25191e95","type":"Error","file":"/mnt/drive3/customerdb/backend/operations_service.php","line":601,"trace":"#0 /mnt/drive3/customerdb/backend/schedule.php(23): app_schedule_update_workflow()\n#1 /mnt/drive3/customerdb/webui/backend/schedule.php(5): require('...')\n#2 {main}"}
[]
{"bank_transaction_id":"4733","legacy_id":null,"bank_import_batch_id":"19","bank_account_id":"11","transaction_uid":"hash:70150c09a343752823ae1a59075cdb48719968aa","transaction_date":"2026-04-30","description":"SUNO INC.","original_description":null,"raw_category":"Merchandise","category_name":"Merchandise","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"SUNO INC.","amount":"96.00","fees":"0.00","total_amount":"96.00","transaction_status":null,"tx_year":"2026","tx_month":"4","transaction_type":"Needs Review","report_category":"Uncategorized","report_category_node_id":null,"review_status":"Needs Review","classification_rule_id":null,"classification_notes":null,"amazon_order_id":null,"amazon_match_method":null,"amazon_lookup_code":null,"classified_at":"2026-05-02 13:29:45","receipt_file_path":null,"receipt_original_name":null,"receipt_uploaded_at":null,"bank_information":"CapitalOne","business_flag":"0","locked_flag":"0","reconciled_flag":"0","reconcile_notes":null,"raw_json":"{\"transactiondate\":\"2026-04-30\",\"posteddate\":\"2026-05-01\",\"cardno\":\"0926\",\"description\":\"SUNO INC.\",\"category\":\"Merchandise\",\"debit\":\"96.00\",\"credit\":\"\"}","created_at":"2026-05-02 13:29:45","updated_at":"2026-05-02 13:29:45"}
{"bank_transaction_id":"4733","legacy_id":null,"bank_import_batch_id":"19","bank_account_id":"11","transaction_uid":"hash:70150c09a343752823ae1a59075cdb48719968aa","transaction_date":"2026-04-30","description":"SUNO INC.","original_description":null,"raw_category":"Merchandise","category_name":"Merchandise","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"SUNO INC.","amount":"96.00","fees":"0.00","total_amount":"96.00","transaction_status":null,"tx_year":"2026","tx_month":"4","transaction_type":"Needs Review","report_category":"Uncategorized","report_category_node_id":null,"review_status":"Needs Review","classification_rule_id":null,"classification_notes":null,"amazon_order_id":null,"amazon_match_method":null,"amazon_lookup_code":null,"classified_at":"2026-05-02 13:29:45","receipt_file_path":"/tmp/customerdb/bank_receipts/tx_4733_20260502_171219_78d2c9f3_Suno_-_Receipt-2617-3614-2169.pdf","receipt_original_name":"Suno - Receipt-2617-3614-2169.pdf","receipt_uploaded_at":"2026-05-02 17:12:19","bank_information":"CapitalOne","business_flag":"0","locked_flag":"0","reconciled_flag":"0","reconcile_notes":null,"raw_json":"{\"transactiondate\":\"2026-04-30\",\"posteddate\":\"2026-05-01\",\"cardno\":\"0926\",\"description\":\"SUNO INC.\",\"category\":\"Merchandise\",\"debit\":\"96.00\",\"credit\":\"\"}","created_at":"2026-05-02 13:29:45","updated_at":"2026-05-02 17:12:19"}
{"mode":"upload_receipt","type":"RuntimeException","file":"/mnt/drive3/customerdb/webui/backend/bank_service.php","line":224,"trace":"#0 /mnt/drive3/customerdb/webui/backend/bank_transactions.php(41): app_bank_upload_receipt()\n#1 {main}"}
{"file":"/mnt/drive3/customerdb/webui/backend/bank_service.php","line":223,"severity_code":2}
{"mode":"upload_receipt","type":"RuntimeException","file":"/mnt/drive3/customerdb/webui/backend/bank_service.php","line":224,"trace":"#0 /mnt/drive3/customerdb/webui/backend/bank_transactions.php(41): app_bank_upload_receipt()\n#1 {main}"}
{"file":"/mnt/drive3/customerdb/webui/backend/bank_service.php","line":223,"severity_code":2}
{"action":"import_csv","type":"RuntimeException","file":"/mnt/drive3/customerdb/backend/ambient_weather_service.php","line":135,"trace":"#0 /mnt/drive3/customerdb/backend/ambient_weather.php(26): app_ambient_weather_import_csv()\n#1 /mnt/drive3/customerdb/webui/backend/ambient_weather.php(5): require('...')\n#2 {main}"}
{"mode":"upload_receipt","type":"Error","file":"/mnt/drive3/customerdb/webui/backend/bank_transactions.php","line":41,"trace":"#0 {main}"}
{"rows_seen":38,"rows_imported":8,"rows_updated":30,"rows_skipped":0,"source_filename":"2026-05-02_transaction_download.csv"}
[]
{"bank_import_batch_id":"19","bank_account_id":"11","import_date":"2026-05-02","start_date":"2026-03-02","end_date":null,"sort_name":null,"import_notes":null,"source_filename":"2026-05-02_transaction_download.csv","import_status":"imported","rows_seen":"38","rows_imported":"8","rows_updated":"30","rows_skipped":"0","created_at":"2026-05-02 13:29:45","updated_at":"2026-05-02 13:29:45"}
{"action":"schedule_update_workflow","source":"setmore","source_key":"35776c34-4908-4575-9077-b607bfdcdf3a","type":"mysqli_sql_exception","file":"/mnt/drive3/customerdb/backend/operations_service.php","line":582,"trace":"#0 /mnt/drive3/customerdb/backend/operations_service.php(582): mysqli->query()\n#1 /mnt/drive3/customerdb/backend/schedule.php(23): app_schedule_update_workflow()\n#2 /mnt/drive3/customerdb/webui/backend/schedule.php(5): require('...')\n#3 {main}"}
{"action":"schedule_update_workflow","source":"setmore","source_key":"35776c34-4908-4575-9077-b607bfdcdf3a","type":"mysqli_sql_exception","file":"/mnt/drive3/customerdb/backend/operations_service.php","line":582,"trace":"#0 /mnt/drive3/customerdb/backend/operations_service.php(582): mysqli->query()\n#1 /mnt/drive3/customerdb/backend/schedule.php(23): app_schedule_update_workflow()\n#2 /mnt/drive3/customerdb/webui/backend/schedule.php(5): require('...')\n#3 {main}"}
{"action":"schedule_update_workflow","source":"setmore","source_key":"35776c34-4908-4575-9077-b607bfdcdf3a","type":"mysqli_sql_exception","file":"/mnt/drive3/customerdb/backend/operations_service.php","line":518,"trace":"#0 /mnt/drive3/customerdb/backend/operations_service.php(518): mysqli->query()\n#1 /mnt/drive3/customerdb/backend/schedule.php(23): app_schedule_update_workflow()\n#2 /mnt/drive3/customerdb/webui/backend/schedule.php(5): require('...')\n#3 {main}"}
{"workflow_status":"drop_off","visit_id":129468,"order_id":106604}
[]
{"workflow_id":"15","source":"setmore","source_key":"f8c81391-ede5-4574-a54d-733b389ca1e1","appointment_date":"2026-05-01","customer_id":"495275","visit_id":"129468","order_id":"106604","workflow_status":"drop_off","payment_state":null,"payment_method":null,"payment_amount":"0.00","paid_in_advance":"0","report_required":"1","report_attached":"1","report_checked_at":"2026-05-01 20:54:10","provider_notes_text":null,"operator_notes":null,"no_show_email_key":"none","created_at":"2026-05-01 20:54:10","updated_at":"2026-05-01 20:54:10","payment_breakdown_json":"[]"}
{"workflow_status":"no_show","visit_id":129467,"order_id":106603}
[]
{"workflow_id":"14","source":"visit","source_key":"129467","appointment_date":"2026-05-01","customer_id":"495274","visit_id":"129467","order_id":null,"workflow_status":"no_show","payment_state":null,"payment_method":null,"payment_amount":"0.00","paid_in_advance":"0","report_required":"0","report_attached":"0","report_checked_at":"2026-05-01 20:36:19","provider_notes_text":null,"operator_notes":"{\"Project Details\":\"Getting a prom dress shortened\",\"When Needed?\":\"Needed by may 9th for prom\"}","no_show_email_key":"none","created_at":"2026-05-01 20:36:19","updated_at":"2026-05-01 20:36:19","payment_breakdown_json":"[]"}
{"workflow_status":"scheduled","visit_id":129479,"order_id":106615}
[]
{"workflow_id":"13","source":"setmore","source_key":"35776c34-4908-4575-9077-b607bfdcdf3a","appointment_date":"2026-05-01","customer_id":"847","visit_id":"129479","order_id":"106615","workflow_status":"scheduled","payment_state":null,"payment_method":null,"payment_amount":"0.00","paid_in_advance":"0","report_required":"1","report_attached":"1","report_checked_at":"2026-05-01 20:33:21","provider_notes_text":null,"operator_notes":null,"no_show_email_key":"none","created_at":"2026-05-01 20:33:21","updated_at":"2026-05-01 20:33:21","payment_breakdown_json":"[]"}
{"action":"schedule_update_workflow","source":"setmore","source_key":"35776c34-4908-4575-9077-b607bfdcdf3a","type":"mysqli_sql_exception","file":"/mnt/drive3/customerdb/backend/operations_service.php","line":518,"trace":"#0 /mnt/drive3/customerdb/backend/operations_service.php(518): mysqli->query()\n#1 /mnt/drive3/customerdb/backend/schedule.php(23): app_schedule_update_workflow()\n#2 /mnt/drive3/customerdb/webui/backend/schedule.php(5): require('...')\n#3 {main}"}
[]
[]
{"customer_id":489061,"visit_id":129328,"email":"regiazuly2597@gmail.com","status":"sent","delivery_result":"Sent via SMTP (PHPMailer)"}
[]
[]
{"customer_id":3390,"visit_id":129357,"email":"lynziesmith2010@icloud.com","status":"sent","delivery_result":"Sent via SMTP (PHPMailer)"}
[]
[]
{"customer_id":3483,"visit_id":129359,"email":"nfridy@gmail.com","status":"sent","delivery_result":"Sent via SMTP (PHPMailer)"}
[]
[]
{"customer_id":3193,"visit_id":129051,"email":"teelkim@aol.com","status":"sent","delivery_result":"Sent via SMTP (PHPMailer)"}
[]
[]
{"customer_id":429498,"visit_id":110275,"email":"dtsrichter@earthlink.net","status":"sent","delivery_result":"Sent via SMTP (PHPMailer)"}
[]
[]
{"customer_id":429509,"visit_id":129327,"email":"chloempaquette@gmail.com","status":"sent","delivery_result":"Sent via SMTP (PHPMailer)"}
[]
[]
{"customer_id":2573,"visit_id":129053,"email":"carriejoy3521@gmail.com","status":"sent","delivery_result":"Sent via SMTP (PHPMailer)"}
[]
[]
{"customer_id":489088,"visit_id":129415,"email":"kamatamabhinav@gmail.com","status":"sent","delivery_result":"Sent via SMTP (PHPMailer)"}
[]
{"daily_customer_totals_id":"5699","legacy_id":null,"customer_date":"2026-04-17 00:00:00","total_customers":"13.00","new_customers":"5.00","cash_sales":"30.25","edwards":"0.00","check_sales":"0.00","credit_card_sales":"278.08","total_sales":"323.08","total_sales_no_edwards":"323.08","dopu_can":null,"customer_name":null,"update_flag":null,"receipts":null,"skyler_worked":"0","skyler_pay":"0.00","ella_pay":"0.00","email":null,"lola":null,"created_at":"2026-04-27 15:30:07","edwards_type":null,"tips":"14.75"}
{"daily_customer_totals_id":"5699","legacy_id":null,"customer_date":"2026-04-17 00:00:00","total_customers":"13.00","new_customers":"5.00","cash_sales":"80.25","edwards":"0.00","check_sales":"0.00","credit_card_sales":"637.72","total_sales":"716.97","total_sales_no_edwards":"717.97","dopu_can":null,"customer_name":null,"update_flag":null,"receipts":null,"skyler_worked":"0","skyler_pay":"0.00","ella_pay":"0.00","email":null,"lola":null,"created_at":"2026-04-27 15:30:00","edwards_type":null,"tips":"14.75"}
[]
{"daily_customer_totals_id":"5725","legacy_id":null,"customer_date":"2026-04-27 00:00:00","total_customers":"8.00","new_customers":"7.00","cash_sales":"0.00","edwards":"0.00","check_sales":"0.00","credit_card_sales":"123.05","total_sales":"123.05","total_sales_no_edwards":"123.05","dopu_can":null,"customer_name":null,"update_flag":null,"receipts":null,"skyler_worked":"0","skyler_pay":"0.00","ella_pay":"0.00","email":null,"lola":null,"created_at":"2026-04-30 14:00:45","edwards_type":null,"tips":"0.00"}
{"daily_customer_totals_id":"5725","legacy_id":null,"customer_date":"2026-04-27 00:00:00","total_customers":"8.00","new_customers":"7.00","cash_sales":"0.00","edwards":"150.00","check_sales":"0.00","credit_card_sales":"123.05","total_sales":"273.05","total_sales_no_edwards":"123.05","dopu_can":null,"customer_name":null,"update_flag":null,"receipts":null,"skyler_worked":"0","skyler_pay":"0.00","ella_pay":"0.00","email":null,"lola":null,"created_at":"2026-04-30 14:00:00","edwards_type":null,"tips":"0.00"}
[]
{"customer_totals_id":"20362","legacy_id":null,"customer_date":"2026-04-29 13:36:00","total_customers":"1.00","new_customers":"1.00","cash_sales":"0.00","edwards":"150.00","check_sales":"0.00","credit_card_sales":"0.00","total_sales":"0.00","total_sales_no_edwards":"0.00","dopu_can":"Pick Up","customer_name":"Edwards Pick Up","update_flag":null,"receipts":null,"skyler_worked":"0","skyler_pay":"0.00","ella_pay":"0.00","email":"","lola":null,"created_at":"2026-04-30 13:37:31","edwards_type":null,"tips":"0.00","visit_id":null,"order_id":null,"customer_id":null}
{"customer_totals_id":"20362","legacy_id":null,"customer_date":"2026-04-27 13:36:00","total_customers":"1.00","new_customers":"1.00","cash_sales":"0.00","edwards":"150.00","check_sales":"0.00","credit_card_sales":"0.00","total_sales":"0.00","total_sales_no_edwards":"0.00","dopu_can":"Pick Up","customer_name":"Edwards Pick Up","update_flag":null,"receipts":null,"skyler_worked":"0","skyler_pay":"0.00","ella_pay":"0.00","email":null,"lola":null,"created_at":"2026-04-30 13:37:00","edwards_type":null,"tips":"0.00","visit_id":null,"order_id":null,"customer_id":null}
{"table":"daily_customer_totals","type":"mysqli_sql_exception","file":"/mnt/drive3/customerdb/backend/live_table_manager_service.php","line":212,"trace":"#0 /mnt/drive3/customerdb/backend/live_table_manager_service.php(212): mysqli->query()\n#1 /mnt/drive3/customerdb/backend/live_table_manager.php(33): app_live_table_save()\n#2 /mnt/drive3/customerdb/webui/backend/live_table_manager.php(5): require('...')\n#3 {main}"}
[]
[]
{"customer_date":"2026-04-29 13:36:00","customer_name":"Edwards Pick Up","dopu_can":"Pick Up","edwards":150}
{"type":"mysqli_sql_exception","file":"C:\\code\\customerdb\\tmp_hockerty_scan.php","line":29,"trace":"#0 C:\\code\\customerdb\\tmp_hockerty_scan.php(29): mysqli->query('SELECT vhi.visi...')\n#1 {main}"}
{"mode":"import_zip","type":"RuntimeException","file":"/mnt/drive3/customerdb/webui/backend/bank_amazon_import.php","line":22,"trace":"#0 {main}"}
{"mode":"import_zip","type":"RuntimeException","file":"/mnt/drive3/customerdb/webui/backend/bank_amazon_import.php","line":24,"trace":"#0 {main}"}
{"mode":"import_zip","type":"RuntimeException","file":"/mnt/drive3/customerdb/webui/backend/bank_amazon_import.php","line":24,"trace":"#0 {main}"}
{"mode":"import_zip","type":"RuntimeException","file":"/mnt/drive3/customerdb/webui/backend/bank_amazon_import.php","line":24,"trace":"#0 {main}"}
[]
{"bank_transaction_id":"4389","legacy_id":null,"bank_import_batch_id":"5","bank_account_id":"11","transaction_uid":"hash:a285d49b5be95b5d6d7da57a7e757faad781d5d2","transaction_date":"2026-04-04","description":"HOBBY-LOBBY #567","original_description":null,"raw_category":"Merchandise","category_name":"Merchandise","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"HOBBY-LOBBY #567","amount":"3.83","fees":"0.00","total_amount":"3.83","transaction_status":null,"tx_year":"2026","tx_month":"4","transaction_type":"Needs Review","report_category":"Uncategorized","report_category_node_id":null,"review_status":"Needs Review","classification_rule_id":null,"classification_notes":null,"classified_at":"2026-04-29 14:37:31","bank_information":"CapitalOne","business_flag":"0","locked_flag":"0","reconciled_flag":"0","reconcile_notes":null,"raw_json":"{\"transactiondate\":\"2026-04-04\",\"posteddate\":\"2026-04-06\",\"cardno\":\"0926\",\"description\":\"HOBBY-LOBBY #567\",\"category\":\"Merchandise\",\"debit\":\"3.83\",\"credit\":\"\"}","created_at":"2026-04-28 18:42:33","updated_at":"2026-04-29 14:37:31"}
{"bank_transaction_id":"4389","legacy_id":null,"bank_import_batch_id":"5","bank_account_id":"11","transaction_uid":"hash:a285d49b5be95b5d6d7da57a7e757faad781d5d2","transaction_date":"2026-04-04","description":"HOBBY-LOBBY #567","original_description":null,"raw_category":"Merchandise","category_name":"Merchandise","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"HOBBY-LOBBY #567","amount":"3.83","fees":"0.00","total_amount":"3.83","transaction_status":null,"tx_year":"2026","tx_month":"4","transaction_type":"Business","report_category":"Supplies","report_category_node_id":"21","review_status":"Approved","classification_rule_id":null,"classification_notes":null,"classified_at":"2026-04-29 14:50:25","bank_information":"CapitalOne","business_flag":"1","locked_flag":"0","reconciled_flag":"0","reconcile_notes":null,"raw_json":"{\"transactiondate\":\"2026-04-04\",\"posteddate\":\"2026-04-06\",\"cardno\":\"0926\",\"description\":\"HOBBY-LOBBY #567\",\"category\":\"Merchandise\",\"debit\":\"3.83\",\"credit\":\"\"}","created_at":"2026-04-28 18:42:33","updated_at":"2026-04-29 14:50:25"}
[]
[]
{"bank_classification_rule_id":"30","rule_name":"HOBBY → Supplies","rule_scope":"global","bank_account_id":null,"match_field":"description","match_type":"contains","match_value":"HOBBY","transaction_type":"Business","report_category":"Supplies","review_required":"0","priority":"25","is_active":"1","created_at":"2026-04-29 14:50:25","updated_at":"2026-04-29 14:50:25"}
[]
{"bank_transaction_id":"4379","legacy_id":null,"bank_import_batch_id":"5","bank_account_id":"11","transaction_uid":"hash:ca2884176f9d2dec32104ce0f8cb5108ac582021","transaction_date":"2026-04-11","description":"CLAUDE.AI SUBSCRIPTION","original_description":null,"raw_category":"Merchandise","category_name":"Merchandise","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"CLAUDE.AI SUBSCRIPTION","amount":"20.00","fees":"0.00","total_amount":"20.00","transaction_status":null,"tx_year":"2026","tx_month":"4","transaction_type":"Needs Review","report_category":"Uncategorized","report_category_node_id":null,"review_status":"Needs Review","classification_rule_id":null,"classification_notes":null,"classified_at":"2026-04-29 14:37:31","bank_information":"CapitalOne","business_flag":"0","locked_flag":"0","reconciled_flag":"0","reconcile_notes":null,"raw_json":"{\"transactiondate\":\"2026-04-11\",\"posteddate\":\"2026-04-13\",\"cardno\":\"0926\",\"description\":\"CLAUDE.AI SUBSCRIPTION\",\"category\":\"Merchandise\",\"debit\":\"20.00\",\"credit\":\"\"}","created_at":"2026-04-28 18:42:33","updated_at":"2026-04-29 14:37:31"}
{"bank_transaction_id":"4379","legacy_id":null,"bank_import_batch_id":"5","bank_account_id":"11","transaction_uid":"hash:ca2884176f9d2dec32104ce0f8cb5108ac582021","transaction_date":"2026-04-11","description":"CLAUDE.AI SUBSCRIPTION","original_description":null,"raw_category":"Merchandise","category_name":"Merchandise","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"CLAUDE.AI SUBSCRIPTION","amount":"20.00","fees":"0.00","total_amount":"20.00","transaction_status":null,"tx_year":"2026","tx_month":"4","transaction_type":"Business","report_category":"Web","report_category_node_id":"38","review_status":"Approved","classification_rule_id":null,"classification_notes":null,"classified_at":"2026-04-29 14:49:43","bank_information":"CapitalOne","business_flag":"1","locked_flag":"0","reconciled_flag":"0","reconcile_notes":null,"raw_json":"{\"transactiondate\":\"2026-04-11\",\"posteddate\":\"2026-04-13\",\"cardno\":\"0926\",\"description\":\"CLAUDE.AI SUBSCRIPTION\",\"category\":\"Merchandise\",\"debit\":\"20.00\",\"credit\":\"\"}","created_at":"2026-04-28 18:42:33","updated_at":"2026-04-29 14:49:43"}
[]
[]
{"bank_classification_rule_id":"29","rule_name":"CLAUDE → Web","rule_scope":"global","bank_account_id":null,"match_field":"description","match_type":"contains","match_value":"CLAUDE","transaction_type":"Business","report_category":"Web","review_required":"0","priority":"25","is_active":"1","created_at":"2026-04-29 14:49:43","updated_at":"2026-04-29 14:49:43"}
[]
{"bank_transaction_id":"4384","legacy_id":null,"bank_import_batch_id":"5","bank_account_id":"11","transaction_uid":"hash:7f2ccb7122e24e03b8fc55bfe8600ed28fac9533","transaction_date":"2026-04-08","description":"FRONTIER COMM CORP WEB","original_description":null,"raw_category":"Phone/Cable","category_name":"Phone/Cable","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"FRONTIER COMM","amount":"114.99","fees":"0.00","total_amount":"114.99","transaction_status":null,"tx_year":"2026","tx_month":"4","transaction_type":"Needs Review","report_category":"Uncategorized","report_category_node_id":null,"review_status":"Needs Review","classification_rule_id":null,"classification_notes":null,"classified_at":"2026-04-29 14:37:31","bank_information":"CapitalOne","business_flag":"0","locked_flag":"0","reconciled_flag":"0","reconcile_notes":null,"raw_json":"{\"transactiondate\":\"2026-04-08\",\"posteddate\":\"2026-04-09\",\"cardno\":\"0926\",\"description\":\"FRONTIER COMM CORP WEB\",\"category\":\"Phone/Cable\",\"debit\":\"114.99\",\"credit\":\"\"}","created_at":"2026-04-28 18:42:33","updated_at":"2026-04-29 14:37:31"}
{"bank_transaction_id":"4384","legacy_id":null,"bank_import_batch_id":"5","bank_account_id":"11","transaction_uid":"hash:7f2ccb7122e24e03b8fc55bfe8600ed28fac9533","transaction_date":"2026-04-08","description":"FRONTIER COMM CORP WEB","original_description":null,"raw_category":"Phone/Cable","category_name":"Phone/Cable","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"FRONTIER COMM","amount":"114.99","fees":"0.00","total_amount":"114.99","transaction_status":null,"tx_year":"2026","tx_month":"4","transaction_type":"Personal","report_category":"Internet","report_category_node_id":"44","review_status":"Approved","classification_rule_id":null,"classification_notes":null,"classified_at":"2026-04-29 14:49:25","bank_information":"CapitalOne","business_flag":"0","locked_flag":"0","reconciled_flag":"0","reconcile_notes":null,"raw_json":"{\"transactiondate\":\"2026-04-08\",\"posteddate\":\"2026-04-09\",\"cardno\":\"0926\",\"description\":\"FRONTIER COMM CORP WEB\",\"category\":\"Phone/Cable\",\"debit\":\"114.99\",\"credit\":\"\"}","created_at":"2026-04-28 18:42:33","updated_at":"2026-04-29 14:49:25"}
[]
[]
{"bank_classification_rule_id":"28","rule_name":"FRONTIER → Internet","rule_scope":"global","bank_account_id":null,"match_field":"description","match_type":"contains","match_value":"FRONTIER","transaction_type":"Personal","report_category":"Internet","review_required":"0","priority":"25","is_active":"1","created_at":"2026-04-29 14:49:25","updated_at":"2026-04-29 14:49:25"}
[]
{"bank_transaction_id":"4383","legacy_id":null,"bank_import_batch_id":"5","bank_account_id":"11","transaction_uid":"hash:fb32356123e45f12cfd0836a428c800ea129e66f","transaction_date":"2026-04-09","description":"SQ *ELLA'S ALTERATIONS","original_description":null,"raw_category":"Other Services","category_name":"Other Services","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"SQ *ELLA'S","amount":"5.20","fees":"0.00","total_amount":"5.20","transaction_status":null,"tx_year":"2026","tx_month":"4","transaction_type":"Needs Review","report_category":"Uncategorized","report_category_node_id":null,"review_status":"Needs Review","classification_rule_id":null,"classification_notes":null,"classified_at":"2026-04-29 14:37:31","bank_information":"CapitalOne","business_flag":"0","locked_flag":"0","reconciled_flag":"0","reconcile_notes":null,"raw_json":"{\"transactiondate\":\"2026-04-09\",\"posteddate\":\"2026-04-10\",\"cardno\":\"0926\",\"description\":\"SQ *ELLA'S ALTERATIONS\",\"category\":\"Other Services\",\"debit\":\"5.20\",\"credit\":\"\"}","created_at":"2026-04-28 18:42:33","updated_at":"2026-04-29 14:37:31"}
{"bank_transaction_id":"4383","legacy_id":null,"bank_import_batch_id":"5","bank_account_id":"11","transaction_uid":"hash:fb32356123e45f12cfd0836a428c800ea129e66f","transaction_date":"2026-04-09","description":"SQ *ELLA'S ALTERATIONS","original_description":null,"raw_category":"Other Services","category_name":"Other Services","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"SQ *ELLA'S","amount":"5.20","fees":"0.00","total_amount":"5.20","transaction_status":null,"tx_year":"2026","tx_month":"4","transaction_type":"Business","report_category":"Income","report_category_node_id":"3","review_status":"Approved","classification_rule_id":null,"classification_notes":null,"classified_at":"2026-04-29 14:49:00","bank_information":"CapitalOne","business_flag":"1","locked_flag":"0","reconciled_flag":"0","reconcile_notes":null,"raw_json":"{\"transactiondate\":\"2026-04-09\",\"posteddate\":\"2026-04-10\",\"cardno\":\"0926\",\"description\":\"SQ *ELLA'S ALTERATIONS\",\"category\":\"Other Services\",\"debit\":\"5.20\",\"credit\":\"\"}","created_at":"2026-04-28 18:42:33","updated_at":"2026-04-29 14:49:00"}
[]
[]
{"bank_classification_rule_id":"27","rule_name":"SQ *ELLA'S ALTERATIONS → Income","rule_scope":"global","bank_account_id":null,"match_field":"description","match_type":"contains","match_value":"SQ *ELLA'S ALTERATIONS","transaction_type":"Business","report_category":"Income","review_required":"0","priority":"25","is_active":"1","created_at":"2026-04-29 14:49:00","updated_at":"2026-04-29 14:49:00"}
[]
{"bank_transaction_id":"4378","legacy_id":null,"bank_import_batch_id":"5","bank_account_id":"11","transaction_uid":"hash:3df597440d8b9b21b44840139949525735694811","transaction_date":"2026-04-12","description":"OPENAI *CHATGPT SUBSCR","original_description":null,"raw_category":"Merchandise","category_name":"Merchandise","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"OPENAI *CHATGPT","amount":"86.76","fees":"0.00","total_amount":"86.76","transaction_status":null,"tx_year":"2026","tx_month":"4","transaction_type":"Needs Review","report_category":"Uncategorized","report_category_node_id":null,"review_status":"Needs Review","classification_rule_id":null,"classification_notes":null,"classified_at":"2026-04-29 14:37:31","bank_information":"CapitalOne","business_flag":"0","locked_flag":"0","reconciled_flag":"0","reconcile_notes":null,"raw_json":"{\"transactiondate\":\"2026-04-12\",\"posteddate\":\"2026-04-13\",\"cardno\":\"0926\",\"description\":\"OPENAI *CHATGPT SUBSCR\",\"category\":\"Merchandise\",\"debit\":\"86.76\",\"credit\":\"\"}","created_at":"2026-04-28 18:42:33","updated_at":"2026-04-29 14:37:31"}
{"bank_transaction_id":"4378","legacy_id":null,"bank_import_batch_id":"5","bank_account_id":"11","transaction_uid":"hash:3df597440d8b9b21b44840139949525735694811","transaction_date":"2026-04-12","description":"OPENAI *CHATGPT SUBSCR","original_description":null,"raw_category":"Merchandise","category_name":"Merchandise","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"OPENAI *CHATGPT","amount":"86.76","fees":"0.00","total_amount":"86.76","transaction_status":null,"tx_year":"2026","tx_month":"4","transaction_type":"Business","report_category":"Web","report_category_node_id":"38","review_status":"Approved","classification_rule_id":null,"classification_notes":null,"classified_at":"2026-04-29 14:48:29","bank_information":"CapitalOne","business_flag":"1","locked_flag":"0","reconciled_flag":"0","reconcile_notes":null,"raw_json":"{\"transactiondate\":\"2026-04-12\",\"posteddate\":\"2026-04-13\",\"cardno\":\"0926\",\"description\":\"OPENAI *CHATGPT SUBSCR\",\"category\":\"Merchandise\",\"debit\":\"86.76\",\"credit\":\"\"}","created_at":"2026-04-28 18:42:33","updated_at":"2026-04-29 14:48:29"}
[]
[]
{"bank_classification_rule_id":"26","rule_name":"OPENAI → Web","rule_scope":"global","bank_account_id":null,"match_field":"description","match_type":"contains","match_value":"OPENAI","transaction_type":"Business","report_category":"Web","review_required":"0","priority":"25","is_active":"1","created_at":"2026-04-29 14:48:29","updated_at":"2026-04-29 14:48:29"}
[]
{"bank_transaction_id":"4377","legacy_id":null,"bank_import_batch_id":"5","bank_account_id":"11","transaction_uid":"hash:3b97bf51c68030660c330dd8542f39ed541df8ea","transaction_date":"2026-04-14","description":"McDonalds 3475","original_description":null,"raw_category":"Dining","category_name":"Dining","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"McDonalds 3475","amount":"15.04","fees":"0.00","total_amount":"15.04","transaction_status":null,"tx_year":"2026","tx_month":"4","transaction_type":"Needs Review","report_category":"Uncategorized","report_category_node_id":null,"review_status":"Needs Review","classification_rule_id":null,"classification_notes":null,"classified_at":"2026-04-29 14:37:31","bank_information":"CapitalOne","business_flag":"0","locked_flag":"0","reconciled_flag":"0","reconcile_notes":null,"raw_json":"{\"transactiondate\":\"2026-04-14\",\"posteddate\":\"2026-04-15\",\"cardno\":\"0926\",\"description\":\"McDonalds 3475\",\"category\":\"Dining\",\"debit\":\"15.04\",\"credit\":\"\"}","created_at":"2026-04-28 18:42:33","updated_at":"2026-04-29 14:37:31"}
{"bank_transaction_id":"4377","legacy_id":null,"bank_import_batch_id":"5","bank_account_id":"11","transaction_uid":"hash:3b97bf51c68030660c330dd8542f39ed541df8ea","transaction_date":"2026-04-14","description":"McDonalds 3475","original_description":null,"raw_category":"Dining","category_name":"Dining","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"McDonalds 3475","amount":"15.04","fees":"0.00","total_amount":"15.04","transaction_status":null,"tx_year":"2026","tx_month":"4","transaction_type":"Personal","report_category":"Dining","report_category_node_id":"15","review_status":"Approved","classification_rule_id":null,"classification_notes":null,"classified_at":"2026-04-29 14:48:05","bank_information":"CapitalOne","business_flag":"0","locked_flag":"0","reconciled_flag":"0","reconcile_notes":null,"raw_json":"{\"transactiondate\":\"2026-04-14\",\"posteddate\":\"2026-04-15\",\"cardno\":\"0926\",\"description\":\"McDonalds 3475\",\"category\":\"Dining\",\"debit\":\"15.04\",\"credit\":\"\"}","created_at":"2026-04-28 18:42:33","updated_at":"2026-04-29 14:48:05"}
[]
[]
{"bank_classification_rule_id":"25","rule_name":"MCDONALDS → Dining","rule_scope":"global","bank_account_id":null,"match_field":"description","match_type":"contains","match_value":"MCDONALDS","transaction_type":"Personal","report_category":"Dining","review_required":"0","priority":"25","is_active":"1","created_at":"2026-04-29 14:48:05","updated_at":"2026-04-29 14:48:05"}
[]
{"bank_transaction_id":"4490","legacy_id":null,"bank_import_batch_id":"10","bank_account_id":"1","transaction_uid":"hash:9ab719fbdfc0abf93fb5ed0527b8e2f6a215cc89","transaction_date":"2026-04-14","description":"Ross Dress for Less","original_description":"ROSS STORES #1612 ZEPHYRHILLS FL","raw_category":"Shopping","category_name":"Shopping","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"Ross Dress","amount":"89.18","fees":"0.00","total_amount":"89.18","transaction_status":"Posted","tx_year":"2026","tx_month":"4","transaction_type":"Needs Review","report_category":"Uncategorized","report_category_node_id":null,"review_status":"Needs Review","classification_rule_id":null,"classification_notes":null,"classified_at":"2026-04-29 14:37:31","bank_information":"USAA","business_flag":"0","locked_flag":"0","reconciled_flag":"0","reconcile_notes":null,"raw_json":"{\"date\":\"2026-04-14\",\"description\":\"Ross Dress for Less\",\"originaldescription\":\"ROSS STORES #1612 ZEPHYRHILLS FL\",\"category\":\"Shopping\",\"amount\":\"89.18\",\"status\":\"Posted\"}","created_at":"2026-04-28 18:56:17","updated_at":"2026-04-29 14:37:31"}
{"bank_transaction_id":"4490","legacy_id":null,"bank_import_batch_id":"10","bank_account_id":"1","transaction_uid":"hash:9ab719fbdfc0abf93fb5ed0527b8e2f6a215cc89","transaction_date":"2026-04-14","description":"Ross Dress for Less","original_description":"ROSS STORES #1612 ZEPHYRHILLS FL","raw_category":"Shopping","category_name":"Shopping","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"Ross Dress","amount":"89.18","fees":"0.00","total_amount":"89.18","transaction_status":"Posted","tx_year":"2026","tx_month":"4","transaction_type":"Personal","report_category":"Other","report_category_node_id":"18","review_status":"Approved","classification_rule_id":null,"classification_notes":null,"classified_at":"2026-04-29 14:47:43","bank_information":"USAA","business_flag":"0","locked_flag":"0","reconciled_flag":"0","reconcile_notes":null,"raw_json":"{\"date\":\"2026-04-14\",\"description\":\"Ross Dress for Less\",\"originaldescription\":\"ROSS STORES #1612 ZEPHYRHILLS FL\",\"category\":\"Shopping\",\"amount\":\"89.18\",\"status\":\"Posted\"}","created_at":"2026-04-28 18:56:17","updated_at":"2026-04-29 14:47:43"}
[]
[]
{"bank_classification_rule_id":"24","rule_name":"ROSS → Other","rule_scope":"global","bank_account_id":null,"match_field":"description","match_type":"contains","match_value":"ROSS","transaction_type":"Personal","report_category":"Other","review_required":"0","priority":"25","is_active":"1","created_at":"2026-04-29 14:47:43","updated_at":"2026-04-29 14:47:43"}
[]
{"bank_transaction_id":"4491","legacy_id":null,"bank_import_batch_id":"10","bank_account_id":"1","transaction_uid":"hash:7421910bd528adc5293fd35bea19c7056f244f17","transaction_date":"2026-04-14","description":"Save A Lot","original_description":"SAVE A LOT 30031 ZEPHYRHILLS FL","raw_category":"Groceries","category_name":"Groceries","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"Save A","amount":"36.98","fees":"0.00","total_amount":"36.98","transaction_status":"Posted","tx_year":"2026","tx_month":"4","transaction_type":"Needs Review","report_category":"Uncategorized","report_category_node_id":null,"review_status":"Needs Review","classification_rule_id":null,"classification_notes":null,"classified_at":"2026-04-29 14:37:31","bank_information":"USAA","business_flag":"0","locked_flag":"0","reconciled_flag":"0","reconcile_notes":null,"raw_json":"{\"date\":\"2026-04-14\",\"description\":\"Save A Lot\",\"originaldescription\":\"SAVE A LOT 30031 ZEPHYRHILLS FL\",\"category\":\"Groceries\",\"amount\":\"36.98\",\"status\":\"Posted\"}","created_at":"2026-04-28 18:56:17","updated_at":"2026-04-29 14:37:31"}
{"bank_transaction_id":"4491","legacy_id":null,"bank_import_batch_id":"10","bank_account_id":"1","transaction_uid":"hash:7421910bd528adc5293fd35bea19c7056f244f17","transaction_date":"2026-04-14","description":"Save A Lot","original_description":"SAVE A LOT 30031 ZEPHYRHILLS FL","raw_category":"Groceries","category_name":"Groceries","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"Save A","amount":"36.98","fees":"0.00","total_amount":"36.98","transaction_status":"Posted","tx_year":"2026","tx_month":"4","transaction_type":"Personal","report_category":"Groceries","report_category_node_id":"14","review_status":"Approved","classification_rule_id":null,"classification_notes":null,"classified_at":"2026-04-29 14:47:15","bank_information":"USAA","business_flag":"0","locked_flag":"0","reconciled_flag":"0","reconcile_notes":null,"raw_json":"{\"date\":\"2026-04-14\",\"description\":\"Save A Lot\",\"originaldescription\":\"SAVE A LOT 30031 ZEPHYRHILLS FL\",\"category\":\"Groceries\",\"amount\":\"36.98\",\"status\":\"Posted\"}","created_at":"2026-04-28 18:56:17","updated_at":"2026-04-29 14:47:15"}
[]
[]
{"bank_classification_rule_id":"23","rule_name":"SAVE A LOT → Groceries","rule_scope":"global","bank_account_id":null,"match_field":"description","match_type":"contains","match_value":"SAVE A LOT","transaction_type":"Personal","report_category":"Groceries","review_required":"0","priority":"25","is_active":"1","created_at":"2026-04-29 14:47:15","updated_at":"2026-04-29 14:47:15"}