Workflows ยท Finance teams ยท Opening soon
Workflows for finance teams
Close the month, watch cash, and send the same reports every month without rebuilding them.
Match two lists
Bank to ledger, payouts to deposits, returns to books. Every row comes back matched, or flagged with the reason.
- Cash reconciliationEach day's takings matched to a bank deposit, or flagged as not bankedSee the workflow Template
- Match customer payments to open invoicesMatch bank payments to QuickBooks open invoices by customer and amount, and see what is still unapplied.See the workflow Built by the agent
- Credit card reconciliationEach charge matched, missing from expenses, or booked but not on the statementSee the workflow Template
- Payroll reconciliationEach net pay line matched to a bank payment, or flaggedSee the workflow Template
- Project budget vs actual hoursTrack project budget hours against actual time in Harvest exports, and show percent used and remaining for each project.See the workflow Built by the agent
- Employee expense policy checkCheck expense reports from Expensify against policy limits by category and flag over-limit items or missing receipts.See the workflow Built by the agent
- CAM reconciliationReconcile year-end CAM for each tenant from an Excel export. Prorate common area expenses by leased sf, compare with estimated CAM paid, and flag the balance.See the workflow Built by the agent
- POS sales reconciliationMatch daily POS sales by payment type to card payouts and cash counts from Square exports.See the workflow Built by the agent
- Match Brex transactions to QuickBooksMatch exported Brex card transactions to QuickBooks expenses by date and amount, then see which rows agree and what needs a check.See the workflow Built by the agent
- Match Expensify reports to XeroCheck approved Expensify expenses against Xero bills, see which match, and list rows that need a look.See the workflow Built by the agent
- Reconcile ADP payroll to the GLCompare ADP payroll register totals by pay date to payroll expense in the general ledger and flag differences.See the workflow Built by the agent
- Reconcile Gusto payroll to QuickBooksMatch Gusto payroll run totals to QuickBooks payroll journal entries, compare wages, taxes, and benefits, and flag mismatches.See the workflow Built by the agent
- Supplier invoice price vs PO priceCompare supplier invoice lines to purchase order rates from NetSuite exports and flag over-rate, duplicate, or match status.See the workflow Built by the agent
Age and chase
Age what is open, and get the list of who to chase, sorted by how late it is.
- Bad debt reserve from agingCalculate each customerโs bad debt reserve from QuickBooks AR aging exports and loss rates for each bucket.See the workflow Built by the agent
- ITC reversal for suppliers unpaid after 180 daysCheck purchase invoices against supplier payments, flag unpaid invoices after 180 days, and calculate ITC to reverse in GSTR-3B.See the workflow Built by the agent
- MSME 45-day payment check (section 43B(h))Check unpaid supplier bills at year end against MSME rules, and see what may be disallowed under section 43B(h).See the workflow Built by the agent
Track and forecast
The number you report every month, rebuilt from the latest export, plus the forecast that follows from it.
- Customer lifetime value by cohortWork out customer lifetime value by signup month cohort from Shopify customers and orders exports, with revenue per customer and average order count.See the workflow Built by the agent
- Profit and loss by monthBuild a monthly profit and loss statement from a QuickBooks general ledger export, with revenue, COGS, gross profit, expenses, and net income.See the workflow Built by the agent
- Customer acquisition cost by channelCalculate customer acquisition cost by channel each month from HubSpot exports, with CAC rounded to whole dollars and a simple status.See the workflow Built by the agent
- Cash conversion cycle by monthWork out cash conversion cycle each month from QuickBooks exports, using month-end balances and monthly sales.See the workflow Built by the agent
- ARPU by monthCalculate average revenue per user each month from Stripe invoices and active customers.See the workflow Built by the agent
- Expense report from card transactionsTurn Amex card exports into an expense report per employee, with category totals and missing receipts flagged.See the workflow Built by the agent
- ROAS by campaignCalculate ROAS by campaign from Google Ads and Shopify exports, matched by week and utm campaign.See the workflow Built by the agent
- Demand forecast by SKUForecast next monthโs demand for each SKU from your Shopify order line export using recent monthly averages and trend.See the workflow Built by the agent
- Vendor spend analysisEach supplier's spend over the last 12 months, its share, and the change on the 12 beforeSee the workflow Template
- Cycle count varianceCompare cycle count results to inventory balances by item and location, and calculate unit and value variance.See the workflow Built by the agent
- Sales forecast from pipelineBuild a quarterly sales forecast from exported deals, with won deals counted in full and open deals weighted by stage probability.See the workflow Built by the agent
- Flux analysisEvery account's last month against the month before, with moves over your limits flaggedSee the workflow Template
- Budget vs actualBudget, actual and variance for every account and monthSee the workflow Template
- Marketing ROI by campaignCalculate marketing ROI for each campaign from HubSpot exports, using won deal revenue and campaign spend.See the workflow Built by the agent
- Price-volume-mix analysisThe change in revenue for each product, split into price, volume and mixSee the workflow Template
- Cash flow forecast from AR and APBuild a 13-week cash flow forecast from QuickBooks exports, starting from todayโs bank balance and grouped by due date.See the workflow Built by the agent
- Customer churn analysisAnalyze customer churn by month from a Stripe subscriptions export, with starting customers, customers lost, churn rate, and MRR lost.See the workflow Built by the agent
- Gross revenue retentionCalculate gross revenue retention by month from Stripe subscription MRR, counting churn and downgrades but not expansion.See the workflow Built by the agent
- Working capital by monthCalculate monthly working capital from a QuickBooks balance sheet, with month-over-month change and status labels.See the workflow Built by the agent
- Month-end close checklist statusShow a month-end close checklist by owner, with done, late, and open tasks based on completed date and due day.See the workflow Built by the agent
- Cost per lead by channelCalculate cost per lead by channel each month from HubSpot exports for ad spend, new leads, and source mapping.See the workflow Built by the agent
- Annual recurring revenue by customerCalculate annual recurring revenue by customer from Stripe exports, using active subscriptions and monthly prices times 12.See the workflow Built by the agent
- Economic nexus by stateTotal sales and orders by state over the last 12 months, compare them to nexus thresholds, and flag each state from a Shopify export.See the workflow Built by the agent
- Customer health scoreScore customers on logins, open support tickets, and days to renewal from HubSpot exports, then list the ones at risk.See the workflow Built by the agent
- Involuntary churn and failed payment recoveryTrack failed subscription payments, retries, and churn from Stripe exports, with invoice and subscription status for this month.See the workflow Built by the agent
- Grant spending trackerTrack grant spending by category from QuickBooks exports, include bills and expenses, and see what is left to spend.See the workflow Built by the agent
- Expansion and contraction MRRBreak down MRR change from a Chargebee export into new, expansion, contraction, and churned MRR by month and customer.See the workflow Built by the agent
- Sales tax by stateCreate a sales tax report from your Shopify orders by state and month, with taxable sales, tax collected, and undercollection flags.See the workflow Built by the agent
- Contribution margin by productCalculate contribution margin by product from QuickBooks exports, using revenue and variable costs to get margin and margin percentage.See the workflow Built by the agent
- Expense allocation by departmentAllocate rent and software by department, using month-end headcount from QuickBooks exports and monthly expense totals.See the workflow Built by the agent
- Labor burden rateCalculate each employee's labor burden rate from Gusto exports, with payroll taxes, benefits, workers comp, and burdened hourly cost.See the workflow Built by the agent
- Meta ads performance by ad setCompare Meta ad sets by spend, CPM, click-through rate, cost per purchase, and ROAS from an exported ads file.See the workflow Built by the agent
- Stripe failed payments, weeklyList failed Stripe payments each week, with decline reason and whether the customer paid later.See the workflow Built by the agent
- TikTok ads performanceExport TikTok Ads and compare campaign performance by week, including spend, cost per click, conversions, and cost per conversion.See the workflow Built by the agent
- Month over month growthCalculate month over month revenue growth by product line from Stripe exports, using paid invoices and line items by invoice created date.See the workflow Built by the agent
- 1099 vendor payments reportSee what you paid each contractor this year and flag the ones over $600 who need a 1099 and are missing a tax ID, from QuickBooks exports.See the workflow Built by the agent
- Stripe MRR by planShow MRR by plan each month from your Stripe subscriptions export, with customer counts and row checks.See the workflow Built by the agent
- Year-over-year growth by product lineCompare each month this year to the same month last year, with growth % and a status for product line sales exported from QuickBooks.See the workflow Built by the agent
- Ad spend pacing against budgetCompare month to date Google Ads spend to monthly budget by campaign and project month end spend.See the workflow Built by the agent
- Discount analysis by repExport Salesforce opportunities and line items, then compare average discount percent by sales rep and product on closed won deals.See the workflow Built by the agent
- Income statement by departmentBuild a departmental income statement from a QuickBooks general ledger export with department classes.See the workflow Built by the agent
- Payroll variance month over monthCompare this monthโs payroll to last month by employee, and see the pay change and what drove it from your Gusto payroll register export.See the workflow Built by the agent
- Price increase impact by customerSee the revenue impact of a price increase by customer from Stripe exports, with old price, new price, and the change.See the workflow Built by the agent
- Chargebee MRR movementCheck Chargebee monthly MRR movement by customer and subscription, including new, expansion, contraction, churn, and reactivation.See the workflow Built by the agent
- Collections forecast from ARForecast the next 8 weeks of cash collections from QuickBooks open invoices and customer days late data.See the workflow Built by the agent
- Operating expenses trendTrack operating expenses by category for the last 12 months, with a month by month trend from your QuickBooks exports.See the workflow Built by the agent
- Recurly churn by cohortSee churn by signup month cohort from exported Recurly subscriptions, with active counts after 1, 3, 6 and 12 months.See the workflow Built by the agent
Calculate
Schedules, commissions, costing and margins, worked out the same way from every new export.
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- Project profitabilityCalculate project profit and margin from Harvest exports, using revenue, labor cost, and expenses by project.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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
Don't see your job? Describe it.
Tell us the job and we'll email you when you can build it.