{"title":"Cash Flow \u0026 Cash Management Templates","description":"\u003cp\u003e\u003cstrong\u003eKnow exactly how much cash you have, and how much you will have next month.\u003c\/strong\u003e Profit on paper doesn't pay salaries; cash in the bank does. These Excel cash flow templates help small businesses track money in and out, forecast the weeks ahead, reconcile the bank and keep petty cash and till records tidy.\u003c\/p\u003e\n\u003ch2\u003eWhat's in this collection\u003c\/h2\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003e\u003ca href=\"\/products\/cash-flow-tracker-excel-template\"\u003eCash Flow Tracker\u003c\/a\u003e:\u003c\/strong\u003e record receipts and payments by category and always see your running bank balance.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003e\u003ca href=\"\/products\/13-week-cash-flow-forecast-excel-template\"\u003e13-Week Cash Flow Forecast\u003c\/a\u003e:\u003c\/strong\u003e plan cash week by week for the next quarter and spot your lowest cash point before it arrives.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003e\u003ca href=\"\/products\/bank-reconciliation-excel-template\"\u003eBank Reconciliation\u003c\/a\u003e:\u003c\/strong\u003e match the bank statement with your cash book and prove the difference is zero.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003e\u003ca href=\"\/products\/petty-cash-log-excel-template\"\u003ePetty Cash Log\u003c\/a\u003e\u003c\/strong\u003e and \u003cstrong\u003e\u003ca href=\"\/products\/daily-cash-count-till-reconciliation-excel-template\"\u003eDaily Cash Count \u0026amp; Till Reconciliation\u003c\/a\u003e:\u003c\/strong\u003e control small expenses and catch till shortages the same day.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eCheque and receivables tools\u003c\/strong\u003e, such as the \u003ca href=\"\/products\/cheque-register-pdc-tracker-excel-template\"\u003ePDC Tracker\u003c\/a\u003e, so post-dated cheques never surprise you.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch2\u003eWho these templates are for\u003c\/h2\u003e\n\u003cp\u003eOwner-managed businesses, shops, restaurants, contractors and freelancers who want a clear view of cash without accounting software, and accountants who need a quick forecasting file for clients.\u003c\/p\u003e\n\u003ch2\u003eA simple weekly cash routine\u003c\/h2\u003e\n\u003col\u003e\n\u003cli\u003eOnce a week, update the cash flow tracker with actual receipts and payments from your bank.\u003c\/li\u003e\n\u003cli\u003eRoll the 13-week forecast forward: replace last week's estimate with the actual figures and add a new week at the end.\u003c\/li\u003e\n\u003cli\u003eCheck the lowest balance in the forecast. If it dips below your safety buffer, act now by chasing receivables, timing supplier payments or arranging finance.\u003c\/li\u003e\n\u003cli\u003eReconcile the bank account monthly so your figures stay accurate.\u003c\/li\u003e\n\u003c\/ol\u003e\n\u003ch2\u003eWhy a cash forecast matters\u003c\/h2\u003e\n\u003cp\u003eMost small businesses that get into trouble don't run out of customers; they run out of cash between paying suppliers and getting paid. A rolling forecast gives you weeks of warning instead of days, and makes conversations with your bank or partners far easier.\u003c\/p\u003e\n\u003cp\u003eWant the full finance toolkit? See our \u003ca href=\"\/collections\/bundles\"\u003ebundles\u003c\/a\u003e or get 25 business templates for AED 29 in the \u003ca href=\"\/collections\/value-packs\"\u003evalue packs\u003c\/a\u003e.\u003c\/p\u003e\n\u003ch2\u003eFrequently asked questions\u003c\/h2\u003e\u003ch3\u003eWhat's the difference between a cash flow tracker and a cash flow forecast?\u003c\/h3\u003e\u003cp\u003eA tracker records what has already happened. A forecast projects what will happen. Use both: the tracker keeps the forecast honest.\u003c\/p\u003e\u003ch3\u003eIs this the same as a cash flow statement for financial reports?\u003c\/h3\u003e\u003cp\u003eNo. These are management tools for day-to-day decisions. A formal cash flow statement for audited accounts should be prepared by your accountant.\u003c\/p\u003e\u003ch3\u003eCan I track more than one bank account?\u003c\/h3\u003e\u003cp\u003eYes. Add an account column or keep one copy of the tracker per account; the formulas work either way.\u003c\/p\u003e\u003ch3\u003eDo I need advanced Excel skills?\u003c\/h3\u003e\u003cp\u003eNo. You type figures into the white input cells and the formulas do the rest. Each file has a How to Use sheet.\u003c\/p\u003e","products":[{"product_id":"cash-flow-tracker-excel-template","title":"Cash Flow Tracker – Excel Template","description":"\u003cp\u003e\u003cstrong\u003eRecord cash coming in and going out and always know your running bank balance.\u003c\/strong\u003e\u003c\/p\u003e\u003ch3\u003eWhat's included\u003c\/h3\u003e\u003cul\u003e\n\u003cli\u003eAutomatic summary: Total cash in, Total cash out, Net cash flow, Closing balance\u003c\/li\u003e\n\u003cli\u003eCalculated for you: Balance\u003c\/li\u003e\n\u003cli\u003eDrop-down menus for quick, consistent entry\u003c\/li\u003e\n\u003cli\u003eColour-coded status and progress highlights\u003c\/li\u003e\n\u003cli\u003eExample rows and a step-by-step \"How to Use\" sheet\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003eWorks with\u003c\/h3\u003e\u003cp\u003e\u003cstrong\u003eInstant download\u003c\/strong\u003e (.xlsx). Works in Microsoft Excel 2010+, Excel for the web, Google Sheets, Apple Numbers and LibreOffice. Currency-neutral, so it works with AED, USD, EUR, INR, GBP or any other currency.\u003c\/p\u003e","brand":"The Template Desk","offers":[{"title":"Default Title","offer_id":46220893847687,"sku":"XLT-012","price":15.0,"currency_code":"AED","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0767\/5369\/8951\/files\/1EBbA1etWjjorylAF8yktMuncXyHxnYbf.png?v=1792935217"},{"product_id":"petty-cash-log-excel-template","title":"Petty Cash Log – Excel Template","description":"\u003cp\u003e\u003cstrong\u003eControl small office expenses with vouchers, approvals and an automatic float balance.\u003c\/strong\u003e\u003c\/p\u003e\u003ch3\u003eWhat's included\u003c\/h3\u003e\u003cul\u003e\n\u003cli\u003eAutomatic summary: Float, Spent, Cash remaining, Top-up required\u003c\/li\u003e\n\u003cli\u003eDrop-down menus for quick, consistent entry\u003c\/li\u003e\n\u003cli\u003eBuilt-in chart that updates as you type\u003c\/li\u003e\n\u003cli\u003eExample rows and a step-by-step \"How to Use\" sheet\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003eWorks with\u003c\/h3\u003e\u003cp\u003e\u003cstrong\u003eInstant download\u003c\/strong\u003e (.xlsx). Works in Microsoft Excel 2010+, Excel for the web, Google Sheets, Apple Numbers and LibreOffice. Currency-neutral, so it works with AED, USD, EUR, INR, GBP or any other currency.\u003c\/p\u003e","brand":"The Template Desk","offers":[{"title":"Default Title","offer_id":46220893913223,"sku":"XLT-014","price":5.0,"currency_code":"AED","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0767\/5369\/8951\/files\/1JTcoBrqxxwnifYc23Wrtk7Zo4X2E5A4H.png?v=1792935217"},{"product_id":"daily-cash-count-till-reconciliation-excel-template","title":"Daily Cash Count \u0026 Till Reconciliation – Excel Template","description":"\u003cp\u003e\u003cstrong\u003eCount notes and coins at closing and instantly see whether the till is over or short against expected cash.\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eAutomatic summary: Cash counted, Expected cash in till, Over \/ (short), To bank (counted − float)\u003c\/li\u003e\n\u003cli\u003eCalculated for you: Total\u003c\/li\u003e\n\u003cli\u003eExample rows and a step-by-step \"How to Use\" sheet\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003cstrong\u003eInstant download\u003c\/strong\u003e (.xlsx). Works in Excel 2010+, Excel online, Google Sheets, Numbers and LibreOffice. Works with any currency.\u003c\/p\u003e","brand":"The Template Desk","offers":[{"title":"Default Title","offer_id":46220910329991,"sku":"XLT-122","price":5.0,"currency_code":"AED","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0767\/5369\/8951\/files\/18TOHCZJWjLOXAUlOpSllho_x3K68uAHj.png?v=1792935588"},{"product_id":"13-week-cash-flow-forecast-excel-template","title":"13-Week Cash Flow Forecast – Excel Template","description":"\u003cp\u003e\u003cstrong\u003eForecast cash week by week for the next quarter, spot shortfalls early and see your lowest cash point.\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eAutomatic summary: Lowest closing cash, Week of lowest cash, Weeks below buffer, Cash at end of quarter\u003c\/li\u003e\n\u003cli\u003eCalculated for you: Week, Week starting, Opening cash, Net cash flow, Closing cash, Status\u003c\/li\u003e\n\u003cli\u003eColour-coded status and progress highlights\u003c\/li\u003e\n\u003cli\u003eBuilt-in chart that updates as you type\u003c\/li\u003e\n\u003cli\u003eExample rows and a step-by-step \"How to Use\" sheet\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003cstrong\u003eInstant download\u003c\/strong\u003e (.xlsx). Works in Excel 2010+, Excel online, Google Sheets, Numbers and LibreOffice. Works with any currency.\u003c\/p\u003e","brand":"The Template Desk","offers":[{"title":"Default Title","offer_id":46222826504327,"sku":"XLT-175","price":5.0,"currency_code":"AED","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0767\/5369\/8951\/files\/1D-V4eiil7uCNu4Ffzit7iQ9MLha20N5H.png?v=1792935719"},{"product_id":"bank-reconciliation-excel-template","title":"Bank Reconciliation – Excel Template","description":"\u003cp\u003e\u003cstrong\u003eReconcile your bank statement with your cash book, list outstanding items and prove the difference is zero.\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eAutomatic summary: Adjusted bank balance, Adjusted book balance, Difference, Result\u003c\/li\u003e\n\u003cli\u003eCalculated for you: Adjust bank, Adjust book\u003c\/li\u003e\n\u003cli\u003eDrop-down menus for quick, consistent entry\u003c\/li\u003e\n\u003cli\u003eColour-coded status and progress highlights\u003c\/li\u003e\n\u003cli\u003eExample rows and a step-by-step \"How to Use\" sheet\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003cstrong\u003eInstant download\u003c\/strong\u003e (.xlsx). Works in Excel 2010+, Excel online, Google Sheets, Numbers and LibreOffice. Works with any currency.\u003c\/p\u003e","brand":"The Template Desk","offers":[{"title":"Default Title","offer_id":46222826602631,"sku":"XLT-176","price":5.0,"currency_code":"AED","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0767\/5369\/8951\/files\/1Lrd2fThmH5GKk155usuOpoKhatMj0vOY.png?v=1792935719"},{"product_id":"working-capital-cash-conversion-cycle-excel-template","title":"Working Capital \u0026 Cash Conversion Cycle – Excel Template","description":"\u003cp\u003e\u003cstrong\u003eCalculate days sales outstanding, days inventory, days payables and your cash conversion cycle period by period.\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eAutomatic summary: Latest cash conversion cycle, Latest working capital\u003c\/li\u003e\n\u003cli\u003eCalculated for you: Debtor days (DSO), Inventory days (DIO), Creditor days (DPO), Cash conversion cycle (days), Working capital\u003c\/li\u003e\n\u003cli\u003eBuilt-in chart that updates as you type\u003c\/li\u003e\n\u003cli\u003eExample rows and a step-by-step \"How to Use\" sheet\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003cstrong\u003eInstant download\u003c\/strong\u003e (.xlsx). Works in Excel 2010+, Excel online, Google Sheets, Numbers and LibreOffice. Works with any currency.\u003c\/p\u003e","brand":"The Template Desk","offers":[{"title":"Default Title","offer_id":46222862385287,"sku":"XLT-241","price":5.0,"currency_code":"AED","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0767\/5369\/8951\/files\/1hKDKlU2LSNWWhS0Moij8w7eS0vXNVODg.png?v=1792935975"},{"product_id":"cash-on-delivery-cod-reconciliation-excel-template","title":"Cash on Delivery (COD) Reconciliation – Excel Template","description":"\u003cp\u003e\u003cstrong\u003eMatch cash-on-delivery orders to courier remittances, catch missing or short payments and see what each courier still owes.\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eAutomatic summary: COD collected by couriers, Remitted to us, Courier fees, Still owed by couriers, Mismatches\u003c\/li\u003e\n\u003cli\u003eCalculated for you: Collected by courier, Difference, Status\u003c\/li\u003e\n\u003cli\u003eDrop-down menus for quick, consistent entry\u003c\/li\u003e\n\u003cli\u003eColour-coded status and progress highlights\u003c\/li\u003e\n\u003cli\u003eExample rows and a step-by-step \"How to Use\" sheet\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003cstrong\u003eInstant download\u003c\/strong\u003e (.xlsx). Works in Excel 2010+, Excel online, Google Sheets, Numbers and LibreOffice. Works with any currency.\u003c\/p\u003e","brand":"The Template Desk","offers":[{"title":"Default Title","offer_id":46224495804551,"sku":"XLT-263","price":5.0,"currency_code":"AED","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0767\/5369\/8951\/files\/1iWpbxxYG4fYKwe8GJSjkcD6RRBC7OpDm.png?v=1792935984"},{"product_id":"cash-bank-book-excel-template","title":"Cash \u0026 Bank Book – Excel Template","description":"\u003cp\u003e\u003cstrong\u003eA two-column cash book for small businesses: record cash and bank receipts and payments with running balances for both.\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eAutomatic summary: Closing cash in hand, Closing bank balance, Total receipts, Total payments\u003c\/li\u003e\n\u003cli\u003eCalculated for you: Cash balance, Bank balance, Net\u003c\/li\u003e\n\u003cli\u003eDrop-down menus for quick, consistent entry\u003c\/li\u003e\n\u003cli\u003eColour-coded status and progress highlights\u003c\/li\u003e\n\u003cli\u003eExample rows and a step-by-step \"How to Use\" sheet\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003cstrong\u003eInstant download\u003c\/strong\u003e (.xlsx). Works in Excel 2010+, Excel online, Google Sheets, Numbers and LibreOffice. Works with any currency.\u003c\/p\u003e","brand":"The Template Desk","offers":[{"title":"Default Title","offer_id":46224503111815,"sku":"XLT-296","price":5.0,"currency_code":"AED","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0767\/5369\/8951\/files\/1CLMcYlbp75Y1HtjDE_N_gL9GewtKLUVm.png?v=1792936111"},{"product_id":"supplier-payment-run-planner-excel-template","title":"Supplier Payment Run Planner – Excel Template","description":"\u003cp\u003e\u003cstrong\u003ePlan a weekly supplier payment run: invoices due, priorities and early-payment discounts, a running total and a check against cash available.\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eAutomatic summary: Selected to pay, Cash left after run, Overdue not selected, Discounts captured\u003c\/li\u003e\n\u003cli\u003eCalculated for you: Days to due, Running total, Cash check\u003c\/li\u003e\n\u003cli\u003eDrop-down menus for quick, consistent entry\u003c\/li\u003e\n\u003cli\u003eColour-coded status and progress highlights\u003c\/li\u003e\n\u003cli\u003eExample rows and a step-by-step \"How to Use\" sheet\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003cstrong\u003eInstant download\u003c\/strong\u003e (.xlsx). Works in Excel 2010+, Excel online, Google Sheets, Numbers and LibreOffice. Works with any currency.\u003c\/p\u003e","brand":"The Template Desk","offers":[{"title":"Default Title","offer_id":46224555180167,"sku":"XLT-489","price":5.0,"currency_code":"AED","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0767\/5369\/8951\/files\/1c-xUA3YCrbJuwxPG5Q244QuBCcIEMCnu.png?v=1792936795"},{"product_id":"cash-receipt-voucher-word-template","title":"Cash Receipt Voucher – Word Template","description":"\u003cp\u003e\u003cstrong\u003eA receipt voucher for cash or cheque payments received, two copies per page.\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eTwo vouchers per A4 page (customer and office copy)\u003c\/li\u003e\n\u003cli\u003eAmount in figures and words\u003c\/li\u003e\n\u003cli\u003eCash \/ cheque \/ transfer options\u003c\/li\u003e\n\u003cli\u003eReceiver signature\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003cstrong\u003eInstant download\u003c\/strong\u003e (.docx). Works in Microsoft Word 2010+, Word for the web, Google Docs, Apple Pages and LibreOffice. A4 page size. Every placeholder is shown in [brackets] and colour, so you can see exactly what to replace.\u003c\/p\u003e","brand":"The Template Desk","offers":[{"title":"Default Title","offer_id":46255643328647,"sku":"WDT-011","price":5.0,"currency_code":"AED","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0767\/5369\/8951\/files\/1-1oWyanFQVE--dciZiBhWfqMS_NvDOsH.png?v=1792505759"},{"product_id":"payment-voucher-word-template","title":"Payment Voucher – Word Template","description":"\u003cp\u003e\u003cstrong\u003eAn internal payment voucher to record and approve cash, cheque or bank payments.\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eVoucher number, date and payee\u003c\/li\u003e\n\u003cli\u003ePayment method tick boxes\u003c\/li\u003e\n\u003cli\u003eAccount allocation table\u003c\/li\u003e\n\u003cli\u003ePrepared, approved and received signatures\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003cstrong\u003eInstant download\u003c\/strong\u003e (.docx). Works in Microsoft Word 2010+, Word for the web, Google Docs, Apple Pages and LibreOffice. A4 page size. Every placeholder is shown in [brackets] and colour, so you can see exactly what to replace.\u003c\/p\u003e","brand":"The Template Desk","offers":[{"title":"Default Title","offer_id":46256555786375,"sku":"WDT-054","price":5.0,"currency_code":"AED","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0767\/5369\/8951\/files\/1_lNbNlshW2AaXs8Sy4nbN57gu0DF1aSi.png?v=1792513899"},{"product_id":"petty-cash-voucher-word-template","title":"Petty Cash Voucher – Word Template","description":"\u003cp\u003e\u003cstrong\u003eRecord small cash payments from the petty cash box, with category, receipts and approval.\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eTwo vouchers per A4 page\u003c\/li\u003e\n\u003cli\u003ePaid to, amount and amount in words\u003c\/li\u003e\n\u003cli\u003eExpense category tick boxes\u003c\/li\u003e\n\u003cli\u003eReceived by and approved by signatures\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003cstrong\u003eInstant download\u003c\/strong\u003e (.docx). Works in Microsoft Word 2010+, Word for the web, Google Docs, Apple Pages and LibreOffice. A4 page size. Every placeholder is shown in [brackets] and colour, so you can see exactly what to replace.\u003c\/p\u003e","brand":"The Template Desk","offers":[{"title":"Default Title","offer_id":46267082014855,"sku":"WDT-156","price":5.0,"currency_code":"AED","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0767\/5369\/8951\/files\/1ACkOtGBuuiqOSLjPz9aTtS0CnTx7Mg1Y.png?v=1792594952"}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0767\/5369\/8951\/collections\/113305_cf53426d-0686-4750-8327-2ffd36b079f3.png?v=1793764338","url":"https:\/\/thetemplatedesk.us\/collections\/cash-flow-templates.oembed","provider":"The Template Desk","version":"1.0","type":"link"}