Receipt Reconciliation Report

Generated: 2026-03-07 07:07:48

Errors: 0 Warnings: 4 Ignored: 2 Passed: 7

Summary

The reconciliation found 4 warning(s) and 2 ignored finding(s) across the three data sources.

Supplier name mismatches (C2) account for 251 of the warnings. These are mostly abbreviations in the Transactions sheet vs full legal names extracted from invoices. The most frequent: 'NHS' (207), '1300TempFence' (14), 'Recycle Central Group' (8), 'Hancock Speedway' (8), 'Vulcan - Ullrich Aluminium' (5). These top patterns cover 242 of the 251 mismatches.

Amount mismatches (C3): 9 found. 4 appear to be sign mismatches (credit notes recorded as negative in Transactions but positive in the Receipts sheet); 4 have significant dollar differences worth investigating; 1 is a minor rounding difference.

Duplicate supplier invoice numbers (D3): 5 found. These could indicate duplicate charges or legitimate multi-part invoices — each should be verified against the source documents.

Missing or incomplete data (D2): 1 row. 1 has genuinely missing data.

Overall processing coverage: 545/545 (100.0%).

3 individual issue(s) across 2 check(s) have been marked as ignored via the Rec Review column.

A. Receipts Folder vs Receipts Sheet

PASS A1: Files in folder with no sheet row 0 issue(s)
PASS A2: Sheet rows with no matching file 0 issue(s)

B. Transactions vs Receipts Folder

PASS B1: URLs without local paths 0 issue(s)
PASS B2: Local paths pointing to missing files 0 issue(s)
PASS B3: Receipt numbers with no file 0 issue(s)

C. Transactions vs Receipts Sheet

