AI Bad Debt Estimator
Calculate and justify Allowance for Doubtful Accounts using GAAP-compliant methods.
Act as a Senior US Bookkeeper and Financial Controller. Your goal is to estimate the 'Bad Debt Expense' and the 'Allowance for Doubtful Accounts' for a business based on the following data: [Aged_Receivables_Summary]. ### Contextual Parameters: - Accounting Methodology: [Methodology] (e.g., Percentage of Sales, Percentage of Receivables, or Specific Identification). - Historical Loss Rate: [Historical_Loss_Rate]% - Reporting Period: [Reporting_Period] ### Task Requirements: 1. **Data Analysis**: Review the provided [Aged_Receivables_Summary]. Categorize the risk levels for each aging bucket (Current, 1-30, 31-60, 61-90, 90+ days). 2. **Calculation**: Apply the historical loss rate or the specific aging percentages provided to calculate the required ending balance in the Allowance for Doubtful Accounts. 3. **Adjusting Entry**: Calculate the necessary adjustment entry by comparing the required balance to the current unadjusted balance of [Current_Allowance_Balance]. 4. **GAAP Compliance**: Provide a brief justification for the estimate based on the 'Matching Principle' and ASC 326 (CECL) if applicable. 5. **Risk Assessment**: Identify the top 3 high-risk accounts that should be monitored for potential direct write-off. ### Output Format: - **Executive Summary**: Total estimated bad debt. - **Journal Entry**: Debit/Credit format. - **Aging Table**: Breakdown of calculations per bucket. - **Strategic Recommendations**: Steps to improve collections for high-risk categories. Data to process: [Aged_Receivables_Summary]
Act as a Senior US Bookkeeper and Financial Controller. Your goal is to estimate the 'Bad Debt Expense' and the 'Allowance for Doubtful Accounts' for a business based on the following data: [Aged_Receivables_Summary]. ### Contextual Parameters: - Accounting Methodology: [Methodology] (e.g., Percentage of Sales, Percentage of Receivables, or Specific Identification). - Historical Loss Rate: [Historical_Loss_Rate]% - Reporting Period: [Reporting_Period] ### Task Requirements: 1. **Data Analysis**: Review the provided [Aged_Receivables_Summary]. Categorize the risk levels for each aging bucket (Current, 1-30, 31-60, 61-90, 90+ days). 2. **Calculation**: Apply the historical loss rate or the specific aging percentages provided to calculate the required ending balance in the Allowance for Doubtful Accounts. 3. **Adjusting Entry**: Calculate the necessary adjustment entry by comparing the required balance to the current unadjusted balance of [Current_Allowance_Balance]. 4. **GAAP Compliance**: Provide a brief justification for the estimate based on the 'Matching Principle' and ASC 326 (CECL) if applicable. 5. **Risk Assessment**: Identify the top 3 high-risk accounts that should be monitored for potential direct write-off. ### Output Format: - **Executive Summary**: Total estimated bad debt. - **Journal Entry**: Debit/Credit format. - **Aging Table**: Breakdown of calculations per bucket. - **Strategic Recommendations**: Steps to improve collections for high-risk categories. Data to process: [Aged_Receivables_Summary]
More Like This
Back to LibraryAI-Enhanced Audit Trail & Transaction Documentation
This prompt helps bookkeepers and business owners document the 'why' and 'how' behind financial transactions. It creates a structured audit trail that links source documents to ledger entries, ensuring compliance with US accounting standards.
AI Depreciation Schedule Generator
This prompt generates comprehensive depreciation schedules for business assets according to US bookkeeping standards. It calculates monthly and annual expense allocations while providing necessary journal entries and tax-basis adjustments.
AI Loan Amortization & Bookkeeping Scheduler
This prompt enables users to calculate detailed loan payoff schedules including monthly interest, principal reduction, and remaining balances. It is specifically designed to assist US bookkeepers in recording accurate journal entries for debt service.