# quickbooks_expenses

id: df954399-aa44-498f-883d-9a4b50fb1027
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
qb_doc_id: 144
qb_realm_id: 9341457542931248
account_name: Mastercard
tx_date: 2026-06-23 00:00:00.000000
created_at: 2026-07-18 04:44:36.285980
metadata_json:
  {"AccountRef": {"value": "41", "name": "Mastercard"}, "PaymentType": "CreditCard", "Credit": false, "TotalAmt": 34.0, "PurchaseEx": {"any": [{"name": "{http://schema.intuit.com/finance/v3}NameValue", "declaredType": "com.intuit.schema.finance.v3.NameValue", "scope": "javax.xml.bind.JAXBElement$GlobalScope", "value": {"Name": "TxnType", "Value": "1"}, "nil": false, "globalScope": true, "typeSubstituted": false}]}, "domain": "QBO", "sparse": false, "Id": "144", "SyncToken": "0", "MetaData": {"CreateTime": "2026-06-23T14:04:25-07:00", "LastUpdatedTime": "2026-06-23T14:04:25-07:00"}, "TxnDate": "2026-06-23", "CurrencyRef": {"value": "USD", "name": "United States Dollar"}, "Line": [{"Id": "1", "Amount": 34.0, "DetailType": "AccountBasedExpenseLineDetail", "AccountBasedExpenseLineDetail": {"AccountRef": {"value": "55", "name": "Automobile"}, "BillableStatus": "NotBillable", "TaxCodeRef": {"value": "NON"}}}]}


id: 67b24148-338a-429e-b625-9464ae3b5283
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
qb_doc_id: 143
qb_realm_id: 9341457542931248
account_name: Mastercard
tx_date: 2026-06-04 00:00:00.000000
created_at: 2026-07-18 04:44:36.286945
metadata_json:
  {"AccountRef": {"value": "41", "name": "Mastercard"}, "PaymentType": "CreditCard", "EntityRef": {"value": "41", "name": "Hicks Hardware", "type": "Vendor"}, "Credit": false, "TotalAmt": 42.4, "PurchaseEx": {"any": [{"name": "{http://schema.intuit.com/finance/v3}NameValue", "declaredType": "com.intuit.schema.finance.v3.NameValue", "scope": "javax.xml.bind.JAXBElement$GlobalScope", "value": {"Name": "TxnType", "Value": "1"}, "nil": false, "globalScope": true, "typeSubstituted": false}]}, "domain": "QBO", "sparse": false, "Id": "143", "SyncToken": "0", "MetaData": {"CreateTime": "2026-06-12T14:45:20-07:00", "LastUpdatedTime": "2026-06-12T14:45:20-07:00"}, "TxnDate": "2026-06-04", "CurrencyRef": {"value": "USD", "name": "United States Dollar"}, "Line": [{"Id": "1", "Amount": 42.4, "DetailType": "AccountBasedExpenseLineDetail", "AccountBasedExpenseLineDetail": {"AccountRef": {"value": "64", "name": "Job Expenses:Job Materials:Decks and Patios"}, "BillableStatus": "NotBillable", "TaxCodeRef": {"value": "NON"}}}]}


id: afa18f0f-d879-4ea2-bbba-ba7b1de5149c
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
qb_doc_id: 142
qb_realm_id: 9341457542931248
account_name: Mastercard
tx_date: 2026-06-10 00:00:00.000000
created_at: 2026-07-18 04:44:36.287465
metadata_json:
  {"AccountRef": {"value": "41", "name": "Mastercard"}, "PaymentType": "CreditCard", "EntityRef": {"value": "57", "name": "Squeaky Kleen Car Wash", "type": "Vendor"}, "Credit": false, "TotalAmt": 19.99, "PurchaseEx": {"any": [{"name": "{http://schema.intuit.com/finance/v3}NameValue", "declaredType": "com.intuit.schema.finance.v3.NameValue", "scope": "javax.xml.bind.JAXBElement$GlobalScope", "value": {"Name": "TxnType", "Value": "1"}, "nil": false, "globalScope": true, "typeSubstituted": false}]}, "domain": "QBO", "sparse": false, "Id": "142", "SyncToken": "0", "MetaData": {"CreateTime": "2026-06-12T14:37:54-07:00", "LastUpdatedTime": "2026-06-12T14:37:54-07:00"}, "TxnDate": "2026-06-10", "CurrencyRef": {"value": "USD", "name": "United States Dollar"}, "Line": [{"Id": "1", "Amount": 19.99, "DetailType": "AccountBasedExpenseLineDetail", "AccountBasedExpenseLineDetail": {"AccountRef": {"value": "55", "name": "Automobile"}, "BillableStatus": "NotBillable", "TaxCodeRef": {"value": "NON"}}}]}


id: 9808ba08-2133-4615-855a-14f3bc9169ae
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
qb_doc_id: 141
qb_realm_id: 9341457542931248
account_name: Mastercard
tx_date: 2026-06-03 00:00:00.000000
created_at: 2026-07-18 04:44:36.287948
metadata_json:
  {"AccountRef": {"value": "41", "name": "Mastercard"}, "PaymentType": "CreditCard", "EntityRef": {"value": "57", "name": "Squeaky Kleen Car Wash", "type": "Vendor"}, "Credit": false, "TotalAmt": 19.99, "PurchaseEx": {"any": [{"name": "{http://schema.intuit.com/finance/v3}NameValue", "declaredType": "com.intuit.schema.finance.v3.NameValue", "scope": "javax.xml.bind.JAXBElement$GlobalScope", "value": {"Name": "TxnType", "Value": "1"}, "nil": false, "globalScope": true, "typeSubstituted": false}]}, "domain": "QBO", "sparse": false, "Id": "141", "SyncToken": "0", "MetaData": {"CreateTime": "2026-06-12T14:37:27-07:00", "LastUpdatedTime": "2026-06-12T14:37:27-07:00"}, "TxnDate": "2026-06-03", "CurrencyRef": {"value": "USD", "name": "United States Dollar"}, "Line": [{"Id": "1", "Amount": 19.99, "DetailType": "AccountBasedExpenseLineDetail", "AccountBasedExpenseLineDetail": {"AccountRef": {"value": "55", "name": "Automobile"}, "BillableStatus": "NotBillable", "TaxCodeRef": {"value": "NON"}}}]}


id: 7f0a59af-cf08-4a7e-a770-d7486e8a3108
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
qb_doc_id: 140
qb_realm_id: 9341457542931248
account_name: Mastercard
tx_date: 2026-06-03 00:00:00.000000
created_at: 2026-07-18 04:44:36.288411
metadata_json:
  {"AccountRef": {"value": "41", "name": "Mastercard"}, "PaymentType": "CreditCard", "EntityRef": {"value": "56", "name": "Bob's Burger Joint", "type": "Vendor"}, "Credit": false, "TotalAmt": 18.97, "PurchaseEx": {"any": [{"name": "{http://schema.intuit.com/finance/v3}NameValue", "declaredType": "com.intuit.schema.finance.v3.NameValue", "scope": "javax.xml.bind.JAXBElement$GlobalScope", "value": {"Name": "TxnType", "Value": "1"}, "nil": false, "globalScope": true, "typeSubstituted": false}]}, "domain": "QBO", "sparse": false, "Id": "140", "SyncToken": "0", "MetaData": {"CreateTime": "2026-06-12T14:36:37-07:00", "LastUpdatedTime": "2026-06-12T14:36:37-07:00"}, "TxnDate": "2026-06-03", "CurrencyRef": {"value": "USD", "name": "United States Dollar"}, "PrivateNote": "Bought lunch for crew 102", "Line": [{"Id": "1", "Amount": 18.97, "DetailType": "AccountBasedExpenseLineDetail", "AccountBasedExpenseLineDetail": {"AccountRef": {"value": "13", "name": "Meals and Entertainment"}, "BillableStatus": "NotBillable", "TaxCodeRef": {"value": "NON"}}}]}


id: d84d277a-7aa3-40f5-ac1f-bd477b6b383f
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
qb_doc_id: 139
qb_realm_id: 9341457542931248
account_name: Mastercard
tx_date: 2026-06-12 00:00:00.000000
created_at: 2026-07-18 04:44:36.288888
metadata_json:
  {"AccountRef": {"value": "41", "name": "Mastercard"}, "PaymentType": "CreditCard", "Credit": true, "TotalAmt": 900.0, "PurchaseEx": {"any": [{"name": "{http://schema.intuit.com/finance/v3}NameValue", "declaredType": "com.intuit.schema.finance.v3.NameValue", "scope": "javax.xml.bind.JAXBElement$GlobalScope", "value": {"Name": "TxnType", "Value": "11"}, "nil": false, "globalScope": true, "typeSubstituted": false}]}, "domain": "QBO", "sparse": false, "Id": "139", "SyncToken": "0", "MetaData": {"CreateTime": "2026-06-12T14:35:37-07:00", "LastUpdatedTime": "2026-06-12T14:35:37-07:00"}, "TxnDate": "2026-06-12", "CurrencyRef": {"value": "USD", "name": "United States Dollar"}, "PrivateNote": "Monthly Payment", "Line": [{"Id": "1", "Amount": 900.0, "DetailType": "AccountBasedExpenseLineDetail", "AccountBasedExpenseLineDetail": {"AccountRef": {"value": "35", "name": "Checking"}, "BillableStatus": "NotBillable", "TaxCodeRef": {"value": "NON"}}, "CustomExtensions": []}]}


id: fb22e244-492e-490a-918e-da26a65bb044
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
qb_doc_id: 138
qb_realm_id: 9341457542931248
account_name: Checking
tx_date: 2026-05-27 00:00:00.000000
created_at: 2026-07-18 04:44:36.289357
metadata_json:
  {"AccountRef": {"value": "35", "name": "Checking"}, "PaymentType": "Check", "EntityRef": {"value": "57", "name": "Squeaky Kleen Car Wash", "type": "Vendor"}, "TotalAmt": 19.99, "PrintStatus": "NotSet", "PurchaseEx": {"any": [{"name": "{http://schema.intuit.com/finance/v3}NameValue", "declaredType": "com.intuit.schema.finance.v3.NameValue", "scope": "javax.xml.bind.JAXBElement$GlobalScope", "value": {"Name": "TxnType", "Value": "3"}, "nil": false, "globalScope": true, "typeSubstituted": false}]}, "domain": "QBO", "sparse": false, "Id": "138", "SyncToken": "0", "MetaData": {"CreateTime": "2026-06-12T14:33:29-07:00", "LastUpdatedTime": "2026-06-12T14:33:29-07:00"}, "DocNumber": "Debit", "TxnDate": "2026-05-27", "CurrencyRef": {"value": "USD", "name": "United States Dollar"}, "Line": [{"Id": "1", "Amount": 19.99, "DetailType": "AccountBasedExpenseLineDetail", "AccountBasedExpenseLineDetail": {"AccountRef": {"value": "55", "name": "Automobile"}, "BillableStatus": "NotBillable", "TaxCodeRef": {"value": "NON"}}, "CustomExtensions": []}]}


id: 8b958b4b-1111-4c36-b360-dc61d960ec71
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
qb_doc_id: 137
qb_realm_id: 9341457542931248
account_name: Checking
tx_date: 2026-05-25 00:00:00.000000
created_at: 2026-07-18 04:44:36.289800
metadata_json:
  {"AccountRef": {"value": "35", "name": "Checking"}, "PaymentType": "Cash", "EntityRef": {"value": "56", "name": "Bob's Burger Joint", "type": "Vendor"}, "TotalAmt": 3.86, "PurchaseEx": {"any": [{"name": "{http://schema.intuit.com/finance/v3}NameValue", "declaredType": "com.intuit.schema.finance.v3.NameValue", "scope": "javax.xml.bind.JAXBElement$GlobalScope", "value": {"Name": "TxnType", "Value": "31"}, "nil": false, "globalScope": true, "typeSubstituted": false}]}, "domain": "QBO", "sparse": false, "Id": "137", "SyncToken": "0", "MetaData": {"CreateTime": "2026-06-12T14:32:16-07:00", "LastUpdatedTime": "2026-06-12T14:32:16-07:00"}, "TxnDate": "2026-05-25", "CurrencyRef": {"value": "USD", "name": "United States Dollar"}, "Line": [{"Id": "1", "Amount": 3.86, "DetailType": "AccountBasedExpenseLineDetail", "AccountBasedExpenseLineDetail": {"AccountRef": {"value": "13", "name": "Meals and Entertainment"}, "BillableStatus": "NotBillable", "TaxCodeRef": {"value": "NON"}}}]}


