Cash Account

An Excel file that teaches how to perform Cash Account operation.

Excel Source: Cash Account

Date, description and document number columns are created. Entry and exit amounts are written in separate fields. The balance column is updated with the formula. Certain periods are monitored with filters. The summary section shows daily totals.

Hope it is useful.