Convert Bank of Georgia statements to Excel, CSV or QBO

• Credit turnover and Debit turnover rows with one total per currency close the table.
• Business accounts use a different export: a landscape layout stored on a rotated page, with DD.MM.YYYY dates and separate debit and credit columns.

The unusual part of this layout is how money is laid out across the page. Instead of one amount column, the statement has a column for each currency: GEL, USD, EUR and GBP. Every transaction has its figure in exactly one of those columns, and the others stay empty for that row. A payment from a lari account shows up under GEL; a transfer from a dollar balance shows up under USD. The converter reads which column holds the number and treats that as the currency of the row, then groups rows by currency. The result is one sheet or section per currency, so a dollar purchase and a lari salary are never added together.

Signs are carried by the figures themselves. A debit has a minus sign in front of it, and a credit is printed with no sign at all. Numbers use a dot for decimals and a comma for thousands, as in 1,234.56. Dates follow the day, month, year order with slashes. The export writes ISO dates, which spreadsheets and accounting tools read without guessing whether 03/04 means March or April.

There is no running balance after each transaction. What the statement gives instead is a Start Balance row and an End Balance row, each with one figure per currency, and, at the foot of the table, Credit turnover and Debit turnover rows with a total per currency. Those four lines are enough for a solid check. For each currency, the start balance plus all credits minus all debits should equal the end balance, and the credit and debit sums should match the turnover rows. If one currency does not reconcile, the converter tells you which one, so you know where to look.

Business accounts are different. Their export uses a landscape layout stored on a rotated page, with DD.MM.YYYY dates and separate debit and credit columns. Business statements were not part of the real-statement check, so look at the balance result closely on a business file. Business clients can also pull statements through the BOnline statement API, which Bank of Georgia documents publicly.

Descriptions on Bank of Georgia statements may be in Georgian. They are kept as Unicode text in the export, and dates, amounts and balances are read the same way whatever language the description is in. The synthetic test files used so far contain Latin text only, and currency columns beyond GEL, USD, EUR and GBP have not been tested.

The layout was worked out from structure-only skeletons of real statements, where every name and figure was masked, and from synthetic replicas. Five real personal statements were then converted and passed the balance check, which is why Bank of Georgia is marked Verified. A layout change on the bank's side could still break a file, so let the balance check guide you each time. Scanned or photographed statements cannot be read.