{"product_id":"brand-deal-tracker","title":"Brand Deal Tracker Spreadsheet","description":"\u003cp\u003eThis brand deal tracker gives influencers and every ugc creator one row per deal, from the first pitch to the day the money lands. Each deal shows its deliverables, fee, content due date and invoice date, and says Paid, Due in so many days, Overdue or Not invoiced.\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\u003eThe dashboard\u003c\/h2\u003e\u003cp\u003eChoose one brand, or all of them, and the dashboard follows. It fills itself from your deals.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eFees booked, with the average deal\u003c\/li\u003e\n\u003cli\u003eMoney paid in and invoices sent over the last 12 months\u003c\/li\u003e\n\u003cli\u003eEvery unpaid invoice, soonest pay-by date first, with overdue ones in red\u003c\/li\u003e\n\u003cli\u003eWho may still run your content, and your exclusive months\u003c\/li\u003e\n\u003cli\u003eHow long each brand takes to pay, from invoice to money\u003c\/li\u003e\n\u003cli\u003eFees at every stage of the pipeline, from pitched to paid, and fees by brand\u003c\/li\u003e\n\u003cli\u003eContent deadlines still open, with what is posted so far\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eUsage rights in the order they end\u003c\/h2\u003e\u003cp\u003eEnter the go-live date and the months of usage the brand bought. Every usage right is listed soonest to end, and marked Ends soon inside the number of days you choose. Each exclusivity you agreed to is tracked too: the category you agreed not to work in, and the day you are free again.\u003c\/p\u003e\u003ch2\u003ePaid, due or overdue\u003c\/h2\u003e\u003cp\u003eThe pay-by date is worked out from the invoice date, overdue payments are flagged by the day, and late content is flagged as well. Everything you are still owed sits on the dashboard, soonest first, so no sponsorship payment slips past.\u003c\/p\u003e\u003ch2\u003eCreator income by brand, platform and month\u003c\/h2\u003e\u003cp\u003eThe Income tab adds up what each brand and each platform has booked and paid, and the money that came in each month.\u003c\/p\u003e\u003ch2\u003eSix connected tabs\u003c\/h2\u003e\u003cp\u003eStart Here, Setup, Deals, Usage Rights, Income and Dashboard: an influencer tracker that covers the money and the rights.\u003c\/p\u003e\u003ch2\u003eLight and dark editions\u003c\/h2\u003e\u003cp\u003eEvery download includes a light edition and a dark edition. Every tab is restyled, not only the dashboard, and both run on the same formulas, so you simply pick the look you prefer. Each edition comes filled with a worked example and as a blank copy, in Excel and in Google Sheets.\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\u003eLight edition: the Excel workbook filled with a worked example (32 brand deals across six platforms), and a blank one\u003c\/li\u003e\n\u003cli\u003eDark edition: the same two files in the dark design\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, which has one-click links to the Google Sheets versions (light and dark, filled and blank)\u003c\/li\u003e\n\u003cli\u003eThe terms of use as a PDF\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eYour files are ready to download as soon as payment clears. They are for personal and business use on your own devices, so please do not share or resell them. Questions before or after you buy? Use our contact page and we will help.\u003c\/p\u003e\u003ch2\u003eFrequently asked questions\u003c\/h2\u003e\u003ch3\u003eCan I use it in Google Sheets?\u003c\/h3\u003e\u003cp\u003eYes. The download includes Excel workbooks for Excel 2016 or later on Windows or 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 does it know a payment is overdue?\u003c\/h3\u003e\u003cp\u003eIt works out the pay-by date from the invoice date. Once that date passes without payment, the deal is marked Overdue and counted by the day.\u003c\/p\u003e\u003ch3\u003eCan it track usage rights and exclusivity?\u003c\/h3\u003e\u003cp\u003eYes. Enter the go-live date and months of usage, and every right is listed in the order it ends. Each exclusivity shows the category and the day you are free again.\u003c\/p\u003e\u003ch3\u003eCan I see income by platform?\u003c\/h3\u003e\u003cp\u003eYes. The Income tab totals what was booked and paid by brand, by platform and by month.\u003c\/p\u003e\u003ch3\u003eWhat is the difference between the light and dark editions?\u003c\/h3\u003e\u003cp\u003eOnly the look. Both have every tab restyled with the same formulas, and both come with every download.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597875052638,"sku":"OPX-230","price":16.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/brand-deal-tracker-01.jpg?v=1790833241","url":"https:\/\/opxviashop.com\/products\/brand-deal-tracker","provider":"OPXVIA","version":"1.0","type":"link"}