{"product_id":"invoice-and-payment-tracker","title":"Invoice and Payment Tracker","description":"\u003cp\u003eGeneral information only. It is not accounting, tax, legal or financial advice.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eThe problem.\u003c\/strong\u003e Invoices sit in one place, payments in another, and the question \"who still owes us, and for how long?\" takes an afternoon to answer.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat this does.\u003c\/strong\u003e You keep one list of customers, one of invoices and one of payments received. The workbook works out what each invoice has had paid, what is still owing, how many days overdue it is and which ageing band it falls in, then adds it all up on a dashboard.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat you can do with it\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eSee the balance owing, the number and amount of overdue invoices, the oldest overdue invoice and what was paid this month.\u003c\/li\u003e\n\u003cli\u003eGroup overdue balances into ageing bands. You type the three edges, in days overdue, so the bands match your own terms.\u003c\/li\u003e\n\u003cli\u003eSee invoices by payment status (Unpaid, Part paid, Overdue, Paid, Overpaid) and by invoice type.\u003c\/li\u003e\n\u003cli\u003eSee your top five customers by balance owing, and the disputed invoices.\u003c\/li\u003e\n\u003cli\u003eSpot mistakes: a payment whose invoice number is not on the Invoices sheet, or an invoice whose customer is missing, is flagged.\u003c\/li\u003e\n\u003cli\u003eChoose your industry (services, trade accounts or professional practice) 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 three export sheets repeat your customers, invoices and payments 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 payment terms and ageing edges.\u003c\/li\u003e\n\u003cli\u003eAdd your customers, then one row per invoice and one row for each payment received.\u003c\/li\u003e\n\u003cli\u003eCheck the dashboard each week.\u003c\/li\u003e\n\u003c\/ol\u003e\u003cp\u003e\u003cstrong\u003eWho it is for.\u003c\/strong\u003e Sole traders and small businesses that raise their own invoices and want a register of what is owing, how overdue it is and who owes most, with ageing bands they set themselves.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWho it is not for.\u003c\/strong\u003e Anyone who wants software that creates or sends invoices, reminders or statements, or that works out tax. This is a receivables register in a spreadsheet: you type the records, no tax is calculated, nothing is sent or posted, and it does not connect to other software.\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 customers, 800 invoices and 1,000 payments are ready, and you can add more by dragging the last row down.\u003c\/li\u003e\n\u003cli\u003ePayment terms and ageing edges are your own numbers. Nothing is a built-in rule, and no rate or tax is built in: type each amount as it appears on your invoice.\u003c\/li\u003e\n\u003cli\u003eAmounts are added as typed, in one currency.\u003c\/li\u003e\n\u003cli\u003eAn invoice due on the report date is not overdue. An invoice with no due date and no payment terms can never be overdue.\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\u003eThis workbook holds personal information about your customers, such as contact names, emails and phone numbers. Look after it: share it only with those who need it and keep it somewhere protected. It has no columns for bank, card, identity or tax identifier details, so please do not type them into Notes or Payment method either.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"TeleWorld Online","offers":[{"title":"Default Title","offer_id":48859262517453,"sku":null,"price":34.0,"currency_code":"AUD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0652\/1031\/9053\/files\/01-cover_af796857-89b1-4e88-b029-3ac69ca07a82.png?v=1795097094","url":"https:\/\/www.teleworld.online\/no\/products\/invoice-and-payment-tracker","provider":"TeleWorld Online","version":"1.0","type":"link"}