Choose an Excel or CSV template to suit your company, store, personal needs, or daily/monthly reporting requirements in the section below. If using for accounting records, check your current accounting system before selecting a template.
Need to download the file immediately? Select Internal templates include receipts and payment vouchers., store model or daily/monthly report. Other administrative templates and accounting forms are separated below.
1. Which type of income and expenditure ledger should I choose?
The important step before uploading the file is to identify the template to be used for. internal management give accounting work. The administrative file can be customized according to operational needs; accounting books and documents must be reconciled with the accounting system currently applied by the unit.
| Demand | Suitable model | Target audience | Note |
|---|---|---|---|
| Track overall income and expenses. | Company income and expense management Excel template | Accounting, finance department, small and medium-sized enterprises | Admin template, with the option to add departments/projects. |
| Track expenses by department | Excel template for managing internal income and expenses. | Internal accounting, finance and administration department | There should be a person making the suggestion, the department, and the status. |
| Managing revenue and expenses at the point of sale. | Excel template for managing store revenue and expenses. | Stores, retail chains | It is necessary to compare by shift and payment method. |
| Track sales revenue and expenses. | Sales and Expense Income/Expense Excel Template | Sales Department, Stores | You should attach the order code and sales channel. |
| Link transactions to receipt/payment voucher numbers. | CSV template for integrated receipts and payments, including receipts and payment vouchers. | Accounting, Finance Department | Suitable for source data management |
| Compile data by day/month | CSV template for daily/monthly income and expenditure reports. | Accountants, managers, business owners | Suitable for basic management reporting |
| Track cash funds according to accounting standards. | S07-DN, S04a-DNN or S2d-DNSN | Businesses operating under corresponding regulations | The correct accounting method must be determined before use. |
| Managing personal income and expenses. | Personal income and expenditure Excel template | Individuals, households | Not a business accounting ledger. |
2. Free downloadable Excel/CSV templates for managing income and expenses.
Check before entering data: Company files use the .xls format; internal, store, sales, and personal files use .xlsx. Sales files are data frames and do not contain pre-set formulas. For files with formulas, save a copy and test a few transactions before using them. CSV files only store data in tabular form; you need to set up formulas in Excel if you want to manually calculate balances.
The files in this section are for tracking and management purposes. Data fields can be added or removed depending on the scale, departmental organization, and reporting needs.
2.1. Sample Excel file for managing company income and expenses.
This company income and expenditure management template is suitable for tracking cash inflows and outflows by day, month, or reporting period. For businesses with multiple units, it's advisable to add departments, projects, expense centers, or responsible individuals to facilitate analysis.

This company file is an outdated reference and needs to be revised before use. The file contains 5 sheets summarizing income, expenses, and printed vouchers; the date on the voucher is currently set to 2019/2010, and the pre-printed basis is Decision 15/2006. The function to convert numbers to words depends on an external add-in and has formula errors; some payment voucher information cells need to be checked for references. Do not enable add-ins from unknown sources to fix errors. If you need to record income and expenses immediately, prioritize the CSV template below and set up the appropriate formula yourself; if creating accounting documents, refer to the applicable regulations in section 3.
Download the old company file for reference (.xls)
2.2. Sample Excel file for managing internal revenue and expenses.
Internal expense records should be suitable for expenses incurred by departments, projects, or operational activities such as office supplies, travel, hospitality, and other internal expenses. In addition to the amount, the requester, responsible person, department, and processing status should be noted.

Download internal expense report template
For chain stores with many small expenses, you can refer to the following article for more information. Petty Cash and store operating expense management.
2.3. Sample Excel file for managing store revenue and expenses.
Stores typically have many transactions throughout the day and multiple payment methods. The tracking file should support categorization by shift, employee, point of sale, and source of funds for easy comparison with actual cash, POS, or bank statements.

Download store expense and revenue form
2.4. Sample Excel file for managing sales revenue and expenses.
The sales revenue and expense form helps link revenue with order-related expenses such as shipping, discounts, or commissions. You can add order codes, customers, sales channels, and responsible employees to analyze each revenue source.

