Formats for Bank Statements in Excel

For importing bank statements from Excel to Tally, there are two kinds of dynamically usable Excel templates.

Bank statement with two columns
Bank Statement — 1 column

Determine which industry you want to rewrite data for.
Enter to update the information.

Mandatory Information

The sheet should be labelled “Bank.”
The header of the sheet should follow one of the two templates provided.
The name, caps, small, and space in the header should not change.

Header and Data Mandatory Column Validations

A mandatory column is a date, which must be in date format.
Details or Description is written information based on bank statement information.

AccountName is the bank ledger that will be used to reconcile the imported bank statement.
If necessary, remarks and additional information may be included.
Chq No, you may use any reference or a blank.
Fill out BillName if necessary to link a bill referred to the correct ledger.
Fill out CostCentre if necessary to map each cost centre to its corresponding ledger.

Read More about Formats for Bank Statements in Excel