Fixing Bank Statement Upload Failures

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 [ Error message: The data you are uploading contains a date that does not match the selected format].
 

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.”
Select the file date column format on the import page which is on the uploaded spreadsheet so the data can be processed accordingly.

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.