{"product_id":"accounts-receivable-spreadsheet-invoice-tracker-ar-aging-collections-dashboard-payment-follow-up","title":"Accounts Receivable Tracker Excel | AR Aging, Invoice Follow-Up \u0026 Collections Dashboard","description":"\u003csection data-mfhq-seo=\"ar-search-v1\"\u003e\u003ch2\u003eTrack accounts receivable follow-up in Excel\u003c\/h2\u003e\n\u003cp\u003eUse this accounts receivable spreadsheet to organize invoice balances, A\/R aging, payment follow-up, customer exposure, collection actions, promise-to-pay dates, disputes, and expected collections in one connected Excel workflow.\u003c\/p\u003e\u003c\/section\u003e\u003ch2\u003eKnow what is owed, what is late, and what to work next\u003c\/h2\u003e\n\u003cp\u003eThe \u003cstrong\u003eMetricForgeHQ AR \u0026amp; Collections Command Center\u003c\/strong\u003e is a Microsoft Excel accounts receivable system for small businesses, bookkeepers, consultants, agencies, contractors, and finance teams that need more than a basic invoice list.\u003c\/p\u003e\u003ch3\u003eWhat you receive\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003eExecutive AR \u0026amp; Collections Dashboard\u003c\/li\u003e\n\u003cli\u003eInvoice Register and separate Payment Log\u003c\/li\u003e\n\u003cli\u003eCollections Follow-Up Queue\u003c\/li\u003e\n\u003cli\u003eCustomer Risk \u0026amp; Exposure view\u003c\/li\u003e\n\u003cli\u003eAR Aging Summary and 13-Week Collections Forecast\u003c\/li\u003e\n\u003cli\u003eEditable settings and collection targets\u003c\/li\u003e\n\u003cli\u003eDemo workbook, blank workbook, Quick Start Guide, FAQ, and single-business license\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch3\u003eCompatibility and delivery\u003c\/h3\u003e\n\u003cp\u003eDelivered as Microsoft Excel .xlsx files using standard formulas and no macros. Microsoft Excel is recommended. Google Sheets import is possible, but formulas, charts, formatting, or behavior may differ. This is an instant digital download; no physical product will be shipped.\u003c\/p\u003e\n\u003csection data-mfhq-demo=\"ar-actual-nov2026\"\u003e\u003ch2\u003eA promise is not a payment: see the actual workbook\u003c\/h2\u003e\n\u003cp\u003e\u003ca href=\"https:\/\/www.youtube.com\/watch?v=wW7c-VUe-oE\"\u003eWatch the 45-second A\/R workbook demonstration on YouTube\u003c\/a\u003e.\u003c\/p\u003e\n\u003cp\u003eFollow a fictional $12,500 invoice, a $5,000 payment and the remaining $7,500 balance. See why a promise to pay is recorded separately from received cash, then review the assigned follow-up.\u003c\/p\u003e\n\u003cp\u003eThis silent demonstration uses views rendered from the actual demo workbook. English and Spanish captions are available; the downloadable workbooks are in English. For small worksheet text, open the video full-screen and select 1080p if available.\u003c\/p\u003e\u003c\/section\u003e\u003csection data-mfhq-demo=\"catalog-quality-v2\"\u003e\u003ch3\u003eWatch the 20-second product preview\u003c\/h3\u003e\n\u003cp\u003eAn invoice is overdue. Who follows up? This captioned overview combines product previews with a practical setup workflow. Examples are illustrative; this is not a live system connection.\u003c\/p\u003e\n\u003cvideo controls playsinline preload=\"none\" width=\"1080\" height=\"1080\" poster=\"https:\/\/cdn.shopify.com\/s\/files\/1\/1021\/7360\/6176\/files\/preview_images\/b5bba9244a6f4ed29d681957d7d1b3a4.thumbnail.0000000000.jpg?v=1790795252\" aria-label=\"AR \u0026amp; Collections Command Center product workflow preview\" style=\"display:block;width:100%;max-width:560px;height:auto;aspect-ratio:1\/1;object-fit:contain;border-radius:12px\"\u003e\u003csource src=\"https:\/\/cdn.shopify.com\/videos\/c\/vp\/b5bba9244a6f4ed29d681957d7d1b3a4\/b5bba9244a6f4ed29d681957d7d1b3a4.HD-1080p-2.5Mbps-96045379.mp4\" type=\"video\/mp4\"\u003eYour browser does not support this video. Review the workflow below and the product gallery.\u003c\/source\u003e\u003c\/video\u003e\u003ch4\u003eStart with this workflow\u003c\/h4\u003e\n\u003col\u003e\n\u003cli\u003eReview the remaining invoice balance.\u003c\/li\u003e\n\u003cli\u003eCheck days past due and promises to pay.\u003c\/li\u003e\n\u003cli\u003eAssign the next follow-up and owner.\u003c\/li\u003e\n\u003c\/ol\u003e\n\u003cp\u003e\u003cstrong\u003eScope to check:\u003c\/strong\u003e A promise to pay is not received cash; update payment records.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eAfter purchase:\u003c\/strong\u003e Open the supplied instructions first and save a working copy of the files. For file or download help, \u003ca href=\"\/pages\/contact\"\u003econtact MetricForgeHQ\u003c\/a\u003e with your order number and product name. Please omit confidential information.\u003c\/p\u003e\u003c\/section\u003e\n\u003cp\u003eConnect invoices, partial payments, balances, aging, customer exposure, follow-ups, promises to pay, disputes, and expected collections in one reusable workflow.\u003c\/p\u003e\n\n\u003ch3\u003eWhat you can manage\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003eTotal open and overdue accounts receivable\u003c\/li\u003e\n\u003cli\u003eCurrent, 1–30, 31–60, 61–90, and 90+ aging\u003c\/li\u003e\n\u003cli\u003ePartial and multiple payments with remaining balances\u003c\/li\u003e\n\u003cli\u003eCollection contacts, outcomes, next steps, priority, and owner\u003c\/li\u003e\n\u003cli\u003ePromise-to-pay dates, amounts, and broken-promise flags\u003c\/li\u003e\n\u003cli\u003eCustomer exposure, risk flags, and open disputes\u003c\/li\u003e\n\u003cli\u003eThirteen-week expected collections forecast\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eWhy it is different\u003c\/h3\u003e\n\u003cp\u003eMany invoice trackers stop at Paid or Unpaid. This system connects the balance to a weekly collections workflow so you can see not only what is outstanding, but also the owner, next action, expected timing, and customer risk.\u003c\/p\u003e\n\u003csection data-mfhq-buying-signal=\"ar-oct31\"\u003e\u003ch3\u003eUse it for one weekly A\/R review\u003c\/h3\u003e\n\u003cp\u003eStart with overdue invoices: confirm the remaining balance, aging bucket, latest contact, promise or dispute status, assigned owner and next action. Then use the 13-week collections view to separate expected timing from received cash.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eBest fit:\u003c\/strong\u003e businesses that invoice customers and need a repeatable follow-up process. This is not accounting software and it does not connect to your bank, payment processor or invoicing platform.\u003c\/p\u003e\u003c\/section\u003e\u003ch3\u003eChoose this product if\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003eYou invoice customers and need a disciplined weekly collection process\u003c\/li\u003e\n\u003cli\u003eYou want an Excel solution without a recurring subscription\u003c\/li\u003e\n\u003cli\u003eYou need a clearer view of cash timing and overdue exposure\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eFor broader cash-flow, expense, inventory, project, and sales tools, browse \u003ca href=\"\/collections\/small-business-excel-systems\"\u003eSmall Business Excel Systems\u003c\/a\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eImportant notice\u003c\/h3\u003e\n\u003cp\u003eThis template supports general business organization and receivables management; it is not accounting, tax, legal, credit, lending, investment, or financial advice. Do not store payment-card data, passwords, authentication codes, bank credentials, government IDs, or other highly sensitive information in the workbook. Files may not be resold, redistributed, sublicensed, or publicly shared.\u003c\/p\u003e\n\u003csection data-mfhq-service=\"upwork-focused-tracker\"\u003e\u003ch3\u003eNeed a custom Excel follow-up workflow?\u003c\/h3\u003e\n\u003cp\u003eFor a separate tracker built around your team's fields, statuses and deadlines, explore our \u003ca href=\"https:\/\/www.upwork.com\/services\/product\/development-it-a-custom-excel-tracker-for-tasks-deadlines-and-business-follow-up-2110397137990992220?utm_source=metricforgehq\u0026amp;utm_medium=referral\u0026amp;utm_campaign=upwork_oct2026\u0026amp;utm_content=ar_product\"\u003ecustom Excel tracker service on Upwork\u003c\/a\u003e. The $249 package covers one workflow, up to 12 input fields and 500 rows, one management summary, demo and blank files, and one revision. Delivery is 10 days after requirements are received.\u003c\/p\u003e\n\u003cp\u003eThis is a separately purchased service. Customization is not included with this template; importing existing records, integrations and macros are outside the focused package. Confirm scope on Upwork using fictional examples.\u003c\/p\u003e\u003c\/section\u003e","brand":"MetricForgeHQ","offers":[{"title":"Default Title","offer_id":52372991869216,"sku":"MFHQ-AR-TRACK-001","price":22.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1021\/7360\/6176\/files\/metricforgehq-ar-premium-hero_cc0bff79-cc6f-429c-8f81-ac4e4533cb5f.png?v=1790311947","url":"https:\/\/metricforgehq.com\/products\/accounts-receivable-spreadsheet-invoice-tracker-ar-aging-collections-dashboard-payment-follow-up","provider":"MetricForgeHQ","version":"1.0","type":"link"}