Workflows ยท Match two lists ยท Opening soon
Account reconciliation templates and matching workflows
Bank to ledger, payouts to deposits, returns to books. Every row comes back matched, or flagged with the reason. Each one rebuilds its result every time your data refreshes.
Team
Data in
60 workflows
- 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
- Match names to a master listEach record with its master name (and ID), and how it matchedSee 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
- Compare two listsCompare two exported spreadsheet lists by email, see matches, and label rows where name and email agree or differ.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
- Fuzzy match two listsMatch company names in a CRM export to a billing list, even when they are spelled differently, using Excel files.See the workflow Built by the agent
- Match records across two systemsMatch customers by email across CRM and billing exports, then show name, email, and whether each record is in both, only CRM, or only billing.See the workflow Built by the agent
- 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
- 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
- Compare two Excel sheets for differencesCompare two Excel sheets, then show added, removed, and changed rows between last month and this month.See the workflow Built by the agent
- Google Ads auditAudit Google Ads keywords from an exported file. See campaign, quality score, click-through rate, and a status for each keyword.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
- 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
- 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
- VLOOKUP between two sheetsLook up product price and category from a Products sheet for each row in an Orders sheet, using exported Excel files.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
- Amazon FBA inventory reconciliationReconcile FBA shipment contents and inventory adjustments from Amazon Seller Central. Show agreed, short, and damaged units for claims.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
- GA4 vs Shopify revenue gapCompare daily GA4 revenue with Shopify orders, match the dates, and flag days where one side is more than 5% higher.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 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
- 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
- Shopify vs ShipBob inventoryCompare Shopify inventory to ShipBob warehouse counts by SKU and see every mismatch with a status and difference.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
Don't see your job? Describe it.
Tell us the job and we'll email you when you can build it.