Make room for
better money habits.
Thoughtful guides for everyday spending. Practical examples, clear explanations and ideas you can put to work.
Find your next good read.
Small decisions. Clearer thinking. A useful place to start.
940 guides · Page 33 of 79
Take your time. Find what helps.
Monthly Totals Wrong in Your Expense Sheet? Dates Stored as Text Are Often Why
If SUMIFS by month returns zero or the wrong figure, your dates are probably text; learn how to test, convert and build monthly totals, with A$ examples.
Read article
Sorting or Copying Broke Your Expense Sheet? Fix References and Merged Cells
Sorting, copying and merged cells can quietly break expense formulas; learn the anchoring rules and a safe layout, with C$ worked examples.
Read article
Formulas Fail After Pasting Bank Data? Decimal Commas and Separators Explained
Spreadsheet formulas that return errors or zero after you paste € bank data often trace back to decimal commas and list separators; here is how to diagnose it.
Read article
Why your expense spreadsheet formulas keep breaking, and how to stop it
Weekly rows added from payout files break monthly totals. These are the formula mistakes behind it, with corrected SUMIFS examples for Excel and Sheets.
Read article
Expense Spreadsheet Showing the Wrong Category Totals? Check These Causes
Category totals in your monthly expense sheet do not match the bank statement? Check spaces, text amounts and spelling in your £ data with this list.
Read article
Why Your Monthly Expense Total Stops Matching as You Add Rows
Your monthly expense sheet total is wrong because new rows fall outside the formula range; here is how to find that and other breakages, with $ examples.
Read article
A 13-week cash forecast for a small shop on one sheet
Build a 13 week cash forecast for a small shop on one sheet: opening cash, expected receipts, known payments and closing cash, with an example.
Read article
A 5-minute closing cash tally for a shop counter
A 5-minute closing cash tally for a shop counter: count notes by denomination, add coins, compare with expected cash and write the difference.
Read article
A business partner takes over the books for a month: a walkthrough
How a partner takes over bookkeeping for a month: a joint month-end session, a solo month with a day-15 check, a joint review and five common slips.
Read article
A cash forecast shows a negative week: what to do before it arrives
Your cash forecast shows a negative week? Options in order of cost: move a payment, collect udhaar, delay stock, or a short bridge for an ₹18,000 gap.
Read article
A daily sales sheet for a shop with several counters or staff
A daily sales sheet for a shop with several counters or staff: one column per counter, a total, and a closing check tying each to its cash and UPI.
Read article
A daily wastage sheet for a sweet shop or bakery
A simple daily wastage sheet for a sweet shop or bakery: columns to keep, a made-up bakery day with costs, and how to total the week by item and reason.
Read article