Convert your KeyBank statement to Excel, QBO & Xero

A KeyBank Corporate Banking Statement keeps its summary in a box near the top: beginning balance, the Additions total, the Subtractions total, and the ending balance. Those printed figures are what the rows we read have to add up to.

Deposits sit under Additions and count as money in. Withdrawals and Paper Checks sit under Subtractions and count as money out. Paper checks print two or three to a row, so each one is split out with its check number and date; when a scan loses the number, the row is labelled simply Check. Dates print as month-day only, so we take the year from the beginning and ending balance dates.

If the PDF also contains court-filing pages or a different bank's statement, those pages are left unread. Several KeyBank accounts in one PDF are not merged: the file is refused with a note, and each account's pages need to go up as a separate file.

KeyBank's summary box gives the numbers to beat: beginning balance, the Additions total, the Subtractions total and the ending balance. Every row we read is totalled and compared with them. A statement that agrees is marked Balanced, and when it disagrees the exact amount is shown to you ahead of the download.