Uploading your bank statement is an important step in bank reconciliation. If you’re encountering issues, here are common causes and solutions:

Incorrect Formatting

Problem: The spreadsheet is not formatted correctly.

Solution: Ensure the file is in .xlsx or .csv format. The columns should include: Date, Narration, Debit and Credit, Balance,  and Account Name (if applicable).  Avoid merged cells or hidden rows/columns.

Incorrect Date Format

Problem: The date format is not recognized by the system.

Solution: Use a consistent date format such as DD-MM-YYYY, YYYY-MM-DD, or YYYY/MM/DD. Avoid text-based dates like “12th Jan 2024.”

Extra Spaces in the File

Problem: Blank rows or hidden spaces cause upload errors.

Solution: Remove unnecessary spaces, particularly at the top or bottom of the file. Ensure each row has complete and valid data.

Non-Existent Chart of Accounts

Problem: Transactions are mapped to accounts that don’t exist in Tyms.

Solution: Go to Settings > Chart of Accounts and create any missing accounts. Use account names that match those set up in your Tyms dashboard.

By addressing these common issues, you can ensure a smoother upload process and accurate bank reconciliation.