Cash tracking
Record receipts and payments, then see the monthly position.
PRACTICAL EXCEL WORKBOOKS / CLEARER REPORTING
Know what your numbers are telling you.
HODASSA develops focused Excel trackers and reports for cash, sales and project costs. Start with a working example, then discuss the inputs and outputs your business needs.
A PRACTICAL STARTING POINT
One useful workbook.
A clear way to update it.
Sales reporting
Turn order inputs into sales, direct cost and margin views.
Project cost review
Compare budgets with costs and reviewed estimates to complete.
OPEN THE FILES. TRY THE INPUTS.
Working examples you can inspect.
Real downloadable workbooks using fictional data. Each example explains its inputs, calculations and limits.
Actual workbook preview · View full size ↗RECEIPTS / PAYMENTS
See where cash comes in and goes out.
A dated transaction log feeds a six-month cash view, with receipts, payments and a running closing balance.
Explore Cash Tracker ↗
Actual workbook preview · View full size ↗INVOICED SALES / DIRECT COST
Turn order rows into a monthly sales report.
Track invoiced sales, direct cost, gross profit and margin. Cancelled orders are excluded and incomplete inputs are flagged.
Explore Sales Report ↗
Actual workbook preview · View full size ↗PROJECTS / COST TO COMPLETE
Spot the projects that need a cost review.
Compare project budgets against actual costs, remaining purchase commitments and a manually reviewed estimate to complete.
Explore Project Cost Review ↗HOW DELIVERY WORKS
Agree what good looks like before the build.
01 / CHECK THE FIT
Start with a sample.
Review an anonymised sample, the report you need and your Excel version before committing to a build.
02 / AGREE THE SCOPE
Define a small deliverable.
Agree inputs, outputs, price, delivery date, revisions and acceptance checks in writing.
03 / BUILD & CHECK
Review a working prototype.
Walk through normal updates, missing data and known totals together. Resolve differences before handover.
04 / HAND OVER
Make the next update clear.
Provide the workbook and instructions. Agree the correction period and any future changes separately.
START WITH ONE REPORT
What do you need your spreadsheet to tell you?
Describe the inputs you have, the decision you need to make and your Excel version.
Discuss your workbook