Antique Mall Statement & Payout Checker for Google Sheets & Excel
Check every mall statement against your own records · by Unelify
$29USD · one-time payment
Buy nowInstant download after payment. You get a PDF with your Google Sheets links (a blank copy and an example) and the Excel files. A free Google account is enough.
- Instant digital download, nothing is shipped
- Works in Google Sheets and Microsoft Excel
- Each month, for each mall: what it should pay you, worked out from your sale lines and its terms, next to what its statement says
- Type each line of the mall's sales report: the item fills in from its tag, and each line is checked (a discount over what you allow, a tag that is not yours, more pieces than you had)
- A printable check with polite questions for the mall office
- Your terms for each mall, month by month: commission, rent, card fees, monthly fees and tax on fees
- Every payment with the statement it is for; what a mall still owes you carries to the next month
- A printable count sheet of what should be in your booth
- Your year at a glance, with your booth profit after fees, rent and the cost of what sold
- Up to 5 malls, 4 color sets and your own words for the labels
- Made to work on a phone too
Know if the mall paid you right
Type your items, your terms for each mall and each line of the mall's monthly sales report. Month then shows, for every mall, what it should pay you next to what its statement says, and whether they match. When they differ, Check turns each difference into a polite question you can print and take to the mall office: a fee that is too high, a sale below the discount you allow, an item that is no longer in your booth. Type each payment with the statement it is for, and anything still owed carries into the next month.
How it works
- Set it upOn Settings: your name or business, currency and colors. In Google Sheets, first set your Locale (country) and Time zone (File > Settings), before typing dates.
- Add your malls and their termsEach mall with its booth, your dealer # and balance at start, then its terms: commission %, rent and how it is taken, card fee, monthly fees and tax on fees.
- List your itemsTag #, item and price per piece, then the mall, your cost, the pieces and the date in.
- Type each month's reportOn Sales, enter each line of the mall's sales report. For a Return or Refund, type the amount as positive and choose its Type; the file makes it reduce sales. On Statements, enter the statement and each payment, with the statement it is for.
- Check itMonth shows Should pay and Mall says for each mall. Check prints the questions for the mall. Count Sheet lists what should be in your booth.
What's inside
Pick a month: each mall's Should pay, Mall says and result, your sales, booth profit and open questions.
A printable page for one mall and month: should be against the statement, line by line, and polite questions for the office.
Up to 3,000 lines from the malls' sales reports: sales, returns and refunds, with a tag look-up and a check on every line.
Up to 600 rows: each statement with its total and figures, payments and adjustments, and the balance carried forward.
Up to 3,000 tags: price, cost, pieces, date in, pieces taken home, missing or broken, and how many are still in the booth.
A printable list of what should be in your booth at one mall, 30 tags per page, with a Counted column to fill in.
Month by month for all malls or one: sales, fees, rent, cost of pieces sold and booth profit.
Up to 5 malls and their terms from any month, your name, currency, colors and your own words.
Questions
Does it connect to the mall's system?
No. You type each line of the mall's sales report and its monthly statement. The file checks them against your own items and the terms you typed.
Will it find a sale the mall left off its report?
Not by itself. Lines copied from the mall's report can match and still miss a sale. Print the Count Sheet and count the pieces in your booth. If something is missing, record it on Items as Missing, with the date and number of pieces. Check then makes it a question you can take to the mall. A missing item is not proof that it sold.
My mall changed its rent or commission. What do I do?
Add a new terms row for that mall from the month the change starts. Earlier months keep their old terms, so their results do not change.
How are card fees handled?
The way your mall charges them: on all sales, on the card sales its statement shows, or on your lines marked Card. You set it in the mall's terms, with how card fees on returns are treated.
Does it calculate sales tax?
No. Type amounts exactly as the mall's report shows them; the file does not add or remove sales tax. If a mall adds GST or HST to its fees, set Tax on fees in its terms. The file does the math with your own figures and is not tax, legal or accounting advice.
What is booth profit?
Your sales minus the mall's fees, the month's rent, the cost of the pieces sold and stock losses at cost. It says Incomplete while a cost is missing.
Do I need Microsoft Excel?
No. Google Sheets is free with a Google account; on a phone, use the free Google Sheets app. If you prefer Excel, the Excel files are included too: a blank file and an example.
How do I get my copy in Google Sheets?
Open the PDF you download and tap a button: a blank copy or an example. Then tap "Use template". A copy is saved in your own Google Drive.
Which currencies can I use?
Pick one from the list on Settings or type your own currency sign. One currency per file; amounts show 2 decimals, and there is no exchange-rate conversion.
How do Check and the Count Sheet print?
On Letter or A4, one page per part (6 questions or 30 tags). In Excel, use File > Print. In Google Sheets, the line above the page names the cells to print. Save each Check as a PDF too.
What happens when the file is full?
It has room for 5 malls, 3,000 items, 3,000 sale lines, 600 Statements rows in total (up to 240 monthly statements, with the remaining rows for payments and adjustments), and 48 months. Then start a new copy with your unsold items, their dates and the pieces still in each booth, and type each mall's balance at start. Keep the previous file as your archive.