Download sales receipt and expenditure template
2.5. Sample Excel file for managing personal income and expenses.
Personal templates help track income, expenses, and savings by day or month. Expenses can be divided into categories such as housing, food, transportation, health, education, entertainment, and savings to compare budget with actual spending.

Download personal income and expenditure template
2.6. CSV template for integrated revenue and expenditure records, including receipts and payments.
This template is suitable when accountants need a source data table that can link transactions with receipt/payment voucher numbers, recipients, debit/credit accounts, departments, original documents, and processing status. The CSV structure is also convenient for importing, processing with Power Query, or transferring data to other systems.
Download the CSV file containing integrated receipts and payment vouchers.
2.7. CSV template for daily and monthly income and expenditure reports.
This report template helps summarize the opening balance, revenue categories, expense categories, revenue-expense difference, and closing balance. Businesses can use this file as a basic management report or as a source for daily/monthly dashboards.
Download the CSV file of daily/monthly income and expenditure reports.
If you need more templates for accounts receivable management, financial planning, cash flow, and other management tables, see the suite. 18 Excel file templates for corporate financial management.
3. Sample accounting books and documents related to revenue and expenditure in 2026
This section is separated from the administrative files above because the accounting form depends on the system the entity is using. The CSV files are provided to support data entry and processing according to the main fields of the form; before using them as official accounting books or documents, they must be compared with the original documents and the entity's procedures.
3.1. Businesses applying Circular 99/2025/TT-BTC
Circular 99/2025/TT-BTC provides guidance on the accounting regime for enterprises, effective from... January 1, 2026. For cash receipt and disbursement operations, the relevant forms include S07-DN – Cash Book, S03a1-DN – Cash Receipt Journal, S03a2-DN – Cash Disbursement Journal, along with Receipt Vouchers and Payment Vouchers.
| Sample | Purpose | Download file |
|---|---|---|
| S07-DN – Cash Register | Tracking documents, explanations, receipts, disbursements, and cash balances. | Download CSV S07-DN |
| S03a1-DN – Cash Collection Log | Record the cash collection transaction and the corresponding account. | Download CSV S03a1-DN |
| S03a2-DN – Cash Disbursement Journal | Record the cash disbursement transaction and the corresponding account. | Download CSV S03a2-DN |
| 01-TT – Receipt | Record the actual amount of money deposited into the fund and related information. | Download the CSV file for Receipt 01-TT |
| 02-TT – Payment Voucher | Record the actual amount disbursed and related information. | Download CSV Payment Voucher 02-TT |
See Circular 99/2025/TT-BTC in the Government Gazette.
3.2. Small and medium-sized enterprises are applying Circular 133/2016/TT-BTC.
Small and medium-sized enterprises (SMEs) currently applying Circular 133/2016/TT-BTC should also read Article 3 of Circular 46/2025/TT-BTC. Clause 1 of Article 10, after amendment, allows for the design or adjustment of accounting voucher and ledger templates according to needs, provided they meet the regulations on content and verifiable/comparable capabilities. When amending or supplementing, enterprises must issue accounting regulations in accordance with Clause 4; simply renaming the file or title and using it as the official ledger is not sufficient.
See Article 3 of Circular 46/2025/TT-BTC
For cash book records based on the Circular 133's template system, the commonly referenced template is: S04a-DNN.
Download CSV S04a-DNN – Cash Register
Circular 133/2016/TT-BTC published in the Government Gazette.
3.3. Micro-enterprises apply Circular 58/2026/TT-BTC.
Circular 58/2026/TT-BTC provides guidance on accounting procedures for micro-enterprises and is effective from... 01/07/2026. In the accounting system there is Form S2d-DNSN – Cash Register; Micro-enterprises within the scope of application may use this ledger to track their cash receipts and disbursements as prescribed.
The list of related documents also includes: Receipt 01-TT and Payment Voucher 02-TT. It is necessary to use the correct set of forms according to the applicable regulations instead of the default forms provided in Circular 99.
| Sample | Purpose | Download file |
|---|---|---|
| S2d-DNSN – Cash Ledger | Tracking documents, interpretations, and receipts/deposits, and disbursements/withdrawals. | Download CSV S2d-DNSN |
| 01-TT – Receipt | Support for recording cash deposits within the applicable scope. | Download the CSV file of Receipt Form TT58 |
| 02-TT – Payment Voucher | Support for recording cash disbursements within the applicable scope. | Download the CSV file of Payment Voucher TT58 |
See Circular 58/2026/TT-BTC in the Government Gazette.
3.4. Household businesses and individual businesses
Household businesses and individual business owners should not use the default accounting templates of enterprises. Circular 152/2025/TT-BTC guiding accounting for household businesses and individual business owners is effective from... January 1, 2026. When it is necessary to maintain proper record-keeping, it is advisable to directly refer to the system of forms designed for this group of people.
4. What data columns should a standard income and expenditure ledger include?
For administrative files, the data structure should be sufficient to record transactions, categorize them, trace responsible parties, and reconcile them with the source of funds or documents. It's unnecessary to put every field in the same table unless it serves a management purpose.
| Data group | Suggestion column | Purpose |
|---|---|---|
| Time | Transaction date, document date, reporting period | Filtering and synthesis over time |
| Document | Receipt number, transaction code, invoice/related document. | Data source tracing |
| Classify | Type of income/expenditure, item, category | Analysis based on the nature of the transaction |
| Cash flow | Revenue, expenses, balance | Track currency fluctuations. |
| Object | Customers, suppliers, payers/recipients | Comparison by subject |
| Organization | Departments, branches, projects, cost centers | Analysis by responsible entity |
| Pay | Cash, bank account, card/wallet, other methods | Compare by source of funds |
| Control | Proposer, approver, status | Monitor the processing procedure. |
| Proof | Link to documents, invoice code, receipt | Post-audit support |
5. How to create an income and expenditure statement in Excel or CSV
-
Define the scope of monitoring.
Determine whether the file is for personal use, a store, a department, or the entire business. If the file is for accounting purposes, determine the accounting system before selecting a template.
-
Standardize the revenue and expenditure categories.
Create a unified catalog for income/expense types, departments, projects, and payment methods. This prevents the same item from being entered under multiple different names.
-
Each line is designed to correspond to a transaction.
Avoid merging cells or inserting total rows in the middle of data ranges. A table structure makes filtering, aggregating data using PivotTables, Power Query, or importing to other systems more convenient.
-
Set up the remainder formula

