Import Details

Import ID	12
Process	Claims via XLSX Upload (CLAIMSXLSX022026)
Status	Staging
Started	2/28/2026 7:54:07 PM
Completed	2/28/2026 7:54:10 PM
DocumentRecordId	45

Document

File Name	Sheet1_FY25_ClaimsImport.xlsx
Created
Link	Open Document

Worksheet Summary

Worksheet	Rows Processed	Claims Created	Warnings	Metadata	DocumentRecordId
Imported Worksheet	46	46	0	0	45

Staged Claims

Row	Claim #	Vendor	VendorId	COA	GL	Amount	Date	Status
1		City of Bellevue						Error
2		Hosted Live 3.11.2025						Error
3								Translated
4		Invoice						Error
5								Translated
6	8084	Merrick & Company	107	150	2	18755.00	10/25/2024	Translated
7	5858	Midco Diving & Marine Services		41	2	1398.11	10/31/2024	Error
8	8123	Merrick & Company	107	150	2	18295.00	12/31/2024	Translated
9	8170	Merrick & Company	107	150	2	900.00	1/31/2025	Translated
10	022125G	Idaho Power	32	122	12	34.55	2/21/2025	Translated
11	022125G	Idaho Power	32	122	11	39.21	2/21/2025	Translated
12	022125G	Idaho Power	32	122	13	180.24	2/21/2025	Translated
13	022125G	Idaho Power	32	122	11	42.11	2/21/2025	Translated
14	022125G	Idaho Power	32	122	11	105.49	2/21/2025	Translated
15	022125G	Idaho Power	32	122	11	33.28	2/21/2025	Translated
16	022125G	Idaho Power	32	122	11	3.19	2/21/2025	Translated
17	022125G	Idaho Power	32	122	11	8.77	2/21/2025	Translated
18	022125G	Idaho Power	32	122	12	26.34	2/21/2025	Translated
19	022125G	Idaho Power	32	122	12	26.34	2/21/2025	Translated
20	022125G	Idaho Power	32	122	11	27.79	2/21/2025	Translated
21	022125G	Idaho Power	32	122	13	112.83	2/21/2025	Translated
22	022125G	Idaho Power	32	122	11	29.62	2/21/2025	Translated
23	022125G	Idaho Power	32	122	11	253.79	2/21/2025	Translated
24	022125G	Idaho Power	32	122	11	2.56	2/21/2025	Translated
25	022125G	Idaho Power	32	122	11	1349.39	2/21/2025	Translated
26	022125G	Idaho Power	32	122	11	26.34	2/21/2025	Translated
27	022125G	Idaho Power	32	122	11	72.49	2/21/2025	Translated
28	225109	Forsgren Associates Inc.	23	68	11	3004.39	2/25/2025	Translated
29	43035164	Quill Corporation	53	43	5	37.18	2/26/2025	Translated
30	134722	Go-Fer It Express Inc.	27	136	3	81.90	2/28/2025	Translated
31	12687963	Idaho Mountain Express	133	24	9	60.72	2/28/2025	Translated
32	12687964	Idaho Mountain Express	133	47	5	44.16	2/28/2025	Translated
33	1000	4550McHugh Bromley Attorneys at La02/28/2025Representation in delivery calls & other water rights work 2/14/25 - 2/						Error
34	8216	Merrick & Company	107	150	2	7800.00	2/28/2025	Translated
35	214920	Napa Auto Parts	48	49	11	89.94	2/28/2025	Translated
36	0061977821	Oxarc	49	49	11	8.68	2/28/2025	Translated
37	INV0014441	Core & Main	15	41	3	278.18	3/1/2025	Translated
38	W497379	Core & Main	15	115	3	136.19	3/1/2025	Translated
39	W497773	Core & Main	15	115	3	1258.67	3/1/2025	Translated
40	02013-2025	-ICRMP		40	5	3457.72	3/1/2025	Error
41	02013-2025	-ICRMP		40	9	1747.66	3/1/2025	Error
42	02013-2025	-ICRMP		40	12	439.16	3/1/2025	Error
43	02013-2025	-ICRMP		40	13	357.14	3/1/2025	Error
44	02013-2025	-ICRMP		40	4	1345.84	3/1/2025	Error
45	02013-2025	-ICRMP		40	8	468.95	3/1/2025	Error
46	02013-2025	-ICRMP		40	6	4350.67	3/1/2025	Error

Staging Summary

Row 1 —

Vendor: City of Bellevue

Vendor Details

Vendor ID:

Raw Vendor Name: City of Bellevue

Accounting

Chart of Accounts:

GL Account:

Amount:

Claim Date:

System Status

Status: Error

Staging ID: 2050

Error Details

Vendor not found: 'City of Bellevue' (Legal='City of Bellevue', DBA=''); Unable to parse GL composite: 'Page:     1'

Raw JSON (provenance)

{
  "ClaimStagingId": 2050,
  "DataImportId": 12,
  "RowIndex": 1,
  "PageExtractionRecordId": null,
  "RawVendorName": "City of Bellevue",
  "RawChartOfAccounts": "",
  "RawGlAccount": "Page:     1",
  "RawAmount": "",
  "RawClaimDate": "",
  "RawClaimNumber": "",
  "ClaimNumber": "",
  "VendorId": null,
  "ClaimDate": null,
  "Description": "Invoices (Claims) FY26 YTD",
  "GLAccountDescription": null,
  "ChartOfAccountsId": null,
  "GeneralLedgerAccountId": null,
  "Amount": null,
  "Sequence": null,
  "ClaimType": "Invoice",
  "Status_LookupCode": "Error",
  "Priority_LookupCode": "Normal",
  "ErrorMessage": "Vendor not found: \u0027City of Bellevue\u0027 (Legal=\u0027City of Bellevue\u0027, DBA=\u0027\u0027); Unable to parse GL composite: \u0027Page:     1\u0027",
  "Note": null,
  "ProcessingNote": null,
  "CreatedAtUtc": "0001-01-01T00:00:00",
  "ClaimGroupKey": null,
  "ProcessingGroupKey": "991a3b68-dd85-49fc-b810-3a5244c6910b",
  "DocumentRecordId": 45,
  "ProcessingMessageCount": null,
  "ClaimStagingMaps": [],
  "ClaimStagingAssets": [],
  "ClaimStagingProvenanceMaps": []
}

Staging Summary

Row 2 —

Vendor: Hosted Live 3.11.2025

Vendor Details

Vendor ID:

Raw Vendor Name: Hosted Live 3.11.2025

Accounting

Chart of Accounts:

GL Account:

Amount:

Claim Date:

System Status

Status: Error

Staging ID: 2051

Error Details

Vendor not found: 'Hosted Live 3.11.2025' (Legal='Hosted Live 3.11.2025', DBA=''); Unable to parse GL composite: 'Feb 02, 2026  07:52AM'

Raw JSON (provenance)

{
  "ClaimStagingId": 2051,
  "DataImportId": 12,
  "RowIndex": 2,
  "PageExtractionRecordId": null,
  "RawVendorName": "Hosted Live 3.11.2025",
  "RawChartOfAccounts": "",
  "RawGlAccount": "Feb 02, 2026  07:52AM",
  "RawAmount": "",
  "RawClaimDate": "",
  "RawClaimNumber": "",
  "ClaimNumber": "",
  "VendorId": null,
  "ClaimDate": null,
  "Description": "Input Dates: 10/1/2024 - 9/30/2025",
  "GLAccountDescription": null,
  "ChartOfAccountsId": null,
  "GeneralLedgerAccountId": null,
  "Amount": null,
  "Sequence": null,
  "ClaimType": "Invoice",
  "Status_LookupCode": "Error",
  "Priority_LookupCode": "Normal",
  "ErrorMessage": "Vendor not found: \u0027Hosted Live 3.11.2025\u0027 (Legal=\u0027Hosted Live 3.11.2025\u0027, DBA=\u0027\u0027); Unable to parse GL composite: \u0027Feb 02, 2026  07:52AM\u0027",
  "Note": null,
  "ProcessingNote": null,
  "CreatedAtUtc": "0001-01-01T00:00:00",
  "ClaimGroupKey": null,
  "ProcessingGroupKey": "991a3b68-dd85-49fc-b810-3a5244c6910b",
  "DocumentRecordId": 45,
  "ProcessingMessageCount": null,
  "ClaimStagingMaps": [],
  "ClaimStagingAssets": [],
  "ClaimStagingProvenanceMaps": []
}

Staging Summary

Row 3 —

Vendor:

Vendor Details

Vendor ID:

Raw Vendor Name:

Accounting

Chart of Accounts:

GL Account:

Amount:

Claim Date:

System Status

Status: Translated

Staging ID: 2052

Error Details

No errors recorded.

Raw JSON (provenance)

{
  "ClaimStagingId": 2052,
  "DataImportId": 12,
  "RowIndex": 3,
  "PageExtractionRecordId": null,
  "RawVendorName": "",
  "RawChartOfAccounts": "",
  "RawGlAccount": "",
  "RawAmount": "",
  "RawClaimDate": "",
  "RawClaimNumber": "",
  "ClaimNumber": "",
  "VendorId": null,
  "ClaimDate": null,
  "Description": "",
  "GLAccountDescription": null,
  "ChartOfAccountsId": null,
  "GeneralLedgerAccountId": null,
  "Amount": null,
  "Sequence": null,
  "ClaimType": "Invoice",
  "Status_LookupCode": "Translated",
  "Priority_LookupCode": "Normal",
  "ErrorMessage": null,
  "Note": null,
  "ProcessingNote": null,
  "CreatedAtUtc": "0001-01-01T00:00:00",
  "ClaimGroupKey": null,
  "ProcessingGroupKey": "991a3b68-dd85-49fc-b810-3a5244c6910b",
  "DocumentRecordId": 45,
  "ProcessingMessageCount": null,
  "ClaimStagingMaps": [],
  "ClaimStagingAssets": [],
  "ClaimStagingProvenanceMaps": []
}

Staging Summary

Row 4 —

Vendor: Invoice

Vendor Details

Vendor ID:

Raw Vendor Name: Invoice

Accounting

Chart of Accounts:

GL Account:

Amount:

Claim Date:

System Status

Status: Error

Staging ID: 2053

Error Details

Vendor not found: 'Invoice' (Legal='Invoice', DBA=''); Unable to parse GL composite: 'Invoice Date'

Raw JSON (provenance)

{
  "ClaimStagingId": 2053,
  "DataImportId": 12,
  "RowIndex": 4,
  "PageExtractionRecordId": null,
  "RawVendorName": "Invoice",
  "RawChartOfAccounts": "",
  "RawGlAccount": "Invoice Date",
  "RawAmount": "",
  "RawClaimDate": "",
  "RawClaimNumber": "",
  "ClaimNumber": "",
  "VendorId": null,
  "ClaimDate": null,
  "Description": "Merchant Name",
  "GLAccountDescription": null,
  "ChartOfAccountsId": null,
  "GeneralLedgerAccountId": null,
  "Amount": null,
  "Sequence": null,
  "ClaimType": "Invoice",
  "Status_LookupCode": "Error",
  "Priority_LookupCode": "Normal",
  "ErrorMessage": "Vendor not found: \u0027Invoice\u0027 (Legal=\u0027Invoice\u0027, DBA=\u0027\u0027); Unable to parse GL composite: \u0027Invoice Date\u0027",
  "Note": null,
  "ProcessingNote": null,
  "CreatedAtUtc": "0001-01-01T00:00:00",
  "ClaimGroupKey": null,
  "ProcessingGroupKey": "991a3b68-dd85-49fc-b810-3a5244c6910b",
  "DocumentRecordId": 45,
  "ProcessingMessageCount": null,
  "ClaimStagingMaps": [],
  "ClaimStagingAssets": [],
  "ClaimStagingProvenanceMaps": []
}

Staging Summary

Row 5 —

Vendor:

Vendor Details

Vendor ID:

Raw Vendor Name:

Accounting

Chart of Accounts:

GL Account:

Amount:

Claim Date:

System Status

Status: Translated

Staging ID: 2054

Error Details

No errors recorded.

Raw JSON (provenance)

