Prebuilt Reports Overview

Have more questions? Submit a request

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:

  1. Log into your SimpleConsign account and navigate to the Back Office. Please not that reporting can only be accessed through the Back Office.

  2. Click on the Reports tab.

  3. 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.

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

 

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.

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)
Credit Card Surcharge Extra fee added for purchases made with a credit card
Monthly Fees Any recurring monthly fees charged to consignors or customers
Check Fees Fees associated with issuing checks
SimpleACH Fees Fees charged for ACH payment transactions via SimpleACH
SimpleACH Facilitator Fees Platform fees for facilitating ACH payments
SimpleACH Bank Withdrawal Total Total amount withdrawn from bank accounts via SimpleACH
Consignor Access Fees Fees charged for consignor account access or use
Layaway Payments Payments received for items placed on layaway
Layaway Refunds Amounts refunded for canceled or returned layaway purchases
Layaway Payoffs Full payment completions of layaway items
Forfeited Layaway Payments Layaway payments retained when layaway terms are not fulfilled
Consignor Payments Total amount paid out to consignors
Consignor Payins Amounts deposited by consignors into their account
Store Split Portion of sales revenue retained by the store
Consignor Split Portion of sales revenue due to consignors
Service Total Total revenue from services (e.g., fees, layaway charges)
Number of Sales Total number of completed sales transactions
Number of Returns Total number of returned sales
Number of Items Sold Total number of individual items sold
Avg. Sale ($) Average dollar amount per sale transaction
Voided Sales Number and value of sales that were voided
Total Buys Total value of items bought directly from customers
Number of Buys Number of buy transactions completed
Number of Items Bought Total quantity of items acquired through buy transactions
Avg. Buy ($) Average dollar amount per buy transaction
Voided Buys Number and value of buy transactions that were voided
Number of Payouts Count of payment transactions made to consignors
Number of Payins Count of deposit transactions made by consignors
Sales Month-to-Date Sales revenue recorded so far in the current month
Sales Year-to-Date Cumulative sales revenue recorded in the current calendar year
Sales Tax Breakdown Detailed summary of tax collected by jurisdiction, including rate and total

 

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 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.

Articles in this section

Was this article helpful?
0 out of 0 found this helpful