Neu: Steuerdossier – Steuererklärung vorbereiten. Mehr erfahren →

Budget & Excel

Credit card in a household budget, without double counts

The short answer: Record card purchases in their categories and treat the monthly card settlement on your salary account as a transfer – otherwise every purchase counts twice. A card bill of CHF 305.85 is not an expense; it pays for expenses already in your budget.

Von Leutrim MiftarajGründer von BudgetHub, MSc Innovation Management (FFHS)Aktualisiert Oktober 2026Autor von «Identity Over Discipline»Methodik & Datenquellen

Why the credit card counts twice

In short: with a credit card, each expense appears twice. First as a purchase on the card, say CHF 86.40 at a restaurant. A month later as part of the lump debit that pays the card bill from your salary account. Import both and count both, and you paid for dinner twice – on paper.

Many notice only when monthly spending looks implausibly high. The error is systematic and returns every month until the settlement is marked correctly.

Two clean approaches

Approach A, precise: the card is its own account. Each purchase is recorded with a category and the card balance goes negative. The settlement is a transfer from the salary account to the card that brings it back to zero. You see where money goes and count nothing twice.

Approach B, simple: skip the card statement and book the settlement as one expense «credit card». Fast, but categories vanish – restaurants, holidays and online shopping disappear into one line. For a useful budget, approach A wins.

Purchase date or billing month?

For the budget, the purchase date counts: dinner on 28 March belongs to March even if the card bill leaves your account in April. Only then are months comparable. The billing month matters for cash flow – it shows when money actually leaves the salary account.

If you pay a lot by card, keep both views: spending by purchase date and the open card balance due next month.

Fees, foreign currency and partial payment

The annual card fee belongs under finance, foreign-currency surcharges to the purchase or also to finance. Partial payment is expensive: leave part of the bill unpaid and you pay interest on the rest. In the budget it appears as its own line – a clear sign to act.

  • Annual fee → finance
  • Interest from partial payment → finance, own line
  • Settlement → transfer, never an expense

Several cards and partner cards

If you hold several cards – a cashback card for everyday use and one for travel – keep each as its own account. Partner cards on the same statement can be separated by the card number in the description or assigned to one person so the couple's settlement stays fair.

Debit cards avoid the issue: payments leave the account directly and appear once. That is why credit cards are the most common cause of double-counted spending.

Handled automatically in the Excel budget

In the household budget for Excel the credit card is an account type. Rules recognise settlements from Viseca, Swisscard, Cornercard and PostFinance Card as transfers, and one of 13 checks warns you if the card still counts twice. CHF 49 once.

In the BudgetHub app you add the card as its own account; transfers from the salary account are recognised and not counted as spending.

Häufige Fragen

How do I record a credit card in a household budget?+

Record purchases in their categories and treat the monthly settlement on the salary account as a transfer. That way every expense counts exactly once.

Is the credit card bill an expense?+

No. It pays for expenses already recorded. Counted as an expense, it doubles your card spending in the budget.

Purchase month or billing month?+

For the budget, the purchase month, so months are comparable. For cash flow, the billing month, when the money leaves your salary account.

Where does the annual card fee go?+

Under finance or bank fees. Interest from partial payment is its own line – usually the first thing worth eliminating.

Do I need to import the card statement?+

For meaningful categories, yes. Booking only the settlement as one expense saves time, but you no longer see what the money was spent on.

Which Swiss card issuers does the Excel budget recognise?+

Its rules recognise Viseca, Swisscard, Cornercard and PostFinance Card settlements among others. Further issuers can be added as your own rule.

Setz es direkt um

Erstelle dein Budget in BudgetHub – kostenlos, ohne Kreditkarte und ohne Bankverknüpfung.