{
  "ClaimStagingId": 2054,
  "DataImportId": 12,
  "RowIndex": 5,
  "PageExtractionRecordId": null,
  "RawVendorName": "",
  "RawChartOfAccounts": "",
  "RawGlAccount": "",
  "RawAmount": "",
  "RawClaimDate": "",
  "RawClaimNumber": "",
  "ClaimNumber": "",
  "VendorId": null,
  "ClaimDate": null,
  "Description": "",
  "GLAccountDescription": null,
  "ChartOfAccountsId": null,
  "GeneralLedgerAccountId": null,
  "Amount": null,
  "Sequence": null,
  "ClaimType": "Invoice",
  "Status_LookupCode": "Translated",
  "Priority_LookupCode": "Normal",
  "ErrorMessage": null,
  "Note": null,
  "ProcessingNote": null,
  "CreatedAtUtc": "0001-01-01T00:00:00",
  "ClaimGroupKey": null,
  "ProcessingGroupKey": "991a3b68-dd85-49fc-b810-3a5244c6910b",
  "DocumentRecordId": 45,
  "ProcessingMessageCount": null,
  "ClaimStagingMaps": [],
  "ClaimStagingAssets": [],
  "ClaimStagingProvenanceMaps": []
}

Staging Summary

Row 6 — 8084

Vendor: Merrick & Company

Vendor Details

Vendor ID: 107

Raw Vendor Name: Merrick & Company

Accounting

Chart of Accounts: 150

GL Account: 2

Amount: 18755.00

Claim Date: 10/25/2024

System Status

Status: Translated

Staging ID: 2055

Error Details

No errors recorded.

Raw JSON (provenance)

{
  "ClaimStagingId": 2055,
  "DataImportId": 12,
  "RowIndex": 6,
  "PageExtractionRecordId": null,
  "RawVendorName": "Merrick \u0026 Company",
  "RawChartOfAccounts": "",
  "RawGlAccount": "200-20-58125",
  "RawAmount": "18,755.00",
  "RawClaimDate": "10/25/2024",
  "RawClaimNumber": "8084",
  "ClaimNumber": "8084",
  "VendorId": 107,
  "ClaimDate": "2024-10-25",
  "Description": "Drinking Water System Project",
  "GLAccountDescription": null,
  "ChartOfAccountsId": 150,
  "GeneralLedgerAccountId": 2,
  "Amount": 18755.00,
  "Sequence": null,
  "ClaimType": "Invoice",
  "Status_LookupCode": "Translated",
  "Priority_LookupCode": "Normal",
  "ErrorMessage": null,
  "Note": null,
  "ProcessingNote": null,
  "CreatedAtUtc": "0001-01-01T00:00:00",
  "ClaimGroupKey": null,
  "ProcessingGroupKey": "991a3b68-dd85-49fc-b810-3a5244c6910b",
  "DocumentRecordId": 45,
  "ProcessingMessageCount": null,
  "ClaimStagingMaps": [],
  "ClaimStagingAssets": [],
  "ClaimStagingProvenanceMaps": []
}

Staging Summary

Row 7 — 5858

Vendor: Midco Diving & Marine Services

Vendor Details

Vendor ID:

Raw Vendor Name: Midco Diving & Marine Services

Accounting

Chart of Accounts: 41

GL Account: 2

Amount: 1398.11

Claim Date: 10/31/2024

System Status

Status: Error

Staging ID: 2056

Error Details

Vendor not found: 'Midco Diving & Marine Services' (Legal='Midco Diving & Marine Services', DBA='')

Raw JSON (provenance)

{
  "ClaimStagingId": 2056,
  "DataImportId": 12,
  "RowIndex": 7,
  "PageExtractionRecordId": null,
  "RawVendorName": "Midco Diving \u0026 Marine Services",
  "RawChartOfAccounts": "",
  "RawGlAccount": "200-20-51160",
  "RawAmount": "1,398.11",
  "RawClaimDate": "10/31/2024",
  "RawClaimNumber": "5858",
  "ClaimNumber": "5858",
  "VendorId": null,
  "ClaimDate": "2024-10-31",
  "Description": "Trip Charge - Scheduled to clean water tank, but discharge not viabl",
  "GLAccountDescription": null,
  "ChartOfAccountsId": 41,
  "GeneralLedgerAccountId": 2,
  "Amount": 1398.11,
  "Sequence": null,
  "ClaimType": "Invoice",
  "Status_LookupCode": "Error",
  "Priority_LookupCode": "Normal",
  "ErrorMessage": "Vendor not found: \u0027Midco Diving \u0026 Marine Services\u0027 (Legal=\u0027Midco Diving \u0026 Marine Services\u0027, DBA=\u0027\u0027)",
  "Note": null,
  "ProcessingNote": null,
  "CreatedAtUtc": "0001-01-01T00:00:00",
  "ClaimGroupKey": null,
  "ProcessingGroupKey": "991a3b68-dd85-49fc-b810-3a5244c6910b",
  "DocumentRecordId": 45,
  "ProcessingMessageCount": null,
  "ClaimStagingMaps": [],
  "ClaimStagingAssets": [],
  "ClaimStagingProvenanceMaps": []
}

Staging Summary

Row 8 — 8123

Vendor: Merrick & Company

Vendor Details

Vendor ID: 107

Raw Vendor Name: Merrick & Company

Accounting

Chart of Accounts: 150

GL Account: 2

Amount: 18295.00

Claim Date: 12/31/2024

System Status

Status: Translated

Staging ID: 2057

Error Details

No errors recorded.

Raw JSON (provenance)

{
  "ClaimStagingId": 2057,
  "DataImportId": 12,
  "RowIndex": 8,
  "PageExtractionRecordId": null,
  "RawVendorName": "Merrick \u0026 Company",
  "RawChartOfAccounts": "",
  "RawGlAccount": "200-20-58125",
  "RawAmount": "18,295.00",
  "RawClaimDate": "12/31/2024",
  "RawClaimNumber": "8123",
  "ClaimNumber": "8123",
  "VendorId": 107,
  "ClaimDate": "2024-12-31",
  "Description": "Drinking Water System Project",
  "GLAccountDescription": null,
  "ChartOfAccountsId": 150,
  "GeneralLedgerAccountId": 2,
  "Amount": 18295.00,
  "Sequence": null,
  "ClaimType": "Invoice",
  "Status_LookupCode": "Translated",
  "Priority_LookupCode": "Normal",
  "ErrorMessage": null,
  "Note": null,
  "ProcessingNote": null,
  "CreatedAtUtc": "0001-01-01T00:00:00",
  "ClaimGroupKey": null,
  "ProcessingGroupKey": "991a3b68-dd85-49fc-b810-3a5244c6910b",
  "DocumentRecordId": 45,
  "ProcessingMessageCount": null,
  "ClaimStagingMaps": [],
  "ClaimStagingAssets": [],
  "ClaimStagingProvenanceMaps": []
}

Staging Summary

Row 9 — 8170

Vendor: Merrick & Company

Vendor Details

Vendor ID: 107

Raw Vendor Name: Merrick & Company

Accounting

Chart of Accounts: 150

GL Account: 2

Amount: 900.00

Claim Date: 1/31/2025

System Status

Status: Translated

Staging ID: 2058

Error Details

No errors recorded.

Raw JSON (provenance)

{
  "ClaimStagingId": 2058,
  "DataImportId": 12,
  "RowIndex": 9,
  "PageExtractionRecordId": null,
  "RawVendorName": "Merrick \u0026 Company",
  "RawChartOfAccounts": "",
  "RawGlAccount": "200-20-58125",
  "RawAmount": "900.00",
  "RawClaimDate": "01/31/2025",
  "RawClaimNumber": "8170",
  "ClaimNumber": "8170",
  "VendorId": 107,
  "ClaimDate": "2025-01-31",
  "Description": "Drinking Water System Project",
  "GLAccountDescription": null,
  "ChartOfAccountsId": 150,
  "GeneralLedgerAccountId": 2,
  "Amount": 900.00,
  "Sequence": null,
  "ClaimType": "Invoice",
  "Status_LookupCode": "Translated",
  "Priority_LookupCode": "Normal",
  "ErrorMessage": null,
  "Note": null,
  "ProcessingNote": null,
  "CreatedAtUtc": "0001-01-01T00:00:00",
  "ClaimGroupKey": null,
  "ProcessingGroupKey": "991a3b68-dd85-49fc-b810-3a5244c6910b",
  "DocumentRecordId": 45,
  "ProcessingMessageCount": null,
  "ClaimStagingMaps": [],
  "ClaimStagingAssets": [],
  "ClaimStagingProvenanceMaps": []
}

Staging Summary

Row 10 — 022125G

Vendor: Idaho Power

Vendor Details

Vendor ID: 32

Raw Vendor Name: Idaho Power

Accounting

Chart of Accounts: 122

GL Account: 12

Amount: 34.55

Claim Date: 2/21/2025

System Status

Status: Translated

Staging ID: 2059

Error Details

No errors recorded.

Raw JSON (provenance)

{
  "ClaimStagingId": 2059,
  "DataImportId": 12,
  "RowIndex": 10,
  "PageExtractionRecordId": null,
  "RawVendorName": "Idaho Power",
  "RawChartOfAccounts": "",
  "RawGlAccount": "100-04-52143",
  "RawAmount": "34.55",
  "RawClaimDate": "02/21/2025",
  "RawClaimNumber": "022125G",
  "ClaimNumber": "022125G",
  "VendorId": 32,
  "ClaimDate": "2025-02-21",
  "Description": "100 N 8th St Park",
  "GLAccountDescription": null,
  "ChartOfAccountsId": 122,
  "GeneralLedgerAccountId": 12,
  "Amount": 34.55,
  "Sequence": null,
  "ClaimType": "Invoice",
  "Status_LookupCode": "Translated",
  "Priority_LookupCode": "Normal",
  "ErrorMessage": null,
  "Note": null,
  "ProcessingNote": null,
  "CreatedAtUtc": "0001-01-01T00:00:00",
  "ClaimGroupKey": null,
  "ProcessingGroupKey": "991a3b68-dd85-49fc-b810-3a5244c6910b",
  "DocumentRecordId": 45,
  "ProcessingMessageCount": null,
  "ClaimStagingMaps": [],
  "ClaimStagingAssets": [],
  "ClaimStagingProvenanceMaps": []
}

Staging Summary

Row 11 — 022125G

Vendor: Idaho Power

Vendor Details

Vendor ID: 32

Raw Vendor Name: Idaho Power

Accounting

Chart of Accounts: 122

GL Account: 11

Amount: 39.21

Claim Date: 2/21/2025

System Status

Status: Translated

Staging ID: 2060

Error Details

No errors recorded.

Raw JSON (provenance)

{
  "ClaimStagingId": 2060,
  "DataImportId": 12,
  "RowIndex": 11,
  "PageExtractionRecordId": null,
  "RawVendorName": "Idaho Power",
  "RawChartOfAccounts": "",
  "RawGlAccount": "100-10-52143",
  "RawAmount": "39.21",
  "RawClaimDate": "02/21/2025",
  "RawClaimNumber": "022125G",
  "ClaimNumber": "022125G",
  "VendorId": 32,
  "ClaimDate": "2025-02-21",
  "Description": "114 Elm St.",
  "GLAccountDescription": null,
  "ChartOfAccountsId": 122,
  "GeneralLedgerAccountId": 11,
  "Amount": 39.21,
  "Sequence": null,
  "ClaimType": "Invoice",
  "Status_LookupCode": "Translated",
  "Priority_LookupCode": "Normal",
  "ErrorMessage": null,
  "Note": null,
  "ProcessingNote": null,
  "CreatedAtUtc": "0001-01-01T00:00:00",
  "ClaimGroupKey": null,
  "ProcessingGroupKey": "991a3b68-dd85-49fc-b810-3a5244c6910b",
  "DocumentRecordId": 45,
  "ProcessingMessageCount": null,
  "ClaimStagingMaps": [],
  "ClaimStagingAssets": [],
  "ClaimStagingProvenanceMaps": []
}

Staging Summary

Row 12 — 022125G

Vendor: Idaho Power

Vendor Details

Vendor ID: 32

Raw Vendor Name: Idaho Power

Accounting

Chart of Accounts: 122

GL Account: 13

Amount: 180.24

Claim Date: 2/21/2025

System Status

Status: Translated

Staging ID: 2061

