Convert TBC Bank statements to Excel, CSV or QBO

• Headers and descriptions are bilingual (Georgian with an English line), and each account has its own statement in one currency, identified by a GE IBAN with the TB bank code.

Each statement covers one account in one currency. The account is identified by a Georgian IBAN, which starts with GE and carries the TB bank code. If you have a lari account and a dollar account, you get two statements, and each is converted on its own with its own balance check.

The first page opens with a summary block: Opening Balance, Closing Balance, Total Paid out and Total Paid in, each followed by the currency code. These four numbers are the frame for the whole conversion. The opening balance plus total paid in, minus total paid out, should equal the closing balance, and the rows the converter extracts should add up to the same two totals. When they do not, you see the difference before you export.

Paid Out and Paid In are separate columns and the amounts in them have no minus sign. The converter turns anything in Paid Out into a negative amount and anything in Paid In into a positive one. A running balance is printed on every row, so the check also works line by line: each balance should follow from the one above it and the amount on that row.

Number formatting is plain. Amounts use a dot as the decimal separator and no thousands separator at all, so a payment of one thousand two hundred lari reads 1200.00. Dates are day first with slashes, as in 05/03/2025. That date is 5 March, not 3 May, which is the classic trap when a Georgian statement is opened in a US-format spreadsheet. The export writes ISO dates such as 2025-03-05, which removes the ambiguity.

The Additional Information column sits between the description and the amounts. Whatever your bank put there can matter when you match payments to invoices, so check where it ended up in the export before you delete anything from the sheet.

Georgian text in descriptions is kept as Unicode. Dates, amounts and balances are read the same way whatever language the description is written in, but the synthetic test files used so far contain Latin text only, so a description with unusual characters is worth a glance.

How the layout was learned matters for how much you should trust it. The notes above were derived from structure-only skeletons of real TBC statements, with every name and figure masked, and from synthetic replicas built to match. Four real statements were then converted and passed the balance check, so TBC is marked Verified. Scanned or photographed statements are not supported.

The public TBC help pages do not describe a CSV export for personal accounts, and the exact menu names for downloading a statement are not documented there either. After signing in to the internet bank or mobile bank, look for the statement option in the account view, choose the period and save the PDF.