Scotiabank business account statements to Excel and QuickBooks
Drop in Scotiabank business account PDFs. Each statement is read by a reader built for this layout and checked against the totals the statement prints.
What this layout is checked against
- Opening balance
- Closing balance
- Total deposits and credits
- Total withdrawals and debits
- Number of deposits and credits
- Number of withdrawals and debits
- Page totals
A statement is labelled Reconciled only when every listed control agrees, and that still doesn't mean every row is right. Where the statement prints a running balance, each row's balance is checked too. The certificate lists each control with the printed figure and the figure read.
What is particular about this layout
This layout sometimes prints amounts without trailing zeros (1,500 or 1,234.5). They are read as amounts only inside a dollar column.
Account statements in your books
Export Excel or CSV for your working papers, QBO for QuickBooks Online, or IIF for QuickBooks Desktop. A statement that doesn't reconcile exports marked: _NOT_RECONCILED in the file name, a status column first, and the certificate with it.
Questions
Is this the statement my bank gives me?
It's the PDF statement you download from Scotiabank online banking or receive in the mail, for a business account. The bank's own transaction download (CSV or QuickBooks file) is a different thing and usually covers recent months only.
What if my statement looks different?
Banks change their designs. A statement that doesn't match this layout is refused as an unsupported layout, not read with the nearest match, and it isn't counted against your plan.
What about scanned Scotiabank statements?
For scanned PDFs this layout is Unsupported. We don't read scans of this layout yet.
Can I check a whole year at once?
Yes. Put the year's PDFs in one run. Each statement is checked on its own, and consecutive months for the same account are checked for a gap.
See also: every layout · how the checks work · pricing · catch-up and year-end