When a retailer first gets on a new system, the priority is clear: learn how to write quotes, process orders, and get inventory dialed in. The sales floor comes first. Everything else, including reporting, gets a quick look and then sits untouched.
Not because the reports aren’t useful. Because there are only so many hours in a training week.
Then, a few months in, a retailer opens a report they’d never clicked on before. It answers a question they’ve been calculating by hand. Or not answering at all. The reaction is almost always the same: “How long has this been here?”
This post covers the reports that consistently fly under the radar. If you’ve been on the HomeSource platform for a while and haven’t explored these, you’re leaving real insight on the table.
AP and AR aging: who owes what, and when
Two reports. Both simple. Both change how you manage cash.
The AP aging report categorizes every outstanding vendor invoice by how overdue it is: current, 30 days, 60 days, 90-plus. Instead of flipping through paper invoices or scrolling through email confirmations, you get a single screen that shows exactly where your vendor obligations stand.
The AR aging report does the same for customer balances. Which customers owe you money? How long have they owed it? Are any accounts drifting past their terms?
Most retailers track this in spreadsheets. Or worse, in their heads. Both reports update in real time as invoices post, payments clear, and new transactions come through. No manual reconciliation needed.
Layer in the cash requirements report, and you can see exactly how much cash you need to cover upcoming vendor payments before they’re due. Retailers who start running this report weekly stop getting surprised by cash flow gaps. The information was always available in theory. The report just puts it in one place.
The GL history wheel: trace any number back to its source
This is probably the single most underused tool in the system. And it’s one of the most powerful.
Click any General Ledger account, and the history wheel shows every transaction that touched it, with drill-down capability to the original source document. Invoice, payment, journal entry, credit memo. Whatever created that number, you can find it in a few clicks.
Before this, tracking down a discrepancy in the GL meant hours of cross-referencing. The accounting team would pull reports from one system, match them against bank statements, and try to figure out where $347.12 went sideways. With the history wheel, that’s a two-minute task. Click the account, find the transaction, drill into the document.
It’s part of the standard GL configuration. Most retailers are focused on POS workflows during their first weeks on the system, so the history wheel doesn’t get a real test drive until something goes wrong. Then it immediately becomes indispensable.
Inventory brand reporting: see what’s actually moving
If you carry products from 15 or 20 manufacturers, you already know some brands move faster than others. But how much detail do you actually have?
Inventory brand reporting breaks down stock levels and movement by manufacturer. Which brands are turning? Which ones have been sitting on the floor for 90 days? Where is your capital actually tied up?
This report changes conversations with vendors. When a rep comes in asking for a bigger commitment, you can pull up actual sell-through data instead of working from memory. When it’s time to plan a floor reset, you’re making decisions based on what sold, not what you think sold.
Most retailers don’t open this report until a check-in call with their account manager. It’s been there since day one. It just takes a nudge to start using it.
All-location reporting: one view across every store
This one is for multi-location retailers, and it solves a problem that’s so familiar it barely registers as a problem anymore.
Owners with two, three, or five stores know the routine. Log into each location separately to pull numbers. Ask store managers to email daily reports. Drive between locations with a notebook.
All-location reporting pulls sales, inventory, AR, AP, and operational data from every store into a single consolidated view. One login, one screen, one source of truth.
During the first weeks on the system, most of the hands-on time goes toward single-store workflows. Learning the interface, getting comfortable with daily operations. The all-location view is available from the start, but it usually gets overlooked until the owner actually needs a cross-store comparison.
When they finally open it, the question is always the same: “Why didn’t I start using this sooner?”
Budget reporting and variance analysis
This is the report that turns a reactive retailer into a proactive one.
The system supports full budget creation by department, account, or location. Once a budget is entered, variance reporting shows exactly where actuals are running ahead or behind. It updates as transactions post throughout the month.
Most independent retailers have never had this level of financial granularity. They’ve been running on gut feel, year-over-year comparisons from their accountant, or a general sense of “we’re doing okay” versus “this month felt slow.”
Budget variance reporting gives you specific answers. Marketing spend is 12% over budget. The parts department is running 8% under revenue projections. Payroll at the second location is trending higher than planned. These aren’t end-of-quarter surprises anymore. They’re mid-month signals you can act on.
The GL structure that powers this reporting is built into the system from the start. Most retailers tackle budget entry once they’re comfortable with daily operations, but the framework is there whenever they’re ready.
The real cost of not using what you already have
Every report in this post is already built into the system. Configured during setup. Available right now.
The gap isn’t the technology. It’s awareness. When the first weeks on a new platform are packed with POS workflows and inventory setup, reporting gets squeezed to the end of the priority list. That’s understandable. But it means most retailers are only using a fraction of what they have.
If any of these reports sound unfamiliar, it might be worth a call with your account manager. A 30-minute walkthrough of what’s already in your system could change how you run your week.
