UK Bookkeeping AI Quarterly Review Template
Generate comprehensive, MTD-compliant quarterly financial reviews with HMRC-specific insights and actionable compliance checks.
Act as an expert UK Bookkeeper and Financial Analyst specializing in UK GAAP, HMRC compliance, and Making Tax Digital (MTD) regulations. Prepare a comprehensive Quarterly Review Report for the following UK business: **Company Details:** - Company Name: [COMPANY_NAME] - Business Structure: [BUSINESS_STRUCTURE] (Limited Company, Sole Trader, Partnership, LLP) - Industry Sector: [INDUSTRY] - Quarter Period: [QUARTER_PERIOD] (e.g., Q1 2024, 1 Jan - 31 Mar 2024) - VAT Registration Status: [VAT_STATUS] (Registered/Not Registered) - VAT Scheme: [VAT_SCHEME] (Standard Accounting, Cash Accounting, Flat Rate Scheme, Margin Scheme) - VAT Number (if applicable): [VAT_NUMBER] - Current Tax Year: [TAX_YEAR] (e.g., 2023/24) **Financial Data Input:** [PASTE_FINANCIAL_DATA_HERE] Include: Turnover/Sales figures, Cost of Sales, Operating Expenses breakdown, Net Profit/Loss, VAT liability (output tax minus input tax), Bank reconciliation status (current balance and uncleared items), Debtors aging (0-30, 31-60, 60+ days), Creditors aging, Stock/inventory levels (if applicable), Previous quarter comparison figures, Year-to-date totals. **Specific Context:** [SPECIFIC_CONCERNS] (e.g., "Considering equipment purchase", "New contractor hired", "Cash flow tight", "Preparing for year-end") **Required Output Structure:** 1. **Executive Dashboard** (Traffic Light System: 🔴🟡🟢) - Overall financial health snapshot - Compliance status (VAT, Companies House, MTD) - Critical alerts requiring immediate action 2. **Financial Performance Analysis** - Quarter-on-quarter and year-on-year variance analysis (highlight >10% deviations) - Gross profit margin calculation and trend - Net profit margin and operating efficiency - Industry benchmarking for [INDUSTRY] where data permits 3. **UK Tax Compliance & Planning** - **VAT Assessment**: Readiness for submission, scheme-specific calculations (e.g., Flat Rate % check), MTD digital link compliance verification - **Corporation Tax** (if Ltd): Estimated provision, marginal rate considerations, associated company rules impact - **Income Tax** (if Sole Trader/Partner): Payment on account calculations, Class 2/4 NIC projections - **CIS Review** (if construction): Verification of deductions suffered vs. paid - **Capital Allowances**: Identify qualifying purchases (AIA, WDA, FYA implications) - **IR35/Off-payroll**: Risk assessment for new contractors/intermediaries 4. **Cash Flow & Working Capital** - Liquidity ratio analysis (current ratio, quick ratio) - Debtor days calculation with collection prioritization list - Creditor management strategy - 90-day cash flow projection highlighting pinch points 5. **Compliance Calendar & Risks** - Upcoming HMRC deadlines (VAT, CT600, SA302, Confirmation Statement) - Companies House filing requirements (Annual Accounts due dates) - MTD ITSA readiness check (if applicable from April 2026) - Identified bookkeeping discrepancies requiring adjustment 6. **Strategic Recommendations** - Tax efficiency opportunities (pension contributions, salary vs. dividends analysis for Ltd, SEIS/EIS investor considerations) - Process improvements for next quarter (digital record-keeping suggestions) - Risk mitigation strategies **Formatting Requirements:** - Use UK terminology (turnover, debtors, creditors, stock, not revenue, AR/AP, inventory) - Include specific HMRC reference codes where relevant (e.g., CCH codes, VAT Notice references) - Present calculations in clear tables - Flag estimates vs. exact figures - Add disclaimer: "This review is based on provided data and does not constitute legal or financial advice. Verify all tax rates against current HMRC guidance." **Tone:** Professional, precise, and proactive. Assume the user understands basic bookkeeping but needs expert compliance guidance.
Act as an expert UK Bookkeeper and Financial Analyst specializing in UK GAAP, HMRC compliance, and Making Tax Digital (MTD) regulations. Prepare a comprehensive Quarterly Review Report for the following UK business: **Company Details:** - Company Name: [COMPANY_NAME] - Business Structure: [BUSINESS_STRUCTURE] (Limited Company, Sole Trader, Partnership, LLP) - Industry Sector: [INDUSTRY] - Quarter Period: [QUARTER_PERIOD] (e.g., Q1 2024, 1 Jan - 31 Mar 2024) - VAT Registration Status: [VAT_STATUS] (Registered/Not Registered) - VAT Scheme: [VAT_SCHEME] (Standard Accounting, Cash Accounting, Flat Rate Scheme, Margin Scheme) - VAT Number (if applicable): [VAT_NUMBER] - Current Tax Year: [TAX_YEAR] (e.g., 2023/24) **Financial Data Input:** [PASTE_FINANCIAL_DATA_HERE] Include: Turnover/Sales figures, Cost of Sales, Operating Expenses breakdown, Net Profit/Loss, VAT liability (output tax minus input tax), Bank reconciliation status (current balance and uncleared items), Debtors aging (0-30, 31-60, 60+ days), Creditors aging, Stock/inventory levels (if applicable), Previous quarter comparison figures, Year-to-date totals. **Specific Context:** [SPECIFIC_CONCERNS] (e.g., "Considering equipment purchase", "New contractor hired", "Cash flow tight", "Preparing for year-end") **Required Output Structure:** 1. **Executive Dashboard** (Traffic Light System: 🔴🟡🟢) - Overall financial health snapshot - Compliance status (VAT, Companies House, MTD) - Critical alerts requiring immediate action 2. **Financial Performance Analysis** - Quarter-on-quarter and year-on-year variance analysis (highlight >10% deviations) - Gross profit margin calculation and trend - Net profit margin and operating efficiency - Industry benchmarking for [INDUSTRY] where data permits 3. **UK Tax Compliance & Planning** - **VAT Assessment**: Readiness for submission, scheme-specific calculations (e.g., Flat Rate % check), MTD digital link compliance verification - **Corporation Tax** (if Ltd): Estimated provision, marginal rate considerations, associated company rules impact - **Income Tax** (if Sole Trader/Partner): Payment on account calculations, Class 2/4 NIC projections - **CIS Review** (if construction): Verification of deductions suffered vs. paid - **Capital Allowances**: Identify qualifying purchases (AIA, WDA, FYA implications) - **IR35/Off-payroll**: Risk assessment for new contractors/intermediaries 4. **Cash Flow & Working Capital** - Liquidity ratio analysis (current ratio, quick ratio) - Debtor days calculation with collection prioritization list - Creditor management strategy - 90-day cash flow projection highlighting pinch points 5. **Compliance Calendar & Risks** - Upcoming HMRC deadlines (VAT, CT600, SA302, Confirmation Statement) - Companies House filing requirements (Annual Accounts due dates) - MTD ITSA readiness check (if applicable from April 2026) - Identified bookkeeping discrepancies requiring adjustment 6. **Strategic Recommendations** - Tax efficiency opportunities (pension contributions, salary vs. dividends analysis for Ltd, SEIS/EIS investor considerations) - Process improvements for next quarter (digital record-keeping suggestions) - Risk mitigation strategies **Formatting Requirements:** - Use UK terminology (turnover, debtors, creditors, stock, not revenue, AR/AP, inventory) - Include specific HMRC reference codes where relevant (e.g., CCH codes, VAT Notice references) - Present calculations in clear tables - Flag estimates vs. exact figures - Add disclaimer: "This review is based on provided data and does not constitute legal or financial advice. Verify all tax rates against current HMRC guidance." **Tone:** Professional, precise, and proactive. Assume the user understands basic bookkeeping but needs expert compliance guidance.
More Like This
Back to LibraryAI HMRC Correspondence Helper
This prompt helps UK bookkeepers, accountants, and small business owners decode official HMRC correspondence, understand their obligations, and respond appropriately. It translates complex tax language into plain English while flagging deadlines, penalties, and required actions.
UK Bookkeeping Knowledge Base Architect
This prompt transforms AI into a specialized UK bookkeeping consultant that creates structured, searchable knowledge bases complete with Standard Operating Procedures (SOPs), compliance checklists, and troubleshooting guides. It ensures all content adheres to current UK regulations including Making Tax Digital (MTD), HMRC requirements, and Companies House filing obligations.
AI Receipt Categorization Assistant
This prompt template transforms your AI into an expert UK bookkeeper capable of analyzing receipts, calculating recoverable VAT, assigning correct nominal codes, and ensuring HMRC compliance. It handles complex scenarios including mixed-use expenses, foreign currency, and different VAT schemes while outputting ready-to-use bookkeeping entries.