Illustrate how to calculate cash balance in the example; compare the result with the actual cash counted. For example, tracking cash funds separately: At the beginning of the day, the cash balance was 2,000,000 VND, sales revenue was 1,500,000 VND, and expenses for purchasing supplies were 800,000 VND, resulting in an ending balance of 2,700,000 VND. If the inventory count shows only 2,600,000 VND remaining, the difference of 100,000 VND needs to be identified from the supporting documents and individual transactions, instead of simply adjusting the balance to match.
When transferring funds between the cash fund and the bank account of the same entity, correctly record both accounts and identify it as an internal transfer. When summarizing the entire entity's cash flow, separate this transfer to avoid including it as an external receipt or disbursement.
Basic test formula:
Ending balance = Beginning balance + Total revenue – Total expenses -
Separate the input area from the calculation area.
Formula cells should be protected or placed in a separate area to prevent overwriting. Date, amount, and category code fields need consistent formatting.
-
Periodic reconciliation
Compare the actual cash balance with bank statements, POS records, receipts/payment vouchers, invoices, or related documents. Any discrepancies should be identified and addressed within the period.
6. Checklist for controlling income and expenditure files before finalizing figures.
- Each transaction has a code or document number for tracking purposes.
- The revenue/expenditure categories have been standardized.
- The remainder formula is not overwritten or skipped.
- The fund balance is reconciled with the actual cash.
- Deposit data is compared with statements when necessary.
- Internal transactions can be conducted within departments/projects if responsibility allocation is required.
- The relevant documents can be retrieved from the transaction.
- The file has backup rules and version management.
- If used as an accounting ledger, it has been reconciled with the applicable accounting system.
For advances and reimbursements, it is advisable to also track the request status, the amount advanced, the amount to be reimbursed, and the settlement documents. (See reference) Advance payment and reimbursement procedures in businesses.
If businesses need to standardize spending limits, approval authority, and principles, they can refer to the following. Sample corporate financial regulations.
7. When is Excel/CSV still suitable, and when is a centralized management system needed?
Excel or CSV are suitable when the number of people working with the data is small, the process is simple, and the data can be aggregated and checked manually. Bottlenecks often arise when the file has to simultaneously process expenditure requests, approvals, budgets, payments, documents, and reconciliation.
| Element | Excel/CSV is often suitable when | A centralized system should be considered when |
|---|---|---|
| User | Fewer users, simpler editing options. | Multiple roles and multiple levels of approval |
| Data | One or more sources | Multiple departments, branches, and payment methods. |
| Document | It is possible to link and check manually. | Distributed documents are stored in email, messages, folders, or multiple systems. |
| Budget | No complicated limits | Budget control is needed by department/project. |
| Approve | Short processing thread | There are various conditions and approval levels. |
| Reconciliation | Moderate weight | Post-auditing is time-consuming or often results in discrepancies. |
To expand from recording income and expenses to managing budgets and costs, see more. cost management methods in businesses.
8. Manage payment requests and supporting documents after the revenue and expenditure recording step.
The income and expenditure ledger helps track cash inflows, outflows, and balances. When multiple people request expenses or the documents originate from various sources, businesses need to further track the purpose of the expense, the approver, the limit, and proof of payment so that accountants can verify each transaction.
Bizzi Expense Pay supports the management of request, approval, payment, and document reconciliation flows. Businesses can learn how to link expense requests, payment transactions, invoices, and receipts on the platform. Bizzi expense and payment management solutions page.
When discussing the scope of implementation, it's important to prepare information on the number of people requesting the expenditure, the approval process, the payment source, and the ongoing reconciliation steps. This information helps identify areas requiring centralized management in addition to the existing income and expenditure file.
9. Frequently Asked Questions about the Income and Expense Ledger Template
What columns are needed for a basic Excel expense and income ledger template?
A basic management table typically includes the transaction date, document number, description, type of receipt/payment, amount received, amount paid, and balance. For businesses with multiple units, it's advisable to add departments, projects, responsible persons, payment methods, and document links.
Is an internal income and expenditure file considered an accounting ledger?
Not default. Internal management files can be customized to operational needs. If used as an accounting ledger, it must comply with accounting laws and the accounting system currently applied by the entity.
Which cash book template should businesses using Circular 99 of 2026 use?
For the corporate accounting system under Circular 99/2025/TT-BTC, you can refer to the restructured CSV form S07-DN – Cash Book. Cash receipts and disbursements transactions also involve S03a1-DN – Cash Receipt Journal and S03a2-DN – Cash Disbursement Journal.
Can small and medium-sized enterprises use S07-DN?
It is necessary to determine the accounting system that the business is applying. If the business applies Circular 133/2016/TT-BTC, the cash book usually refers to Form S04a-DNN. It is also necessary to refer to the relevant amendments, including Circular 46/2025/TT-BTC on the chart of accounts.
Which forms should micro-enterprises be aware of from July 1, 2026?
Circular 58/2026/TT-BTC takes effect from July 1, 2026. The accounting system includes Form S2d-DNSN – Detailed Cash Register; and the Receipt Voucher 01-TT and Payment Voucher 02-TT for micro-enterprises, according to their scope of application.
Can the CSV file downloaded in this article replace the official legal form?
No. CSV files are restructured according to key data fields for convenient data entry and processing. CSV files do not fully reproduce the print layout, signatures, and presentation style of the official form; when used for accounting purposes, they must be compared with the original document.
When should a business switch from Excel to a cost management system?
Considerations should be taken when multiple people are working simultaneously, data is scattered across multiple departments or branches, processes have multiple levels of approval, budget/limit control is required, or transaction reconciliation with documentation is time-consuming.
