Moving Expenses from Excel to Software in 30 Days

For most companies, starting expense tracking in Excel is the right call: the template is free, everyone knows how to use it and it covers the first months well. The problem is usually not Excel itself but the load the file has to carry as the company grows. This article is written for finance and accounting teams in Turkey who still collect expenses in an Excel template. It covers where Excel starts to strain, a four-week migration plan, how to map your columns to the new system and what to do with the old files.

Should expenses be tracked in Excel or in software?

Expense tracking can run in Excel at companies with few employees and a single approver; as approvers, branches and cards multiply, expense software leaves less manual work.

The decision is less about preference and more about volume and control. If a handful of reports arrive each month, one person checks them and nobody uses a corporate card, a well-designed Excel template does the job. If you do not have a consistent template yet, a simple Excel expense form template is a good start, and our expense form example article explains how to fill one in. The migration plan below assumes you are starting from a template like that.

At what point does Excel stop working for expense tracking?

Excel starts to strain when several people enter, approve and transfer the same data to another system. If you recognise several of the signs below, it may be time to plan the switch:

This table is not a case against Excel. Excel remains a strong tool for analysis and reporting; what strains is data collection, control and approval.

For a rough idea of what the switch could save, the savings calculator gives an estimated time and cost figure based on headcount. The results rest on assumptions, so read them against your own numbers. The logic behind the calculation is explained in our expense management ROI guide.

How do you plan the switch in 30 days?

Moving from Excel to expense software becomes manageable when you split four weeks into preparation, setup, pilot and full rollout. The real duration depends on your structure, the complexity of your approval rules and the scope of the ERP integration. The plan below is a framework, not a commitment.

Week 1: Take stock

• Collect the last three months of Excel files and mark which columns are actually filled in.
• Simplify the category list. Which category do the items in the "Other" column really belong to?
• Compare cost centres, project codes and the employee list with the codes in your accounting system.
• Put every written or unwritten rule on one list: meal limits, taxi rules, who approves what.
• Use that list to decide which modules you actually need.

Week 2: Build the structure

• Set up categories, cost centres and users in the system.
• Build the approval flow: who approves, who gets it above which amount, who stands in when an approver is on leave?
• Enter your expense policy rules. Starting with warnings rather than blocks makes it easier for employees to adjust.
• Review the accounting account mapping together with the finance team.

Week 3: Pilot with a small team

• Run one period with real expenses in a single department (example: the sales team).
• Keep the same expenses in Excel for a short while and compare the two results.
• Note the fields employees struggle with and reduce the number of mandatory fields if needed.

Week 4: Open it to everyone and announce the cut-over date

• Open the system to all employees with a short user guide and an introduction session.
• Announce the cut-over date: expenses after this date are accepted only through the new system.
• Archive the old Excel files in a read-only folder.
• Close the first month in the new system and list the steps that did not go smoothly.

Where do the columns of your Excel template go?

Each column in an Excel expense form corresponds to a field or setting in expense software; mapping them in a table before the switch reduces transfer errors. The mapping below is an example for a typical expense claim form, using Turkey's Uniform Chart of Accounts (Tekdüzen Hesap Planı):

Sample entry (example figures): for a 120 TL parking receipt with 20% VAT, the 100 TL net amount is debited to a class 7 expense account and 20 TL to 191 Deductible VAT, while 120 TL is credited to the employee's reimbursement account. Which class 7 account is used depends on the nature of the expense and your company's chart of accounts.

How long should old Excel expense files be kept?

In Turkey, old expense files and the documents behind them should be kept for at least 5 years under tax law and 10 years under commercial law.

• Tax Procedure Law No. 213, Article 253 (Official Gazette: 10 January 1961): books and documents are kept for 5 years, starting from the calendar year after the year they relate to.
• Turkish Commercial Code No. 6102, Article 82 (in force since 1 July 2012): commercial books and documents are kept for 10 years.

An Excel file is not a document in its own right; what matters are the original receipts and invoices or the e-document records. You do not have to move past years into the new system. Keeping old files in an archive that cannot be changed and starting the new period in the new system is a practical approach. Confirm retention periods and the archiving method with your financial advisor (mali müşavir).

How does it work in Masraff?

Masraff expense management covers the steps that run by hand in Excel with the features below. Some of them are separate modules, so decide which ones you need in the first week of the switch.

• Expenses and expense reports: Employees enter expenses in the Web Portal or the mobile app, group them in a report and send it for approval. The report passes period closing, duplicate and mandatory field checks. Who approved or rejected it, and when, is visible in the activity history.
• Expense Policy Engine: Limits by category, time and number of participants are defined; each rule works as a warning or a block.
• Advanced Approval: The approval flow is built with threshold, grade and delegation rules.
• Statement Reconciliation: The corporate card statement is uploaded as an Excel file; lines are matched to expenses by card ID, date and amount, and employees are notified about items with missing receipts.
• Expense creation from invoice QR: An expense is created by scanning the QR code on an e-invoice (e-Fatura).
• Detailed VAT and account assignment: The split between expense, VAT and employee accounts, as well as KKEG (non-deductible expense) scenarios, is defined in the accounting settings.
• Accounting integration: Masraff integrates with more than 20 ERP and accounting systems.

Excel does not disappear either: expense reports can be exported in Excel format, and policy violation reports can be downloaded as Excel. You keep the pivot tables you are used to; the data simply comes from a single source.

Frequently asked questions

What are the advantages of expense software over Excel?

Expense software brings approval, limit checks, duplicate receipt checks and the transfer to accounting into one place. In Excel these steps run through email and manual checks, and errors are often noticed only at month end.

How long does it take to switch to expense software?

The time it takes depends on company size, approval rules and the scope of the ERP integration. The 30-day plan in this article is a framework; for setups with an integration, agree the timeline with your provider.

Should past Excel expense records be moved into the new system?

In most cases, no. Keeping the files from before the cut-over date in a read-only archive and starting the new period in the new system gives a cleaner separation. Confirm retention periods with your financial advisor.

When is an Excel expense template enough?

An Excel template can be enough when headcount is small, there is one approver, no corporate cards are used and few reports come in each month. When one of these conditions changes, go back to the table of signs above.