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.
A sworn number is a claim. A tie-out checks it against the bank. The template runs 15 of those checks once the statements are keyed in.
Three of them do most of the work. Every claimed figure has a bank line behind it. Every bank line over your threshold is on a claimed list. Every claimed balance matches the records on its date. The other twelve catch the gaps: a missing month, a skipped check number, a statement that does not add up to its own totals.
Start on the Setup tab, then Statements, then Transactions. The Summary tab shows which checks fail. The Exceptions tab lists each one with the page it came from, so the person checking does not have to hunt.
Excel, no macros, nothing leaves your machine. Free. We ask for an email so we can send updates to the checks. No sequence, no calls.
Built for a New York litigation practice.
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.