Prebuilt Reports in SimpleConsign are standardized reports that provide fast, actionable insights into key areas of your business. These reports eliminate the need for custom configuration, offering a reliable foundation for decision-making in areas like sales, inventory, payouts, and employee performance.
Accessing Prebuilt Reports
To navigate to Prebuilt Reports:
-
Log into your SimpleConsign account and navigate to the Back Office. Please not that reporting can only be accessed through the Back Office.
-
Click on the Reports tab.
-
Click on the Report dropdown to access the prebuilt reports.
Each report can be filtered by date range and other parameters depending on the report type.
Key Definitions: Taxable and Non-Taxable Sales
-
Taxable Sales: Items with applicable taxes based on their categories.
-
Non-Taxable Sales: Revenue from tax-exempt items or portions of discounts, influenced by applied categories and coupons.
Date Based Reports
Cash Ins and Outs
Description: Displays a list of manual cash in and cash out transactions performed at terminals, typically outside regular sales. This includes deposits made into a drawer (e.g., opening funds) and cash taken out (e.g., end-of-day bank deposits or petty cash withdrawals).
Use Cases: Helpful for auditing daily drawer activity and monitoring non-sale cash flow, such as petty cash additions or cash removed for deposits.
|
Breakdown |
Description |
|
Type |
Cash In or Cash Out |
|
Date/Time |
Date and time of the transaction |
|
Amount |
Value of the transaction |
|
Notes |
Reason or context for the entry |
|
Employee |
Who processed the transaction |
Consignor Monthly Fee
Description: The Consignor Monthly Fee report displays recurring fees issued to consignors, typically for rent. It lists each consignor’s ID, name, charged fee, and current account balance including unpaid or negative balances.
Use Cases: This report is ideal for shops that operate on a fee-based consignment model. It helps in tracking which consignors owe monthly dues, monitoring revenue from fees, and ensuring fees are not overlooked during payout processes.
|
Breakdown |
Description |
|
Date |
Date the fee was applied to the consignor's account |
|
Consignor ID |
Unique ID for each consignor |
|
First Name |
Consignor's first name |
|
Last Name |
Consignor's last name |
|
Fee Description |
Consignor's last name |
|
Fee Amount |
Fee amount charged monthly |
|
Current Account Balance |
Balance due or credit |
Consignor Negative Balance
Description: Lists consignors with an outstanding balance owed to the store up to the specified date.
Use Cases: Used by stores that charge fees or make deductions from consignor accounts, this report flags balances below zero so you can follow up or restrict payout actions.
|
Breakdown |
Description |
|
Consignor Name |
Full name of the consignor |
|
Consignor ID |
Unique ID for each consignor |
|
Contact Info |
Contact information such as phone or email |
|
Created Date |
Date the account entry was created |
|
Payment Date |
Date of the last payment on the account |
|
Description |
Reason or context for the charge or balance |
|
Amount |
Value of the outstanding negative balance |
Consignor Payout Totals
Description: Shows total payouts made to each consignor within the selected date range.
Use Cases: Use this report to audit total consignor disbursements over time, reconcile payout totals, or track top-earning consignors.
|
Breakdown |
Description |
|
Consignor ID |
Unique ID for each consignor |
|
First Name |
Consignor's first name |
|
Last Name |
Consignor's last name |
|
Street |
Consignor's street address |
|
City |
City of residence |
|
State |
State of residence |
|
Zip |
Postal code |
|
Phone 1 |
Primary phone number |
|
Phone 2 |
Secondary phone number (if applicable) |
|
Total Balance |
Current account balance including sales and fees |
|
Consignor Access Fees |
Fees associated with consignor portal access |
|
Online Transaction Fees |
Fees from online sales activity |
|
Check Fees |
Fees deducted for check payouts |
|
SimpleACH Fees |
Fees deducted for ACH transfers |
|
CC Proc. Fees |
Fees deducted for credit card processing |
|
Monthly Fees |
Monthly service or participation fees |
|
Store Credit Paid |
Store credit used to pay consignors |
|
Additional Store Credit |
Any bonus store credit granted |
|
Total Paid |
Total payout amount issued to the consignor |
|
Total Tax Collected |
Tax collected from the consignor's sales |
Consignor Sales
Description: The Consignor Sales report itemizes each consignor's sales during a defined date range, including details such as product names, sale dates, quantities, pricing, discounts, and tax classifications. It provides a full breakdown of taxable and non-taxable sales, making it a reliable tool for both payout calculation and tax reporting.
Use Cases: Used to generate detailed sales statements for consignors, this report supports payout accuracy, dispute resolution, and sales performance analysis. It helps consignors and store managers track individual item movement, validate commissions or splits, and review historical sales activity.
|Breakdown|Description| |---|---| |Consignor Name|Full name of the consignor| |Consignor ID|Unique identifier for the consignor| |Sales Total|Total dollar value of all sales within the date range| |Taxable Sales Total|Value of sales subject to tax| |Non-Taxable Sales Total|Value of sales not subject to tax| |Buyer's Fee Total|Amount collected as buyer’s fees (if applicable)| |Sales Tax Total|Total sales tax collected on the consignor's items| |Sold Date|Date when the item was sold| |Item Name|Name or description of the sold item| |Price|Price per unit of the item sold| |Quantity|Number of items sold in the transaction| |Subtotal|Total sale amount before discounts and tax| |Discounted?|Indicator if a discount was applied to the item|
Additional Context on Taxable and Non-Taxable Sales
-
Taxable Sales Total: Represents revenue generated from items or transactions subject to tax based on their category.
-
Non-Taxable Sales Total: Includes revenue from items categorized as tax-exempt or discounts/coupons that reduce the taxable amount. Adjustments are influenced by specific item classifications and applied discounts.
Consignor Account History By Consignor
Description: The Consignor Account Entry History By Consignor report provides a line-by-line breakdown of all account entries made for each consignor. This includes fees, sales proceeds, payouts, and manual adjustments. Each entry is dated and categorized, helping staff and consignors understand how account balances have changed over time.
Use Cases: This report is vital for reviewing account-level financial histories, resolving disputes, and explaining deductions or payouts. It supports transparent communication with consignors and thorough internal audits.
|
Breakdown |
Description |
|
Consignor Name |
Full name of the consignor |
|
Consignor ID |
Unique identifier for the consignor |
|
Entry Date |
Date the entry was made into the consignor’s account |
|
Description |
Description of the entry |
|
Amount |
Amount debited or credited |
|
Status |
Current status of the entry and the employee you initiated it. |
|
Expire Date |
Date when the entry (such as a fee or store credit) will expire if applicable |
Consignor Account History By Employee
Description: The Consignor Account Entry History by Employee report provides a line-by-line breakdown of all account entries made by each employee per consignor.
Use Cases: Used to audit employee behavior and understand how employee actions impact consignor accounts.
|
Breakdown |
Description |
|
Consignor Name |
Full name of the consignor |
|
Consignor ID |
Unique identifier for the consignor |
|
Entry Date |
Date the entry was made into the consignor’s account |
|
Description |
Description of the entry |
|
Amount |
Amount debited or credited |
|
Status |
Current status of the entry and the employee you initiated it. |
|
Expire Date |
Date when the entry (such as a fee or store credit) will expire if applicable |
Employee Sales Report
Description: The Employee Sales Report details sales activity per employee, highlighting store-owned, consigned, and service sales. It breaks down total performance for each staff member over the selected time period.
Use Cases: Great for evaluating employee productivity, calculating commissions, and identifying top-performing staff. This report also helps in tracking training needs and maintaining accountability for sales behavior.
|
Breakdown |
Description |
|
Employee Name |
Staff member responsible for sale |
|
Store Inventory Sales |
Revenue from store-owned items |
|
Consignment Sales |
Revenue from consigned goods |
|
Service Sales |
Revenue from service items |
|
Total Sales |
Combined revenue from all sources |
Expiring Items Report
Description: Displays inventory items nearing or past their expiration/expiry date if tracked, often based on consignor contract length or preset time limits. Can be grouped by consignor or category.
Use Cases: Used to identify inventory that should be discounted, returned, or removed from the sales floor.
By Consignor:
|
Breakdown |
Description |
|
Consignor |
Name of the consignor who owns the item |
|
Barcode/SKU |
Unique identifier assigned to the item |
|
Item |
Name or short description of the product |
|
Start |
Date the item was first listed or became active |
|
Expires |
Scheduled expiration date for the item |
|
Status |
Current availability or sales status of the item |
|
Retail |
Retail price of the item as listed in inventory |
|
Quantity |
Number of units available in stock |
By Category:
|
Breakdown |
Description |
|
Category |
Classification of the item (e.g., Clothing, Furniture) |
|
Barcode/SKU |
Unique identifier assigned to the item |
|
Consignor |
Name of the consignor who owns the item |
|
Item |
Name or short description of the product |
|
Start |
Date the item was first listed or became active |
|
Expires |
Scheduled expiration date for the item |
|
Status |
Current availability or sales status of the item |
|
Retail |
Retail price of the item as listed in inventory |
|
Quantity |
Number of units available in stock |
Gift Card Balances
Description: The Gift Card Balances report provides a comprehensive view of all issued gift cards within the system, showing each card's barcode, usage details, and current balance. This report is valuable for financial tracking and audit preparation, especially to identify unused or partially used cards that remain on the books as liabilities.
Use Cases: This report is used during financial audits, customer support cases, and routine accounting. It helps monitor outstanding liabilities and can be referenced when validating gift card usage or resolving disputes.
|
Breakdown |
Description |
|
Purchase Date |
Date the gift card was purchased |
|
Barcode |
Unique code identifying gift card and the usage details |
|
Description |
Type of card |
|
Current Balance |
Current value remaining on the gift card |
Hourly Sales Report
Description: The Hourly Sales Report presents sales performance broken down by hour of the day and by day of week and hour for a specified date. It includes total revenue and number of transactions in each hourly segment, providing insight into customer traffic patterns.
Use Cases: This report is valuable for scheduling decisions, identifying peak selling hours, and optimizing staffing and promotional activities based on foot traffic and revenue distribution throughout the day.
|
Breakdown |
Description |
|
Number of Sales |
Count of transactions within the hour |
|
Sales Total |
Revenue generated per hour |
Inventory Adjustments
Description: The Inventory Adjustments report captures all changes made to inventory records during a selected timeframe. This includes items added to stock, updated product details, or changes in pricing and quantities. It serves as a transparent log of inventory edits, making it an essential tool for maintaining accuracy and preventing unauthorized changes.
Use Cases: Ideal for auditing and inventory control, this report helps management detect unusual activity, ensure consistent inventory practices, and maintain an accurate reflection of stock levels and item details across the business.
|
Breakdown |
Description |
|
Date |
Date the inventory update was made |
|
Type |
Nature of update (e.g., new entry, adjustment, restock, etc.) |
|
Batch # |
Grouping identifier for bulk adjustments |
|
Employee |
Staff member who made the adjustment |
|
Category |
Item category (e.g., Dresses, Hats) |
|
Name |
Name of the item updated |
|
Description |
Short description or notes about the update |
|
Quantity |
Number of units added or removed |
|
Cost |
Item cost used for accounting purposes |
|
Retail |
Retail price of the item post-update |
|
New/Used |
Condition of the item (new or used) |
|
SKU |
Stock Keeping Unit or barcode identifier |
Inventory by Category
Description: The Inventory by Category report provides a snapshot of current inventory levels, grouped by category. It details the number of items owned by the store versus consigned items, along with the associated total cost per category.
Use Cases: Ideal for inventory planning, purchasing, and reporting, this report helps stores evaluate their current stock distribution, monitor category saturation, and ensure balanced merchandising across inventory types.
|
Breakdown |
Description |
|
Category |
Inventory classification or grouping (e.g., Shoes, Furniture) |
|
Total Quantity |
Combined number of items in each category |
|
Consigned - Used |
Quantity of used consigned items in stock |
|
Consigned - New |
Quantity of new consigned items in stock |
|
Store Inventory - Used |
Quantity of used items owned by the store in stock |
|
Store Inventory - New |
Quantity of new items owned by the store in stock |
|
Total Cost |
Total cost of goods for all items in the category |
Money Transfer Report
Description: The Money Transfer Report tracks funds that are moved between store locations, accounts, or registers using consignor balances and store credit. This includes scenarios where a customer uses store credit from one location to purchase items at another, or when money is reallocated internally between registers or departments.
Use Cases: Useful for auditing internal fund movements or verifying cash flow between sites.
|
Breakdown |
Description |
|
From Location |
The originating store or register where the funds were deducted |
|
Consignor Balance In |
Amount of consignor balance received at this location |
|
Consignor Balance Out |
Amount of consignor balance used or transferred from this location |
|
Net Consignor Balance Transferred |
Net total of consignor balance moved (In - Out) |
|
Store Credit In |
Store credit received at this location |
|
Store Credit Out |
Store credit used or transferred from this location |
|
Net Store Credit Transferred |
Net total of store credit moved (In - Out) |
|
Reward Points In |
Reward points received at this location |
|
Reward Points Out |
Reward points used or transferred from this location |
|
Net Reward Points Transferred |
Net total of reward points moved (In - Out) |
Online Sales Report
Description: The Online Sales Report tracks transactions processed via SimpleConsign’s integrated e-commerce channels. It captures key metrics including item names, sales totals, number of transactions, and taxes collected. However, it should be noted that this report is primarily intended for quick reference.
Due to how data is submitted from external e-commerce platforms, the transaction totals shown may differ from the sum of individual items. These totals are displayed exactly as they were received by SimpleConsign and may include tax or reflect discrepancies caused by incorrect submission formatting.
Use Cases: This report supports performance monitoring of online operations, comparing e-commerce success to in-store metrics. It’s particularly useful for reconciling online revenue with inventory and financial systems.
|
Breakdown |
Description |
|
Sales Totals |
Combined revenue from all online transactions |
|
Return Totals |
Total value of items returned through online channels |
|
Itemized Details of Sales |
Breakdown of individual items sold online |
|
Order/Receipt Number |
Unique transaction identifier submitted via API |
|
Type of Transaction |
Indicates whether the transaction is a Sale or Return |
|
SKU |
Stock Keeping Unit associated with the item sold |
|
Item Name |
Product name as listed at the time of sale |
|
Split % Consignor Amount |
Revenue share amount owed to the consignor based on agreed split |
|
Cost |
Store's cost for the sold item |
|
Memo Price |
Adjusted or promotional price of item (if used) |
|
Buyer's Fee |
Additional fee charged to the buyer, often as a platform service fee |
|
Item Fee |
Extra fee deducted per item sold (e.g., handling fee) |
|
Online Transaction Fee |
Fee associated with processing the online transaction |
|
Sold Price |
Final selling price before tax and fees |
|
Quantity |
Number of units sold for each item |
|
Total Price |
Final transaction value including tax and all applicable fees |
Outstanding Balances by Day
Description: Displays a daily summary of customer accounts with unpaid balances (e.g., layaways or store credit owed).
Use Cases: Useful for tracking outstanding liabilities owed by customers, helping staff follow up on due payments.
|
Breakdown |
Description |
|
Date |
Date on which the balance snapshot was recorded |
|
Store Credit |
Total store credit available across all accounts on that date |
|
Consignor Payout Balance |
Total payouts due to consignors not yet paid out |
|
Consignor Total Balance |
Overall balance owed to all consignors (including pending sales, credits, and fees) |
Payout Activity
Description: The Payout Activity report captures all consignor payments made over a selected period. It lists each payout transaction along with relevant details like the date, payout type, consignor information, and payout amount. This creates a reliable audit trail for all consignor disbursements.
Use Cases: Used for payment verification, audit reviews, and reconciliation, this report helps ensure all consignors are paid accurately and timely. It is particularly valuable for resolving payout disputes and tracking financial obligations to consignors.
|
Breakdown |
Description |
|
Total Payouts |
Total amount paid out across all consignors during the selected timeframe |
|
Cash Payout Total |
Total amount paid using cash |
|
Check Payout Total |
Total amount paid via check |
|
SimpleACH Payout Total |
Total amount transferred via SimpleACH |
|
Store Credit Payout Total |
Total amount paid using store credit |
|
Date |
Payout date |
|
Consignor |
Name of the consignor who received the payout |
|
Payout Note |
Notes or memos attached to the payout transaction |
|
Amount |
Specific amount paid in the transaction |
Sales by Category
Description: The Sales by Category report offers a structured view of product performance by grouping sales according to predefined categories. It includes critical metrics such as item count, cost of goods sold (COGS), gross sales, margins, and the mix of new versus used inventory.
Use Cases: This report is commonly used to identify top-performing product categories, spot underperforming segments, and guide merchandising or promotional strategies. It's invaluable for retail strategy planning and inventory investment decisions.
|
Breakdown |
Description |
|
Store Owned vs Consignment Inventory |
Indicates whether items sold were owned by the store or provided on consignment |
|
Category |
Classification of items sold (e.g., Apparel, Electronics) |
|
Number of Items |
Total count of items sold in the given category |
|
COGS (Store-Owned Items) |
Cost of Goods Sold – the store’s expense to acquire the items sold |
|
Consignor Payment (Consigned Items) |
Amount paid to the consignor for the item sold |
|
Sales |
Total gross sales revenue generated for the category |
|
Gross Margin % |
Profit margin calculated as (Sales - COGS) / Sales, shown as a percentage |
Sales Report
Description: The Sales Report provides a detailed overview of all sales activity over a selected period. It captures both taxable and non-taxable transactions, sales splits between store and consignors, total revenue, number of items sold, and various operational metrics. Additionally, it includes financial insights such as sales tax collected, layaway payments, average sale value, and cost of goods sold (COGS). This report serves as a foundational financial tool for daily reconciliation, performance tracking, and long-term planning.
Additional Insights on Non-Taxable Sales:
Non-taxable sales encompass items or discounts exempt from tax calculation. Their values are influenced by the interplay between taxable item categories, the applied discounts, and coupon credits. This distinction is crucial for accurate revenue reporting and compliance with tax regulations.
Use Cases: This report is ideal for a variety of business functions. It supports daily close-out processes by verifying totals for sales, payouts, and taxes collected. For monthly and year-end reporting, it provides insights into store-owned versus consignment performance and facilitates tax preparation. Managers and owners can also use it for performance reviews, examining trends in average sale value, item counts, and transaction activity. Finally, it is a valuable resource during audit preparation, offering a clear, itemized view of financial and operational data.
|Breakdown|Description| |---|---| |Taxable Sales|Total value of items sold that were subject to sales tax| |Non-Taxable Sales|Total value of items sold that were tax-exempt| |Sales Tax|Total amount of tax collected from taxable sales| |Sales Total|Grand total of all sales, including taxable and non-taxable items| |Store Item Sales|Revenue from sales of store-owned inventory| |Consign Item Sales|Revenue from sales of consigned inventory| |Coupon & Rewards Points|Discounts or value redeemed via coupons or loyalty points| |Cost of Goods Sold|Total cost to the store for the goods that were sold| |Consignor CC Processing Fees|Credit card processing fees charged to consignors (This is not the same as surcharge. See here.)| |Item Fees|Any fees applied per item sold (e.g., listing fees)| |Buyer's Fees|Fees charged to buyers on purchases (e.g., service or handling fees)|
Non-Taxable Sales Calculation:
Non-taxable sales can be determined using the formula: Coupons − (Store Item Sales + Consign Item Sales). This calculation explains how discounts and sales align to form these amounts, essential for accurate financial assessments.
Sold Not in System
Description: The Sold Not in System report identifies items that were sold despite not being properly added to inventory beforehand—either because their quantity was zero or they were added at the point of sale. These situations suggest procedural gaps and represent potential stock tracking issues.
Use Cases: Use this report to catch process inconsistencies, flag items that may need to be properly entered into inventory, and ensure all sales are linked to legitimate stock. It’s particularly useful for shops with multiple employees or high-volume point-of-sale scenarios.
|
Breakdown |
Description |
|
Date |
Date the item was sold |
|
Type |
System classification (e.g., sell) |
|
Category |
Category classification for the item (e.g., Books, Hats) |
|
Name |
Name of the item sold |
|
Description |
Item description |
|
Cost |
Store’s internal cost for the item, if available |
|
Price |
Sale price charged to the customer |
|
New/Used |
Condition of the item (new or used) |
|
Employee |
Staff member who processed the sale |
|
Invoice |
Invoice number tied to the transaction |
End of Day Reports
End of Day
Description: The End of Day report provides a summary of all financial activity between End of Day processes, including sales, payouts, drawer balances, and inventory updates. It calculates beginning and ending balances by tracking total income and expenses, highlighting any discrepancies as Over/Short. Additional sections cover inventory cost changes, retail values, and consignor payouts, offering a comprehensive daily financial overview.
Use Cases: This report is essential for end-of-shift reconciliation, cash accountability, and day-to-day operational oversight. Managers use it to investigate over/short issues, audit inventory changes, and ensure payouts and cash handling align with expected outcomes.
Cash Flow
|
Breakdown |
Description |
|
Beginning Balance |
Total starting balance across all cash drawers at the start of the End of Day period |
|
Sales |
Total revenue from item sales |
|
Gift Card Sales |
Revenue from sold gift cards |
|
Services |
Income from service-based transactions |
|
Store Credit In |
Store credit used by customers for purchases |
|
Gift Card Payments |
Gift card redemptions used to pay for items |
|
Cash In |
Manual cash added to drawers during the day |
|
Check In |
Check payments manually added to drawers |
|
Credit In |
Credit card payments manually added to drawers |
|
Layaway Payments |
Payments applied toward active layaways |
|
Layaway Payoffs |
Full payments made to close layaways |
|
Total In |
Sum of all incoming cash and equivalent value |
|
Returns (Sales Tax Included) |
Total value of item returns including sales tax |
|
Layaway Refunds |
Money returned for canceled layaways |
|
Store Credit Returns |
Store credit returned from canceled purchases |
|
Gift Card Returns |
Gift card amounts refunded to customers |
|
Check Returns |
Checks returned to customers or voided |
|
Total Buys |
Total value paid out for purchased inventory |
|
Check Buys |
Total value of inventory purchased via check |
|
Store Credit Buys |
Value of inventory purchased using store credit |
|
Cash Out |
Cash removed from drawers for payouts or deposits |
|
Total Out |
Sum of all cash outflows or deductions |
|
Ending Balance |
Net drawer balance at close (Total In − Total Out) |
|
Over/Short |
Difference between expected and counted drawer totals |
Drawer Counts
|
Breakdown |
Description |
|
Cash, Check, MC, VISA, AMEX, DISC, Debit |
Expected and actual counted values for each tender type |
|
Total |
Total expected and actual value across all tender types |
|
Beginning Cash |
Starting cash value for each drawer |
|
Cash Deposit, Check Deposit, Credit Card Deposit |
Amounts deposited during closing for each type |
Inventory Summary
|
Breakdown |
Description |
|
Starting Inventory Cost |
Inventory value at the beginning of the reporting period |
|
Inv Adjustments |
System-calculated inventory changes (e.g., markdowns) |
|
Manual Cost Adjustments |
Staff-entered changes to item cost |
|
Inv Added From Customers |
Inventory received from consignors or sellers |
|
Inv Added From Returns |
Inventory restocked from returns |
|
Inv Transferred In/Out |
Inventory moved between locations |
|
Less Deletions |
Value of inventory deleted from the system |
|
Ending Inventory Cost |
Final value of all on-hand inventory at period close |
|
Current Inv Retail |
Retail value of all store-owned inventory |
|
Current Consign Inv Retail |
Retail value of all consignor-owned inventory |
|
Pending Inv Cost Transferring Out |
Cost of inventory in transfer between locations |
|
Inv Cost Returned From Transfers |
Cost of inventory returned from inter-store transfers |
Consignor Payouts
|
Breakdown |
Description |
|
Cash |
Total consignor payouts made in cash |
|
Check |
Total consignor payouts made via check |
|
SimpleACH |
Total consignor payouts sent via ACH |
|
Store Credit |
Total consignor payouts issued as store credit |
Terminal
Description: The Terminal report isolates End of Day activity by terminal, detailing cash entries and withdrawals, voided transactions, and discrepancies at each point of sale. It mimics the structure of the EOD report but provides data at the register level for deeper insight. See the above table for more detials.
Use Cases: This report helps identify which terminals may be contributing to cash handling errors or variances. It's also useful for monitoring employee behavior, verifying void activity, and auditing station-specific performance.
Transaction
Description: The Transaction report tracks all customer-facing actions during each End of Day period, including purchases, returns, layaway payments, and voids. It focuses exclusively on sales-related activity and excludes backend processes like payouts.
Use Cases: Use this report to review individual transactions, investigate discrepancies, or audit customer interactions. It’s also a useful tool for sales tracking, identifying patterns in transaction types, and improving checkout practices.
|
Breakdown |
Description |
|
Terminal |
Name of the terminal used for the transaction |
|
Invoice |
Unique identifier for each transaction |
|
Type |
Type of transaction (e.g., Sell, Sell/Service) |
|
Employee |
Employee who processed the transaction |
|
Sales |
Total sales amount excluding tax |
|
Buys |
Value of items bought from customers in the transaction |
|
Tax |
Total tax collected on the transaction |
|
CC Surcharge |
Credit card surcharge fee on the transaction |
|
Total |
Combined amount including sales and tax |
|
Payment Total |
Total amount paid by the customer |
|
Store Cr |
Amount paid using store credit |
|
Gift Card |
Amount paid using a gift card |
|
Check |
Amount paid using a check |
|
MC |
Amount paid using MasterCard |
|
VISA |
Amount paid using VISA |
|
AMEX |
Amount paid using American Express |
|
DISC |
Amount paid using Discover |
|
Debit |
Amount paid using a debit card |
|
Cash |
Amount paid in cash |
|
Square |
Amount processed via Square payment system (if applicable) |
End of Month
Description: The End of Month report aggregates financial data across a specified range of dates, offering a cumulative view similar to the End of Day report but over a longer timeframe. It summarizes total sales, payouts, inventory changes, and drawer activity.
Use Cases: Ideal for monthly closings and strategic planning, this report enables financial reconciliation and helps businesses analyze performance trends across weeks or months. It’s particularly useful for preparing statements for stakeholders or internal reviews.
Cash Flow
|
Breakdown |
Description |
|
Beginning Balance |
Total starting balance across all cash drawers at the start of the End of Day period |
|
Sales |
Total revenue from item sales |
|
Gift Card Sales |
Revenue from sold gift cards |
|
Services |
Income from service-based transactions |
|
Store Credit In |
Store credit used by customers for purchases |
|
Gift Card Payments |
Gift card redemptions used to pay for items |
|
Cash In |
Manual cash added to drawers during the day |
|
Check In |
Check payments manually added to drawers |
|
Credit In |
Credit card payments manually added to drawers |
|
Layaway Payments |
Payments applied toward active layaways |
|
Layaway Payoffs |
Full payments made to close layaways |
|
Total In |
Sum of all incoming cash and equivalent value |
|
Returns (Sales Tax Included) |
Total value of item returns including sales tax |
|
Layaway Refunds |
Money returned for canceled layaways |
|
Store Credit Returns |
Store credit returned from canceled purchases |
|
Gift Card Returns |
Gift card amounts refunded to customers |
|
Check Returns |
Checks returned to customers or voided |
|
Total Buys |
Total value paid out for purchased inventory |
|
Check Buys |
Total value of inventory purchased via check |
|
Store Credit Buys |
Value of inventory purchased using store credit |
|
Cash Out |
Cash removed from drawers for payouts or deposits |
|
Total Out |
Sum of all cash outflows or deductions |
|
Ending Balance |
Net drawer balance at close (Total In − Total Out) |
|
Over/Short |
Difference between expected and counted drawer totals |
Drawer Counts
|
Breakdown |
Description |
|
Cash, Check, MC, VISA, AMEX, DISC, Debit |
Expected and actual counted values for each tender type |
|
Total |
Total expected and actual value across all tender types |
|
Beginning Cash |
Starting cash value for each drawer |
|
Cash Deposit, Check Deposit, Credit Card Deposit |
Amounts deposited during closing for each type |
Inventory Summary
|
Breakdown |
Description |
|
Starting Inventory Cost |
Inventory value at the beginning of the reporting period |
|
Inv Adjustments |
System-calculated inventory changes (e.g., markdowns) |
|
Manual Cost Adjustments |
Staff-entered changes to item cost |
|
Inv Added From Customers |
Inventory received from consignors or sellers |
|
Inv Added From Returns |
Inventory restocked from returns |
|
Inv Transferred In/Out |
Inventory moved between locations |
|
Less Deletions |
Value of inventory deleted from the system |
|
Ending Inventory Cost |
Final value of all on-hand inventory at period close |
|
Current Inv Retail |
Retail value of all store-owned inventory |
|
Current Consign Inv Retail |
Retail value of all consignor-owned inventory |
|
Pending Inv Cost Transferring Out |
Cost of inventory in transfer between locations |
|
Inv Cost Returned From Transfers |
Cost of inventory returned from inter-store transfers |
Consignor Payouts
|
Breakdown |
Description |
|
Cash |
Total consignor payouts made in cash |
|
Check |
Total consignor payouts made via check |
|
SimpleACH |
Total consignor payouts sent via ACH |
|
Store Credit |
Total consignor payouts issued as store credit |
Layaway
Description: The Layaway Report lists all layaway transactions initiated, completed, or canceled within a selected time period. It includes status indicators and payment progress.
Use Cases: Great for tracking deferred revenue, understanding cash flow timing, and following up with customers who have active or overdue layaways.
|
Breakdown |
Description |
|
Customer Name |
Name of customer with layaway |
|
Date Opened |
When the layaway was created |
|
Status |
Current layaway status (active, paid, canceled) |
|
Total Due |
Amount owed |
|
Total Paid |
Amount paid to date |
Terminal Payments
Description: Shows all payments processed through each terminal during the End of Day period, broken down by type (cash, credit, etc.).
Use Cases: Used to reconcile terminal-level totals with drawer counts, track payment method trends, and verify processing consistency across shifts.
|
Breakdown |
Description |
|
Time |
Timestamp of when the payment was processed |
|
Payment Type |
Type and source of payment, including masked card numbers (e.g., AMEX xxxxxxxx1009) or methods like store credit |
|
Amount |
Value of the individual payment processed |
|
Source |
Origin of the payment (typically labeled as 'Transaction') |
|
Employee |
Employee who processed the payment |
Company-Wide Reports
Consignor Negative Balance Summary
Description: The Consignor Negative Balance Summary report aggregates all consignors with outstanding negative balances into a single view. It simplifies the process of monitoring financial liability at a store-wide level by consolidating individual account deficits.
Use Cases: Useful for store owners or finance managers needing to track total liability and identify trends in unpaid fees or overdrawn consignor accounts. Helps prioritize follow-ups or adjust account policies.
|
Breakdown |
Description |
|
Location |
Store location associated with the consignor account |
|
Consignor |
Internal consignor ID or code |
|
First Name |
First name of the consignor |
|
Last Name |
Last name of the consignor |
|
|
Email address on file for the consignor |
|
Street |
Street portion of the consignor’s address |
|
State |
State where the consignor resides |
|
Zip |
ZIP or postal code of the consignor's address |
|
Outstanding Balance |
Current negative balance amount owed |
|
Last Activity Date |
Most recent date of account activity (e.g., sale, payment) |
Additional Prebuilt Report Resources
Webinar Recording: Mastering Prebuilt Reports
Discover the power of Prebuilt Reports in SimpleConsign with insights from the SimpleConsign Team.
In this session, you’ll learn how to easily access essential business insights, track sales performance, manage consignor payouts, and take advantage of valuable features like Store Insights. See practical demonstrations and explore how these tools can help you optimize your store’s performance — all without the need for additional setup.
What If Prebuilt Reports Aren't Enough?
Custom Reports allow you to create tailored data views to suit specific business needs that aren’t covered by SimpleConsign’s standard Prebuilt Reports. Using the Custom Reports tool, users can select fields, apply filters, and export results that meet their unique requirements.
When to Use Custom Reports: If the information you need cannot be found in a single Prebuilt Report or if you need a custom layout, filtering, or grouping of data across multiple record types (e.g., inventory + sales + customer data), Custom Reports are the way to go.
Prebuilt vs. Custom Reports Comparison
|
Feature |
Prebuilt Reports |
Custom Reports |
|
Ready-to-use |
✅ |
❌ (requires setup) |
|
Standard layouts |
✅ |
❌ (customizable) |
|
Filter by fields |
Limited |
✅ Extensive filtering |
|
Cross-category data |
❌ |
✅ |
|
Export flexibility |
✅ |
✅ |
|
Use case flexibility |
Moderate |
High |
Example Custom Report Use Cases
-
Non-Taxable Sales Report: Monitor sales made without tax to identify exemption trends or compliance issues.
-
Consignor Aged Balances: Show all consignors with unpaid balances grouped by how long the balance has been outstanding.
-
Gift Card Transactions Report: Track all gift card sales, redemptions, and remaining balances over a specific period.
To learn how to build and use Custom Reports, visit our Custom Reports Overview.