{"product_id":"petty-cash-reconciliation-excel-template-cash-count-receipt-tracking-spreadsheet-small-business-accounting-template","title":"Petty Cash Reconciliation Excel Template | Cash Count \u0026 Receipt Tracking Spreadsheet | Small Business Accounting Template","description":"\u003cp class=\"MsoNormal\"\u003eKeep your petty cash records organized with this \u003cb\u003ePetty Cash Reconciliation Excel Spreadsheet Template\u003c\/b\u003e, designed to make routine cash reconciliation simple, structured, and easy to document. \u003c\/p\u003e\n\u003cp class=\"MsoNormal\"\u003eThis reusable Excel template helps you count physical cash by denomination, record receipts, account for advances and submitted replenishments, and compare your reconciled petty cash against the approved fund amount.\u003c\/p\u003e\n\u003cp class=\"MsoNormal\"\u003eBuilt-in formulas automatically calculate key totals, helping you quickly identify any difference between the amount accounted for and the approved petty cash fund.\u003c\/p\u003e\n\u003cp class=\"MsoNormal\"\u003e\u003cb\u003eWhat’s Included\u003c\/b\u003e\u003c\/p\u003e\n\u003cp class=\"MsoNormal\"\u003e\u003cspan style=\"font-family: 'Segoe UI Symbol',sans-serif; mso-bidi-font-family: 'Segoe UI Symbol';\"\u003e✓\u003c\/span\u003e Petty Cash Reconciliation Worksheet\u003cbr\u003e\u003cspan style=\"font-family: 'Segoe UI Symbol',sans-serif; mso-bidi-font-family: 'Segoe UI Symbol';\"\u003e✓\u003c\/span\u003e Currency Denomination Tracking\u003cbr\u003e\u003cspan style=\"font-family: 'Segoe UI Symbol',sans-serif; mso-bidi-font-family: 'Segoe UI Symbol';\"\u003e✓\u003c\/span\u003e Automatic Cash Balance Calculations\u003cbr\u003e\u003cspan style=\"font-family: 'Segoe UI Symbol',sans-serif; mso-bidi-font-family: 'Segoe UI Symbol';\"\u003e✓\u003c\/span\u003e Receipts on Hand Tracking\u003cbr\u003e\u003cspan style=\"font-family: 'Segoe UI Symbol',sans-serif; mso-bidi-font-family: 'Segoe UI Symbol';\"\u003e✓\u003c\/span\u003e Automatic Total Receipts\u003cbr\u003e\u003cspan style=\"font-family: 'Segoe UI Symbol',sans-serif; mso-bidi-font-family: 'Segoe UI Symbol';\"\u003e✓\u003c\/span\u003e Advances Tracking\u003cbr\u003e\u003cspan style=\"font-family: 'Segoe UI Symbol',sans-serif; mso-bidi-font-family: 'Segoe UI Symbol';\"\u003e✓\u003c\/span\u003e Replenishments Currently Submitted\u003cbr\u003e\u003cspan style=\"font-family: 'Segoe UI Symbol',sans-serif; mso-bidi-font-family: 'Segoe UI Symbol';\"\u003e✓\u003c\/span\u003e Automatic Reconciled Petty Cash Total\u003cbr\u003e\u003cspan style=\"font-family: 'Segoe UI Symbol',sans-serif; mso-bidi-font-family: 'Segoe UI Symbol';\"\u003e✓\u003c\/span\u003e Approved Petty Cash Comparison\u003cbr\u003e\u003cspan style=\"font-family: 'Segoe UI Symbol',sans-serif; mso-bidi-font-family: 'Segoe UI Symbol';\"\u003e✓\u003c\/span\u003e Automatic Difference Calculation\u003cbr\u003e\u003cspan style=\"font-family: 'Segoe UI Symbol',sans-serif; mso-bidi-font-family: 'Segoe UI Symbol';\"\u003e✓\u003c\/span\u003e Custodian \u0026amp; Department Information\u003cbr\u003e\u003cspan style=\"font-family: 'Segoe UI Symbol',sans-serif; mso-bidi-font-family: 'Segoe UI Symbol';\"\u003e✓\u003c\/span\u003e Signature Sections\u003cbr\u003e\u003cspan style=\"font-family: 'Segoe UI Symbol',sans-serif; mso-bidi-font-family: 'Segoe UI Symbol';\"\u003e✓\u003c\/span\u003e Disclaimer \/ Reference Tab\u003c\/p\u003e\n\u003cp class=\"MsoNormal\"\u003e\u003cb\u003eHow It Works\u003c\/b\u003e\u003c\/p\u003e\n\u003cp class=\"MsoNormal\"\u003e\u003cb\u003e1. Add Fund Details\u003c\/b\u003e\u003cbr\u003eEnter the date, custodian information, department, fund number, and total approved petty cash.\u003c\/p\u003e\n\u003cp class=\"MsoNormal\"\u003e\u003cb\u003e2. Count Your Cash\u003c\/b\u003e\u003cbr\u003eEnter the quantity of each currency denomination. The spreadsheet calculates the corresponding cash balances and total cash on hand.\u003c\/p\u003e\n\u003cp class=\"MsoNormal\"\u003e\u003cb\u003e3. Record Supporting Amounts\u003c\/b\u003e\u003cbr\u003eEnter receipts on hand, advances, and replenishments currently submitted.\u003c\/p\u003e\n\u003cp class=\"MsoNormal\"\u003e\u003cb\u003e4. Review Your Reconciliation\u003c\/b\u003e\u003cbr\u003eThe spreadsheet calculates the total reconciled petty cash and compares it with the approved petty cash amount so you can review the resulting difference.\u003c\/p\u003e\n\u003cp class=\"MsoNormal\"\u003e\u003cb\u003ePerfect For\u003c\/b\u003e\u003c\/p\u003e\n\u003cp class=\"MsoNormal\"\u003e• Small Business Owners\u003cbr\u003e• Bookkeepers\u003cbr\u003e• Office Administrators\u003cbr\u003e• Finance Teams\u003cbr\u003e• Department Managers\u003cbr\u003e• Petty Cash Custodians\u003cbr\u003e• Entrepreneurs\u003cbr\u003e• Administrative Professionals\u003c\/p\u003e\n\u003cp class=\"MsoNormal\"\u003e\u003cb\u003eWhy You’ll Love It\u003c\/b\u003e\u003c\/p\u003e\n\u003cp class=\"MsoNormal\"\u003e\u003cspan style=\"font-family: 'Segoe UI Symbol',sans-serif; mso-bidi-font-family: 'Segoe UI Symbol';\"\u003e✓\u003c\/span\u003e Simple and organized layout\u003cbr\u003e\u003cspan style=\"font-family: 'Segoe UI Symbol',sans-serif; mso-bidi-font-family: 'Segoe UI Symbol';\"\u003e✓\u003c\/span\u003e Built-in Excel calculations\u003cbr\u003e\u003cspan style=\"font-family: 'Segoe UI Symbol',sans-serif; mso-bidi-font-family: 'Segoe UI Symbol';\"\u003e✓\u003c\/span\u003e Reusable for ongoing reconciliations\u003cbr\u003e\u003cspan style=\"font-family: 'Segoe UI Symbol',sans-serif; mso-bidi-font-family: 'Segoe UI Symbol';\"\u003e✓\u003c\/span\u003e Tracks multiple components of petty cash\u003cbr\u003e\u003cspan style=\"font-family: 'Segoe UI Symbol',sans-serif; mso-bidi-font-family: 'Segoe UI Symbol';\"\u003e✓\u003c\/span\u003e Helps document cash counts and receipts\u003cbr\u003e\u003cspan style=\"font-family: 'Segoe UI Symbol',sans-serif; mso-bidi-font-family: 'Segoe UI Symbol';\"\u003e✓\u003c\/span\u003e Quickly highlights reconciliation differences\u003cbr\u003e\u003cspan style=\"font-family: 'Segoe UI Symbol',sans-serif; mso-bidi-font-family: 'Segoe UI Symbol';\"\u003e✓\u003c\/span\u003e Professional business-friendly format\u003c\/p\u003e\n\u003cp class=\"MsoNormal\"\u003e\u003cb\u003eDigital Product\u003c\/b\u003e\u003c\/p\u003e\n\u003cp class=\"MsoNormal\"\u003eThis is a \u003cb\u003edigital Excel spreadsheet template\u003c\/b\u003e. No physical product will be shipped.\u003c\/p\u003e\n\u003cp class=\"MsoNormal\"\u003eDownload the file, open it in Microsoft Excel, enter your information, and reuse the template whenever you need to perform a petty cash reconciliation.\u003c\/p\u003e\n\u003cp class=\"MsoNormal\"\u003e\u003cb\u003eImportant:\u003c\/b\u003e This template is provided as a general organizational and record-keeping resource. Please review the included disclaimer and determine whether the template is appropriate for your individual business, accounting, or record-keeping requirements.\u003c\/p\u003e","brand":"My Template Vault","offers":[{"title":"Default Title","offer_id":58536457568639,"sku":null,"price":1.98,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1010\/1381\/5679\/files\/PettyCashReconciliation_1.png?v=1790467067","url":"https:\/\/mytemplatevault.com\/products\/petty-cash-reconciliation-excel-template-cash-count-receipt-tracking-spreadsheet-small-business-accounting-template","provider":"My Template Vault","version":"1.0","type":"link"}