Chicago Public Library, 10110 Cash, operating account (bank account ending 4410)

Bank reconciliation

As of October 31, 2025

C SA 11/06/25 CTL 11/10/25

Objective

Agree the general ledger cash balance at October 31, 2025 to the bank statement, and explain every difference.

Conclusion

The account reconciles with no unexplained difference. Adjusted bank and book balances both equal 32,073.72. Reconciling items are three outstanding checks, one deposit in transit and a bank error of 0.27 that the bank corrected on November 5, 2025. One adjusting entry for the 35.00 bank fee was posted (C-1.4).

Work performed

  1. Agreed the bank balance to the October statement and the book balance to the general ledger.
  2. Matched all 13 bank statement lines to the general ledger by check number and amount (C-1.5).
  3. Traced every general ledger payment to the City payment record (C-1.6).
  4. Traced each outstanding check and the deposit in transit to the November bank statement (C-1.1, C-1.2).
  5. Investigated the one amount mismatch and obtained the bank's correction (C-1.3).
  6. Footed every schedule.

Sign-off

Prepared by
Staff accountant, November 6, 2025
Reviewed by
Controller, November 10, 2025

Index

  • C-1Reconciliation summary
  • C-1.1Outstanding checks
  • C-1.2Deposits in transit
  • C-1.3Bank error
  • C-1.4Adjusting entry
  • C-1.5Bank statement agreement
  • C-1.6General ledger detail

Tick marks

  • ✓aAgreed between bank statement and general ledger. The letter pairs the items.
  • BSAgreed to the October bank statement.
  • GLAgreed to the general ledger, account 10110.
  • FFooted. The column adds to the total shown.
  • STraced to the source payment record in the City of Chicago Payments dataset.
  • SBSTraced to the November bank statement, which shows the item clearing.
  • BEBank error. The bank paid a different amount than the check was written for.

Chicago Public Library, 10110 Cash, operating account (bank account ending 4410)

Reconciliation summary

As of October 31, 2025

C-1 SA 11/06/25 CTL 11/10/25
Balance per bank statement, Oct 31BS22,181.82
Add deposits in transitC-1.215,000.00
Less outstanding checksC-1.1(5,108.37)
Add bank error, check 40214 overpaidC-1.30.27
Adjusted bank balanceF32,073.72A
Balance per general ledger, Oct 31GL32,108.72
Less account analysis fee not yet recordedC-1.4(35.00)
Adjusted book balanceF32,073.72A
Difference0.00

A Adjusted balances agree.

Activity check

BankGeneral ledger
Opening balance, Oct 112,480.0012,480.00
Receipts50,000.0065,000.00
Disbursements(40,298.18)(45,371.28)
Closing balance, Oct 3122,181.82 F32,108.72 F

Chicago Public Library, 10110 Cash, operating account (bank account ending 4410)

Outstanding checks

As of October 31, 2025

C-1.1 SA 11/06/25 CTL 11/10/25

Checks recorded in October that had not cleared the bank by October 31, 2025. Each was traced to the November statement.

CheckIssuedPayeeSourceGLClearedAmount
40222Oct 27Debi's Piano Tuning & Repair PVCI25CI502257 SGL-14 Nov 10 SBS315.80
40223Oct 28Perk Products Inc PVCI25CI502280 SGL-15 Nov 3 SBS155.43
40224Oct 31Perk Products Inc PVCI25CI502304 SGL-17 Nov 6 SBS4,637.14
Total outstanding checks, to C-15,108.37 F

Check 40222 cleared later than usual. The vendor held it before depositing; nothing further needed.

Chicago Public Library, 10110 Cash, operating account (bank account ending 4410)

Deposits in transit

As of October 31, 2025

C-1.2 SA 11/06/25 CTL 11/10/25

Receipts recorded in October that the bank credited after October 31, 2025.

RecordedDescriptionGLCredited by bankAmount
Oct 31Transfer in from Corporate FundGL-16Nov 3 SBS15,000.00
Total deposits in transit, to C-115,000.00 F

The transfer was booked on the last business day of the month and credited on the next business day, which is a normal timing difference.

Chicago Public Library, 10110 Cash, operating account (bank account ending 4410)

Bank error

As of October 31, 2025

C-1.3 SA 11/06/25 CTL 11/10/25

One check cleared for a different amount than it was written for.

CheckPayeeSourceWritten, per GLPaid, per bankDifference
40214Debi's Piano Tuning & RepairPVCI25CI502209 S 110.25 GL-5 110.52 BS-5 0.27 BE

The payment record and the check both show 110.25. The bank encoded the check as 110.52, transposing the cents. The bank was notified and issued a credit memo for 0.27 on November 5, 2025 SBS. No entry is needed in the books.

Chicago Public Library, 10110 Cash, operating account (bank account ending 4410)

Adjusting entry