id: 6b24d4a8-0ade-410b-a4c7-99a5efaa79ec
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
qb_doc_id: 136
qb_realm_id: 9341457542931248
account_name: Checking
tx_date: 2026-05-20 00:00:00.000000
created_at: 2026-07-18 04:44:36.290236
metadata_json:
  {"AccountRef": {"value": "35", "name": "Checking"}, "PaymentType": "Cash", "EntityRef": {"value": "57", "name": "Squeaky Kleen Car Wash", "type": "Vendor"}, "TotalAmt": 19.99, "PurchaseEx": {"any": [{"name": "{http://schema.intuit.com/finance/v3}NameValue", "declaredType": "com.intuit.schema.finance.v3.NameValue", "scope": "javax.xml.bind.JAXBElement$GlobalScope", "value": {"Name": "TxnType", "Value": "31"}, "nil": false, "globalScope": true, "typeSubstituted": false}]}, "domain": "QBO", "sparse": false, "Id": "136", "SyncToken": "0", "MetaData": {"CreateTime": "2026-06-12T14:31:50-07:00", "LastUpdatedTime": "2026-06-12T14:31:50-07:00"}, "TxnDate": "2026-05-20", "CurrencyRef": {"value": "USD", "name": "United States Dollar"}, "Line": [{"Id": "1", "Amount": 19.99, "DetailType": "AccountBasedExpenseLineDetail", "AccountBasedExpenseLineDetail": {"AccountRef": {"value": "55", "name": "Automobile"}, "BillableStatus": "NotBillable", "TaxCodeRef": {"value": "NON"}}}]}


id: ccf029e5-3668-48bf-a352-4c83704f873f
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
qb_doc_id: 135
qb_realm_id: 9341457542931248
account_name: Checking
tx_date: 2026-05-20 00:00:00.000000
created_at: 2026-07-18 04:44:36.290658
metadata_json:
  {"AccountRef": {"value": "35", "name": "Checking"}, "PaymentType": "Cash", "EntityRef": {"value": "56", "name": "Bob's Burger Joint", "type": "Vendor"}, "TotalAmt": 5.66, "PurchaseEx": {"any": [{"name": "{http://schema.intuit.com/finance/v3}NameValue", "declaredType": "com.intuit.schema.finance.v3.NameValue", "scope": "javax.xml.bind.JAXBElement$GlobalScope", "value": {"Name": "TxnType", "Value": "31"}, "nil": false, "globalScope": true, "typeSubstituted": false}]}, "domain": "QBO", "sparse": false, "Id": "135", "SyncToken": "1", "MetaData": {"CreateTime": "2026-06-12T14:26:38-07:00", "LastUpdatedTime": "2026-06-12T14:30:32-07:00"}, "TxnDate": "2026-05-20", "CurrencyRef": {"value": "USD", "name": "United States Dollar"}, "Line": [{"Id": "1", "Amount": 5.66, "DetailType": "AccountBasedExpenseLineDetail", "AccountBasedExpenseLineDetail": {"AccountRef": {"value": "13", "name": "Meals and Entertainment"}, "BillableStatus": "NotBillable", "TaxCodeRef": {"value": "NON"}}}]}


id: 0036a276-be5d-4c0b-9685-4fe9cde2450a
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
qb_doc_id: 134
qb_realm_id: 9341457542931248
account_name: Checking
tx_date: 2026-06-01 00:00:00.000000
created_at: 2026-07-18 04:44:36.291074
metadata_json:
  {"AccountRef": {"value": "35", "name": "Checking"}, "PaymentType": "Cash", "EntityRef": {"value": "50", "name": "Tania's Nursery", "type": "Vendor"}, "TotalAmt": 23.5, "PurchaseEx": {"any": [{"name": "{http://schema.intuit.com/finance/v3}NameValue", "declaredType": "com.intuit.schema.finance.v3.NameValue", "scope": "javax.xml.bind.JAXBElement$GlobalScope", "value": {"Name": "TxnType", "Value": "31"}, "nil": false, "globalScope": true, "typeSubstituted": false}]}, "domain": "QBO", "sparse": false, "Id": "134", "SyncToken": "0", "MetaData": {"CreateTime": "2026-06-12T14:21:49-07:00", "LastUpdatedTime": "2026-06-12T14:21:49-07:00"}, "TxnDate": "2026-06-01", "CurrencyRef": {"value": "USD", "name": "United States Dollar"}, "Line": [{"Id": "1", "Amount": 23.5, "DetailType": "AccountBasedExpenseLineDetail", "AccountBasedExpenseLineDetail": {"AccountRef": {"value": "66", "name": "Job Expenses:Job Materials:Plants and Soil"}, "BillableStatus": "NotBillable", "TaxCodeRef": {"value": "NON"}}}]}


id: ab683aae-a5f4-4813-8a42-c8398ff188a5
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
qb_doc_id: 133
qb_realm_id: 9341457542931248
account_name: Checking
tx_date: 2026-05-21 00:00:00.000000
created_at: 2026-07-18 04:44:36.291485
metadata_json:
  {"AccountRef": {"value": "35", "name": "Checking"}, "PaymentType": "Check", "EntityRef": {"value": "33", "name": "Chin's Gas and Oil", "type": "Vendor"}, "TotalAmt": 185.0, "PrintStatus": "NotSet", "PurchaseEx": {"any": [{"name": "{http://schema.intuit.com/finance/v3}NameValue", "declaredType": "com.intuit.schema.finance.v3.NameValue", "scope": "javax.xml.bind.JAXBElement$GlobalScope", "value": {"Name": "TxnType", "Value": "3"}, "nil": false, "globalScope": true, "typeSubstituted": false}]}, "domain": "QBO", "sparse": false, "Id": "133", "SyncToken": "0", "MetaData": {"CreateTime": "2026-06-12T14:17:55-07:00", "LastUpdatedTime": "2026-06-12T14:17:55-07:00"}, "DocNumber": "70", "TxnDate": "2026-05-21", "CurrencyRef": {"value": "USD", "name": "United States Dollar"}, "Line": [{"Id": "1", "Amount": 185.0, "DetailType": "AccountBasedExpenseLineDetail", "AccountBasedExpenseLineDetail": {"AccountRef": {"value": "72", "name": "Maintenance and Repair"}, "BillableStatus": "NotBillable", "TaxCodeRef": {"value": "NON"}}, "CustomExtensions": []}]}


id: 7d5fa52b-9c5e-44e0-b6fc-3417f7aa24eb
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
qb_doc_id: 132
qb_realm_id: 9341457542931248
account_name: Checking
tx_date: 2026-05-21 00:00:00.000000
created_at: 2026-07-18 04:44:36.291893
metadata_json:
  {"AccountRef": {"value": "35", "name": "Checking"}, "PaymentType": "Cash", "EntityRef": {"value": "33", "name": "Chin's Gas and Oil", "type": "Vendor"}, "TotalAmt": 52.14, "PurchaseEx": {"any": [{"name": "{http://schema.intuit.com/finance/v3}NameValue", "declaredType": "com.intuit.schema.finance.v3.NameValue", "scope": "javax.xml.bind.JAXBElement$GlobalScope", "value": {"Name": "TxnType", "Value": "31"}, "nil": false, "globalScope": true, "typeSubstituted": false}]}, "domain": "QBO", "sparse": false, "Id": "132", "SyncToken": "0", "MetaData": {"CreateTime": "2026-06-12T14:15:18-07:00", "LastUpdatedTime": "2026-06-12T14:15:18-07:00"}, "TxnDate": "2026-05-21", "CurrencyRef": {"value": "USD", "name": "United States Dollar"}, "Line": [{"Id": "1", "Amount": 52.14, "DetailType": "AccountBasedExpenseLineDetail", "AccountBasedExpenseLineDetail": {"AccountRef": {"value": "56", "name": "Automobile:Fuel"}, "BillableStatus": "NotBillable", "TaxCodeRef": {"value": "NON"}}}]}


id: ebbce8a6-242d-480b-ba6c-11e2ac4e8513
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
qb_doc_id: 131
qb_realm_id: 9341457542931248
account_name: Checking
tx_date: 2026-05-28 00:00:00.000000
created_at: 2026-07-18 04:44:36.292300
metadata_json:
  {"AccountRef": {"value": "35", "name": "Checking"}, "PaymentType": "Cash", "EntityRef": {"value": "33", "name": "Chin's Gas and Oil", "type": "Vendor"}, "TotalAmt": 63.15, "PurchaseEx": {"any": [{"name": "{http://schema.intuit.com/finance/v3}NameValue", "declaredType": "com.intuit.schema.finance.v3.NameValue", "scope": "javax.xml.bind.JAXBElement$GlobalScope", "value": {"Name": "TxnType", "Value": "31"}, "nil": false, "globalScope": true, "typeSubstituted": false}]}, "domain": "QBO", "sparse": false, "Id": "131", "SyncToken": "0", "MetaData": {"CreateTime": "2026-06-12T14:14:16-07:00", "LastUpdatedTime": "2026-06-12T14:14:16-07:00"}, "TxnDate": "2026-05-28", "CurrencyRef": {"value": "USD", "name": "United States Dollar"}, "Line": [{"Id": "1", "Amount": 63.15, "DetailType": "AccountBasedExpenseLineDetail", "AccountBasedExpenseLineDetail": {"AccountRef": {"value": "56", "name": "Automobile:Fuel"}, "BillableStatus": "NotBillable", "TaxCodeRef": {"value": "NON"}}}]}


id: 5f2fc0b7-31da-46dc-b8cb-ffadedfb50c7
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
qb_doc_id: 127
qb_realm_id: 9341457542931248
account_name: Checking
tx_date: 2026-05-29 00:00:00.000000
created_at: 2026-07-18 04:44:36.292700
metadata_json:
  {"AccountRef": {"value": "35", "name": "Checking"}, "PaymentType": "Cash", "EntityRef": {"value": "47", "name": "Pam Seitz", "type": "Vendor"}, "TotalAmt": 75.0, "PurchaseEx": {"any": [{"name": "{http://schema.intuit.com/finance/v3}NameValue", "declaredType": "com.intuit.schema.finance.v3.NameValue", "scope": "javax.xml.bind.JAXBElement$GlobalScope", "value": {"Name": "TxnType", "Value": "54"}, "nil": false, "globalScope": true, "typeSubstituted": false}]}, "domain": "QBO", "sparse": false, "Id": "127", "SyncToken": "0", "MetaData": {"CreateTime": "2026-05-29T13:11:56-07:00", "LastUpdatedTime": "2026-05-29T13:11:56-07:00"}, "DocNumber": "76", "TxnDate": "2026-05-29", "CurrencyRef": {"value": "USD", "name": "United States Dollar"}, "Line": [{"Id": "1", "Description": "Counsel", "Amount": 75.0, "DetailType": "AccountBasedExpenseLineDetail", "AccountBasedExpenseLineDetail": {"AccountRef": {"value": "12", "name": "Legal & Professional Fees"}, "BillableStatus": "NotBillable", "TaxCodeRef": {"value": "NON"}}, "CustomExtensions": []}]}


id: ae3e63cc-9bc3-453d-846a-0fa86bf9486e
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
qb_doc_id: 122
qb_realm_id: 9341457542931248
account_name: Mastercard
tx_date: 2026-05-29 00:00:00.000000
created_at: 2026-07-18 04:44:36.293116
metadata_json:
  {"AccountRef": {"value": "41", "name": "Mastercard"}, "PaymentType": "CreditCard", "EntityRef": {"value": "33", "name": "Chin's Gas and Oil", "type": "Vendor"}, "Credit": false, "TotalAmt": 52.56, "PurchaseEx": {"any": [{"name": "{http://schema.intuit.com/finance/v3}NameValue", "declaredType": "com.intuit.schema.finance.v3.NameValue", "scope": "javax.xml.bind.JAXBElement$GlobalScope", "value": {"Name": "TxnType", "Value": "54"}, "nil": false, "globalScope": true, "typeSubstituted": false}]}, "domain": "QBO", "sparse": false, "Id": "122", "SyncToken": "0", "MetaData": {"CreateTime": "2026-05-29T13:03:14-07:00", "LastUpdatedTime": "2026-05-29T13:03:14-07:00"}, "DocNumber": "1", "TxnDate": "2026-05-29", "CurrencyRef": {"value": "USD", "name": "United States Dollar"}, "Line": [{"Id": "1", "Amount": 52.56, "DetailType": "AccountBasedExpenseLineDetail", "AccountBasedExpenseLineDetail": {"AccountRef": {"value": "56", "name": "Automobile:Fuel"}, "BillableStatus": "NotBillable", "TaxCodeRef": {"value": "NON"}}, "CustomExtensions": []}]}


