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.

Bilingual English and Spanish income ledger with automatic weekly, monthly and year-to-date totals
Illustration of the ledger layout with sample data.

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

  1. Record income at source

    One row per working day, with pay and tips entered as they are received: a simple cash-basis income record.

  2. Summarize by period

    Totals by week, month and year, keyed on both the period and the year, so each period is cut off correctly.

  3. 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.

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
Hire an expert