SHORT ANSWER · PROOF OF CASH
Is there a free proof of cash template?
Yes. A proof of cash template is a label column plus four amount columns: Beginning balance, Receipts, Disbursements and Ending balance. Under them go a bank row at the top and a books total at the bottom, with reconciling items between. Copy the layout below into Excel. The example uses Matter 25-117, and every row ties.
THE TEMPLATE
What goes in a four-column proof of cash template?
Five headers and at least four rows, shown here with example amounts. A proof of cash needs nothing more than this to start. Choosing a tool? See the best proof of cash software.
| Beginning balance | Receipts | Disbursements | Ending balance | |
|---|---|---|---|---|
| Balance per bank statement | 14,902.35 | 8,120.00 | 4,781.80 | 18,240.55 |
| Add: deposit in transit, month end | 500.00 | 500.00 | ||
| Less: outstanding check 3290 | 312.40 | −312.40 | ||
| Balance per books | 14,902.35 | 8,620.00 | 5,094.20 | 18,428.15 |
Example amounts are from Matter 25-117, a fictional matter. Put a check formula at the end of each row: Beginning + Receipts − Disbursements − Ending should be 0.00.
ZeraBooks builds the workflow around your matters and your template for free. No development charge, whether it’s a forensic department or one person.
FILLING IT IN
How do you fill in the template for your own client?
Start from the statement, then add one row for every item that is open or missing. The steps are on how do you do a proof of cash?
- Take the bank row from a statement you have proven: opening plus every row equals the printed closing.
- Add a row for deposits in transit at the start of the month: in Beginning balance, then out of Receipts.
- Add a row for checks still outstanding from the prior month: in Beginning balance as a minus, then out of Disbursements.
- Add rows for month-end deposits in transit and outstanding checks, as in the example.
- Add a row for anything on the statement the books don’t have yet, such as a bank fee.
- Total each column down and compare it with the books. Read the difference between a proof of cash and a bank reconciliation if only the ending column is checked today.
Can I use this template in Excel?
Yes. Type the five headers across row 1 and the row labels down column A, then add a check column with the row formula.
How many rows does a proof of cash need?
At least a bank row and a books row. Add one row for each reconciling item, at either end of the month.
Can ZeraBooks fill in the bank row?
Yes. It proves each statement and gives Money In and Money Out as columns. With a free custom build, the output can match your own proof of cash workpaper cell by cell.
FREE CUSTOM BUILD
Copy the layout.
Let ZeraBooks fill the bank row.
Send one past matter and see its statements proven and laid out in your own template.