System
Unified timeline of data changes (saves, imports, deletes) and backend errors. Filter by type, area, severity, or search.
303,251 results · Page 5968 of 6066
[]
[]
{"bank_classification_rule_id":"31","rule_name":"MCDONALD → Dining","rule_scope":"global","bank_account_id":null,"match_field":"description","match_type":"contains","match_value":"MCDONALD","transaction_type":"Personal","report_category":"Dining","review_required":"0","priority":"25","is_active":"1","created_at":"2026-05-03 15:06:02","updated_at":"2026-05-03 15:06:02"}
[]
{"bank_transaction_id":"4504","legacy_id":null,"bank_import_batch_id":"10","bank_account_id":"1","transaction_uid":"hash:dd0d1a3c4224c75e74d797c2a02512eab7f9d8f8","transaction_date":"2026-03-27","description":"Tires Plus","original_description":"TIRES PLUS 520756 TAMPA FL","raw_category":"Service & Parts","category_name":"Service & Parts","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"Tires Plus","amount":"572.78","fees":"0.00","total_amount":"572.78","transaction_status":"Posted","tx_year":"2026","tx_month":"3","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 17:13:12","receipt_file_path":null,"receipt_original_name":null,"receipt_uploaded_at":null,"bank_information":"USAA","business_flag":"0","locked_flag":"0","reconciled_flag":"0","reconcile_notes":null,"raw_json":"{\"date\":\"2026-03-27\",\"description\":\"Tires Plus\",\"originaldescription\":\"TIRES PLUS 520756 TAMPA FL\",\"category\":\"Service & Parts\",\"amount\":\"572.78\",\"status\":\"Posted\"}","created_at":"2026-04-28 18:56:17","updated_at":"2026-05-02 17:13:12"}
{"bank_transaction_id":"4504","legacy_id":null,"bank_import_batch_id":"10","bank_account_id":"1","transaction_uid":"hash:dd0d1a3c4224c75e74d797c2a02512eab7f9d8f8","transaction_date":"2026-03-27","description":"Tires Plus","original_description":"TIRES PLUS 520756 TAMPA FL","raw_category":"Service & Parts","category_name":"Service & Parts","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"Tires Plus","amount":"572.78","fees":"0.00","total_amount":"572.78","transaction_status":"Posted","tx_year":"2026","tx_month":"3","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 17:13:12","receipt_file_path":"/tmp/customerdb/bank_receipts/tx_4504_20260503_150436_3e0f2367_Tires_Plus_Caravan_Invoice154074.pdf","receipt_original_name":"Tires Plus Caravan Invoice154074.Pdf","receipt_uploaded_at":"2026-05-03 15:04:36","bank_information":"USAA","business_flag":"0","locked_flag":"0","reconciled_flag":"0","reconcile_notes":null,"raw_json":"{\"date\":\"2026-03-27\",\"description\":\"Tires Plus\",\"originaldescription\":\"TIRES PLUS 520756 TAMPA FL\",\"category\":\"Service & Parts\",\"amount\":\"572.78\",\"status\":\"Posted\"}","created_at":"2026-04-28 18:56:17","updated_at":"2026-05-03 15:04:36"}
{"workflow_status":"drop_off","visit_id":129342,"order_id":104095}
[]
{"workflow_id":"18","source":"setmore","source_key":"30cf48a2-52ea-4568-bcf1-2bdb0f8d6d53","appointment_date":"2026-05-02","customer_id":"489065","visit_id":"129342","order_id":"104095","workflow_status":"drop_off","payment_state":"deposit","payment_method":"Credit","payment_amount":"99.99","paid_in_advance":"0","report_required":"1","report_attached":"0","report_checked_at":"2026-05-02 18:01:22","provider_notes_text":"[Workflow] Status: drop off | Payment State: deposit | Payment: Credit $99.99 | Paid In Advance: No | Report Required: Yes | Report Attached: No","operator_notes":null,"no_show_email_key":"none","created_at":"2026-05-02 18:01:22","updated_at":"2026-05-02 18:01:22","payment_breakdown_json":"[{\"method\":\"Credit\",\"amount\":99.99}]"}
{"workflow_status":"rescheduled","visit_id":129474,"order_id":106610}
[]
{"workflow_id":"17","source":"setmore","source_key":"d251d06c-de64-4686-951c-6760a3c7dec6","appointment_date":"2026-05-02","customer_id":"3514","visit_id":"129474","order_id":"106610","workflow_status":"rescheduled","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-02 18:00:19","provider_notes_text":"[Workflow] Status: rescheduled | Payment State: n/a | Payment: None | Paid In Advance: No | Report Required: No | Report Attached: No","operator_notes":null,"no_show_email_key":"none","created_at":"2026-05-02 18:00:19","updated_at":"2026-05-02 18:00:19","payment_breakdown_json":"[]"}
{"type":"mysqli_sql_exception","file":"/tmp/tmp_paydetail.php","line":6,"trace":"#0 /tmp/tmp_paydetail.php(6): mysqli->query()\n#1 {main}"}
{"type":"mysqli_sql_exception","file":"/tmp/tmp_audit3.php","line":5,"trace":"#0 /tmp/tmp_audit3.php(5): mysqli->query()\n#1 {main}"}
{"type":"mysqli_sql_exception","file":"/tmp/tmp_audit2.php","line":5,"trace":"#0 /tmp/tmp_audit2.php(5): mysqli->query()\n#1 {main}"}
{"type":"mysqli_sql_exception","file":"/tmp/tmp_direct_audit.php","line":11,"trace":"#0 /tmp/tmp_direct_audit.php(11): mysqli->query()\n#1 {main}"}
{"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"}