Audit intermediate Works with: Any AI

QuickBooks Bank Reconciliation and Cash Controls Audit

Table output Has example

Check that reconciliations are complete, timely and reviewed.

The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.

[VERIFY] is an editorial flag, not a blank to fill. Wherever the prompt shows [VERIFY], check that item against a reliable source before you use it.

Rate this prompt

Loading ratings…

Audit reconciliation practice. Data: for each bank and card account, the last reconciled date, the number of unreconciled transactions older than 60 days, the beginning balance check, any adjustment entries, and who prepares and who reviews: [RECONCILIATION_STATUS]. Our policy: [POLICY].

Check that every account is reconciled monthly, that nobody who handles cash also reconciles without review (a segregation of duties note appropriate for a very small team), that adjustment entries are small and explained, that old unreconciled items are investigated, and that reconciliation reports are saved. Count accounts meeting each test and show the percentage with arithmetic. Rate the control environment as strong, adequate or weak with reasons; example status (invented): current account reconciled to 28 February with 0 unreconciled items over 60 days. Separate facts from inferences and ask for evidence you have not seen.

Return a table of accounts and findings, a prioritised action list, and a monthly control checklist. This is a review of controls, not of people. Mark features such as audit logs and closing dates [VERIFY]. General education only: it is not accounting, tax or legal advice, and local rules vary, so end with the questions a qualified professional should answer for my situation [VERIFY].

Fill in before use

Optional: type your details and the prompt above updates. Nothing is saved or sent.

Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.

See an example result (fictional data)
Invented status of four accounts. Current account: reconciled to 28 February, 0 unreconciled items over 60 days. Savings: reconciled, 0. Card 1: last reconciled 31 December, 14 unreconciled items. Card 2: reconciled, 1 item over 60 days. Accounts reconciled monthly: 2 of 4 (50 percent). Adjustment entries in the year: 3, total 41.20, all explained. Preparer and reviewer are the same person on 2 accounts. Rating: adequate with gaps. Actions: reconcile Card 1 within a week, add an independent monthly review.

Illustrative only, made-up data. Your results will differ and must be reviewed.

Related prompts