Error Details

No errors recorded.

Raw JSON (provenance)

{
  "ClaimStagingId": 2061,
  "DataImportId": 12,
  "RowIndex": 12,
  "PageExtractionRecordId": null,
  "RawVendorName": "Idaho Power",
  "RawChartOfAccounts": "",
  "RawGlAccount": "100-09-52143",
  "RawAmount": "180.24",
  "RawClaimDate": "02/21/2025",
  "RawClaimNumber": "022125G",
  "ClaimNumber": "022125G",
  "VendorId": 32,
  "ClaimDate": "2025-02-21",
  "Description": "115 Pine St.",
  "GLAccountDescription": null,
  "ChartOfAccountsId": 122,
  "GeneralLedgerAccountId": 13,
  "Amount": 180.24,
  "Sequence": null,
  "ClaimType": "Invoice",
  "Status_LookupCode": "Translated",
  "Priority_LookupCode": "Normal",
  "ErrorMessage": null,
  "Note": null,
  "ProcessingNote": null,
  "CreatedAtUtc": "0001-01-01T00:00:00",
  "ClaimGroupKey": null,
  "ProcessingGroupKey": "991a3b68-dd85-49fc-b810-3a5244c6910b",
  "DocumentRecordId": 45,
  "ProcessingMessageCount": null,
  "ClaimStagingMaps": [],
  "ClaimStagingAssets": [],
  "ClaimStagingProvenanceMaps": []
}

Staging Summary

Row 13 — 022125G

Vendor: Idaho Power

Vendor Details

Vendor ID: 32

Raw Vendor Name: Idaho Power

Accounting

Chart of Accounts: 122

GL Account: 11

Amount: 42.11

Claim Date: 2/21/2025

System Status

Status: Translated

Staging ID: 2062

Error Details

No errors recorded.

Raw JSON (provenance)

{
  "ClaimStagingId": 2062,
  "DataImportId": 12,
  "RowIndex": 13,
  "PageExtractionRecordId": null,
  "RawVendorName": "Idaho Power",
  "RawChartOfAccounts": "",
  "RawGlAccount": "100-10-52143",
  "RawAmount": "42.11",
  "RawClaimDate": "02/21/2025",
  "RawClaimNumber": "022125G",
  "ClaimNumber": "022125G",
  "VendorId": 32,
  "ClaimDate": "2025-02-21",
  "Description": "116 Pine St.",
  "GLAccountDescription": null,
  "ChartOfAccountsId": 122,
  "GeneralLedgerAccountId": 11,
  "Amount": 42.11,
  "Sequence": null,
  "ClaimType": "Invoice",
  "Status_LookupCode": "Translated",
  "Priority_LookupCode": "Normal",
  "ErrorMessage": null,
  "Note": null,
  "ProcessingNote": null,
  "CreatedAtUtc": "0001-01-01T00:00:00",
  "ClaimGroupKey": null,
  "ProcessingGroupKey": "991a3b68-dd85-49fc-b810-3a5244c6910b",
  "DocumentRecordId": 45,
  "ProcessingMessageCount": null,
  "ClaimStagingMaps": [],
  "ClaimStagingAssets": [],
  "ClaimStagingProvenanceMaps": []
}

Staging Summary

Row 14 — 022125G

Vendor: Idaho Power

Vendor Details

Vendor ID: 32

Raw Vendor Name: Idaho Power

Accounting

Chart of Accounts: 122

GL Account: 11

Amount: 105.49

Claim Date: 2/21/2025

System Status

Status: Translated

Staging ID: 2063

Error Details

No errors recorded.

Raw JSON (provenance)

{
  "ClaimStagingId": 2063,
  "DataImportId": 12,
  "RowIndex": 14,
  "PageExtractionRecordId": null,
  "RawVendorName": "Idaho Power",
  "RawChartOfAccounts": "",
  "RawGlAccount": "100-10-52143",
  "RawAmount": "105.49",
  "RawClaimDate": "02/21/2025",
  "RawClaimNumber": "022125G",
  "ClaimNumber": "022125G",
  "VendorId": 32,
  "ClaimDate": "2025-02-21",
  "Description": "117 Pine St.",
  "GLAccountDescription": null,
  "ChartOfAccountsId": 122,
  "GeneralLedgerAccountId": 11,
  "Amount": 105.49,
  "Sequence": null,
  "ClaimType": "Invoice",
  "Status_LookupCode": "Translated",
  "Priority_LookupCode": "Normal",
  "ErrorMessage": null,
  "Note": null,
  "ProcessingNote": null,
  "CreatedAtUtc": "0001-01-01T00:00:00",
  "ClaimGroupKey": null,
  "ProcessingGroupKey": "991a3b68-dd85-49fc-b810-3a5244c6910b",
  "DocumentRecordId": 45,
  "ProcessingMessageCount": null,
  "ClaimStagingMaps": [],
  "ClaimStagingAssets": [],
  "ClaimStagingProvenanceMaps": []
}

Staging Summary

Row 15 — 022125G

Vendor: Idaho Power

Vendor Details

Vendor ID: 32

Raw Vendor Name: Idaho Power

Accounting

Chart of Accounts: 122

GL Account: 11

Amount: 33.28

Claim Date: 2/21/2025

System Status

Status: Translated

Staging ID: 2064

Error Details

No errors recorded.

Raw JSON (provenance)

{
  "ClaimStagingId": 2064,
  "DataImportId": 12,
  "RowIndex": 15,
  "PageExtractionRecordId": null,
  "RawVendorName": "Idaho Power",
  "RawChartOfAccounts": "",
  "RawGlAccount": "100-10-52143",
  "RawAmount": "33.28",
  "RawClaimDate": "02/21/2025",
  "RawClaimNumber": "022125G",
  "ClaimNumber": "022125G",
  "VendorId": 32,
  "ClaimDate": "2025-02-21",
  "Description": "1461 S. Main",
  "GLAccountDescription": null,
  "ChartOfAccountsId": 122,
  "GeneralLedgerAccountId": 11,
  "Amount": 33.28,
  "Sequence": null,
  "ClaimType": "Invoice",
  "Status_LookupCode": "Translated",
  "Priority_LookupCode": "Normal",
  "ErrorMessage": null,
  "Note": null,
  "ProcessingNote": null,
  "CreatedAtUtc": "0001-01-01T00:00:00",
  "ClaimGroupKey": null,
  "ProcessingGroupKey": "991a3b68-dd85-49fc-b810-3a5244c6910b",
  "DocumentRecordId": 45,
  "ProcessingMessageCount": null,
  "ClaimStagingMaps": [],
  "ClaimStagingAssets": [],
  "ClaimStagingProvenanceMaps": []
}

Staging Summary

Row 16 — 022125G

Vendor: Idaho Power

Vendor Details

Vendor ID: 32

Raw Vendor Name: Idaho Power

Accounting

Chart of Accounts: 122

GL Account: 11

Amount: 3.19

Claim Date: 2/21/2025

System Status

Status: Translated

Staging ID: 2065

Error Details

No errors recorded.

Raw JSON (provenance)

{
  "ClaimStagingId": 2065,
  "DataImportId": 12,
  "RowIndex": 16,
  "PageExtractionRecordId": null,
  "RawVendorName": "Idaho Power",
  "RawChartOfAccounts": "",
  "RawGlAccount": "100-10-52143",
  "RawAmount": "3.19",
  "RawClaimDate": "02/21/2025",
  "RawClaimNumber": "022125G",
  "ClaimNumber": "022125G",
  "VendorId": 32,
  "ClaimDate": "2025-02-21",
  "Description": "161 Cowcatcher Loop",
  "GLAccountDescription": null,
  "ChartOfAccountsId": 122,
  "GeneralLedgerAccountId": 11,
  "Amount": 3.19,
  "Sequence": null,
  "ClaimType": "Invoice",
  "Status_LookupCode": "Translated",
  "Priority_LookupCode": "Normal",
  "ErrorMessage": null,
  "Note": null,
  "ProcessingNote": null,
  "CreatedAtUtc": "0001-01-01T00:00:00",
  "ClaimGroupKey": null,
  "ProcessingGroupKey": "991a3b68-dd85-49fc-b810-3a5244c6910b",
  "DocumentRecordId": 45,
  "ProcessingMessageCount": null,
  "ClaimStagingMaps": [],
  "ClaimStagingAssets": [],
  "ClaimStagingProvenanceMaps": []
}

Staging Summary

Row 17 — 022125G

Vendor: Idaho Power

Vendor Details

Vendor ID: 32

Raw Vendor Name: Idaho Power

Accounting

Chart of Accounts: 122

GL Account: 11

Amount: 8.77

Claim Date: 2/21/2025

System Status

Status: Translated

Staging ID: 2066

Error Details

No errors recorded.

Raw JSON (provenance)

{
  "ClaimStagingId": 2066,
  "DataImportId": 12,
  "RowIndex": 17,
  "PageExtractionRecordId": null,
  "RawVendorName": "Idaho Power",
  "RawChartOfAccounts": "",
  "RawGlAccount": "100-10-52143",
  "RawAmount": "8.77",
  "RawClaimDate": "02/21/2025",
  "RawClaimNumber": "022125G",
  "ClaimNumber": "022125G",
  "VendorId": 32,
  "ClaimDate": "2025-02-21",
  "Description": "206 N Main St.",
  "GLAccountDescription": null,
  "ChartOfAccountsId": 122,
  "GeneralLedgerAccountId": 11,
  "Amount": 8.77,
  "Sequence": null,
  "ClaimType": "Invoice",
  "Status_LookupCode": "Translated",
  "Priority_LookupCode": "Normal",
  "ErrorMessage": null,
  "Note": null,
  "ProcessingNote": null,
  "CreatedAtUtc": "0001-01-01T00:00:00",
  "ClaimGroupKey": null,
  "ProcessingGroupKey": "991a3b68-dd85-49fc-b810-3a5244c6910b",
  "DocumentRecordId": 45,
  "ProcessingMessageCount": null,
  "ClaimStagingMaps": [],
  "ClaimStagingAssets": [],
  "ClaimStagingProvenanceMaps": []
}

Staging Summary

Row 18 — 022125G

Vendor: Idaho Power

Vendor Details

Vendor ID: 32

Raw Vendor Name: Idaho Power

Accounting

Chart of Accounts: 122

GL Account: 12

Amount: 26.34

Claim Date: 2/21/2025

System Status

Status: Translated

Staging ID: 2067

Error Details

No errors recorded.

Raw JSON (provenance)

{
  "ClaimStagingId": 2067,
  "DataImportId": 12,
  "RowIndex": 18,
  "PageExtractionRecordId": null,
  "RawVendorName": "Idaho Power",
  "RawChartOfAccounts": "",
  "RawGlAccount": "100-04-52143",
  "RawAmount": "26.34",
  "RawClaimDate": "02/21/2025",
  "RawClaimNumber": "022125G",
  "ClaimNumber": "022125G",
  "VendorId": 32,
  "ClaimDate": "2025-02-21",
  "Description": "300 E Cedar St.",
  "GLAccountDescription": null,
  "ChartOfAccountsId": 122,
  "GeneralLedgerAccountId": 12,
  "Amount": 26.34,
  "Sequence": null,
  "ClaimType": "Invoice",
  "Status_LookupCode": "Translated",
  "Priority_LookupCode": "Normal",
  "ErrorMessage": null,
  "Note": null,
  "ProcessingNote": null,
  "CreatedAtUtc": "0001-01-01T00:00:00",
  "ClaimGroupKey": null,
  "ProcessingGroupKey": "991a3b68-dd85-49fc-b810-3a5244c6910b",
  "DocumentRecordId": 45,
  "ProcessingMessageCount": null,
  "ClaimStagingMaps": [],
  "ClaimStagingAssets": [],
  "ClaimStagingProvenanceMaps": []
}

Staging Summary

Row 19 — 022125G

Vendor: Idaho Power

Vendor Details

Vendor ID: 32

Raw Vendor Name: Idaho Power

Accounting

Chart of Accounts: 122

GL Account: 12

Amount: 26.34

Claim Date: 2/21/2025

System Status

Status: Translated

Staging ID: 2068

Error Details

No errors recorded.

Raw JSON (provenance)

