Workflows ยท Calculate ยท Opening soon
Calculation workflows
Schedules, commissions, costing and margins, worked out the same way from every new export. Each one rebuilds its result every time your data refreshes.
Team
Data in
83 workflows
- Pivot table from raw dataTurn a raw sales export into a pivot table of revenue by region and month.See the workflow Built by the agent
- Real estate commission splitWork out real estate commission on each closed sale and split it between the listing agent, buying agent and brokerage.See the workflow Built by the agent
- Loan amortization from statementsBuild a monthly loan amortization schedule from an Excel export, with interest, principal, and remaining balance for each loan.See the workflow Built by the agent
- Accrued expenses scheduleBuild an accrued expenses schedule from QuickBooks exports. Match purchase orders to vendor bills, calculate unbilled amounts, and flag items that need accrual.See the workflow Built by the agent
- RFM segmentsEvery customer scored 1-5 on recency, frequency and spend, with a segmentSee the workflow Template
- Sales velocityEach rep's open deals, win rate, deal size, sales cycle and velocity, and the team'sSee the workflow Template
- Inventory turnover and days on handEach product's turnover and days of stock on hand, month by monthSee the workflow Template
- Salary bands compa-ratioExport employees from BambooHR, pair them with salary bands, and work out each employee's compa-ratio against the band midpoint.See the workflow Built by the agent
- Economic order quantityCalculate economic order quantity for each item from a NetSuite item cost and demand export.See the workflow Built by the agent
- Google Ads wasted spendFind search terms with spend and no conversions in the last 30 days, ranked by spend, from a Google Ads export.See the workflow Built by the agent
- Property rent rollBuild a rent roll from exported Excel lease and payment files, with unit, tenant, monthly rent, lease end, and balance owed.See the workflow Built by the agent
- Payment processing fees by methodTrack payment processing fees by method each month, total sales and fees, and flag fee rates that are too high.See the workflow Built by the agent
- Negative keyword finderEvery search term that spent money and never converted, with its share of spendSee the workflow Template
- Construction job costingCompare each job budget to actual cost in QuickBooks exports, then see variance and variance percent by job.See the workflow Built by the agent
- Mileage reimbursement logTurn a trip log into a mileage reimbursement report by employee and month, using the IRS business rate and excluding commute trips.See the workflow Built by the agent
- SKU rationalizationFind SKUs to cut in Shopify exports. See last-year revenue, units sold, revenue share, gross margin, and a simple status.See the workflow Built by the agent
- Multi-touch attributionSplit closed HubSpot deal credit across touchpoints, by touch and by channel, from exported deal, contact, engagement, and channel mapping files.See the workflow Built by the agent
- SaaS metrics packBuild a SaaS metrics pack from Stripe exports. Get monthly MRR, new, expansion, churned MRR, customer count, and ARPA.See the workflow Built by the agent
- Trial balanceEvery account's debit or credit balance at the period endSee the workflow Template
- Journal entry upload from a spreadsheetCheck a journal entry template before upload. Match accounts, balance debits and credits, and review rows that do not meet the rules.See the workflow Built by the agent
- Restaurant food cost percentageCalculate food cost percentage by week by location from Toast exports, using weekly food purchases and food sales.See the workflow Built by the agent
- 13-week cash flowBuild a 13 week cash flow from QuickBooks open invoices, open bills, and the checking account register.See the workflow Built by the agent
- Sales commissionEach rep's sales and commission by month, with an accelerator above quotaSee the workflow Template
- Customer lifetime valueExport Shopify orders and calculate customer lifetime value per customer from spend, orders, first and last order date, and average order value.See the workflow Built by the agent
- Running totalsShow daily sales, monthly running totals, and month to date vs last month to date from a spreadsheet export.See the workflow Built by the agent
- Content decay: pages losing clicksCompare clicks per page this quarter vs last quarter and list the pages that lost the most in Google Search Console exports.See the workflow Built by the agent
- LTV to CAC ratioMatch Stripe and Google Ads exports by month, calculate CAC and LTV, then show the LTV to CAC ratio.See the workflow Built by the agent
- CAC payback periodSee how many months it takes each cohort to earn back acquisition cost from spend and new MRR, from your Stripe export.See the workflow Built by the agent
- Affiliate commissionsCalculate affiliate commissions by affiliate and month from Shopify orders, using referral codes, rate tables, and order subtotal.See the workflow Built by the agent
- Lease amortization scheduleBuild a lease amortization schedule from your Excel export, with monthly liability, interest, and payment for each lease.See the workflow Built by the agent
- Lost deal reasonsAnalyze closed lost deals by reason, stage, rep, and lost value from a HubSpot deals export.See the workflow Built by the agent
- Code transactions to GL accountsUse exported QuickBooks files to code card and bank transactions to GL accounts, apply vendor rules, and flag rows with no rule.See the workflow Built by the agent
- Marketing attribution first touch last touchCompare first touch and last touch attribution of won deal revenue by channel from a HubSpot deals export.See the workflow Built by the agent
- Supplier on-time deliveryCalculate each supplierโs on-time delivery rate from exported NetSuite purchase orders and item receipts.See the workflow Built by the agent
- Customer concentrationSee what share of revenue your top customers make up from a QuickBooks export, and flag any customer over 10 percent.See the workflow Built by the agent
- Customer profitabilityRank customer profit from QuickBooks exports, using invoice lines, product costs, discounts, and customer names.See the workflow Built by the agent
- Deferred revenue scheduleSpread Stripe invoices over service months and track month-end deferred revenue in one workflow.See the workflow Built by the agent
- Early payment discounts missedFind vendor bills with early payment discount terms, compare bills and payments, and see missed discount amounts.See the workflow Built by the agent
- Fixed asset register and depreciationBuild a fixed asset register from exported QuickBooks buys, asset life schedules, and account lists. Calculate straight-line monthly depreciation and net book value.See the workflow Built by the agent
- Product profitability after feesWork out profit per product after COGS, discounts, shipping and payment fees from Shopify exports.See the workflow Built by the agent
- Reorder pointsCalculate reorder point per SKU from Shopify order and settings exports, then flag what to reorder now.See the workflow Built by the agent
- Slow moving inventoryFind items with stock on hand, units sold in the last 90 days, and tied up inventory value from NetSuite exports.See the workflow Built by the agent
- Construction WIP scheduleBuild a WIP schedule for each job from QuickBooks exports, with percent complete, earned revenue, and over or under billing.See the workflow Built by the agent
- DAU/MAU stickinessShow daily DAU/MAU from your Mixpanel events export, with a status for each day.See the workflow Built by the agent
- GMROI by categoryCalculate GMROI by category from Shopify sales and inventory exports, using gross margin dollars over average inventory at cost.See the workflow Built by the agent
- Influencer campaign ROIMatch influencer payouts to discount code sales from Shopify exports, then calculate ROI for each influencer.See the workflow Built by the agent
- Labor cost as percent of salesCalculate labor cost as a percentage of sales by location and week from Toast exports.See the workflow Built by the agent
- Lead scoringScore HubSpot contacts by company size, job title, and pages viewed from your points table, then list the leads that match.See the workflow Built by the agent
- NPS by segmentExport survey scores from Delighted and calculate NPS by customer segment and month, using promoters minus detractors.See the workflow Built by the agent
- Open to buy by categoryWork out open to buy by category for next month from sales plan, inventory on hand, and open purchase orders exported from Shopify.See the workflow Built by the agent
- Project profitabilityCalculate project profit and margin from Harvest exports, using revenue, labor cost, and expenses by project.See the workflow Built by the agent
- Recipe costing and menu priceCost recipes from Excel exports, then compare plate cost with menu price as a food cost percentage.See the workflow Built by the agent
- Restaurant tip poolSplit weekly pooled tips by hours worked, using exported Toast tips and timesheet files. See each front of house share.See the workflow Built by the agent
- SLA breaches by priorityCount tickets that breached first reply targets by priority over the last 8 weeks, with breach rate and a status column.See the workflow Built by the agent
- Statement of functional expensesBuild a statement of functional expenses from QuickBooks exports, split each expense line by allocation, and flag mismatches.See the workflow Built by the agent
- Upsell opportunities from usageFind customers near or over their plan limits from exported Stripe data, so sales can offer the right upgrade.See the workflow Built by the agent
- Gender pay gapCompare average and median pay by gender within each job level and department from a BambooHR export.See the workflow Built by the agent
- Map a chart of accounts to a new oneMap a QuickBooks trial balance to a new Xero chart of accounts, then flag unmapped, duplicate, and not mappable accounts.See the workflow Built by the agent
- Agency client profitabilityCalculate client profit from Harvest client, invoice, and time entry exports. Add fees, subtract staff costs, and get profit by client.See the workflow Built by the agent
- Categorize bank transactionsCategorize bank transactions from a bank export, match description words to your category list, and flag rows to review.See the workflow Built by the agent
- Shipping cost per orderCalculate average shipping cost per order by carrier, service, and destination zone from your ShipStation shipment export.See the workflow Built by the agent
- Prepaid expense scheduleBuild a monthly prepaid expense schedule from your QuickBooks export and show the remaining prepaid balance by month.See the workflow Built by the agent
- Revenue recognition scheduleBuild a revenue recognition schedule from QuickBooks invoices by spreading annual contract revenue evenly across the service months.See the workflow Built by the agent
- Timesheet hours by projectTurn Harvest time entries into a timesheet report with hours by project, person and week, split into billable and non-billable.See the workflow Built by the agent
- Fleet fuel spendBuild a fuel report from Excel exports. Summarize fuel spend, gallons, miles, and cost per mile by vehicle and month.See the workflow Built by the agent
- Prepaid expense amortization scheduleBuild a prepaid expense amortization schedule from a QuickBooks export, with vendor, monthly amount, and balance left.See the workflow Built by the agent
- Customer support tickets by categoryTurn a Zendesk tickets export into a ticket report by category and week, and see which categories are growing.See the workflow Built by the agent
- Law firm billable hoursTrack billable hours and fees by attorney, client, and matter this month from Clio exports.See the workflow Built by the agent
- Subscription renewals dueExport Chargebee subscriptions and build a renewal forecast for the next 90 days with ARR and renewal dates.See the workflow Built by the agent
- Fundraising campaign resultsSummarize each fundraising campaign from Bloomerang exports, including donors, gifts, total raised, average gift, and progress against goal.See the workflow Built by the agent
- Order fulfillment timeCalculate order fulfillment time from ShipStation exports by day and warehouse, with shipment counts, average days to ship, and status.See the workflow Built by the agent
- Search Console clicks by pageShow clicks, impressions, CTR and position by page this month compared with last month from exported Search Console pages data.See the workflow Built by the agent
- Employee overtime costTrack overtime cost and hours by department and week from your ADP export, and flag weeks that move outside the normal range.See the workflow Built by the agent
- Etsy sales by listingSummarize Etsy sales by listing and month from an orders export, with orders, revenue, and fees.See the workflow Built by the agent
- Feature usage by planShow how many accounts on each plan used each feature this month from your Mixpanel exports.See the workflow Built by the agent
- Owner statement by propertyBuild monthly owner statement lines from AppFolio exports for rent, fees, repairs, expenses, and net owed by property.See the workflow Built by the agent
- Revenue by regionShow closed-won revenue by region and quarter from a Salesforce Opportunities export, with region issues flagged for review.See the workflow Built by the agent
- Salon stylist commissionCalculate salon stylist commission from a Square sales export. Apply a tiered rate to service sales and 10 percent to retail product sales for the pay period.See the workflow Built by the agent
- Weeks of cover by storeCalculate weeks of cover for each product at each store from Lightspeed stock and sales exports.See the workflow Built by the agent
- Blended ROAS across Google and Meta AdsCombine Google Ads and Meta Ads exports with Shopify orders to see weekly blended ROAS, with duplicate rows flagged first.See the workflow Built by the agent
- LinkedIn Ads cost per leadShow LinkedIn Ads campaign cost per lead by week, sorted highest first, from your exported campaign file.See the workflow Built by the agent
- Meta Ads creative fatigueTrack weekly CTR and frequency by ad creative, and flag ads where CTR drops while frequency rises.See the workflow Built by the agent
- Sales by day of week and hourShow sales by day of week and hour of day from your Square export, so you can spot your busiest times.See the workflow Built by the agent
Don't see your job? Describe it.
Tell us the job and we'll email you when you can build it.