Current location - Loan Platform Complete Network - Loan consultation - How to use excel to make handbooks
How to use excel to make handbooks
Manual has two meanings: one is a diary or weekly diary with pictures, which is obviously not suitable for excel.

Another meaning is accounting books, which are generally divided into chronological accounts and general ledger.

Chronological accounts are also called running accounts. Design a table showing date, voucher number, content, account, debit (in) amount, loan (out) amount and balance respectively. Among them, the account can be omitted, and the balance design is automatically calculated.

The sub-ledger is designed according to the double-entry bookkeeping principle, and has two important tables: 1, and the chart of accounts, including account code, account name, opening balance, current debit and cumulative debit and cumulative credit.

2 Accounting entry table, namely accounting voucher entry table, with items such as month, voucher number, content, subject code, name, loan amount and loan amount.

According to the above two tables, the balance sheet income statement is automatically generated and the voucher is printed.