id: 58ad0ce6-5a15-4807-8633-ab14aac94b87
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
qb_doc_id: 115
qb_realm_id: 9341457542931248
account_name: Checking
tx_date: 2026-05-29 00:00:00.000000
created_at: 2026-07-18 04:44:36.293515
metadata_json:
  {"AccountRef": {"value": "35", "name": "Checking"}, "PaymentType": "Check", "EntityRef": {"value": "41", "name": "Hicks Hardware", "type": "Vendor"}, "RemitToAddr": {"Id": "37", "Line1": "42 Main St.", "City": "Middlefield", "CountrySubDivisionCode": "CA", "PostalCode": "94303", "Lat": "37.445013", "Long": "-122.1391443"}, "TotalAmt": 228.75, "PrintStatus": "NotSet", "PurchaseEx": {"any": [{"name": "{http://schema.intuit.com/finance/v3}NameValue", "declaredType": "com.intuit.schema.finance.v3.NameValue", "scope": "javax.xml.bind.JAXBElement$GlobalScope", "value": {"Name": "TxnType", "Value": "3"}, "nil": false, "globalScope": true, "typeSubstituted": false}]}, "domain": "QBO", "sparse": false, "Id": "115", "SyncToken": "0", "MetaData": {"CreateTime": "2026-05-29T12:51:46-07:00", "LastUpdatedTime": "2026-05-29T12:51:46-07:00"}, "DocNumber": "75", "TxnDate": "2026-05-29", "CurrencyRef": {"value": "USD", "name": "United States Dollar"}, "Line": [{"Id": "1", "Description": "Rock Fountain", "Amount": 125.0, "DetailType": "ItemBasedExpenseLineDetail", "ItemBasedExpenseLineDetail": {"BillableStatus": "NotBillable", "ItemRef": {"value": "5", "name": "Rock Fountain"}, "UnitPrice": 125, "Qty": 1, "TaxCodeRef": {"value": "NON"}}, "CustomExtensions": []}, {"Id": "2", "Description": "Sprinkler Heads", "Amount": 11.25, "DetailType": "ItemBasedExpenseLineDetail", "ItemBasedExpenseLineDetail": {"BillableStatus": "NotBillable", "ItemRef": {"value": "16", "name": "Sprinkler Heads"}, "UnitPrice": 0.75, "Qty": 15, "TaxCodeRef": {"value": "NON"}}, "CustomExtensions": []}, {"Id": "3", "Description": "Sprinkler Pipes", "Amount": 62.5, "DetailType": "ItemBasedExpenseLineDetail", "ItemBasedExpenseLineDetail": {"BillableStatus": "NotBillable", "ItemRef": {"value": "17", "name": "Sprinkler Pipes"}, "UnitPrice": 2.5, "Qty": 25, "TaxCodeRef": {"value": "NON"}}, "CustomExtensions": []}, {"Id": "4", "Description": "Fountain Pump", "Amount": 30.0, "DetailType": "ItemBasedExpenseLineDetail", "ItemBasedExpenseLineDetail": {"BillableStatus": "NotBillable", "ItemRef": {"value": "11", "name": "Pump"}, "UnitPrice": 10, "Qty": 3, "TaxCodeRef": {"value": "NON"}}, "CustomExtensions": []}]}


id: 44161d3e-ee5d-49fe-aca9-c8e09c3e29ce
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
qb_doc_id: 109
qb_realm_id: 9341457542931248
account_name: Checking
tx_date: 2026-04-18 00:00:00.000000
created_at: 2026-07-18 04:44:36.293916
metadata_json:
  {"AccountRef": {"value": "35", "name": "Checking"}, "PaymentType": "Check", "EntityRef": {"value": "30", "name": "Books by Bessie", "type": "Vendor"}, "RemitToAddr": {"Id": "31", "Line1": "15 Main St.", "City": "Palo Alto", "CountrySubDivisionCode": "CA", "PostalCode": "94303", "Lat": "37.445013", "Long": "-122.1391443"}, "TotalAmt": 55.0, "PrintStatus": "NotSet", "PurchaseEx": {"any": [{"name": "{http://schema.intuit.com/finance/v3}NameValue", "declaredType": "com.intuit.schema.finance.v3.NameValue", "scope": "javax.xml.bind.JAXBElement$GlobalScope", "value": {"Name": "TxnType", "Value": "3"}, "nil": false, "globalScope": true, "typeSubstituted": false}]}, "domain": "QBO", "sparse": false, "Id": "109", "SyncToken": "0", "MetaData": {"CreateTime": "2026-05-29T12:39:12-07:00", "LastUpdatedTime": "2026-05-29T12:39:12-07:00"}, "DocNumber": "12", "TxnDate": "2026-04-18", "CurrencyRef": {"value": "USD", "name": "United States Dollar"}, "Line": [{"Id": "1", "Amount": 55.0, "DetailType": "AccountBasedExpenseLineDetail", "AccountBasedExpenseLineDetail": {"AccountRef": {"value": "70", "name": "Legal & Professional Fees:Bookkeeper"}, "BillableStatus": "NotBillable", "TaxCodeRef": {"value": "NON"}}, "CustomExtensions": []}]}


id: 05b3367b-0a1a-4428-b617-7e84f3cd0113
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
qb_doc_id: 107
qb_realm_id: 9341457542931248
account_name: Checking
tx_date: 2026-03-18 00:00:00.000000
created_at: 2026-07-18 04:44:36.294306
metadata_json:
  {"AccountRef": {"value": "35", "name": "Checking"}, "PaymentType": "Cash", "EntityRef": {"value": "49", "name": "Robertson & Associates", "type": "Vendor"}, "TotalAmt": 250.0, "PurchaseEx": {"any": [{"name": "{http://schema.intuit.com/finance/v3}NameValue", "declaredType": "com.intuit.schema.finance.v3.NameValue", "scope": "javax.xml.bind.JAXBElement$GlobalScope", "value": {"Name": "TxnType", "Value": "54"}, "nil": false, "globalScope": true, "typeSubstituted": false}]}, "domain": "QBO", "sparse": false, "Id": "107", "SyncToken": "0", "MetaData": {"CreateTime": "2026-05-29T12:36:23-07:00", "LastUpdatedTime": "2026-05-29T12:36:23-07:00"}, "DocNumber": "12", "TxnDate": "2026-03-18", "CurrencyRef": {"value": "USD", "name": "United States Dollar"}, "Line": [{"Id": "1", "Amount": 250.0, "DetailType": "AccountBasedExpenseLineDetail", "AccountBasedExpenseLineDetail": {"AccountRef": {"value": "69", "name": "Legal & Professional Fees:Accounting"}, "BillableStatus": "NotBillable", "TaxCodeRef": {"value": "NON"}}, "CustomExtensions": []}]}


id: 994e1a30-512c-42e5-b65a-0a2947529ba3
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
qb_doc_id: 88
qb_realm_id: 9341457542931248
account_name: Mastercard
tx_date: 2026-05-19 00:00:00.000000
created_at: 2026-07-18 04:44:36.294690
metadata_json:
  {"AccountRef": {"value": "41", "name": "Mastercard"}, "PaymentType": "CreditCard", "EntityRef": {"value": "50", "name": "Tania's Nursery", "type": "Vendor"}, "Credit": false, "TotalAmt": 54.92, "PurchaseEx": {"any": [{"name": "{http://schema.intuit.com/finance/v3}NameValue", "declaredType": "com.intuit.schema.finance.v3.NameValue", "scope": "javax.xml.bind.JAXBElement$GlobalScope", "value": {"Name": "TxnType", "Value": "54"}, "nil": false, "globalScope": true, "typeSubstituted": false}]}, "domain": "QBO", "sparse": false, "Id": "88", "SyncToken": "1", "MetaData": {"CreateTime": "2026-05-28T13:15:55-07:00", "LastUpdatedTime": "2026-05-28T13:17:13-07:00"}, "DocNumber": "22", "TxnDate": "2026-05-19", "CurrencyRef": {"value": "USD", "name": "United States Dollar"}, "Line": [{"Id": "1", "Amount": 54.92, "DetailType": "AccountBasedExpenseLineDetail", "AccountBasedExpenseLineDetail": {"AccountRef": {"value": "49", "name": "Landscaping Services:Job Materials:Plants and Soil"}, "BillableStatus": "NotBillable", "TaxCodeRef": {"value": "NON"}}, "CustomExtensions": []}]}


id: 74152a9c-542b-4948-853a-6ba905b9ae77
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
qb_doc_id: 87
qb_realm_id: 9341457542931248
account_name: Checking
tx_date: 2026-04-25 00:00:00.000000
created_at: 2026-07-18 04:44:36.295092
metadata_json:
  {"AccountRef": {"value": "35", "name": "Checking"}, "PaymentType": "Cash", "EntityRef": {"value": "50", "name": "Tania's Nursery", "type": "Vendor"}, "TotalAmt": 108.09, "PurchaseEx": {"any": [{"name": "{http://schema.intuit.com/finance/v3}NameValue", "declaredType": "com.intuit.schema.finance.v3.NameValue", "scope": "javax.xml.bind.JAXBElement$GlobalScope", "value": {"Name": "TxnType", "Value": "54"}, "nil": false, "globalScope": true, "typeSubstituted": false}]}, "domain": "QBO", "sparse": false, "Id": "87", "SyncToken": "1", "MetaData": {"CreateTime": "2026-05-28T13:14:42-07:00", "LastUpdatedTime": "2026-05-28T13:17:06-07:00"}, "DocNumber": "15", "TxnDate": "2026-04-25", "CurrencyRef": {"value": "USD", "name": "United States Dollar"}, "Line": [{"Id": "1", "Amount": 108.09, "DetailType": "AccountBasedExpenseLineDetail", "AccountBasedExpenseLineDetail": {"AccountRef": {"value": "58", "name": "Job Expenses"}, "BillableStatus": "NotBillable", "TaxCodeRef": {"value": "NON"}}, "CustomExtensions": []}]}


id: df4f4846-3a44-4138-af1f-6891553002dc
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
qb_doc_id: 89
qb_realm_id: 9341457542931248
account_name: Checking
tx_date: 2026-05-28 00:00:00.000000
created_at: 2026-07-18 04:44:36.295481
metadata_json:
  {"AccountRef": {"value": "35", "name": "Checking"}, "PaymentType": "Cash", "EntityRef": {"value": "50", "name": "Tania's Nursery", "type": "Vendor"}, "TotalAmt": 46.98, "PurchaseEx": {"any": [{"name": "{http://schema.intuit.com/finance/v3}NameValue", "declaredType": "com.intuit.schema.finance.v3.NameValue", "scope": "javax.xml.bind.JAXBElement$GlobalScope", "value": {"Name": "TxnType", "Value": "54"}, "nil": false, "globalScope": true, "typeSubstituted": false}]}, "domain": "QBO", "sparse": false, "Id": "89", "SyncToken": "1", "MetaData": {"CreateTime": "2026-05-28T13:16:42-07:00", "LastUpdatedTime": "2026-05-28T13:16:55-07:00"}, "DocNumber": "108", "TxnDate": "2026-05-28", "CurrencyRef": {"value": "USD", "name": "United States Dollar"}, "Line": [{"Id": "1", "Amount": 46.98, "DetailType": "AccountBasedExpenseLineDetail", "AccountBasedExpenseLineDetail": {"AccountRef": {"value": "58", "name": "Job Expenses"}, "BillableStatus": "NotBillable", "TaxCodeRef": {"value": "NON"}}, "CustomExtensions": []}]}


id: 2a14d3e4-17bb-4b69-bc6f-4647d22520b1
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
qb_doc_id: 86
qb_realm_id: 9341457542931248
account_name: Checking
tx_date: 2026-04-18 00:00:00.000000
created_at: 2026-07-18 04:44:36.295868
metadata_json:
  {"AccountRef": {"value": "35", "name": "Checking"}, "PaymentType": "Cash", "EntityRef": {"value": "50", "name": "Tania's Nursery", "type": "Vendor"}, "TotalAmt": 89.09, "PurchaseEx": {"any": [{"name": "{http://schema.intuit.com/finance/v3}NameValue", "declaredType": "com.intuit.schema.finance.v3.NameValue", "scope": "javax.xml.bind.JAXBElement$GlobalScope", "value": {"Name": "TxnType", "Value": "54"}, "nil": false, "globalScope": true, "typeSubstituted": false}]}, "domain": "QBO", "sparse": false, "Id": "86", "SyncToken": "1", "MetaData": {"CreateTime": "2026-05-28T13:13:42-07:00", "LastUpdatedTime": "2026-05-28T13:13:55-07:00"}, "DocNumber": "9", "TxnDate": "2026-04-18", "CurrencyRef": {"value": "USD", "name": "United States Dollar"}, "Line": [{"Id": "1", "Description": "Morning Glories and Sod", "Amount": 89.09, "DetailType": "AccountBasedExpenseLineDetail", "AccountBasedExpenseLineDetail": {"AccountRef": {"value": "66", "name": "Job Expenses:Job Materials:Plants and Soil"}, "BillableStatus": "NotBillable", "TaxCodeRef": {"value": "NON"}}, "CustomExtensions": []}]}


