Worksheet

Branch reconciliation worksheet

One sheet, one mismatch per row. Columns are item code, branch, document type, document number, the quantity at the branch, the same figure at head office and the gap. Two last columns name the cause from four buckets (code, price, transfer, ledger) and a named owner for the fix, and a footer lists the global masters.

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 “Why branch data stops matching across your branches”, www.gullysystem.com/blog/why-branch-data-stops-matching-across-your-branches