Below are examples of some basic reports you can create in Heartland 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
(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