As of October 31, 2025

C-1.4 SA 11/06/25 CTL 11/10/25

Items on the bank statement that were not yet in the general ledger.

EntryAccountBank refDebitCredit
AJE-1
Posted Nov 7		61540 Bank service chargesBS-1235.00
10110 Cash, operating account35.00
Totals35.00 F35.00 F

To record the October account analysis fee charged by the bank on October 31, 2025. Posting brings the general ledger to the adjusted book balance on C-1.

Chicago Public Library, 10110 Cash, operating account (bank account ending 4410)

Bank statement agreement

As of October 31, 2025

C-1.5 SA 11/06/25 CTL 11/10/25

Every line on the October statement, agreed to the general ledger. Matching letters pair each bank line with its ledger line on C-1.6.

RefDateBank descriptionAmountAgreed to
Opening balance, Oct 112,480.00BS
BS-1Oct 1BOOK TRANSFER CR CORP FUND50,000.00✓aGL-1
BS-2Oct 10CHECK 40211(761.10)✓bGL-2
BS-3Oct 15CHECK 40212(3,749.50)✓cGL-3
BS-4Oct 21CHECK 40213(6,662.23)✓dGL-4
BS-5Oct 27CHECK 40214(110.52)BEeGL-5, see C-1.3
BS-6Oct 28CHECK 40215(21.23)✓fGL-6
BS-7Oct 29CHECK 40216(1,178.05)✓gGL-7
BS-8Oct 29CHECK 40217(404.80)✓hGL-8
BS-9Oct 29CHECK 40218(330.75)✓iGL-9
BS-10Oct 30CHECK 40219(1,222.52)✓jGL-10
BS-11Oct 30CHECK 40220(25,092.05)✓kGL-11, GL-12
BS-12Oct 31ACCOUNT ANALYSIS FEE(35.00)JENot in GL, see C-1.4
BS-13Oct 31CHECK 40221(730.43)✓lGL-13
Closing balance, Oct 31, to C-122,181.82F

Chicago Public Library, 10110 Cash, operating account (bank account ending 4410)

General ledger detail

As of October 31, 2025

C-1.6 SA 11/06/25 CTL 11/10/25

Every October entry to account 10110, with how it was cleared. The 15 payments are real City of Chicago records; follow a voucher link to see the source.

RefDateDescriptionCheckVoucherAmountCleared
Opening balance, Oct 112,480.00GL
GL-1Oct 1Transfer in from Corporate Fund Internal transfer 50,000.00✓aBS-1, Oct 1
GL-2Oct 6Perk Products Inc40211 PVCI25CI502132 S (761.10)✓bBS-2, Oct 10
GL-3Oct 8Davis Bancorp40212 PVCI25CI502167 S (3,749.50)✓cBS-3, Oct 15
GL-4Oct 15Midwest Tape Exchange40213 PVCI25CI502185 S (6,662.23)✓dBS-4, Oct 21
GL-5Oct 21Debi's Piano Tuning & Repair40214 PVCI25CI502209 S (110.25)BEeBS-5, Oct 27
GL-6Oct 22Midwest Tape Exchange40215 PVCI25CI502232 S (21.23)✓fBS-6, Oct 28
GL-7Oct 23Debi's Piano Tuning & Repair40216 PVCI25CI502240 S (1,178.05)✓gBS-7, Oct 29
GL-8Oct 23B & L Distributors, Inc.40217 PVCI25CI703063 S (404.80)✓hBS-8, Oct 29
GL-9Oct 23Debi's Piano Tuning & Repair40218 PVCI25CI703076 S (330.75)✓iBS-9, Oct 29
GL-10Oct 24Midwest Tape Exchange40219 PVCI25CI502247 S (1,222.52)✓jBS-10, Oct 30
GL-11Oct 24Midwest Tape Exchange40220 PVCI25CI502251 S (20,974.20)✓kBS-11, Oct 30
GL-12Oct 24Midwest Tape Exchange40220 PVCI25CI502251 S (4,117.85)✓kBS-11, Oct 30
GL-13Oct 27Perk Products Inc40221 PVCI25CI502253 S (730.43)✓lBS-13, Oct 31
GL-14Oct 27Debi's Piano Tuning & Repair40222 PVCI25CI502257 S (315.80)O/SOutstanding, C-1.1
GL-15Oct 28Perk Products Inc40223 PVCI25CI502280 S (155.43)O/SOutstanding, C-1.1
GL-16Oct 31Transfer in from Corporate Fund Internal transfer 15,000.00DITIn transit, C-1.2
GL-17Oct 31Perk Products Inc40224 PVCI25CI502304 S (4,637.14)O/SOutstanding, C-1.1
Closing balance, Oct 31, to C-132,108.72F

Check 40220 paid two invoices on one voucher, so two ledger lines clear against one bank line.