About this template
Expense Reporting & Receipt Register 2026/2027 – Excel, Word and PDF
Does the company need an expense report, receipt register, and clear management of employee reimbursements? This complete document package helps Swedish small businesses, associations, and finance departments collect supporting documents, document approvals, track actual payouts, and identify missing receipts and duplicates.
You get a functional Excel template for expense reporting with seven worksheets, six professional editable Word documents, and six corresponding searchable PDF files. The content is primarily in Swedish with a separate English work form and an English quick guide for use under Swedish conditions.
What is included in the package
| Delivery | Function | Format |
|---|---|---|
| Expense report & reimbursement request | Input fields for employee, expense, receipt ID, business purpose, claimed amount, reviewer's decision, and payment reference. | Word + PDF |
| Routine for expenses, receipts & approval | Internal instruction on roles, mandates, receipt control, classification, bookkeeping, responsibility, and discrepancies. | Word + PDF |
| Receipt log & supporting document control | Register form and checklist that links every expense to a receipt or invoice. | Word + PDF |
| Reconciliation of expenses & reimbursements | Log for approved amounts, executed payments, open items, and documented discrepancies. | Word + PDF |
| Employee Expense Claim & Approval | English work form adapted to Swedish employer and accounting practice. | Word + PDF |
| Detailed user guide | Step-by-step, common errors, legal limitations, primary sources, and English instructions. | Word + PDF |
| Expense register & Reimbursement tracking | Seven Excel sheets with automatic summation of approved, paid, and remaining amounts. | Excel (XLSX) |
A total of 13 delivery files in one ZIP: 6 DOCX, 6 searchable PDF, and 1 XLSX. The files are for local, editable use without a subscription.
Excel template for expenses, receipts, and reimbursements
- Overview: claimed and approved amounts, payouts, remaining approved reimbursements, receipt checks, and warning flags.
- Expenses: up to 120 case rows with person ID, supplier, expense category, receipt reference, amount, status, and manually decided reimbursement amount.
- Payments: up to 200 actual payment transactions; multiple partial payments for the same case can be registered.
- Personnel: up to 50 internal person IDs with department and manager, without the need for personal identity numbers or bank account numbers.
- Reconciliation: verification of approved amounts against registered payouts and actual bank records.
- Controls: 60 review rows for discrepancies, actions, and responsibility.
- Instructions: practical fill-in guide and links to official legal sources.
Excel has built-in checks for duplicate case IDs, missing receipts, amounts not decided, payouts without a case, and overpayments. The amount calculations work even when an approved reimbursement is paid out on several occasions.
How to use the documents
- Determine internal routine: establish mandates, amount limits, and how supporting documents are submitted and archived.
- Register employees: use internal person IDs and data-minimized information.
- Register the case: enter a unique case ID, purchase date, cost, business purpose, and receipt reference.
- Review and classify: check receipts and make a manual assessment regarding outlay or cost reimbursement according to current law.
- Decide reimbursement: the authorized reviewer selects Approved, Rejected, or Under Review and enters the approved amount.
- Track payouts: register only completed payments with a unique transaction ID and amount.
- Reconcile and archive: follow discrepancy flags and reconcile supporting documents against bank, payroll, and accounting.
Outlays and cost reimbursements – the difference is important
The Swedish Tax Agency distinguishes between outlays on behalf of the employer, where the underlying cost is the company's, and cost reimbursements for expenses that instead relate to the employee. This classification can affect which documents are considered vouchers, the right to deduct VAT, and any tax handling. For example, an original document received digitally by the employee on behalf of the company must be preserved according to the Accounting Standards Board's rules.
Sources: Swedish Tax Agency – cost reimbursement and outlays · Accounting Standards Board – archiving of receipts · Accounting Act (1999:1078).
Typical areas of use
Personal expenses in small businesses, purchase of office supplies and work tools, paid company expenses, receipt compilation in associations, internal approval, reimbursement requests, and administration of repayments. Travel per diems and mileage allowances normally belong to a separate travel expense process.
Common questions about expense reporting
Is this the same product as travel expense and per diem?
No. Travel Expense, Per Diem & Mileage Allowance focuses on business travel and tax-free standard amounts. This package focuses on ongoing purchases and company expenses, receipt management, approval, and actually paid reimbursements.
Can I register several payouts for the same expense?
Yes. Add each actual partial payment with the same case ID; Excel shows the registered total amount and remaining approved amount.
Does Excel automatically calculate VAT and tax-free amounts?
No. Classification and right to deduction require individual review of the receipt, the nature of the purchase, and applicable rules.
Must I save the receipts?
Yes, supporting documents that constitute accounting information must be preserved according to the Accounting Act and the Accounting Standards Board's rules. An Excel register does not replace the original supporting document.
Can I use the package in English?
An English form and an English quick guide are included. Other main templates are in Swedish and adapted to Swedish conditions.
Does it include a digital accounting or payment service?
No. These are editable documents and Excel registers for internal control and follow-up, not a banking, payroll, or accounting system.
Format and delivery
Digital ZIP delivery with Word, PDF, and Excel. No physical product is sent. The files can be edited locally; for automatic Excel calculations, Microsoft Excel or a compatible spreadsheet program is required. Shopify Digital Products must display the associated ZIP file before automatic delivery can be considered complete.