id: 40ddcd44-498f-4008-8627-840900ee2afa
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
qb_doc_id: 85
qb_realm_id: 9341457542931248
account_name: Mastercard
tx_date: 2026-03-25 00:00:00.000000
created_at: 2026-07-18 04:44:36.296253
metadata_json:
  {"AccountRef": {"value": "41", "name": "Mastercard"}, "PaymentType": "CreditCard", "EntityRef": {"value": "50", "name": "Tania's Nursery", "type": "Vendor"}, "Credit": false, "TotalAmt": 158.08, "PurchaseEx": {"any": [{"name": "{http://schema.intuit.com/finance/v3}NameValue", "declaredType": "com.intuit.schema.finance.v3.NameValue", "scope": "javax.xml.bind.JAXBElement$GlobalScope", "value": {"Name": "TxnType", "Value": "54"}, "nil": false, "globalScope": true, "typeSubstituted": false}]}, "domain": "QBO", "sparse": false, "Id": "85", "SyncToken": "0", "MetaData": {"CreateTime": "2026-05-28T13:12:01-07:00", "LastUpdatedTime": "2026-05-28T13:12:01-07:00"}, "DocNumber": "3", "TxnDate": "2026-03-25", "CurrencyRef": {"value": "USD", "name": "United States Dollar"}, "Line": [{"Id": "1", "Amount": 158.08, "DetailType": "AccountBasedExpenseLineDetail", "AccountBasedExpenseLineDetail": {"AccountRef": {"value": "66", "name": "Job Expenses:Job Materials:Plants and Soil"}, "BillableStatus": "NotBillable", "TaxCodeRef": {"value": "NON"}}, "CustomExtensions": []}]}


id: 482c43c7-b12b-43a1-8970-a23f60a12313
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
qb_doc_id: 56
qb_realm_id: 9341457542931248
account_name: Mastercard
tx_date: 2026-05-23 00:00:00.000000
created_at: 2026-07-18 04:44:36.296640
metadata_json:
  {"AccountRef": {"value": "41", "name": "Mastercard"}, "PaymentType": "CreditCard", "EntityRef": {"value": "50", "name": "Tania's Nursery", "type": "Vendor"}, "Credit": false, "TotalAmt": 82.45, "PurchaseEx": {"any": [{"name": "{http://schema.intuit.com/finance/v3}NameValue", "declaredType": "com.intuit.schema.finance.v3.NameValue", "scope": "javax.xml.bind.JAXBElement$GlobalScope", "value": {"Name": "TxnType", "Value": "54"}, "nil": false, "globalScope": true, "typeSubstituted": false}]}, "domain": "QBO", "sparse": false, "Id": "56", "SyncToken": "1", "MetaData": {"CreateTime": "2026-05-27T15:10:12-07:00", "LastUpdatedTime": "2026-05-28T13:10:58-07:00"}, "DocNumber": "50", "TxnDate": "2026-05-23", "CurrencyRef": {"value": "USD", "name": "United States Dollar"}, "Line": [{"Id": "1", "Amount": 82.45, "DetailType": "AccountBasedExpenseLineDetail", "AccountBasedExpenseLineDetail": {"AccountRef": {"value": "66", "name": "Job Expenses:Job Materials:Plants and Soil"}, "BillableStatus": "NotBillable", "TaxCodeRef": {"value": "NON"}}, "CustomExtensions": []}]}


id: 7642bf62-149d-4cca-b2ea-891a6cb3b880
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
qb_doc_id: 84
qb_realm_id: 9341457542931248
account_name: Checking
tx_date: 2026-05-20 00:00:00.000000
created_at: 2026-07-18 04:44:36.297046
metadata_json:
  {"AccountRef": {"value": "35", "name": "Checking"}, "PaymentType": "Check", "EntityRef": {"value": "52", "name": "Tony Rondonuwu", "type": "Vendor"}, "TotalAmt": 100.0, "PrintStatus": "NotSet", "PurchaseEx": {"any": [{"name": "{http://schema.intuit.com/finance/v3}NameValue", "declaredType": "com.intuit.schema.finance.v3.NameValue", "scope": "javax.xml.bind.JAXBElement$GlobalScope", "value": {"Name": "TxnType", "Value": "3"}, "nil": false, "globalScope": true, "typeSubstituted": false}]}, "domain": "QBO", "sparse": false, "Id": "84", "SyncToken": "0", "MetaData": {"CreateTime": "2026-05-28T13:09:46-07:00", "LastUpdatedTime": "2026-05-28T13:09:46-07:00"}, "TxnDate": "2026-05-20", "CurrencyRef": {"value": "USD", "name": "United States Dollar"}, "Line": [{"Id": "1", "Description": "Consulting", "Amount": 100.0, "DetailType": "AccountBasedExpenseLineDetail", "AccountBasedExpenseLineDetail": {"AccountRef": {"value": "71", "name": "Legal & Professional Fees:Lawyer"}, "BillableStatus": "NotBillable", "TaxCodeRef": {"value": "NON"}}, "CustomExtensions": []}]}


id: dc66cb5a-8b56-4069-856c-7abccb180a0b
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
qb_doc_id: 83
qb_realm_id: 9341457542931248
account_name: Checking
tx_date: 2026-05-23 00:00:00.000000
created_at: 2026-07-18 04:44:36.297431
metadata_json:
  {"AccountRef": {"value": "35", "name": "Checking"}, "PaymentType": "Cash", "EntityRef": {"value": "41", "name": "Hicks Hardware", "type": "Vendor"}, "TotalAmt": 215.66, "PurchaseEx": {"any": [{"name": "{http://schema.intuit.com/finance/v3}NameValue", "declaredType": "com.intuit.schema.finance.v3.NameValue", "scope": "javax.xml.bind.JAXBElement$GlobalScope", "value": {"Name": "TxnType", "Value": "54"}, "nil": false, "globalScope": true, "typeSubstituted": false}]}, "domain": "QBO", "sparse": false, "Id": "83", "SyncToken": "0", "MetaData": {"CreateTime": "2026-05-28T13:08:20-07:00", "LastUpdatedTime": "2026-05-28T13:08:20-07:00"}, "DocNumber": "13", "TxnDate": "2026-05-23", "CurrencyRef": {"value": "USD", "name": "United States Dollar"}, "Line": [{"Id": "1", "Amount": 215.66, "DetailType": "AccountBasedExpenseLineDetail", "AccountBasedExpenseLineDetail": {"AccountRef": {"value": "67", "name": "Job Expenses:Job Materials:Sprinklers and Drip Systems"}, "BillableStatus": "NotBillable", "TaxCodeRef": {"value": "NON"}}, "CustomExtensions": []}]}


id: c3ea81c8-8b67-4de1-991a-422bed2411b2
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
qb_doc_id: 81
qb_realm_id: 9341457542931248
account_name: Mastercard
tx_date: 2026-05-17 00:00:00.000000
created_at: 2026-07-18 04:44:36.297815
metadata_json:
  {"AccountRef": {"value": "41", "name": "Mastercard"}, "PaymentType": "CreditCard", "EntityRef": {"value": "41", "name": "Hicks Hardware", "type": "Vendor"}, "Credit": false, "TotalAmt": 88.09, "PurchaseEx": {"any": [{"name": "{http://schema.intuit.com/finance/v3}NameValue", "declaredType": "com.intuit.schema.finance.v3.NameValue", "scope": "javax.xml.bind.JAXBElement$GlobalScope", "value": {"Name": "TxnType", "Value": "54"}, "nil": false, "globalScope": true, "typeSubstituted": false}]}, "domain": "QBO", "sparse": false, "Id": "81", "SyncToken": "0", "MetaData": {"CreateTime": "2026-05-28T13:04:57-07:00", "LastUpdatedTime": "2026-05-28T13:04:57-07:00"}, "DocNumber": "1", "TxnDate": "2026-05-17", "CurrencyRef": {"value": "USD", "name": "United States Dollar"}, "Line": [{"Id": "1", "Amount": 88.09, "DetailType": "AccountBasedExpenseLineDetail", "AccountBasedExpenseLineDetail": {"CustomerRef": {"value": "20", "name": "Red Rock Diner"}, "AccountRef": {"value": "64", "name": "Job Expenses:Job Materials:Decks and Patios"}, "BillableStatus": "NotBillable", "TaxCodeRef": {"value": "NON"}}, "CustomExtensions": []}]}


id: 4d616023-b3ce-4f98-9f42-a0b47daf5855
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
qb_doc_id: 80
qb_realm_id: 9341457542931248
account_name: Checking
tx_date: 2026-05-11 00:00:00.000000
created_at: 2026-07-18 04:44:36.298194
metadata_json:
  {"AccountRef": {"value": "35", "name": "Checking"}, "PaymentType": "Cash", "EntityRef": {"value": "41", "name": "Hicks Hardware", "type": "Vendor"}, "TotalAmt": 24.36, "PurchaseEx": {"any": [{"name": "{http://schema.intuit.com/finance/v3}NameValue", "declaredType": "com.intuit.schema.finance.v3.NameValue", "scope": "javax.xml.bind.JAXBElement$GlobalScope", "value": {"Name": "TxnType", "Value": "54"}, "nil": false, "globalScope": true, "typeSubstituted": false}]}, "domain": "QBO", "sparse": false, "Id": "80", "SyncToken": "0", "MetaData": {"CreateTime": "2026-05-28T13:03:08-07:00", "LastUpdatedTime": "2026-05-28T13:03:08-07:00"}, "DocNumber": "8", "TxnDate": "2026-05-11", "CurrencyRef": {"value": "USD", "name": "United States Dollar"}, "Line": [{"Id": "1", "Amount": 24.36, "DetailType": "AccountBasedExpenseLineDetail", "AccountBasedExpenseLineDetail": {"AccountRef": {"value": "49", "name": "Landscaping Services:Job Materials:Plants and Soil"}, "BillableStatus": "NotBillable", "TaxCodeRef": {"value": "NON"}}, "CustomExtensions": []}]}


id: c9142e4d-b7f3-49a1-ac02-36bd5d0fef40
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
qb_doc_id: 59
qb_realm_id: 9341457542931248
account_name: Mastercard
tx_date: 2026-05-14 00:00:00.000000
created_at: 2026-07-18 04:44:36.298568
metadata_json:
  {"AccountRef": {"value": "41", "name": "Mastercard"}, "PaymentType": "CreditCard", "EntityRef": {"value": "33", "name": "Chin's Gas and Oil", "type": "Vendor"}, "Credit": false, "TotalAmt": 65.0, "PurchaseEx": {"any": [{"name": "{http://schema.intuit.com/finance/v3}NameValue", "declaredType": "com.intuit.schema.finance.v3.NameValue", "scope": "javax.xml.bind.JAXBElement$GlobalScope", "value": {"Name": "TxnType", "Value": "54"}, "nil": false, "globalScope": true, "typeSubstituted": false}]}, "domain": "QBO", "sparse": false, "Id": "59", "SyncToken": "0", "MetaData": {"CreateTime": "2026-05-27T15:16:13-07:00", "LastUpdatedTime": "2026-05-27T15:16:13-07:00"}, "DocNumber": "1", "TxnDate": "2026-05-14", "CurrencyRef": {"value": "USD", "name": "United States Dollar"}, "Line": [{"Id": "1", "Amount": 65.0, "DetailType": "AccountBasedExpenseLineDetail", "AccountBasedExpenseLineDetail": {"AccountRef": {"value": "56", "name": "Automobile:Fuel"}, "BillableStatus": "NotBillable", "TaxCodeRef": {"value": "NON"}}, "CustomExtensions": []}]}


