September 2026 close, Lakeview Dental Group
- Collect
- Verify at the bank
- Book it
- Name the exceptions
Running the close
Checking…
Step 1 of 4: CollectStep 2 of 4: Verify at the bankStep 3 of 4: Book itStep 4 of 4: Name the exceptions
Not close ready
$11,939.02
4 open items, 2 material
Payments tied out
1,408 of 1,412
PMS to bank to ledger
Bridge to the bank feed
Checking…$0.00
difference after timing and fees
Insurance paymentsPMS posted
- Has an open amountEFT$162,310.00
- Has an open amountCheck$41,850.00
- Tied outVirtual card$21,800.00
Patient paymentsPMS posted
- Tied outCard$118,240.00
- Tied outText-to-pay$31,600.00
- Has an open amountCheck$29,180.00
- Tied outCash$17,400.00
Tied outHas an open amount
Group total
- PMS posted
- $422,380.00
- Bank verified
- $416,277.60
- Booked
- $409,140.00
- Open
- $11,939.02
Drawn to scale. Open is 2.8% of what was posted, in 4 items with an owner.
Insurance
- PMS posted
- $225,960.00
- Bank verified
- $221,147.60
- Booked
- $218,930.00
- Open
- $11,016.58
Patient
- PMS posted
- $196,420.00
- Bank verified
- $195,130.00
- Booked
- $190,210.00
- Open
- $310.00
Suspense
- Open
- $612.44
| By payment type | PMS posted | Bank verified | Booked | Open |
|---|---|---|---|---|
| Insurance | $225,960.00 | $221,147.60 | $218,930.00 | $11,016.58 |
| Patient | $196,420.00 | $195,130.00 | $190,210.00 | $310.00 |
| Suspense | · | · | · | $612.44 |
| Group total | $422,380.00 | $416,277.60 | $409,140.00 | $11,939.02 |
By location
- DowntownClose ready
Dentrix · $128,410.00 posted
$0.00 open - LakeviewAttention
Open Dental · $112,980.00 posted
$4,812.40 open - WestsideReview
Eaglesoft · $96,330.00 posted
$310.00 open - NorthAttention
Dentrix · $84,660.00 posted
$6,816.62 open
Open items, each with an owner
Delta Dental EFT in the bank, not yet posted
$6,204.18Material
Dana K., BillerNorth2 days
Aetna check posted, never deposited
$4,812.40Material
Luis P., Office managerLakeview26 days
Unidentified bank credit
$612.44
Sam T., ControllerNorthIn research
NSF not reversed
$310.00
Rosa M., Office managerWestside14 days
Unattributed cash is never spread by percentage. Nothing is plugged to make the month close.
Illustrative reconciliation, sample data. Every row and column adds up.
