{"product_id":"finance-clients-and-loans-tracker","title":"Finance Clients and Loans Tracker","description":"\u003cp\u003eGeneral information only. It is not financial advice and does not assess anyone's situation.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eThe problem.\u003c\/strong\u003e Client details sit in one file, applications in another, follow-ups in an inbox and the documents you are waiting for in your head. It is hard to say where each file is up to, who needs a call and what is still missing.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat this does.\u003c\/strong\u003e You keep one list of clients, one of applications or loan files, one of follow-ups and one of documents. The workbook counts applications at each stage, adds up the amounts you typed, flags follow-ups that are overdue and shows how long each document has been outstanding.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat you can do with it\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eSee open applications, the open pipeline value as typed, completed applications and applications not proceeding.\u003c\/li\u003e\n\u003cli\u003eSee applications by stage and by product type, as tables and bar charts.\u003c\/li\u003e\n\u003cli\u003eSee follow-ups overdue, due soon and scheduled, and clients with no follow-up booked.\u003c\/li\u003e\n\u003cli\u003eSee documents outstanding by age, and the oldest one.\u003c\/li\u003e\n\u003cli\u003eType your own look-ahead window, document age limits and stages on Settings. Nothing is built in as a rule.\u003c\/li\u003e\n\u003cli\u003eChoose your industry (broker, bookkeeping or advisory practice, or lender-style admin) to load suitable lists, then edit them to suit you.\u003c\/li\u003e\n\u003cli\u003eKeep your records in a clear structure: a Data Dictionary explains every column, and four export sheets repeat your clients, applications, follow-ups and documents under plain field names.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003cstrong\u003eHow it works\u003c\/strong\u003e\u003c\/p\u003e\u003col\u003e\n\u003cli\u003eEnter your business name, choose your industry, and type your own numbers on Settings.\u003c\/li\u003e\n\u003cli\u003eAdd your clients, then applications, follow-ups and documents.\u003c\/li\u003e\n\u003cli\u003eCheck the dashboard.\u003c\/li\u003e\n\u003c\/ol\u003e\u003cp\u003e\u003cstrong\u003eWho it is for.\u003c\/strong\u003e Brokers, bookkeepers, advisers and small teams who manage client files from a list and want to see every stage, follow-up and document in one place.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWho it is not for.\u003c\/strong\u003e Businesses that need software to assess people, make decisions or send messages. This is a spreadsheet: you type the records, and it does not send anything, store identity, bank or income details, or connect to your email or calendar.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003ePersonal information.\u003c\/strong\u003e This workbook holds personal information about your clients. Look after it: share it only with those who need it and keep it somewhere protected. It has no columns for identity, bank, income or credit details, so please do not type them into Notes either.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat you need.\u003c\/strong\u003e Microsoft Excel 2016 or later. It was tested in Excel for Windows. No macros, no add-ins and no subscription.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eGood to know\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e300 clients, 500 applications, 1,000 follow-ups and 600 document rows are ready, and you can add more by dragging the last row down.\u003c\/li\u003e\n\u003cli\u003eAmounts are only the figures you type, added up exactly as typed.\u003c\/li\u003e\n\u003cli\u003eAn example copy with a made-up business shows every sheet working before you start.\u003c\/li\u003e\n\u003cli\u003eNothing is locked or password protected.\u003c\/li\u003e\n\u003cli\u003eUse this template to capture and improve your business data now. In future you can automate with AI.\u003c\/li\u003e\n\u003cli\u003eGeneral information only. It is not financial advice and does not assess anyone's situation.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"TeleWorld Online","offers":[{"title":"Default Title","offer_id":48859262353613,"sku":null,"price":39.0,"currency_code":"AUD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0652\/1031\/9053\/files\/01-cover_a963a1d7-4757-4927-aaa5-dd680fe04a06.png?v=1795097932","url":"https:\/\/www.teleworld.online\/ko\/products\/finance-clients-and-loans-tracker","provider":"TeleWorld Online","version":"1.0","type":"link"}