Expense categories

Lidl spend report: how to total your shopping from statements

Lidl spend report: find every Lidl line on your statements, total them by month with a SUMIF wildcard formula, and see what a typical week costs you.

Editorial illustration for Lidl spend report: how to total your shopping from statements

To build a Lidl spend report, download your bank or card statement, filter the lines whose description contains the shop's name, and add them up by month. A SUMIF formula with a wildcard does this in one line, and a pivot or a monthly list shows the trend. we cannot describe the company's own app or receipts, so use its help pages for those; the method below uses only your statement.

Where to find the lines

Your statement is the honest record. Search the description column for the shop name, and watch for variations, such as a branch name or an extra word, because the same shop can appear in several ways. Note that a refund is a negative line and should be included in the total.

The formula that totals them

Put dates in column A, descriptions in column B and amounts in column C, rows 2 to 500. In Excel or Google Sheets, this adds every line whose description contains the shop name, ignoring capital letters:

  • =SUMIF($B$2:$B$500,"*Lidl*",$C$2:$C$500)
  • For one month, with the first of the month in F1 and the next month start in G1: =SUMIFS($C$2:$C$500,$B$2:$B$500,"*Lidl*",$A$2:$A$500,">="&$F$1,$A$2:$A$500,"<"&$G$1)

Dates must be real dates, not text, or the month test will find nothing.

A worked example

Say the statement shows these euro amounts for one shop in a month: 23.40, 41.15, 12.80, 38.60 and a refund of 4.50 shown as negative.

DateDescriptionAmount in euro
2Lidl, branch one23.40
9Lidl, branch one41.15
15Lidl, branch two12.80
23Lidl, branch one38.60
26Lidl refund-4.50

The total is 23.40 + 41.15 + 12.80 + 38.60 - 4.50 = 111.45. With four visits, the average per visit, before the refund, is 115.95 / 4 = 28.99.

How do you make it useful?

  1. Add a column for the category, such as groceries.
  2. Total each month and compare, ignoring one-off events.
  3. Look at the number of visits as well as the amount.
  4. Set a monthly target for groceries and see how close you were.

Should you compare shops?

A report for one shop only tells half the story. Add a second SUMIF for another grocery shop, then put the two side by side with a third cell for the total. If the first came to 111.45 and the second to 64.30, the combined grocery spend is 175.75. Seeing both guards you against telling yourself one shop is cheap when you are simply going there more often.

What if your statement uses short descriptions?

Card statements often shorten names or add codes. Search for a few letters of the name, or look at the amount and date to find the line, and keep a short list of the spellings you have found. A wildcard such as *LID* catches more variants, but check that it does not pull in unrelated shops. A quick scroll through the matches tells you.

Doing this in an app

SpendixAI is built around India and INR, so it is not the natural home for a euro-only life. If you spend euros while travelling, each expense there can carry its own currency, totals use the base currency you chose before importing, and there is a Foreign-currency spend report. It also has a Report builder for filtering and grouping, with CSV download. For a euro budget at home, the sheet above is simpler.

Before you trust the number

  • Did every branch variant get picked up?
  • Are refunds included?
  • Are dates real dates?
  • Does the monthly total match your statement lines when added by hand?
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports