1 You need to set the required accounting subjects according to your actual business;

2. Prepare accounting vouchers according to the business (bills received and paid);

3. Register the subsidiary ledger according to the account, borrowing direction and amount of the accounting voucher, and calculate the amount and balance of each subsidiary account;

4 according to the accounting data, prepare transfer vouchers for cost sharing, tax accrual, salary accrual and so on;

(Collect costs, calculate production costs, sales costs, etc.)

5. Register the subsidiary ledger and calculate the amount and balance of each subject;

Carry forward the profit and loss account and calculate the profit and loss.

6. Summarize all the accounting vouchers according to the first-level subjects and prepare the subject summary table;

7 Register the general ledger according to the account summary table, and calculate the amount and balance of each account in the general ledger;

8. The general ledger is consistent with the subsidiary ledger;

According to the general ledger data and subsidiary ledger data, prepare accounting statements, tax returns, declare and pay taxes.

----------------------------------

Excel accounting processing is a free and universal accounting template.

Do initialization, determine the subjects to be used, and enter voucher entries.

Journal, subsidiary ledger general ledger income statement balance sheet is automatically generated.

Turn on the computer and download it from the computer's webpage (on this page that Baidu knows).

After downloading, decompress first. When opening excel for accounting treatment, it is best to open it in EXCEL2003 or 2007. To enable macros.

Look at the instructions first. On the third line of the voucher page. .

For reference. .

Note: electronic files need to be backed up frequently and kept on two different media, such as hard disk and USB flash drive, to prevent accidents and avoid data loss. .