id: 8a6e0fb8-adf1-49ff-8cc4-02a1f7a24a47
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
qb_doc_id: 58
qb_realm_id: 9341457542931248
account_name: Checking
tx_date: 2026-04-24 00:00:00.000000
created_at: 2026-07-18 04:44:36.298942
metadata_json:
  {"AccountRef": {"value": "35", "name": "Checking"}, "PaymentType": "Check", "EntityRef": {"value": "33", "name": "Chin's Gas and Oil", "type": "Vendor"}, "TotalAmt": 62.01, "PrintStatus": "NotSet", "PurchaseEx": {"any": [{"name": "{http://schema.intuit.com/finance/v3}NameValue", "declaredType": "com.intuit.schema.finance.v3.NameValue", "scope": "javax.xml.bind.JAXBElement$GlobalScope", "value": {"Name": "TxnType", "Value": "3"}, "nil": false, "globalScope": true, "typeSubstituted": false}]}, "domain": "QBO", "sparse": false, "Id": "58", "SyncToken": "0", "MetaData": {"CreateTime": "2026-05-27T15:15:00-07:00", "LastUpdatedTime": "2026-05-27T15:15:00-07:00"}, "DocNumber": "5", "TxnDate": "2026-04-24", "CurrencyRef": {"value": "USD", "name": "United States Dollar"}, "Line": [{"Id": "1", "Amount": 62.01, "DetailType": "AccountBasedExpenseLineDetail", "AccountBasedExpenseLineDetail": {"AccountRef": {"value": "56", "name": "Automobile:Fuel"}, "BillableStatus": "NotBillable", "TaxCodeRef": {"value": "NON"}}, "CustomExtensions": []}]}


id: 1143ed83-61fb-4edb-bf42-cb8a9b83cf89
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
qb_doc_id: 57
qb_realm_id: 9341457542931248
account_name: Checking
tx_date: 2026-04-09 00:00:00.000000
created_at: 2026-07-18 04:44:36.299316
metadata_json:
  {"AccountRef": {"value": "35", "name": "Checking"}, "PaymentType": "Check", "EntityRef": {"value": "33", "name": "Chin's Gas and Oil", "type": "Vendor"}, "TotalAmt": 54.55, "PrintStatus": "NotSet", "PurchaseEx": {"any": [{"name": "{http://schema.intuit.com/finance/v3}NameValue", "declaredType": "com.intuit.schema.finance.v3.NameValue", "scope": "javax.xml.bind.JAXBElement$GlobalScope", "value": {"Name": "TxnType", "Value": "3"}, "nil": false, "globalScope": true, "typeSubstituted": false}]}, "domain": "QBO", "sparse": false, "Id": "57", "SyncToken": "0", "MetaData": {"CreateTime": "2026-05-27T15:14:27-07:00", "LastUpdatedTime": "2026-05-27T15:14:27-07:00"}, "DocNumber": "4", "TxnDate": "2026-04-09", "CurrencyRef": {"value": "USD", "name": "United States Dollar"}, "Line": [{"Id": "1", "Amount": 54.55, "DetailType": "AccountBasedExpenseLineDetail", "AccountBasedExpenseLineDetail": {"AccountRef": {"value": "56", "name": "Automobile:Fuel"}, "BillableStatus": "NotBillable", "TaxCodeRef": {"value": "NON"}}, "CustomExtensions": []}]}


id: 7c6e6b96-06ac-4253-8458-4ef5a6c15e78
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
qb_doc_id: 55
qb_realm_id: 9341457542931248
account_name: Mastercard
tx_date: 2026-05-27 00:00:00.000000
created_at: 2026-07-18 04:44:36.299693
metadata_json:
  {"AccountRef": {"value": "41", "name": "Mastercard"}, "PaymentType": "CreditCard", "EntityRef": {"value": "42", "name": "Lee Advertising", "type": "Vendor"}, "Credit": false, "TotalAmt": 74.86, "PurchaseEx": {"any": [{"name": "{http://schema.intuit.com/finance/v3}NameValue", "declaredType": "com.intuit.schema.finance.v3.NameValue", "scope": "javax.xml.bind.JAXBElement$GlobalScope", "value": {"Name": "TxnType", "Value": "54"}, "nil": false, "globalScope": true, "typeSubstituted": false}]}, "domain": "QBO", "sparse": false, "Id": "55", "SyncToken": "1", "MetaData": {"CreateTime": "2026-05-27T14:20:35-07:00", "LastUpdatedTime": "2026-05-27T14:22:40-07:00"}, "TxnDate": "2026-05-27", "CurrencyRef": {"value": "USD", "name": "United States Dollar"}, "Line": [{"Id": "1", "Amount": 74.86, "DetailType": "AccountBasedExpenseLineDetail", "AccountBasedExpenseLineDetail": {"AccountRef": {"value": "7", "name": "Advertising"}, "BillableStatus": "NotBillable", "TaxCodeRef": {"value": "NON"}}, "CustomExtensions": []}]}


id: 7616f4eb-8e75-478f-857f-9bed608a7a50
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
qb_doc_id: 51
qb_realm_id: 9341457542931248
account_name: Mastercard
tx_date: 2026-05-27 00:00:00.000000
created_at: 2026-07-18 04:44:36.300072
metadata_json:
  {"AccountRef": {"value": "41", "name": "Mastercard"}, "PaymentType": "CreditCard", "EntityRef": {"value": "38", "name": "Ellis Equipment Rental", "type": "Vendor"}, "Credit": false, "TotalAmt": 112.0, "PurchaseEx": {"any": [{"name": "{http://schema.intuit.com/finance/v3}NameValue", "declaredType": "com.intuit.schema.finance.v3.NameValue", "scope": "javax.xml.bind.JAXBElement$GlobalScope", "value": {"Name": "TxnType", "Value": "54"}, "nil": false, "globalScope": true, "typeSubstituted": false}]}, "domain": "QBO", "sparse": false, "Id": "51", "SyncToken": "0", "MetaData": {"CreateTime": "2026-05-27T11:45:45-07:00", "LastUpdatedTime": "2026-05-27T11:45:45-07:00"}, "DocNumber": "1", "TxnDate": "2026-05-27", "CurrencyRef": {"value": "USD", "name": "United States Dollar"}, "Line": [{"Id": "1", "Description": "Equipment rental for 5 days", "Amount": 112.0, "DetailType": "AccountBasedExpenseLineDetail", "AccountBasedExpenseLineDetail": {"AccountRef": {"value": "29", "name": "Equipment Rental"}, "BillableStatus": "NotBillable", "TaxCodeRef": {"value": "NON"}}, "CustomExtensions": []}]}


id: ee9b33a2-b38b-416a-a8d9-493b2c9a6301
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
qb_doc_id: 36
qb_realm_id: 9341457542931248
account_name: Checking
tx_date: 2026-05-23 00:00:00.000000
created_at: 2026-07-18 04:44:36.300448
metadata_json:
  {"AccountRef": {"value": "35", "name": "Checking"}, "PaymentType": "Check", "EntityRef": {"value": "43", "name": "Mahoney Mugs", "type": "Vendor"}, "TotalAmt": 18.08, "PrintStatus": "NotSet", "PurchaseEx": {"any": [{"name": "{http://schema.intuit.com/finance/v3}NameValue", "declaredType": "com.intuit.schema.finance.v3.NameValue", "scope": "javax.xml.bind.JAXBElement$GlobalScope", "value": {"Name": "TxnType", "Value": "3"}, "nil": false, "globalScope": true, "typeSubstituted": false}]}, "domain": "QBO", "sparse": false, "Id": "36", "SyncToken": "0", "MetaData": {"CreateTime": "2026-05-27T11:12:45-07:00", "LastUpdatedTime": "2026-05-27T11:12:45-07:00"}, "DocNumber": "2", "TxnDate": "2026-05-23", "CurrencyRef": {"value": "USD", "name": "United States Dollar"}, "Line": [{"Id": "1", "Description": "Office Supplies", "Amount": 18.08, "DetailType": "AccountBasedExpenseLineDetail", "AccountBasedExpenseLineDetail": {"AccountRef": {"value": "15", "name": "Office Expenses"}, "BillableStatus": "NotBillable", "TaxCodeRef": {"value": "NON"}}, "CustomExtensions": []}]}


# ad_metrics

id: ec1a0185-bd61-4a6c-a378-9bf660f6dc1b
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
external_campaign_id: google_sheets_tiktok_2026-06-24
source_service: google_sheets
metric_date: 2026-06-24
created_at: 2026-07-17 11:05:32.140020
updated_at: 2026-07-17 11:05:32.140022
metadata_json:
  {"platform": "tiktok", "source": "google_sheets", "spreadsheet_id": "1PL1FFqWPcA85yHZcYyMXE5fihmWhbvSXy33z7RMb41s"}


id: 55fd8f8b-741f-4424-b0c2-04137691164b
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
external_campaign_id: google_sheets_google_2026-05-31
source_service: google_sheets
metric_date: 2026-05-31
created_at: 2026-07-17 11:05:32.140621
updated_at: 2026-07-17 11:05:32.164600
metadata_json:
  {"platform": "google", "source": "google_sheets", "spreadsheet_id": "1PL1FFqWPcA85yHZcYyMXE5fihmWhbvSXy33z7RMb41s"}


id: 47131206-b322-4bf8-a7e3-a1d90fe11841
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
external_campaign_id: google_sheets_facebook_2026-05-28
source_service: google_sheets
metric_date: 2026-05-28
created_at: 2026-07-17 11:05:32.152059
updated_at: 2026-07-17 11:05:32.154613
metadata_json:
  {"platform": "facebook", "source": "google_sheets", "spreadsheet_id": "1PL1FFqWPcA85yHZcYyMXE5fihmWhbvSXy33z7RMb41s"}


id: 261fcd22-f9db-4505-af88-080106008558
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
external_campaign_id: google_sheets_Angi_2026-06-26
source_service: google_sheets
metric_date: 2026-06-26
created_at: 2026-07-17 11:05:32.268262
updated_at: 2026-07-17 11:05:32.270350
metadata_json:
  {"platform": "Angi", "source": "google_sheets", "spreadsheet_id": "1PL1FFqWPcA85yHZcYyMXE5fihmWhbvSXy33z7RMb41s"}


id: 419e571f-e390-46eb-ae77-72727e0a1c77
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
external_campaign_id: google_sheets_Home Buddy_2026-03-05
source_service: google_sheets
metric_date: 2026-03-05
created_at: 2026-07-17 11:05:32.343243
updated_at: 2026-07-17 11:05:32.343976
metadata_json:
  {"platform": "Home Buddy", "source": "google_sheets", "spreadsheet_id": "1PL1FFqWPcA85yHZcYyMXE5fihmWhbvSXy33z7RMb41s"}


# connector_logs

id: c3aba71e-ba00-4e91-865b-367e0e920e9c
company_id: 5186f947-3886-418a-87b1-7a2a6f34559e
connector_id: 2acb3a24-0f30-4821-9ddd-3f1ce62310cf
event_type: connect_error
status: error
details_json: {}
created_at: 2026-07-21 14:19:46.931982
error_message:
  403 Client Error: Forbidden for url: https://quickbooks.api.intuit.com/v3/company/9341457542931248/companyinfo/9341457542931248


# estimates

id: 1cb03ba3-932b-4e4a-9fcd-9472d4902e31
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
estimate_number: GL-2026-001
customer_name: Full
project_type: Landscape Design
description: Full backyard landscape redesign with retaining wall and irrigation.
address: 1234 Oak Dr
city: Madison
state: WI
zip_code: 53703
stage: draft
expires_at: 2026-08-24 14:36:01.302378
assigned_to: 9ad18bb3-ef0f-479f-94c9-fae5db6a5ee4
source: referral
created_at: 2026-07-25 14:36:01.302378
updated_at: 2026-07-26 14:36:01.302378
line_items_json:
  "[{\"item\": \"Full backyard landscape redesign with retaining wall and irrigation.\", \"qty\": 1, \"unit_price\": 8500, \"total\": 8500}]"

stage_history:
  "[{\"stage\": \"draft\", \"timestamp\": \"2026-07-25 14:36:01\", \"changed_by\": \"9ad18bb3-ef0f-479f-94c9-fae5db6a5ee4\"}]"


id: cdf6b239-bfd0-47ae-ba81-3ccbbf0fcd78
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
estimate_number: GL-2026-002
customer_name: Perimeter
project_type: Commercial Landscape
description: Perimeter landscaping for church campus with shrub beds and trees.
address: 5678 Pine St
city: Madison
state: WI
zip_code: 53703
stage: delivered
delivered_at: 2026-07-26 16:22:38.661515
expires_at: 2026-08-25 14:36:01.302378
assigned_to: 0d5ccc1f-772d-4015-a146-765ef98bd46c
source: website
created_at: 2026-07-26 14:36:01.302378
updated_at: 2026-07-26 16:22:38.661922
line_items_json:
  "[{\"item\": \"Perimeter landscaping for church campus with shrub beds and trees.\", \"qty\": 1, \"unit_price\": 22000, \"total\": 22000}]"

