Free · Excel · no macros
The Tie-Out Template: tie a fiduciary account or a net worth statement to the bank records.
Enter the statements, the transactions and the figures being tested. Fifteen checks run on their own, and every exception points to its document, page and line.
What you get
- The fifteen checks: statement math; opening equals prior closing; gaps between statements; keyed lines against statement totals; every claimed receipt and disbursement matched to a bank line; bank lines on no claimed list; transfers that leave the listed accounts; unlisted account endings; check gaps and duplicates; cash near $10,000; round amounts; related-party payments; activity around your key dates; claimed balances against the records; and a Schedule J-style cash reconciliation.
- A blank workbook and a sample filled with invented data, so you can watch every check fire.
- Works in Excel 2019 or later, Microsoft 365, LibreOffice and Google Sheets.
For matrimonial, estate and commercial litigators, and the forensic accountants who work with them.
Evidence Sweep
Fixed-fee offline analysis of financial productions for New York litigators and forensic accountants. Every figure cited to its page and line in 72 hours.