{
  "ClaimStagingId": 2068,
  "DataImportId": 12,
  "RowIndex": 19,
  "PageExtractionRecordId": null,
  "RawVendorName": "Idaho Power",
  "RawChartOfAccounts": "",
  "RawGlAccount": "100-04-52143",
  "RawAmount": "26.34",
  "RawClaimDate": "02/21/2025",
  "RawClaimNumber": "022125G",
  "ClaimNumber": "022125G",
  "VendorId": 32,
  "ClaimDate": "2025-02-21",
  "Description": "318 E Cedar St",
  "GLAccountDescription": null,
  "ChartOfAccountsId": 122,
  "GeneralLedgerAccountId": 12,
  "Amount": 26.34,
  "Sequence": null,
  "ClaimType": "Invoice",
  "Status_LookupCode": "Translated",
  "Priority_LookupCode": "Normal",
  "ErrorMessage": null,
  "Note": null,
  "ProcessingNote": null,
  "CreatedAtUtc": "0001-01-01T00:00:00",
  "ClaimGroupKey": null,
  "ProcessingGroupKey": "991a3b68-dd85-49fc-b810-3a5244c6910b",
  "DocumentRecordId": 45,
  "ProcessingMessageCount": null,
  "ClaimStagingMaps": [],
  "ClaimStagingAssets": [],
  "ClaimStagingProvenanceMaps": []
}

Staging Summary

Row 20 — 022125G

Vendor: Idaho Power

Vendor Details

Vendor ID: 32

Raw Vendor Name: Idaho Power

Accounting

Chart of Accounts: 122

GL Account: 11

Amount: 27.79

Claim Date: 2/21/2025

System Status

Status: Translated

Staging ID: 2069

Error Details

No errors recorded.

Raw JSON (provenance)

{
  "ClaimStagingId": 2069,
  "DataImportId": 12,
  "RowIndex": 20,
  "PageExtractionRecordId": null,
  "RawVendorName": "Idaho Power",
  "RawChartOfAccounts": "",
  "RawGlAccount": "100-10-52143",
  "RawAmount": "27.79",
  "RawClaimDate": "02/21/2025",
  "RawClaimNumber": "022125G",
  "ClaimNumber": "022125G",
  "VendorId": 32,
  "ClaimDate": "2025-02-21",
  "Description": "508 Broadford Rd",
  "GLAccountDescription": null,
  "ChartOfAccountsId": 122,
  "GeneralLedgerAccountId": 11,
  "Amount": 27.79,
  "Sequence": null,
  "ClaimType": "Invoice",
  "Status_LookupCode": "Translated",
  "Priority_LookupCode": "Normal",
  "ErrorMessage": null,
  "Note": null,
  "ProcessingNote": null,
  "CreatedAtUtc": "0001-01-01T00:00:00",
  "ClaimGroupKey": null,
  "ProcessingGroupKey": "991a3b68-dd85-49fc-b810-3a5244c6910b",
  "DocumentRecordId": 45,
  "ProcessingMessageCount": null,
  "ClaimStagingMaps": [],
  "ClaimStagingAssets": [],
  "ClaimStagingProvenanceMaps": []
}

Staging Summary

Row 21 — 022125G

Vendor: Idaho Power

Vendor Details

Vendor ID: 32

Raw Vendor Name: Idaho Power

Accounting

Chart of Accounts: 122

GL Account: 13

Amount: 112.83

Claim Date: 2/21/2025

System Status

Status: Translated

Staging ID: 2070

Error Details

No errors recorded.

Raw JSON (provenance)

{
  "ClaimStagingId": 2070,
  "DataImportId": 12,
  "RowIndex": 21,
  "PageExtractionRecordId": null,
  "RawVendorName": "Idaho Power",
  "RawChartOfAccounts": "",
  "RawGlAccount": "100-09-52143",
  "RawAmount": "112.83",
  "RawClaimDate": "02/21/2025",
  "RawClaimNumber": "022125G",
  "ClaimNumber": "022125G",
  "VendorId": 32,
  "ClaimDate": "2025-02-21",
  "Description": "517 N 2nd St",
  "GLAccountDescription": null,
  "ChartOfAccountsId": 122,
  "GeneralLedgerAccountId": 13,
  "Amount": 112.83,
  "Sequence": null,
  "ClaimType": "Invoice",
  "Status_LookupCode": "Translated",
  "Priority_LookupCode": "Normal",
  "ErrorMessage": null,
  "Note": null,
  "ProcessingNote": null,
  "CreatedAtUtc": "0001-01-01T00:00:00",
  "ClaimGroupKey": null,
  "ProcessingGroupKey": "991a3b68-dd85-49fc-b810-3a5244c6910b",
  "DocumentRecordId": 45,
  "ProcessingMessageCount": null,
  "ClaimStagingMaps": [],
  "ClaimStagingAssets": [],
  "ClaimStagingProvenanceMaps": []
}

Staging Summary

Row 22 — 022125G

Vendor: Idaho Power

Vendor Details

Vendor ID: 32

Raw Vendor Name: Idaho Power

Accounting

Chart of Accounts: 122

GL Account: 11

Amount: 29.62

Claim Date: 2/21/2025

System Status

Status: Translated

Staging ID: 2071

Error Details

No errors recorded.

Raw JSON (provenance)

{
  "ClaimStagingId": 2071,
  "DataImportId": 12,
  "RowIndex": 22,
  "PageExtractionRecordId": null,
  "RawVendorName": "Idaho Power",
  "RawChartOfAccounts": "",
  "RawGlAccount": "100-10-52143",
  "RawAmount": "29.62",
  "RawClaimDate": "02/21/2025",
  "RawClaimNumber": "022125G",
  "ClaimNumber": "022125G",
  "VendorId": 32,
  "ClaimDate": "2025-02-21",
  "Description": "714 N Main St",
  "GLAccountDescription": null,
  "ChartOfAccountsId": 122,
  "GeneralLedgerAccountId": 11,
  "Amount": 29.62,
  "Sequence": null,
  "ClaimType": "Invoice",
  "Status_LookupCode": "Translated",
  "Priority_LookupCode": "Normal",
  "ErrorMessage": null,
  "Note": null,
  "ProcessingNote": null,
  "CreatedAtUtc": "0001-01-01T00:00:00",
  "ClaimGroupKey": null,
  "ProcessingGroupKey": "991a3b68-dd85-49fc-b810-3a5244c6910b",
  "DocumentRecordId": 45,
  "ProcessingMessageCount": null,
  "ClaimStagingMaps": [],
  "ClaimStagingAssets": [],
  "ClaimStagingProvenanceMaps": []
}

Staging Summary

Row 23 — 022125G

Vendor: Idaho Power

Vendor Details

Vendor ID: 32

Raw Vendor Name: Idaho Power

Accounting

Chart of Accounts: 122

GL Account: 11

Amount: 253.79

Claim Date: 2/21/2025

System Status

Status: Translated

Staging ID: 2072

Error Details

No errors recorded.

Raw JSON (provenance)

{
  "ClaimStagingId": 2072,
  "DataImportId": 12,
  "RowIndex": 23,
  "PageExtractionRecordId": null,
  "RawVendorName": "Idaho Power",
  "RawChartOfAccounts": "",
  "RawGlAccount": "100-10-52143",
  "RawAmount": "253.79",
  "RawClaimDate": "02/21/2025",
  "RawClaimNumber": "022125G",
  "ClaimNumber": "022125G",
  "VendorId": 32,
  "ClaimDate": "2025-02-21",
  "Description": "89 Martin Ln Shop",
  "GLAccountDescription": null,
  "ChartOfAccountsId": 122,
  "GeneralLedgerAccountId": 11,
  "Amount": 253.79,
  "Sequence": null,
  "ClaimType": "Invoice",
  "Status_LookupCode": "Translated",
  "Priority_LookupCode": "Normal",
  "ErrorMessage": null,
  "Note": null,
  "ProcessingNote": null,
  "CreatedAtUtc": "0001-01-01T00:00:00",
  "ClaimGroupKey": null,
  "ProcessingGroupKey": "991a3b68-dd85-49fc-b810-3a5244c6910b",
  "DocumentRecordId": 45,
  "ProcessingMessageCount": null,
  "ClaimStagingMaps": [],
  "ClaimStagingAssets": [],
  "ClaimStagingProvenanceMaps": []
}

Staging Summary

Row 24 — 022125G

Vendor: Idaho Power

Vendor Details

Vendor ID: 32

Raw Vendor Name: Idaho Power

Accounting

Chart of Accounts: 122

GL Account: 11

Amount: 2.56

Claim Date: 2/21/2025

System Status

Status: Translated

Staging ID: 2073

Error Details

No errors recorded.

Raw JSON (provenance)

{
  "ClaimStagingId": 2073,
  "DataImportId": 12,
  "RowIndex": 24,
  "PageExtractionRecordId": null,
  "RawVendorName": "Idaho Power",
  "RawChartOfAccounts": "",
  "RawGlAccount": "100-10-52143",
  "RawAmount": "2.56",
  "RawClaimDate": "02/21/2025",
  "RawClaimNumber": "022125G",
  "ClaimNumber": "022125G",
  "VendorId": 32,
  "ClaimDate": "2025-02-21",
  "Description": "921 Riverside Dr.",
  "GLAccountDescription": null,
  "ChartOfAccountsId": 122,
  "GeneralLedgerAccountId": 11,
  "Amount": 2.56,
  "Sequence": null,
  "ClaimType": "Invoice",
  "Status_LookupCode": "Translated",
  "Priority_LookupCode": "Normal",
  "ErrorMessage": null,
  "Note": null,
  "ProcessingNote": null,
  "CreatedAtUtc": "0001-01-01T00:00:00",
  "ClaimGroupKey": null,
  "ProcessingGroupKey": "991a3b68-dd85-49fc-b810-3a5244c6910b",
  "DocumentRecordId": 45,
  "ProcessingMessageCount": null,
  "ClaimStagingMaps": [],
  "ClaimStagingAssets": [],
  "ClaimStagingProvenanceMaps": []
}

Staging Summary

Row 25 — 022125G

Vendor: Idaho Power

Vendor Details

Vendor ID: 32

Raw Vendor Name: Idaho Power

Accounting

Chart of Accounts: 122

GL Account: 11

Amount: 1349.39

Claim Date: 2/21/2025

System Status

Status: Translated

Staging ID: 2074

Error Details

No errors recorded.

Raw JSON (provenance)

{
  "ClaimStagingId": 2074,
  "DataImportId": 12,
  "RowIndex": 25,
  "PageExtractionRecordId": null,
  "RawVendorName": "Idaho Power",
  "RawChartOfAccounts": "",
  "RawGlAccount": "100-10-52143",
  "RawAmount": "1,349.39",
  "RawClaimDate": "02/21/2025",
  "RawClaimNumber": "022125G",
  "ClaimNumber": "022125G",
  "VendorId": 32,
  "ClaimDate": "2025-02-21",
  "Description": "IP Lights",
  "GLAccountDescription": null,
  "ChartOfAccountsId": 122,
  "GeneralLedgerAccountId": 11,
  "Amount": 1349.39,
  "Sequence": null,
  "ClaimType": "Invoice",
  "Status_LookupCode": "Translated",
  "Priority_LookupCode": "Normal",
  "ErrorMessage": null,
  "Note": null,
  "ProcessingNote": null,
  "CreatedAtUtc": "0001-01-01T00:00:00",
  "ClaimGroupKey": null,
  "ProcessingGroupKey": "991a3b68-dd85-49fc-b810-3a5244c6910b",
  "DocumentRecordId": 45,
  "ProcessingMessageCount": null,
  "ClaimStagingMaps": [],
  "ClaimStagingAssets": [],
  "ClaimStagingProvenanceMaps": []
}

Staging Summary

Row 26 — 022125G

Vendor: Idaho Power

Vendor Details

Vendor ID: 32

Raw Vendor Name: Idaho Power

Accounting

Chart of Accounts: 122

GL Account: 11

Amount: 26.34

Claim Date: 2/21/2025

System Status

Status: Translated

Staging ID: 2075

Error Details

No errors recorded.

Raw JSON (provenance)

