At present, not well enterprises use software accounting professional to manage revenues and expenditures/sales revenue. Therefore, file revenue and expenditure management business in Excel (aka file manager sales revenue) below is designed to be simple, easy to use standard accounting model circular 200, helps you keep track of financial transactions daily, fast print receipts – payment receipt with just a few taps. Here are detailed instructions from AccNet.
1. Target file manager sales revenue in Excel
- Record business income and expenditure, cash or bank deposits
- Automatically receipt or payment receipt standard form circular 200
- Print fast, don't need to enter manually the content
The file structure to manage sales in Excel, including 4 sheet:
| STT | Sheet Name | Role |
| 1 | LAST UPDATE THU | Enter the entire cash receipts |
| 2 | TH CHI | Enter the entire voucher to spend money |
| 3 | Phieu thu | Auto show featured collect (retrieve data from the last sheet TH THU) |
| 4 | Phieu chi | Auto show coupons, cost (retrieving data from the last sheet TH CHI) |
2. Instructions how to manage income and expenditure business in Excel
Sheet “TH AUTUMN” – Synthetic collect cash
Sheet “TH INCOME” in the income and expenditure management in business will be recorded in the cash receipts / switch account into business
Data sheet:
| Stock from | NAME | ADDRESS | INTERPRETATION | SL | ACCOUNT INCURRED | Symbol | Number | Date | Name | MSThuế | Items | Business | Tax | Tax | ||||
| Number | Date | Month | Year | CT | HAVE | AMOUNT | invoices | Invoices | Invoices | the seller | the seller | number | performance | VAT | ||||
How to fill each column:
| Columns | Content | Entering for example |
| A | Number of vouchers | Enter the order number or code private |
| B-C-D | Day – Month – Year | Enter manually the correct format number (EXAMPLE: 01 - 04 - 2024) |
| E | Name payer | Nguyen Van A |
| F | Address payer | 123 Le Loi, Q1 |
| G | Interpret the reasons of | Payment of the invoice number 123 |
| H | Number (if needed, for example goods) | 1 |
| I | Account There (where to get money) | 111 (Cash), 112 (deposit NH) |
| J | Amount | 100000000 |
| K–R | Bill information, tax (if have) | MST goods, tax rates, tax, VAT,... |
Note:
- Don't need the recipe – just enter manually
- After entering the new line, receipt automatically updates according to that line
Sheet “TH CHI” – the Aggregate cash expenditures in file manager sales revenue
Sheet “TH CHI” in file management revenue and expenditure by business Excel recorded the payments to suppliers, employees, billing,...
Data sheet:
| Stock from | NAME | ADDRESS | INTERPRETATION | SL | ACCOUNT INCURRED | Symbol | Number | Date | Name | MSThuế | Items | Business | Tax | Tax | |||
| Number | Date | Month | CT | DEBT | AMOUNT | invoices | Invoices | Invoices | the seller | the seller | number | performance | VAT | ||||
How to fill each column:
| Columns | Content | Entering for example |
| A | Number of vouchers | 13.02 (possible date) |
| B-C | Day – Month | VD: 25 – 02 |
| D | They name the person receiving the funds | Tran Van B |
| E | Address the recipient | ABC corporation |
| F | Paraphrase content details | Buy goods |
| G | Number | 2 (if the goods) |
| H | Financial Debts | 156, 1331 (separated by comma) |
| I | Amount | 5.500.000 |
| J–R | Tax code of goods, works,... | For more votes have with the bill or work |
Note:
- Column H (Debit account): can record as many accounts as 156 (goods), 1331 (tax deductible)
- Similar to last update THU, more votes will automatically get the last line
Sheet “PHIEU THU” – automatically print receipt in the revenue and expenditure management business in Excel
- Has the function of automatic complete content from the last line in the TH THU
- Sheet correct form according to circular 200 – Model number 01-TT
You don'T need to enter anything in the sheet of this. When you want to print:
- On sheet “TH-AUTUMN” → enter the data line new
- To “PHIEU THU” → information has display available
- Press Ctrl + P to print
Sheet “PHIEU CHI” – automatically print payment receipt
- Automatically display the content from the last line in the TH CHI
- Sample standard accounting circular 200
How to print: like receipts in file manager sales revenue in Excel, just enter the data in “TH CHI”, do not need to manipulate anything.
3. Important note when using file revenue and expenditure management business in Excel
- Only enter data in “TH THU”, “TH MORE”
- Absolutely do not enter or delete anything in the sheet “PHIEU THU”, “PHIEU CHI”
- If you want to edit the template in, so make a copy before editing
- When printing coupons, remember to check printer, paper (usually A5)
With file revenue and expenditure management business in Excel this, you don't need deep understanding of accounting or Excel advanced may still easy to use. Data entry clear form in automatic operation minimalist will help you save time. If the business you're looking for a management solution sales revenue quickly, more professional Excel file, the software AccNet Cloud (Top 1 should buy) main is the ideal tool to get started.
CONTACT INFORMATION:- ACCOUNTING SOLUTIONS COMPREHENSIVE ACCNET
- 🏢 Head office: 23 Nguyen Thi huynh, Ward 8, Phu Nhuan District, ho chi minh CITY.CITY
- ☎️ Hotline: 0901 555 063
- 📧 Email: accnet@lacviet.com.vn
- 🌐 Website: https://accnet.vn/
Theme: