Workflows ยท Accounting firms ยท Opening soon
Workflows for accounting and bookkeeping firms
Run each one on every client's export. The agent checks each step on your rows.
Every month: bank and payouts
- Bank reconciliationEvery line matched, flagged for a date check, or missing from one sideSee the workflow Template
- Match Stripe payouts to QuickBooks depositsMatch Stripe payouts to QuickBooks deposits each Monday and flag anything missing, short, duplicate, or extra.See the workflow Built by the agent
- Match Shopify payouts to XeroMatch Shopify payouts to Xero bank lines by date and amount, then flag mismatches and missing rows.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
Month-end close
- 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
- AR agingWhat each customer owes, split into 1-30, 31-60, 61-90 and over 90 days overdueSee the workflow Template
- AP agingWhat you owe each supplier, split by how overdue it isSee the workflow Template
- 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
- 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
Year end
- 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
- 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
- Trial balanceEvery account's debit or credit balance at the period endSee the workflow Template
Every month: GST
- GSTR-1 vs sales registerCompare your Tally sales register with GSTR-1 B2B details by GSTIN and invoice number. See missing, unmatched, and differing invoices.See the workflow Built by the agent
- GSTR-2B reconciliation with the purchase registerMatch your Tally purchase register to the GSTR-2B export by GSTIN and invoice number, then spot missing and mismatched invoices.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
Every month: bank and payouts
- Razorpay settlement reconciliationMatch Razorpay settlements to HDFC Bank credits by UTR and amount, show fee and GST on fee, and list settlements not yet in the bank.See the workflow Built by the agent
- Bank reconciliationEvery line matched, flagged for a date check, or missing from one sideSee the workflow Template
Every quarter: TDS
- Form 26AS TDS reconciliationCompare TDS in your Tally books with TRACES Form 26AS for FY 2025 to 26, by customer TAN and section, and flag gaps and differences.See the workflow Built by the agent
- Vendor statement reconciliationEach invoice: agrees, differs, or appears on only one sideSee the workflow Template
All 99 for accounting firms, by job
Match two lists
Bank to ledger, payouts to deposits, returns to books. Every row comes back matched, or flagged with the reason.
- Bank reconciliationEvery line matched, flagged for a date check, or missing from one sideSee the workflow Template
- Payment reconciliationEach payout matched to its bank deposit, flagged for a date check, or missingSee the workflow Template
- 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
- Three-way matchEach PO line: matched, partly received, billed more than received, or price differsSee the workflow Template
- Invoice reconciliationEach invoice paid in full, part-paid, overpaid or not paid, and payments with no invoiceSee the workflow Template
- 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
- Vendor statement reconciliationEach invoice: agrees, differs, or appears on only one sideSee the workflow Template
- Intercompany reconciliationEach reference: agrees (adds to zero), differs, or is booked on one side onlySee the workflow Template
- Inventory reconciliationEach SKU: agrees, over, short, or only on one sideSee the workflow Template
- GL account reconciliationEach account: agrees, differs, or appears on one side onlySee the workflow Template
- Reconcile the AR subledger to the general ledgerReconcile AR aging by customer to the general ledger each month end, and show customer status and differences from QuickBooks exports.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
- Revenue reconciliation: billing vs GLCompare invoiced revenue from billing to revenue posted in the GL by month, then show the monthly gap.See the workflow Built by the agent
- Form 26AS TDS reconciliationCompare TDS in your Tally books with TRACES Form 26AS for FY 2025 to 26, by customer TAN and section, and flag gaps and differences.See the workflow Built by the agent
- GSTR-1 vs sales registerCompare your Tally sales register with GSTR-1 B2B details by GSTIN and invoice number. See missing, unmatched, and differing invoices.See the workflow Built by the agent
- GSTR-2B reconciliation with the purchase registerMatch your Tally purchase register to the GSTR-2B export by GSTIN and invoice number, then spot missing and mismatched invoices.See the workflow Built by the agent
- Payment posting reconciliationMatch remittance payments to bank deposits and claims, then flag payments not yet posted or deposits with no remittance.See the workflow Built by the agent
- Razorpay settlement reconciliationMatch Razorpay settlements to HDFC Bank credits by UTR and amount, show fee and GST on fee, and list settlements not yet in the bank.See the workflow Built by the agent
- Three-way trust reconciliationCheck a trust account three ways from QuickBooks exports: client ledger balances, trust ledger entries, and the bank statement ending balance.See the workflow Built by the agent
- Match Stripe payouts to QuickBooks depositsMatch Stripe payouts to QuickBooks deposits each Monday and flag anything missing, short, duplicate, or extra.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
- Deposit reconciliationMatch bank statement exports to QuickBooks deposits exports by date and amount, then see which deposits agree and which are missing.See the workflow Built by the agent
- Insurance commission reconciliationMatch carrier commission statements to your book of business, compare expected and paid commission, and flag short or missing payments.See the workflow Built by the agent
- Match PayPal transfers to QuickBooksMatch PayPal transfers to QuickBooks deposits, and flag transfers that do not line up by date or amount.See the workflow Built by the agent
- Match Shopify payouts to QuickBooks depositsMatch Shopify payouts to QuickBooks deposits, and flag fees, refunds, missing deposits, short deposits, duplicates, and over deposits.See the workflow Built by the agent
- Vendor payment runBuild a vendor payment schedule from a QuickBooks export. List unpaid vendor bills due in the next 14 days by vendor with open balances.See the workflow Built by the agent
- Customers paying lateList customers who usually pay late, with average days late and current balances, from your QuickBooks invoice export.See the workflow Built by the agent
- HubSpot deals vs Stripe invoicesCheck closed won HubSpot deals against Stripe invoices by amount, and list the ones that do not match.See the workflow Built by the agent
- Match Amazon settlements to QuickBooksMatch Amazon settlements to QuickBooks deposits, break out fees, refunds, and reserve holds, and flag missing, short, or duplicate payouts.See the workflow Built by the agent
- Match an Amex statement to QuickBooksMatch Amex statement lines to QuickBooks card charges by date, payee, and amount. See which lines agree, are missing, or are duplicates.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 Etsy payouts to QuickBooksMatch Etsy payout exports to QuickBooks deposits, then mark each row as Agrees or show what is off.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
- Match Ramp transactions to NetSuiteMatch Ramp card transactions to your NetSuite credit card register, then flag agreed, missing, mismatched, and extra lines.See the workflow Built by the agent
- Match Shopify payouts to XeroMatch Shopify payouts to Xero bank lines by date and amount, then flag mismatches and missing rows.See the workflow Built by the agent
- Match Square deposits to QuickBooksMatch Square transfers to QuickBooks deposits and flag anything off by amount or missing.See the workflow Built by the agent
- Match Stripe payouts to NetSuite depositsReconcile Stripe payouts to NetSuite deposits each week, match by payout id and amount, and flag differences.See the workflow Built by the agent
- Match Stripe payouts to Xero bank depositsMatch Stripe payouts to Xero bank deposits by amount and date, and flag payouts that never landed in the bank feed.See the workflow Built by the agent
- Match WooCommerce orders to Stripe chargesCheck WooCommerce orders against Stripe charges by amount, with status notes for matches, differences, and missing charges.See the workflow Built by the agent
- Parcel invoice auditAudit UPS freight invoices against tracking detail, flag duplicate charges, late deliveries, and unexpected surcharges.See the workflow Built by the agent
- Payment terms complianceCheck vendor payment terms and list bills paid early or late from QuickBooks exports.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
- Refunds by reasonSee refunds by reason and month, and the refund rate on sales, using Stripe exports.See the workflow Built by the agent
- Salesforce closed-won vs QuickBooks invoicesMatch Salesforce closed-won opportunities to QuickBooks invoices by customer and amount, and flag deals that were never invoiced.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.
- DPO by monthDays payable outstanding for every month, with bills received and what was unpaid at month endSee the workflow Template
- AR agingWhat each customer owes, split into 1-30, 31-60, 61-90 and over 90 days overdueSee the workflow Template
- DSO by monthDays sales outstanding for every month, with credit sales and what was owed at month endSee the workflow Template
- AP agingWhat you owe each supplier, split by how overdue it isSee the workflow Template
- 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.
- 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
- 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
- Vendor spend analysisEach supplier's spend over the last 12 months, its share, and the change on the 12 beforeSee the workflow Template
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- Income statement by departmentBuild a departmental income statement from a QuickBooks general ledger export with department classes.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
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
- 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
- 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
- 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
- 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
- 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 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
- Project profitabilityCalculate project profit and margin from Harvest exports, using revenue, labor cost, and expenses by project.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
- 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
- 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
- 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
Don't see your job? Describe it.
Tell us the job and we'll email you when you can build it.