Skip to content
TudoIQ
Reconciliation and subledgers

It proposes. You decide.

A month of bank activity arrives already matched against the ledger on amount, date and reference. What lands on your desk is a reviewed list to approve, not a pile to work through.

Bank reconciliation · Operating · March 2026

Matching

284

Auto-matched

of 291 items

6

Proposed

reason attached

1

Exception

entry drafted

0.00

Unexplained

statement ties

14 Mar · ACH CREDIT · HARBORLINE FOODS · REF INV-2291

A/R · Invoice 2291 · issued 12 Feb · due 14 Mar

Amount, reference and date within 3 days

12,480.00matched

13 Mar · ACH CREDIT · VANTAGE ROBOTICS

A/R · Invoices 2274 + 2288 · part payment

One receipt against two invoices, 8,900.00 still open on 2288

31,100.00split

12 Mar · PAYROLL · GUSTO · RUN 03-12

6000 Salaries + 2110 Accrued payroll · 31 heads

Tied to the payroll register line by line

148,902.14matched

11 Mar · CHECK 2209 · CEDAR & CO

A/P · Bill AP-4380 · Net 30

Cleared 6 days after issue

7,340.00matched

10 Mar · DEBIT · MERCH SVC FEE ADJ

No ledger entry

Fee reversal from Feb, journal entry drafted to 6510, awaiting review

418.22exception
Statement balance · 31 Mar1,284,902.44
Deposits in transit18,220.00
Outstanding checks · 4(31,540.18)
Ledger balance1,271,582.26
Difference0.00

Bank rec · Operating, Mar 2026.pdf

Matched items, exceptions, sign-off

Outstanding items.xlsx

4 checks, 2 deposits, aged

Staged, not posted. The one exception already has its journal entry written and a reason. It goes to a person, never to a suspense account.

Bank matching

Proposals, not postings.

Bank lines are matched against the ledger on amount, date and reference. Strong matches are proposed, weak ones are left alone, and every proposal is staged rather than posted.

Approving is the step that creates the entries: one action for the whole batch. That separation is what makes the speed usable: an auto-matcher that posts on its own is one you have to audit afterwards, and auditing a machine takes longer than doing the work yourself.

And a reconciliation only goes green when a statement balance has been entered and it actually ties. Matched is not reconciled, a distinction that costs firms real money when a system blurs it.

TAI · week of 16 March 2026

Reading the feed

1,184

Posted

on this client's own history

47

In your queue

coded, reasoning attached

9

Routed to Ops

receipt, PO or W-9 missing

0

Uncategorised

and none in suspense

14 Mar · AWS EMEA SARL · INV 8F2K1QP

Posted. Matches 11 prior payments, split 68 / 32 across Production and R&D on the standing cost-allocation rule.

4,182.606300 · Infrastructure

13 Mar · RAMP CARD SETTLEMENT · 41 items

Cleared against 41 receipts. 2 missing, chased J. Okafor and M. Silva, due 20 Mar.

18,447.021015 · Card clearing

12 Mar · WIRE · HEIDRICK & STRUGGLES

Matched to PO-1188. Contract is three instalments, with the remaining 84,000.00 accrued to 2100.

42,000.006710 · Recruiting

11 Mar · STRIPE TRANSFER · ST-99204471

Split three ways: 60,903.88 to 4000 Revenue, 2,004.26 to 6510 Processing fees, 1,000.00 to 2400 Refund reserve.

63,908.143-way split

09 Mar · CHK 2214 · NW HOLDINGS LLC

First payment to this payee. Posted on the pattern from two prior contractors, W-9 requested, 1099-NEC flag set. In your queue to confirm or recode.

4,200.006120 · Contractors

07 Mar · DEP · LANDLORD REFUND

Reversed the 2024 deposit. Lease ends 30 Jun, so the ROU asset and liability are remeasured, ASC 842 rollforward updated.

15,000.001450 · Deposit

Already drafted, for dates that have not arrived

6 drafted ahead
31 MAR

Month-end close · 14 of 22 items pre-run

6 journal entries drafted: 9,750.00 rent accrual, 1,250.00 prepaid insurance, 6,133.00 depreciation across 14 assets, 22,910.00 deferred revenue release.

Accounting · D. Okonjo to review

01 APR

Rent escalation +3.5%

Lease clause 6(b). ASC 842 remeasurement drafted: ROU asset +38,204.00, liability +38,204.00, straight-line rent re-spread over 27 months.

Accounting · schedule attached

12 APR

AWS renewal · 50,190.00 / yr

Prepaid schedule drafted with 12 amortisation lines at 4,182.50. Seat count needs confirming before it posts.

Ops · A. Reyes, due 08 Apr

14 APR

Ohio economic nexus · 94,120 of 100,000

Threshold trips at this run rate in about six weeks. Registration task created and assigned, ahead of the Q2 filing.

Ops · M. Silva, due 14 Apr

30 APR

1099-NEC · 3 vendors missing W-9

Chased 04 Mar, two returned. Northwind Holdings outstanding; the filing is blocked on it and nothing else.

Ops · chase scheduled 21 Mar

30 JUN

Lease expiry · Suite 400

Termination notice is due 90 days out, on 01 Apr. Calendar item created, deposit reversal already posted this month.

Ops · decision needed by 25 Mar

Nothing waits in an uncategorised bucket. Where TAI is less than certain it still posts to the account this client's own books support, says why, and puts the row in your queue, so the review list is decisions to confirm, not a suspense account someone has to remember.

Subledgers

They have to agree with the control account.

A/P and A/R registers, the fixed asset register, vendor records and 1099 tracking all reconcile back to their control accounts, and the difference is shown rather than assumed to be zero.

Aging detail for both receivables and payables comes out of the same data, so what you send a client and what sits in the ledger cannot drift apart.

Fixed assets depreciate on a straight-line basis with a whole-month convention, posting through the close like any other schedule.

Reconciles to control

Tied
  • 01Accounts payable register
  • 02Accounts receivable register, with allowance and credit memos
  • 03Fixed asset register and depreciation
  • 04Vendor records and 1099 tracking
Vendors

Onboarding, records and 1099s in the same place as the bills.

Vendor onboarding collects what you need at the point you need it, rather than in January when the 1099 deadline arrives and half your vendors have no tax details on file.

Because the vendor record, the bills and the payments live in one system, the 1099 position is a query rather than a project.

Field request · Operations

Submitted

Atlassian · annual licences, 12 seats

A. Reyes · renewal 12 Apr · PO-1204

2,400.00
Budget · Engineering software18,000 / 24,000
Approver · dept headM. Silva · 11 Mar
Approver · financeD. Okonjo · 12 Mar
6420 · SoftwareQ3 RolloutEngineeringPrepaid · 12 mo

Accounts payable

Draft bill · AP-4417
Vendor · Atlassian Pty LtdW-9 on file
Amount2,400.00
Matched toPO-1204 · exact
TermsNet 30 · due 11 Apr
Coding6420 · carried through

TAI also drafted, unprompted

  • Prepaid schedule · 12 lines at 200.00, first release 30 Apr
  • Close item added to April · “Release Atlassian prepaid”
  • Project cost allocated · Q3 Rollout, 2,400.00 to Engineering
Waiting on finance review. Still not posted.

Screen capture · Bank match, 11s. Run auto-propose, review the staged matches, approve, entries post.

The short version

Reconciled means reconciled, not nearly.

The statement balance is in, the difference is zero, and it took an afternoon instead of a fortnight.

Next

Technical accounting

ASC 842 classification and rollforwards, ASC 606 allocation, multi-currency revaluation, and consolidation with intercompany eliminations.