PASS C1: Transaction receipt nums with no sheet row 0 issue(s)
WARNING C2: Supplier name mismatches 251 issue(s)
Show 251 detail(s)
  • Row 9 (receipt 15207917130): transaction='1300TempFence' vs sheet='Ready Industries Pty Ltd trading as 1300 TempFence'
  • Row 28 (receipt 16036367490): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 29 (receipt 16023615100): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 30 (receipt 16010178050): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 31 (receipt 16010177590): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 32 (receipt 15996685800): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 33 (receipt 15996673490): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 34 (receipt 15989819360): transaction='1300TempFence' vs sheet='Ready Industries Pty Ltd trading as 1300 TempFence'
  • Row 43 (receipt 16175245960): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 45 (receipt 16146886800): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 48 (receipt 16110284320): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 50 (receipt 16064744520): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 57 (receipt 16331502870): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 58 (receipt 16319119870): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 63 (receipt 16276400080): transaction='1300TempFence' vs sheet='Ready Industries Pty Ltd trading as 1300 TempFence'
  • Row 66 (receipt 16220390100): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 74 (receipt 16442748500): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 78 (receipt 16412881070): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 81 (receipt 16409840000): transaction='BURRELLS LANDSCAPE SUPPLIE' vs sheet='Mat Brown Concrete Pty Ltd t/as Burrells Concrete'
  • Row 82 (receipt 16396355220): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 85 (receipt 16385437500): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 86 (receipt 16373876440): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 87 (receipt 16348439910): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 88 (receipt 16348439410): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 93 (receipt 16634651350): transaction='1300TempFence' vs sheet='Ready Industries Pty Ltd (trading as 1300 TempFence)'
  • Row 96 (receipt 16594025030): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 98 (receipt 16579342980): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 99 (receipt 16579329380): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 100 (receipt 16564287840): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 103 (receipt 16546078250): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 104 (receipt 16533254940): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 105 (receipt 16533253660): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 107 (receipt 16491102290): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 115 (receipt 16744284420): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 116 (receipt 16744269670): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 118 (receipt 16732088590): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 123 (receipt 16706224600): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 124 (receipt 16693281100): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 137 (receipt 16901109910): transaction='1300TempFence' vs sheet='Ready Industries Pty Ltd (trading as 1300 TempFence)'
  • Row 139 (receipt 16886975460): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 140 (receipt 16874120880): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 142 (receipt 16860900490): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 143 (receipt 16860899240): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 144 (receipt 16846870480): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 145 (receipt 16832238810): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 147 (receipt 16814850790): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 148 (receipt 16804166960): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 149 (receipt 16762697290): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 150 (receipt 16762696590): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 154 (receipt 17004088930): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 155 (receipt 16993400390): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 158 (receipt 16981300700): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 159 (receipt 16981286170): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 160 (receipt 16981285060): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 161 (receipt 16981282610): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 166 (receipt 16956408840): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 167 (receipt 16944444430): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 168 (receipt 16944443200): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 170 (receipt 16944431030): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 173 (receipt 16917860490): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 174 (receipt 16904235780): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 183 (receipt 17126851860): transaction='Recycle Central Group' vs sheet='Central Waste Station Pty Ltd t/as Recycle Central'
  • Row 185 (receipt 17126745860): transaction='Recycle Central Group' vs sheet='Central Waste Station Pty Ltd t/as Recycle Central'
  • Row 187 (receipt 17113014830): transaction='PW Saddington & Sons Pty LTD' vs sheet='Saddingtons Building Supplies'
  • Row 188 (receipt 17074288350): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 189 (receipt 17060565350): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 191 (receipt 17046048530): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 192 (receipt 17030335850): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 196 (receipt 17167311860): transaction='1300TempFence' vs sheet='Ready Industries Pty Ltd (trading as 1300 TempFence)'
  • Row 202 (receipt 17241267930): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 203 (receipt 17224837190): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 204 (receipt 17212407230): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 205 (receipt 17212402890): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 206 (receipt 17199419390): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 207 (receipt 17171333400): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 208 (receipt 17267090150): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 211 (receipt 17237821100): transaction='Recycle Central Group' vs sheet='Central Waste Station Pty Ltd t/as Recycle Central'
  • Row 212 (receipt 17302241900): transaction='Recycle Central Group' vs sheet='Central Waste Station Pty Ltd t/as Recycle Central'
  • Row 213 (receipt 17302121540): transaction='Recycle Central Group' vs sheet='Central Waste Station Pty Ltd t/as Recycle Central'
  • Row 214 (receipt 17253025020): transaction='Recycle Central Group' vs sheet='Central Waste Station Pty Ltd t/as Recycle Central'
  • Row 225 (receipt 17379571650): transaction='S-Crete Concrete Contractors' vs sheet='S-Crete Pty Ltd'
  • Row 228 (receipt 17378526850): transaction='Recycle Central Group' vs sheet='Central Waste Station Pty Ltd t/as Recycle Central'
  • Row 230 (receipt 17378504730): transaction='Hancock Speedway' vs sheet='Bishop and Hart T Hart Constructions Pty Ltd'
  • Row 232 (receipt 17305547350): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 233 (receipt 17305546240): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 240 (receipt 17569357810): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 241 (receipt 17557063320): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 242 (receipt 17543636180): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 243 (receipt 17528742700): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 249 (receipt 17524795890): transaction='Recycle Central Group' vs sheet='Central Waste Station Pty Ltd t/as Recycle Central'
  • Row 251 (receipt 17524754920): transaction='1300TempFence' vs sheet='Ready Industries Pty Ltd trading as 1300 TempFence'
  • Row 252 (receipt 17497272600): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 253 (receipt 17483115070): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 254 (receipt 17467987790): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 255 (receipt 17455230010): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 267 (receipt 17689915600): transaction='Mighty Helpful Mitre 10' vs sheet='Mitre 10 (Beveridge Building Products)'
  • Row 268 (receipt 17704431840): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 269 (receipt 17692214160): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 270 (receipt 17678900440): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 271 (receipt 17678898960): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 272 (receipt 17678891010): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 273 (receipt 17633458800): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 274 (receipt 17621902110): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 275 (receipt 17609852310): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 276 (receipt 17609850880): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 277 (receipt 17597052430): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 278 (receipt 17597050820): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 279 (receipt 17597030800): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 280 (receipt 17633471200): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 282 (receipt 17675140560): transaction='PW Saddington & Sons Pty LTD' vs sheet='Saddingtons Building Supplies'
  • Row 301 (receipt 17826552090): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 302 (receipt 17826551450): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 303 (receipt 17817142290): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 304 (receipt 17806915400): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 306 (receipt 17796086590): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 307 (receipt 17796084000): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 314 (receipt 17781904480): transaction='1300TempFence' vs sheet='Ready Industries Pty Ltd trading as 1300 TempFence'
  • Row 318 (receipt 17752200860): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 319 (receipt 17752200120): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 320 (receipt 17741730200): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 321 (receipt 17741720140): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 322 (receipt 17741719000): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 323 (receipt 17741716890): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 325 (receipt 17727815160): transaction='Hancock Speedway' vs sheet='BISHOP AND HART T HART CONSTRUCTIONS PTY LTD'
  • Row 332 (receipt 17944777940): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 335 (receipt 17930488360): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 337 (receipt 17914716670): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 338 (receipt 17899889080): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 342 (receipt 17896398040): transaction='Hancock Speedway' vs sheet='BISHOP AND HART T HART CONSTRUCTIONS PTY LTD'
  • Row 347 (receipt 17849498010): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 348 (receipt 17839970730): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 355 (receipt 18120850210): transaction='1300TempFence' vs sheet='Ready Industries Pty Ltd (trading as 1300 TempFence)'
  • Row 363 (receipt 17976713190): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 364 (receipt 17976719590): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 365 (receipt 17991378200): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 366 (receipt 17991379760): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 367 (receipt 18005209310): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 368 (receipt 18018521780): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 369 (receipt 18018524550): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 370 (receipt 18018525180): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 371 (receipt 18018541090): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 372 (receipt 18031527660): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 373 (receipt 18049786120): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 374 (receipt 18064893910): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 375 (receipt 18079183630): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 376 (receipt 18092734980): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 377 (receipt 18018526680): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 392 (receipt 18235034790): transaction='Coastallay' vs sheet='Bishop and Hart'
  • Row 395 (receipt 18232521860): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 396 (receipt 18232508310): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 397 (receipt 18216870690): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 398 (receipt 18202345780): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 399 (receipt 18202332060): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 400 (receipt 18198559290): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 401 (receipt 18198558110): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 404 (receipt 18185703720): transaction='Hancock Speedway' vs sheet='Bishop and Hart T Hart Constructions Pty Ltd'
  • Row 406 (receipt 18161993370): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 409 (receipt 18150242510): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 411 (receipt 18137520900): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 412 (receipt 18137501540): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 413 (receipt 18123446530): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 419 (receipt 18415623040): transaction='1300TempFence' vs sheet='Ready Industries Pty Ltd (trading as 1300 TempFence)'
  • Row 421 (receipt 18415606670): transaction='Hancock Speedway' vs sheet='Bishop and Hart T Hart Constructions Pty Ltd'
  • Row 422 (receipt 18399099420): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 423 (receipt 18385669710): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 424 (receipt 18385656610): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 425 (receipt 18385656030): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 426 (receipt 18385655240): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 427 (receipt 18385653360): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 428 (receipt 18371543700): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 429 (receipt 18342014900): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 430 (receipt 18341999960): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 431 (receipt 18341999770): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 432 (receipt 18341999060): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 449 (receipt 18538133820): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 450 (receipt 18538133610): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 451 (receipt 18538125990): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 452 (receipt 18526202740): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 453 (receipt 18514077480): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 454 (receipt 18514071060): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 455 (receipt 18501279020): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 456 (receipt 18488384980): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 457 (receipt 18459756310): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 458 (receipt 18432618360): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 459 (receipt 18417860390): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 462 (receipt 18511189930): transaction='Hancock Speedway' vs sheet='BISHOP AND HART T HART CONSTRUCTIONS PTY LTD'
  • Row 464 (receipt 18486991330): transaction='Hancock Speedway' vs sheet='BISHOP AND HART T HART CONSTRUCTIONS PTY LTD'
  • Row 470 (receipt 18486974110): transaction='Vulcan - Ullrich Aluminium' vs sheet='Vulcan Steel (Australia) Pty Ltd'
  • Row 483 (receipt 18709740300): transaction='Artistic Waterproofing' vs sheet='Bishop and Hart'
  • Row 487 (receipt 18709673840): transaction='Vulcan - Ullrich Aluminium' vs sheet='Vulcan Steel (Australia) Pty Ltd'
  • Row 492 (receipt 18709416830): transaction='1300TempFence' vs sheet='Ready Industries Pty Ltd trading as 1300 TempFence'
  • Row 493 (receipt 18664866770): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 494 (receipt 18653565220): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 496 (receipt 18639441360): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 498 (receipt 18606187370): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 499 (receipt 18574950560): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 500 (receipt 18574948960): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 501 (receipt 18557422590): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 513 (receipt 18837561720): transaction='Vulcan - Ullrich Aluminium' vs sheet='Vulcan Steel (Australia) Pty Ltd'
  • Row 515 (receipt 18837554950): transaction='Hancock Speedway' vs sheet='BISHOP AND HART T HART CONSTRUCTIONS PTY LTD'
  • Row 516 (receipt 18827375340): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 517 (receipt 18827369840): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 518 (receipt 18815187900): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 519 (receipt 18815187380): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 520 (receipt 18802259280): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 521 (receipt 18787909420): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 523 (receipt 18787900420): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 524 (receipt 18787900110): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 525 (receipt 18769651590): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 526 (receipt 18769649610): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 527 (receipt 18742525420): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 528 (receipt 18742523470): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 529 (receipt 18742515050): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 530 (receipt 18742514190): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 531 (receipt 18742514180): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 532 (receipt 18712392750): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 561 (receipt 18857279760): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 562 (receipt 18998590590): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 563 (receipt 18920952420): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 579 (receipt 19317232620): transaction='1300TempFence' vs sheet='Ready Industries Pty Ltd'
  • Row 580 (receipt 19031643500): transaction='1300TempFence' vs sheet='Ready Industries Pty Ltd trading as 1300 TempFence'
  • Row 581 (receipt 19424789560): transaction='365 Site Services' vs sheet='Bishop and Hart Construction Group'
  • Row 592 (receipt 19303015650): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 593 (receipt 19274323140): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 594 (receipt 19274322650): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 595 (receipt 19259034940): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 596 (receipt 19243020000): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 597 (receipt 19195157920): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 600 (receipt 19317238610): transaction='Vulcan - Ullrich Aluminium' vs sheet='Vulcan Steel (Australia) Pty Ltd'
  • Row 610 (receipt 19380101320): transaction='Earp Bros - Surface Evolution' vs sheet='Earp Brothers Hardware P/L'
  • Row 613 (receipt 19438397000): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 614 (receipt 19438396600): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 615 (receipt 19425860860): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 616 (receipt 19425859820): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 617 (receipt 19354697260): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 618 (receipt 19354696800): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 619 (receipt 19339425730): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 620 (receipt 19339424560): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 623 (receipt 19411689960): transaction='Vulcan - Ullrich Aluminium' vs sheet='Vulcan Steel (Australia) Pty Ltd'
  • Row 629 (receipt 19624554110): transaction='1300TempFence' vs sheet='Ready Industries Pty Ltd'
  • Row 642 (receipt 19594576620): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 643 (receipt 19581146920): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 644 (receipt 19581146640): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 645 (receipt 19581145450): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 646 (receipt 19581145110): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 647 (receipt 19552109810): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 648 (receipt 19552102510): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 649 (receipt 19552101480): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 650 (receipt 19518531760): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 651 (receipt 19470444560): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
  • Row 652 (receipt 19470435440): transaction='NHS' vs sheet='Northumberland Handyman Supplies Pty Ltd'
