What you can ask
Ask it what you’d ask someone who’s read your book.
Seven kinds of question, from a restaurant, a salon and a shop. Each answer is worked out from a sample business’s book, the way it works out yours.
Your expenses, each with what it was for. Supplier names let it spot a price rise.
Daily sales. With items, it can also say which items fell, and whether fewer were sold or prices changed.
Sales by item. Add what each costs you, and it ranks them by what they keep.
Eight weeks of daily sales. Always a range, never just one number, and never more than five weeks ahead.
Your prices, for a price change. Item costs and monthly expenses, for a profit target.
Nothing extra.
Daily sales and expenses. Timed receipts add your busy hours.
Where did my money go?
Spending by what it was for, and what’s left after it.
What else was true on the slow days: the weekday, payday, a holiday, a note you left.
Best and worst, rising and fading, and what each one keeps.
A likely range for next week or next month, and where this month is heading.
Try a price, a target or a new item on your own numbers before you do it.
Figures that don’t look right, entries made twice, names that look alike. Nothing changes until you say.
Growth, what you keep, how steady it is, your busy days and hours.
Where did my money go in September?
September’s money was absorbed mainly by operating expenses, leaving the period slightly short. September, up to Sep 27, had ₱95,110 in operating expenses and ₱190 more going out than came in.
| Item | Amount |
|---|---|
| Revenue | ₱157,215 |
| Item costs | ₱62,295 |
| Gross Profit | ₱94,920 |
| Operating Expenses | ₱95,110 |
| Net | −₱190 |
- Ingredients & supplies took ₱39,560, about 42% of operating expenses.
- Wages took ₱26,000, rent ₱22,000, and utilities ₱7,550.
- Sales were ₱157,215; after ₱62,295 in costs, ₱94,920 remained before operating expenses.
What did I make after costs in August?
August left you with ₱12,003 after costs and expenses.
| Item | Amount | entries |
|---|---|---|
| Sales | ₱186,250 | 403 |
| Cost of goods | ₱74,147 | 403 |
| Gross profit | ₱112,103 | — |
| Wages | ₱52,000 | 2 |
| Rent | ₱22,000 | 1 |
| Ingredients & supplies | ₱17,800 | 11 |
| Utilities | ₱8,300 | 1 |
| Expenses | ₱100,100 | 15 |
| Net | ₱12,003 | — |
- Sales were ₱186,250.
- Cost of goods was ₱74,147, leaving ₱112,103 before expenses.
- Expenses were ₱100,100; wages were the largest at ₱52,000.
Review the wages entered for August before making spending decisions.
Why was last week so low?
Last week was lower mainly because fewer items sold, not because prices changed.
This period
Sep 21–27 · 7 days
₱37,225
₱5,318 a day
The period before
Sep 14–20 · 7 days
₱45,580
₱6,511 a day
Change
per day
−18.3%
₱8,355 less in total
| This period | ₱37,225 | ₱5,318 a day |
|---|---|---|
| The period before | ₱45,580 | ₱6,511 a day |
- Sales fell by ₱8,355, or about 18%, from the previous week; both periods covered seven days.
- The price effect was ₱0, while lower volume accounted for the full decline across 13 products sold in both weeks.
- Last week came to ₱37,225 against about ₱40,573 expected from your usual matching weekdays, including an ordinary Sep 26.
- The previous week had three paydays and last week had none, so the week-to-week comparison is not fully fair.
- Nothing was logged for Sep 21–27 about a promotion, closure, or event.
What remains unexplained is why fewer items sold, especially with no logged event or price change.
Was Sep 22 a bad day, or just a Tuesday?
Sep 22 was mainly a weak evening, not an unusually bad Tuesday overall.
| Item | Amount | Units |
|---|---|---|
| Sep 22 | ₱4,250 | 39 |
- Sales were ₱4,250, about ₱446 below the usual Tuesday level of ₱4,696, or about 9% lower.
- The shortfall was concentrated in the evening, at 61% below its usual level; morning, midday, and afternoon were at or above usual.
- No event was logged for Sep 22, so the reason for the evening drop remains unexplained.
What sold best in September?
Sinigang na baboy sold best by sales in September.
- Sinigang na baboy₱29,785161 sold18.9%
- Lechon kawali₱15,75075 sold10.0%
- Pork sisig₱15,05086 sold9.6%
- Chicken adobo₱14,35587 sold9.1%
- Kare-kare₱12,96054 sold8.2%
- Iced tea₱12,705231 sold8.1%
- Rice₱12,630421 sold8.0%
- Bangus₱9,88052 sold6.3%
| Item | Amount | Sold | Share |
|---|---|---|---|
| Sinigang na baboy | ₱29,785 | 161 sold | 18.9% |
| Lechon kawali | ₱15,750 | 75 sold | 10.0% |
| Pork sisig | ₱15,050 | 86 sold | 9.6% |
| Chicken adobo | ₱14,355 | 87 sold | 9.1% |
| Kare-kare | ₱12,960 | 54 sold | 8.2% |
| Iced tea | ₱12,705 | 231 sold | 8.1% |
| Rice | ₱12,630 | 421 sold | 8.0% |
| Bangus | ₱9,880 | 52 sold | 6.3% |
- September, up to Sep 27, Sinigang na baboy led with ₱29,785 from 161 items.
- The next strongest were Lechon kawali (₱15,750), Pork sisig (₱15,050), Chicken adobo (₱14,355), and Kare-kare (₱12,960).
- Rice sold the most items, at 421, but ranked below Sinigang na baboy in sales.
Which dishes are fading?
Pancit palabok is the dish fading over the available period.
- Pancit palabok fell about 43% in the second half versus the first half of Aug 29–Sep 27.
- Lechon kawali rose about 47% over the same comparison.
- The sales amount behind the change isn’t available, so the size in pesos remains unclear.
How much rides on my top dishes?
Your sales depend meaningfully on a small group of dishes.
- From Aug 29–Sep 27, the top three dishes—Sinigang na baboy, Lechon kawali, and Pork sisig—brought in about 38% of sales across 13 products.
- Sinigang na baboy was the top dish at ₱33,670.
Review these three dishes first for availability, pricing, and cost control.
Where will September end?
September is heading to finish around ₱174,683.
- Up to Sep 27, this month has reached ₱157,215.
- The forecast range is roughly ₱173,979–₱175,175, based on the remaining three days.
When will October reach ₱150,000?
October is forecast to reach ₱150,000 around Oct 26, with the estimate ranging from Oct 24 to Oct 30.
What if I charge ₱40 more for kare-kare?
A ₱40 increase could add roughly ₱2,480 in sales if Kare-kare volume holds.
- This estimate uses 62 Kare-kare items sold over Aug 29–Sep 27.
- The estimate stays ahead as long as volume falls less than about 39%.
Did I miss any days?
You did not miss any sales days in the period covered.
| Check | Detail | Entries |
|---|---|---|
| duplicate | Sep 18 Lechon kawali entered 2× | 2 |
- Your entries run from Jun 8 to Sep 27, with no missing sales days identified.
- Sep 18 has one duplicate entry for Lechon kawali, entered twice for ₱1,260.
Remove the duplicate Sep 18 entry if it was accidental.
Does anything look wrong in my entries?
One entry looks duplicated; otherwise, your entries show no obvious gaps or naming problems.
| Check | Detail | Entries |
|---|---|---|
| duplicate | Sep 18 Lechon kawali entered 2× | 2 |
- Sep 18 Lechon kawali appears twice with the same details, for ₱1,260.
- No missing sales days, negative entries, unresolved name pairs, or unusual sales windows were found.
- Every sales entry includes the product, quantity, price per item, cost per item, and sale time.
- Every expense entry has a category.
Is anything entered twice?
Yes—one sale appears to have been entered twice.
| Check | Detail | Entries |
|---|---|---|
| duplicate | Sep 18 Lechon kawali entered 2× | 2 |
- Sep 18: Lechon kawali was entered twice for the same sale, at ₱1,260.
- The duplicate is the only duplicate group found in the entries reviewed.
Remove one of the two Sep 18 Lechon kawali entries.
How am I doing overall?
Overall, the business is fine, with expenses the main area to watch.
This period
Aug 29 – Sep 27 · 30 days
₱178,975
₱5,966 a day
The period before
Jul 30 – Aug 28 · 30 days
₱177,875
₱5,929 a day
Change
per day
+0.6%
₱1,100 more in total
| This period | ₱178,975 | ₱5,966 a day |
|---|---|---|
| The period before | ₱177,875 | ₱5,929 a day |
- Sales were nearly flat against the preceding 30-day period: ₱178,975 versus ₱177,875, a ₱1,100 increase.
- You keep about 60% of each sale after ingredient costs, while expenses take about 69% of sales.
- Your top three products bring in 38% of sales, and daily sales barely wobble.
Review which expenses are taking the largest share of sales and whether any can be reduced.
How did this month compare with last month?
Sales are essentially flat against last month on the comparable days.
This period
Sep 1–27 · 27 days
₱157,215
₱5,823 a day
The period before
Aug 1–27 · 27 days
₱157,820
₱5,845 a day
Change
per day
−0.4%
₱605 less in total
| This period | ₱157,215 | ₱5,823 a day |
|---|---|---|
| The period before | ₱157,820 | ₱5,845 a day |
- This month, up to Sep 27, came to ₱157,215, versus ₱157,820 last month over the same 27 days.
- That is down ₱605, or about 0.4%; daily sales were ₱5,823 versus ₱5,845.
- This month is incomplete because it covers 27 of the 28 days asked, but both periods cover the same weekdays, so the comparison is fair.
What am I spending the most on?
You’re spending the most on wages.
| Item | Amount | entries |
|---|---|---|
| Wages | ₱40,000 | 2 |
| Rent | ₱18,000 | 1 |
| Supplies | ₱8,200 | 2 |
| Utilities | ₱4,550 | 1 |
- Wages: ₱40,000, about 57% of spending in the last 30 days.
- Rent: ₱18,000.
- Supplies: ₱8,200.
- Utilities: ₱4,550.
Did my expenses go up in September?
Your expenses are running lower per day in September than in August.
This period
Sep 1–27 · 27 days
₱50,750
₱1,880 a day
The period before
Aug 1–31 · 31 days
₱65,950
₱2,127 a day
Change
per day
−11.7%
₱15,200 less in total, on 4 fewer days
| This period | ₱50,750 | ₱1,880 a day |
|---|---|---|
| The period before | ₱65,950 | ₱2,127 a day |
- September, up to Sep 27, came to ₱50,750 across 27 days; August came to ₱65,950 across 31 days, so the periods cover different numbers of days and September is incomplete.
- The daily rate was ₱1,880 versus ₱2,127, or about 12% lower per day in September.
What did I keep in August?
August left you with money after costs and expenses.
| Item | Amount | entries |
|---|---|---|
| Sales | ₱173,700 | 217 |
| Cost of goods | ₱44,490 | 217 |
| Gross profit | ₱129,210 | — |
| Wages | ₱40,000 | 2 |
| Rent | ₱18,000 | 1 |
| Utilities | ₱4,750 | 1 |
| Supplies | ₱3,200 | 1 |
| Expenses | ₱65,950 | 5 |
| Net | ₱63,260 | — |
- You kept ₱63,260 after ₱44,490 in cost of goods and ₱65,950 in expenses.
- Wages were the largest expense at ₱40,000.
Review the wages recorded for August and confirm they belong to that month.
Why were my Tuesdays slow?
Tuesdays were slow mainly because the afternoon and evening failed to bring in their usual sales.
| Saturday | ₱8,830 |
|---|---|
| Tuesday | ₱2,250 |
- Tuesday was the weakest weekday, at about 63% below the daily average.
- The biggest shortfall was 2–6pm, averaging ₱1,613 on Tuesdays versus ₱3,572 on an average day, about 55% lower.
- Evening sales were also weak, averaging ₱100 on Tuesdays versus ₱573 on an average day, about 83% lower; morning was about 31% lower too.
- The four Tuesdays ranged from ₱1,700 to ₱3,200, with Sep 1 the weakest day overall at ₱1,700 and marked as month start and payday.
What remains unexplained is whether fewer items sold, smaller sales, or a Tuesday operating pattern caused those time-slot shortfalls.
Why was August better than July?
August was not better than July in sales, although it ran above its usual August level.
This period
Aug 1–31 · 31 days
₱173,700
₱5,603 a day
The period before
Jul 1–31 · 31 days
₱177,750
₱5,734 a day
Change
per day
−2.3%
₱4,050 less in total
| This period | ₱173,700 | ₱5,603 a day |
|---|---|---|
| The period before | ₱177,750 | ₱5,734 a day |
- August sales were ₱173,700 versus July’s ₱177,750, a decrease of ₱4,050 or about 2%.
- The entire change came from selling fewer items across the 8 products sold in both months; price changes added ₱0.
- August was ₱6,635 above its estimated usual level of ₱167,065, but that estimate used only two comparable Mondays and ignored weekday and payday patterns.
- What remains unexplained is whether a specific operating issue caused the lower item volume, because no promotion, closure, or event was logged for August.
What happened on Sep 19?
Sep 19 was a sales day, but the entries don’t show what drove it.
| Item | Amount | Units |
|---|---|---|
| Sep 19 | ₱9,700 | 18 |
- Sales came to ₱9,700 from 18 items.
- Sep 19 was a Saturday.
- Nothing was logged for Sep 19 that explains the result.
Which services make me money?
All eight services leave money after their costs, with Colour + cut leading and Keratin treatment weakest.
- Colour + cut₱31,86066%
- Gel set₱30,40084%
- Haircut₱25,99092%
- Hair treatment₱15,64057%
- Manicure₱10,12088%
- Pedicure₱9,10087%
- Blow-dry₱7,77093%
- Keratin treatment₱7,26055%
| Colour + cut | ₱31,860 | 66% |
|---|---|---|
| Gel set | ₱30,400 | 84% |
| Haircut | ₱25,990 | 92% |
| Hair treatment | ₱15,640 | 57% |
| Manicure | ₱10,120 | 88% |
| Pedicure | ₱9,100 | 87% |
| Blow-dry | ₱7,770 | 93% |
| Keratin treatment | ₱7,260 | 55% |
- Colour + cut leaves ₱31,860 after its cost; Gel set leaves ₱30,400.
- Haircut leaves ₱25,990; Hair treatment leaves ₱15,640.
- Manicure leaves ₱10,120; Pedicure leaves ₱9,100.
- Blow-dry has the strongest margin at about 93%, while Keratin treatment has the weakest at 55%.
- Keratin treatment leaves ₱7,260 after its cost, despite ₱13,200 in sales.
Review the pricing or ingredient cost for Keratin treatment before pushing it harder.
Are gel sets growing?
Gel sets are growing, with stronger sales toward the end of the period.
| Item | Amount | Units |
|---|---|---|
| Aug 29 | ₱900 | 2 |
| Aug 30 | ₱900 | 2 |
| Aug 31 | ₱450 | 1 |
| Sep 1 | ₱450 | 1 |
| Sep 2 | ₱450 | 1 |
| Sep 3 | ₱900 | 2 |
| Sep 4 | ₱900 | 2 |
| Sep 5 | ₱900 | 2 |
| Sep 6 | ₱1,350 | 3 |
- Sales rose from ₱900 on Aug 29 to ₱2,250 on Sep 27.
- The strongest day was Sep 12 at ₱3,150; the weakest was Aug 31 at ₱450.
- Weekends averaged ₱1,710 per day, compared with ₱945 on non-weekend days.
Keep watching whether the stronger late-period sales continue beyond weekends.
Colour or treatments: which brings in more?
Colour brings in more than any individual treatment product.
- Colour + cut₱48,60027 sold53.6%
- Hair treatment₱27,60023 sold30.5%
- Keratin treatment₱13,20011 sold14.6%
- Kertin treatmnt₱1,2001 sold1.3%
| Item | Amount | Sold | Share |
|---|---|---|---|
| Colour + cut | ₱48,600 | 27 sold | 53.6% |
| Hair treatment | ₱27,600 | 23 sold | 30.5% |
| Keratin treatment | ₱13,200 | 11 sold | 14.6% |
| Kertin treatmnt | ₱1,200 | 1 sold | 1.3% |
- Colour + cut brought in ₱48,600 from 27 sold.
- Hair treatment brought in ₱27,600 from 23 sold.
- Keratin treatment brought in ₱13,200 from 11 sold.
- Kertin treatmnt brought in ₱1,200 from 1 sold.
Am I on track for ₱170,000 this month?
You are on track for this month’s target.
- Up to Sep 27, this month is at ₱163,600 against ₱153,000 expected.
- At the pace of your entries up to Sep 27, September is on pace for roughly ₱181,778.
- You would need roughly ₱2,133 a day from Sep 28 to reach the target.
What if I raise every price by 10%?
A 10% price increase is estimated to raise sales if the drop in sales stays below the break-even point.
- Over Aug 29–Sep 27, sales came to ₱185,000 across all 30 days.
- At the same sales volume, the increase is estimated to add about ₱18,500, taking sales to roughly ₱203,500.
- You could absorb an estimated sales-volume loss of about 9% before the increase stops helping.
What if I put gel sets up ₱50?
A ₱50 increase would roughly add ₱4,000 if Gel set sales volume stays unchanged.
- This estimate uses 80 Gel sets sold at about ₱450 each from Aug 29–Sep 27.
- The increase stays ahead if volume falls by less than an estimated 12%.
Does anything look off in my entries?
Yes—duplicate, naming, and negative-value entries need attention.
| Check | Detail | Entries |
|---|---|---|
| duplicate | Sep 12 Gel set entered 2× | 2 |
| look-alike names | "Keratin treatment" vs "Kertin treatmnt" | 42 |
| negative amounts | refunds or entry errors | 1 |
- 3 issues were found, with no missing sales days.
- Sep 12’s Gel set entry appears twice with the same details; the duplicate amount is ₱900.
- “Keratin treatment” and “Kertin treatmnt” are look-alike names across 42 entries.
- One entry has a negative amount of ₱250, which may be a refund or an entry error.
- Your last entry was yesterday, and all sales entries have product names, quantities, prices, and sale times.
Remove the Sep 12 duplicate, standardize the treatment name, and confirm whether the negative ₱250 was a refund.
Are any names spelled two ways?
Yes—one pair of names is spelled two ways: “Keratin treatment” and “Kertin treatmnt,” appearing across 42 entries.
| Check | Detail | Entries |
|---|---|---|
| duplicate | Sep 12 Gel set entered 2× | 2 |
| look-alike names | "Keratin treatment" vs "Kertin treatmnt" | 42 |
| negative amounts | refunds or entry errors | 1 |
What are my busiest hours?
Your busiest hours are 2–6pm, when the afternoon brings in the most sales.
| Item | Sales | A day |
|---|---|---|
| morning (6–11am) | ₱21,050 | ₱702 |
| midday (11am–2pm) | ₱39,600 | ₱1,320 |
| afternoon (2–6pm) | ₱107,150 | ₱3,572 |
| evening (6–10pm) | ₱17,200 | ₱573 |
- Afternoon sales average ₱3,572 per day and account for about 58% of sales.
- Midday averages ₱1,320 per day, morning ₱702, and evening ₱573.
Am I growing?
Sales are growing, with the latest period ahead of the one before it.
This period
Aug 29 – Sep 27 · 30 days
₱185,000
₱6,167 a day
The period before
Jul 30 – Aug 28 · 30 days
₱166,550
₱5,552 a day
Change
per day
+11.1%
₱18,450 more in total
| This period | ₱185,000 | ₱6,167 a day |
|---|---|---|
| The period before | ₱166,550 | ₱5,552 a day |
- The last 30 days reached ₱185,000 versus ₱166,550 in the preceding 30 days, a difference of ₱18,450.
- The increase was 11%, with daily sales also up by ₱615.
- The overall read is fine: growth is steady, though daily sales wobble a fair bit and your top 3 products bring in 61% of sales.
What did I spend on supplies this month?
You spent ₱6,210 on supplies this month, up to Sep 27.
| Item | Amount | entries |
|---|---|---|
| Wages | ₱24,000 | 1 |
| Rent | ₱16,000 | 1 |
| Other | ₱7,100 | 4 |
| Supplies | ₱6,210 | 7 |
| Utilities | ₱4,050 | 1 |
Where does my money go each month?
Your monthly money picture is incomplete because item costs are missing.
| Item | Amount |
|---|---|
| Revenue | ₱159,050 |
| Operating Expenses | ₱83,260 |
- For Aug 29–Sep 27, sales were ₱159,050 and operating expenses were ₱83,260.
- I can’t show gross profit or what was left after all costs because the cost of each item and how many you sold aren’t available.
Add each item’s cost and quantity so the monthly flow can include product costs and what was left after expenses.
How much is left after expenses?
Over the last 30 days, ₱75,790 was left after expenses; cost of goods is not included because item costs aren’t logged.
| Item | Amount | entries |
|---|---|---|
| Sales | ₱159,050 | 109 |
| Wages | ₱48,000 | 2 |
| Rent | ₱16,000 | 1 |
| Other | ₱9,000 | 5 |
| Supplies | ₱6,210 | 7 |
| Utilities | ₱4,050 | 1 |
| Expenses | ₱83,260 | 16 |
| Left after expenses | ₱75,790 | — |
Wages were the largest expense at ₱48,000.
Add the cost of each item to see what remains after both expenses and product costs.
Why was last Tuesday slow?
Tuesday was slow because sales came in well below your usual level, but the entries don’t show why.
| Item | Amount | Entries |
|---|---|---|
| Sep 22 | ₱3,685 | 4 |
- Sep 22 sales were ₱3,685 against an expected ₱5,003, a shortfall of ₱1,318, or about 26%.
- I can’t identify a slow hour because too few sales include the time they happened.
- Nothing was logged around Sep 22 that explains the drop.
Was the Aug 31 holiday weekend slow?
No—the holiday Monday was essentially in line with your usual sales.
| Item | Amount | Entries |
|---|---|---|
| Aug 31 | ₱5,150 | 3 |
- Aug 31 sales were ₱5,150, just ₱79 below the expected ₱5,229, or 2% lower.
- The comparison uses a rolling 28-day average; only two earlier days matched the same weekday and payday pattern, so the seasonal comparison is limited.
- I couldn’t identify a slower hour because too few sales include sale times.
- Nothing was logged explaining what happened on Aug 31.
Which items sell the least?
Teflon tape sells the least by revenue at ₱75.
- Teflon tape₱750.1%
- Masking tape₱900.1%
- PVC pipe 1/2in₱1150.1%
- Sandpaper sheet₱1200.1%
- Wire 2.0mm per m₱2250.1%
- Screwdriver set₱2500.2%
- Electrical tape₱3150.2%
- Cable ties pack₱3200.2%
| Teflon tape | ₱75 | 0.1% |
|---|---|---|
| Masking tape | ₱90 | 0.1% |
| PVC pipe 1/2in | ₱115 | 0.1% |
| Sandpaper sheet | ₱120 | 0.1% |
| Wire 2.0mm per m | ₱225 | 0.1% |
| Screwdriver set | ₱250 | 0.2% |
| Electrical tape | ₱315 | 0.2% |
| Cable ties pack | ₱320 | 0.2% |
- Masking tape follows at ₱90.
- PVC pipe 1/2in follows at ₱115.
- The ranking covers 33 products, but only the weakest eight are shown here; it ranks by revenue, not units sold.
What’s selling more than last month?
Latex paint is the standout growth item, with smaller gains from the garden shovel, basic faucet, and door hinge.
| Item | Before | Now | Change |
|---|---|---|---|
| Latex paint 4L | ₱4,450 | ₱25,810 | +₱21,360 |
| Plywood 1/2in | ₱79,140 | ₱66,315 | −₱12,825 |
| Garden shovel | ₱0 | ₱2,250 | +₱2,250 |
| Cement 40kg | ₱11,115 | ₱9,250 | −₱1,865 |
| Faucet basic | ₱2,720 | ₱4,545 | +₱1,825 |
| Pliers | ₱2,090 | ₱380 | −₱1,710 |
| Extension cord 4-gang | ₱1,980 | ₱660 | −₱1,320 |
| Door hinge 3in | ₱320 | ₱1,600 | +₱1,280 |
- Latex paint 4L: ₱21,360 more than the comparable period last month
- Garden shovel: ₱2,250 more
- Faucet basic: ₱1,825 more
- Door hinge 3in: ₱1,280 more
This month, up to Sep 27, is incomplete; both periods cover 27 days and the same weekdays, so the comparison is fair.
Overall sales were ₱144,350 this month, up to Sep 27, versus ₱139,815 in the comparable period last month—up ₱4,535, or about 3%. Plywood 1/2in fell by ₱12,825, partly offsetting the gains.
Check whether the Latex paint increase was a one-off sale or a product you should keep more available.
Where is September heading?
September is on pace to finish above current sales.
- At the pace of your entries up to Sep 27, this month has reached ₱144,350.
- At this pace, this month is heading for roughly ₱160,389.
- No September target was provided, so I can’t state the gap.
What if I raise all my prices by 5%?
Raising every price could increase sales if volume holds.
- Over the last 30 days, sales came to ₱159,050.
- At the same volume, the estimate is about ₱7,953 in added sales, bringing projected sales to ₱167,003.
- The estimate stays ahead if sales volume falls by less than about 5%.
Trial the increase and watch whether sales volume falls below that level.
Should I sell ₱450 solar lamps that cost me ₱310?
Sell it as a small trial, but do not commit to a large order yet.
| Item | Amount | Entries |
|---|---|---|
| Week of Aug 3 | ₱660 | 1 |
| Week of Aug 10 | ₱185 | 2 |
| Week of Aug 17 | ₱3,750 | 5 |
| Week of Aug 24 | ₱2,080 | 4 |
| Week of Aug 31 | ₱2,275 | 4 |
| Week of Sep 7 | ₱640 | 2 |
| Week of Sep 14 | ₱720 | 2 |
| Week of Sep 21 | ₱75 | 1 |
- Each lamp leaves ₱140 before other expenses, about 31% of its selling price.
- Electrical sales were uneven and ended much weaker than they began, so the nearest existing category is only a guide, not a forecast.
- What remains unknown is whether solar lamps will attract buyers at this price and how many you can sell.
Does Sep 15 look right?
Sep 15 looks softer than your usual comparable day, but not wildly outside the pattern.
| Usual | ₱4,770 |
|---|---|
| Sep 15 | ₱4,095 |
- Sales were ₱4,095, versus expected sales of ₱4,770 from four comparable days.
- That was ₱675 below expected, or about 14% lower.
- Sep 15 was marked as payday.
Did anything get entered twice?
No duplicate entries were found.
| Check | Detail | Entries |
|---|---|---|
| look-alike names | "Latex paint 1L" vs "Latex paint 4L" | 26 |
- The review found 0 duplicate groups and 0 duplicate entries.
- It did flag 26 entries where similar names may refer to different products: “Latex paint 1L” and “Latex paint 4L.”
How is the shop doing?
The shop is broadly fine, with slower growth and reliance on a few products worth watching.
This period
Aug 29 – Sep 27 · 30 days
₱159,050
₱5,302 a day
The period before
Jul 30 – Aug 28 · 30 days
₱157,630
₱5,254 a day
Change
per day
+0.9%
₱1,420 more in total
| This period | ₱159,050 | ₱5,302 a day |
|---|---|---|
| The period before | ₱157,630 | ₱5,254 a day |
- Sales were nearly flat against the previous 30-day period: ₱159,050 versus ₱157,630, up ₱1,420 or about 1%.
- Expenses took about 52% of sales, while daily sales stayed steady.
- Your top three products brought in about 71% of sales, but I can’t tell which products actually make money without their costs and quantities sold.
When are my busiest days?
Your busiest day is Saturday; Sunday is your slowest.
| Saturday | ₱6,914 |
|---|---|
| Sunday | ₱3,234 |
- Saturday averages about 30% above your daily average.
- Sunday averages about 39% below your daily average.
Did my expenses go down in September?
September expenses are running lower per day, but the month is incomplete and the comparison periods cover different numbers of days.
This period
Sep 1–27 · 27 days
₱57,360
₱2,124 a day
The period before
Aug 1–31 · 31 days
₱82,490
₱2,661 a day
Change
per day
−20.2%
₱25,130 less in total, on 4 fewer days
| This period | ₱57,360 | ₱2,124 a day |
|---|---|---|
| The period before | ₱82,490 | ₱2,661 a day |
- September, up to Sep 27, came to ₱57,360 across 27 days, versus ₱82,490 across 31 days in August.
- The daily expense rate was ₱2,124 in September versus ₱2,661 in August, down about 20%.
- September had expenses on 11 days, compared with 12 days in August.
What it can’t answer yet
What it can’t answer yet.
- Anything that never got written down.It will say so, and say what would let it answer.
- Why a customer did or didn’t come in.It shows what else was true that day, not the reason.
- Taxes and BIR filings.
- Counting your cash or your stock.It knows what sold, not what’s on the shelf.
- Who your customers are.No names, no regulars.
- How you compare with other businesses.
- More than about five weeks ahead.Past that, a range gets too wide to be useful.
Should I start a ₱650 lash lift?
I can’t weigh the lash lift yet because I don’t have its cost per service. Nails sales rose from ₱9,550 in the first full week to ₱15,150 in the last, but that is only a nearby guide, not a forecast.
| Item | Amount | Units |
|---|---|---|
| Week of Aug 3 | ₱9,550 | 29 |
| Week of Aug 10 | ₱10,250 | 31 |
| Week of Aug 17 | ₱9,850 | 29 |
| Week of Aug 24 | ₱9,250 | 28 |
| Week of Aug 31 | ₱10,600 | 31 |
| Week of Sep 7 | ₱14,050 | 38 |
| Week of Sep 14 | ₱13,950 | 39 |
| Week of Sep 21 | ₱15,150 | 40 |
Ask it about your own business.
Join the waitlist