{"product_id":"consultant-retainer-tracker-bookkeeping","title":"Consultant Client and Retainer Tracker","description":"\u003cp\u003eThis consultant retainer tracker is a bookkeeping workbook for self employed consultants and advisers. It records retainers, project fees, advisory days and workshops against the costs of delivering them, and keeps expenses you recharge to clients on their own line so they never pass for earned revenue.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003ePlease read:\u003c\/strong\u003e This is a tracker tool only, not financial, tax, legal, medical or any other professional advice or advisory service. It records and calculates what you enter; you are solely responsible for checking all figures, rates, dates and results and for every decision you make. By purchasing, downloading or using it, you accept these terms (your statutory consumer rights are not affected).\u003c\/p\u003e\u003ch2\u003eBuilt around how consultants get paid\u003c\/h2\u003e\u003cp\u003eA generic ledger opens with product sales and service income. This consulting bookkeeping file opens with the lines you actually bill.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eIncome lines:\u003c\/strong\u003e Retainers, Projects, Advisory days and Workshops\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eExpense lines:\u003c\/strong\u003e Software and subscriptions, Contractors, Travel and Meals, and more\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eMileage reasons:\u003c\/strong\u003e client site, workshop, pitch and conference, chosen from a drop-down\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eTrain tickets you paid for and later billed back are not income. Giving them their own line means the revenue figure on the dashboard is the work you did.\u003c\/p\u003e\u003ch2\u003eThirteen connected tabs\u003c\/h2\u003e\u003cp\u003eStart Here, Setup, Clients, Invoices, Income, Expenses, Mileage, Monthly, Quarterly, Estimated Tax, Profit and Loss, Balances and Dashboard.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e500 income rows and 500 expense rows\u003c\/li\u003e\n\u003cli\u003eAn invoice tracker showing what was raised, sent, paid and overdue\u003c\/li\u003e\n\u003cli\u003eEstimated tax set aside as you go\u003c\/li\u003e\n\u003cli\u003eMonthly and quarterly totals, the way tax is usually filed\u003c\/li\u003e\n\u003cli\u003eA profit and loss built from the same two lists\u003c\/li\u003e\n\u003cli\u003eA client tracker with 10 client records and what each one has been worth\u003c\/li\u003e\n\u003cli\u003eAccount balances and a dashboard that reads everything\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eSee a full year before you start\u003c\/h2\u003e\u003cp\u003eOne copy comes filled with a worked year of 264 income entries and 330 expense entries, finishing at a 59.9% margin, so you can see every tab working. The other copy is blank and ready for your own clients. The Start Here tab walks you through setup in a few minutes.\u003c\/p\u003e\u003cp\u003eIt is a bookkeeping spreadsheet, not an accountant. Tax rates and what you can claim are yours to set and yours to check.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. The Google Sheets version is a real workbook you take a copy of, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eNo dynamic arrays, no macros, no add-ins and no subscription\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eTwo Excel workbooks: the filled example and a blank copy\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, which has one-click links to the Google Sheets versions (filled and blank)\u003c\/li\u003e\n\u003cli\u003eThe terms of use as a PDF\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eEverything is ready to download as soon as payment clears. The files are for personal and business use on your own devices; please do not share or resell them. Questions? Use our contact page and we will help.\u003c\/p\u003e\u003ch2\u003eFrequently asked questions\u003c\/h2\u003e\u003ch3\u003eCan I use it in Excel and Google Sheets?\u003c\/h3\u003e\u003cp\u003eYes. There are Excel workbooks for Excel 2016 or later on Windows and Mac, and the instruction guide has one-click links to copy the Google Sheets versions with a free Google account.\u003c\/p\u003e\u003ch3\u003eHow do I handle expenses I bill back to a client?\u003c\/h3\u003e\u003cp\u003eRecharged expenses get their own line, so they are kept apart from the fees you earned and do not inflate your revenue figure.\u003c\/p\u003e\u003ch3\u003eDoes it track unpaid invoices?\u003c\/h3\u003e\u003cp\u003eYes. The Invoices tab shows each invoice as raised, sent, paid or overdue.\u003c\/p\u003e\u003ch3\u003eDoes it calculate my tax bill?\u003c\/h3\u003e\u003cp\u003eThe Estimated Tax tab sets tax aside as you go using the rate you enter. The rates and what you can claim are yours to set and check.\u003c\/p\u003e\u003ch3\u003eHow many clients can I track?\u003c\/h3\u003e\u003cp\u003eThe Clients tab holds 10 client records, each showing what that client has been worth, alongside 500 income and 500 expense rows.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597869023326,"sku":"OPX-152","price":32.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/consultant-retainer-tracker-bookkeeping-01.jpg?v=1790832794","url":"https:\/\/opxviashop.com\/products\/consultant-retainer-tracker-bookkeeping","provider":"OPXVIA","version":"1.0","type":"link"}