Worksheet

Opening balance tie out sheet

A spreadsheet with one row per account. Columns cover account, old trial balance, sub ledger total, loaded balance, new trial balance, difference, suspense item, owner and cleared date, with a sign-off line. A second tab lists every open item.

Name: ______________________   Business: ______________________   Date: ______________

Scroll the table sideways to see every column.

Cross out or rewrite any heading that does not fit your business. From the guide “How to set opening balances in new software from your old books”, www.gullysystem.com/blog/how-to-set-opening-balances-in-new-software-from-your-old-books