{"title":"Google Sheets Templates","description":"\u003cp\u003eSpreadsheet templates for Google Sheets and Excel, built for small business owners, ecommerce stores and marketers. Each one comes with example data, a dashboard and a quick-start guide, and works the moment you make your copy.\u003c\/p\u003e","products":[{"product_id":"budget-cash-flow-planner-2027-google-sheets","title":"Small Business Budget and Cash Flow Template 2027 (Google Sheets and Excel)","description":"\u003cp\u003e\u003cstrong\u003e2027 Small Business Budget and Cash Flow Planner\u003c\/strong\u003e is a spreadsheet template for Google Sheets and Excel. You plan your income and expenses for the year, log what actually comes in and goes out, and see budget vs actual and your cash balance month by month. Example data is filled in so you can see it working before you add your own.\u003c\/p\u003e\n\u003ch2\u003eWhat's inside\u003c\/h2\u003e\n\u003cul\u003e\n  \u003cli\u003eA Setup tab for your business name, currency symbol, plan start month and year, opening cash, and your own income and expense categories\u003c\/li\u003e\n  \u003cli\u003eA Transactions log with 1,000 ready rows, category dropdowns and an automatic income or expense type\u003c\/li\u003e\n  \u003cli\u003eA 12-month Budget for every category\u003c\/li\u003e\n  \u003cli\u003eBudget vs Actual for year to date, the full year or any single month, with variance and % variance in green or red\u003c\/li\u003e\n  \u003cli\u003eA Cash Flow tab with opening balance, cash in, cash out and closing balance for each month, your lowest cash month highlighted, and a planned balance from your budget\u003c\/li\u003e\n  \u003cli\u003eA Dashboard with year totals, net profit, profit margin, budget vs actual charts, a monthly cash chart and your top 5 expense categories\u003c\/li\u003e\n  \u003cli\u003eA Start Here tab and a quick-start PDF guide that explains every number in plain words\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch2\u003eBest for\u003c\/h2\u003e\n\u003cul\u003e\n  \u003cli\u003eSmall business owners and freelancers who want a yearly budget and cash plan in one file\u003c\/li\u003e\n  \u003cli\u003eAnyone who wants to see a tight cash month coming before it arrives\u003c\/li\u003e\n  \u003cli\u003eOwners who prefer a spreadsheet to accounting software for planning\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch2\u003eHow it works\u003c\/h2\u003e\n\u003col\u003e\n  \u003cli\u003eMake your copy in Google Sheets, or open the .xlsx in Excel\u003c\/li\u003e\n  \u003cli\u003eOn Setup, type your business details and edit the category lists\u003c\/li\u003e\n  \u003cli\u003eType your monthly budget for each category\u003c\/li\u003e\n  \u003cli\u003eLog each payment in or out on Transactions\u003c\/li\u003e\n  \u003cli\u003eCheck Budget vs Actual, Cash Flow and the Dashboard. Delete the example rows when you are ready\u003c\/li\u003e\n\u003c\/ol\u003e\n\u003ch2\u003eRequirements\u003c\/h2\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets:\u003c\/strong\u003e a free Google account. Open the link and use File \u0026gt; Make a copy.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExcel:\u003c\/strong\u003e the desktop app on Windows or Mac, 2016 or later, or Microsoft 365.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cem\u003eNotes:\u003c\/em\u003e Instant digital download. You get a Google Sheets link to copy, the .xlsx file for Excel and a quick-start PDF guide. No physical product is shipped. Single business license.\u003c\/p\u003e","brand":"UkiyoProds","offers":[{"title":"Default Title","offer_id":48577091797076,"sku":null,"price":19.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0617\/7207\/0996\/files\/budget-cash-flow-planner-2027-google-sheets.png?v=1795276027"},{"product_id":"social-media-content-calendar-2027-google-sheets","title":"2027 Social Media Content Calendar Template (Google Sheets and Excel)","description":"\u003cp\u003e\u003cstrong\u003e2027 Social Media Content Calendar\u003c\/strong\u003e is a spreadsheet template for Google Sheets and Excel. You plan every post in one list, see each month day by day, keep your mix of content pillars on target, and track what is still an idea, in progress or published. It includes a list of 2027 US holidays and marketing dates, each checked against a published source.\u003c\/p\u003e\n\u003ch2\u003eWhat's inside\u003c\/h2\u003e\n\u003cul\u003e\n  \u003cli\u003eA Content Plan with 1,000 ready rows: date, automatic weekday, platform, pillar, format, hook, caption, call to action, link, hashtags, owner, status and publish date\u003c\/li\u003e\n  \u003cli\u003eA Monthly View: pick a month and see each day with its posts and key dates\u003c\/li\u003e\n  \u003cli\u003ePillar Balance: posts per pillar each month and your yearly mix against the targets you set\u003c\/li\u003e\n  \u003cli\u003eA Status Tracker with counts by status and platform, and posts past their date that are not published\u003c\/li\u003e\n  \u003cli\u003eAn Ideas Bank for your backlog, with priority and a used or not used flag\u003c\/li\u003e\n  \u003cli\u003e2027 Key Dates: 42 dates, including US federal holidays with their observed dates and common marketing dates, each with a content idea. The source for every date is listed in the guide\u003c\/li\u003e\n  \u003cli\u003eEditable lists for platforms, pillars, formats, statuses and team members, plus a quick-start PDF guide\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch2\u003eBest for\u003c\/h2\u003e\n\u003cul\u003e\n  \u003cli\u003eSmall businesses and solo creators who post on more than one platform\u003c\/li\u003e\n  \u003cli\u003eSocial media managers who plan a month or a quarter ahead\u003c\/li\u003e\n  \u003cli\u003eSmall teams who need one shared plan with owners and statuses\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch2\u003eHow it works\u003c\/h2\u003e\n\u003col\u003e\n  \u003cli\u003eMake your copy in Google Sheets, or open the .xlsx in Excel\u003c\/li\u003e\n  \u003cli\u003eOn Setup, add your brand name and edit the platform, pillar, format, status and team lists\u003c\/li\u003e\n  \u003cli\u003ePark ideas in the Ideas Bank, then add posts to the Content Plan\u003c\/li\u003e\n  \u003cli\u003eUse Monthly View, Pillar Balance and Status Tracker to check your plan\u003c\/li\u003e\n  \u003cli\u003eDelete the example rows when you are ready\u003c\/li\u003e\n\u003c\/ol\u003e\n\u003ch2\u003eRequirements\u003c\/h2\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets:\u003c\/strong\u003e a free Google account. Open the link and use File \u0026gt; Make a copy.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExcel:\u003c\/strong\u003e the desktop app on Windows or Mac, 2016 or later, or Microsoft 365.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cem\u003eNotes:\u003c\/em\u003e Instant digital download. You get a Google Sheets link to copy, the .xlsx file for Excel and a quick-start PDF guide. No physical product is shipped. Single business license.\u003c\/p\u003e","brand":"UkiyoProds","offers":[{"title":"Default Title","offer_id":48577092157524,"sku":null,"price":15.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0617\/7207\/0996\/files\/social-media-content-calendar-2027-google-sheets.png?v=1795276028"},{"product_id":"shopify-profit-tracker-google-sheets","title":"Shopify Profit Tracker Spreadsheet: Orders, Ad Spend and Net Margin (Google Sheets and Excel)","description":"\u003cp\u003e\u003cstrong\u003eShopify Profit Tracker\u003c\/strong\u003e is a spreadsheet template for Google Sheets and Excel that shows what your store keeps after product costs, shipping, payment fees and ad spend. You copy a few daily totals from Shopify and your ad accounts, and it works out contribution profit, net margin, ROAS, MER, CPA and break-even ROAS by day and by month. It does not connect to your store. Payment fees are your own rates, typed in once on the Settings tab.\u003c\/p\u003e\n\u003ch2\u003eWhat's inside\u003c\/h2\u003e\n\u003cul\u003e\n  \u003cli\u003eA Settings tab for your payment processing %, fixed fee per order, any extra transaction fee, packaging cost, product cost %, target margin and monthly fixed costs. The example rates are labelled as examples to replace\u003c\/li\u003e\n  \u003cli\u003eA Daily Log with 1,000 ready rows: orders, gross sales, discounts, refunds, shipping, COGS and ad spend for Meta, Google, TikTok and other channels\u003c\/li\u003e\n  \u003cli\u003eCalculated columns for payment fees, net revenue, contribution profit, net margin %, ROAS, MER, CPA and break-even ROAS\u003c\/li\u003e\n  \u003cli\u003eA Monthly Summary with every cost and ratio, net profit after fixed costs, and ad spend by channel\u003c\/li\u003e\n  \u003cli\u003eProduct Margins: unit margin, margin %, break-even ROAS and the most you can spend in ads per sale for each product\u003c\/li\u003e\n  \u003cli\u003eA Dashboard with a month picker, year totals, a profit trend chart and an ad spend vs profit chart\u003c\/li\u003e\n  \u003cli\u003eA quick-start PDF guide that explains every formula in plain words\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch2\u003eBest for\u003c\/h2\u003e\n\u003cul\u003e\n  \u003cli\u003eShopify store owners who run paid ads and want to know if they pay off\u003c\/li\u003e\n  \u003cli\u003eSmall ecommerce teams who want one monthly profit and loss view\u003c\/li\u003e\n  \u003cli\u003eOwners checking which products can carry ad spend\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch2\u003eHow it works\u003c\/h2\u003e\n\u003col\u003e\n  \u003cli\u003eMake your copy in Google Sheets, or open the .xlsx in Excel\u003c\/li\u003e\n  \u003cli\u003eOn Settings, type your own fee rates, costs and fixed costs\u003c\/li\u003e\n  \u003cli\u003eList your products with price, unit cost, packaging and shipping\u003c\/li\u003e\n  \u003cli\u003eEach day or week, add your sales and ad spend totals to the Daily Log\u003c\/li\u003e\n  \u003cli\u003eRead the Monthly Summary and the Dashboard. Delete the example rows when you are ready\u003c\/li\u003e\n\u003c\/ol\u003e\n\u003ch2\u003eRequirements\u003c\/h2\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets:\u003c\/strong\u003e a free Google account. Open the link and use File \u0026gt; Make a copy.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExcel:\u003c\/strong\u003e the desktop app on Windows or Mac, 2016 or later, or Microsoft 365.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cem\u003eNotes:\u003c\/em\u003e Instant digital download. You get a Google Sheets link to copy, the .xlsx file for Excel and a quick-start PDF guide. No physical product is shipped. Single business license.\u003c\/p\u003e","brand":"UkiyoProds","offers":[{"title":"Default Title","offer_id":48577092386900,"sku":null,"price":19.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0617\/7207\/0996\/files\/shopify-profit-tracker-google-sheets.png?v=1795276028"}],"url":"https:\/\/ukiyoprod.com\/collections\/google-sheets-templates.oembed","provider":"Ukiyo","version":"1.0","type":"link"}