{"product_id":"profit-and-loss-excel-dashboard","title":"Profit and Loss Dashboard – Excel Template","description":"\u003cp\u003eA profit and loss dashboard for small businesses, finance managers and founders. See net revenue, gross profits, debts and corporation tax at a glance, with monthly gross profit, income against expenses, CAPEX vs. OPEX and a breakdown of operating expenses for each department.\u003c\/p\u003e\n\u003cp\u003e\u003cimg src=\"https:\/\/cdn.shopify.com\/s\/files\/1\/0790\/7701\/5743\/files\/profit-and-loss-dashboard-light-and-dark.jpg?v=1792009199\" alt=\"Profit and Loss Excel dashboard shown in its light and dark themes, with net revenue, gross profits, income vs expenses and cost distribution\" width=\"2716\" height=\"1762\" style=\"width: 100%; height: auto;\"\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eLight and dark themes included:\u003c\/strong\u003e every licence comes with both workbooks, a clean light version and a dark version with the same features, so you can use whichever suits your screen or your brand.\u003c\/p\u003e\n\u003cp\u003eWhat's included: two macro-enabled .xlsm workbooks (light and dark), each with 4 sheets (Dashboard, Data Entry, Pivot, Data). A full year of sample figures for three departments (Headquarter, Web Store and Branches) is already filled in. Click a department on the slicer and every card and chart follows it, including a Business Info card with that department's details. The Data Entry form checks your month, then adds it to the Data table and refreshes the dashboard in one click. Figures in USD. Colourway: indigo \u0026amp; white (light) and indigo \u0026amp; charcoal (dark).\u003c\/p\u003e\n\u003cp\u003eAbout the macros: the only macro, Add entry, moves the ready row into the Data table inside the workbook and refreshes the pivots. It runs only when you click the button. Click Enable Content when Excel asks; if Excel shows a red Security Risk bar, close the file, right-click it, choose Properties, tick Unblock and reopen. Prefer no macros? The form has a ready row you can copy and paste instead, then use Data \u0026gt; Refresh All. The department slicer works without macros.\u003c\/p\u003e\n\u003cp\u003eWorks in desktop Microsoft Excel (Microsoft 365 or Excel 2016 and later, Windows or Mac). The Add entry button needs desktop Excel, as macros don't run in Excel for the web. Instant digital download, nothing is shipped.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eLicences:\u003c\/strong\u003e 1 ➜ Personal Use for one person, for your own business or hobby. 2 ➜ Commercial Use for a business or organisation of any size, including client work by consultants and agencies.\u003c\/p\u003e","brand":"Sky Dashboards","offers":[{"title":"1 ➜ Personal Use","offer_id":67668406927551,"sku":"VCD-PROFIT-LOSS-P","price":49.0,"currency_code":"USD","in_stock":true},{"title":"2 ➜ Commercial Use","offer_id":67668406960319,"sku":"VCD-PROFIT-LOSS-C","price":99.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0790\/7701\/5743\/files\/profit-and-loss-dashboard-light-and-dark.jpg?v=1792009199","url":"https:\/\/skydashboards.com\/products\/profit-and-loss-excel-dashboard","provider":"Sky Dashboards","version":"1.0","type":"link"}