Managing Accounts Receivable in Excel
Blog
How to Manage Accounts Receivable in Switzerland
Learn how to manage accounts receivable in Switzerland with 5 proven steps, Excel tips, and invoice automation best practices.
Services fiduciaires
What Is Accounts Receivable?
Accounts receivable, or AR, is the money your customers still owe you for goods or services you have already delivered. In simple terms, it is earned revenue that has not yet reached your bank account.
AR appears on your balance sheet as a current asset. But it only helps your business when you collect it on time. From Swiss businesses to international companies in this country, strong AR management supports working capital and keeps cash flow stable.
In Switzerland, many companies pay within 30 days. However, late payments still happen. Swiss law does not set one fixed maximum payment term for all business invoices, so clear payment terms are important. If a commercial invoice becomes overdue, the statutory default interest rate is generally 5% per year.
Knowing how to manage accounts receivable helps your business collect payments faster, reduce disputes, and plan cash flow with more confidence.
This guide explains the five core steps to managing accounts receivable. It also covers the best AR practices for 2026, how to manage accounts receivable in Excel, and how invoice automation can help Swiss companies save time and reduce manual work.
The Importance of Accounts Receivable Management in 2026
The 2026 AR Benchmark Report by Billtrust shows that the global average Days Sales Outstanding (DSO) sits at roughly 50–54 days, with 44% of companies reporting DSO above 60 days. Top-performing teams, however, collect in 28 days or fewer. The gap between average and excellent is not luck — it is process.
For Swiss businesses, strong AR management delivers:
- Predictable cash flow for payroll, investment, and operations
- Reduced reliance on short-term credit lines
- Stronger financial reporting and audit readiness
- Better relationships with clients through clear, professional invoicing
- Lower risk of bad debt and write-offs
If you are running an SME in Switzerland, AR is one of the most impactful areas of SME financial management you can improve without a large budget or a big team.
The 5 Steps to Managing Accounts Receivable
The core framework is simple: set clear payment terms, invoice on time, track unpaid invoices, follow up with customers, and reconcile payments. When done well, these steps help your business protect cash flow, reduce late payments, and keep cleaner financial records.
Step 1: Set Clear Credit Terms Before You Invoice
Accounts receivable problems often start before the invoice is sent. If your payment terms are unclear, customers may delay payment or interpret the terms in their favor.
Define your payment rules before work begins. This includes the due date, accepted payment methods, late payment conditions, and any deposit requirements. For many B2B transactions in Switzerland, Net 30 is common. However, some businesses use shorter terms or offer early payment discounts, such as a small reduction for payment within 10 days.
Put these terms in every contract, quote, and invoice. Swiss contract law gives businesses room to agree on payment terms with their clients, so use that flexibility to protect your cash flow from the start.
Step 2: Issue Invoices Quickly and Accurately
Your payment timeline only starts when the customer receives the invoice. If your team waits several days or weeks to invoice, your cash collection slows down as well.
Send invoices as soon as you deliver goods or complete a service. Each invoice should include:
- Invoice date
- Due date
- Client name and billing details
- Clear description of goods or services
- VAT details, if applicable
- Total amount due
- Your bank details, including IBAN
- Payment terms and reference number
Invoice errors are one of the most common reasons for payment delays. A missing VAT detail, wrong amount, unclear service description, or incorrect billing address can lead to disputes and slow approval on the client’s side.
Step 3: Track Outstanding Invoices With an Aging Report
An accounts receivable aging report shows which invoices remain unpaid and how long they have been outstanding. It usually groups invoices into aging periods such as:
- 0–30 days
- 31–60 days
- 61–90 days
- 90+ days
This report is one of the most useful tools for managing accounts receivable. It shows where your cash is stuck, which clients need follow-up, and which invoices may become difficult to collect.
Review your aging report weekly. A monthly review is often too late, especially for small businesses that depend on steady cash flow. The longer an invoice stays unpaid, the harder it becomes to recover.
Step 4: Follow Up Consistently and Professionally
Many late payments happen because the client forgot, missed the invoice, or had an internal approval delay. A clear follow-up process works better than random chasing.
A practical follow-up flow can look like this:
- Send a friendly reminder 3–5 days before the due date
- Follow up on the due date if payment has not arrived
- Send a firmer reminder 7 days after the due date
- Send a formal notice after 30 days overdue
Keep every message polite, clear, and documented. In Switzerland, written records can become important if you need to escalate the matter through formal debt collection procedures.
Your tone should stay professional. The goal is to collect payment without damaging the client relationship.
Step 5: Reconcile Payments and Update Your Records
When a payment arrives, match it to the correct invoice as soon as possible. Unmatched payments create confusion and can make your accounts receivable balance look higher than it really is.
Reconcile your bank statements with your AR ledger at least once a week. This helps you:
- Confirm which invoices are paid
- Identify partial payments
- Spot duplicate or incorrect payments
- Keep financial statements accurate
- Prepare cleaner VAT and accounting records
This step matters even more for Swiss businesses that need accurate turnover records for VAT reporting and year-end accounting.
As your invoice volume grows, manual reconciliation can become slow and error-prone. Invoice automation and accounting software can help by matching payments faster, flagging overdue invoices, and keeping your accounts receivable records up to date.
How to Manage Accounts Receivable in Excel
For small businesses and freelancers in Switzerland, Excel remains a practical starting point for AR management. Here is how to set up a functional AR tracker in Excel.
Build Your AR Register
Start with one spreadsheet that lists every invoice you send. Keep the layout clean and easy to update.
Use these columns:
- Invoice number
- Client name
- Invoice date
- Due date
- Amount in CHF
- Amount paid
- Balance due
- Days outstanding
- Status: Open, Paid, or Overdue
You can use a simple formula to calculate how long an invoice has been outstanding:
Formula to calculate how long an invoice
=TODAY()-[Invoice Date]
Then use conditional formatting to highlight overdue invoices. For example, you can mark invoices in red once the due date has passed. This makes late payments easy to spot without reviewing every row manually.
Create an Aging Report Tab
Next, create a second tab for your accounts receivable aging report. This report groups unpaid invoices by how long they have been outstanding.
Use aging buckets such as:
- 0–30 days
- 31–60 days
- 61–90 days
- 90+ days
You can use SUMIF or SUMIFS formulas to calculate the total balance in each bucket. This gives you a quick view of your AR health at any time.
You can also calculate Days Sales Outstanding, or DSO, in Excel:
Formula to calculate DSO
- DSO = (Total Accounts Receivable ÷ Total Credit Sales) × Number of Days in the Period
This helps you understand how long your business usually takes to collect payment after issuing invoices.
Know the Limits of Excel
Excel works well when your invoice volume is still low. For example, it can be enough if you manage a small number of clients and around 50 to 100 active invoices.
But as your business grows, Excel becomes harder to control. Manual data entry increases the risk of errors. It also takes more time to update payment statuses, check overdue invoices, and prepare reports.
Excel also has clear limits. It does not send automatic payment reminders, connect to your bank, or create VAT-compliant invoices by itself. If your business handles more invoices, international clients, or Swiss VAT reporting, dedicated accounting software may be a better choice.
You can also hire a fiduciary to manage accounts receivable, improve reporting, and keep your accounting records accurate.
Managing Accounts Receivable with Invoice Automation
Invoice automation is the single biggest lever for improving AR performance in 2026. According to Billtrust's benchmark data, 92% of payments at top-performing companies now require zero manual intervention. AI-powered AR tools are reducing DSO by an average of six days year-over-year, and 99% of AR teams using AI report faster payment speeds.
Here is what invoice automation does for Swiss businesses:
Automated Invoice Generation and Delivery
Modern accounting platforms (such as Abacus, Bexio, or Sage for Swiss businesses) generate invoices automatically when a sale is recorded, apply the correct VAT rate, and send them to the client by email or through a client portal. Electronic invoice delivery (eDelivery) rates reached 81.76% in 2025, up from 79.65% in 2024. Each automated invoice saves an average of six minutes compared to manual processing — which adds up fast at scale.
Automated Payment Reminders
Automation tools send pre-due and overdue reminders on a schedule you define — without anyone on your team having to remember. You can personalize the tone (friendly for good clients, firmer for repeat late payers) and escalate automatically. This removes the awkwardness of chasing payments manually and keeps your collections consistent.
Automatic Cash Application and Reconciliation
When a payment arrives, automation software matches it to the open invoice using AI — no manual matching required. This keeps your AR ledger accurate in real time and reduces the risk of errors in your Swiss VAT filings. The best systems achieve match rates above 93% at the line-item level.
Real-time AR Dashboards and DSO Tracking
Automated AR platforms give you a live view of your DSO, aging buckets, collection rates, and cash flow forecast, without building anything in Excel. For Swiss SMEs that do not have a dedicated finance team, this is often the most practical path to professional AR management. If you are considering whether to build this capability in-house or delegate it, our guide on how to outsource accounting services in Switzerland walks through the decision in detail.
Best Practices for Managing Accounts Receivable in Switzerland
What are the best practices for managing accounts receivable? Here are the eight practices that consistently separate high-performing AR teams from the rest.
1. Assess Customer Creditworthiness before Extending Credit
Not every client deserves Net 60 terms. Before extending credit to a new customer, you should check their payment history, request trade references, and consider a credit check through a Swiss credit bureau (such as Creditreform or CRIF).
In 2025, credit approval rates dropped to 78% globally as finance teams tightened standards in response to economic uncertainty. Being selective upfront prevents bad debt later.
2. Standardize Your Invoicing Process
Every invoice should look the same and contain the same information. Inconsistent invoices confuse clients and create disputes.
Use a template that includes all legally required information for Swiss invoices
- Your company name and address
- The client's name and address
- Invoice number
- Date & description of services
- VAT number (if registered),
- VAT amount & total due in CHF
- Payment details.
3. Offer Multiple Payment Methods
The easier it is to pay, the faster you get paid. In Switzerland, bank transfer (IBAN) is the standard, but offering QR-bill payment (the Swiss QR-code invoice standard introduced in 2022), credit card, and online payment portals removes friction.
The 2026 AR benchmarks show that ACH-equivalent digital payments now account for 69% of B2B transactions at top-performing companies, up from 65% in 2024.
4. Monitor Your DSO Weekly
Days Sales Outstanding (DSO) is your primary AR health metric. A DSO under 30 days is excellent for Swiss businesses. The global median is 46 days. If your DSO is creeping up, it is a signal to review your credit terms, invoicing speed, or follow-up process. Do not wait for month-end to check — weekly monitoring catches problems early.
5. Separate AR from Sales Responsibilities
Sales teams are incentivized to close deals, not collect payments. When the same person manages both, collections often get deprioritized to protect the client relationship. Assign AR follow-up to a dedicated person or team — or outsource it to your fiduciary. This creates accountability and removes the conflict of interest.
6. Use Data to Predict and Prevent Late Payments
In 2026, AI-powered AR tools can flag clients who are likely to pay late based on historical behavior — before the invoice is even due. This lets you prioritize follow-up, adjust credit terms proactively, or require upfront payment from high-risk clients. Even without AI, reviewing your aging report regularly gives you the data to spot patterns and act early.
7. Know Your Swiss Debt Collection Options
If a client refuses to pay, Switzerland's Federal Debt Enforcement and Bankruptcy Act (SchKG) provides a clear legal path. You can file a Betreibung (debt enforcement request) through the local debt enforcement office for a fee of around CHF 20–50. The debtor then has 10 days to pay or file an objection. This process is well-established and effective, but it works best when you have clear written contracts and documented communication.
8. Audit Your AR Process Regularly
At least once a year, review your entire AR process: credit policies, invoicing templates, follow-up cadence, and reconciliation procedures. An internal audit of your AR function will surface inefficiencies, compliance gaps, and opportunities to automate. This is especially important for Swiss companies subject to ordinary audit requirements under the Swiss Code of Obligations.
AR Management: Excel vs. Automation vs. Outsourcing
Which approach is right for your Swiss business? Here is a quick comparison.
Excel
Best forFreelancers, micro-businesses (<50 invoices/month)
Key benefitFree, flexible, no setup
Main limitationManual, no automation, error-prone at scale
Accounting software (Bexio, Abacus, Sage)
Best forSMEs with 50–500 invoices/month
Key benefitAutomated invoicing, reminders, VAT compliance
Main limitationRequires setup and ongoing maintenance
Outsourced AR (fiduciary)
Best forSMEs and growing companies
Key benefitExpert management, full compliance, no internal resource needed
Main limitationMonthly cost; requires good communication
Common AR Mistakes Swiss Businesses Make
Even well-run businesses make these AR mistakes. Knowing them helps you avoid them.
- Sending invoices late. Every day of delay is a day added to your DSO. Invoice on the day of delivery, every time.
- Not following up on overdue invoices. Silence does not get you paid. A structured reminder sequence is essential.
- Mixing AR with accounts payable tracking. Keep your receivables and payables separate to maintain a clear picture of your cash position.
- Ignoring small overdue balances. Small unpaid invoices add up. They also signal that a client may have cash flow problems of their own.
- Not reconciling payments promptly. Unmatched payments distort your AR balance and can cause VAT reporting errors.
- Extending credit without a credit check. One bad debt can wipe out the profit from several good clients. Assess creditworthiness before you extend terms.
How Fiduciaire Genevoise Can Help You Manage AR
At Fiduciaire Genevoise, accounts receivable management is a core part of our fiduciary services. We handle the full AR cycle for Swiss businesses: from setting up your invoicing process and credit policies, to tracking outstanding payments, managing reminders, and escalating overdue accounts when needed.
Our team of certified accountants and licensed fiduciaries works with SMEs, startups, and international companies across Geneva and Switzerland. We combine local expertise in Swiss contract law, VAT, and debt enforcement with modern accounting tools to keep your receivables clean, your cash flow healthy, and your reporting accurate.
Whether you need a full AR outsourcing solution or just a review of your current process, we can help. Our clients typically see a meaningful reduction in overdue balances within the first 90 days of working with us.
FAQ
Switzerland has no statutory maximum payment term for commercial transactions. Under Article 75 of the Swiss Code of Obligations (OR), if no payment term is agreed, the obligation is due immediately. In practice, Net 30 is the most common B2B payment term. Parties are free to agree on any term, and late payment interest is set at a minimum of 5% per year under Article 104 OR.
Conclusion
Managing accounts receivable well is not complicated — but it does require consistency. The five steps (clear credit terms, immediate invoicing, aging report tracking, structured follow-up, and prompt reconciliation) form the foundation. Layer in the best practices around credit assessment, payment options, and data-driven collections, and you have a system that keeps cash flowing and bad debt low.
For Swiss businesses, the legal framework is favorable: strong payment culture, clear debt enforcement procedures, and flexible contract law. The main risk is not the law — it is letting AR management slip through the cracks of a busy operation.
Whether you manage AR in Excel, use accounting software, or outsource it entirely, the goal is the same: get paid on time, every time. If you want expert support, contact Fiduciaire Genevoise — we are here to help you build a receivables process that works.
Élodie Rochat
Services fiduciaires
Swiss GAAP FER 30: Definition, Application & Updates
Learn what Swiss GAAP FER 30 is, who must apply it, the latest updates, consolidation rules, and key reporting requirements for Swiss groups.
Élodie Rochat
21 July 2026
8 minutes read
Services fiduciaires
Tax Accounting in Switzerland: Definition & Types (2026)
Swiss tax accounting covers three levels: federal, cantonal, and municipal. Learn what it includes, what changed in 2025–2026, and how to stay compliant.
Alice Meier
21 July 2026
9 minutes read
Fiscalité
Audit et contrôles
What Is Goodwill in Accounting? Definition in the Swiss Context
Goodwill is the premium paid above a company's net asset value in an acquisition. See how it's calculated and treated under Swiss rules.
Élodie Rochat
14 July 2026
7 minutes read