Accounting & Bookkeeping Bundle

Bookkeeping automation, financial statements, tax preparation, audit trails, reconciliation, and accounting workflow skills for CPAs and bookkeepers.

Browse all skill bundles

Included Skills (75)

Expense Accounting — Expense accounting register: expense number and date, payee with PAN and VAT, bill reference, document type, amount with VAT, ledger account, approver and status. Use for expense bookkeeping.
Receipt Accounting — Receipt register: payer, mode, gross amount received, invoice allocation, unapplied amount and TDS collected. Use for receipt and sales-income accounting.
Payment Accounting — Payment voucher register: payment number and date, paid to and purpose, mode, gross amount, TDS rate and deducted, net paid, invoice allocation, ledger and reconciliation status. Use for vouchers.
Expense Report Automator — This tool scans receipt folders to generate categorized expense spreadsheets and summary dashboards, streamlining bookkeeping and tax preparation for busy professionals.
Salary Wage Accounting — Payroll register: gross, allowances, TDS and provident fund deductions, net pay, payment date and statutory reconciliation. Use for salary accounting.
Party Ledger Reconciliation — Party ledger reconciliation: party type, name and PAN/VAT, ledger against statement balance, difference and reason, duplicates, confirmation status and adjustment. Use for balance checks.
Expense Management — Expense claim register: claim id, employee and department, amount and tax, approver and level, category, cost centre, budget line, receipt flag and status. Use for claim approvals.
Purchase Accounting — Purchase register: supplier, invoice, gross amount, VAT and TDS, net payable, ledger account and payment balance. Use for purchase accounting.
Day Book — Daily cash, bank and digital day book: opening and closing balances per book, in/out movements, debit/credit presentation and reconciliation status. Use for daily bookkeeping.
Xero Accounting Integration — Connect applications to Xero and automate bookkeeping workflows by syncing accounting data and generating financial reports programmatically for businesses.
Payments Received — Payments received log: reference, client and invoice, amount and currency, payment date and method, withholding tax, bank account, received-by and receipt-sent status. Use for incoming payments.
Automated Bookkeeping Assistant — This tool automates month-end closing, transaction categorization, and bank reconciliation for small businesses to ensure accurate financial records for accountants and owners.
Expense Report — The skill compiles and categorizes business expenses, organizing receipts, CSV data, and manual entries into a clear summary. It produces ready‑to‑submit expense reports that finance teams and tax professionals can use for reimbursement and filing. The process ensures accurate categorization and streamlines reporting.
Odoo Accounting Configurator — This tool provides functional consultants and business owners with step-by-step guidance for configuring Odoo Accounting modules, tax rules, and financial workflows.
Monthly Bookkeeping Closer — This tool automates the monthly bookkeeping reconciliation process by identifying anomalies, categorizing transactions, and generating financial summaries for accounting professionals.
Sales Accounting — Sales register: customer, invoice, gross amount, discount, VAT and TDS, net receivable, credit terms and balance. Use for sales accounting.
Excel Processor — The Excel Processor reads, transforms, and analyzes spreadsheet data in .xlsx, .xls, and .csv formats. It merges CSVs, creates pivot tables, cleans data, adds formulas, filters rows, and generates reports from tabular data. This skill benefits analysts, data scientists, and business users who need efficient, accurate spreadsheet manipulation and reporting.
Financial Projection Engine — This tool helps business owners and financial analysts project future cash flow by identifying recurring revenue and expense patterns using historical transaction data.
Tax Document Organizer — This tool scans your folders to identify, rename, and organize tax documents into a CPA-ready package while generating a list of missing items.
Odoo Payroll Architect — This expert assistant helps HR managers and accountants configure Odoo salary structures, leave policies, and payroll accounting integrations for accurate employee compensation management.
Spreadsheet Data Analyst — This tool profiles, cleans, and analyzes spreadsheet exports using code to provide accurate, reproducible business insights and metrics for data-driven decision makers.
Asset Depreciation Calculator — This tool helps business owners and accountants calculate annual asset depreciation deductions using MACRS schedules and Section 179 expensing for tax reporting.
Expense Reconciliation Auditor — This tool automates expense folder audits by reconciling receipts with bank statements, categorizing transactions, and flagging policy violations for financial controllers.
Clients Accounts — Client and account register: contacts, billing address, tax ID and basis, payment terms, invoice totals, amounts paid and outstanding balance. Use for account tracking.
QuickBooks Online Integration — Connect SaaS apps to QuickBooks Online via OAuth2 to automate financial data pipelines and accounting integrations for small businesses.
Billing Automation — The skill automates invoice generation, billing workflows, payment tracking, and revenue recognition for SaaS and service businesses. It streamlines subscription management, usage-based invoicing, and payment reminders, enabling accurate financial reporting and efficient accounts receivable processes. This solution benefits finance teams and product managers who need reliable, end-to-end billing pipelines.
Accounting Audit System Builder — Routes an accounting or audit request to the right module skill, from software selection through monthly closing, asking only what is missing. Use for books of accounts or audit files.
Monthly Closing Statements — Monthly closing register: period dates, cash/bank/party/inventory/TDS reconciliation flags, profit, receivables, payables, working capital, open adjustments and reviewer. Use for period close.
Tds Booking Payment — TDS register: payee PAN, payment nature, rate and amount deducted, deposit date and challan reference, return filing and ledger variance. Use for TDS compliance.
Professional Invoice Generator — This tool helps freelancers and small business owners quickly create professional, branded PDF invoices by automating template setup and billing details.
Accounts Receivable Analyzer — This tool categorizes outstanding invoices into aging buckets to help financial managers identify overdue payments and assess total credit exposure.
Seasonal Trend Analyzer — This tool identifies cyclical revenue and expense patterns to help business owners optimize cash flow, staffing, and marketing strategies throughout the year.
Tax Strategy Advisor — Provides actionable tax optimization strategies and financial planning insights to help individuals maximize deductions and improve their long-term tax efficiency.
Excel Spreadsheet Manager — Generate and parse Excel spreadsheets with ExcelJS, assisting developers in tasks like data export, report building, and data pipelines.
Home Office Deductor — This tool helps self-employed individuals calculate their home office tax deduction by comparing simplified and actual expense methods for accurate reporting.
Cash Flow Forecaster — This tool generates a 13-week rolling cash flow forecast from financial data to help small business owners identify potential liquidity crunches before they occur.
Payroll Finance — Payroll register: employee, department and month, basic, DA, HRA and TA, bonus, deductions, net pay, pay period, payment date and method. Use for payroll records.
Budget Cash Flow — Budget against actual by department, category and period, with budget and actual amounts, variance, percentage used and linked expenses. Use for budget tracking or cash-flow reviews.
Bookkeeping Workflow Automation — Automates bookkeeping tasks like parsing statements, categorizing transactions, reconciling accounts, and generating reports, benefiting accountants and business owners.
Accounting Software Selection — Scores shortlisted accounting packages against 57 evidence-backed fields, emitted as CSV, SQL, JSON Schema or Notion on request. Use for choosing accounting software.
Tax Register — Tax register: sales and purchase tax, withholding deducted and received, net payable, filing due date and days remaining. Use for tax compliance.
Spreadsheet Integrity Auditor — This tool identifies structural errors and formula inconsistencies in business spreadsheets to help financial analysts and operators ensure data accuracy and model reliability.
IRS Penalty Estimator — This tool helps taxpayers and accountants calculate potential IRS underpayment penalties by analyzing quarterly tax payment history and liability requirements.
State Tax Calculator — This tool helps taxpayers estimate their state income tax liability and remaining balance by analyzing annual income data and existing tax payments.
Schedule C Organizer — This tool categorizes business expenses into IRS Schedule C line items to streamline tax preparation for freelancers and small business owners.
Artifact_spreadsheet — The skill creates, reads, edits, and cleans spreadsheet files in .xlsx, .xlsm, .csv, and .tsv formats. It restructures messy tabular data into proper workbooks, applies formulas, recalculates values, and enforces validation gates. Developers and data engineers benefit from reliable spreadsheet manipulation within automated build tasks.
Spreadsheet Logic Engine — This tool enables AI agents to execute formula-backed spreadsheet operations programmatically, providing reliable business logic processing without requiring manual UI interaction.
Excel Financial Modeler — This tool assists financial analysts in creating error-free, industry-standard Excel models by enforcing strict formatting, color-coding conventions, and precise formula integrity.
Spreadsheet Automation Tool — This skill enables users to create, edit, clean, and convert spreadsheet files, providing data professionals with efficient tools for managing complex tabular data.
Time Tracking — Time entry register: employee, project, client, task, hours, billable flag, rate and amount, invoice and approver. Use for time tracking.
R&D Finance Manager — Manages internal R&D program finances, including budgeting, burn rate tracking, and routing capitalization decisions to finance owners.
Annual Financial Reporter — This tool generates comprehensive annual financial reviews with spending trends and category breakdowns to assist users with tax preparation and goal setting.
Charitable Giving Tracker — This tool analyzes your transaction history to categorize charitable donations, calculate annual totals, and estimate potential tax deductions for tax season preparation.
Quarterly Tax Estimator — This tool helps self-employed individuals and business owners calculate accurate quarterly tax payments while ensuring compliance with IRS safe harbor penalty rules.
Rental Property Analyzer — This tool helps real estate investors calculate key financial metrics and organize property-specific income and expenses for efficient tax preparation.
Contractor Payment Tracker — This tool helps business owners monitor independent contractor payments to ensure accurate tax reporting and identify vendors nearing the IRS 1099-NEC threshold.
Financial Statement Generator — This tool generates detailed profit and loss statements for specific date ranges to help business owners analyze revenue, expenses, and net margins.
Financial Statement Processor — This tool converts financial PDF documents into structured spreadsheets while mathematically verifying data integrity to ensure all transactions and balances reconcile perfectly for accountants.
Grow Sustainably — The Grow Sustainably skill calculates a small business’s self‑funded growth rate, evaluating the financial viability of hires, leases, ad spend, and large contracts through metrics such as contribution margin, break‑even, and cash buffer. It delivers actionable guardrails and thresholds that help SaaS, services, retail, and wholesale companies make informed decisions about hiring, advertising, organic growth, cash flow, and burnout prevention.
Petty Cash Management — Petty cash register: entry number, date and type, payee and purpose, cash in and out, running balance, cash limit flag, custodian, physical count and variance. Use for petty cash.
Source Document Filing — Source document register: document type and number, party, amount, index key, storage location, retention period and verification. Use for document filing.
Credit Cycle Analysis — Debtor and creditor credit-cycle analysis: weighted collection or payment days, ageing buckets, credit limit utilisation and gap against benchmark. Use for working-capital review.
SRED Documentation Assistant — This tool aggregates annual GitHub, Notion, and Linear activity into organized project summaries to streamline the preparation of SRED tax credit documentation.
Venmo Transaction Reconciler — This tool automates the reconciliation of Venmo exports by classifying business transactions and filtering out personal payments for small business owners and accountants.
Subscription Savings Analyst — This tool analyzes transaction history to identify recurring charges and unused subscriptions, helping users optimize their monthly spending and maximize annual savings.
Net Worth Tracker — This tool helps individuals calculate their total net worth by aggregating transaction data and user-provided account balances into a comprehensive financial statement.
Stripe Transaction Importer — This tool automates the reconciliation of Stripe CSV exports into Open Accountant by processing charges, fees, and refunds for financial accuracy.
Square Transaction Importer — This tool automates the import and reconciliation of Square POS sales data into Open Accountant for business owners and bookkeepers.
Insurance Expense Auditor — This tool analyzes your annual insurance premiums by category and compares them against standard benchmarks to help you identify potential overspending.
Transaction Splitter — This tool helps users accurately divide single transactions into multiple categories, ensuring precise expense tracking for mixed-purpose purchases and complex financial reporting.
Subscription Expense Auditor — This tool analyzes transaction history to identify recurring charges, calculate total spending, and flag unused subscriptions to help users optimize their monthly budgets.
Automated Receivables Manager — This tool generates AR aging reports and drafts personalized, escalating payment reminders to help freelancers and small businesses recover outstanding invoices efficiently.
Financial Modeling Assistant — Provides comprehensive financial ratio analysis, DCF valuation, and forecasting tools to assist finance professionals in making data-driven strategic business decisions.
Business Finance Analysis — Analyzes business finance fundamentals like profit margins, unit economics, and LTV/CAC to assist with financial planning and decision-making.
Template Engine — The Template Engine automatically populates document templates with data, enabling users to create mail merges, generate letters or invoices, and auto-fill forms from spreadsheets. It supports DOCX, PDF, HTML, and plain text formats, allowing bulk generation of professional documents. This skill benefits businesses and individuals who need efficient, accurate document creation at scale.