Reconciliation Review

QuickBooks Online OAuth + Reports — internal tool

← Home

Read-only. Nothing on this page changes a reconciliation — it shows what the last run produced and which documents still need a human.

Reset
Summary
Discrepancy: 24 Missing in QBO: 3 Matched: 61 Not yet reconciled: select a client
Breaks — 27 of 88
Closing Statement QBO Difference Status Reason
Citi AA #2278 (via cardholder 3237) #3237
credit card · Citi AA card #2278
2026-08-05 3,987.48 5,111.78 (1,124.30) Discrepancy —
from August 05.pdf
Chase Ink (account #1312) #1312
credit card · Chase INK
2026-08-04 128,734.22 130,432.56 (1,698.34) Discrepancy —
from 20260804-statements-1312-.pdf
BOA Checking 4531 #4531
bank · Bank of America Checking 4531
2026-07-31 165,480.86 165,155.03 325.83 Discrepancy —
from BOA #4531 Bank Statement 07.2026.pdf
Fairwinds Main checking 5139 #5139
bank · Fairwinds Main checking account 5139
2026-07-31 193,982.18 190,056.80 3,925.38 Discrepancy —
from July 2026.pdf
Chase Checking AP 3259 #3259
bank · Chase Checking AP (3259)
2026-07-31 22,601.25 21,012.09 1,589.16 Discrepancy —
from Chase #3259 Bank statement 07.2026.pdf
Amex Platinum 61003 #61003
credit card · AMEX Platinum 61003
2026-07-29 325,056.10 — — Missing in QBO account 'AMEX Platinum 61003' is not on the 2026-07-29 balance sheet
from AE #61003 CC Statement 07.29.26.pdf
Chase Ink (account #1312) #1312
credit card · Chase INK
2026-07-04 130,856.91 123,064.06 7,792.85 Discrepancy —
from 20260704-statements-1312-.pdf
Chase Ink (account #1312) #1312
credit card · Chase INK
2026-06-04 129,022.14 109,483.30 19,538.84 Discrepancy —
from 20260604-statements-1312-.pdf
BOA Checking 4531 #4531
bank · Bank of America Checking 4531
2026-05-31 105,055.48 104,729.65 325.83 Discrepancy —
from BOA #4531 Bank Statement 05.2026.pdf
Fairwinds Main checking 5139 #5139
bank · Fairwinds Main checking account 5139
2026-05-31 7,649.91 3,724.53 3,925.38 Discrepancy —
from May 2026.pdf
Vanguard Investments #7695
bank · Vanguard Investments
2026-05-31 300,842.07 315,842.07 (15,000.00) Discrepancy —
from May2026.pdf
Amex Platinum 61003 #61003
credit card · AMEX Platinum 61003
2026-05-29 131,886.89 — — Missing in QBO account 'AMEX Platinum 61003' is not on the 2026-05-29 balance sheet
from AE #61003 CC Statement 05.29.26.pdf
Chase Checking AP 3259 #3259
bank · Chase Checking AP (3259)
2026-05-29 27,114.31 25,525.15 1,589.16 Discrepancy —
from Chase #3259 Bank statement 05.2026.pdf
Chase Visa 1477 (via 4803) #4803
credit card · Chase Visa 1477 (4803)
2026-05-05 5,763.85 5,613.90 149.95 Discrepancy —
from Chase #4803 CC Statement 05.05.26.pdf
Citi AA #2278 (via cardholder 3237) #3237
credit card · Citi AA card #2278
2026-05-05 24,158.66 24,208.61 (49.95) Discrepancy —
from May 05.pdf
Chase Ink (account #1312) #1312
credit card · Chase INK
2026-05-04 43,879.23 44,390.24 (511.01) Discrepancy —
from 20260504-statements-1312-.pdf
BOA Checking 4531 #4531
bank · Bank of America Checking 4531
2026-04-30 139,358.15 139,032.32 325.83 Discrepancy —
from BOA #4531 Bank Statement 04.2026.pdf
Citi Checking 2266 #2266
bank · Citibank Checking 2266
2026-04-30 363,654.15 7,910.15 355,744.00 Discrepancy —
from Citi #2266 Activities 07.2026.xlsx
Fairwinds Main checking 5139 #5139
bank · Fairwinds Main checking account 5139
2026-04-30 40,741.10 36,815.72 3,925.38 Discrepancy —
from April 2026.pdf
Chase Checking AP 3259 #3259
bank · Chase Checking AP (3259)
2026-04-30 19,850.48 18,261.32 1,589.16 Discrepancy —
from Chase #3259 Bank statement 04.2026.pdf
Amex Platinum 61003 #61003
credit card · AMEX Platinum 61003
2026-04-28 90,670.65 — — Missing in QBO account 'AMEX Platinum 61003' is not on the 2026-04-28 balance sheet
from AE #61003 CC Statement 04.28.26.pdf
Chase Visa 9612 #9612
credit card · Chase Visa (9612)
2026-04-28 1,624.24 15,510.79 (13,886.55) Discrepancy —
from Chase #9612 CC Statement 04.28.26.pdf
Amex Delta Reserve 81009 #81009
credit card · Delta Reserve Business Card 81009
2026-04-17 1,365.97 1,431.92 (65.95) Discrepancy —
from AE #81009 CC Statement 04.17.26.pdf
Chase Visa 4281 #4281
credit card · Chase Visa 4281
2026-04-10 15,715.68 16,059.25 (343.57) Discrepancy —
from Chase #4281 CC Statement 04.10.26.pdf
Chase Visa 1477 (via 4803) #4803
credit card · Chase Visa 1477 (4803)
2026-04-05 5,699.65 5,609.68 89.97 Discrepancy —
from Chase #4803 CC Statement 04.05.26.pdf
Chase Ink (account #1312) #1312
credit card · Chase INK
2026-04-04 108,142.12 109,298.76 (1,156.64) Discrepancy —
from 20260404-statements-1312-.pdf
Citi AA #2278 (via cardholder 3237) #3237
credit card · Citi AA card #2278
2026-04-03 3,916.55 8,352.05 (4,435.50) Discrepancy —
from April 03.pdf
Needs review — 1

Failed or flagged extractions, plus individual accounts — a statement can report several — that were extracted cleanly but have no account_map entry. None of these ever appear in a reconciliation, so they are invisible in the table above.

File Account Closing Ending balance Status Why it is here
Citi #2266 Activities 07.2026.xlsx
bank statement
Accounting/2026/Bank statements/July/Citi #2266 Activities 07.2026.xlsx
Citi #2266 2026-07-31 7,790.15 Flagged
85% confident
file contains the latest balance for rest of month
Tip: If you connect multiple clients, reports will run against the selected realm_id.