Case study
A Bilingual Income Ledger With Weekly, Monthly and Yearly Totals
A one-sheet English and Spanish income ledger that rolls daily pay and tips up into weekly, monthly and year-to-date totals.
- Client
- Raumond P.
- Sector
- Self-employed income records
- Location
- Costa Rica (end user)
- Scope
- Daily income ledger with automatic period totals
- Tools
- Excel tables, SUMIFS, date functions
The Brief
The client had been confident with Excel but had retired over a decade earlier and no longer felt able to build a spreadsheet himself. He wanted a very simple record for a friend in Costa Rica who had no clear picture of what she earned, summarized week by week.
The Challenge
The person keeping the records isn't a spreadsheet user and reads Spanish as well as English. The ledger had to capture each day's income at source, with pay and tips kept as separate income lines, and produce period totals without any formula work on her part.
Daily records also had to stay usable over time: totals needed to cut off cleanly by week, month and year so earlier periods stay correct as new entries are added.

What we delivered
- A daily income ledger that takes under a minute to update
- Weekly earnings visible at a glance, with month-to-date and year-to-date totals
- Clean, dated income records that can be handed to an adviser if ever needed
What We Built
- A daily income ledger with English and Spanish headings (Date / Fecha, Hours / Horas, Pay / Pago, Tip / Propina)
- Pay and tips recorded as separate income lines, plus hours and number of clients for income-per-hour analysis
- Automatic period fields: enter the date and the week number, month, year and weekday fill themselves
- Weekly, monthly and year-to-date income totals that update with every entry
- An Excel table structure, so new rows inherit every formula and totals never miss a line
How We Approached It
Record income at source
One row per working day, with pay and tips entered as they are received: a simple cash-basis income record.
Summarize by period
Totals by week, month and year, keyed on both the period and the year, so each period is cut off correctly.
Make it impossible to break
Formulas live inside a structured table and are never typed by the user; every heading is bilingual.
Accounting Terms in This Project
- Income ledger
- A dated, line-by-line record of money earned, kept as it happens rather than reconstructed later.
- Cash basis
- Income recorded when it is received, the simplest method for an individual's own records.
- Period totals
- Income summarized by week, month and year, with each period cut off by date.
- Year to date (YTD)
- Total income from the start of the year up to the latest entry.
More Case Studies
Education provider (teaching products)Segment P&L Analysis of Teaching Products Across Two Markets
Six years of product-level income statements analyzed for income, direct cost and gross margin movement before, during and after Covid, presented market by market.
Read the case study →
Group of Australian advisory businessesRolling a Combined Budget vs Actual Workbook Into a New Financial Year
A multi-entity budget workbook rebuilt for a new July–June financial year, with monthly budget vs actual figures, full-year totals and variance analysis.
Read the case study →Have a similar job?
Send us the file or a short description. You'll get a fixed price within a few business hours.
Hire an Excel Accounting Expert