stage_history:
  [{"stage": "draft", "timestamp": "2026-07-26 14:36:01", "changed_by": "0d5ccc1f-772d-4015-a146-765ef98bd46c"}, {"from_stage": "draft", "to_stage": "delivered", "timestamp": "2026-07-26T16:22:38.661515+00:00", "notes": "Direct model test"}]


id: d997b35e-f33a-4e61-88bd-631d4f2d2b0a
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
estimate_number: GL-2026-003
customer_name: Paver
project_type: Outdoor Patio
description: Paver patio with pergola for restaurant expansion.
address: 890 State St
city: Madison
state: WI
zip_code: 53703
stage: draft
expires_at: 2026-08-23 14:36:01.302378
assigned_to: 9ad18bb3-ef0f-479f-94c9-fae5db6a5ee4
source: email
created_at: 2026-07-24 14:36:01.302378
updated_at: 2026-07-26 14:36:01.302378
line_items_json:
  "[{\"item\": \"Paver patio with pergola for restaurant expansion.\", \"qty\": 1, \"unit_price\": 15000, \"total\": 15000}]"

stage_history:
  "[{\"stage\": \"draft\", \"timestamp\": \"2026-07-24 14:36:01\", \"changed_by\": \"9ad18bb3-ef0f-479f-94c9-fae5db6a5ee4\"}]"


id: 435698e1-4345-4787-b13f-ec2f51e8ded2
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
estimate_number: GL-2026-004
customer_name: Raised
project_type: Garden Installation
description: Raised bed veg garden with composting and drip irrigation.
address: 2345 Elm Ct
city: Sun Prairie
state: WI
zip_code: 53703
stage: delivered
delivered_at: 2026-07-14 14:36:01.302378
expires_at: 2026-08-11 14:36:01.302378
assigned_to: 004b70be-a3e5-43ab-90bc-a9766ce017dd
source: website
created_at: 2026-07-12 14:36:01.302378
updated_at: 2026-07-26 14:36:01.302378
line_items_json:
  "[{\"item\": \"Raised bed veg garden with composting and drip irrigation.\", \"qty\": 1, \"unit_price\": 12500, \"total\": 12500}]"

stage_history:
  "[{\"stage\": \"draft\", \"timestamp\": \"2026-07-12 14:36:01\", \"changed_by\": \"004b70be-a3e5-43ab-90bc-a9766ce017dd\"}, {\"stage\": \"delivered\", \"timestamp\": \"2026-07-14 14:36:01\", \"changed_by\": \"004b70be-a3e5-43ab-90bc-a9766ce017dd\"}]"


id: 3dec9ad3-aa47-4231-9d06-3bf2ca1618f3
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
estimate_number: GL-2026-005
customer_name: HOA
project_type: Commercial Landscape
description: HOA landscape renovation for 24-unit complex.
address: 3456 Riverside Dr
city: Madison
state: WI
zip_code: 53703
stage: delivered
delivered_at: 2026-07-18 14:36:01.302378
expires_at: 2026-08-15 14:36:01.302378
assigned_to: 0d5ccc1f-772d-4015-a146-765ef98bd46c
source: referral
created_at: 2026-07-16 14:36:01.302378
updated_at: 2026-07-26 14:36:01.302378
line_items_json:
  "[{\"item\": \"HOA landscape renovation for 24-unit complex.\", \"qty\": 1, \"unit_price\": 45000, \"total\": 45000}]"

stage_history:
  "[{\"stage\": \"draft\", \"timestamp\": \"2026-07-16 14:36:01\", \"changed_by\": \"0d5ccc1f-772d-4015-a146-765ef98bd46c\"}, {\"stage\": \"delivered\", \"timestamp\": \"2026-07-18 14:36:01\", \"changed_by\": \"0d5ccc1f-772d-4015-a146-765ef98bd46c\"}]"


id: 56991f29-bdc4-4ff3-a456-9025e3c4ffc4
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
estimate_number: GL-2026-006
customer_name: Deck
project_type: Deck Repair
description: Deck repair and staining, composite railing replacement.
address: 4567 Maple Ave
city: Fitchburg
state: WI
zip_code: 53703
stage: delivered
delivered_at: 2026-07-21 14:36:01.302378
expires_at: 2026-08-18 14:36:01.302378
assigned_to: 9ad18bb3-ef0f-479f-94c9-fae5db6a5ee4
source: angi
created_at: 2026-07-19 14:36:01.302378
updated_at: 2026-07-26 14:36:01.302378
line_items_json:
  "[{\"item\": \"Deck repair and staining, composite railing replacement.\", \"qty\": 1, \"unit_price\": 6800, \"total\": 6800}]"

stage_history:
  "[{\"stage\": \"draft\", \"timestamp\": \"2026-07-19 14:36:01\", \"changed_by\": \"9ad18bb3-ef0f-479f-94c9-fae5db6a5ee4\"}, {\"stage\": \"delivered\", \"timestamp\": \"2026-07-21 14:36:01\", \"changed_by\": \"9ad18bb3-ef0f-479f-94c9-fae5db6a5ee4\"}]"


id: 533b5130-856b-43d7-a5f5-642c1f9b7be8
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
estimate_number: GL-2026-007
customer_name: Educational
project_type: School Garden
description: Educational garden with raised beds and rainwater collection.
address: 5678 School Rd
city: Madison
state: WI
zip_code: 53703
stage: delivered
delivered_at: 2026-07-22 14:36:01.302378
expires_at: 2026-08-20 14:36:01.302378
assigned_to: 004b70be-a3e5-43ab-90bc-a9766ce017dd
source: website
created_at: 2026-07-21 14:36:01.302378
updated_at: 2026-07-26 14:36:01.302378
line_items_json:
  "[{\"item\": \"Educational garden with raised beds and rainwater collection.\", \"qty\": 1, \"unit_price\": 35000, \"total\": 35000}]"

stage_history:
  "[{\"stage\": \"draft\", \"timestamp\": \"2026-07-21 14:36:01\", \"changed_by\": \"004b70be-a3e5-43ab-90bc-a9766ce017dd\"}, {\"stage\": \"delivered\", \"timestamp\": \"2026-07-22 14:36:01\", \"changed_by\": \"004b70be-a3e5-43ab-90bc-a9766ce017dd\"}]"


id: 95ce3dc6-0ad9-4c19-94dc-14bff26eb43a
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
estimate_number: GL-2026-008
customer_name: Complete
project_type: Full Landscape
description: Complete front/backyard with flagstone walkways and lighting.
address: 6789 Birch Ln
city: Madison
state: WI
zip_code: 53703
stage: accepted
delivered_at: 2026-07-01 06:36:01.302378
accepted_at: 2026-07-06 14:36:01.302378
expires_at: 2026-07-28 14:36:01.302378
assigned_to: 0d5ccc1f-772d-4015-a146-765ef98bd46c
source: referral
created_at: 2026-06-28 14:36:01.302378
updated_at: 2026-07-26 14:36:01.302378
line_items_json:
  "[{\"item\": \"Complete front/backyard with flagstone walkways and lighting.\", \"qty\": 1, \"unit_price\": 18500, \"total\": 18500}]"

stage_history:
  "[{\"stage\": \"draft\", \"timestamp\": \"2026-06-28 14:36:01\", \"changed_by\": \"0d5ccc1f-772d-4015-a146-765ef98bd46c\"}, {\"stage\": \"delivered\", \"timestamp\": \"2026-07-01 06:36:01\", \"changed_by\": \"0d5ccc1f-772d-4015-a146-765ef98bd46c\"}, {\"stage\": \"accepted\", \"timestamp\": \"2026-07-06 14:36:01\", \"changed_by\": \"0d5ccc1f-772d-4015-a146-765ef98bd46c\"}]"


id: 42505c8f-d151-4422-ba78-69b630d82ed4
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
estimate_number: GL-2026-009
customer_name: Multi-phase
project_type: Commercial Landscape
description: Multi-phase renovation for 48-unit apartment complex.
address: 7890 Lakeview Ter
city: Madison
state: WI
zip_code: 53703
stage: accepted
delivered_at: 2026-06-24 22:36:01.302378
accepted_at: 2026-07-01 14:36:01.302378
expires_at: 2026-07-21 14:36:01.302378
assigned_to: 004b70be-a3e5-43ab-90bc-a9766ce017dd
source: website
created_at: 2026-06-21 14:36:01.302378
updated_at: 2026-07-26 14:36:01.302378
line_items_json:
  "[{\"item\": \"Multi-phase renovation for 48-unit apartment complex.\", \"qty\": 1, \"unit_price\": 52000, \"total\": 52000}]"

stage_history:
  "[{\"stage\": \"draft\", \"timestamp\": \"2026-06-21 14:36:01\", \"changed_by\": \"004b70be-a3e5-43ab-90bc-a9766ce017dd\"}, {\"stage\": \"delivered\", \"timestamp\": \"2026-06-24 22:36:01\", \"changed_by\": \"004b70be-a3e5-43ab-90bc-a9766ce017dd\"}, {\"stage\": \"accepted\", \"timestamp\": \"2026-07-01 14:36:01\", \"changed_by\": \"004b70be-a3e5-43ab-90bc-a9766ce017dd\"}]"


id: cd2a30ef-fec2-4696-9502-bdbd0d3e9c08
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
estimate_number: GL-2026-010
customer_name: Segmented
project_type: Retaining Wall
description: Segmented retaining wall with drainage, 40ft x 4ft.
address: 8901 Cedar Rd
city: Verona
state: WI
zip_code: 53703
stage: accepted
delivered_at: 2026-07-09 22:36:01.302378
accepted_at: 2026-07-12 14:36:01.302378
expires_at: 2026-08-07 14:36:01.302378
assigned_to: 9ad18bb3-ef0f-479f-94c9-fae5db6a5ee4
source: email
created_at: 2026-07-08 14:36:01.302378
updated_at: 2026-07-26 14:36:01.302378
line_items_json:
  "[{\"item\": \"Segmented retaining wall with drainage, 40ft x 4ft.\", \"qty\": 1, \"unit_price\": 9200, \"total\": 9200}]"

stage_history:
  "[{\"stage\": \"draft\", \"timestamp\": \"2026-07-08 14:36:01\", \"changed_by\": \"9ad18bb3-ef0f-479f-94c9-fae5db6a5ee4\"}, {\"stage\": \"delivered\", \"timestamp\": \"2026-07-09 22:36:01\", \"changed_by\": \"9ad18bb3-ef0f-479f-94c9-fae5db6a5ee4\"}, {\"stage\": \"accepted\", \"timestamp\": \"2026-07-12 14:36:01\", \"changed_by\": \"9ad18bb3-ef0f-479f-94c9-fae5db6a5ee4\"}]"


id: 43f56bdd-2647-46ee-818a-73bf55da927a
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
estimate_number: GL-2026-011
customer_name: Smart
project_type: Irrigation
description: Smart irrigation system for 1/2 acre yard.
address: 9012 Willow Way
city: Madison
state: WI
zip_code: 53703
stage: rejected
delivered_at: 2026-07-06 22:36:01.302378
rejected_at: 2026-07-09 14:36:01.302378
expires_at: 2026-08-04 14:36:01.302378
rejection_reason: Chose competitor - $1,200 lower
competitor_name: ProScape Landscaping
assigned_to: 9ad18bb3-ef0f-479f-94c9-fae5db6a5ee4
source: website
created_at: 2026-07-05 14:36:01.302378
updated_at: 2026-07-26 14:36:01.302378
line_items_json:
  "[{\"item\": \"Smart irrigation system for 1/2 acre yard.\", \"qty\": 1, \"unit_price\": 7500, \"total\": 7500}]"

stage_history:
  "[{\"stage\": \"draft\", \"timestamp\": \"2026-07-05 14:36:01\", \"changed_by\": \"9ad18bb3-ef0f-479f-94c9-fae5db6a5ee4\"}, {\"stage\": \"delivered\", \"timestamp\": \"2026-07-06 22:36:01\", \"changed_by\": \"9ad18bb3-ef0f-479f-94c9-fae5db6a5ee4\"}, {\"stage\": \"rejected\", \"timestamp\": \"2026-07-09 14:36:01\", \"changed_by\": \"9ad18bb3-ef0f-479f-94c9-fae5db6a5ee4\"}]"


