Below are examples of some basic reports you can create in Springboard Retail for your accountant or bookkeeper for booking journal entries, preparing reconciliations, etc. Remember that you can run and save these reports for any time period you'd like. You can also add custom fields and report on those custom fields, under groups, to enhance the reports with more information.

(1) Monthly Sales (Sales to Payment Reconciliation)

Filters: 

  • Filter the date to view the last month

Groups:

  • Location >> Name

Metrics

  • Source Sales >> Gross Sales
  • Source Sales >> Net Markdowns
  • Source Sales >> Gross Returns
  • Source Sales >> Net Sales
  • Sales Tax >> Net Amount Collected
  • Shipping >> Net Shipping Income
  • Location Sales >> Net Item Sold Cost
  • Payments >> Net Payments

(2) Payment Types by Date

Filters: 

  • Filter the date to view Month to Date

Groups:

  • Date
  • Location >> Name
  • Payments >> Payment Type

Metrics

  • Payments >> Net Payments

(3) Credit Card Payments By Type and Date

(4) Monthly Inventory Balance Rollforward

Filters: 

  • Filter the date to view Last Month

Groups:

  • Location >> Name

Metrics

  • Beginning Inventory >> Cost on Hand
  • Purchasing >> Gross Received Cost
  • Purchasing >> Gross Returned Cost
  • Source Sales >> Net Item Sold Cost
  • Inventory Adjustments >> Net Adjusted Cost
  • Ending Inventory >> Cost on Hand

NOTES:

Beginning Inventory Cost on Hand + Purchasing Gross Received Cost - Purchasing Gross Returned Cost - Source Sales Net Item Sold Cost + or - Inventory Adjustments Net Adjusted Cost = Ending Inventory Cost on Hand.

*Net adjusted cost should be added or subtracted depending on your adjustments for that month if it is in parentheses that means it is negative and should be subtracted. If it is not it is a positive number that should be added.

(5) Monthly Gift Card Liability

Filters: 

  • Filter the date to view Last Month

Groups:

  • Gift Cards >> Gift Card #

Metrics

  • Gift Cards >> Beginning Balance
  • Gift Cards >> Gift Cards Expired
  • Gift Cards >> Net Adjusted Amount
  • Gift Cards >> Issued
  • Gift Cards >> Ending Balance 

NOTES:

Giftcards Redeemed need to come from report #2 above, Payments by Payment Type.

(6) Monthly Purchases by Vendor

Filters: 

  • Filter the date to view Month to Date (or Last Month)

Groups:

  • Date
  • Vendor >> Name
  • Purchasing >> Receipt #

Metrics

  • Purchasing >> Gross Received Cost
  • Purchasing >> Gross Received QTY
  • Purchasing >> Gross Returned Cost
  • Purchasing >> Gross Returned QTY

(7) Sales Tax Amounts Due

Did this answer your question?