Audit intermediate Works with: Any AI

Inventory and Asset Count Reconciliation Review

Table output Has example

Compare counts with records and trace differences.

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

Rate this prompt

Loading ratings…

Reconcile stock or assets. Records versus physical count by item code: [COUNT_COMPARISON]. Count method and date: [COUNT_METHOD]. Movements since the count: [MOVEMENTS].

Calculate differences in units and value, the shrinkage rate as difference value divided by book value, and flag items above [THRESHOLD] percent. Consider timing differences before suggesting loss.

Return a table, arithmetic, likely causes and controls: cycle counts, locked storage and sign-off for write-offs.

Add a worked calculation: book value of stock 80,000; counted 78,400; difference 1,600; shrinkage = 1,600 divided by 80,000 equals 2 percent. Item X: book 50, counted 40, difference 10 units at 12 equals 120, which is 20 percent of the item. Timing: 6 units were shipped after the count, which explains 6 of the 10, leaving 4 units or 48. Show the adjusted result and recommend a cycle count of high-value items.

Finish with a one-line explanation of the difference between a count error, a timing difference and a loss, so that no difference is called a loss before the timing is checked.

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 stock. Book value 80,000; counted 78,400; difference 1,600; shrinkage = 1,600 / 80,000 = 2 percent.
Item X: book 50 units, counted 40, difference 10 units at 12 = 120, which is 20 percent of the item.
Timing: 6 units were dispatched after the count, explaining 6 x 12 = 72. Remaining 4 units = 48.
Adjusted difference for the item: 48. Next step: recount item X and check dispatch records.
Control: monthly cycle counts of high-value items.
Sign-off rule: write-offs above 100 need the manager's approval and a reason recorded.

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

Related prompts