id: 70dae20a-3803-4565-a5ae-f0a5fac76eac
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
estimate_number: GL-2026-012
customer_name: Luxury
project_type: Full Landscape
description: Luxury landscape with water feature and outdoor kitchen.
address: 1012 Estate Dr
city: McFarland
state: WI
zip_code: 53703
stage: rejected
delivered_at: 2026-06-27 22:36:01.302378
rejected_at: 2026-06-30 14:36:01.302378
expires_at: 2026-07-26 14:36:01.302378
rejection_reason: Project on hold - budget constraints
assigned_to: 0d5ccc1f-772d-4015-a146-765ef98bd46c
source: referral
created_at: 2026-06-26 14:36:01.302378
updated_at: 2026-07-26 14:36:01.302378
line_items_json:
  "[{\"item\": \"Luxury landscape with water feature and outdoor kitchen.\", \"qty\": 1, \"unit_price\": 28000, \"total\": 28000}]"

stage_history:
  "[{\"stage\": \"draft\", \"timestamp\": \"2026-06-26 14:36:01\", \"changed_by\": \"0d5ccc1f-772d-4015-a146-765ef98bd46c\"}, {\"stage\": \"delivered\", \"timestamp\": \"2026-06-27 22:36:01\", \"changed_by\": \"0d5ccc1f-772d-4015-a146-765ef98bd46c\"}, {\"stage\": \"rejected\", \"timestamp\": \"2026-06-30 14:36:01\", \"changed_by\": \"0d5ccc1f-772d-4015-a146-765ef98bd46c\"}]"


id: 800ca71d-913f-4740-82e4-3609b598dd5d
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
estimate_number: GL-2026-013
customer_name: Natural
project_type: Patio & Lighting
description: Natural stone patio with LED lighting and fire pit.
address: 2013 Stone Path
city: Madison
state: WI
zip_code: 53703
stage: closed
delivered_at: 2026-06-11 14:36:01.302378
accepted_at: 2026-06-21 14:36:01.302378
closed_at: 2026-07-21 14:36:01.302378
expires_at: 2026-07-01 14:36:01.302378
assigned_to: 004b70be-a3e5-43ab-90bc-a9766ce017dd
source: referral
created_at: 2026-06-01 14:36:01.302378
updated_at: 2026-07-26 14:36:01.302378
line_items_json:
  "[{\"item\": \"Natural stone patio with LED lighting and fire pit.\", \"qty\": 1, \"unit_price\": 14200, \"total\": 14200}]"

stage_history:
  "[{\"stage\": \"draft\", \"timestamp\": \"2026-06-01 14:36:01\", \"changed_by\": \"004b70be-a3e5-43ab-90bc-a9766ce017dd\"}, {\"stage\": \"delivered\", \"timestamp\": \"2026-06-11 14:36:01\", \"changed_by\": \"004b70be-a3e5-43ab-90bc-a9766ce017dd\"}, {\"stage\": \"accepted\", \"timestamp\": \"2026-06-21 14:36:01\", \"changed_by\": \"004b70be-a3e5-43ab-90bc-a9766ce017dd\"}, {\"stage\": \"scheduled\", \"timestamp\": \"2026-07-01 14:36:01\", \"changed_by\": \"004b70be-a3e5-43ab-90bc-a9766ce017dd\"}, {\"stage\": \"closed\", \"timestamp\": \"2026-07-21 14:36:01\", \"changed_by\": \"004b70be-a3e5-43ab-90bc-a9766ce017dd\"}]"


id: fbba774b-6a48-483d-aa05-214d238f8232
company_id: e81f4619-a522-4f54-ae3b-cdfa6abf921c
estimate_number: GL-2026-014
customer_name: Remove
project_type: Tree Removal
description: Remove 3 mature oaks, stump grinding, reseed lawn.
address: 3014 Oak Hollow
city: Stoughton
state: WI
zip_code: 53703
stage: expired
delivered_at: 2026-06-28 06:36:01.302378
expires_at: 2026-07-16 14:36:01.302378
assigned_to: 9ad18bb3-ef0f-479f-94c9-fae5db6a5ee4
source: website
created_at: 2026-06-16 14:36:01.302378
updated_at: 2026-07-26 14:36:01.302378
line_items_json:
  "[{\"item\": \"Remove 3 mature oaks, stump grinding, reseed lawn.\", \"qty\": 1, \"unit_price\": 11000, \"total\": 11000}]"

stage_history:
  "[{\"stage\": \"draft\", \"timestamp\": \"2026-06-16 14:36:01\", \"changed_by\": \"9ad18bb3-ef0f-479f-94c9-fae5db6a5ee4\"}, {\"stage\": \"delivered\", \"timestamp\": \"2026-06-28 06:36:01\", \"changed_by\": \"9ad18bb3-ef0f-479f-94c9-fae5db6a5ee4\"}, {\"stage\": \"expired\", \"timestamp\": \"2026-07-21 14:36:01\", \"changed_by\": \"9ad18bb3-ef0f-479f-94c9-fae5db6a5ee4\"}]"


id: 37001825-dc4b-41ce-8ee3-777b5ee4bcb0
company_id: 307d7335-a929-4103-b66f-e04117c4ed77
estimate_number: MR-2026-101
customer_name: TPO
project_type: Commercial Roof
description: TPO membrane replacement on 12,000 sq ft flat roof.
address: 4015 Commerce Dr
city: Madison
state: WI
zip_code: 53703
stage: draft
expires_at: 2026-08-24 14:36:01.302378
assigned_to: 9ad18bb3-ef0f-479f-94c9-fae5db6a5ee4
source: website
created_at: 2026-07-25 14:36:01.302378
updated_at: 2026-07-26 14:36:01.302378
line_items_json:
  "[{\"item\": \"TPO membrane replacement on 12,000 sq ft flat roof.\", \"qty\": 1, \"unit_price\": 38000, \"total\": 38000}]"

stage_history:
  "[{\"stage\": \"draft\", \"timestamp\": \"2026-07-25 14:36:01\", \"changed_by\": \"9ad18bb3-ef0f-479f-94c9-fae5db6a5ee4\"}]"


id: 3feca014-129f-47a5-b0bf-4ab09e67f67c
company_id: 307d7335-a929-4103-b66f-e04117c4ed77
estimate_number: MR-2026-102
customer_name: Shingle
project_type: Roof Repair
description: Shingle replacement on north slope with flashing repair.
address: 5016 Walnut St
city: Madison
state: WI
zip_code: 53703
stage: draft
expires_at: 2026-08-22 14:36:01.302378
assigned_to: 004b70be-a3e5-43ab-90bc-a9766ce017dd
source: angi
created_at: 2026-07-23 14:36:01.302378
updated_at: 2026-07-26 14:36:01.302378
line_items_json:
  "[{\"item\": \"Shingle replacement on north slope with flashing repair.\", \"qty\": 1, \"unit_price\": 15500, \"total\": 15500}]"

stage_history:
  "[{\"stage\": \"draft\", \"timestamp\": \"2026-07-23 14:36:01\", \"changed_by\": \"004b70be-a3e5-43ab-90bc-a9766ce017dd\"}]"


id: 0fb54ab0-a990-47c5-ae37-11fe3f7390a2
company_id: 307d7335-a929-4103-b66f-e04117c4ed77
estimate_number: MR-2026-103
customer_name: Standing
project_type: Church Roof
description: Standing seam metal roof. 18,000 sq ft with complex valleys.
address: 6017 Faith Ave
city: Sun Prairie
state: WI
zip_code: 53703
stage: delivered
delivered_at: 2026-07-16 14:36:01.302378
expires_at: 2026-08-13 14:36:01.302378
assigned_to: 0d5ccc1f-772d-4015-a146-765ef98bd46c
source: referral
created_at: 2026-07-14 14:36:01.302378
updated_at: 2026-07-26 14:36:01.302378
line_items_json:
  "[{\"item\": \"Standing seam metal roof. 18,000 sq ft with complex valleys.\", \"qty\": 1, \"unit_price\": 62000, \"total\": 62000}]"

stage_history:
  "[{\"stage\": \"draft\", \"timestamp\": \"2026-07-14 14:36:01\", \"changed_by\": \"0d5ccc1f-772d-4015-a146-765ef98bd46c\"}, {\"stage\": \"delivered\", \"timestamp\": \"2026-07-16 14:36:01\", \"changed_by\": \"0d5ccc1f-772d-4015-a146-765ef98bd46c\"}]"


id: 915b7e59-63b8-4cfd-812f-bf1c13a7773e
company_id: 307d7335-a929-4103-b66f-e04117c4ed77
estimate_number: MR-2026-104
customer_name: EPDM
project_type: Flat Roof
description: EPDM to TPO conversion on 10-unit condominium.
address: 7018 River Rd
city: Madison
state: WI
zip_code: 53703
stage: delivered
delivered_at: 2026-07-20 14:36:01.302378
expires_at: 2026-08-17 14:36:01.302378
assigned_to: 9ad18bb3-ef0f-479f-94c9-fae5db6a5ee4
source: website
created_at: 2026-07-18 14:36:01.302378
updated_at: 2026-07-26 14:36:01.302378
line_items_json:
  "[{\"item\": \"EPDM to TPO conversion on 10-unit condominium.\", \"qty\": 1, \"unit_price\": 45000, \"total\": 45000}]"

stage_history:
  "[{\"stage\": \"draft\", \"timestamp\": \"2026-07-18 14:36:01\", \"changed_by\": \"9ad18bb3-ef0f-479f-94c9-fae5db6a5ee4\"}, {\"stage\": \"delivered\", \"timestamp\": \"2026-07-20 14:36:01\", \"changed_by\": \"9ad18bb3-ef0f-479f-94c9-fae5db6a5ee4\"}]"


id: 95d31012-d263-4bd2-96f3-9515ae961df4
company_id: 307d7335-a929-4103-b66f-e04117c4ed77
estimate_number: MR-2026-105
customer_name: Architectural
project_type: Full Roof Replacement
description: Architectural shingles on 2,800 sq ft home. New fascia/soffits.
address: 8019 Ridge View
city: Fitchburg
state: WI
zip_code: 53703
stage: accepted
delivered_at: 2026-07-03 22:36:01.302378
accepted_at: 2026-07-08 14:36:01.302378
expires_at: 2026-07-31 14:36:01.302378
assigned_to: 004b70be-a3e5-43ab-90bc-a9766ce017dd
source: referral
created_at: 2026-07-01 14:36:01.302378
updated_at: 2026-07-26 14:36:01.302378
line_items_json:
  "[{\"item\": \"Architectural shingles on 2,800 sq ft home. New fascia/soffits.\", \"qty\": 1, \"unit_price\": 22500, \"total\": 22500}]"

stage_history:
  "[{\"stage\": \"draft\", \"timestamp\": \"2026-07-01 14:36:01\", \"changed_by\": \"004b70be-a3e5-43ab-90bc-a9766ce017dd\"}, {\"stage\": \"delivered\", \"timestamp\": \"2026-07-03 22:36:01\", \"changed_by\": \"004b70be-a3e5-43ab-90bc-a9766ce017dd\"}, {\"stage\": \"accepted\", \"timestamp\": \"2026-07-08 14:36:01\", \"changed_by\": \"004b70be-a3e5-43ab-90bc-a9766ce017dd\"}]"


id: c39c45eb-8ab4-4944-91e9-0b29d80ac183
company_id: 307d7335-a929-4103-b66f-e04117c4ed77
estimate_number: MR-2026-106
customer_name: Bulged
project_type: Commercial Roof
description: Bulged roof replacement with energy coating and skylights.
address: 9020 Children Way
city: Madison
state: WI
zip_code: 53703
stage: accepted
delivered_at: 2026-06-27 22:36:01.302378
accepted_at: 2026-07-04 14:36:01.302378
expires_at: 2026-07-24 14:36:01.302378
assigned_to: 0d5ccc1f-772d-4015-a146-765ef98bd46c
source: email
created_at: 2026-06-24 14:36:01.302378
updated_at: 2026-07-26 14:36:01.302378
line_items_json:
  "[{\"item\": \"Bulged roof replacement with energy coating and skylights.\", \"qty\": 1, \"unit_price\": 55000, \"total\": 55000}]"

stage_history:
  "[{\"stage\": \"draft\", \"timestamp\": \"2026-06-24 14:36:01\", \"changed_by\": \"0d5ccc1f-772d-4015-a146-765ef98bd46c\"}, {\"stage\": \"delivered\", \"timestamp\": \"2026-06-27 22:36:01\", \"changed_by\": \"0d5ccc1f-772d-4015-a146-765ef98bd46c\"}, {\"stage\": \"accepted\", \"timestamp\": \"2026-07-04 14:36:01\", \"changed_by\": \"0d5ccc1f-772d-4015-a146-765ef98bd46c\"}]"


