Here’s how you can import your bank data into Excel, whether it’s in a PDF or another format


1. Exporting Your Bank Statement (PDF or Excel Format)

  • Log in to your bank's online banking portal.
  • Download your bank statement, which might be available in PDF or Excel format.

  •  Formatting the Data in Excel

    You need to organize the Excel sheet into 4 key columns:

    • Date: Enter the transaction date in the correct format (e.g., DD/MM/YYYY).
    • Description: Include details about the transaction (e.g., merchant name, bank charges, etc.).
    • Type of Transaction: Clearly label whether the transaction is a Debit (money out) or Credit (money in).
    • Amount: Enter the exact amount of the transaction.

  • Example:

    DateDescriptionType of TransactionAmount
    01/10/2024Amazon PurchaseDebit500.00
    05/10/2024Salary CreditCredit50,000
    10/10/2024ATM WithdrawalDebit2,000

     Importing the Excel File

    • Save the Excel file in a compatible format (preferably .csv coma delimited).
    • Go with banking section- import bank statement.
    • select Excel or Pdf, If excel mapping date, description, type of transaction and amount.
  •  Navigate to Accounting Vouchers 
           open tally - click on payment and receipt option

  • By following these steps, you can easily import and reconcile thousands of bank transactions within minutes using Tally, making the process fast and efficient.