System
Unified timeline of data changes (saves, imports, deletes) and backend errors. Filter by type, area, severity, or search.
271,984 results · Page 5342 of 5440
[]
{"bank_transaction_id":"145","legacy_id":"836861","bank_import_batch_id":"2","bank_account_id":"11","transaction_uid":"legacy:836861","transaction_date":"2026-02-14","description":"WP MEDIA","original_description":"WP MEDIA","raw_category":"Internet","category_name":"Internet","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"WP MEDIA","amount":"-48.00","fees":"0.00","total_amount":"-48.00","transaction_status":"Debit","tx_year":"2026","tx_month":"2","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-03 15:23:27","receipt_file_path":null,"receipt_original_name":null,"receipt_uploaded_at":null,"bank_information":"CapitalOne Credit Card","business_flag":"0","locked_flag":"0","reconciled_flag":"0","reconcile_notes":null,"raw_json":"{\"id\":\"836861\",\"date\":\"2026-02-14\",\"description\":\"WP MEDIA\",\"originaldescription\":\"WP MEDIA\",\"category\":\"Internet\",\"amount\":\"-48\",\"status\":\"Debit\",\"bankinformation\":\"CapitalOne Credit Card\",\"fees\":\"0\"}","created_at":"2026-04-28 17:55:13","updated_at":"2026-05-03 15:23:27"}
{"bank_transaction_id":"145","legacy_id":"836861","bank_import_batch_id":"2","bank_account_id":"11","transaction_uid":"legacy:836861","transaction_date":"2026-02-14","description":"WP MEDIA","original_description":"WP MEDIA","raw_category":"Internet","category_name":"Internet","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"WP MEDIA","amount":"-48.00","fees":"0.00","total_amount":"-48.00","transaction_status":"Debit","tx_year":"2026","tx_month":"2","transaction_type":"Business","report_category":"Software","report_category_node_id":"24","review_status":"Approved","classification_rule_id":null,"classification_notes":null,"amazon_order_id":null,"amazon_match_method":null,"amazon_lookup_code":null,"classified_at":"2026-05-03 15:23:56","receipt_file_path":null,"receipt_original_name":null,"receipt_uploaded_at":null,"bank_information":"CapitalOne Credit Card","business_flag":"1","locked_flag":"0","reconciled_flag":"0","reconcile_notes":null,"raw_json":"{\"id\":\"836861\",\"date\":\"2026-02-14\",\"description\":\"WP MEDIA\",\"originaldescription\":\"WP MEDIA\",\"category\":\"Internet\",\"amount\":\"-48\",\"status\":\"Debit\",\"bankinformation\":\"CapitalOne Credit Card\",\"fees\":\"0\"}","created_at":"2026-04-28 17:55:13","updated_at":"2026-05-03 15:23:56"}
[]
[]
{"bank_classification_rule_id":"45","rule_name":"MEDIA → Software","rule_scope":"global","bank_account_id":null,"match_field":"description","match_type":"contains","match_value":"MEDIA","transaction_type":"Business","report_category":"Software","review_required":"0","priority":"144","is_active":"1","created_at":"2026-05-03 15:23:56","updated_at":"2026-05-03 15:23:56"}
[]
{"bank_transaction_id":"80","legacy_id":"836925","bank_import_batch_id":"2","bank_account_id":"12","transaction_uid":"legacy:836925","transaction_date":"2026-02-22","description":"Withdrawal to 360 Checking XXXXXXX3811","original_description":"Withdrawal to 360 Checking XXXXXXX3811","raw_category":"Credit Card","category_name":"Credit Card","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"Withdrawal to","amount":"175.00","fees":"0.00","total_amount":"175.00","transaction_status":"Debit","tx_year":"2026","tx_month":"2","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-03 15:19:56","receipt_file_path":null,"receipt_original_name":null,"receipt_uploaded_at":null,"bank_information":"CapitalOne Checking","business_flag":"0","locked_flag":"0","reconciled_flag":"0","reconcile_notes":null,"raw_json":"{\"id\":\"836925\",\"date\":\"2026-02-22\",\"description\":\"Withdrawal to 360 Checking XXXXXXX3811\",\"originaldescription\":\"Withdrawal to 360 Checking XXXXXXX3811\",\"category\":\"Credit Card\",\"amount\":\"175\",\"status\":\"Debit\",\"bankinformation\":\"CapitalOne Checking\",\"fees\":\"0\"}","created_at":"2026-04-28 17:55:13","updated_at":"2026-05-03 15:19:56"}
{"bank_transaction_id":"80","legacy_id":"836925","bank_import_batch_id":"2","bank_account_id":"12","transaction_uid":"legacy:836925","transaction_date":"2026-02-22","description":"Withdrawal to 360 Checking XXXXXXX3811","original_description":"Withdrawal to 360 Checking XXXXXXX3811","raw_category":"Credit Card","category_name":"Credit Card","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"Withdrawal to","amount":"175.00","fees":"0.00","total_amount":"175.00","transaction_status":"Debit","tx_year":"2026","tx_month":"2","transaction_type":"Personal","report_category":"Income","report_category_node_id":"5","review_status":"Approved","classification_rule_id":null,"classification_notes":null,"amazon_order_id":null,"amazon_match_method":null,"amazon_lookup_code":null,"classified_at":"2026-05-03 15:23:20","receipt_file_path":null,"receipt_original_name":null,"receipt_uploaded_at":null,"bank_information":"CapitalOne Checking","business_flag":"0","locked_flag":"0","reconciled_flag":"0","reconcile_notes":null,"raw_json":"{\"id\":\"836925\",\"date\":\"2026-02-22\",\"description\":\"Withdrawal to 360 Checking XXXXXXX3811\",\"originaldescription\":\"Withdrawal to 360 Checking XXXXXXX3811\",\"category\":\"Credit Card\",\"amount\":\"175\",\"status\":\"Debit\",\"bankinformation\":\"CapitalOne Checking\",\"fees\":\"0\"}","created_at":"2026-04-28 17:55:13","updated_at":"2026-05-03 15:23:20"}
[]
[]
{"bank_classification_rule_id":"44","rule_name":"WITHDRAWAL → Income","rule_scope":"global","bank_account_id":null,"match_field":"description","match_type":"contains","match_value":"WITHDRAWAL","transaction_type":"Personal","report_category":"Income","review_required":"0","priority":"143","is_active":"1","created_at":"2026-05-03 15:23:20","updated_at":"2026-05-03 15:23:20"}
[]
{"bank_transaction_id":"100","legacy_id":"836905","bank_import_batch_id":"2","bank_account_id":"12","transaction_uid":"legacy:836905","transaction_date":"2026-02-20","description":"Withdrawal to 360 Performance Savings XXXXXXX4978","original_description":"Withdrawal to 360 Performance Savings XXXXXXX4978","raw_category":"Credit Card","category_name":"Credit Card","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"Withdrawal to","amount":"700.00","fees":"0.00","total_amount":"700.00","transaction_status":"Debit","tx_year":"2026","tx_month":"2","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-03 15:19:57","receipt_file_path":null,"receipt_original_name":null,"receipt_uploaded_at":null,"bank_information":"CapitalOne Checking","business_flag":"0","locked_flag":"0","reconciled_flag":"0","reconcile_notes":null,"raw_json":"{\"id\":\"836905\",\"date\":\"2026-02-20\",\"description\":\"Withdrawal to 360 Performance Savings XXXXXXX4978\",\"originaldescription\":\"Withdrawal to 360 Performance Savings XXXXXXX4978\",\"category\":\"Credit Card\",\"amount\":\"700\",\"status\":\"Debit\",\"bankinformation\":\"CapitalOne Checking\",\"fees\":\"0\"}","created_at":"2026-04-28 17:55:13","updated_at":"2026-05-03 15:19:57"}
{"bank_transaction_id":"100","legacy_id":"836905","bank_import_batch_id":"2","bank_account_id":"12","transaction_uid":"legacy:836905","transaction_date":"2026-02-20","description":"Withdrawal to 360 Performance Savings XXXXXXX4978","original_description":"Withdrawal to 360 Performance Savings XXXXXXX4978","raw_category":"Credit Card","category_name":"Credit Card","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"Withdrawal to","amount":"700.00","fees":"0.00","total_amount":"700.00","transaction_status":"Debit","tx_year":"2026","tx_month":"2","transaction_type":"Personal","report_category":"Income","report_category_node_id":"5","review_status":"Approved","classification_rule_id":null,"classification_notes":null,"amazon_order_id":null,"amazon_match_method":null,"amazon_lookup_code":null,"classified_at":"2026-05-03 15:22:58","receipt_file_path":null,"receipt_original_name":null,"receipt_uploaded_at":null,"bank_information":"CapitalOne Checking","business_flag":"0","locked_flag":"0","reconciled_flag":"0","reconcile_notes":null,"raw_json":"{\"id\":\"836905\",\"date\":\"2026-02-20\",\"description\":\"Withdrawal to 360 Performance Savings XXXXXXX4978\",\"originaldescription\":\"Withdrawal to 360 Performance Savings XXXXXXX4978\",\"category\":\"Credit Card\",\"amount\":\"700\",\"status\":\"Debit\",\"bankinformation\":\"CapitalOne Checking\",\"fees\":\"0\"}","created_at":"2026-04-28 17:55:13","updated_at":"2026-05-03 15:22:58"}
[]
[]
{"bank_classification_rule_id":"43","rule_name":"WITHDRAWAL → Income","rule_scope":"global","bank_account_id":null,"match_field":"description","match_type":"contains","match_value":"WITHDRAWAL","transaction_type":"Personal","report_category":"Income","review_required":"0","priority":"142","is_active":"1","created_at":"2026-05-03 15:22:58","updated_at":"2026-05-03 15:22:58"}
[]
{"bank_transaction_id":"126","legacy_id":"836880","bank_import_batch_id":"2","bank_account_id":"13","transaction_uid":"legacy:836880","transaction_date":"2026-02-16","description":"WM SUPERCENTER #706","original_description":"WM SUPERCENTER #706","raw_category":"Merchandise","category_name":"Merchandise","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"WM SUPERCENTER","amount":"-153.41","fees":"0.00","total_amount":"-153.41","transaction_status":"Debit","tx_year":"2026","tx_month":"2","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-03 15:19:57","receipt_file_path":null,"receipt_original_name":null,"receipt_uploaded_at":null,"bank_information":"CapitalOne Savor","business_flag":"0","locked_flag":"0","reconciled_flag":"0","reconcile_notes":null,"raw_json":"{\"id\":\"836880\",\"date\":\"2026-02-16\",\"description\":\"WM SUPERCENTER #706\",\"originaldescription\":\"WM SUPERCENTER #706\",\"category\":\"Merchandise\",\"amount\":\"-153.41\",\"status\":\"Debit\",\"bankinformation\":\"CapitalOne Savor\",\"fees\":\"0\"}","created_at":"2026-04-28 17:55:13","updated_at":"2026-05-03 15:19:57"}
{"bank_transaction_id":"126","legacy_id":"836880","bank_import_batch_id":"2","bank_account_id":"13","transaction_uid":"legacy:836880","transaction_date":"2026-02-16","description":"WM SUPERCENTER #706","original_description":"WM SUPERCENTER #706","raw_category":"Merchandise","category_name":"Merchandise","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"WM SUPERCENTER","amount":"-153.41","fees":"0.00","total_amount":"-153.41","transaction_status":"Debit","tx_year":"2026","tx_month":"2","transaction_type":"Personal","report_category":"Groceries","report_category_node_id":"14","review_status":"Approved","classification_rule_id":null,"classification_notes":null,"amazon_order_id":null,"amazon_match_method":null,"amazon_lookup_code":null,"classified_at":"2026-05-03 15:22:30","receipt_file_path":null,"receipt_original_name":null,"receipt_uploaded_at":null,"bank_information":"CapitalOne Savor","business_flag":"0","locked_flag":"0","reconciled_flag":"0","reconcile_notes":null,"raw_json":"{\"id\":\"836880\",\"date\":\"2026-02-16\",\"description\":\"WM SUPERCENTER #706\",\"originaldescription\":\"WM SUPERCENTER #706\",\"category\":\"Merchandise\",\"amount\":\"-153.41\",\"status\":\"Debit\",\"bankinformation\":\"CapitalOne Savor\",\"fees\":\"0\"}","created_at":"2026-04-28 17:55:13","updated_at":"2026-05-03 15:22:30"}
[]
[]
{"bank_classification_rule_id":"42","rule_name":"SUPERCENTER → Groceries","rule_scope":"global","bank_account_id":null,"match_field":"description","match_type":"contains","match_value":"SUPERCENTER","transaction_type":"Personal","report_category":"Groceries","review_required":"0","priority":"141","is_active":"1","created_at":"2026-05-03 15:22:30","updated_at":"2026-05-03 15:22:30"}
[]
{"bank_transaction_id":"4735","legacy_id":null,"bank_import_batch_id":"19","bank_account_id":"11","transaction_uid":"hash:b2dcc36cdba3b7dbce8d931c3ee36cea06c851de","transaction_date":"2026-04-29","description":"TOP 100","original_description":null,"raw_category":"Other Services","category_name":"Other Services","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"TOP 100","amount":"68.73","fees":"0.00","total_amount":"68.73","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-03 15:19:52","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-29\",\"posteddate\":\"2026-04-30\",\"cardno\":\"0926\",\"description\":\"TOP 100\",\"category\":\"Other Services\",\"debit\":\"68.73\",\"credit\":\"\"}","created_at":"2026-05-02 13:29:45","updated_at":"2026-05-03 15:19:52"}
{"bank_transaction_id":"4735","legacy_id":null,"bank_import_batch_id":"19","bank_account_id":"11","transaction_uid":"hash:b2dcc36cdba3b7dbce8d931c3ee36cea06c851de","transaction_date":"2026-04-29","description":"TOP 100","original_description":null,"raw_category":"Other Services","category_name":"Other Services","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"TOP 100","amount":"68.73","fees":"0.00","total_amount":"68.73","transaction_status":null,"tx_year":"2026","tx_month":"4","transaction_type":"Business","report_category":"Advertising","report_category_node_id":"22","review_status":"Approved","classification_rule_id":null,"classification_notes":null,"amazon_order_id":null,"amazon_match_method":null,"amazon_lookup_code":null,"classified_at":"2026-05-03 15:21:34","receipt_file_path":null,"receipt_original_name":null,"receipt_uploaded_at":null,"bank_information":"CapitalOne","business_flag":"1","locked_flag":"0","reconciled_flag":"0","reconcile_notes":null,"raw_json":"{\"transactiondate\":\"2026-04-29\",\"posteddate\":\"2026-04-30\",\"cardno\":\"0926\",\"description\":\"TOP 100\",\"category\":\"Other Services\",\"debit\":\"68.73\",\"credit\":\"\"}","created_at":"2026-05-02 13:29:45","updated_at":"2026-05-03 15:21:34"}
[]
[]
{"bank_classification_rule_id":"41","rule_name":"TOP → Advertising","rule_scope":"global","bank_account_id":null,"match_field":"description","match_type":"contains","match_value":"TOP","transaction_type":"Business","report_category":"Advertising","review_required":"0","priority":"140","is_active":"1","created_at":"2026-05-03 15:21:34","updated_at":"2026-05-03 15:21:34"}
[]
{"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-03 15:19:52","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-03 15:19:52"}
{"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":"Business","report_category":"Software","report_category_node_id":"24","review_status":"Approved","classification_rule_id":null,"classification_notes":null,"amazon_order_id":null,"amazon_match_method":null,"amazon_lookup_code":null,"classified_at":"2026-05-03 15:21:23","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":"1","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-03 15:21:23"}
[]
[]
{"bank_classification_rule_id":"40","rule_name":"SUNO → Software","rule_scope":"global","bank_account_id":null,"match_field":"description","match_type":"contains","match_value":"SUNO","transaction_type":"Business","report_category":"Software","review_required":"0","priority":"139","is_active":"1","created_at":"2026-05-03 15:21:23","updated_at":"2026-05-03 15:21:23"}
[]
{"bank_transaction_id":"4505","legacy_id":null,"bank_import_batch_id":"10","bank_account_id":"1","transaction_uid":"hash:c5756d1b49d70465150ea4fd3e1838883cb4437b","transaction_date":"2026-03-25","description":"Adjustment Dispute","original_description":"ADJDIS-2603024085D","raw_category":"Financial","category_name":"Financial","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"Adjustment Dispute","amount":"-68.57","fees":"0.00","total_amount":"-68.57","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-03 15:10:35","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-25\",\"description\":\"Adjustment Dispute\",\"originaldescription\":\"ADJDIS-2603024085D\",\"category\":\"Financial\",\"amount\":\"-68.57\",\"status\":\"Posted\"}","created_at":"2026-04-28 18:56:17","updated_at":"2026-05-03 15:10:35"}
{"bank_transaction_id":"4505","legacy_id":null,"bank_import_batch_id":"10","bank_account_id":"1","transaction_uid":"hash:c5756d1b49d70465150ea4fd3e1838883cb4437b","transaction_date":"2026-03-25","description":"Adjustment Dispute","original_description":"ADJDIS-2603024085D","raw_category":"Financial","category_name":"Financial","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"Adjustment Dispute","amount":"-68.57","fees":"0.00","total_amount":"-68.57","transaction_status":"Posted","tx_year":"2026","tx_month":"3","transaction_type":"Personal","report_category":"Bank Fees","report_category_node_id":"20","review_status":"Approved","classification_rule_id":null,"classification_notes":null,"amazon_order_id":null,"amazon_match_method":null,"amazon_lookup_code":null,"classified_at":"2026-05-03 15:13:31","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-25\",\"description\":\"Adjustment Dispute\",\"originaldescription\":\"ADJDIS-2603024085D\",\"category\":\"Financial\",\"amount\":\"-68.57\",\"status\":\"Posted\"}","created_at":"2026-04-28 18:56:17","updated_at":"2026-05-03 15:13:31"}
[]
[]
{"bank_classification_rule_id":"39","rule_name":"ADJUSTMENT → Bank Fees","rule_scope":"global","bank_account_id":null,"match_field":"description","match_type":"contains","match_value":"ADJUSTMENT","transaction_type":"Personal","report_category":"Bank Fees","review_required":"0","priority":"25","is_active":"1","created_at":"2026-05-03 15:13:31","updated_at":"2026-05-03 15:13:31"}
[]
{"bank_transaction_id":"4394","legacy_id":null,"bank_import_batch_id":"5","bank_account_id":"11","transaction_uid":"hash:afb2e61edbe058c684a2a0d9565b9fc4ec60ee45","transaction_date":"2026-03-27","description":"BURGER KING #28995 Q07","original_description":null,"raw_category":"Dining","category_name":"Dining","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"BURGER KING","amount":"7.93","fees":"0.00","total_amount":"7.93","transaction_status":null,"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-03 15:10:35","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-03-27\",\"posteddate\":\"2026-03-28\",\"cardno\":\"0926\",\"description\":\"BURGER KING #28995 Q07\",\"category\":\"Dining\",\"debit\":\"7.93\",\"credit\":\"\"}","created_at":"2026-04-28 18:42:33","updated_at":"2026-05-03 15:10:35"}
{"bank_transaction_id":"4394","legacy_id":null,"bank_import_batch_id":"5","bank_account_id":"11","transaction_uid":"hash:afb2e61edbe058c684a2a0d9565b9fc4ec60ee45","transaction_date":"2026-03-27","description":"BURGER KING #28995 Q07","original_description":null,"raw_category":"Dining","category_name":"Dining","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"BURGER KING","amount":"7.93","fees":"0.00","total_amount":"7.93","transaction_status":null,"tx_year":"2026","tx_month":"3","transaction_type":"Personal","report_category":"Dining","report_category_node_id":"15","review_status":"Approved","classification_rule_id":null,"classification_notes":null,"amazon_order_id":null,"amazon_match_method":null,"amazon_lookup_code":null,"classified_at":"2026-05-03 15:12:53","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-03-27\",\"posteddate\":\"2026-03-28\",\"cardno\":\"0926\",\"description\":\"BURGER KING #28995 Q07\",\"category\":\"Dining\",\"debit\":\"7.93\",\"credit\":\"\"}","created_at":"2026-04-28 18:42:33","updated_at":"2026-05-03 15:12:53"}
[]
[]
{"bank_classification_rule_id":"38","rule_name":"BURGER → Dining","rule_scope":"global","bank_account_id":null,"match_field":"description","match_type":"contains","match_value":"BURGER","transaction_type":"Personal","report_category":"Dining","review_required":"0","priority":"25","is_active":"1","created_at":"2026-05-03 15:12:53","updated_at":"2026-05-03 15:12:53"}
[]
{"bank_transaction_id":"4509","legacy_id":null,"bank_import_batch_id":"10","bank_account_id":"1","transaction_uid":"hash:99b36687fb04e88384bf93038e69f0743afc2856","transaction_date":"2026-03-23","description":"Costco","original_description":"COSTCO WHSE#1249 LUTZ FL","raw_category":"Shopping","category_name":"Shopping","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"Costco","amount":"395.25","fees":"0.00","total_amount":"395.25","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-03 15:10:35","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-23\",\"description\":\"Costco\",\"originaldescription\":\"COSTCO WHSE#1249 LUTZ FL\",\"category\":\"Shopping\",\"amount\":\"395.25\",\"status\":\"Posted\"}","created_at":"2026-04-28 18:56:17","updated_at":"2026-05-03 15:10:35"}
{"bank_transaction_id":"4509","legacy_id":null,"bank_import_batch_id":"10","bank_account_id":"1","transaction_uid":"hash:99b36687fb04e88384bf93038e69f0743afc2856","transaction_date":"2026-03-23","description":"Costco","original_description":"COSTCO WHSE#1249 LUTZ FL","raw_category":"Shopping","category_name":"Shopping","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"Costco","amount":"395.25","fees":"0.00","total_amount":"395.25","transaction_status":"Posted","tx_year":"2026","tx_month":"3","transaction_type":"Personal","report_category":"Groceries","report_category_node_id":"14","review_status":"Approved","classification_rule_id":null,"classification_notes":null,"amazon_order_id":null,"amazon_match_method":null,"amazon_lookup_code":null,"classified_at":"2026-05-03 15:12:32","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-23\",\"description\":\"Costco\",\"originaldescription\":\"COSTCO WHSE#1249 LUTZ FL\",\"category\":\"Shopping\",\"amount\":\"395.25\",\"status\":\"Posted\"}","created_at":"2026-04-28 18:56:17","updated_at":"2026-05-03 15:12:32"}
[]
[]
{"bank_classification_rule_id":"37","rule_name":"COSTCO → Groceries","rule_scope":"global","bank_account_id":null,"match_field":"description","match_type":"contains","match_value":"COSTCO","transaction_type":"Personal","report_category":"Groceries","review_required":"0","priority":"25","is_active":"1","created_at":"2026-05-03 15:12:32","updated_at":"2026-05-03 15:12:32"}
[]
{"bank_transaction_id":"4506","legacy_id":null,"bank_import_batch_id":"10","bank_account_id":"1","transaction_uid":"hash:4d799030d2307a2375a5633d803bea47917ebad8","transaction_date":"2026-03-24","description":"Orl Payment","original_description":"PT *ORL HLTH PYMT ORLANDO FL","raw_category":"Doctor","category_name":"Doctor","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"Orl Payment","amount":"40.00","fees":"0.00","total_amount":"40.00","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-03 15:10:35","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-24\",\"description\":\"Orl Payment\",\"originaldescription\":\"PT *ORL HLTH PYMT ORLANDO FL\",\"category\":\"Doctor\",\"amount\":\"40.00\",\"status\":\"Posted\"}","created_at":"2026-04-28 18:56:17","updated_at":"2026-05-03 15:10:35"}
{"bank_transaction_id":"4506","legacy_id":null,"bank_import_batch_id":"10","bank_account_id":"1","transaction_uid":"hash:4d799030d2307a2375a5633d803bea47917ebad8","transaction_date":"2026-03-24","description":"Orl Payment","original_description":"PT *ORL HLTH PYMT ORLANDO FL","raw_category":"Doctor","category_name":"Doctor","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"Orl Payment","amount":"40.00","fees":"0.00","total_amount":"40.00","transaction_status":"Posted","tx_year":"2026","tx_month":"3","transaction_type":"Personal","report_category":"Medical","report_category_node_id":"13","review_status":"Approved","classification_rule_id":null,"classification_notes":null,"amazon_order_id":null,"amazon_match_method":null,"amazon_lookup_code":null,"classified_at":"2026-05-03 15:12:07","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-24\",\"description\":\"Orl Payment\",\"originaldescription\":\"PT *ORL HLTH PYMT ORLANDO FL\",\"category\":\"Doctor\",\"amount\":\"40.00\",\"status\":\"Posted\"}","created_at":"2026-04-28 18:56:17","updated_at":"2026-05-03 15:12:07"}
[]
[]
{"bank_classification_rule_id":"36","rule_name":"Orl Payment → Medical","rule_scope":"global","bank_account_id":null,"match_field":"description","match_type":"contains","match_value":"Orl Payment","transaction_type":"Personal","report_category":"Medical","review_required":"0","priority":"25","is_active":"1","created_at":"2026-05-03 15:12:07","updated_at":"2026-05-03 15:12:07"}
[]
{"bank_transaction_id":"4392","legacy_id":null,"bank_import_batch_id":"19","bank_account_id":"11","transaction_uid":"hash:ffb667c0fceb4db00158ff85adc778eae14320ec","transaction_date":"2026-04-02","description":"SXM*SIRIUSXM.COM/ACCT","original_description":null,"raw_category":"Phone/Cable","category_name":"Phone/Cable","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"SXM*SIRIUSXM.COM/ACCT","amount":"1.09","fees":"0.00","total_amount":"1.09","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 17:13:11","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-02\",\"posteddate\":\"2026-04-03\",\"cardno\":\"0926\",\"description\":\"SXM*SIRIUSXM.COM/ACCT\",\"category\":\"Phone/Cable\",\"debit\":\"1.09\",\"credit\":\"\"}","created_at":"2026-04-28 18:42:33","updated_at":"2026-05-02 17:13:11"}
{"bank_transaction_id":"4392","legacy_id":null,"bank_import_batch_id":"19","bank_account_id":"11","transaction_uid":"hash:ffb667c0fceb4db00158ff85adc778eae14320ec","transaction_date":"2026-04-02","description":"SXM*SIRIUSXM.COM/ACCT","original_description":null,"raw_category":"Phone/Cable","category_name":"Phone/Cable","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"SXM*SIRIUSXM.COM/ACCT","amount":"1.09","fees":"0.00","total_amount":"1.09","transaction_status":null,"tx_year":"2026","tx_month":"4","transaction_type":"Personal","report_category":"Entertainment","report_category_node_id":"17","review_status":"Approved","classification_rule_id":null,"classification_notes":null,"amazon_order_id":null,"amazon_match_method":null,"amazon_lookup_code":null,"classified_at":"2026-05-03 15:10:23","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-02\",\"posteddate\":\"2026-04-03\",\"cardno\":\"0926\",\"description\":\"SXM*SIRIUSXM.COM/ACCT\",\"category\":\"Phone/Cable\",\"debit\":\"1.09\",\"credit\":\"\"}","created_at":"2026-04-28 18:42:33","updated_at":"2026-05-03 15:10:23"}
[]
[]
{"bank_classification_rule_id":"35","rule_name":"SIRIUSXM → Entertainment","rule_scope":"global","bank_account_id":null,"match_field":"description","match_type":"contains","match_value":"SIRIUSXM","transaction_type":"Personal","report_category":"Entertainment","review_required":"0","priority":"25","is_active":"1","created_at":"2026-05-03 15:10:23","updated_at":"2026-05-03 15:10:23"}
[]
{"bank_transaction_id":"4507","legacy_id":null,"bank_import_batch_id":"10","bank_account_id":"1","transaction_uid":"hash:a99d115188832681bcd9dd8f7b18bd8e5fb56630","transaction_date":"2026-03-24","description":"Tires Plus","original_description":"TIRES PLUS 74802 ZEPHYRHILLS FL","raw_category":"Service & Parts","category_name":"Service & Parts","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"Tires Plus","amount":"2333.19","fees":"0.00","total_amount":"2333.19","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-24\",\"description\":\"Tires Plus\",\"originaldescription\":\"TIRES PLUS 74802 ZEPHYRHILLS FL\",\"category\":\"Service & Parts\",\"amount\":\"2333.19\",\"status\":\"Posted\"}","created_at":"2026-04-28 18:56:17","updated_at":"2026-05-02 17:13:12"}
{"bank_transaction_id":"4507","legacy_id":null,"bank_import_batch_id":"10","bank_account_id":"1","transaction_uid":"hash:a99d115188832681bcd9dd8f7b18bd8e5fb56630","transaction_date":"2026-03-24","description":"Tires Plus","original_description":"TIRES PLUS 74802 ZEPHYRHILLS FL","raw_category":"Service & Parts","category_name":"Service & Parts","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"Tires Plus","amount":"2333.19","fees":"0.00","total_amount":"2333.19","transaction_status":"Posted","tx_year":"2026","tx_month":"3","transaction_type":"Business","report_category":"Automotive","report_category_node_id":"48","review_status":"Approved","classification_rule_id":null,"classification_notes":null,"amazon_order_id":null,"amazon_match_method":null,"amazon_lookup_code":null,"classified_at":"2026-05-03 15:09:52","receipt_file_path":null,"receipt_original_name":null,"receipt_uploaded_at":null,"bank_information":"USAA","business_flag":"1","locked_flag":"0","reconciled_flag":"0","reconcile_notes":null,"raw_json":"{\"date\":\"2026-03-24\",\"description\":\"Tires Plus\",\"originaldescription\":\"TIRES PLUS 74802 ZEPHYRHILLS FL\",\"category\":\"Service & Parts\",\"amount\":\"2333.19\",\"status\":\"Posted\"}","created_at":"2026-04-28 18:56:17","updated_at":"2026-05-03 15:09:52"}
[]
[]
{"bank_classification_rule_id":"34","rule_name":"Tires Plus → Automotive","rule_scope":"global","bank_account_id":null,"match_field":"description","match_type":"contains","match_value":"Tires Plus","transaction_type":"Business","report_category":"Automotive","review_required":"0","priority":"25","is_active":"1","created_at":"2026-05-03 15:09:52","updated_at":"2026-05-03 15:09:52"}
[]
{"bank_transaction_id":"4724","legacy_id":null,"bank_import_batch_id":"18","bank_account_id":"16","transaction_uid":"hash:badf7a2e64b5daa963a2deafe0cc3230a7ea4bb0","transaction_date":"2026-04-04","description":"STORE 1854 ZEPHYRHILLS FL","original_description":null,"raw_category":null,"category_name":null,"subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"STORE 1854","amount":"-81.30","fees":"0.00","total_amount":"-81.30","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 17:13:11","receipt_file_path":null,"receipt_original_name":null,"receipt_uploaded_at":null,"bank_information":"Lowes","business_flag":"0","locked_flag":"0","reconciled_flag":"0","reconcile_notes":null,"raw_json":"{\"transactiondate\":\"04/04/2026\",\"postingdate\":\"04/04/2026\",\"referencenumber\":\"P929400FF00XSJBMS\",\"amount\":\"-81.3\",\"description\":\"STORE 1854 ZEPHYRHILLS FL\"}","created_at":"2026-04-28 19:02:09","updated_at":"2026-05-02 17:13:11"}
{"bank_transaction_id":"4724","legacy_id":null,"bank_import_batch_id":"18","bank_account_id":"16","transaction_uid":"hash:badf7a2e64b5daa963a2deafe0cc3230a7ea4bb0","transaction_date":"2026-04-04","description":"STORE 1854 ZEPHYRHILLS FL","original_description":null,"raw_category":null,"category_name":null,"subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"STORE 1854","amount":"-81.30","fees":"0.00","total_amount":"-81.30","transaction_status":null,"tx_year":"2026","tx_month":"4","transaction_type":"Personal","report_category":"Home Repair or Service","report_category_node_id":"49","review_status":"Approved","classification_rule_id":null,"classification_notes":null,"amazon_order_id":null,"amazon_match_method":null,"amazon_lookup_code":null,"classified_at":"2026-05-03 15:09:16","receipt_file_path":null,"receipt_original_name":null,"receipt_uploaded_at":null,"bank_information":"Lowes","business_flag":"0","locked_flag":"0","reconciled_flag":"0","reconcile_notes":null,"raw_json":"{\"transactiondate\":\"04/04/2026\",\"postingdate\":\"04/04/2026\",\"referencenumber\":\"P929400FF00XSJBMS\",\"amount\":\"-81.3\",\"description\":\"STORE 1854 ZEPHYRHILLS FL\"}","created_at":"2026-04-28 19:02:09","updated_at":"2026-05-03 15:09:16"}
[]
[]
{"bank_classification_rule_id":"33","rule_name":"STORE 1854 → Home Repair or Service","rule_scope":"global","bank_account_id":null,"match_field":"description","match_type":"contains","match_value":"STORE 1854","transaction_type":"Personal","report_category":"Home Repair or Service","review_required":"0","priority":"25","is_active":"1","created_at":"2026-05-03 15:09:16","updated_at":"2026-05-03 15:09:16"}
[]
[]
{"bank_report_category_node_id":"50","parent_id":"4","name":"Home Repair or Service","sort_order":"0","is_active":"1","created_at":"2026-05-03 15:08:43","updated_at":"2026-05-03 15:08:43"}
[]
[]
{"bank_report_category_node_id":"49","parent_id":"6","name":"Home Repair or Service","sort_order":"0","is_active":"1","created_at":"2026-05-03 15:08:37","updated_at":"2026-05-03 15:08:37"}
[]
[]
{"bank_report_category_node_id":"48","parent_id":"4","name":"Automotive","sort_order":"0","is_active":"1","created_at":"2026-05-03 15:07:45","updated_at":"2026-05-03 15:07:45"}
[]
[]
{"bank_report_category_node_id":"47","parent_id":"6","name":"Automotive","sort_order":"0","is_active":"1","created_at":"2026-05-03 15:07:36","updated_at":"2026-05-03 15:07:36"}
[]
{"bank_transaction_id":"4493","legacy_id":null,"bank_import_batch_id":"10","bank_account_id":"1","transaction_uid":"hash:7eab55d959c939c1d36ab90893c3848e15fca6a2","transaction_date":"2026-04-07","description":"Reward Points Redemption","original_description":"REWARD POINTS REDEMPTION","raw_category":"Bonus","category_name":"Bonus","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"Reward Points","amount":"-55.81","fees":"0.00","total_amount":"-55.81","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,"amazon_order_id":null,"amazon_match_method":null,"amazon_lookup_code":null,"classified_at":"2026-05-02 17:13:11","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-04-07\",\"description\":\"Reward Points Redemption\",\"originaldescription\":\"REWARD POINTS REDEMPTION\",\"category\":\"Bonus\",\"amount\":\"-55.81\",\"status\":\"Posted\"}","created_at":"2026-04-28 18:56:17","updated_at":"2026-05-02 17:13:11"}
{"bank_transaction_id":"4493","legacy_id":null,"bank_import_batch_id":"10","bank_account_id":"1","transaction_uid":"hash:7eab55d959c939c1d36ab90893c3848e15fca6a2","transaction_date":"2026-04-07","description":"Reward Points Redemption","original_description":"REWARD POINTS REDEMPTION","raw_category":"Bonus","category_name":"Bonus","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"Reward Points","amount":"-55.81","fees":"0.00","total_amount":"-55.81","transaction_status":"Posted","tx_year":"2026","tx_month":"4","transaction_type":"Personal","report_category":"Income","report_category_node_id":"5","review_status":"Approved","classification_rule_id":null,"classification_notes":null,"amazon_order_id":null,"amazon_match_method":null,"amazon_lookup_code":null,"classified_at":"2026-05-03 15:06:28","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-04-07\",\"description\":\"Reward Points Redemption\",\"originaldescription\":\"REWARD POINTS REDEMPTION\",\"category\":\"Bonus\",\"amount\":\"-55.81\",\"status\":\"Posted\"}","created_at":"2026-04-28 18:56:17","updated_at":"2026-05-03 15:06:28"}
[]
[]
{"bank_classification_rule_id":"32","rule_name":"REWARD → Income","rule_scope":"global","bank_account_id":null,"match_field":"description","match_type":"contains","match_value":"REWARD","transaction_type":"Personal","report_category":"Income","review_required":"0","priority":"25","is_active":"1","created_at":"2026-05-03 15:06:28","updated_at":"2026-05-03 15:06:28"}
[]
{"bank_transaction_id":"4499","legacy_id":null,"bank_import_batch_id":"10","bank_account_id":"1","transaction_uid":"hash:ae5b303fd9afb223304e1fd8005decf90c5eb593","transaction_date":"2026-04-01","description":"McDonald's","original_description":"MCDONALD'S F6961 MIAMI FL","raw_category":"Fast Food","category_name":"Fast Food","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"McDonald's","amount":"21.17","fees":"0.00","total_amount":"21.17","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,"amazon_order_id":null,"amazon_match_method":null,"amazon_lookup_code":null,"classified_at":"2026-05-02 17:13:11","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-04-01\",\"description\":\"McDonald's\",\"originaldescription\":\"MCDONALD'S F6961 MIAMI FL\",\"category\":\"Fast Food\",\"amount\":\"21.17\",\"status\":\"Posted\"}","created_at":"2026-04-28 18:56:17","updated_at":"2026-05-02 17:13:11"}
{"bank_transaction_id":"4499","legacy_id":null,"bank_import_batch_id":"10","bank_account_id":"1","transaction_uid":"hash:ae5b303fd9afb223304e1fd8005decf90c5eb593","transaction_date":"2026-04-01","description":"McDonald's","original_description":"MCDONALD'S F6961 MIAMI FL","raw_category":"Fast Food","category_name":"Fast Food","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"McDonald's","amount":"21.17","fees":"0.00","total_amount":"21.17","transaction_status":"Posted","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,"amazon_order_id":null,"amazon_match_method":null,"amazon_lookup_code":null,"classified_at":"2026-05-03 15:06:02","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-04-01\",\"description\":\"McDonald's\",\"originaldescription\":\"MCDONALD'S F6961 MIAMI FL\",\"category\":\"Fast Food\",\"amount\":\"21.17\",\"status\":\"Posted\"}","created_at":"2026-04-28 18:56:17","updated_at":"2026-05-03 15:06:02"}
[]
[]
{"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"}