{"dashboard":{"counts":{"banks":21,"categories":0,"transactions":4792,"unreconciled":4792,"locked":0,"needs_review":4456,"classification_rules":52},"totals":{"credits_total":966150.89,"debits_total":454953.25},"latest_import":{"bank_import_batch_id":"38","bank_account_id":"1","import_date":"2026-05-08","start_date":"2026-05-01","end_date":"2026-05-31","sort_name":null,"import_notes":null,"source_filename":"usaavisa.csv","import_status":"imported","rows_seen":"80","rows_imported":"0","rows_updated":"80","rows_skipped":"0","created_at":"2026-05-08 19:01:40","updated_at":"2026-05-08 19:01:40"},"recent_imports":[{"bank_import_batch_id":"38","bank_account_id":"1","import_date":"2026-05-08","start_date":"2026-05-01","end_date":"2026-05-31","sort_name":null,"import_notes":null,"source_filename":"usaavisa.csv","import_status":"imported","rows_seen":"80","rows_imported":"0","rows_updated":"80","rows_skipped":"0","created_at":"2026-05-08 19:01:40","updated_at":"2026-05-08 19:01:40","bank_name":"USAA"},{"bank_import_batch_id":"37","bank_account_id":"1","import_date":"2026-05-08","start_date":"2026-05-01","end_date":"2026-05-31","sort_name":null,"import_notes":null,"source_filename":"usaavisa.csv","import_status":"imported","rows_seen":"80","rows_imported":"4","rows_updated":"76","rows_skipped":"0","created_at":"2026-05-08 19:00:49","updated_at":"2026-05-08 19:00:49","bank_name":"USAA"},{"bank_import_batch_id":"36","bank_account_id":"4","import_date":"2026-05-08","start_date":"2026-05-01","end_date":"2026-05-31","sort_name":null,"import_notes":null,"source_filename":"usaasavings.csv","import_status":"imported","rows_seen":"3","rows_imported":"0","rows_updated":"3","rows_skipped":"0","created_at":"2026-05-08 19:00:36","updated_at":"2026-05-08 19:00:36","bank_name":"USAA"},{"bank_import_batch_id":"35","bank_account_id":"2","import_date":"2026-05-08","start_date":"2026-05-01","end_date":"2026-05-31","sort_name":null,"import_notes":null,"source_filename":"usaamainchecking.csv","import_status":"imported","rows_seen":"1","rows_imported":"0","rows_updated":"1","rows_skipped":"0","created_at":"2026-05-08 19:00:13","updated_at":"2026-05-08 19:00:13","bank_name":"USAA"},{"bank_import_batch_id":"34","bank_account_id":"7","import_date":"2026-05-08","start_date":"2026-05-01","end_date":"2026-05-31","sort_name":null,"import_notes":null,"source_filename":"midlforidacreditcard.csv","import_status":"imported","rows_seen":"25","rows_imported":"0","rows_updated":"0","rows_skipped":"25","created_at":"2026-05-08 18:59:37","updated_at":"2026-05-08 18:59:37","bank_name":"MidFlorida"},{"bank_import_batch_id":"33","bank_account_id":"8","import_date":"2026-05-08","start_date":"2026-05-01","end_date":"2026-05-31","sort_name":null,"import_notes":null,"source_filename":"midfloridacarloan.csv","import_status":"imported","rows_seen":"5","rows_imported":"0","rows_updated":"0","rows_skipped":"5","created_at":"2026-05-08 18:59:21","updated_at":"2026-05-08 18:59:21","bank_name":"MidFlorida"},{"bank_import_batch_id":"32","bank_account_id":"6","import_date":"2026-05-08","start_date":"2026-01-01","end_date":"2026-05-31","sort_name":null,"import_notes":null,"source_filename":"midfloridamainchecking.csv","import_status":"imported","rows_seen":"12","rows_imported":"0","rows_updated":"0","rows_skipped":"12","created_at":"2026-05-08 18:59:08","updated_at":"2026-05-08 18:59:08","bank_name":"MidFlorida"},{"bank_import_batch_id":"31","bank_account_id":"6","import_date":"2026-05-08","start_date":"2026-05-01","end_date":"2026-05-31","sort_name":null,"import_notes":null,"source_filename":"midfloridamainchecking.csv","import_status":"imported","rows_seen":"12","rows_imported":"0","rows_updated":"0","rows_skipped":"12","created_at":"2026-05-08 18:58:47","updated_at":"2026-05-08 18:58:47","bank_name":"MidFlorida"},{"bank_import_batch_id":"30","bank_account_id":"16","import_date":"2026-05-08","start_date":"2026-05-01","end_date":"2026-05-31","sort_name":null,"import_notes":null,"source_filename":"lowes2.csv","import_status":"imported","rows_seen":"5","rows_imported":"0","rows_updated":"5","rows_skipped":"0","created_at":"2026-05-08 18:57:52","updated_at":"2026-05-08 18:57:52","bank_name":"Lowes"},{"bank_import_batch_id":"29","bank_account_id":"16","import_date":"2026-05-08","start_date":"2026-05-01","end_date":"2026-05-31","sort_name":null,"import_notes":null,"source_filename":"lowes.csv","import_status":"imported","rows_seen":"8","rows_imported":"1","rows_updated":"7","rows_skipped":"0","created_at":"2026-05-08 18:57:43","updated_at":"2026-05-08 18:57:43","bank_name":"Lowes"}],"recent_transactions":[{"bank_transaction_id":"4581","legacy_id":null,"bank_import_batch_id":"11","bank_account_id":"15","transaction_uid":"hash:408907ac7ff74aaf1f54a4e66ee74aded20a12e5","transaction_date":"2026-12-30","description":"AMAZON MARKETPLACE SEATTLE WA","original_description":null,"raw_category":null,"category_name":null,"subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"AMAZON MARKETPLACE","amount":"-25.42","fees":"0.00","total_amount":"-25.42","transaction_status":null,"tx_year":"2026","tx_month":"12","transaction_type":null,"report_category":null,"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":null,"receipt_file_path":null,"receipt_original_name":null,"receipt_uploaded_at":null,"bank_information":"Amazon","business_flag":"0","locked_flag":"0","reconciled_flag":"0","reconcile_notes":null,"raw_json":"{\"transactiondate\":\"12/30/2026\",\"postingdate\":\"12/30/2026\",\"referencenumber\":\"P934200BDEHMBR13V\",\"amount\":\"-25.42\",\"description\":\"AMAZON MARKETPLACE SEATTLE WA\"}","created_at":"2026-04-28 18:59:49","updated_at":"2026-04-29 09:48:03","bank_name":"Amazon","source_filename":"amazon1.csv"},{"bank_transaction_id":"4580","legacy_id":null,"bank_import_batch_id":"11","bank_account_id":"15","transaction_uid":"hash:c2d6d8ce059d8d129a99f279fb5c934c6e37cfed","transaction_date":"2026-12-30","description":"AMAZON RETAIL SEATTLE WA","original_description":null,"raw_category":null,"category_name":null,"subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"AMAZON RETAIL","amount":"-41.56","fees":"0.00","total_amount":"-41.56","transaction_status":null,"tx_year":"2026","tx_month":"12","transaction_type":null,"report_category":null,"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":null,"receipt_file_path":null,"receipt_original_name":null,"receipt_uploaded_at":null,"bank_information":"Amazon","business_flag":"0","locked_flag":"0","reconciled_flag":"0","reconcile_notes":null,"raw_json":"{\"transactiondate\":\"12/30/2026\",\"postingdate\":\"12/30/2026\",\"referencenumber\":\"P934200BDEHM6GTHM\",\"amount\":\"-41.56\",\"description\":\"AMAZON RETAIL SEATTLE WA\"}","created_at":"2026-04-28 18:59:49","updated_at":"2026-04-29 09:48:03","bank_name":"Amazon","source_filename":"amazon1.csv"},{"bank_transaction_id":"3","legacy_id":"836992","bank_import_batch_id":"2","bank_account_id":"16","transaction_uid":"legacy:836992","transaction_date":"2026-12-30","description":"P929400BD00XSBL35","original_description":"LOWES INTERNET FUFILLMNT","raw_category":"P929400BD00XSBL35","category_name":"P929400BD00XSBL35","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"P929400BD00XSBL35","amount":"-258.92","fees":"0.00","total_amount":"-258.92","transaction_status":"Debit","tx_year":"2026","tx_month":"12","transaction_type":null,"report_category":null,"report_category_node_id":null,"review_status":"Needs Review","classification_rule_id":null,"classification_notes":null,"amazon_order_id":null,"amazon_match_method":"ref_pending","amazon_lookup_code":"P929400BD00XSBL35","classified_at":null,"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":"{\"id\":\"836992\",\"date\":\"2026-12-30\",\"description\":\"P929400BD00XSBL35\",\"originaldescription\":\"LOWES INTERNET FUFILLMNT\",\"category\":\"P929400BD00XSBL35\",\"amount\":\"-258.92\",\"status\":\"Debit\",\"bankinformation\":\"Lowes\",\"fees\":\"0\"}","created_at":"2026-04-28 17:55:13","updated_at":"2026-04-29 15:52:13","bank_name":"Lowes","source_filename":"BankTransactions.xlsx"},{"bank_transaction_id":"2","legacy_id":"836993","bank_import_batch_id":"2","bank_account_id":"15","transaction_uid":"legacy:836993","transaction_date":"2026-12-30","description":"P934200BDEHM6GTHM","original_description":"AMAZON RETAIL SEATTLE WA","raw_category":"P934200BDEHM6GTHM","category_name":"P934200BDEHM6GTHM","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"P934200BDEHM6GTHM","amount":"-41.56","fees":"0.00","total_amount":"-41.56","transaction_status":"Debit","tx_year":"2026","tx_month":"12","transaction_type":null,"report_category":null,"report_category_node_id":null,"review_status":"Needs Review","classification_rule_id":null,"classification_notes":null,"amazon_order_id":null,"amazon_match_method":"ref_pending","amazon_lookup_code":"P934200BDEHM6GTHM","classified_at":null,"receipt_file_path":null,"receipt_original_name":null,"receipt_uploaded_at":null,"bank_information":"Amazon","business_flag":"0","locked_flag":"0","reconciled_flag":"0","reconcile_notes":null,"raw_json":"{\"id\":\"836993\",\"date\":\"2026-12-30\",\"description\":\"P934200BDEHM6GTHM\",\"originaldescription\":\"AMAZON RETAIL SEATTLE WA\",\"category\":\"P934200BDEHM6GTHM\",\"amount\":\"-41.56\",\"status\":\"Debit\",\"bankinformation\":\"Amazon\",\"fees\":\"0\"}","created_at":"2026-04-28 17:55:13","updated_at":"2026-04-29 15:52:13","bank_name":"Amazon","source_filename":"BankTransactions.xlsx"},{"bank_transaction_id":"1","legacy_id":"836994","bank_import_batch_id":"2","bank_account_id":"15","transaction_uid":"legacy:836994","transaction_date":"2026-12-30","description":"P934200BDEHMBR13V","original_description":"AMAZON MARKETPLACE SEATTLE WA","raw_category":"P934200BDEHMBR13V","category_name":"P934200BDEHMBR13V","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"P934200BDEHMBR13V","amount":"-25.42","fees":"0.00","total_amount":"-25.42","transaction_status":"Debit","tx_year":"2026","tx_month":"12","transaction_type":null,"report_category":null,"report_category_node_id":null,"review_status":"Needs Review","classification_rule_id":null,"classification_notes":null,"amazon_order_id":null,"amazon_match_method":"ref_pending","amazon_lookup_code":"P934200BDEHMBR13V","classified_at":null,"receipt_file_path":null,"receipt_original_name":null,"receipt_uploaded_at":null,"bank_information":"Amazon","business_flag":"0","locked_flag":"0","reconciled_flag":"0","reconcile_notes":null,"raw_json":"{\"id\":\"836994\",\"date\":\"2026-12-30\",\"description\":\"P934200BDEHMBR13V\",\"originaldescription\":\"AMAZON MARKETPLACE SEATTLE WA\",\"category\":\"P934200BDEHMBR13V\",\"amount\":\"-25.42\",\"status\":\"Debit\",\"bankinformation\":\"Amazon\",\"fees\":\"0\"}","created_at":"2026-04-28 17:55:13","updated_at":"2026-04-29 15:52:13","bank_name":"Amazon","source_filename":"BankTransactions.xlsx"},{"bank_transaction_id":"4579","legacy_id":null,"bank_import_batch_id":"11","bank_account_id":"15","transaction_uid":"hash:eef5d80ab4708e21985d289e15e90ae913d55781","transaction_date":"2026-12-28","description":"AMAZON MARKETPLACE SEATTLE WA","original_description":null,"raw_category":null,"category_name":null,"subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"AMAZON MARKETPLACE","amount":"-16.62","fees":"0.00","total_amount":"-16.62","transaction_status":null,"tx_year":"2026","tx_month":"12","transaction_type":null,"report_category":null,"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":null,"receipt_file_path":null,"receipt_original_name":null,"receipt_uploaded_at":null,"bank_information":"Amazon","business_flag":"0","locked_flag":"0","reconciled_flag":"0","reconcile_notes":null,"raw_json":"{\"transactiondate\":\"12/28/2026\",\"postingdate\":\"12/28/2026\",\"referencenumber\":\"P934200BBEHMBPXDG\",\"amount\":\"-16.62\",\"description\":\"AMAZON MARKETPLACE SEATTLE WA\"}","created_at":"2026-04-28 18:59:49","updated_at":"2026-04-29 09:48:03","bank_name":"Amazon","source_filename":"amazon1.csv"},{"bank_transaction_id":"4","legacy_id":"836991","bank_import_batch_id":"2","bank_account_id":"15","transaction_uid":"legacy:836991","transaction_date":"2026-12-28","description":"P934200BBEHMBPXDG","original_description":"AMAZON MARKETPLACE SEATTLE WA","raw_category":"P934200BBEHMBPXDG","category_name":"P934200BBEHMBPXDG","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"P934200BBEHMBPXDG","amount":"-16.62","fees":"0.00","total_amount":"-16.62","transaction_status":"Debit","tx_year":"2026","tx_month":"12","transaction_type":null,"report_category":null,"report_category_node_id":null,"review_status":"Needs Review","classification_rule_id":null,"classification_notes":null,"amazon_order_id":null,"amazon_match_method":"ref_pending","amazon_lookup_code":"P934200BBEHMBPXDG","classified_at":null,"receipt_file_path":null,"receipt_original_name":null,"receipt_uploaded_at":null,"bank_information":"Amazon","business_flag":"0","locked_flag":"0","reconciled_flag":"0","reconcile_notes":null,"raw_json":"{\"id\":\"836991\",\"date\":\"2026-12-28\",\"description\":\"P934200BBEHMBPXDG\",\"originaldescription\":\"AMAZON MARKETPLACE SEATTLE WA\",\"category\":\"P934200BBEHMBPXDG\",\"amount\":\"-16.62\",\"status\":\"Debit\",\"bankinformation\":\"Amazon\",\"fees\":\"0\"}","created_at":"2026-04-28 17:55:13","updated_at":"2026-04-29 15:52:13","bank_name":"Amazon","source_filename":"BankTransactions.xlsx"},{"bank_transaction_id":"4731","legacy_id":null,"bank_import_batch_id":"19","bank_account_id":"11","transaction_uid":"hash:476bd0df99b488426df4f4df49f3076df3d45d8f","transaction_date":"2026-05-01","description":"CREDIT-CASH BACK REWARD","original_description":null,"raw_category":"Payment/Credit","category_name":"Payment/Credit","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"CREDIT-CASH BACK","amount":"3.58","fees":"0.00","total_amount":"3.58","transaction_status":null,"tx_year":"2026","tx_month":"5","transaction_type":"Transfer","report_category":"Credit Card Payment","report_category_node_id":null,"review_status":"Approved","classification_rule_id":"21","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-05-01\",\"posteddate\":\"2026-05-01\",\"cardno\":\"0926\",\"description\":\"CREDIT-CASH BACK REWARD\",\"category\":\"Payment/Credit\",\"debit\":\"\",\"credit\":\"3.58\"}","created_at":"2026-05-02 13:29:45","updated_at":"2026-05-03 15:19:52","bank_name":"CapitalOne","source_filename":"2026-05-02_transaction_download.csv"},{"bank_transaction_id":"4789","legacy_id":null,"bank_import_batch_id":"38","bank_account_id":"1","transaction_uid":"hash:ea8025b13b8c30f667deaa9ef64c4d9984f291ec","transaction_date":"2026-04-30","description":"ZPH AHMG PC","original_description":"ZPH AHMG PC","raw_category":"Category Pending","category_name":"Category Pending","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"ZPH AHMG","amount":"5.00","fees":"0.00","total_amount":"5.00","transaction_status":"Pending","tx_year":"2026","tx_month":"4","transaction_type":"Personal","report_category":"Doctors","report_category_node_id":null,"review_status":"Approved","classification_rule_id":"20","classification_notes":null,"amazon_order_id":null,"amazon_match_method":null,"amazon_lookup_code":null,"classified_at":"2026-05-08 19:00:49","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-30\",\"description\":\"ZPH AHMG PC\",\"originaldescription\":\"ZPH AHMG PC\",\"category\":\"Category Pending\",\"amount\":\"5.00\",\"status\":\"Pending\"}","created_at":"2026-05-08 19:00:49","updated_at":"2026-05-08 19:01:40","bank_name":"USAA","source_filename":"usaavisa.csv"},{"bank_transaction_id":"4786","legacy_id":null,"bank_import_batch_id":"27","bank_account_id":"11","transaction_uid":"hash:c3a48420e66af83267f335e3f60b3adc0c354576","transaction_date":"2026-04-30","description":null,"original_description":null,"raw_category":null,"category_name":null,"subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":null,"amount":"10.02","fees":"0.00","total_amount":"10.02","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-08 18:57:06","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":"{\"accountnumber\":\"4978\",\"transactiondescription\":\"Monthly Interest Paid\",\"transactiondate\":\"04/30/26\",\"transactiontype\":\"Credit\",\"transactionamount\":\"10.02\",\"balance\":\"4232.7\"}","created_at":"2026-05-08 18:57:06","updated_at":"2026-05-08 18:57:06","bank_name":"CapitalOne","source_filename":"capitalonesavings4978ins&tax.csv"},{"bank_transaction_id":"4739","legacy_id":null,"bank_import_batch_id":"25","bank_account_id":"12","transaction_uid":"hash:da28a9e8bc1edf6c9520c9184c11b053c21f5885","transaction_date":"2026-04-30","description":null,"original_description":null,"raw_category":null,"category_name":null,"subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":null,"amount":"0.20","fees":"0.00","total_amount":"0.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,"amazon_order_id":null,"amazon_match_method":null,"amazon_lookup_code":null,"classified_at":"2026-05-08 18:55:12","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":"{\"accountnumber\":\"6488\",\"transactiondescription\":\"Monthly Interest Paid\",\"transactiondate\":\"04/30/26\",\"transactiontype\":\"Credit\",\"transactionamount\":\"0.2\",\"balance\":\"7853.34\"}","created_at":"2026-05-08 18:55:12","updated_at":"2026-05-08 18:56:02","bank_name":"CapitalOne","source_filename":"capitalonemainchecking.csv"},{"bank_transaction_id":"4734","legacy_id":null,"bank_import_batch_id":"24","bank_account_id":"11","transaction_uid":"hash:9dbe2621eb22e0e1e6002dca76e40916015a58dd","transaction_date":"2026-04-30","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":"0.77","fees":"0.00","total_amount":"0.77","transaction_status":null,"tx_year":"2026","tx_month":"4","transaction_type":"Personal","report_category":"Entertainment","report_category_node_id":null,"review_status":"Approved","classification_rule_id":"35","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-30\",\"posteddate\":\"2026-04-30\",\"cardno\":\"0926\",\"description\":\"SXM*SIRIUSXM.COM/ACCT\",\"category\":\"Phone/Cable\",\"debit\":\"\",\"credit\":\"0.77\"}","created_at":"2026-05-02 13:29:45","updated_at":"2026-05-08 18:55:28","bank_name":"CapitalOne","source_filename":"capitalonequicksilver.csv"},{"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_name":"CapitalOne","source_filename":"2026-05-02_transaction_download.csv"},{"bank_transaction_id":"4732","legacy_id":null,"bank_import_batch_id":"19","bank_account_id":"11","transaction_uid":"hash:8b2eb878a316b02ffd31c73ebacbd35893de3b82","transaction_date":"2026-04-30","description":"BELL PHARMACY 004","original_description":null,"raw_category":"Healthcare","category_name":"Healthcare","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"BELL PHARMACY","amount":"26.66","fees":"0.00","total_amount":"26.66","transaction_status":null,"tx_year":"2026","tx_month":"4","transaction_type":"Personal","report_category":"Pharmacy","report_category_node_id":null,"review_status":"Approved","classification_rule_id":"6","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-30\",\"posteddate\":\"2026-05-01\",\"cardno\":\"0926\",\"description\":\"BELL PHARMACY 004\",\"category\":\"Healthcare\",\"debit\":\"26.66\",\"credit\":\"\"}","created_at":"2026-05-02 13:29:45","updated_at":"2026-05-03 15:19:52","bank_name":"CapitalOne","source_filename":"2026-05-02_transaction_download.csv"},{"bank_transaction_id":"4791","legacy_id":null,"bank_import_batch_id":"38","bank_account_id":"1","transaction_uid":"hash:16850c0c63048e655a063a4e9b4a3c3731dcbd12","transaction_date":"2026-04-29","description":"Ahmg Obgyn","original_description":"AHMG PC SS OBGYN DADE    DADE CITY    FL","raw_category":"Doctor","category_name":"Doctor","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"Ahmg Obgyn","amount":"40.00","fees":"0.00","total_amount":"40.00","transaction_status":"Posted","tx_year":"2026","tx_month":"4","transaction_type":"Personal","report_category":"Doctors","report_category_node_id":null,"review_status":"Approved","classification_rule_id":"20","classification_notes":null,"amazon_order_id":null,"amazon_match_method":null,"amazon_lookup_code":null,"classified_at":"2026-05-08 19:00:49","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-29\",\"description\":\"Ahmg Obgyn\",\"originaldescription\":\"AHMG PC SS OBGYN DADE    DADE CITY    FL\",\"category\":\"Doctor\",\"amount\":\"40.00\",\"status\":\"Posted\"}","created_at":"2026-05-08 19:00:49","updated_at":"2026-05-08 19:01:40","bank_name":"USAA","source_filename":"usaavisa.csv"}]},"accounts":[{"bank_account_id":"15","legacy_id":null,"bank_name":"Amazon","account_name":"Amazon","routing_number":null,"account_number":null,"account_mask":null,"is_active":"1","created_at":"2026-04-28 17:55:08","updated_at":"2026-04-28 17:55:08"},{"bank_account_id":"12","legacy_id":null,"bank_name":"CapitalOne","account_name":"Checking","routing_number":null,"account_number":null,"account_mask":null,"is_active":"1","created_at":"2026-04-28 17:55:08","updated_at":"2026-04-28 17:55:08"},{"bank_account_id":"11","legacy_id":null,"bank_name":"CapitalOne","account_name":"Credit Card","routing_number":null,"account_number":null,"account_mask":null,"is_active":"1","created_at":"2026-04-28 17:55:08","updated_at":"2026-04-28 17:55:08"},{"bank_account_id":"21","legacy_id":null,"bank_name":"CapitalOne","account_name":"Savings","routing_number":null,"account_number":null,"account_mask":null,"is_active":"1","created_at":"2026-04-28 18:44:40","updated_at":"2026-04-28 18:44:40"},{"bank_account_id":"13","legacy_id":null,"bank_name":"CapitalOne","account_name":"Savor","routing_number":null,"account_number":null,"account_mask":null,"is_active":"1","created_at":"2026-04-28 17:55:08","updated_at":"2026-04-28 17:55:08"},{"bank_account_id":"17","legacy_id":null,"bank_name":"CareCredit","account_name":"CareCredit","routing_number":null,"account_number":null,"account_mask":null,"is_active":"1","created_at":"2026-04-28 17:55:08","updated_at":"2026-04-28 17:55:08"},{"bank_account_id":"10","legacy_id":null,"bank_name":"Centennial","account_name":"Bank","routing_number":null,"account_number":null,"account_mask":null,"is_active":"1","created_at":"2026-04-28 17:55:08","updated_at":"2026-04-28 17:55:08"},{"bank_account_id":"16","legacy_id":null,"bank_name":"Lowes","account_name":"Lowes","routing_number":null,"account_number":null,"account_mask":null,"is_active":"1","created_at":"2026-04-28 17:55:08","updated_at":"2026-04-28 17:55:08"},{"bank_account_id":"14","legacy_id":null,"bank_name":"M&T","account_name":"Bank","routing_number":null,"account_number":null,"account_mask":null,"is_active":"1","created_at":"2026-04-28 17:55:08","updated_at":"2026-04-28 17:55:08"},{"bank_account_id":"8","legacy_id":null,"bank_name":"MidFlorida","account_name":"Car Loan","routing_number":null,"account_number":null,"account_mask":null,"is_active":"1","created_at":"2026-04-28 17:55:08","updated_at":"2026-04-28 17:55:08"},{"bank_account_id":"6","legacy_id":null,"bank_name":"MidFlorida","account_name":"Checking","routing_number":null,"account_number":null,"account_mask":null,"is_active":"1","created_at":"2026-04-28 17:55:08","updated_at":"2026-04-28 17:55:08"},{"bank_account_id":"7","legacy_id":null,"bank_name":"MidFlorida","account_name":"Credit Card","routing_number":null,"account_number":null,"account_mask":null,"is_active":"1","created_at":"2026-04-28 17:55:08","updated_at":"2026-04-28 17:55:08"},{"bank_account_id":"9","legacy_id":null,"bank_name":"MidFlorida","account_name":"Youth Savings","routing_number":null,"account_number":null,"account_mask":null,"is_active":"1","created_at":"2026-04-28 17:55:08","updated_at":"2026-04-28 17:55:08"},{"bank_account_id":"20","legacy_id":null,"bank_name":"Square","account_name":"Credit Card","routing_number":null,"account_number":null,"account_mask":null,"is_active":"1","created_at":"2026-04-28 17:55:08","updated_at":"2026-04-28 17:55:08"},{"bank_account_id":"18","legacy_id":null,"bank_name":"Target","account_name":"Target","routing_number":null,"account_number":null,"account_mask":null,"is_active":"1","created_at":"2026-04-28 17:55:08","updated_at":"2026-04-28 17:55:08"},{"bank_account_id":"19","legacy_id":null,"bank_name":"United Wholesale Mortgage","account_name":"United Wholesale Mortgage","routing_number":null,"account_number":null,"account_mask":null,"is_active":"1","created_at":"2026-04-28 17:55:08","updated_at":"2026-04-28 17:55:08"},{"bank_account_id":"4","legacy_id":null,"bank_name":"USAA","account_name":"Backup Checking","routing_number":null,"account_number":null,"account_mask":null,"is_active":"1","created_at":"2026-04-28 17:55:08","updated_at":"2026-04-28 17:55:08"},{"bank_account_id":"2","legacy_id":null,"bank_name":"USAA","account_name":"Main Checking","routing_number":null,"account_number":null,"account_mask":null,"is_active":"1","created_at":"2026-04-28 17:55:08","updated_at":"2026-04-28 17:55:08"},{"bank_account_id":"3","legacy_id":null,"bank_name":"USAA","account_name":"Savings","routing_number":null,"account_number":null,"account_mask":null,"is_active":"1","created_at":"2026-04-28 17:55:08","updated_at":"2026-04-28 17:55:08"},{"bank_account_id":"1","legacy_id":null,"bank_name":"USAA","account_name":"Signature Visa","routing_number":null,"account_number":null,"account_mask":null,"is_active":"1","created_at":"2026-04-28 17:55:08","updated_at":"2026-04-28 17:55:08"},{"bank_account_id":"5","legacy_id":null,"bank_name":"USAA","account_name":"Youth Spending","routing_number":null,"account_number":null,"account_mask":null,"is_active":"1","created_at":"2026-04-28 17:55:08","updated_at":"2026-04-28 17:55:08"}],"categories":[],"report_names":[]}