SaleLedger by ProfitPin
SaleLedger · Sample report

What the monthly report looks like.

This is the real output for the practice month that ships with the tutorial: a fictional auction house, auction 246, opening balance $150,000.00, as of 2026-08-31. It is out of balance on purpose so you can see how every gap is named. No real business or person appears in it.

Trust Reconciliation OUT OF BALANCE

Bank adjusted balance$166,730.00
Trust control balance$150,475.00
Consignor subledger total$150,000.00

Exceptions (8)

1. DISBURSEMENT MISMATCH — Consignor A (Settlement payout - Auction 246 - STL-246): ledger recorded $27,200.00, but bank cleared $27,700.00 on 2026-08-09. Overpayment of $500.00.
2. UNMATCHED RECEIPT — $20,000.00 deposit on 2026-08-12 (Deposit - buyer payment): no corresponding auction/consignor transaction found in the ledger.
3. UNMATCHED DISBURSEMENT — $10,200.00 debited on 2026-08-15 (Check 1045 - Consignor D): no corresponding ledger entry or authorization found.
4. UNMATCHED DISBURSEMENT — $2,950.00 debited on 2026-08-15 (Wire out - operating account transfer): no corresponding ledger entry or authorization found.
5. UNMATCHED RECEIPT — $10,000.00 deposit on 2026-08-20 (Deposit - unidentified): no corresponding auction/consignor transaction found in the ledger.
6. UNMATCHED RECEIPT — $18,360.00 deposit on 2026-08-21 (Deposit - buyer payment (Auction 248)): no corresponding auction/consignor transaction found in the ledger.
7. UNMATCHED DISBURSEMENT — $18,360.00 debited on 2026-08-22 (Check 1046 - Consignor F): no corresponding ledger entry or authorization found.
8. UNMATCHED DISBURSEMENT — $95.00 debited on 2026-08-31 (Monthly service fee): no corresponding ledger entry or authorization found.

Check Register

Includes the bookkeeping fields named in Wisconsin SPS 125.12(1): date, payee, check number, amount. Whether your records meet your state's rules is for you and your accountant to determine.

DateCheck #PayeeAmount
2026-08-091042Consignor A$27,200.00
2026-08-091043Consignor C$29,150.00
2026-08-101044Consignor B$15,425.00
2026-08-10(wire/transfer)HOUSE$12,750.00

How to read it

The routine around this report is in the monthly reconciliation guide. To produce it yourself with the same fictional files, follow the tutorial.

YOUR OWN MONTH, IN MINUTES

Run this on your records.

Settlement export, QuickBooks file, bank statement — three files in, this report out, on your own computer. $129.00/month, first 30 days free, cancel any time.

Start free trial ↗