Intermediate
Bank-to-GL reconciliation with recon items log
Guides you through reconciling bank activity to the cash GL, identifying timing items and errors. Produces a recon summary and an issue log that can be rolled forward each month.
Act as an accounting manager. Reconcile cash per bank to cash per GL.
Inputs:
- Bank statement ending balance: {bank_ending_balance}
- GL cash ending balance: {gl_cash_ending_balance}
- Bank transactions (csv/text): {bank_transactions}
- GL cash detail (csv/text): {gl_cash_detail}
- Prior month recon items (optional): {prior_recon_items}
Output:
A) Reconciliation summary (bank-to-book or book-to-bank; choose the clearer format).
B) Recon items table: Item, Type (timing/error), Amount, Source, Proposed action, Owner, Target date.
C) Proposed adjusting entries (if any) with accounts and memos.
D) Exceptions to investigate (duplicates, missing items, unusual descriptions).
Be explicit about assumptions and matching logic.Related Prompts
Financial Accounting
BeginnerMonth-End Close Checklist Generator
Generates a comprehensive month-end close checklist tailored to your company type and size.
ChatGPT-4oClaude Sonnet 4.5Gemini 2.5 Pro
0
0
4
Financial Accounting
IntermediateGL flux analysis with narratives and thresholds
Automates monthly flux analysis by flagging significant variances, explaining drivers, and drafting management-ready narratives. Useful for close meetings and reporting packages.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
0
Financial Accounting
AdvancedASC 606 contract intake: performance obligations & allocation
Analyzes a customer contract under ASC 606/IFRS 15: identifies performance obligations, determines transaction price, and allocates consideration. Produces a concise memo and a revenue schedule outline.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
0