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
(3) Credit Card Payments By Type and Date (How to reconcile the Credit Card deposits coming into your bank to Heartland Retail)
(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 (How to report on your sales tax collected in Heartland Retail)