Reconciliation Report: May Business Checking Statement vs May Bookkeeping Ledger
Both lists look complete. Each has 8 data rows, and the last line of each is whole, so I see no sign of a cut-off paste.
Summary
| Item | Count |
|---|---|
| Rows in A | 8 |
| Rows in B | 8 |
| Matched exactly | 5 |
| Matched with differences | 1 |
| Only in A | 1 |
| Only in B | 1 |
| Possible matches to review | 1 |
| Possible duplicates | 1 (B3, which repeats B2) |
| Unreadable rows | 0 |
Why your ledger doesn't match the bank: The bank statement totals $306.50 more than your ledger. Three items explain the gap to the cent:
- B3 (+$312.50): The ledger shows a second Delta Freight payment of -312.50 (EXP-203). The bank shows only one.
- A6 (-$15.00): The bank charged a $15.00 service fee that isn't in the ledger.
- A7 / B6 (+$9.00): The Brightline payment is -189.40 at the bank but -198.40 in the ledger, which looks like swapped digits.
The other six bank rows line up with ledger entries. One of them (A1↔B8) has quite different descriptions, so please give it a quick look.
Totals tie-out
| Amount | |
|---|---|
| Total of List A (bank) | 1,717.07 |
| Total of List B (ledger) | 1,410.57 |
| Difference (A − B) | 306.50 |
Breakdown of the difference:
| Component | Rows | Effect on A − B |
|---|---|---|
| Only in A | A6 (-15.00) | -15.00 |
| minus Only in B | B3 (-312.50) | +312.50 |
| Amount difference on the possible match | A7 (-189.40) vs B6 (-198.40) | +9.00 |
| Amount differences on matched pairs | none | 0.00 |
| Explained total | 306.50 | |
| Unexplained remainder | 0.00 |
The breakdown fully explains the difference.
Matched with differences
| A row | B row | Key | Field | A value | B value | Difference |
|---|---|---|---|---|---|---|
| A1 | B8 | 2024-05-01 / 05/01/2024, -1500.00 | Description | Opening transfer | Office Rent (EXP-206) | Descriptions don't resemble each other. Amount and date match exactly, so this meets your rules. |
Only in List A
| Row | Date | Description | Amount |
|---|---|---|---|
| A6 | 2024-05-15 | Bank service fee | -15.00 |
Only in List B
| Row | Ref | Vendor/Customer | Date | Amount |
|---|---|---|---|---|
| B3 | EXP-203 | Delta Freight | 05/07/2024 | -312.50 |
Possible matches — please review
| A row | B row | Why it might match | Why I'm unsure |
|---|---|---|---|
| A7 (2024-05-20, Brightline Print Co, -189.40) | B6 (EXP-205, Brightline Printing, 05/21/2024, -198.40) | Same vendor (name variant), dates 1 day apart, and the amounts use the same digits with "89" and "98" swapped. This is a common typing slip. | The amounts differ by 9.00. You said amounts must match to the cent, so I didn't count this as a match. |
Possible duplicates
| Rows | List | Details |
|---|---|---|
| B2 and B3 | B (ledger) | B2: EXP-202, Delta Freight, 05/06/2024, -312.50. B3: EXP-203, Delta Freight, 05/07/2024, -312.50. Same vendor and amount, one day apart, with different refs. The bank shows only one Delta Freight payment (A3, 2024-05-06, -312.50), and I matched it to B2 because it has the same date. |
Matched exactly
| A row | B row | Key | Amount |
|---|---|---|---|
| A2 | B1 | 2024-05-02 / 05/02/2024, ACME SUPPLIES ↔ Acme Supplies Inc (EXP-201) | -245.00 |
| A3 | B2 | 2024-05-06 / 05/06/2024, DELTA FREIGHT ↔ Delta Freight (EXP-202) | -312.50 |
| A4 | B4 | 2024-05-09 / 05/09/2024, Stripe payout ↔ Stripe (INC-88) | 1840.22 |
| A5 | B5 | 2024-05-13 / 05/13/2024, Google Workspace ↔ Google Workspace (EXP-204) | -72.00 |
| A8 | B7 | 2024-05-28 / 05/28/2024, Stripe payout ↔ Stripe (INC-89) | 2210.75 |
Assumptions & rules used
- Matching rules (yours):
- Amount must match exactly to the cent.
- Dates may be up to 3 days apart.
- Names were not required to match, because you said vendor names are spelled differently.
- Pairing:
- Each row was matched at most once.
- When two ledger rows fit one bank row, I chose the closest date. That's why A3 paired with B2 (same day) rather than B3 (one day later).
- Dates:
- List A uses YYYY-MM-DD.
- List B uses MM/DD/YYYY. I'm confident in this reading because 05/21/2024 can only mean May 21, and it fits "May" for every row.
- Amounts: Negatives are money out and positives are money in, in both lists. Neither list used currency symbols or thousands separators.
- Columns:
- List B's Ref column was used only as a label, since List A has no matching ID column.
- Descriptions were used only to flag odd pairs (A1↔B8) and possible matches (A7↔B6), not to decide matches.
- Category counts: Each row is counted in exactly one main category. A7 and B6 are counted as a "possible match," not under "Only in A/B." B3 is counted as "Only in B" and is also flagged as a possible duplicate.
Suggested next steps
- Delta Freight: Check whether B3 (EXP-203, Delta Freight, 05/07/2024, -312.50) was entered twice by mistake, since the bank shows only one Delta Freight payment (A3).
- Delta Freight in June: If B3 is a real second payment, check your June bank statement to see whether it cleared later.
- Bank fee: Confirm whether the A6 bank service fee (2024-05-15, -15.00) was recorded anywhere in the ledger. If not, it's missing from B.
- Brightline: Check the Brightline receipt or invoice to see whether the correct amount is -189.40 (A7, bank) or -198.40 (B6, ledger).
- Office Rent: Confirm that A1 "Opening transfer" (-1500.00) really is the Office Rent payment in B8 (EXP-206). If it was a transfer to another account, the ledger entry may be labeled incorrectly.
- Re-check the total: After any corrections, re-total the ledger. If B3 is removed, the fee is added, and B6 is changed to -189.40, the ledger should total 1,717.07, matching the bank.
Made by a Donkley AI worker. AI can make mistakes; please review before you rely on it.