Ledger on Excel is a tool to help businesses manage financial data for many small business, personal accounting, to set, track the books as important as Window, general journal, ledger, cash Book, balance Sheet of arising. In this article, AccNet will guide to bookkeeping on Excelyou can easily follow.
1. Instructions on how to do bookkeeping on excel details
Step 1. Prepared Excel file
Before starting how to do bookkeeping on Excel, you need to prepare an Excel file that the sheet corresponding to each type of bookkeeping to manage. The sheet is important in accounting Excel file:
- General journal – to Record all accounting arise.
- Ledger – detailed tracking of each account accounting.
- Cashbook – cash Management in business.
- Bank books – tracking a transaction through a bank account.
- The balance sheet of arise – Synthetic data from the ledger to check balance.
Note:
- Format file format .xlsx to avoid loss of data when hosted.
- Put the sheet name in English not about to avoid the error formula.
Step 2. Instructions for making general journal in accounting on Excel
General diary notes all financial transactions incurred in chronological order. How to create table general:
B1: Open Excel, select sheet general journal.
B2: Create a data table with the following columns:
| Stock from | Interpretation | Scored ledger | Number account | Amount | Code handle the | ||
| Number brand | Date month | Interpretation | Interpretation | Debt | Have | ||
B3: Enter accounting data in each transaction arises, or apply the formula to automatically calculate, check data accuracy (recipe recorded in the template file, ledger end of the article)
Step 3. How to do ledger accounting on Excel
Ledger tracking details for each account, accounting based on data from the general journal. How to make table ledger accounting on Excel:
B1: Open Excel, select the sheet ledger.
B2: Create a data table with the following columns to set up ledger on Excel:
| Stock from | Interpretation | TK | Amount | Handling code | ||
| Number | Date | Debt | Have | |||
| Balance beginning of the period | ||||||
B3: Proceed to enter accounting data in each transaction to acknowledge full financial information. In addition, you can use Excel formulas to automate the calculation process, helps to control the data accurate and limit errors. (Recipe details are in the file template ledger at the end of the article)
Step 4. Instructions for making the cash Book accounting on Excel
Cashbook track your cash expenses of the business. How to make table cashbook accounting on Excel:
B1: Open Excel, select the sheet cash Book.
B2: Create table data according to the template ledger on Excel with the following columns:
| Stock from | Interpretation | TK | Amount | Handling code | ||||
| Date | Thu | Details | Thu | Details | Survival | |||
| Balance beginning of the period | ||||||||
B3: Enter the accounting profession incurred on the table in the correct time sequence. To optimize the recording window, can apply Excel formulas to help calculate automatically collate data quickly. (Refer to the template file, ledger end of post for details recipe)
Step 5. How to make balance Sheet of arising accounting on Excel
The balance sheet of the biosynthesis of data from the ledger to check the balance of accounting. How to create a balance sheet of arising:
B1: Open Excel, select the sheet the balance Sheet.
B2: Create a data table with the following columns to set up ledger on Excel:
| Code | Number TK | Account name accounting | Balance beginning of the period | Number arises | Final balance | STT | |||
| Debt | Have | Debt | Have | Debt | Have | ||||
B3: Complete accounting information in the data table according to each actual transaction. To ensure high accuracy, you can set up formulas in Excel to automatically synthetic test data. (The specific formula is provided in the template file, ledger end of article)
Step 6. Format & file protection bookkeeping on Excel
- Table format: Use Format as Table for easy data tracking.
- Protect formula avoid editing mistake: Select the cell containing the formula → Ctrl + 1 → Tab Protection → Check Locked → Protect Sheet.
- Save the file: Select File → Save As → format .xlsx or .xlsm if there is macro.
2. Download file template ledger on Excel
AccNet have prepared template file Excel with a full range of bookkeeping so that you can download and use immediately.
The guide to bookkeeping on Excel help accountants track the financial situation of the business. Using formulas such as SUMIF, IF, VLOOKUP, you can automate the process of data entry, collation of data. Hope this guide help you understand how to set ledger on Excel professional!
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: