Table of Contents
In most companies, the expense file that goes to accounting at month end is an Excel sheet: receipts are entered row by row, totals are added up and VAT is split out. Kept properly, the sheet takes accounting minutes to process; kept carelessly, the same receipt is entered twice, the VAT total does not add up and an email chain about missing details begins. This article explains which columns an expense list should have, how to keep it in Excel and what to check before sending it to accounting. The document types, tax ID (VKN) and VAT rules described here are Turkish rules, so adapt the columns to your own country's requirements.
What is an expense list and how is it different from an expense form?
An expense list is a table in which the receipts and invoices collected over a period each take one row; an expense form describes a single expense or a single claim.
An expense form is usually a document an employee fills in for one expense or one trip. It is approved, signed and sent to accounting together with the supporting document. An expense list, by contrast, is a periodic log: every receipt collected over a month, a project or a trip goes into the same table. That is why it is often called a "receipt list" or "receipt log".
The purpose of the list is to give accounting a summary that is ready to post. Each row should match one document, and totals should be checkable by category and by VAT rate. The receipt itself also has to carry certain details, such as the seller's name, tax ID, date and VAT amount.
Which columns should an expense list have?
An expense list should have at least date, document details, seller and tax ID, category, cost center, VAT breakdown, total amount and payment method columns.
| Column | What goes in it | Why it is needed |
|---|---|---|
| Date | The date on the document | Sets the period and the expense date |
| Document type | Invoice, e-Fatura, e-Arşiv invoice (Turkish e-archive invoice), receipt, gider pusulası (Turkish self-billed expense voucher) | Shows which document the entry relies on |
| Document no | The document's series and sequence number | The main key for catching duplicate entries |
| Seller / VKN | Seller name and tax ID number (VKN) | Invoice verification and supplier matching |
| Description | A short description of the expense | Helps the accountant understand the expense |
| Category | Travel, accommodation, meals, office supplies and so on | Mapping to the chart of accounts |
| Cost center | Department or unit | Cost allocation and budget tracking |
| VAT rate | The rate on the document | Checking VAT totals by rate |
| VAT amount | The VAT on the document | Separating deductible VAT |
| Net amount | Amount excluding VAT (tax base) | The expense entry |
| Total | Amount including VAT | Comparison with the document total |
| Payment method | Company card, personal card, cash, advance | Reimbursement and card statement matching |
| Project | Project code, if any | Project-level cost tracking |
Not every company needs every column; the project column can stay empty in a company that does not work by project. But do not give up the document number and tax ID columns, because most of the checks in the next section depend on them. Whether a document is accepted as an expense and whether its VAT is deductible depends on Turkey's Tax Procedure Law No. 213 (Vergi Usul Kanunu) and VAT legislation; confirm the treatment for your company with your tax advisor (mali müşavir).
How do you keep an expense list in Excel?
In Excel, an expense list is kept with one row per document, fixed columns, drop-down categories and monthly tabs, with totals taken from a pivot table.
One row per document. If a receipt carries more than one VAT rate, opening one row per rate instead of merging them into a single row makes the VAT check easier. Never combine several documents in one row; the document number column loses its meaning.
Drop-down lists. Link the category, cost center, document type and payment method columns to drop-down lists with Data Validation. With free text, "Meals", "meals" and "Meal expense" look like three different categories and the totals break.
Formula columns. Instead of typing the net amount and VAT amount by hand, calculate them from the total and the VAT rate, or the other way round: enter the values from the document and check the total with a formula. Whichever method you choose, the figure on the document and the figure in the table must be the same.
Monthly tabs. Open a separate tab for each month and keep every tab in the same column layout. That makes it easy to combine all the tabs at year end.
Pivot summary. On a separate summary tab, build a pivot table to total by category, cost center and VAT rate. Accounting can review the entries quickly from this summary.
If you want a ready-made starting point, browse the templates and calculators in Masraff's free tools and extend them to the list's columns.
What should you check before sending it to accounting?
Before an expense list goes to accounting, check it for duplicate document numbers, missing tax IDs and a consistent VAT total.
- Duplicate document number: If the same seller and the same document number appear on two rows, the same receipt has most likely been entered twice. Highlighting duplicate values with Conditional Formatting in Excel shows this quickly.
- Missing tax ID: If the tax ID is blank on an invoiced expense, the document cannot be verified. Filter these rows and complete them from the document image.
- VAT total: The net amount plus the VAT amount must equal the total column. Add a check column showing the difference and review every row where it is not zero.
- Date range: Note separately any documents that fall outside the list's period.
- Document match: Does the number of rows match the number of attached documents, and does every row have an image?
Running these checks in the same order every month noticeably reduces the questions that come back from accounting.
When does an Excel expense list stop being enough?
An Excel expense list starts to fall short when the number of documents grows, when several people enter data into the same file and when an approval step is needed.
A few dozen receipts a month from a handful of employees are easy to manage in Excel. The problems start at scale: every employee sends their own file, column layouts drift apart, receipt images are scattered across emails and the file does not show who approved what. The duplicate check is no longer done on one sheet but becomes a job spread across dozens of files.
At that point it makes sense to move to a system that captures the receipt at the moment of spending and runs the checks as the entry is made. For example, Masraff checks for possible duplicate expenses by date, amount and currency; category, merchant, receipt number and tax ID can optionally be added to that check. When a likely duplicate is found, the report can be blocked from being submitted. That way, much of the manual month-end check in Excel is already done while the expense is being entered.
Conclusion
A good expense list comes down to one row per document, a fixed column layout and checks run in the same order every month. Excel does the job at small volumes; as the number of documents and people grows, you need to collect receipts in one place and automate the checks. See the receipt management solution for collecting receipts, and the expense management page for the whole expense process.