WARNING C3: Amount mismatches (Transactions vs Receipts) 9 issue(s)
Show 9 detail(s)
  • Row 60 (receipt 16276411810): transaction=$-572.00 vs sheet=$572.00 (diff=$1144.00)
  • Row 169 (receipt 16944431780): transaction=$-151.33 vs sheet=$151.33 (diff=$302.66)
  • Row 171 (receipt 16944430280): transaction=$-151.33 vs sheet=$151.33 (diff=$302.66)
  • Row 358 (receipt 18118950980): transaction=$1449.70 vs sheet=$816.45 (diff=$633.25)
  • Row 359 (receipt 18120846190): transaction=$16380.44 vs sheet=$23400.44 (diff=$7020.00)
  • Row 360 (receipt 18029621960): transaction=$7020.00 vs sheet=$23400.44 (diff=$16380.44)
  • Row 363 (receipt 17976713190): transaction=$582.31 vs sheet=$582.32 (diff=$0.01)
  • Row 507 (receipt 18890947930): transaction=$5421.00 vs sheet=$20232.25 (diff=$14811.25)
  • Row 530 (receipt 18742514190): transaction=$-348.67 vs sheet=$348.67 (diff=$697.34)

D. Internal Consistency

WARNING D1: Net + GST != Total 1 issue(s)
Show 1 detail(s)
  • Receipt 18639441360 (row 414): net $228.13 + GST $22.83 = $250.96, but total = $251.17 (diff $0.21)
