What are the Excel formats and accounting statements of account books?

1. Excel format of account books: the standard file format is XLS.

Accounting statements:

Second, do journal operations with EXCEL tables:

0 1. First, open a blank form in EXCEL.

02. Journals can be divided into cash book and deposit journals. Here, take the cash book as an example. Enter the word cash book in the cell in the first column of the first row.

03. Enter the date, description, debit, credit and balance in the second line.

04. Click Format in the menu bar above, then click the column, and then click the column width to widen each column, so that it is easy to enter enough words and numbers.

05. Select the cells from A to E in the first row, then click the "Merge and Center" button in the menu bar above, and put the words "Cash Book" in the middle.

06. Select five cells with words in the second row, and then click the center button on the menu bar above to put the words in the middle of the cells. This looks beautiful.

07. Select all the cells from line 2 to line 23 and from column A to column E, then click the Tian Zi border in the menu bar and add borders to these cells, and the journal format is designed. When bookkeeping, fill in the date and summary, and then fill in the debit amount. The balance is equal to the previous balance plus the debit of the day, and then the credit of the day is subtracted, and the calculated figure is the balance.