{
  "ClaimStagingId": 2075,
  "DataImportId": 12,
  "RowIndex": 26,
  "PageExtractionRecordId": null,
  "RawVendorName": "Idaho Power",
  "RawChartOfAccounts": "",
  "RawGlAccount": "100-10-52143",
  "RawAmount": "26.34",
  "RawClaimDate": "02/21/2025",
  "RawClaimNumber": "022125G",
  "ClaimNumber": "022125G",
  "VendorId": 32,
  "ClaimDate": "2025-02-21",
  "Description": "IP Lights",
  "GLAccountDescription": null,
  "ChartOfAccountsId": 122,
  "GeneralLedgerAccountId": 11,
  "Amount": 26.34,
  "Sequence": null,
  "ClaimType": "Invoice",
  "Status_LookupCode": "Translated",
  "Priority_LookupCode": "Normal",
  "ErrorMessage": null,
  "Note": null,
  "ProcessingNote": null,
  "CreatedAtUtc": "0001-01-01T00:00:00",
  "ClaimGroupKey": null,
  "ProcessingGroupKey": "991a3b68-dd85-49fc-b810-3a5244c6910b",
  "DocumentRecordId": 45,
  "ProcessingMessageCount": null,
  "ClaimStagingMaps": [],
  "ClaimStagingAssets": [],
  "ClaimStagingProvenanceMaps": []
}

Staging Summary

Row 27 — 022125G

Vendor: Idaho Power

Vendor Details

Vendor ID: 32

Raw Vendor Name: Idaho Power

Accounting

Chart of Accounts: 122

GL Account: 11

Amount: 72.49

Claim Date: 2/21/2025

System Status

Status: Translated

Staging ID: 2076

Error Details

No errors recorded.

Raw JSON (provenance)

{
  "ClaimStagingId": 2076,
  "DataImportId": 12,
  "RowIndex": 27,
  "PageExtractionRecordId": null,
  "RawVendorName": "Idaho Power",
  "RawChartOfAccounts": "",
  "RawGlAccount": "100-10-52143",
  "RawAmount": "72.49",
  "RawClaimDate": "02/21/2025",
  "RawClaimNumber": "022125G",
  "ClaimNumber": "022125G",
  "VendorId": 32,
  "ClaimDate": "2025-02-21",
  "Description": "206 N Main",
  "GLAccountDescription": null,
  "ChartOfAccountsId": 122,
  "GeneralLedgerAccountId": 11,
  "Amount": 72.49,
  "Sequence": null,
  "ClaimType": "Invoice",
  "Status_LookupCode": "Translated",
  "Priority_LookupCode": "Normal",
  "ErrorMessage": null,
  "Note": null,
  "ProcessingNote": null,
  "CreatedAtUtc": "0001-01-01T00:00:00",
  "ClaimGroupKey": null,
  "ProcessingGroupKey": "991a3b68-dd85-49fc-b810-3a5244c6910b",
  "DocumentRecordId": 45,
  "ProcessingMessageCount": null,
  "ClaimStagingMaps": [],
  "ClaimStagingAssets": [],
  "ClaimStagingProvenanceMaps": []
}

Staging Summary

Row 28 — 225109

Vendor: Forsgren Associates Inc.

Vendor Details

Vendor ID: 23

Raw Vendor Name: Forsgren Associates Inc.

Accounting

Chart of Accounts: 68

GL Account: 11

Amount: 3004.39

Claim Date: 2/25/2025

System Status

Status: Translated

Staging ID: 2077

Error Details

No errors recorded.

Raw JSON (provenance)

{
  "ClaimStagingId": 2077,
  "DataImportId": 12,
  "RowIndex": 28,
  "PageExtractionRecordId": null,
  "RawVendorName": "Forsgren Associates Inc.",
  "RawChartOfAccounts": "",
  "RawGlAccount": "100-10-51090",
  "RawAmount": "3,004.39",
  "RawClaimDate": "02/25/2025",
  "RawClaimNumber": "225109",
  "ClaimNumber": "225109",
  "VendorId": 23,
  "ClaimDate": "2025-02-25",
  "Description": "02-24-0139 FY21 Trans Plan KN 22026 - TB reimb 92.66%",
  "GLAccountDescription": null,
  "ChartOfAccountsId": 68,
  "GeneralLedgerAccountId": 11,
  "Amount": 3004.39,
  "Sequence": null,
  "ClaimType": "Invoice",
  "Status_LookupCode": "Translated",
  "Priority_LookupCode": "Normal",
  "ErrorMessage": null,
  "Note": null,
  "ProcessingNote": null,
  "CreatedAtUtc": "0001-01-01T00:00:00",
  "ClaimGroupKey": null,
  "ProcessingGroupKey": "991a3b68-dd85-49fc-b810-3a5244c6910b",
  "DocumentRecordId": 45,
  "ProcessingMessageCount": null,
  "ClaimStagingMaps": [],
  "ClaimStagingAssets": [],
  "ClaimStagingProvenanceMaps": []
}

Staging Summary

Row 29 — 43035164

Vendor: Quill Corporation

Vendor Details

Vendor ID: 53

Raw Vendor Name: Quill Corporation

Accounting

Chart of Accounts: 43

GL Account: 5

Amount: 37.18

Claim Date: 2/26/2025

System Status

Status: Translated

Staging ID: 2078

Error Details

No errors recorded.

Raw JSON (provenance)

{
  "ClaimStagingId": 2078,
  "DataImportId": 12,
  "RowIndex": 29,
  "PageExtractionRecordId": null,
  "RawVendorName": "Quill Corporation",
  "RawChartOfAccounts": "",
  "RawGlAccount": "100-01-52010",
  "RawAmount": "37.18",
  "RawClaimDate": "02/26/2025",
  "RawClaimNumber": "43035164",
  "ClaimNumber": "43035164",
  "VendorId": 53,
  "ClaimDate": "2025-02-26",
  "Description": "Date Stamps",
  "GLAccountDescription": null,
  "ChartOfAccountsId": 43,
  "GeneralLedgerAccountId": 5,
  "Amount": 37.18,
  "Sequence": null,
  "ClaimType": "Invoice",
  "Status_LookupCode": "Translated",
  "Priority_LookupCode": "Normal",
  "ErrorMessage": null,
  "Note": null,
  "ProcessingNote": null,
  "CreatedAtUtc": "0001-01-01T00:00:00",
  "ClaimGroupKey": null,
  "ProcessingGroupKey": "991a3b68-dd85-49fc-b810-3a5244c6910b",
  "DocumentRecordId": 45,
  "ProcessingMessageCount": null,
  "ClaimStagingMaps": [],
  "ClaimStagingAssets": [],
  "ClaimStagingProvenanceMaps": []
}

Staging Summary

Row 30 — 134722

Vendor: Go-Fer It Express Inc.

Vendor Details

Vendor ID: 27

Raw Vendor Name: Go-Fer It Express Inc.

Accounting

Chart of Accounts: 136

GL Account: 3

Amount: 81.90

Claim Date: 2/28/2025

System Status

Status: Translated

Staging ID: 2079

Error Details

No errors recorded.

Raw JSON (provenance)

{
  "ClaimStagingId": 2079,
  "DataImportId": 12,
  "RowIndex": 30,
  "PageExtractionRecordId": null,
  "RawVendorName": "Go-Fer It Express Inc.",
  "RawChartOfAccounts": "",
  "RawGlAccount": "300-30-52110",
  "RawAmount": "81.90",
  "RawClaimDate": "02/28/2025",
  "RawClaimNumber": "134722",
  "ClaimNumber": "134722",
  "VendorId": 27,
  "ClaimDate": "2025-02-28",
  "Description": "Dellivery of test samples",
  "GLAccountDescription": null,
  "ChartOfAccountsId": 136,
  "GeneralLedgerAccountId": 3,
  "Amount": 81.90,
  "Sequence": null,
  "ClaimType": "Invoice",
  "Status_LookupCode": "Translated",
  "Priority_LookupCode": "Normal",
  "ErrorMessage": null,
  "Note": null,
  "ProcessingNote": null,
  "CreatedAtUtc": "0001-01-01T00:00:00",
  "ClaimGroupKey": null,
  "ProcessingGroupKey": "991a3b68-dd85-49fc-b810-3a5244c6910b",
  "DocumentRecordId": 45,
  "ProcessingMessageCount": null,
  "ClaimStagingMaps": [],
  "ClaimStagingAssets": [],
  "ClaimStagingProvenanceMaps": []
}

Staging Summary

Row 31 — 12687963

Vendor: Idaho Mountain Express

Vendor Details

Vendor ID: 133

Raw Vendor Name: Idaho Mountain Express

Accounting

Chart of Accounts: 24

GL Account: 9

Amount: 60.72

Claim Date: 2/28/2025

System Status

Status: Translated

Staging ID: 2080

Error Details

No errors recorded.

Raw JSON (provenance)

{
  "ClaimStagingId": 2080,
  "DataImportId": 12,
  "RowIndex": 31,
  "PageExtractionRecordId": null,
  "RawVendorName": "Idaho Mountain Express",
  "RawChartOfAccounts": "",
  "RawGlAccount": "100-03-51020",
  "RawAmount": "60.72",
  "RawClaimDate": "02/28/2025",
  "RawClaimNumber": "12687963",
  "ClaimNumber": "12687963",
  "VendorId": 133,
  "ClaimDate": "2025-02-28",
  "Description": "Legal ordinance 2025-01",
  "GLAccountDescription": null,
  "ChartOfAccountsId": 24,
  "GeneralLedgerAccountId": 9,
  "Amount": 60.72,
  "Sequence": null,
  "ClaimType": "Invoice",
  "Status_LookupCode": "Translated",
  "Priority_LookupCode": "Normal",
  "ErrorMessage": null,
  "Note": null,
  "ProcessingNote": null,
  "CreatedAtUtc": "0001-01-01T00:00:00",
  "ClaimGroupKey": null,
  "ProcessingGroupKey": "991a3b68-dd85-49fc-b810-3a5244c6910b",
  "DocumentRecordId": 45,
  "ProcessingMessageCount": null,
  "ClaimStagingMaps": [],
  "ClaimStagingAssets": [],
  "ClaimStagingProvenanceMaps": []
}

Staging Summary

Row 32 — 12687964

Vendor: Idaho Mountain Express

Vendor Details

Vendor ID: 133

Raw Vendor Name: Idaho Mountain Express

Accounting

Chart of Accounts: 47

GL Account: 5

Amount: 44.16

Claim Date: 2/28/2025

System Status

Status: Translated

Staging ID: 2081

Error Details

No errors recorded.

Raw JSON (provenance)

{
  "ClaimStagingId": 2081,
  "DataImportId": 12,
  "RowIndex": 32,
  "PageExtractionRecordId": null,
  "RawVendorName": "Idaho Mountain Express",
  "RawChartOfAccounts": "",
  "RawGlAccount": "100-01-52060",
  "RawAmount": "44.16",
  "RawClaimDate": "02/28/2025",
  "RawClaimNumber": "12687964",
  "ClaimNumber": "12687964",
  "VendorId": 133,
  "ClaimDate": "2025-02-28",
  "Description": "Legal P \u0026 Z - Appeal Sign Permit - Maverick",
  "GLAccountDescription": null,
  "ChartOfAccountsId": 47,
  "GeneralLedgerAccountId": 5,
  "Amount": 44.16,
  "Sequence": null,
  "ClaimType": "Invoice",
  "Status_LookupCode": "Translated",
  "Priority_LookupCode": "Normal",
  "ErrorMessage": null,
  "Note": null,
  "ProcessingNote": null,
  "CreatedAtUtc": "0001-01-01T00:00:00",
  "ClaimGroupKey": null,
  "ProcessingGroupKey": "991a3b68-dd85-49fc-b810-3a5244c6910b",
  "DocumentRecordId": 45,
  "ProcessingMessageCount": null,
  "ClaimStagingMaps": [],
  "ClaimStagingAssets": [],
  "ClaimStagingProvenanceMaps": []
}

Staging Summary

Row 33 — 1000

Vendor: 4550McHugh Bromley Attorneys at La02/28/2025Representation in delivery calls & other water rights work 2/14/25 - 2/

Vendor Details

Vendor ID:

Raw Vendor Name: 4550McHugh Bromley Attorneys at La02/28/2025Representation in delivery calls & other water rights work 2/14/25 - 2/

Accounting

