Create a comparative balance sheet draft for a multi-entity dental practice group that reclassifies intercompany loan receivables/payables, adjusts Partners' capital for guaranteed payments, and flags contra-asset allowance for doubtful patient receivables based on aging analysis from the prior 13 billing cycles

Generate create a comparative balance sheet draft for a multi-entity dental practice group that reclassifies intercompany loan receivables/payables, adjusts partners' capital for guaranteed payments, and flags contra-asset allowance for doubtful patient receivables based on aging analysis from the prior 13 billing cycles for Accounting, Tax Preparation, Bookkeeping, and Payroll Services industry

Accounting, Tax Preparation, Bookkeeping, and Payroll Services

Agent Configuration

Login required: You need to sign in to execute this agent.

Click to upload or drag and drop

Allowed: XLSX, CSV, TXT

Max size: 10MB

Upload trial balance exports for each dental entity in the group (at minimum parent and all subsidiaries)
Period-end date for the comparative balance sheet (MM/DD/YYYY)
Balance-sheet date for the comparative prior period (MM/DD/YYYY)

Click to upload or drag and drop

Allowed: XLSX, CSV

Max size: 5MB

Upload the standardized chart-of-accounts mapping that aligns all entity GL codes to the parent presentation format

Click to upload or drag and drop

Allowed: XLSX, PDF, CSV

Max size: 10MB

Provide the detailed intercompany loan schedule showing payable/receivable pairs, interest rates, and maturity dates across all entities

Click to upload or drag and drop

Allowed: PDF, DOCX

Max size: 25MB

Upload executed partner guaranteed-payment agreements (salary/contract amounts for each partner) to adjust Partners' capital properly

Click to upload or drag and drop

Allowed: XLSX, CSV

Max size: 10MB

Aged patient receivables report for the most recent 13 billing cycles in detail by payer and buckets (0-30, 31-60, 61-90, 91-120, 120+ days)
Select the tax structure governing this dental group’s treatment of partner capital accounts
Primary payer and service mix used to benchmark allowance-for-doubtful-accounts percentages
Engagement level and compliance framework applicable to the draft balance sheet
Approach for estimating the allowance for doubtful accounts on patient AR
Any further instructions, assumptions, or disclosures required for GAAP/non-GAAP treatment, related-party footnotes, or covenant exclusions