On this page Jump to section
Question and scope
Does a QuickBooks Online inventory quantity adjustment made after a period has closed change that closed period's cost of goods sold, or does the effect land only in the period where the adjustment is entered? A bookkeeping VA meets this question during a cycle count, after a receiving error, or when a client says the inventory on hand is wrong but the month has already been reported. The answer decides whether the correction needs a prior-period note, a current-period entry, or a conversation with the accountant before anything is posted. A rushed adjustment can make the count right and the reported margin wrong at the same time.
The scope is one QuickBooks Online company file, one inventory item, and one closed accounting period with a saved inventory valuation and profit and loss report. It includes quantity adjustments made through the inventory adjustment screen and adjustments made by editing an existing transaction. It excludes a change to the item's costing method, a full inventory rebuild, and a migration between subscription levels, because each of those changes the measurement basis rather than the quantity. Those changes deserve a separate test with their own baseline and approval.
Why an adjustment could reach a closed period
QuickBooks Online computes inventory value from quantity on hand and the cost assigned to the item. When a quantity adjustment changes the count, the product also has to decide how to value the difference. Depending on the item setup and the transaction date, that value change can post to an inventory adjustment account, to cost of goods sold, or to another account chosen by the user. That posting is the mechanism by which a closed period could move.
The date on the adjustment adds a second variable. If the adjustment is dated inside the closed period, the report for that period may recalculate even though nobody edited an old sale. If it is dated in the current period, the quantity changes now but the closed report should keep its original figures. The audit has to separate the transaction date from the entry date, because a user can enter an adjustment today with a date from last month.
Population and baseline
Build the population from every inventory adjustment that touches the item during a defined window around the closed period. Record the adjustment date, entry date, quantity before and after, unit cost, value change, offset account, and the user who posted it. Include at least one adjustment dated inside the closed period and one dated after it, so the test can compare both paths. Exclude adjustments to items that are not tracked as inventory, because they do not carry the same valuation logic.
Freeze the baseline before making any change. Export the inventory valuation summary for the closed period and save the exact as-of date and report run time. Export the profit and loss report for the same period with cost of goods sold detail visible, and save the inventory adjustment account activity. Screenshot the item's current setup, including costing method and the accounts assigned to inventory and cost of goods sold.
Test setup
Work in a copy of the company file when the subscription allows it. A quantity adjustment in the live file can change the current inventory value, the next report a client sees, and any open order that depends on availability. If a copy is not possible, schedule the test outside business hours, get written approval for the window, and record every setting before the edit. The test must be reversible without guessing which values were original.
Change one variable at a time. First test a quantity adjustment dated inside the closed period with no change to unit cost. Then test the same quantity change dated in the current period. Finally, test a quantity adjustment that also changes the value, because quantity and value can follow different posting rules. A test that changes date, quantity, and value together cannot show which factor moved the report.
Procedure
Run the baseline comparison before touching the item. Reopen the saved valuation and profit and loss reports and confirm that they still match the exports from the close date. This step catches ordinary drift from later sales or receipts, so the test does not blame an old change on the new adjustment. Record the current figures and the run time before proceeding.
Next, post the smallest plausible adjustment inside the closed period, such as a one-unit decrease at the item's current cost. Save it, then rerun the valuation and profit and loss reports with the same date range and accounting method. Compare the inventory value, the cost of goods sold total, and the adjustment account balance line by line. Capture the before and after values for the item and for the affected accounts, then reverse the adjustment and confirm the reports return to baseline.
Repeat the same quantity change with a current-period date and compare the same three figures. If the closed period holds while the current period moves, the date is the controlling factor in this file. If both periods move, the item setup or the offset account is routing the value differently than the date alone would suggest. Record the result with the exact dates and report settings, not a general statement that inventory changed.
Definitions and measures
A retroactive value effect means the closed period's cost of goods sold changes after the adjustment without any historical sales form being edited. A current-period effect means the closed period keeps its original figures and the adjustment lands in the period where it was entered. A split effect means the quantity moves in one period and the value moves in another, which is the outcome most likely to confuse a reviewer who checks only one report. Name the category before writing the memo so the conclusion is not reduced to a vague change.
Measure the result at three levels. The first is the item, where quantity on hand and inventory value either change or hold. The second is the report, where cost of goods sold and the adjustment account either move or hold for the closed period. The third is the trial balance, where the inventory asset and the offset account must move by the same amount for the entry to balance. Report all three, because a stable profit and loss total can still hide a shifted balance sheet.
Worked example
Suppose a client closed a quarter with 240 units on hand and an inventory value of 4,800 dollars. A cycle count later finds 236 units, and the VA posts a four-unit decrease dated on the last day of the closed quarter. If the item is set to average cost, the adjustment may reduce inventory by the current average unit cost and post the difference to cost of goods sold for that quarter. The VA then reruns the closed reports and compares the result with the saved baseline.
If the closed quarter's cost of goods sold rises by the value of four units, the adjustment reached backward. The VA documents the change, checks whether the quarter was already reported to the owner or a lender, and asks the accountant whether a prior-period correction is needed. If only the current quarter moves, the closed report stands and the correction is a current-period item. The test establishes which happened; the accountant decides the reporting treatment.
Evidence standard
The evidence set includes the saved valuation and profit and loss reports, the item setup screenshots, the adjustment record, and the account activity before and after each test. Each claim in the memo should point to a specific artifact with a date and a report run time. A statement that the closed period did not change is credible only when the same report, date range, and accounting method are shown before and after with identical figures. Add at least three item-level or account-level examples so the conclusion rests on more than one total.
Keep the raw exports rather than only a summary table. A summary can omit the offset account or the quantity column that actually changed. If the report cannot be reproduced because the period is locked, the item was made inactive, or the subscription changed, say so and lower the confidence of the conclusion. Do not fill the gap with an assumption about how the product should behave.
Interpretation limits
A result in one company file does not prove that every QuickBooks Online edition or every inventory setup behaves the same way. The outcome can depend on the costing method, the inventory start date, the offset account, and whether the item had enough quantity to absorb the adjustment. Record the product edition, the item setup, and the test date so a later reviewer can judge whether the result still applies. A second item with a different costing method is a useful follow-up test.
The test also cannot see a value change that the interface hides, such as a cost layer consumed by a later sale before the report is rerun. That is why the procedure checks the item, the reports, and the account activity together. A clean result means no visible change in the fields examined, not proof that no database write occurred, and the memo should state that boundary. State also whether the period was locked during the test.
Review cadence
Repeat the test after any quantity adjustment that touches a closed period, any change to an item's costing method, and any product release that affects inventory valuation. A quarterly check is reasonable for a client with frequent cycle counts, while a client with a single annual count can test only when an adjustment is posted. The cadence should follow the risk of the change and the size of the inventory balance, not the calendar alone. Put the next test date in the client's close calendar rather than in a personal reminder.
Close the review with a named owner, the exact item settings, and a date for the next check. Link the result to the inventory adjustment evidence workflow and the inventory cycle count procedure so the next reviewer starts from the same standard. If the adjustment needs a correction, convert the finding into a dated entry with an approval step. The test answers what the adjustment changed; the accountant decides how the change should be reported.