Chart of Accounts:

GL Account:

Amount:

Claim Date:

System Status

Status: Error

Staging ID: 2082

Error Details

Vendor not found: '4550McHugh Bromley Attorneys at La02/28/2025Representation in delivery calls & other water rights work 2/14/25 - 2/' (Legal='4550McHugh Bromley Attorneys at La02/28/2025Representation in delivery calls & other water rights work 2/14/25 - 2', DBA=''); Unable to parse GL composite: 'Conjunctive Management'

Raw JSON (provenance)

{
  "ClaimStagingId": 2082,
  "DataImportId": 12,
  "RowIndex": 33,
  "PageExtractionRecordId": null,
  "RawVendorName": "4550McHugh Bromley Attorneys at La02/28/2025Representation in delivery calls \u0026 other water rights work 2/14/25 - 2/",
  "RawChartOfAccounts": "",
  "RawGlAccount": "Conjunctive Management",
  "RawAmount": "",
  "RawClaimDate": "",
  "RawClaimNumber": "1000",
  "ClaimNumber": "1000",
  "VendorId": null,
  "ClaimDate": null,
  "Description": "1,472.00200-20-51070",
  "GLAccountDescription": null,
  "ChartOfAccountsId": null,
  "GeneralLedgerAccountId": null,
  "Amount": null,
  "Sequence": null,
  "ClaimType": "Invoice",
  "Status_LookupCode": "Error",
  "Priority_LookupCode": "Normal",
  "ErrorMessage": "Vendor not found: \u00274550McHugh Bromley Attorneys at La02/28/2025Representation in delivery calls \u0026 other water rights work 2/14/25 - 2/\u0027 (Legal=\u00274550McHugh Bromley Attorneys at La02/28/2025Representation in delivery calls \u0026 other water rights work 2/14/25 - 2\u0027, DBA=\u0027\u0027); Unable to parse GL composite: \u0027Conjunctive Management\u0027",
  "Note": null,
  "ProcessingNote": null,
  "CreatedAtUtc": "0001-01-01T00:00:00",
  "ClaimGroupKey": null,
  "ProcessingGroupKey": "991a3b68-dd85-49fc-b810-3a5244c6910b",
  "DocumentRecordId": 45,
  "ProcessingMessageCount": null,
  "ClaimStagingMaps": [],
  "ClaimStagingAssets": [],
  "ClaimStagingProvenanceMaps": []
}

Staging Summary

Row 34 — 8216

Vendor: Merrick & Company

Vendor Details

Vendor ID: 107

Raw Vendor Name: Merrick & Company

Accounting

Chart of Accounts: 150

GL Account: 2

Amount: 7800.00

Claim Date: 2/28/2025

System Status

Status: Translated

Staging ID: 2083

Error Details

No errors recorded.

Raw JSON (provenance)

{
  "ClaimStagingId": 2083,
  "DataImportId": 12,
  "RowIndex": 34,
  "PageExtractionRecordId": null,
  "RawVendorName": "Merrick \u0026 Company",
  "RawChartOfAccounts": "",
  "RawGlAccount": "200-20-58125",
  "RawAmount": "7,800.00",
  "RawClaimDate": "02/28/2025",
  "RawClaimNumber": "8216",
  "ClaimNumber": "8216",
  "VendorId": 107,
  "ClaimDate": "2025-02-28",
  "Description": "Drinking Water System Project",
  "GLAccountDescription": null,
  "ChartOfAccountsId": 150,
  "GeneralLedgerAccountId": 2,
  "Amount": 7800.00,
  "Sequence": null,
  "ClaimType": "Invoice",
  "Status_LookupCode": "Translated",
  "Priority_LookupCode": "Normal",
  "ErrorMessage": null,
  "Note": null,
  "ProcessingNote": null,
  "CreatedAtUtc": "0001-01-01T00:00:00",
  "ClaimGroupKey": null,
  "ProcessingGroupKey": "991a3b68-dd85-49fc-b810-3a5244c6910b",
  "DocumentRecordId": 45,
  "ProcessingMessageCount": null,
  "ClaimStagingMaps": [],
  "ClaimStagingAssets": [],
  "ClaimStagingProvenanceMaps": []
}

Staging Summary

Row 35 — 214920

Vendor: Napa Auto Parts

Vendor Details

Vendor ID: 48

Raw Vendor Name: Napa Auto Parts

Accounting

Chart of Accounts: 49

GL Account: 11

Amount: 89.94

Claim Date: 2/28/2025

System Status

Status: Translated

Staging ID: 2084

Error Details

No errors recorded.

Raw JSON (provenance)

{
  "ClaimStagingId": 2084,
  "DataImportId": 12,
  "RowIndex": 35,
  "PageExtractionRecordId": null,
  "RawVendorName": "Napa Auto Parts",
  "RawChartOfAccounts": "",
  "RawGlAccount": "100-10-52090",
  "RawAmount": "89.94",
  "RawClaimDate": "02/28/2025",
  "RawClaimNumber": "214920",
  "ClaimNumber": "214920",
  "VendorId": 48,
  "ClaimDate": "2025-02-28",
  "Description": "Diesel Additive",
  "GLAccountDescription": null,
  "ChartOfAccountsId": 49,
  "GeneralLedgerAccountId": 11,
  "Amount": 89.94,
  "Sequence": null,
  "ClaimType": "Invoice",
  "Status_LookupCode": "Translated",
  "Priority_LookupCode": "Normal",
  "ErrorMessage": null,
  "Note": null,
  "ProcessingNote": null,
  "CreatedAtUtc": "0001-01-01T00:00:00",
  "ClaimGroupKey": null,
  "ProcessingGroupKey": "991a3b68-dd85-49fc-b810-3a5244c6910b",
  "DocumentRecordId": 45,
  "ProcessingMessageCount": null,
  "ClaimStagingMaps": [],
  "ClaimStagingAssets": [],
  "ClaimStagingProvenanceMaps": []
}

Staging Summary

Row 36 — 0061977821

Vendor: Oxarc

Vendor Details

Vendor ID: 49

Raw Vendor Name: Oxarc

Accounting

Chart of Accounts: 49

GL Account: 11

Amount: 8.68

Claim Date: 2/28/2025

System Status

Status: Translated

Staging ID: 2085

Error Details

No errors recorded.

Raw JSON (provenance)

{
  "ClaimStagingId": 2085,
  "DataImportId": 12,
  "RowIndex": 36,
  "PageExtractionRecordId": null,
  "RawVendorName": "Oxarc",
  "RawChartOfAccounts": "",
  "RawGlAccount": "100-10-52090",
  "RawAmount": "8.68",
  "RawClaimDate": "02/28/2025",
  "RawClaimNumber": "0061977821",
  "ClaimNumber": "0061977821",
  "VendorId": 49,
  "ClaimDate": "2025-02-28",
  "Description": "Acetylene",
  "GLAccountDescription": null,
  "ChartOfAccountsId": 49,
  "GeneralLedgerAccountId": 11,
  "Amount": 8.68,
  "Sequence": null,
  "ClaimType": "Invoice",
  "Status_LookupCode": "Translated",
  "Priority_LookupCode": "Normal",
  "ErrorMessage": null,
  "Note": null,
  "ProcessingNote": null,
  "CreatedAtUtc": "0001-01-01T00:00:00",
  "ClaimGroupKey": null,
  "ProcessingGroupKey": "991a3b68-dd85-49fc-b810-3a5244c6910b",
  "DocumentRecordId": 45,
  "ProcessingMessageCount": null,
  "ClaimStagingMaps": [],
  "ClaimStagingAssets": [],
  "ClaimStagingProvenanceMaps": []
}

Staging Summary

Row 37 — INV0014441

Vendor: Core & Main

Vendor Details

Vendor ID: 15

Raw Vendor Name: Core & Main

Accounting

Chart of Accounts: 41

GL Account: 3

Amount: 278.18

Claim Date: 3/1/2025

System Status

Status: Translated

Staging ID: 2086

Error Details

No errors recorded.

Raw JSON (provenance)

{
  "ClaimStagingId": 2086,
  "DataImportId": 12,
  "RowIndex": 37,
  "PageExtractionRecordId": null,
  "RawVendorName": "Core \u0026 Main",
  "RawChartOfAccounts": "",
  "RawGlAccount": "300-30-51160",
  "RawAmount": "278.18",
  "RawClaimDate": "03/01/2025",
  "RawClaimNumber": "INV0014441",
  "ClaimNumber": "INV0014441",
  "VendorId": 15,
  "ClaimDate": "2025-03-01",
  "Description": "Fittings, etc. for WW Plant",
  "GLAccountDescription": null,
  "ChartOfAccountsId": 41,
  "GeneralLedgerAccountId": 3,
  "Amount": 278.18,
  "Sequence": null,
  "ClaimType": "Invoice",
  "Status_LookupCode": "Translated",
  "Priority_LookupCode": "Normal",
  "ErrorMessage": null,
  "Note": null,
  "ProcessingNote": null,
  "CreatedAtUtc": "0001-01-01T00:00:00",
  "ClaimGroupKey": null,
  "ProcessingGroupKey": "991a3b68-dd85-49fc-b810-3a5244c6910b",
  "DocumentRecordId": 45,
  "ProcessingMessageCount": null,
  "ClaimStagingMaps": [],
  "ClaimStagingAssets": [],
  "ClaimStagingProvenanceMaps": []
}

Staging Summary

Row 38 — W497379

Vendor: Core & Main

Vendor Details

Vendor ID: 15

Raw Vendor Name: Core & Main

Accounting

Chart of Accounts: 115

GL Account: 3

Amount: 136.19

Claim Date: 3/1/2025

System Status

Status: Translated

Staging ID: 2087

Error Details

No errors recorded.

Raw JSON (provenance)

{
  "ClaimStagingId": 2087,
  "DataImportId": 12,
  "RowIndex": 38,
  "PageExtractionRecordId": null,
  "RawVendorName": "Core \u0026 Main",
  "RawChartOfAccounts": "",
  "RawGlAccount": "300-30-51163",
  "RawAmount": "136.19",
  "RawClaimDate": "03/01/2025",
  "RawClaimNumber": "W497379",
  "ClaimNumber": "W497379",
  "VendorId": 15,
  "ClaimDate": "2025-03-01",
  "Description": "Bushings, valves, etc. WW Plant",
  "GLAccountDescription": null,
  "ChartOfAccountsId": 115,
  "GeneralLedgerAccountId": 3,
  "Amount": 136.19,
  "Sequence": null,
  "ClaimType": "Invoice",
  "Status_LookupCode": "Translated",
  "Priority_LookupCode": "Normal",
  "ErrorMessage": null,
  "Note": null,
  "ProcessingNote": null,
  "CreatedAtUtc": "0001-01-01T00:00:00",
  "ClaimGroupKey": null,
  "ProcessingGroupKey": "991a3b68-dd85-49fc-b810-3a5244c6910b",
  "DocumentRecordId": 45,
  "ProcessingMessageCount": null,
  "ClaimStagingMaps": [],
  "ClaimStagingAssets": [],
  "ClaimStagingProvenanceMaps": []
}

Staging Summary

Row 39 — W497773

Vendor: Core & Main

Vendor Details

Vendor ID: 15

Raw Vendor Name: Core & Main

Accounting

Chart of Accounts: 115

GL Account: 3

Amount: 1258.67

Claim Date: 3/1/2025

System Status

Status: Translated

Staging ID: 2088

Error Details

No errors recorded.

Raw JSON (provenance)

{
  "ClaimStagingId": 2088,
  "DataImportId": 12,
  "RowIndex": 39,
  "PageExtractionRecordId": null,
  "RawVendorName": "Core \u0026 Main",
  "RawChartOfAccounts": "",
  "RawGlAccount": "300-30-51163",
  "RawAmount": "1,258.67",
  "RawClaimDate": "03/01/2025",
  "RawClaimNumber": "W497773",
  "ClaimNumber": "W497773",
  "VendorId": 15,
  "ClaimDate": "2025-03-01",
  "Description": "Transition Couplers - WW Plant",
  "GLAccountDescription": null,
  "ChartOfAccountsId": 115,
  "GeneralLedgerAccountId": 3,
  "Amount": 1258.67,
  "Sequence": null,
  "ClaimType": "Invoice",
  "Status_LookupCode": "Translated",
  "Priority_LookupCode": "Normal",
  "ErrorMessage": null,
  "Note": null,
  "ProcessingNote": null,
  "CreatedAtUtc": "0001-01-01T00:00:00",
  "ClaimGroupKey": null,
  "ProcessingGroupKey": "991a3b68-dd85-49fc-b810-3a5244c6910b",
  "DocumentRecordId": 45,
  "ProcessingMessageCount": null,
  "ClaimStagingMaps": [],
  "ClaimStagingAssets": [],
  "ClaimStagingProvenanceMaps": []
}

