How to Reconcile an Antique Mall Sales Report and Payout

How to Reconcile an Antique Mall Sales Report With Your Own Records

The payout is the last number, not the whole explanation.

If an antique mall deposits $684.20, that amount alone does not tell you which items sold, whether the sale amounts match your records, which fees were applied, or why your own estimate was different. To answer those questions, reconcile the mall's report against your item, sale, fee, and deposit records in a consistent order.

This guide uses a manual workflow. A spreadsheet, notebook, or inventory app can support it, but no tool replaces the need to match the underlying records.

What reconciliation is trying to prove

A useful reconciliation should connect four layers:

1. Sold items: Which of your items does the mall report as sold?
2. Sale amounts: What amount was recorded for each sale, including any documented discount or adjustment?
3. Applicable fees: Which rent, commission, card, service, or other fee terms apply under your own agreement and statement?
4. Payout: Does the expected amount based on those records match the amount you actually received?

The goal is not to force the numbers to agree. The goal is to explain the difference.

Do not begin with assumptions about what every antique mall charges. Fee structures, discount handling, reporting detail, and payout timing vary. Use the agreement and report for your specific mall.

Gather the records before changing anything

Collect the documents and entries for the same reporting period:

• the mall sales report or vendor statement;
• your item list with stable item numbers;
• your own sale records, if you entered sales during the period;
• the fee setup or written agreement in effect for that period;
• records of documented discounts, returns, voids, or adjustments;
• the payout notice, check stub, or deposit record; and
• notes about timing differences carried from an earlier period.

Save an unchanged copy of the mall report before adding notes. If you work in a spreadsheet, create a separate reconciliation sheet rather than overwriting the source values.

Make sure every record covers the same start and end dates. A report ending September 30 and a deposit arriving October 3 may belong together. A sale from October 1 may not.

Step 1: Match every reported sale to one item

Start at the item level. Use the strongest identifier the mall provides, such as an item number, tag number, SKU, or sufficiently specific description.

For each line on the report:

1. Find the corresponding item in your records.
2. Confirm that the identifier and description reasonably refer to the same object.
3. Record the mall's sale date and sale amount in the reconciliation worksheet.
4. Mark the line as matched, unmatched, or needing review.
5. Preserve any uncertainty instead of assigning a line to the most likely item.

Descriptions such as “lamp” or “vase” are weak identifiers. If several items fit, do not guess. Flag the line and check tags, booth photos, prior inventory counts, or the mall's available transaction detail.

Also check the reverse direction: items you recorded as sold that do not appear on the mall report for this period. The explanation may be timing, a return, a duplicate entry, or another documented adjustment. It may also remain unresolved. Record the status before changing the original sale record.

Step 2: Verify the actual sale amounts

The tagged or list price is not always the amount that reached the sales report. A promotion, approved discount, return, or correction may change the figure.

For each matched item, compare:

• your recorded list or tagged price;
• your recorded actual sale amount, if available;
• the amount shown on the mall report; and
• any documented discount or adjustment.

Keep the list price and actual sale amount in separate columns. Replacing one with the other erases the information you need to explain the difference.

If the report shows a lower amount than your tag, verify whether the difference matches a documented discount. If the report shows a higher or otherwise unfamiliar amount, preserve it as a variance until you have support for an explanation.

Step 3: Verify the fee setup that actually applied

Do not use a universal antique-mall fee formula. Read the fee labels on the statement and compare them with the agreement or configuration that applied during the period.

Your worksheet may need separate lines for:

• fixed booth rent;
• percentage commission;
• card or transaction fees;
• advertising, service, or administrative fees;
• credits;
• returns or reversals; and
• prior-period balances.

Not every mall uses all of these. Some use different names or calculations. A percentage may apply to some sales and not others. A fixed charge may be deducted from the payout or handled separately.

For each fee, record:

• the label used by the mall;
• the rate or fixed amount;
• the sales or period to which it applies;
• the amount you expected;
• the amount reported; and
• the source that supports your expectation.

