Excel financial system, the method of automatically generating cash flow statement. Cash flow statement is automatically generated, but in the entry of vouchers need to be in advance in each cash class voucher entries designated corresponding cash flow items, and Kingdee Ufida Other financial software is the same.
1, input vouchers, if the corresponding account is a cash flow account, in the Cash flow project to select the cash flow items. When a cash Flow item column cell is selected, if it is a cash account, the system automatically pops up the selection window.
2, the use of the software interface of the cash flow statement function, click the corresponding period after the button cash flow table data to automatically update to Excel data files in the cash flow statement.
3, note that the Excel file open to enable macros, the operation interface of the associated software is through the Excel file voucher table in the following button click Open.
4, this Excel financial system can also automatically generate three forms of balance sheet, profit statement. It's simpler than automatically generating a cash flow statement. In addition, the automatic creation of a breakdown of the function
Precautions:
To enable macros, you cannot open them with WPS.