Staging Summary

Row 40 — 02013-2025

Vendor: -ICRMP

Vendor Details

Vendor ID:

Raw Vendor Name: -ICRMP

Accounting

Chart of Accounts: 40

GL Account: 5

Amount: 3457.72

Claim Date: 3/1/2025

System Status

Status: Error

Staging ID: 2089

Error Details

Vendor not found: '-ICRMP' (Legal='-ICRMP', DBA='')

Raw JSON (provenance)

{
  "ClaimStagingId": 2089,
  "DataImportId": 12,
  "RowIndex": 40,
  "PageExtractionRecordId": null,
  "RawVendorName": "-ICRMP",
  "RawChartOfAccounts": "",
  "RawGlAccount": "100-01-51150",
  "RawAmount": "3,457.72",
  "RawClaimDate": "03/01/2025",
  "RawClaimNumber": "02013-2025",
  "ClaimNumber": "02013-2025",
  "VendorId": null,
  "ClaimDate": "2025-03-01",
  "Description": "Liability Insurance",
  "GLAccountDescription": null,
  "ChartOfAccountsId": 40,
  "GeneralLedgerAccountId": 5,
  "Amount": 3457.72,
  "Sequence": null,
  "ClaimType": "Invoice",
  "Status_LookupCode": "Error",
  "Priority_LookupCode": "Normal",
  "ErrorMessage": "Vendor not found: \u0027-ICRMP\u0027 (Legal=\u0027-ICRMP\u0027, DBA=\u0027\u0027)",
  "Note": null,
  "ProcessingNote": null,
  "CreatedAtUtc": "0001-01-01T00:00:00",
  "ClaimGroupKey": null,
  "ProcessingGroupKey": "991a3b68-dd85-49fc-b810-3a5244c6910b",
  "DocumentRecordId": 45,
  "ProcessingMessageCount": null,
  "ClaimStagingMaps": [],
  "ClaimStagingAssets": [],
  "ClaimStagingProvenanceMaps": []
}

Staging Summary

Row 41 — 02013-2025

Vendor: -ICRMP

Vendor Details

Vendor ID:

Raw Vendor Name: -ICRMP

Accounting

Chart of Accounts: 40

GL Account: 9

Amount: 1747.66

Claim Date: 3/1/2025

System Status

Status: Error

Staging ID: 2090

Error Details

Vendor not found: '-ICRMP' (Legal='-ICRMP', DBA='')

Raw JSON (provenance)

{
  "ClaimStagingId": 2090,
  "DataImportId": 12,
  "RowIndex": 41,
  "PageExtractionRecordId": null,
  "RawVendorName": "-ICRMP",
  "RawChartOfAccounts": "",
  "RawGlAccount": "100-03-51150",
  "RawAmount": "1,747.66",
  "RawClaimDate": "03/01/2025",
  "RawClaimNumber": "02013-2025",
  "ClaimNumber": "02013-2025",
  "VendorId": null,
  "ClaimDate": "2025-03-01",
  "Description": "Liability Insurance",
  "GLAccountDescription": null,
  "ChartOfAccountsId": 40,
  "GeneralLedgerAccountId": 9,
  "Amount": 1747.66,
  "Sequence": null,
  "ClaimType": "Invoice",
  "Status_LookupCode": "Error",
  "Priority_LookupCode": "Normal",
  "ErrorMessage": "Vendor not found: \u0027-ICRMP\u0027 (Legal=\u0027-ICRMP\u0027, DBA=\u0027\u0027)",
  "Note": null,
  "ProcessingNote": null,
  "CreatedAtUtc": "0001-01-01T00:00:00",
  "ClaimGroupKey": null,
  "ProcessingGroupKey": "991a3b68-dd85-49fc-b810-3a5244c6910b",
  "DocumentRecordId": 45,
  "ProcessingMessageCount": null,
  "ClaimStagingMaps": [],
  "ClaimStagingAssets": [],
  "ClaimStagingProvenanceMaps": []
}

Staging Summary

Row 42 — 02013-2025

Vendor: -ICRMP

Vendor Details

Vendor ID:

Raw Vendor Name: -ICRMP

Accounting

Chart of Accounts: 40

GL Account: 12

Amount: 439.16

Claim Date: 3/1/2025

System Status

Status: Error

Staging ID: 2091

Error Details

Vendor not found: '-ICRMP' (Legal='-ICRMP', DBA='')

Raw JSON (provenance)

{
  "ClaimStagingId": 2091,
  "DataImportId": 12,
  "RowIndex": 42,
  "PageExtractionRecordId": null,
  "RawVendorName": "-ICRMP",
  "RawChartOfAccounts": "",
  "RawGlAccount": "100-04-51150",
  "RawAmount": "439.16",
  "RawClaimDate": "03/01/2025",
  "RawClaimNumber": "02013-2025",
  "ClaimNumber": "02013-2025",
  "VendorId": null,
  "ClaimDate": "2025-03-01",
  "Description": "Liability Insurance",
  "GLAccountDescription": null,
  "ChartOfAccountsId": 40,
  "GeneralLedgerAccountId": 12,
  "Amount": 439.16,
  "Sequence": null,
  "ClaimType": "Invoice",
  "Status_LookupCode": "Error",
  "Priority_LookupCode": "Normal",
  "ErrorMessage": "Vendor not found: \u0027-ICRMP\u0027 (Legal=\u0027-ICRMP\u0027, DBA=\u0027\u0027)",
  "Note": null,
  "ProcessingNote": null,
  "CreatedAtUtc": "0001-01-01T00:00:00",
  "ClaimGroupKey": null,
  "ProcessingGroupKey": "991a3b68-dd85-49fc-b810-3a5244c6910b",
  "DocumentRecordId": 45,
  "ProcessingMessageCount": null,
  "ClaimStagingMaps": [],
  "ClaimStagingAssets": [],
  "ClaimStagingProvenanceMaps": []
}

Staging Summary

Row 43 — 02013-2025

Vendor: -ICRMP

Vendor Details

Vendor ID:

Raw Vendor Name: -ICRMP

Accounting

Chart of Accounts: 40

GL Account: 13

Amount: 357.14

Claim Date: 3/1/2025

System Status

Status: Error

Staging ID: 2092

Error Details

Vendor not found: '-ICRMP' (Legal='-ICRMP', DBA='')

Raw JSON (provenance)

{
  "ClaimStagingId": 2092,
  "DataImportId": 12,
  "RowIndex": 43,
  "PageExtractionRecordId": null,
  "RawVendorName": "-ICRMP",
  "RawChartOfAccounts": "",
  "RawGlAccount": "100-09-51150",
  "RawAmount": "357.14",
  "RawClaimDate": "03/01/2025",
  "RawClaimNumber": "02013-2025",
  "ClaimNumber": "02013-2025",
  "VendorId": null,
  "ClaimDate": "2025-03-01",
  "Description": "Liability Insurance",
  "GLAccountDescription": null,
  "ChartOfAccountsId": 40,
  "GeneralLedgerAccountId": 13,
  "Amount": 357.14,
  "Sequence": null,
  "ClaimType": "Invoice",
  "Status_LookupCode": "Error",
  "Priority_LookupCode": "Normal",
  "ErrorMessage": "Vendor not found: \u0027-ICRMP\u0027 (Legal=\u0027-ICRMP\u0027, DBA=\u0027\u0027)",
  "Note": null,
  "ProcessingNote": null,
  "CreatedAtUtc": "0001-01-01T00:00:00",
  "ClaimGroupKey": null,
  "ProcessingGroupKey": "991a3b68-dd85-49fc-b810-3a5244c6910b",
  "DocumentRecordId": 45,
  "ProcessingMessageCount": null,
  "ClaimStagingMaps": [],
  "ClaimStagingAssets": [],
  "ClaimStagingProvenanceMaps": []
}

Staging Summary

Row 44 — 02013-2025

Vendor: -ICRMP

Vendor Details

Vendor ID:

Raw Vendor Name: -ICRMP

Accounting

Chart of Accounts: 40

GL Account: 4

Amount: 1345.84

Claim Date: 3/1/2025

System Status

Status: Error

Staging ID: 2093

Error Details

Vendor not found: '-ICRMP' (Legal='-ICRMP', DBA='')

Raw JSON (provenance)

{
  "ClaimStagingId": 2093,
  "DataImportId": 12,
  "RowIndex": 44,
  "PageExtractionRecordId": null,
  "RawVendorName": "-ICRMP",
  "RawChartOfAccounts": "",
  "RawGlAccount": "100-05-51150",
  "RawAmount": "1,345.84",
  "RawClaimDate": "03/01/2025",
  "RawClaimNumber": "02013-2025",
  "ClaimNumber": "02013-2025",
  "VendorId": null,
  "ClaimDate": "2025-03-01",
  "Description": "Liability Insurance",
  "GLAccountDescription": null,
  "ChartOfAccountsId": 40,
  "GeneralLedgerAccountId": 4,
  "Amount": 1345.84,
  "Sequence": null,
  "ClaimType": "Invoice",
  "Status_LookupCode": "Error",
  "Priority_LookupCode": "Normal",
  "ErrorMessage": "Vendor not found: \u0027-ICRMP\u0027 (Legal=\u0027-ICRMP\u0027, DBA=\u0027\u0027)",
  "Note": null,
  "ProcessingNote": null,
  "CreatedAtUtc": "0001-01-01T00:00:00",
  "ClaimGroupKey": null,
  "ProcessingGroupKey": "991a3b68-dd85-49fc-b810-3a5244c6910b",
  "DocumentRecordId": 45,
  "ProcessingMessageCount": null,
  "ClaimStagingMaps": [],
  "ClaimStagingAssets": [],
  "ClaimStagingProvenanceMaps": []
}

Staging Summary

Row 45 — 02013-2025

Vendor: -ICRMP

Vendor Details

Vendor ID:

Raw Vendor Name: -ICRMP

Accounting

Chart of Accounts: 40

GL Account: 8

Amount: 468.95

Claim Date: 3/1/2025

System Status

Status: Error

Staging ID: 2094

Error Details

Vendor not found: '-ICRMP' (Legal='-ICRMP', DBA='')

Raw JSON (provenance)

{
  "ClaimStagingId": 2094,
  "DataImportId": 12,
  "RowIndex": 45,
  "PageExtractionRecordId": null,
  "RawVendorName": "-ICRMP",
  "RawChartOfAccounts": "",
  "RawGlAccount": "100-07-51150",
  "RawAmount": "468.95",
  "RawClaimDate": "03/01/2025",
  "RawClaimNumber": "02013-2025",
  "ClaimNumber": "02013-2025",
  "VendorId": null,
  "ClaimDate": "2025-03-01",
  "Description": "Liability Insurance",
  "GLAccountDescription": null,
  "ChartOfAccountsId": 40,
  "GeneralLedgerAccountId": 8,
  "Amount": 468.95,
  "Sequence": null,
  "ClaimType": "Invoice",
  "Status_LookupCode": "Error",
  "Priority_LookupCode": "Normal",
  "ErrorMessage": "Vendor not found: \u0027-ICRMP\u0027 (Legal=\u0027-ICRMP\u0027, DBA=\u0027\u0027)",
  "Note": null,
  "ProcessingNote": null,
  "CreatedAtUtc": "0001-01-01T00:00:00",
  "ClaimGroupKey": null,
  "ProcessingGroupKey": "991a3b68-dd85-49fc-b810-3a5244c6910b",
  "DocumentRecordId": 45,
  "ProcessingMessageCount": null,
  "ClaimStagingMaps": [],
  "ClaimStagingAssets": [],
  "ClaimStagingProvenanceMaps": []
}

Staging Summary

Row 46 — 02013-2025