IGNORED D1: Net + GST != Total 2 issue(s)
Show 2 detail(s)
  • Receipt 15768012920 (row 2): net $36047.21 + GST $3747.94 = $39795.15, but total = $39795.29 (diff $0.14)
  • Receipt 17784892150 (row 255): net $4565.30 + GST $449.53 = $5014.83, but total = $5021.83 (diff $7.00)
IGNORED D2: Missing critical fields 1 issue(s)
Show 1 detail(s)
  • Receipt 19222386150 (row 490): missing total
WARNING D3: Duplicate supplier invoice numbers 5 issue(s)
Show 5 detail(s)
  • Invoice '1597' appears on receipts: 17524813060 (row 201), 19409577670 (row 505)
  • Invoice '18048' appears on receipts: 16501070040 (row 56), 16409840000 (row 67)
  • Invoice '2758758' appears on receipts: 18341999770 (row 358), 19581146640 (row 537)
  • Invoice 'S186090\1' appears on receipts: 15245241950 (row 8), 15180446860 (row 10)
  • Invoice 'SO266778' appears on receipts: 18120846190 (row 297), 18029621960 (row 298)
PASS D4: Duplicate URLs across different receipts 0 issue(s)

E. Completeness

INFO E1: Processing progress 5 issue(s)
Show 5 detail(s)
  • Total transaction rows: 548
  • With URL (col X): 545
  • With local path (col Y): 545
  • With receipt number (col Z): 545
  • Processing rate: 545/545 (100.0%)
INFO E2: Cross-source count comparison 3 issue(s)
Show 3 detail(s)
  • Files on disk: 545
  • Receipts sheet rows: 545
  • Unique receipt numbers in Transactions: 545

Rec Review Overrides

Errors: 0 | Warnings: 4 | Ignored: 2 | Passed: 7 — ISSUES FOUND

Issue detail