US Bookkeeping

AI Intercompany Transaction Reconciler

Automate the identification and matching of due-to/due-from transactions across multiple entities.

#bookkeeping#accounting#us-gaap#reconciliation
P
Created by PromptLib Team
Published February 12, 2026
3,732 copies
3.8 rating
Act as a Senior US Bookkeeper and Financial Controller. Your task is to perform a detailed intercompany reconciliation between [ENTITY_A] and [ENTITY_B] for the period of [FISCAL_PERIOD].

### DATA INPUTS:
1. General Ledger Extract for Account [ACCOUNT_NAME_A] from [ENTITY_A]: [GL_DATA_A]
2. General Ledger Extract for Account [ACCOUNT_NAME_B] from [ENTITY_B]: [GL_DATA_B]
3. Threshold for Materiality: [MATERIALITY_THRESHOLD]

### INSTRUCTIONS:
1. **Matching Logic**: Identify transactions in [ENTITY_A] that have a corresponding reciprocal entry in [ENTITY_B]. Consider differences in dates (timing differences) and currency fluctuations if applicable.
2. **Discrepancy Analysis**: Flag any transactions that exist in one ledger but not the other. Categorize these as 'Unmatched - Missing in B', 'Unmatched - Missing in A', or 'Value Mismatch'.
3. **US GAAP Compliance**: Ensure all intercompany loans, management fees, and expense recharges follow standard US bookkeeping principles.
4. **Reporting**: Provide a table summarizing the 'Due To' and 'Due From' balances. Calculate the net variance.
5. **Adjustment Journal Entries**: Propose specific Journal Entries (Debit/Credit) to bring the accounts into balance, including descriptions for the entries.

### OUTPUT FORMAT:
- **Executive Summary**: Total balance per Entity A vs Entity B and the Net Variance.
- **Matched Transactions Table**: Date, Description, Amount A, Amount B.
- **Variance Report**: Detailed list of items causing the mismatch.
- **Proposed Adjustments**: Ready-to-post Journal Entries.
Best Use Cases
Monthly closing of parent-subsidiary accounts.
Preparing consolidated financial statements for US GAAP audits.
Identifying unrecorded management fees or shared service charges.
Cleaning up 'Due To/From' accounts that haven't been reconciled in multiple quarters.
Verifying intercompany loan interest calculations.
Frequently Asked Questions

More Like This

Back to Library

AI-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.

#bookkeeping#accounting+2
2,875
4.5

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.

#tax#accounting+3
3,564
4.6

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.

#bookkeeping#finance+1
3,294
4.8
Get This Prompt
Free
Quick Actions
Estimated time:10 min
Verified by62 experts