Vendor: -ICRMP

Vendor Details

Vendor ID:

Raw Vendor Name: -ICRMP

Accounting

Chart of Accounts: 40

GL Account: 6

Amount: 4350.67

Claim Date: 3/1/2025

System Status

Status: Error

Staging ID: 2095

Error Details

Vendor not found: '-ICRMP' (Legal='-ICRMP', DBA='')

Raw JSON (provenance)

{
  "ClaimStagingId": 2095,
  "DataImportId": 12,
  "RowIndex": 46,
  "PageExtractionRecordId": null,
  "RawVendorName": "-ICRMP",
  "RawChartOfAccounts": "",
  "RawGlAccount": "100-08-51150",
  "RawAmount": "4,350.67",
  "RawClaimDate": "03/01/2025",
  "RawClaimNumber": "02013-2025",
  "ClaimNumber": "02013-2025",
  "VendorId": null,
  "ClaimDate": "2025-03-01",
  "Description": "Liability Insurance",
  "GLAccountDescription": null,
  "ChartOfAccountsId": 40,
  "GeneralLedgerAccountId": 6,
  "Amount": 4350.67,
  "Sequence": null,
  "ClaimType": "Invoice",
  "Status_LookupCode": "Error",
  "Priority_LookupCode": "Normal",
  "ErrorMessage": "Vendor not found: \u0027-ICRMP\u0027 (Legal=\u0027-ICRMP\u0027, DBA=\u0027\u0027)",
  "Note": null,
  "ProcessingNote": null,
  "CreatedAtUtc": "0001-01-01T00:00:00",
  "ClaimGroupKey": null,
  "ProcessingGroupKey": "991a3b68-dd85-49fc-b810-3a5244c6910b",
  "DocumentRecordId": 45,
  "ProcessingMessageCount": null,
  "ClaimStagingMaps": [],
  "ClaimStagingAssets": [],
  "ClaimStagingProvenanceMaps": []
}

Page Extraction Records

Page #	Processing Group	Created

Metadata

Key	Value

Logs

Timestamp	Worksheet	Row	Message
2/28/2026 7:54:09 PM	Sheet1	1	FUSED: IM='City of Bellevue' DD='Invoices (Claims) FY26 YTD' CG='Page: 1' GLD=''
2/28/2026 7:54:09 PM	Sheet1	2	FUSED: IM='Hosted Live 3.11.2025' DD='Input Dates: 10/1/2024 - 9/30/2025' CG='Feb 02, 2026 07:52AM' GLD=''
2/28/2026 7:54:09 PM	Sheet1	3	FUSED: IM='' DD='' CG='' GLD=''
2/28/2026 7:54:09 PM	Sheet1	4	FUSED: IM='Invoice' DD='Merchant Name' CG='Invoice Date' GLD='Description'
2/28/2026 7:54:09 PM	Sheet1	5	FUSED: IM='' DD='' CG='' GLD=''
2/28/2026 7:54:09 PM	Sheet1	6	FUSED: IM='8084Merrick & Company' DD='10/25/2024Drinking Water System Project' CG='18,755.00200-20-58125' GLD='Drinking Water Plan - IDEQ'
2/28/2026 7:54:09 PM	Sheet1	7	FUSED: IM='5858Midco Diving & Marine Services' DD='10/31/2024Trip Charge - Scheduled to clean water tank, but discharge not viabl' CG='1,398.11200-20-51160' GLD='Repairs & Maintenance (Gen'
2/28/2026 7:54:09 PM	Sheet1	8	FUSED: IM='8123Merrick & Company' DD='12/31/2024Drinking Water System Project' CG='18,295.00200-20-58125' GLD='Drinking Water Plan - IDEQ'
2/28/2026 7:54:09 PM	Sheet1	9	FUSED: IM='8170Merrick & Company' DD='01/31/2025Drinking Water System Project' CG='900.00200-20-58125' GLD='Drinking Water Plan - IDEQ'
2/28/2026 7:54:09 PM	Sheet1	10	FUSED: IM='022125GIdaho Power' DD='02/21/2025100 N 8th St Park' CG='34.55100-04-52143' GLD='Utilities - Power'
2/28/2026 7:54:09 PM	Sheet1	11	FUSED: IM='022125GIdaho Power' DD='02/21/2025114 Elm St.' CG='39.21100-10-52143' GLD='Utilities - Power'
2/28/2026 7:54:09 PM	Sheet1	12	FUSED: IM='022125GIdaho Power' DD='02/21/2025115 Pine St.' CG='180.24100-09-52143' GLD='Utilities - Power'
2/28/2026 7:54:09 PM	Sheet1	13	FUSED: IM='022125GIdaho Power' DD='02/21/2025116 Pine St.' CG='42.11100-10-52143' GLD='Utilities - Power'
2/28/2026 7:54:09 PM	Sheet1	14	FUSED: IM='022125GIdaho Power' DD='02/21/2025117 Pine St.' CG='105.49100-10-52143' GLD='Utilities - Power'
2/28/2026 7:54:09 PM	Sheet1	15	FUSED: IM='022125GIdaho Power' DD='02/21/20251461 S. Main' CG='33.28100-10-52143' GLD='Utilities - Power'
2/28/2026 7:54:09 PM	Sheet1	16	FUSED: IM='022125GIdaho Power' DD='02/21/2025161 Cowcatcher Loop' CG='3.19100-10-52143' GLD='Utilities - Power'
2/28/2026 7:54:09 PM	Sheet1	17	FUSED: IM='022125GIdaho Power' DD='02/21/2025206 N Main St.' CG='8.77100-10-52143' GLD='Utilities - Power'
2/28/2026 7:54:09 PM	Sheet1	18	FUSED: IM='022125GIdaho Power' DD='02/21/2025300 E Cedar St.' CG='26.34100-04-52143' GLD='Utilities - Power'
2/28/2026 7:54:09 PM	Sheet1	19	FUSED: IM='022125GIdaho Power' DD='02/21/2025318 E Cedar St' CG='26.34100-04-52143' GLD='Utilities - Power'
2/28/2026 7:54:09 PM	Sheet1	20	FUSED: IM='022125GIdaho Power' DD='02/21/2025508 Broadford Rd' CG='27.79100-10-52143' GLD='Utilities - Power'
2/28/2026 7:54:09 PM	Sheet1	21	FUSED: IM='022125GIdaho Power' DD='02/21/2025517 N 2nd St' CG='112.83100-09-52143' GLD='Utilities - Power'
2/28/2026 7:54:09 PM	Sheet1	22	FUSED: IM='022125GIdaho Power' DD='02/21/2025714 N Main St' CG='29.62100-10-52143' GLD='Utilities - Power'
2/28/2026 7:54:09 PM	Sheet1	23	FUSED: IM='022125GIdaho Power' DD='02/21/202589 Martin Ln Shop' CG='253.79100-10-52143' GLD='Utilities - Power'
2/28/2026 7:54:09 PM	Sheet1	24	FUSED: IM='022125GIdaho Power' DD='02/21/2025921 Riverside Dr.' CG='2.56100-10-52143' GLD='Utilities - Power'
2/28/2026 7:54:09 PM	Sheet1	25	FUSED: IM='022125GIdaho Power' DD='02/21/2025IP Lights' CG='1,349.39100-10-52143' GLD='Utilities - Power'
2/28/2026 7:54:09 PM	Sheet1	26	FUSED: IM='022125GIdaho Power' DD='02/21/2025IP Lights' CG='26.34100-10-52143' GLD='Utilities - Power'
2/28/2026 7:54:09 PM	Sheet1	27	FUSED: IM='022125GIdaho Power' DD='02/21/2025206 N Main' CG='72.49100-10-52143' GLD='Utilities - Power'
2/28/2026 7:54:09 PM	Sheet1	28	FUSED: IM='225109Forsgren Associates Inc.' DD='02/25/202502-24-0139 FY21 Trans Plan KN 22026 - TB reimb 92.66%' CG='3,004.39100-10-51090' GLD='Engineering Services'
2/28/2026 7:54:09 PM	Sheet1	29	FUSED: IM='43035164Quill Corporation' DD='02/26/2025Date Stamps' CG='37.18100-01-52010' GLD='Office Supplies'
2/28/2026 7:54:09 PM	Sheet1	30	FUSED: IM='134722Go-Fer It Express Inc.' DD='02/28/2025Dellivery of test samples' CG='81.90300-30-52110' GLD='Test Samples - Water & Sewer'
2/28/2026 7:54:09 PM	Sheet1	31	FUSED: IM='12687963Idaho Mountain Express' DD='02/28/2025Legal ordinance 2025-01' CG='60.72100-03-51020' GLD='Advertising'
2/28/2026 7:54:09 PM	Sheet1	32	FUSED: IM='12687964Idaho Mountain Express' DD='02/28/2025Legal P & Z - Appeal Sign Permit - Maverick' CG='44.16100-01-52060' GLD='Publishing'
2/28/2026 7:54:09 PM	Sheet1	33	FUSED: IM='1000 4550McHugh Bromley Attorneys at La02/28/2025Representation in delivery calls & other water rights work 2/14/25 - 2/' DD='1,472.00200-20-51070' CG='Conjunctive Management' GLD=''
2/28/2026 7:54:09 PM	Sheet1	34	FUSED: IM='8216Merrick & Company' DD='02/28/2025Drinking Water System Project' CG='7,800.00200-20-58125' GLD='Drinking Water Plan - IDEQ'
2/28/2026 7:54:09 PM	Sheet1	35	FUSED: IM='214920Napa Auto Parts' DD='02/28/2025Diesel Additive' CG='89.94100-10-52090' GLD='Supplies'
2/28/2026 7:54:09 PM	Sheet1	36	FUSED: IM='0061977821Oxarc' DD='02/28/2025Acetylene' CG='8.68100-10-52090' GLD='Supplies'
2/28/2026 7:54:09 PM	Sheet1	37	FUSED: IM='INV0014441Core & Main' DD='03/01/2025Fittings, etc. for WW Plant' CG='278.18300-30-51160' GLD='Repairs & Maintenance (Gen'
2/28/2026 7:54:09 PM	Sheet1	38	FUSED: IM='W497379Core & Main' DD='03/01/2025Bushings, valves, etc. WW Plant' CG='136.19300-30-51163' GLD='R & M - Equipment (non-auto)'
2/28/2026 7:54:09 PM	Sheet1	39	FUSED: IM='W497773Core & Main' DD='03/01/2025Transition Couplers - WW Plant' CG='1,258.67300-30-51163' GLD='R & M - Equipment (non-auto)'
2/28/2026 7:54:09 PM	Sheet1	40	FUSED: IM='02013-2025-ICRMP' DD='03/01/2025Liability Insurance' CG='3,457.72100-01-51150' GLD='Liability Insurance'
2/28/2026 7:54:09 PM	Sheet1	41	FUSED: IM='02013-2025-ICRMP' DD='03/01/2025Liability Insurance' CG='1,747.66100-03-51150' GLD='Liability Insurance'
2/28/2026 7:54:09 PM	Sheet1	42	FUSED: IM='02013-2025-ICRMP' DD='03/01/2025Liability Insurance' CG='439.16100-04-51150' GLD='Liability Insurance'
2/28/2026 7:54:09 PM	Sheet1	43	FUSED: IM='02013-2025-ICRMP' DD='03/01/2025Liability Insurance' CG='357.14100-09-51150' GLD='Liability Insurance'
2/28/2026 7:54:09 PM	Sheet1	44	FUSED: IM='02013-2025-ICRMP' DD='03/01/2025Liability Insurance' CG='1,345.84100-05-51150' GLD='Liability Insurance'
2/28/2026 7:54:09 PM	Sheet1	45	FUSED: IM='02013-2025-ICRMP' DD='03/01/2025Liability Insurance' CG='468.95100-07-51150' GLD='Liability Insurance'
2/28/2026 7:54:09 PM	Sheet1	46	FUSED: IM='02013-2025-ICRMP' DD='03/01/2025Liability Insurance' CG='4,350.67100-08-51150' GLD='Liability Insurance'

CivicPulse Admin

Import Details

Document

Worksheet Summary

Staged Claims

Translation Errors — Row 1

Translation Errors — Row 2

Translation Errors — Row 4

Translation Errors — Row 7