If the agreement is unclear, mark the question. Do not invent a rule to close the worksheet.

Step 4: Calculate the expected payout

Once sold items, sale amounts, and applicable fees are listed, calculate an expected payout from the records you can support.

A general worksheet structure is:

Expected payout = matched sale amounts − applicable deductions + applicable credits or adjustments

That is a structure, not a universal fee formula. Use only the deductions and credits that apply to your arrangement.

Keep expected payout separate from profit. Reconciliation asks whether sales and deductions explain the money received. Profit analysis may also include item cost, repairs, travel, supplies, overhead, and other business expenses that do not appear on the mall's payout statement.

Step 5: Compare expected payout with actual payout

Record the amount actually received from the mall, then calculate:

Variance = actual payout − expected payout

A zero variance means the listed inputs agree mathematically. It does not prove that every source record was complete.

A nonzero variance is a prompt to investigate, not proof that anyone did something wrong. Common categories to review include:

• a sale or return recorded in a different period;
• a discount or adjustment not yet entered in your records;
• a fee label or calculation you interpreted differently;
• a prior balance, credit, or carry-forward;
• a duplicate or missing entry;
• a rounding difference; or
• a payment amount that belongs to a different report period.

Write the explanation beside the variance and retain the supporting record. If you cannot explain it, leave it open with a next action and date.

Fictional example: four sales, one unexplained difference

The following figures are fictional. They illustrate the workflow and do not represent typical fees or recommended terms.

Marisol sells from Booth 27 at Riverbend Antique Mall. Her September mall report lists four sold items. Her agreement for that period shows a 10% sales commission and a fixed $175 booth charge. The report also lists one $6 service fee and no credits.

Item match

Marisol keeps the lamp's $95 list price in her item record and records $85 as the actual sale amount. She does not overwrite the original price.

Payout worksheet

The payout is $2 less than the supported calculation. Marisol does not change a sale amount or invent another fee to make the sheet balance. She records the variance, checks for a prior-period balance or separate fee note, and asks the mall to identify the line if her records do not explain it.

The outcome may be a documented fee, timing difference, correction, or an error in Marisol's own setup. Until there is evidence, it remains an unresolved $2 variance—not an accusation.

Reconciliation worksheet template

Copy this table for each reporting period:

Add an owner, due date, and next action for every open line. That keeps “look into this later” from becoming a permanent accounting category.

Keep this job separate from inventory and profit analysis

Reconciliation touches inventory and profit records, but it answers a narrower question.

• An inventory tracker tells you what you own, where it is, and what happened to each item.
• A profit calculation compares revenue with the costs included in your chosen definition.
• A sales-report reconciliation explains whether reported sales, applicable fees, and adjustments support the payout received.

Keeping those jobs separate prevents one worksheet from trying to be an inventory database, income statement, and payout audit at the same time.

For the broader item-record structure, see Antique Booth Inventory Tracker: A Practical System for Items, Costs, and Sales. For profit analysis, see How to Calculate Your Real Profit Selling at Antique Malls.

Where MaxIMS fits

A manual process works when the item, sale, fee, and payout records stay consistent. MaxIMS can keep seller-entered item records, recorded sales, selling locations, and configured location fees together. Those records can support the expected side of a payout reconciliation; the mall's report and the actual payment remain external evidence that must be compared.

This workflow does not assume statement import or parsing, bank-feed integration, automated matching, or automated decisions about which record is correct. MaxIMS does not replace accounting, tax, or legal advice. The seller remains responsible for entering accurate information, checking the applicable agreement, comparing the mall’s report and payment with their records, and investigating unresolved variance.

Review MaxIMS inventory, location, fee, and reporting features.

Close the period only when the difference is explained

Use the same sequence every time:

1. Match sold items.
2. Verify actual sale amounts.
3. Check the applicable fee setup.
4. Calculate expected payout.
5. Compare actual payout.
6. Preserve and investigate any variance.

The deposit tells you what arrived. Reconciliation tells you why.