id: ef6dea48-aea9-419e-8520-9a9d5bfbc871
company_id: 307d7335-a929-4103-b66f-e04117c4ed77
estimate_number: MR-2026-107
customer_name: Emergency
project_type: Hospital Roof
description: Emergency roof repair on hospital wing.
address: 1021 Hospital Dr
city: Madison
state: WI
zip_code: 53703
stage: rejected
delivered_at: 2026-07-05 14:36:01.302378
rejected_at: 2026-07-07 14:36:01.302378
expires_at: 2026-08-03 14:36:01.302378
rejection_reason: Lost - hospital insurance certification
competitor_name: National Roofing Systems
assigned_to: 0d5ccc1f-772d-4015-a146-765ef98bd46c
source: website
created_at: 2026-07-04 14:36:01.302378
updated_at: 2026-07-26 14:36:01.302378
line_items_json:
  "[{\"item\": \"Emergency roof repair on hospital wing.\", \"qty\": 1, \"unit_price\": 125000, \"total\": 125000}]"

stage_history:
  "[{\"stage\": \"draft\", \"timestamp\": \"2026-07-04 14:36:01\", \"changed_by\": \"0d5ccc1f-772d-4015-a146-765ef98bd46c\"}, {\"stage\": \"delivered\", \"timestamp\": \"2026-07-05 14:36:01\", \"changed_by\": \"0d5ccc1f-772d-4015-a146-765ef98bd46c\"}, {\"stage\": \"rejected\", \"timestamp\": \"2026-07-07 14:36:01\", \"changed_by\": \"0d5ccc1f-772d-4015-a146-765ef98bd46c\"}]"


id: 3eccde6b-9f75-4d36-9aa2-42b8bd38a563
company_id: 307d7335-a929-4103-b66f-e04117c4ed77
estimate_number: MR-2026-108
customer_name: Full
project_type: Roof Replacement
description: Full shingle replacement, 2,400 sq ft, 2-story.
address: 2022 Neighborhood Ct
city: Middleton
state: WI
zip_code: 53703
stage: rejected
delivered_at: 2026-07-12 14:36:01.302378
rejected_at: 2026-07-14 14:36:01.302378
expires_at: 2026-08-10 14:36:01.302378
rejection_reason: Went with neighbor recommendation
assigned_to: 9ad18bb3-ef0f-479f-94c9-fae5db6a5ee4
source: angi
created_at: 2026-07-11 14:36:01.302378
updated_at: 2026-07-26 14:36:01.302378
line_items_json:
  "[{\"item\": \"Full shingle replacement, 2,400 sq ft, 2-story.\", \"qty\": 1, \"unit_price\": 18500, \"total\": 18500}]"

stage_history:
  "[{\"stage\": \"draft\", \"timestamp\": \"2026-07-11 14:36:01\", \"changed_by\": \"9ad18bb3-ef0f-479f-94c9-fae5db6a5ee4\"}, {\"stage\": \"delivered\", \"timestamp\": \"2026-07-12 14:36:01\", \"changed_by\": \"9ad18bb3-ef0f-479f-94c9-fae5db6a5ee4\"}, {\"stage\": \"rejected\", \"timestamp\": \"2026-07-14 14:36:01\", \"changed_by\": \"9ad18bb3-ef0f-479f-94c9-fae5db6a5ee4\"}]"


id: b61eb14a-557c-44f5-96a6-eef7cc424a1f
company_id: 307d7335-a929-4103-b66f-e04117c4ed77
estimate_number: MR-2026-109
customer_name: Cedar
project_type: Roof Replacement
description: Cedar shake to architectural shingle conversion. Done.
address: 3023 Cedar Hill
city: Madison
state: WI
zip_code: 53703
stage: closed
delivered_at: 2026-06-08 00:12:01.302378
accepted_at: 2026-06-19 09:48:01.302378
closed_at: 2026-07-23 14:36:01.302378
expires_at: 2026-06-26 14:36:01.302378
assigned_to: 004b70be-a3e5-43ab-90bc-a9766ce017dd
source: referral
created_at: 2026-05-27 14:36:01.302378
updated_at: 2026-07-26 14:36:01.302378
line_items_json:
  "[{\"item\": \"Cedar shake to architectural shingle conversion. Done.\", \"qty\": 1, \"unit_price\": 19800, \"total\": 19800}]"

stage_history:
  "[{\"stage\": \"draft\", \"timestamp\": \"2026-05-27 14:36:01\", \"changed_by\": \"004b70be-a3e5-43ab-90bc-a9766ce017dd\"}, {\"stage\": \"delivered\", \"timestamp\": \"2026-06-08 00:12:01\", \"changed_by\": \"004b70be-a3e5-43ab-90bc-a9766ce017dd\"}, {\"stage\": \"accepted\", \"timestamp\": \"2026-06-19 09:48:01\", \"changed_by\": \"004b70be-a3e5-43ab-90bc-a9766ce017dd\"}, {\"stage\": \"scheduled\", \"timestamp\": \"2026-06-30 19:24:01\", \"changed_by\": \"004b70be-a3e5-43ab-90bc-a9766ce017dd\"}, {\"stage\": \"closed\", \"timestamp\": \"2026-07-23 14:36:01\", \"changed_by\": \"004b70be-a3e5-43ab-90bc-a9766ce017dd\"}]"


id: dc025576-55d4-4b90-81ce-71a78053d198
company_id: 307d7335-a929-4103-b66f-e04117c4ed77
estimate_number: MR-2026-110
customer_name: Flat
project_type: Multi-Unit Roof
description: Flat roof on 16-unit complex. Offer expired.
address: 4024 Valley Rd
city: Waunakee
state: WI
zip_code: 53703
stage: expired
delivered_at: 2026-06-25 06:36:01.302378
expires_at: 2026-07-11 14:36:01.302378
assigned_to: 0d5ccc1f-772d-4015-a146-765ef98bd46c
source: email
created_at: 2026-06-11 14:36:01.302378
updated_at: 2026-07-26 14:36:01.302378
line_items_json:
  "[{\"item\": \"Flat roof on 16-unit complex. Offer expired.\", \"qty\": 1, \"unit_price\": 78000, \"total\": 78000}]"

stage_history:
  "[{\"stage\": \"draft\", \"timestamp\": \"2026-06-11 14:36:01\", \"changed_by\": \"0d5ccc1f-772d-4015-a146-765ef98bd46c\"}, {\"stage\": \"delivered\", \"timestamp\": \"2026-06-25 06:36:01\", \"changed_by\": \"0d5ccc1f-772d-4015-a146-765ef98bd46c\"}, {\"stage\": \"expired\", \"timestamp\": \"2026-07-22 14:36:01\", \"changed_by\": \"0d5ccc1f-772d-4015-a146-765ef98bd46c\"}]"


id: fca14ec5-00b5-4394-ba40-e783b597a025
company_id: 3d735c64-e5e5-4d9a-ba8a-f0fa864d1a3a
estimate_number: PH-2026-201
customer_name: 20-ton
project_type: Commercial HVAC
description: 20-ton rooftop unit with VRF zoning for office building.
address: 5025 Business Park Dr
city: Madison
state: WI
zip_code: 53703
stage: draft
expires_at: 2026-08-23 14:36:01.302378
assigned_to: 0d5ccc1f-772d-4015-a146-765ef98bd46c
source: email
created_at: 2026-07-24 14:36:01.302378
updated_at: 2026-07-26 14:36:01.302378
line_items_json:
  "[{\"item\": \"20-ton rooftop unit with VRF zoning for office building.\", \"qty\": 1, \"unit_price\": 85000, \"total\": 85000}]"

stage_history:
  "[{\"stage\": \"draft\", \"timestamp\": \"2026-07-24 14:36:01\", \"changed_by\": \"0d5ccc1f-772d-4015-a146-765ef98bd46c\"}]"


id: b801a29d-a6fa-47fc-93c4-50db93c0464c
company_id: 3d735c64-e5e5-4d9a-ba8a-f0fa864d1a3a
estimate_number: PH-2026-202
customer_name: High-efficiency
project_type: HVAC Upgrade
description: High-efficiency furnace and AC replacement. Heat pump option.
address: 6026 Library Ln
city: Madison
state: WI
zip_code: 53703
stage: delivered
delivered_at: 2026-07-19 14:36:01.302378
expires_at: 2026-08-16 14:36:01.302378
assigned_to: 9ad18bb3-ef0f-479f-94c9-fae5db6a5ee4
source: website
created_at: 2026-07-17 14:36:01.302378
updated_at: 2026-07-26 14:36:01.302378
line_items_json:
  "[{\"item\": \"High-efficiency furnace and AC replacement. Heat pump option.\", \"qty\": 1, \"unit_price\": 42000, \"total\": 42000}]"

stage_history:
  "[{\"stage\": \"draft\", \"timestamp\": \"2026-07-17 14:36:01\", \"changed_by\": \"9ad18bb3-ef0f-479f-94c9-fae5db6a5ee4\"}, {\"stage\": \"delivered\", \"timestamp\": \"2026-07-19 14:36:01\", \"changed_by\": \"9ad18bb3-ef0f-479f-94c9-fae5db6a5ee4\"}]"


id: 47f4bbfc-15ff-445f-b283-6c8eb121920b
company_id: 3d735c64-e5e5-4d9a-ba8a-f0fa864d1a3a
estimate_number: PH-2026-203
customer_name: Cold-climate
project_type: Heat Pump
description: Cold-climate heat pump with gas furnace backup.
address: 7027 Hearth Rd
city: Stoughton
state: WI
zip_code: 53703
stage: accepted
delivered_at: 2026-07-08 06:36:01.302378
accepted_at: 2026-07-11 14:36:01.302378
expires_at: 2026-08-05 14:36:01.302378
assigned_to: 004b70be-a3e5-43ab-90bc-a9766ce017dd
source: referral
created_at: 2026-07-06 14:36:01.302378
updated_at: 2026-07-26 14:36:01.302378
line_items_json:
  "[{\"item\": \"Cold-climate heat pump with gas furnace backup.\", \"qty\": 1, \"unit_price\": 16500, \"total\": 16500}]"

stage_history:
  "[{\"stage\": \"draft\", \"timestamp\": \"2026-07-06 14:36:01\", \"changed_by\": \"004b70be-a3e5-43ab-90bc-a9766ce017dd\"}, {\"stage\": \"delivered\", \"timestamp\": \"2026-07-08 06:36:01\", \"changed_by\": \"004b70be-a3e5-43ab-90bc-a9766ce017dd\"}, {\"stage\": \"accepted\", \"timestamp\": \"2026-07-11 14:36:01\", \"changed_by\": \"004b70be-a3e5-43ab-90bc-a9766ce017dd\"}]"


id: fd30449a-5e90-496d-961d-0b7587ca8812
company_id: 3d735c64-e5e5-4d9a-ba8a-f0fa864d1a3a
estimate_number: PH-2026-204
customer_name: Full
project_type: Commercial HVAC
description: Full HVAC overhaul for 40-room boutique hotel. Done.
address: 8028 Riverside Blvd
city: Madison
state: WI
zip_code: 53703
stage: closed
delivered_at: 2026-05-29 14:36:01.302378
accepted_at: 2026-06-10 14:36:01.302378
closed_at: 2026-07-16 14:36:01.302378
expires_at: 2026-06-16 14:36:01.302378
assigned_to: 0d5ccc1f-772d-4015-a146-765ef98bd46c
source: referral
created_at: 2026-05-17 14:36:01.302378
updated_at: 2026-07-26 14:36:01.302378
line_items_json:
  "[{\"item\": \"Full HVAC overhaul for 40-room boutique hotel. Done.\", \"qty\": 1, \"unit_price\": 95000, \"total\": 95000}]"

stage_history:
  "[{\"stage\": \"draft\", \"timestamp\": \"2026-05-17 14:36:01\", \"changed_by\": \"0d5ccc1f-772d-4015-a146-765ef98bd46c\"}, {\"stage\": \"delivered\", \"timestamp\": \"2026-05-29 14:36:01\", \"changed_by\": \"0d5ccc1f-772d-4015-a146-765ef98bd46c\"}, {\"stage\": \"accepted\", \"timestamp\": \"2026-06-10 14:36:01\", \"changed_by\": \"0d5ccc1f-772d-4015-a146-765ef98bd46c\"}, {\"stage\": \"scheduled\", \"timestamp\": \"2026-06-22 14:36:01\", \"changed_by\": \"0d5ccc1f-772d-4015-a146-765ef98bd46c\"}, {\"stage\": \"closed\", \"timestamp\": \"2026-07-16 14:36:01\", \"changed_by\": \"0d5ccc1f-772d-4015-a146-765ef98bd46c\"}]"


