GWP Stock Receipt and Variance Reconciliation Audit
Audit the stock you received, issued, and returned for a GWP promotion, then reconcile any variance before closeout. Use it to catch missing units, bad counts, and unsupported adjustments while the records are still available.
Trusted by frontline teams 15 years of frontline software AI customization in seconds
Built for: Retail · Consumer Packaged Goods · Wholesale Distribution · E Commerce Fulfillment
Overview
This template is for reconciling gift-with-purchase stock at the end of a promotion. It captures the promotion details, the units received from the brand, the units issued through POS, the units returned at closeout, and the final variance analysis so the closeout can be approved with evidence.
Use it when a promotion has a defined start and end, a known allocation method, and source records that can be compared against physical stock. It is especially useful when multiple people touch the inventory, when stock is moved between locations, or when the brand requires settlement support for shortages or overages.
Do not use it as a generic warehouse cycle count or as a substitute for daily inventory control. It is not designed for open-ended stock audits, non-promo merchandise, or situations where there is no reliable receipt or POS issue record. If the promotion was never tracked at receipt, the template can still document the closeout, but the variance explanation will be weaker and may require a manual exception note.
The template is structured to follow the actual reconciliation flow: define the audit scope, verify receipts and stock records, compare POS issues and returns, analyze variances, and finish with approval and follow-up. That makes it easier to spot missing documents, incorrect cutoff timing, and unsupported adjustments before the record is filed.
Standards & compliance context
- This template supports internal control and audit trail expectations commonly used in ISO 9001-style quality systems and trade promotion governance.
- If the promotion involves regulated products or controlled distribution, keep the reconciliation aligned with the applicable company SOPs and any brand or distributor retention rules.
- Where inventory handling overlaps with workplace safety, follow general OSHA housekeeping and material handling expectations for safe segregation and storage.
- If the closeout process is part of a broader food, pharmacy, or consumer goods workflow, retain records in a way that supports the applicable industry audit requirements and traceability expectations.
General regulatory context for orientation only — verify current requirements with counsel or the relevant agency before relying on this template for compliance.
What's inside this template
Audit Scope and Promotion Details
This section defines the exact promotion, location, channel, and cutoff so every later count is tied to the correct event.
- Promotion name, SKU, and audit period are documented
- Audit location and POS channel are identified
- Brand issue terms and expected GWP allocation method are available
- Audit cutoff date and time align to promotion end
- Inspector confirms all relevant source records are included
Receipt and Stock Record Verification
This section proves what was received, what condition it arrived in, and what physical stock remained at closeout.
- Units received from brand are recorded with date and quantity
- Receiving documentation matches the recorded quantity
- Any damaged, short, or over-received units are identified
- Physical stock on hand at closeout is counted
- Stock is segregated from non-promotion inventory and clearly identified
POS Issue and Return Reconciliation
This section compares issued and returned units against the expected closing balance to expose any mismatch.
- Units issued at POS are extracted from the sales or issue log
- Units returned at promotion end are counted and recorded
- Expected closing balance is calculated correctly
- Actual closing balance matches expected balance within tolerance
- Variance amount is calculated and documented
Variance Analysis and Root Cause
This section explains why the numbers differ and whether the difference needs an approved adjustment.
- Variance explanation is supported by source evidence
- Variance cause is classified
- Variance exceeds approval threshold
- Adjustment request has been raised for unresolved variance
- Root cause and corrective action are documented
Closeout Approval and Follow-up
This section turns the reconciliation into an authorized record with assigned actions and retention-ready documentation.
- Final reconciliation is reviewed and approved by authorized owner
- Supporting documents are filed for audit retention
- Outstanding actions and due dates are assigned
- Inspector signature
How to use this template
- Enter the promotion name, SKU, audit period, location, POS channel, and cutoff time so the reconciliation is tied to one specific closeout event.
- Attach the brand issue terms, receiving documents, POS issue logs, and any return counts before you start the variance calculation.
- Count the physical stock on hand at closeout, separate promo units from non-promo inventory, and record any damaged, short, or over-received units.
- Compare units received, issued, and returned to calculate the expected closing balance, then document any difference against the actual count.
- Classify the variance cause, add source evidence for the explanation, and raise an adjustment request if the difference exceeds the approval threshold.
- Obtain final review and approval from the authorized owner, then file all supporting records and assign follow-up actions with due dates.
Best practices
- Use the exact promotion cutoff date and time from the brand terms, not the store close time, when calculating the closing balance.
- Keep promo stock physically segregated and clearly labeled so the closeout count does not mix with regular inventory.
- Reconcile against source records before you count the shelf stock, because the count should confirm the paper trail rather than replace it.
- Photograph damaged, short, or over-received units at the time they are identified and attach the images to the audit record.
- Require a second review for any variance above the approval threshold so unsupported adjustments do not get filed as final.
- Document whether the variance came from receiving, issue, return, shrink, or data entry error so corrective action can target the real failure point.
- Retain the receiving slip, POS export, count sheet, and approval trail together so the closeout can be traced during later review.
What this template typically catches
Issues teams running this template most often surface in practice:
Common use cases
Frequently asked questions
What does this GWP stock audit cover?
This template covers the full end-of-promotion reconciliation for gift-with-purchase units: brand receipts, physical stock on hand, POS issues, returns, and the final variance. It also captures the supporting documents needed to explain differences and approve any adjustment. Use it when you need a clean closeout record, not just a count of remaining units.
When should this audit be performed?
Run it at promotion end, immediately after the cutoff date and time, while receiving records, POS logs, and remaining stock are still easy to verify. It is also useful if a promotion is paused, extended, or transferred between locations, because those events often create reconciliation gaps. The closer the audit is to the closeout event, the easier it is to resolve variances.
Who should complete the reconciliation?
The audit is usually completed by a store manager, trade marketing coordinator, inventory controller, or another authorized owner who can access receiving records and POS issue data. A second reviewer or approver should validate the final balance if the variance exceeds the approval threshold. The person counting stock should not be the only person approving the adjustment.
How does this help with brand-supplied GWP inventory?
It creates a traceable chain from units received from the brand to units issued at POS and units returned at the end of the promotion. That makes it easier to prove whether the closing balance is correct and whether any shortage, overage, or damaged stock is real. It also gives the brand or internal finance team a documented basis for settlement.
What are the most common mistakes this template helps prevent?
Common mistakes include counting mixed promo and non-promo stock together, using the wrong cutoff time, and reconciling against incomplete POS issue logs. Another frequent issue is documenting a variance without attaching receiving slips, return counts, or a root-cause explanation. This template forces the evidence to be collected before the closeout is approved.
Can I customize this audit for different promotion types?
Yes. You can adapt the fields for single-SKU giveaways, tiered GWP offers, multi-location promotions, or channel-specific issue methods such as store issue, warehouse issue, or direct-to-store delivery. If your promotion uses partial packs, mixed cartons, or manual issue logs, add those details to the receipt and reconciliation sections so the expected balance is calculated correctly.
Does this template integrate with POS or inventory systems?
It works well alongside POS exports, warehouse receiving records, and inventory management reports, even if the template itself is used as the audit record. The key is to attach or reference the source files used to calculate issued, returned, and closing quantities. If your team uses spreadsheets or BI exports, this template gives you a consistent review structure.
How is this different from a simple stock count sheet?
A stock count sheet only tells you what is on hand at a point in time. This audit also explains where the stock came from, how much was issued, what was returned, and why any difference exists. That makes it much more useful for approval, dispute resolution, and audit retention.
Related templates
Go deeper on the topic
-
A daily huddle is a brief (10–15 minute) standing meeting held at the start of a shift or workday to align the team on priorities, surface issues, and...
-
A deskless worker is any employee whose job happens without a desk, a company laptop, or a fixed workstation. They're roughly 80% of the global workforce —...
-
A frontline employee app is a phone-first application that gives hourly, field, and deskless workers access to their schedule, pay, announcements, training,...
-
A frontline worker is any employee whose job happens away from a desk — on a production floor, in a patient room, behind a store counter, in a customer's...
-
Discover why manufacturing teams need mobile tools — from real-time safety alerts to on-the-go training and frontline recognition. See how MangoApps helps.
-
Union workforce software that automates CBA compliance, overtime, and grievances—cut manual work and reduce risk.
-
AI won’t replace frontline workers—it will separate organizations that equip them from those that don’t.
-
Outdated tools hurt large companies with communication, collaboration, and security issues—cut costs with modern enterprise tools.
Ready to use this template?
Get started with MangoApps and use GWP Stock Receipt and Variance Reconciliation Audit with your team — pricing built for small business.
